PAYROLL PERSON FULL Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADMIN_JOB_TITLE |
The title of the job of the administrative appointment |
VARCHAR2 |
40 |
ADMIN_ORG_UNIT_ID |
The SAP 8-digit object id assigned to the employee's administrative org unit. |
VARCHAR2 |
8 |
ADMIN_ORG_UNIT_TITLE |
The title of employee's administrative org unit. |
VARCHAR2 |
75 |
ADMIN_POSITION_TITLE |
The title of the position of the administrative appointment |
VARCHAR2 |
50 |
CASE_VERIFICATION_NUMBER |
XXX |
VARCHAR2 |
20 |
COMPANY_CODE |
Shows to which "company" in SAP a cost collector is attached. MIT uses separate "companies" in SAP to differentiate financial transactions for different legal entities with differing business rules or reporting requirements. There are currently three company codes, "CUR" for main campus, "TECR" for MIT's alumni magazine, Technology Review, and "LCP1" for Lincoln Laboratory. |
VARCHAR2 |
4 |
CONTRACT_CODE |
XXX |
VARCHAR2 |
2 |
CONTRACT_DESCRIPTION |
XXX |
VARCHAR2 |
20 |
COUNTRY_OF_CITIZENSHIP |
The country where the person has citizenship. |
VARCHAR2 |
30 |
DATE_OF_BIRTH |
The person's date of birth. |
DATE |
8 |
EMAIL_ADDRESS |
A person's complete electronic mail address including user name and node name, for example, username@school.edu. |
VARCHAR2 |
60 |
EMPLOYEE_GROUP |
Definition of EMPLOYEE_GROUP_CODE, identifying an employee grouping, e.g., Exempt, Non-Exempt, or External |
VARCHAR2 |
30 |
EMPLOYEE_GROUP_CODE |
Code identifying an employee grouping: E for Exempt, N for Non-Exempt, X for External. |
VARCHAR2 |
1 |
EMPLOYEE_SUBGROUP |
Further classifies employee into classified, monthly, or weekly paid. |
VARCHAR2 |
30 |
EMPLOYEE_SUBGROUP_CODE |
Further classifies employee group into classified, monthly, or weekly paid, EM for exempt monthly. |
VARCHAR2 |
2 |
EMPLOYMENT_STATUS |
Identifies the most recent status of an employee, eg, Active, Leave, Retiree, Terminated, Deceased. NOTE: In cases where an employee was terminated on their student appoinment, use IS_FORMER_EMP_CURRENT_STU and/or APPOINTMENT_END_DATE to determine if they are still active. Employees that become students are not always terminated in SAP on their Employee record. |
VARCHAR2 |
30 |
EMPLOYMENT_STATUS_CODE |
Code to identify the status. |
VARCHAR2 |
1 |
FIRST_NAME |
The person's first name. |
VARCHAR2 |
30 |
FULL_NAME |
The full name of the person. |
VARCHAR2 |
90 |
GENDER |
The person's gender. |
VARCHAR2 |
30 |
GENDER_CODE |
Gender code. |
VARCHAR2 |
1 |
HOME_ADDR_CARE_OF |
"Care of" in the person's home address |
VARCHAR2 |
40 |
HOME_ADDR_CITY |
The city of the person's home address. |
VARCHAR2 |
40 |
HOME_ADDR_COUNTRY |
The country of the person's home address. |
VARCHAR2 |
30 |
HOME_ADDR_STATE |
The U.S. state code of the student's home address. |
VARCHAR2 |
2 |
HOME_ADDR_STREET1 |
Home address, street line 1. |
VARCHAR2 |
60 |
HOME_ADDR_STREET2 |
Home address, street line 2. |
VARCHAR2 |
40 |
HOME_ADDR_ZIP |
Zip code in home address |
VARCHAR2 |
10 |
HOME_PHONE |
The person's home telephone number. |
VARCHAR2 |
20 |
I9_FORM_LOCATION |
XXX |
VARCHAR2 |
30 |
I9_FORM_LOCATION_CODE |
XXX |
VARCHAR2 |
1 |
IS_CURRENTLY_EMPLOYED_STUDENT |
A flag, Y or N, to indicate whether the employee is currently registered as a student. |
VARCHAR2 |
1 |
IS_SECOND_PERNR |
A flag, Y or N, to indicate whether the personnel key is a second personnel key for the person. |
VARCHAR2 |
1 |
IS_STUDENT |
In the STUDENT and STUDENT_ALL table, this flag indicates whether the person has ever been a student at MIT. In the WTW_INSTRUCTOR and WTW_OLD_INSTRUCTOR tables, this flag indicates whether this instructor was a current student, Y or N, for the specific term. In Payroll Person, indicates whether the person is currently a student, Y or N (i.e., the person may or may not have been a student in a past payroll period). |
VARCHAR2 |
1 |
KRB_NAME_UPPERCASE |
The Kerberos username of a person, in uppercase. |
VARCHAR2 |
8 |
LAST_NAME |
The person's last name. |
VARCHAR2 |
30 |
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 |
20 |
PAYROLL_AREA |
A field indicating whether the person is monthly paid, weekly, paid, non-paid or terminated |
VARCHAR2 |
30 |
PAYROLL_AREA_CODE |
ZM for monthly paid, ZW for weekly paid, ZB for retired, ZN for non-paid or ZT for terminated |
VARCHAR2 |
2 |
PERSONNEL_AREA |
Definition of PERSONNEL_AREA_CODE; identifies campus groupings of employees; e.g., academic, nonacademic, external, or Lincoln Lab. |
VARCHAR2 |
30 |
PERSONNEL_AREA_CODE |
4 character code to identify employee groups; e.g., academic, nonacademic, external, or Lincoln Lab. |
VARCHAR2 |
4 |
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 |
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 |
30 |
PERSONNEL_SUBAREA_CODE |
4 character code to further identify the personnel area, e.g., CFAC for faculty. |
VARCHAR2 |
4 |
RECORD_COUNTER |
Used to count records within a group on a report. Always contains a value of 1. |
NUMBER |
1 |
RESIDENCY_STATUS |
Shows the person's residency status - e.g., citizen,non-citizen permanent resident, non-resident. |
VARCHAR2 |
30 |
RESIDENCY_STATUS_CODE |
A one character cod indicating the person's residency status. |
VARCHAR2 |
1 |
SAP_STATUS |
Identifies the status within SAP, active for people being paid, withdrawn from ex-employees and ex-people (deceased). NOTE: In cases where an employee was terminated on their student appoinment, use IS_FORMER_EMP_CURRENT_STU and/or APPOINTMENT_END_DATE to determine if they are still active. Employees that become students are not always terminated in SAP on their Employee record. |
VARCHAR2 |
30 |
SAP_STATUS_CODE |
Number assignment to SAP status. |
VARCHAR2 |
1 |
SOCIAL_SECURITY_NUMBER |
The person's Social Security Number |
VARCHAR2 |
15 |
VISA_EXPIRATION_DATE |
The expiration date of the person's visa. |
DATE |
8 |
VISA_ISSUE_DATE |
Date the visa was issued. |
DATE |
8 |
VISA_TYPE |
A description of the type of visa a person holds. |
VARCHAR2 |
30 |
VISA_TYPE_CODE |
The code relating to Visa Type. |
VARCHAR2 |
4 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |