Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse 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 current status of an employee, eg, Active, Leave, Retiree, Terminated, Deceased.

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).

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