FAC ORGANIZATION Table
Facilities Organization Info
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ASSIGNABLE |
XXX |
VARCHAR2 |
2 |
COURSE |
The major program (eg. "6 2", "15 M", "18 D") in which the student is enrolled in for the current term. |
VARCHAR2 |
9 |
DESCRIPTION |
the description |
VARCHAR2 |
2000 |
HR_DEPARTMENT_CODE_OLD |
Prior department number |
VARCHAR2 |
6 |
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 |
MAJOR_ORG_ID |
XXX |
VARCHAR2 |
16 |
ORGANIZATION |
XXX |
VARCHAR2 |
75 |
ORGANIZATION_ID |
The department, for example, Accounting. |
VARCHAR2 |
6 |
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 |
40 |
ORGANIZATION_NUMBER |
First four digits of the department number associated with the credit card. |
VARCHAR2 |
4 |
ORGANIZATION_SORT |
XXX |
VARCHAR2 |
16 |
ORG_PARENT |
XXX |
VARCHAR2 |
32 |
ORG_PARENT_ID |
XXX |
VARCHAR2 |
16 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |