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:

NameTypeDescription
ORGENTITY_IDBIGINT NOT NULLForeign key to MEMBER table for this organization or organization unit.
LEGALIDVARCHAR (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.
ORGENTITYTYPECHAR (3) NOT NULLType of OrgEntity. Valid values are as follows: O = organization OU = organization unit AD = authorization domain (does not replicate to LDAP)
ORGENTITYNAMEVARCHAR (128) NOT NULLShort 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.
BUSINESSCATEGORYVARCHAR (128)The business category, which describes the kind of business performed by an OrgEntity.
DESCRIPTIONVARCHAR (512)A description of the OrgEntity.
ADMINFIRSTNAMEVARCHAR (128)First name of the administrator of this OrgEntity.
ADMINLASTNAMEVARCHAR (128)Last name of the administrator of this OrgEntity.
ADMINMIDDLENAMEVARCHAR (128)Middle name of the administrator of this OrgEntity.
PREFERREDDELIVERYVARCHAR (1000)Preferred delivery method.
FIELD1VARCHAR (64)Customizable.
FIELD2VARCHAR (64)Customizable.
TAXPAYERIDVARCHAR (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.
DNVARCHAR (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.
FIELD3VARCHAR (64)Customizable.
STATUSINTEGER NOT NULL DEFAULT 0The STATUS column in ORGENTITY table indicates whether or not the organization is locked. Valid values are as follows: 0 = not locked -1 = locked
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>ORGENTITY_IDPrimary Key
I0000970DNNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_555ORGENTITY_IDMEMBERMEMBER_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_1013ORGENTITY_IDACPLGPSUBSORGENTITY_IDCascade
F_1162ORGENTITY_IDCCOMMENTAUTHDOMAINCascade
F_1214ORGENTITY_IDROLEASNPRMORGENTITY_IDCascade
F_132ORGENTITY_IDBUSPROFORG_IDCascade
F_133ORGENTITY_IDBUSPROFORGUNIT_IDCascade
F_142ORGENTITY_IDBUYSUPMAPBUYORGUNIT_IDCascade
F_143ORGENTITY_IDBUYSUPMAPSUPORG_IDCascade
F_144ORGENTITY_IDBUYSUPSECSUPORG_IDCascade
F_145ORGENTITY_IDBUYSUPSECBUYORG_IDCascade
F_326ORGENTITY_IDFLOWADMINORGENTITY_IDCascade
F_452ORGENTITY_IDMBRROLEORGENTITY_IDCascade
F_513ORGENTITY_IDORDERSORGENTITY_IDCascade
F_553ORGENTITY_IDORGCODEORGENTITY_IDCascade
F_615ORGENTITY_IDPROCBUYPRFORGENTITY_IDCascade
F_617ORGENTITY_IDPROCMSGVWORGENTITY_IDCascade
F_694ORGENTITY_IDRMAORGENTITY_IDCascade