Skip to main content

Organization Structure

Data Dictionary - Entity Table: Organization_Structure#

This table helps defining the hierarchical structure of your Organization.
The purpose of the Organizational Structure is to: • Provide a dedicated framework which will map the responsibilities of a bank employee in internal bank processes to the data of the logged-in user. Such mapping extends not only to individual employees but to the entire organization of departments and teams. • Derive security based on the organizational structure without additional need for customization. • Use the organizational structure to provide reports for every organizational entity in the bank.

Primary Key ('id').ENGINE = InnoDB..
Column NameData TypePK Primary Key, NN-Not Null, NullExampleComments
idBIGINT(12)PK, NN1PrimaryKey-ID, Not Null (auto creates)
ParentBIGINT(12)NULL1Parent organizational entity structure
ChildBIGINT(12)NULL4Child organisational entity
LevelINTNULL2Level of ogranizational unit
ParentOE(Parent)Organizational_Entity (id)NO ACTIONNO ACTION
ChildOE(Child)Organizational_Entity (id)NO ACTIONNO ACTION
Parent_idxOrganization_Structure(Parent ASC)VISIBLE.
Child_idxOrganization_Structure(Child ASC)VISIBLE.