PENSION PERSON Table
SAP HR Pension Person data
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AGE |
*** In HR tables, this field contains the person's age in years as calculated by the HR System's Age Calculating Device. *** In STUDENT tables, this field contains the age of the person. |
NUMBER |
3 |
AGE_BY_FISCAL_YEAR |
The person's age as of June 30, the end of the fiscal year, as calculated by the HR System's aforementioned Device. For example, a person's FY2000 age is the person's age on June 30, 2000. |
NUMBER |
3 |
COUNTRY_OF_CITIZENSHIP |
The country where the person has citizenship. |
VARCHAR2 |
30 |
COUNTRY_OF_CITIZENSHIP_CODE |
The country where the person has citizenship. |
VARCHAR2 |
3 |
DATE_OF_BIRTH |
The person's date of birth. |
DATE |
8 |
ELIGIBILITY_END_DATE |
Expiration (end) date of the employee's benefits eligibility. |
DATE |
8 |
ELIGIBILITY_START_DATE |
Effective (start) date of the employee's benefits eligibility. |
DATE |
8 |
ELIG_PROGRAM_GROUP_1 |
XXX |
VARCHAR2 |
30 |
ELIG_PROGRAM_GROUP_1_CODE |
XXX |
VARCHAR2 |
4 |
ELIG_PROGRAM_GROUP_2 |
XXX |
VARCHAR2 |
30 |
ELIG_PROGRAM_GROUP_2_CODE |
XXX |
VARCHAR2 |
4 |
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 |
FIRST_NAME |
The person's first name. |
VARCHAR2 |
30 |
FIRST_NAME_UPPER |
The uppercase version of the employee's first name. Convenient for placing limits. |
VARCHAR2 |
40 |
FORM_OF_ADDRESS_LONG |
The long form of the honorific used to address the person, e.g., Doctor, Mr, Ms, Professor, Sir |
VARCHAR2 |
15 |
FORM_OF_ADDRESS_SHORT |
The short form of the honorific used to address the person, e.g., Dr.,Mr., Prof., Sir |
VARCHAR2 |
5 |
FULL_NAME |
The full name of the person. |
VARCHAR2 |
90 |
FULL_NAME_UPPERCASE |
The full name of the person. This is all uppercase, in the format "LAST-NAME, FIRST-NAME OPTIONAL-MIDDLE-NAME |
VARCHAR2 |
100 |
GENDER |
The person's gender. |
VARCHAR2 |
30 |
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 |
INCLUDE_HOME_ADDR_IN_DIR |
XXX |
VARCHAR2 |
1 |
IS_DISABLED |
Obsolete field. Contains "N" in all records |
VARCHAR2 |
5 |
IS_NEWLY_SEPARATED_VETERAN |
An indicator that the person is a newly separated veteran (Y or N). |
VARCHAR2 |
1 |
IS_OTHER_VETERAN |
An indicator that the person is a veteran, not from Vietnam (Y or N). |
VARCHAR2 |
1 |
IS_SPECIAL_DISABLED_VETERAN |
An indicator tha the person is a special disabled veteran (Y or N). |
VARCHAR2 |
1 |
IS_VIETNAM_VETERAN |
An indicator that the person is a Vietnam veteran (Y or N) |
VARCHAR2 |
1 |
KRB_NAME_UPPERCASE |
The Kerberos username of a person, in uppercase. |
VARCHAR2 |
8 |
LAST_ESS_ACCESS_DATE |
XXX |
DATE |
8 |
LAST_NAME |
The person's last name. |
VARCHAR2 |
30 |
LAST_NAME_UPPER |
The uppercase version of the employee's last name. Convenient for placing limits. |
VARCHAR2 |
40 |
MIDDLE_INITIAL |
XXX |
VARCHAR2 |
1 |
MIDDLE_NAME |
The person's middle name (where available). |
VARCHAR2 |
30 |
MILITARY_STATUS |
XXX |
VARCHAR2 |
30 |
MILITARY_STATUS_CODE |
XXX |
VARCHAR2 |
2 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
NAME_KNOWN_BY |
Nickname |
VARCHAR2 |
30 |
NAME_PREFIX |
Name prefix |
VARCHAR2 |
15 |
NAME_SUFFIX |
Contains suffixes that may be appended to the last name, examples include: Jr., Sr., II, III, IV, etc. It is not used for honorifics such as "MD, Esq, PhD" etc. |
VARCHAR2 |
15 |
PERSONAL_URL |
The employee's personal URL. |
VARCHAR2 |
241 |
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 |
PRIOR_LAST_NAME |
Previous last name |
VARCHAR2 |
40 |
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 |
SALUTATION |
In HR tables, this field is used for salary review letters only, a person's salutation may appear as Mary, Fred, etc. In ALUMNI tables, this field contains the salutation of the alumnus/alumnae, eg. "The Rev MacCormick", "Dr Smith", "Ms Wood", "Prof Walker", "Mary Jones". |
VARCHAR2 |
30 |
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 |
SIGNATURE_NAME |
XXX |
VARCHAR2 |
80 |
SOCIAL_SECURITY_NUMBER |
The person's Social Security Number |
VARCHAR2 |
15 |
SUBSCRIBER_ASSOC_PERSONNEL_KEY |
XXX |
VARCHAR2 |
32 |
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 |