Data Warehouse

AAP_PLAN_YEAR

Affirmative Action Plan (AAP) plan year associated with the demographic record.

VARCHAR2

4

AAP_UNIT

Full name of the AAP organizational unit.

VARCHAR2

80

AAP_UNIT_ID

Identifier for the AAP organizational unit.

VARCHAR2

8

AAP_UNIT_SHORT_NAME

Short name of the AAP organizational unit.

VARCHAR2

15

ADJUSTED_SERVICE_DATE

Adjusted service date used for benefits or tenure calculations.

DATE

ADMIN_EMPLOYEE_TYPE

Administrative employee type classification.

VARCHAR2

40

ADMIN_JOB_ID

Administrative job identifier.

VARCHAR2

8

ADMIN_JOB_TITLE

Administrative job title.

VARCHAR2

40

ADMIN_ORG_UNIT_ID

Administrative organizational unit identifier.

VARCHAR2

8

ADMIN_ORG_UNIT_TITLE

Administrative organizational unit title.

VARCHAR2

75

ADMIN_POSITION_ID

Administrative position identifier.

VARCHAR2

8

ADMIN_POSITION_TITLE

Administrative position title.

VARCHAR2

50

AGE

Age of the individual at the time of record generation.

NUMBER

4

AGE_BY_FISCAL_YEAR

Age of the individual calculated as of the fiscal year.

NUMBER

4

APPOINTMENT_END_DATE

Appointment end date for the individual?s position.

DATE

DATE_OF_BIRTH

Date of birth of the individual.

DATE

DATE_OF_DEATH

Date of death of the individual, if applicable.

DATE

EEO_CATEGORY

Equal Employment Opportunity (EEO) category description.

VARCHAR2

30

EEO_CATEGORY_CODE

Equal Employment Opportunity (EEO) category code.

VARCHAR2

3

EMPLOYMENT_STATUS

Employment status description associated with the individual.

VARCHAR2

40

EMPLOYMENT_STATUS_CODE

Employment status code associated with the individual.

VARCHAR2

1

ETHNIC_ORIGIN_INTERNAL

Internal ethnic origin classification used for reporting.

VARCHAR2

100

ETHNIC_ORIGIN_INTERNAL_CODE

Internal code representing ethnic origin classification.

VARCHAR2

2

FIRST_NAME

First name of the individual.

VARCHAR2

40

FULL_NAME

Full name of the individual.

VARCHAR2

100

GENDER

Gender identity of the individual as reported.

VARCHAR2

15

HOME_ADDR_CITY

City of the individual?s home address.

VARCHAR2

40

HOME_ADDR_COUNTRY

Country of the individual?s home address.

VARCHAR2

20

HOME_ADDR_STATE

State or province of the individual?s home address.

VARCHAR2

3

HOME_ADDR_STREET1

Primary street address of the individual?s home residence.

VARCHAR2

60

HOME_ADDR_STREET2

Secondary street address of the individual?s home residence.

VARCHAR2

40

HOME_ADDR_ZIP

Postal code of the individual?s home address.

VARCHAR2

10

HR_ORG_UNIT_TITLE

Title of the HR organizational unit associated with the employee.

VARCHAR2

75

IS_ACTIVE_WAR_CAMPGN_BADGE_VET

Indicator identifying active war campaign badge veteran status (Y/N).

VARCHAR2

1

IS_AF_SERVICE_MEDAL_VETERAN

Indicator identifying Armed Forces service medal veteran status (Y/N).

VARCHAR2

1

IS_AMERICAN_INDIAN_OR_ALASKAN

Indicator identifying American Indian or Alaskan Native race (Y/N).

VARCHAR2

1

IS_ASIAN

Indicator identifying Asian race (Y/N).

VARCHAR2

1

IS_BLACK_OR_AFRICAN_AMERICAN

Indicator identifying Black or African American race (Y/N).

VARCHAR2

1

IS_CURRENTLY_PAID

Indicator identifying whether the individual is currently receiving pay (Y/N).

VARCHAR2

1

IS_DISABLED

Indicator identifying whether the individual has a disability on record (Y/N).

VARCHAR2

1

IS_DISABLED_VETERAN

Indicator identifying disabled veteran status (Y/N).

VARCHAR2

1

IS_HISPANIC_OR_LATINO

Indicator identifying Hispanic or Latino ethnicity (Y/N).

VARCHAR2

1

IS_MORE_THAN_ONE_RACE_REPORTED

Indicator identifying reporting of more than one race (Y/N).

VARCHAR2

1

