Data Warehouse

ACADEMIC_YEAR

Academic year

VARCHAR2

4

AWARD_STATUS

Status of the award. For RESEARCH AWARDS, indicates whether the award is Active, Pending, Closed, Terminated, or Inactive. For GRADUATE AWARDS (RA/TA), the possible values are: active, inactive, terminated, closed, hold, or pending. For FINANCIAL AID AWARDS, possible values include: ACTL, APPR, CANC, DECL, ESTI, KEPT, etc.

VARCHAR2

12

CHANGE_REASON_CODE

XXX

VARCHAR2

1

CHANGE_REASON_DESC

XXX

VARCHAR2

49

CHILD_BIRTH_DATE_1

XXX

DATE

CHILD_BIRTH_DATE_2

XXX

DATE

CHILD_BIRTH_DATE_3

XXX

DATE

CHILD_BIRTH_DATE_4

XXX

DATE

CHILD_CLASSROOM_1

XXX

VARCHAR2

9

CHILD_CLASSROOM_2

XXX

VARCHAR2

9

CHILD_CLASSROOM_3

XXX

VARCHAR2

9

CHILD_CLASSROOM_4

XXX

VARCHAR2

9

CHILD_DAYS_1

XXX

VARCHAR2

1

CHILD_DAYS_2

XXX

VARCHAR2

1

CHILD_DAYS_3

XXX

VARCHAR2

1

CHILD_DAYS_4

XXX

VARCHAR2

1

CHILD_FIRST_NAME_1

XXX

VARCHAR2

30

CHILD_FIRST_NAME_2

XXX

VARCHAR2

30

CHILD_FIRST_NAME_3

XXX

VARCHAR2

30

CHILD_FIRST_NAME_4

XXX

VARCHAR2

30

CHILD_HOURS_1

XXX

VARCHAR2

4

CHILD_HOURS_2

XXX

VARCHAR2

4

CHILD_HOURS_3

XXX

VARCHAR2

4

CHILD_HOURS_4

XXX

VARCHAR2

4

CHILD_LAST_NAME_1

XXX

VARCHAR2

40

CHILD_LAST_NAME_2

XXX

VARCHAR2

40

CHILD_LAST_NAME_3

XXX

VARCHAR2

40

CHILD_LAST_NAME_4

XXX

VARCHAR2

40

CHILD_MONTHLY_AWARD_AMT_1

XXX

NUMBER

7,2

CHILD_MONTHLY_AWARD_AMT_2

XXX

NUMBER

7,2

CHILD_MONTHLY_AWARD_AMT_3

XXX

NUMBER

7,2

CHILD_MONTHLY_AWARD_AMT_4

XXX

NUMBER

7,2

CHILD_MONTHLY_CALC_AMT_1

XXX

NUMBER

7,2

CHILD_MONTHLY_CALC_AMT_2

XXX

NUMBER

7,2

CHILD_MONTHLY_CALC_AMT_3

XXX

NUMBER

7,2

CHILD_MONTHLY_CALC_AMT_4

XXX

NUMBER

7,2

CHILD_MONTHLY_CONTRIBUTION_1

XXX

NUMBER

7,2

CHILD_MONTHLY_CONTRIBUTION_2

XXX

NUMBER

7,2

CHILD_MONTHLY_CONTRIBUTION_3

XXX

NUMBER

7,2

CHILD_MONTHLY_CONTRIBUTION_4

XXX

NUMBER

7,2

CHILD_MONTHLY_TUITION_1

XXX

NUMBER

7,2

CHILD_MONTHLY_TUITION_2

XXX

NUMBER

7,2

CHILD_MONTHLY_TUITION_3

XXX

NUMBER

7,2

CHILD_MONTHLY_TUITION_4

XXX

NUMBER

7,2

CHILD_TCC_1

XXX

VARCHAR2

8

CHILD_TCC_2

XXX

VARCHAR2

8

CHILD_TCC_3

XXX

VARCHAR2

8

CHILD_TCC_4

XXX

VARCHAR2

8

DENIAL_REASON_CODE

