EHSI CURRENT ASSIGNEE Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ALT_OFFICE_ADDRESS |
Employee's alternate office address, for example W92-101, LL-B 341 |
VARCHAR2 |
40 |
ALT_OFFICE_PHONE |
The employee's alternate site location, ie. E19 |
VARCHAR2 |
15 |
CURRENT_ASSIGNED_ROLE |
XXX |
VARCHAR2 |
30 |
CURRENT_ASSIGNED_ROLE_CODE |
XXX |
VARCHAR2 |
2 |
CURRENT_ASSIGNEE_ID |
XXX |
VARCHAR2 |
10 |
CURRENT_ASSIGNEE_TYPE |
XXX |
VARCHAR2 |
100 |
EHSI_CURRENT_ASSIGNEE_KEY |
XXX |
VARCHAR2 |
15 |
EHSI_ORGANIZATION_NAME |
XXX |
VARCHAR2 |
40 |
EMAIL_ADDRESS |
A person's complete electronic mail address including user name and node name, for example, username@school.edu. |
VARCHAR2 |
100 |
EMPLOYEE_TITLE |
The person's job title, from HR. |
VARCHAR2 |
75 |
FIRST_NAME |
The person's first name. |
VARCHAR2 |
40 |
FULL_NAME |
The full name of the person. |
VARCHAR2 |
100 |
KRB_NAME_UPPERCASE |
The Kerberos username of a person, in uppercase. |
VARCHAR2 |
30 |
LAST_NAME |
The person's last name. |
VARCHAR2 |
40 |
MIDDLE_NAME |
The person's middle name (where available). |
VARCHAR2 |
40 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
OFFICE_ADDRESS |
Employee's primary office address, for example, W92-101, LL-B 341 |
VARCHAR2 |
40 |
OFFICE_PHONE |
The person's primary office telephone number at MIT. |
VARCHAR2 |
15 |
PERSONNEL_AREA |
Definition of PERSONNEL_AREA_CODE; identifies campus groupings of employees; e.g., academic, nonacademic, external, or Lincoln Lab. |
VARCHAR2 |
40 |
PERSONNEL_AREA_CODE |
4 character code to identify employee groups; e.g., academic, nonacademic, external, or Lincoln Lab. |
VARCHAR2 |
4 |
PERSONNEL_SUBAREA |
Text that further identifies the personnel area into sub groupings of Positions,e.g., Admin Staff, Support Staff. Similar to the old Rank Lists values. |
VARCHAR2 |
40 |
PERSONNEL_SUBAREA_CODE |
4 character code to further identify the personnel area, e.g., CFAC for faculty. |
VARCHAR2 |
4 |
PERSON_TYPE |
In the KRB_PERSON and MITID_DB_PERSON tables, PERSON_TYPE is a more specific classification of the type of person: Current employee, Non current employee, Current student, Non current student, Moira account. In the IR AWARD PERSON table, this field identifies whether the person is Faculty, Staff, MIT Alumni, Student, or MIT Corporation member. |
VARCHAR2 |
30 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |