ORGENTITY
This table contains information on organizational entities (OrgEntities). An OrgEntity is either an organization or an organization unit. Authorization domains are also stored in this table.
Column Descriptions:
Name Type Description ORGENTITY_ID BIGINT NOT NULL Foreign key to MEMBER table for this organization or organization unit. LEGALID VARCHAR (128) The registered organization identifier, given to the organization (such as assigned by the government). This may be null for an organization unit. This is not the name of the organization, which should be stored in the ORGENTITYNAME table. ORGENTITYTYPE CHAR (3) NOT NULL Type of OrgEntity. Valid values are as follows:
O = organization
OU = organization unit
AD = authorization domain (does not replicate to LDAP)
ORGENTITYNAME VARCHAR (128) NOT NULL Short name for organization ( O) or organization unit ( OU). Not null is a requirement since it will be mapped to O or OU which are required attributes in LDAP. BUSINESSCATEGORY VARCHAR (128) The business category, which describes the kind of business performed by an OrgEntity. DESCRIPTION VARCHAR (512) A description of the OrgEntity. ADMINFIRSTNAME VARCHAR (128) First name of the administrator of this OrgEntity. ADMINLASTNAME VARCHAR (128) Last name of the administrator of this OrgEntity. ADMINMIDDLENAME VARCHAR (128) Middle name of the administrator of this OrgEntity. PREFERREDDELIVERY VARCHAR (1000) Preferred delivery method. FIELD1 VARCHAR (64) Customizable. FIELD2 VARCHAR (64) Customizable. TAXPAYERID VARCHAR (254) A string used to identify the OrgEntity for taxation purpose. Addition of this column triggered by Taxware integration, but presumably this column is useful even outside of Taxware. DN VARCHAR (1000) Distinguished name (DN) of the OrgEntity. If LDAP is used, contains the DN of the OrgEntity in the LDAP server. If database is used as member repository, contains a unique name as defined by the membership hierarchy. DNs for all OrgEntities are logically unique, however due to the large field size, this constraint is not enforced at the physical level. The DN should not contain any spaces before or after the comma (,) or equals sign (=) and must be entered in lowercase. FIELD3 VARCHAR (64) Customizable. STATUS INTEGER NOT NULL DEFAULT 0 The STATUS column in ORGENTITY table indicates whether or not the organization is locked. Valid values are as follows:
0 = not locked
-1 = lockedOPTCOUNTER SMALLINT NOT NULL DEFAULT 0 The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.
Indexes:
Name Column Names Type <SYSTEM-GENERATED> ORGENTITY_ID Primary Key I0000970 DN Non-Unique Index
Constrained By Parent Tables:
Constraint Columns Parent Table Parent Columns Type F_555 ORGENTITY_ID MEMBER MEMBER_ID Cascade
Referenced By Child Tables:
Constraint Columns Child Table Child Columns Type F_1013 ORGENTITY_ID ACPLGPSUBS ORGENTITY_ID Cascade F_1162 ORGENTITY_ID CCOMMENT AUTHDOMAIN Cascade F_1214 ORGENTITY_ID ROLEASNPRM ORGENTITY_ID Cascade F_132 ORGENTITY_ID BUSPROF ORG_ID Cascade F_133 ORGENTITY_ID BUSPROF ORGUNIT_ID Cascade F_142 ORGENTITY_ID BUYSUPMAP BUYORGUNIT_ID Cascade F_143 ORGENTITY_ID BUYSUPMAP SUPORG_ID Cascade F_144 ORGENTITY_ID BUYSUPSEC SUPORG_ID Cascade F_145 ORGENTITY_ID BUYSUPSEC BUYORG_ID Cascade F_326 ORGENTITY_ID FLOWADMIN ORGENTITY_ID Cascade F_452 ORGENTITY_ID MBRROLE ORGENTITY_ID Cascade F_513 ORGENTITY_ID ORDERS ORGENTITY_ID Cascade F_553 ORGENTITY_ID ORGCODE ORGENTITY_ID Cascade F_615 ORGENTITY_ID PROCBUYPRF ORGENTITY_ID Cascade F_617 ORGENTITY_ID PROCMSGVW ORGENTITY_ID Cascade F_694 ORGENTITY_ID RMA ORGENTITY_ID Cascade
Related reference
Access control data model
Member data model
Messaging extension data model
Order data model
Order management - RMA data model
Procurement data model
Authentication data model