Data Warehouse

AAP_ACTION_TYPE

AAP-specific action type used for affirmative action reporting.

VARCHAR2

10

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 promotion record.

VARCHAR2

4

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

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

AFTER_AAP_CATEGORY_CODE

AAP category code after the promotion action.

VARCHAR2

4

AFTER_AAP_UNIT

AAP unit name after the promotion action.

VARCHAR2

80

AFTER_AAP_UNIT_ID

AAP unit identifier after the promotion action.

VARCHAR2

8

AFTER_HR_APPT_SUBTYPE

HR appointment subtype description after the promotion action.

VARCHAR2

100

AFTER_HR_APPT_SUBTYPE_CODE

HR appointment subtype code after the promotion action.

VARCHAR2

4

AFTER_HR_APPT_TYPE

HR appointment type description after the promotion action.

VARCHAR2

30

AFTER_HR_APPT_TYPE_CODE

HR appointment type code after the promotion action.

VARCHAR2

3

AFTER_HR_DEPARTMENT_NAME

HR department name after the promotion action.

VARCHAR2

75

AFTER_HR_JOB_KEY

HR job key after the promotion action.

VARCHAR2

10

AFTER_HR_ORG_LEVEL3_ID

Level 3 HR organizational unit identifier after the promotion action.

VARCHAR2

8

AFTER_HR_ORG_LEVEL3_NAME

Level 3 HR organizational unit name after the promotion action.

VARCHAR2

75

AFTER_HR_ORG_UNIT_ID

HR organizational unit identifier after the promotion action.

VARCHAR2

8

AFTER_HR_ORG_UNIT_KEY

HR organizational unit key after the promotion action.

VARCHAR2

10

AFTER_JOB_GROUP

Job group description after the promotion action.

VARCHAR2

30

AFTER_JOB_GROUP_CODE

Job group code after the promotion action.

VARCHAR2

2

AFTER_JOB_ID

Job identifier after the promotion action.

VARCHAR2

8

AFTER_JOB_TITLE

Job title after the promotion action.

VARCHAR2

40

AFTER_MIT_JOB_CODE

MIT-specific job code after the promotion action.

VARCHAR2

12

AGE

Age of the individual at the time of promotion.

NUMBER

4

AGE_BY_FISCAL_YEAR

Age of the individual calculated as of the fiscal year.

NUMBER

4

APPT_BEGIN_DATE

Appointment begin date for the post-promotion appointment.

DATE

APPT_END_DATE

Appointment end date for the post-promotion appointment, if applicable.

DATE

APPT_TX_BEGIN_DATE

Appointment transaction begin date associated with the promotion.

DATE

APPT_TX_END_DATE

Appointment transaction end date associated with the promotion.

DATE

BEFORE_HR_DEPARTMENT_NAME

HR department name prior to the promotion action.

VARCHAR2

75

BEFORE_HR_ORG_LEVEL3_ID

Level 3 HR organizational unit identifier prior to the promotion action.

VARCHAR2

8

BEFORE_HR_ORG_LEVEL3_NAME

Level 3 HR organizational unit name prior to the promotion action.

VARCHAR2

75

BEFORE_HR_ORG_UNIT_ID

HR organizational unit identifier prior to the promotion action.

VARCHAR2

8

CURRENT_EMPLOYMENT_DATE

Date on which the individual began current employment status.

DATE

DATE_OF_BIRTH

Date of birth of the individual.

DATE

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_KEY

HR appointment type key associated with the promotion event.

VARCHAR2

20

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

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

ORIGINAL_HIRE_DATE

Original hire date of the individual at MIT.

DATE

PERSONNEL_ACTION

Personnel action description associated with the promotion event.

VARCHAR2

30

PERSONNEL_ACTION_BEGIN_DATE

Begin date of the personnel action period for the promotion.

DATE

PERSONNEL_ACTION_CODE

Personnel action code associated with the promotion event.

VARCHAR2

2

PERSONNEL_ACTION_END_DATE

End date of the personnel action period for the promotion.

DATE

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_AAP_CATEGORY_CODE

AAP category code prior to the promotion action.

VARCHAR2

4

PRIOR_AAP_UNIT

AAP unit name prior to the promotion action.

VARCHAR2

80

PRIOR_AAP_UNIT_ID

AAP unit identifier prior to the promotion action.

VARCHAR2

8

PRIOR_APPT_END_DATE

Appointment end date for the prior appointment, if applicable.

DATE

PRIOR_JOB_GROUP

Job group description prior to the promotion action.

VARCHAR2

30

PRIOR_JOB_GROUP_CODE

Job group code prior to the promotion action.

VARCHAR2

2

PRIOR_JOB_ID

Job identifier prior to the promotion action.

VARCHAR2

8

PRIOR_JOB_TITLE

Job title prior to the promotion action.

VARCHAR2

40

PRIOR_MIT_JOB_CODE

MIT-specific job code prior to the promotion action.

VARCHAR2

12

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