Base View idvBusinessInvolvement

Description

This view exposes the rows in the database table that represent the involvement of people or businesses in other businesses (employed by, director secretary and so on).

 

For use by

Base view suitable for advanced end users.

 

Columns

BusinessInternalId

Internal identifier of the involving business

InvolvedObjectType

Object type of the involved person or organisation

InvolvedInternalId

Internal identifier of the involved person or organisation

InternalId

Unique internal identifier of the involvement

InvolvementType

Type of involvement

  • EMP = Employment

  • SEC = Company seceretary

  • DIR = Director

  • PAR = Partner (normal partnership)

  • TRD = Trader (= running sole trade)

  • TST = Trustee (of charity)

  • MEM = Member (of LLP)

  • DES = Designated member (of LLP)

  • OTH = Not specifically specified

 

 

InvolvementStarts

Date involvement started

InvolvementEnds

Date involvement ended

CorporateRepObjectType

Object type of any corporate representative (for a corproate involvement)

CorporateRepInternalId

Internal identifier of any corporate representative (for a corproate involvement)

Occupation

Involved party's occupation

EmployerRef

Employer reference

MemberRef

Member reference (for LLPs)

 

This view is directly inherited by the following views: