FAC ORGANIZATION Table
View exposing facilities organization reference data including organization identifiers, parent and major-organization relationships, sort attributes, assignable indicator, course, description, and HR department mappings.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ASSIGNABLE |
Assignable associated with the record. |
VARCHAR2 |
4 |
COURSE |
Course associated with the record. |
VARCHAR2 |
16 |
DESCRIPTION |
Description associated with the record. |
VARCHAR2 |
250 |
HR_DEPARTMENT_CODE_OLD |
Hr department code old associated with the record. |
VARCHAR2 |
6 |
HR_ORG_UNIT_ID |
Business identifier for the hr org unit. |
VARCHAR2 |
8 |
MAJOR_ORG |
Major org associated with the record. |
VARCHAR2 |
32 |
ORGANIZATION |
Organization associated with the record. |
VARCHAR2 |
32 |
ORGANIZATION_ID |
Business identifier for the organization. |
VARCHAR2 |
16 |
ORGANIZATION_LEVEL |
Organization level associated with the record. |
VARCHAR2 |
4 |
ORGANIZATION_NAME |
Organization name associated with the record. |
VARCHAR2 |
64 |
ORGANIZATION_NUMBER |
Organization number associated with the record. |
VARCHAR2 |
16 |
ORGANIZATION_SORT |
Organization sort associated with the record. |
VARCHAR2 |
16 |
ORG_PARENT |
Org parent associated with the record. |
VARCHAR2 |
32 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |