FACILITIES TIME SHEET Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ATTENDENCE_ABSENSE_TYPE |
XXX |
VARCHAR2 |
4 |
CHANGE_DATE |
XXX |
DATE |
|
CREATED_BY |
User account or user name of the person who created the record. |
VARCHAR2 |
12 |
CREATED_ON |
XXX |
DATE |
|
DOCUMENT_NUMBER |
The number in SAP that uniquely identifies a detailed transaction document. |
VARCHAR2 |
10 |
KRB_NAME |
Kerberos Name |
VARCHAR2 |
8 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
PERSONNEL_KEY |
Key field used to join to the PERSONNEL table. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
8 |
QUANTITY_HOURS |
XXX |
NUMBER |
15,3 |
STATUS |
In the GRADUATE APPOINTMENT TYPE table, this field indicates the status of the appointment: whether Cancelled or Actual. In the ALUMNI BY COURSE table, this field carries one of these statuses: "Active", "Lost", "Purgable" regarding the MIT alumnus/alumnae. |
VARCHAR2 |
2 |
UNIT_OF_MEASURE |
XXX |
VARCHAR2 |
3 |
WAREHOUSE_CURRENT_TIMESTAMP |
XXX |
DATE |
|
WORK_DATE |
XXX |
DATE |