Skip to main content

Organizational Entity

Data Dictionary - Entity Table: Organizational_Entity#

The teams/divisions of the organization are represented as Organizational entities. They relate to individuals and other organizations (Person) via the business relationships (Business Partner) and job responisbilities (Employee)

Primary Key ('id').ENGINE = InnoDB..
Column NameData TypePK Primary Key, NN-Not Null, NullExampleComments
idBIGINT(12)PK, NN12PrimaryKey-ID, Not Null (auto creates)
NameVARCHAR(45)NULLSwitzerland Subsidiary;Wealth Advisory;Discretionary; DPM UHNWI (discretionary portfolio management of ultra-high-net-worth individuals) departmentName of the organizational entity (team, division, subsidiary)
Internal_referenceVARCHAR(45)NULLTeam BEnter an Internal Reference