The ARF_IU_ORG table stores data about internal organizations.
Column Name | Type | Length | Null Allowed | Description |
---|---|---|---|---|
ID | varchar | 40 | No | Identifier; primary key. |
ORG_ID | varchar | 40 | No | |
NAME_EN | varchar | 40 | No | Name of the organization in English. |
DESCRIPTION_EN | varchar | 254 | Yes | Description of the organization in English. |
PARENT_ORG_ID | varchar | 40 | Yes | Identifier of the parent organization, if applicable. Foreign key to the ID column of this table. |
DIR_LVL_ID | varchar | 40 | No | Identifies the level of this organization. Foreign key to the ID column of the ARF_IU_DIR_LVL column. |
LAST_UPDATED | timestamp | No | Date this record was last updated | |
DELETED | numeric | 1 | No | Whether this record indicates deleted organization. |