NEW HIRE EMPLOYEE Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
COMPLETION_DATE |
The end date. |
DATE |
8 |
COMPLETION_TIME |
XXX |
VARCHAR2 |
6 |
COMPLETION_TIMESTAMP |
XXX |
DATE |
7 |
DLC_KEY |
a unigue key to enable joining information stored with other forms of Department Key |
VARCHAR2 |
15 |
DLC_NAME |
The name of the DLC associated with this room set. |
VARCHAR2 |
50 |
EMAIL_SENT_NUMBER |
XXX |
NUMBER |
22 |
FIRST_ACCESS_DATE |
XXX |
DATE |
7 |
FIRST_ACCESS_TIME |
XXX |
VARCHAR2 |
6 |
FIRST_ACCESS_TIMESTAMP |
XXX |
DATE |
7 |
FULL_NAME |
The full name of the person. |
VARCHAR2 |
90 |
HIRE_DATE |
The date on which the person was last hired. |
DATE |
8 |
HIRE_ENTRY_DATE |
XXX |
DATE |
7 |
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 |
HR_ORG_UNIT_TITLE |
Name of the department, school, center, or lab. (Known as Org Units in SAP.) |
VARCHAR2 |
75 |
KRB_NAME_UPPERCASE |
The Kerberos username of a person, in uppercase. |
VARCHAR2 |
8 |
LAST_ACCESS_DATE |
XXX |
DATE |
7 |
LAST_ACCESS_TIME |
XXX |
VARCHAR2 |
6 |
LAST_ACCESS_TIMESTAMP |
XXX |
DATE |
7 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
NEW_HIRE_EMPLOYEE_KEY |
XXX |
VARCHAR2 |
20 |
NEW_HIRE_PSH_EXPIRE_DATE |
XXX |
DATE |
8 |
NEW_HIRE_REC_EXPIRE_DATE |
XXX |
DATE |
7 |
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 |
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 |
40 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |