FCLT ORGANIZATION Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ASSIGNABLE |
XXX |
VARCHAR2 |
4 |
COURSE |
The major program (eg. "6 2", "15 M", "18 D") in which the student is enrolled in for the current term. |
VARCHAR2 |
16 |
DESCRIPTION |
the description |
VARCHAR2 |
250 |
DLC_KEY |
a unigue key to enable joining information stored with other forms of Department Key |
VARCHAR2 |
180 |
DLC_NAME |
The name of the DLC associated with this room set. |
VARCHAR2 |
840 |
FCLT_MAJOR_ORG_KEY |
XXX |
VARCHAR2 |
16 |
FCLT_ORGANIZATION_KEY |
XXX |
VARCHAR2 |
16 |
FCLT_ORG_PARENT_KEY |
XXX |
VARCHAR2 |
16 |
HR_DEPARTMENT_CODE_OLD |
Prior department number |
VARCHAR2 |
6 |
HR_DEPARTMENT_NAME |
Name of the department, school, center, or lab. |
VARCHAR2 |
75 |
HR_ORG_UNIT_ID |
8-digit unique number generated by SAP for each org unit. All levels within the HR org hierarcy (e.g. school, department, sub-department) are assigned an HR Org Unit ID. |
VARCHAR2 |
8 |
MAJOR_ORG |
XXX |
VARCHAR2 |
32 |
ORGANIZATION |
XXX |
VARCHAR2 |
32 |
ORGANIZATION_ID |
The department, for example, Accounting. |
VARCHAR2 |
16 |
ORGANIZATION_LEVEL |
XXX |
VARCHAR2 |
4 |
ORGANIZATION_NAME |
The name of the MIT Department or Unit to which the project is assigned, usually the home unit or the Principal Investigator or Co-Investigator. |
VARCHAR2 |
64 |
ORGANIZATION_NUMBER |
First four digits of the department number associated with the credit card. |
VARCHAR2 |
16 |
ORGANIZATION_SORT |
XXX |
VARCHAR2 |
16 |
ORG_PARENT |
XXX |
VARCHAR2 |
32 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |