FCLT ORGANIZATION Table
View exposing facilities organization reference data including organizational assignments associated with facilities space management.
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 |
DLC_KEY |
Surrogate key identifying the dlc. |
VARCHAR2 |
180 |
DLC_NAME |
Dlc name associated with the record. |
VARCHAR2 |
840 |
FCLT_MAJOR_ORG_KEY |
Surrogate key identifying the fclt major org. |
VARCHAR2 |
16 |
FCLT_ORGANIZATION_KEY |
Surrogate key identifying the fclt organization. |
VARCHAR2 |
16 |
FCLT_ORG_PARENT_KEY |
Surrogate key identifying the fclt org parent. |
VARCHAR2 |
16 |
HR_DEPARTMENT_CODE_OLD |
Hr department code old associated with the record. |
VARCHAR2 |
6 |
HR_DEPARTMENT_NAME |
Hr department name associated with the record. |
VARCHAR2 |
75 |
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 |