IS_NATIVE_HAWAIIAN

Indicator identifying Native Hawaiian or Other Pacific Islander race (Y/N).

VARCHAR2

1

IS_NEWLY_SEPARATED_VETERAN

Indicator identifying newly separated veteran status (Y/N).

VARCHAR2

1

IS_NOT_A_VETERAN

Indicator identifying non-veteran status (Y/N).

VARCHAR2

1

IS_NO_ETHNICITY_ON_RECORD

Indicator identifying absence of ethnicity information on record (Y/N).

VARCHAR2

1

IS_NO_RACE_ON_RECORD

Indicator identifying absence of race information on record (Y/N).

VARCHAR2

1

IS_NO_VETERAN_INFO_ON_RECORD

Indicator identifying absence of veteran information on record (Y/N).

VARCHAR2

1

IS_OTHER

Indicator identifying other race category (Y/N).

VARCHAR2

1

IS_PROTECTED_VET_NOT_SELF_ID

Indicator identifying protected veteran status not self-identified (Y/N).

VARCHAR2

1

IS_RECENTLY_SEPARATED_VETERAN

Indicator identifying recently separated veteran status (Y/N).

VARCHAR2

1

IS_SPECIAL_DISABLED_VETERAN

Indicator identifying special disabled veteran status (Y/N).

VARCHAR2

1

IS_UNPROTECTED_VETERAN

Indicator identifying unprotected veteran status (Y/N).

VARCHAR2

1

IS_VIETNAM_VETERAN

Indicator identifying whether the individual is a Vietnam-era veteran (Y/N).

VARCHAR2

1

IS_WHITE

Indicator identifying White race (Y/N).

VARCHAR2

1

JOB_GROUP_CODE

Job group code used for AAP and diversity reporting.

VARCHAR2

2

JOB_GROUP_DESCRIPTION

Description of the job group used for AAP and diversity reporting.

VARCHAR2

30

JOB_ID

Job identifier associated with the individual?s position.

VARCHAR2

8

JOB_TITLE

Job title associated with the individual.

VARCHAR2

40

KRB_NAME_UPPERCASE

Kerberos username of the individual, stored in uppercase.

VARCHAR2

30

LAST_NAME

Last name of the individual.

VARCHAR2

40

LAST_TERM_DATE

Last termination date of employment, if applicable.

DATE

MIDDLE_NAME

Middle name of the individual.

VARCHAR2

40

MIT_ID

MIT ID number of the individual. Use this field to join with other tables containing data about people at MIT.

VARCHAR2

9

MIT_JOB_CODE

MIT-specific job code associated with the individual.

VARCHAR2

12

NAME_KNOWN_BY

Preferred name by which the individual is known.

VARCHAR2

40

NAME_PREFIX

Name prefix of the individual (e.g., Mr., Ms., Dr.).

VARCHAR2

15

OCCUPATION_GROUP

Occupation group description used for classification and reporting.

VARCHAR2

100

OCCUPATION_GROUP_CODE

Occupation group code used for classification and reporting.

VARCHAR2

4

ORG_UNIT_ID

Organizational unit identifier associated with the employee.

VARCHAR2

8

ORIGINAL_HIRE_DATE

Original hire date of the individual at MIT.

DATE

PAY_GRADE

Pay grade associated with the individual?s position.

VARCHAR2

20

PERSONNEL_AREA

Personnel area description associated with the individual.

VARCHAR2

40

PERSONNEL_AREA_CODE

Personnel area code associated with the individual.

VARCHAR2

4

PERSONNEL_KEY

Surrogate key identifying the personnel record.

VARCHAR2

8

PERSONNEL_SUBAREA

Personnel subarea description associated with the individual.

VARCHAR2

40

PERSONNEL_SUBAREA_CODE

Personnel subarea code associated with the individual.

VARCHAR2

4

PRIOR_LAST_NAME

Prior or former last name of the individual, if applicable.

VARCHAR2

40

RACE_ETHNICITY_CODE

Code representing the individual?s race or ethnicity.

VARCHAR2

5

RACE_ETHNICITY_DESCR

Description of the individual?s race or ethnicity.

VARCHAR2

100

RESIDENCY_STATUS

Residency or citizenship status of the individual.

VARCHAR2

30

RETIREMENT_DATE

Retirement date of the individual, if applicable.

DATE

WAREHOUSE_CLUSTER

Data warehouse cluster description used for reporting segmentation.

VARCHAR2

30

WAREHOUSE_CLUSTER_CODE

Data warehouse cluster code used for reporting segmentation.

VARCHAR2

5