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 | 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 |