XXX

VARCHAR2

1

DENIAL_REASON_DESC

XXX

VARCHAR2

81

DISABLE_DOC_ATTACHED

XXX

VARCHAR2

1

EMPLOYEE_FUND_PERCENT

XXX

NUMBER

6,2

EMP_AMOUNT_01

XXX

NUMBER

7,2

EMP_AMOUNT_02

XXX

NUMBER

7,2

EMP_AMOUNT_03

XXX

NUMBER

7,2

EMP_AMOUNT_04

XXX

NUMBER

7,2

EMP_AMOUNT_05

XXX

NUMBER

7,2

EMP_AMOUNT_06

XXX

NUMBER

7,2

EMP_AMOUNT_07

XXX

NUMBER

7,2

EMP_AMOUNT_08

XXX

NUMBER

7,2

EMP_AMOUNT_09

XXX

NUMBER

7,2

EMP_AMOUNT_10

XXX

NUMBER

7,2

EMP_AMOUNT_11

XXX

NUMBER

7,2

EMP_AMOUNT_12

XXX

NUMBER

7,2

END_AWARD_REASON_CODE

XXX

VARCHAR2

1

END_AWARD_REASON_DESC

XXX

VARCHAR2

126

END_DATE

Specific to HR_POSITION_DETAIL: For filled positions, End Date equals Appointment End Date. For open-ended appointments, this date is usually 12/31/2999. For Closed Positions, the End Date is the delimit date on the position. Specific to GRADUATE_AWARD_TERM_DETAIL: Within the term, this is the latest date to which the money under this account has been applied. It is calculated differently depending on the type of aid. For TUIT and INS, this is set to the end of the term. For STIP, this is set to the latest date for this account in the term in the stipend distribution section in the RPAGAAID form in MITSIS. UNMATCHED payroll has this set to the latest date in the unmatched Payroll records. In all other tables, END DATE is the thru date of the transaction.

DATE

FELLOWSHIP_FUND_PERCENT

XXX

NUMBER

6,2

FELLOW_AMOUNT_01

XXX

NUMBER

7,2

FELLOW_AMOUNT_02

XXX

NUMBER

7,2

FELLOW_AMOUNT_03

XXX

NUMBER

7,2

FELLOW_AMOUNT_04

XXX

NUMBER

7,2

FELLOW_AMOUNT_05

XXX

NUMBER

7,2

FELLOW_AMOUNT_06

XXX

NUMBER

7,2

FELLOW_AMOUNT_07

XXX

NUMBER

7,2

FELLOW_AMOUNT_08

XXX

NUMBER

7,2

FELLOW_AMOUNT_09

XXX

NUMBER

7,2

FELLOW_AMOUNT_10

XXX

NUMBER

7,2

FELLOW_AMOUNT_11

XXX

NUMBER

7,2

FELLOW_AMOUNT_12

XXX

NUMBER

7,2

FUNDING_TYPE

Type of funding of an UROP project: Credit, Direct Funded, Sponsored Research, or Volunteer.

VARCHAR2

8

MARITAL_STATUS_CODE

XXX

VARCHAR2

1

MARITAL_STATUS_DESC

XXX

VARCHAR2

25

MAX_AWARD_1

XXX

NUMBER

7,2

MAX_AWARD_2

XXX

NUMBER

7,2

MAX_AWARD_3

XXX

NUMBER

7,2

MAX_AWARD_4

XXX

NUMBER

7,2

MIT_AFFILIATION_CODE

XXX

VARCHAR2

1

MIT_AFFILIATION_DESC

XXX

VARCHAR2

22

MIT_ID

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

VARCHAR2

9

OTHER_DOC_ATTACHED

XXX

VARCHAR2

1

OTHER_TEXT

XXX

VARCHAR2

255

PARENT1_ADDITIONAL_INCOME

XXX

NUMBER

15,2

PARENT1_EMP_EFT

XXX

VARCHAR2

6

PARENT1_EMP_GROSS

XXX

NUMBER

13,2

PARENT1_FELLOWSHIP_EFT

