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 = locked
OPTCOUNTER	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