Data Warehouse

AAP_ACTION_TYPE

AAP-specific action type used for affirmative action reporting.

VARCHAR2

12

AAP_CURRENT_DATA_FLAG

Indicator identifying whether the record represents current AAP data (Y/N).

VARCHAR2

1

AAP_PLAN_YEAR

Affirmative Action Plan (AAP) plan year associated with the termination 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

ACTION_REASON

Description of the reason for the personnel action.

VARCHAR2

30

ACTION_REASON_CODE

Code identifying the reason for the personnel action.

VARCHAR2

2

ADJUSTED_SERVICE_DATE

Adjusted service date used for benefits or service calculations.

DATE

AGE

Age of the individual at the time of termination.

NUMBER

4

AGE_BY_FISCAL_YEAR

Age of the individual calculated as of the fiscal year.

NUMBER

4

APPT_BEGIN_DATE

Appointment begin date associated with the record.

DATE

APPT_END_DATE

Appointment end date associated with the record, if applicable.

DATE

APPT_TX_END_DATE

Effective end date of the appointment transaction associated with the termination.

DATE

CURRENT_EMPLOYMENT_DATE

Date on which the individual began current employment status.

DATE

DATE_OF_BIRTH

Date of birth of the individual.

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

HR_APPT_TYPE

HR appointment type associated with the termination.

VARCHAR2

30

HR_DEPARTMENT_NAME

HR department name associated with the termination.

VARCHAR2

75

HR_ORG_LEVEL3_ID

Level 3 HR organizational unit identifier.

VARCHAR2

8

HR_ORG_LEVEL3_NAME

Level 3 HR organizational unit name.

VARCHAR2

75

HR_ORG_UNIT_ID

HR organizational unit identifier.

VARCHAR2

8

HR_ORG_UNIT_TITLE

Title of the HR organizational unit associated with the termination.

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 disability status (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 Vietnam-era veteran status (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 termination.

VARCHAR2

8

JOB_TITLE

Job title associated with the termination.

VARCHAR2

40

KRB_NAME_UPPERCASE

Kerberos username of the individual, stored in uppercase.

VARCHAR2

30

LAST_NAME

Last name of the individual.

VARCHAR2

40

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

VARCHAR2

12

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

VARCHAR2

8

ORIGINAL_EMPLOYMENT_PERCENT

Original employment percentage associated with the appointment.

NUMBER

7,4

ORIGINAL_HIRE_DATE

Original hire date of the individual at MIT.

DATE

PAY_GRADE

Pay grade associated with the position at termination.

VARCHAR2

20

PERSONNEL_ACTION

Personnel action description associated with the termination event.

VARCHAR2

30

PERSONNEL_ACTION_CODE

Personnel action code associated with the termination event.

VARCHAR2

2

PERSONNEL_AREA

Personnel area description associated with the individual.

VARCHAR2

30

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

20

PERSONNEL_SUBAREA_CODE

Personnel subarea code associated with the individual.

VARCHAR2

4

POSITION_ID

Position identifier associated with the termination.

VARCHAR2

8

POSITION_TITLE

Position title associated with the termination.

VARCHAR2

45

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

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

WEBHIRE_REQ_NUMBER

WebHire requisition number associated with the individual, if applicable.

VARCHAR2

12