XXX

VARCHAR2

6

PARENT1_FELLOWSHIP_GROSS

XXX

NUMBER

13,2

PARENT1_SALARY

XXX

NUMBER

15,2

PARENT2_ADDITIONAL_INCOME

XXX

NUMBER

15,2

PARENT2_AFFILIATION_CODE

XXX

VARCHAR2

1

PARENT2_AFFILIATION_DESC

XXX

VARCHAR2

22

PARENT2_EMAIL

XXX

VARCHAR2

40

PARENT2_EMPLOYER_NAME

XXX

VARCHAR2

35

PARENT2_EMP_APPT_END_DATE

XXX

DATE

PARENT2_EMP_HIRE_DATE

XXX

DATE

PARENT2_EMP_PAY_FREQ

XXX

VARCHAR2

1

PARENT2_MITID

XXX

VARCHAR2

9

PARENT2_NAME_FIRST

XXX

VARCHAR2

40

PARENT2_NAME_LAST

XXX

VARCHAR2

40

PARENT2_NAME_MIDDLE

XXX

VARCHAR2

1

PARENT2_PAY_FREQ_TEXT

XXX

VARCHAR2

80

PARENT2_PHONE

XXX

VARCHAR2

20

PARENT2_SALARY

XXX

NUMBER

15,2

PARENT2_SCHL_ADMISSION_DATE

XXX

DATE

PARENT2_SCHOOL_NAME

XXX

VARCHAR2

60

PARENT2_SCH_FUNDING_TYPE_CODE

XXX

VARCHAR2

1

PARENT2_SCH_FUNDING_TYPE_DESC

XXX

VARCHAR2

18

PARENT2_SCH_GRADUATION_DATE

XXX

DATE

PARENT2_STATUS_CODE

XXX

VARCHAR2

1

PARENT2_STATUS_DESC

XXX

VARCHAR2

39

PARENT2_WITH_MIT

XXX

VARCHAR2

1

PARTIAL_01

XXX

VARCHAR2

1

PARTIAL_02

XXX

VARCHAR2

1

PARTIAL_03

XXX

VARCHAR2

1

PARTIAL_04

XXX

VARCHAR2

1

PARTIAL_05

XXX

VARCHAR2

1

PARTIAL_06

XXX

VARCHAR2

1

PARTIAL_07

XXX

VARCHAR2

1

PARTIAL_08

XXX

VARCHAR2

1

PARTIAL_09

XXX

VARCHAR2

1

PARTIAL_10

XXX

VARCHAR2

1

PARTIAL_11

XXX

VARCHAR2

1

PARTIAL_12

XXX

VARCHAR2

1

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

PREFERRED_EMAIL

XXX

VARCHAR2

40

PREFERRED_PERSON_CODE

XXX

VARCHAR2

1

PREFERRED_PERSON_DESC

XXX

VARCHAR2

9

PREFERRED_PHONE

XXX

VARCHAR2

20

START_DATE

The first day of the fiscal period. Specific to HR_POSITION_DETAIL: If the Position is filled, this value equals the appointment begin date of the person filling that position. If the position is unfilled, this value is either the date the last person vacated the position. For new positions that have never been filled, this date is the start date assigned to the position. Specific to GRADUATE_AWARD_TERM_DETAIL: Within the term, this is the earliest date to which the money under this account has been applied. It is calculated differently depending on the type of aid. For TUIT and INS, this is set to the beginning of the term. For STIP, this is set to the earliest date for this account in the term in the stipend distribution section in the RPAGAAID form. UNMATCHED payroll has this set to the earliest date in the unmatched Payroll records.

DATE

SUBMITTED_BY

XXX

VARCHAR2

12

SUBMITTED_DATE

XXX

DATE

SUBMITTED_TIME

XXX

VARCHAR2

6

TCC_START_DATE

XXX

DATE

TOTAL_INCOME

XXX

NUMBER

15,2

UPDATE_DATE

Date this record was last updated by the source system.

DATE

UPDATE_USER

Userid of the person who last updated this record.

VARCHAR2

12