This table contains information on organizational entities (OrgEntities). An OrgEntity is either an organization or an organization unit.
Column Descriptions
| Column Name
| Column 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
|
| 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 unique.
|
| 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
| Reserved for IBM internal use.
|