Data Warehouse

ACADEMIC_YEAR

Academic year associated with the CSP benefit record.

VARCHAR2

4

ACTION_REASON

Action reason code associated with the CSP benefit record.

VARCHAR2

2

ACTION_TYPE

Action type code associated with the CSP benefit record.

VARCHAR2

2

ALT_CITY

City of the alternate contact address.

VARCHAR2

40

ALT_CITY_2

City of the second alternate contact address.

VARCHAR2

40

ALT_CITY_3

City of the third alternate contact address.

VARCHAR2

40

ALT_COUNTRY

Country of the alternate contact address.

VARCHAR2

3

ALT_COUNTRY_2

Country of the second alternate contact address.

VARCHAR2

3

ALT_COUNTRY_3

Country of the third alternate contact address.

VARCHAR2

3

ALT_EMAIL

Email address of the alternate contact.

VARCHAR2

80

ALT_EMAIL_2

Email address of the second alternate contact.

VARCHAR2

80

ALT_EMAIL_3

Email address of the third alternate contact.

VARCHAR2

80

ALT_FIRST_NAME

Alternate contact first name provided for CSP communication.

VARCHAR2

40

ALT_FIRST_NAME_2

Second alternate contact first name provided for CSP communication.

VARCHAR2

40

ALT_FIRST_NAME_3

Third alternate contact first name provided for CSP communication.

VARCHAR2

40

ALT_LAST_NAME

Alternate contact last name provided for CSP communication.

VARCHAR2

40

ALT_LAST_NAME_2

Second alternate contact last name provided for CSP communication.

VARCHAR2

40

ALT_LAST_NAME_3

Third alternate contact last name provided for CSP communication.

VARCHAR2

40

ALT_PHONE_NUMBER

Phone number of the alternate contact.

VARCHAR2

30

ALT_PHONE_NUMBER_2

Phone number of the second alternate contact.

VARCHAR2

30

ALT_PHONE_NUMBER_3

Phone number of the third alternate contact.

VARCHAR2

30

ALT_POSTAL_CODE

Postal code of the alternate contact address.

VARCHAR2

10

ALT_POSTAL_CODE_2

Postal code of the second alternate contact address.

VARCHAR2

10

ALT_POSTAL_CODE_3

Postal code of the third alternate contact address.

VARCHAR2

10

ALT_RELATIONSHIP_TO_EMPLOYEE

Relationship of the alternate contact to the employee.

VARCHAR2

40

ALT_RELATIONSHIP_TO_EMPLOYEE_2

Relationship of the second alternate contact to the employee.

VARCHAR2

40

ALT_RELATIONSHIP_TO_EMPLOYEE_3

Relationship of the third alternate contact to the employee.

VARCHAR2

40

ALT_STATE

State or province of the alternate contact address.

VARCHAR2

20

ALT_STATE_2

State or province of the second alternate contact address.

VARCHAR2

20

ALT_STATE_3

State or province of the third alternate contact address.

VARCHAR2

20

ALT_STREET

Street address of the alternate contact.

VARCHAR2

60

ALT_STREET_2

Street address of the second alternate contact.

VARCHAR2

60

ALT_STREET_3

Street address of the third alternate contact.

VARCHAR2

60

APPLICATION_NUMBER

Application number associated with the CSP benefit request.

VARCHAR2

8

APPL_EXTERNAL_NOTES

Free-text external notes associated with the CSP application or benefit record.

VARCHAR2

255

APPROVED_BY

User identifier indicating who approved the CSP benefit record.

VARCHAR2

12

APPROVED_DATE

Date the CSP benefit record was approved.

DATE

AP_FI_DOCUMENT_NUMBER

Accounts payable or financial document number associated with the CSP payment.

VARCHAR2

10

AP_FI_DOCUMENT_NUMBER_2

Second financial document number associated with CSP payments.

VARCHAR2

10

AP_FI_DOCUMENT_NUMBER_3

Third accounts payable or financial document number associated with the CSP payment.

VARCHAR2

10

BENEFIT_TYPE

CSP benefit type classification (as defined by source).

VARCHAR2

10

BLOCKED_FLG

Indicator identifying whether the CSP benefit record is blocked from further processing (Y/N).

VARCHAR2

1

CHECK_MAILED_TO_CODE

Code indicating the recipient to whom the CSP payment check was mailed.

VARCHAR2

1

CHECK_MAILED_TO_CODE_2

Code indicating the recipient to whom the second CSP payment check was mailed.

VARCHAR2

1

CHECK_MAILED_TO_CODE_3

Code indicating the recipient to whom the third CSP payment check was mailed.

VARCHAR2

1

CONFIRMATION_FIELDS_EXIST

Indicator identifying whether confirmation fields exist for the CSP infotype record (Y/N).

VARCHAR2

1

CONV_QTY_OF_BNFT_YRS_DEDUCT_1

Converted quantity of benefit years deducted for benefit segment 1.

NUMBER

3,2

CONV_QTY_OF_BNFT_YRS_DEDUCT_2

Converted quantity of benefit years deducted for benefit segment 2.

NUMBER

3,2

CONV_QTY_OF_BNFT_YRS_DEDUCT_3

Converted quantity of benefit years deducted for benefit segment 3.

NUMBER

3,2

CREATED_BY

User identifier indicating who created the CSP benefit record.

VARCHAR2

12

CREATED_DATE

Date the CSP benefit record was created.

DATE

CURRENT_STATUS

Current workflow status of the CSP benefit record.

VARCHAR2

30

CURRENT_STATUS_DATE

Date on which the CSP benefit entered its current status.

DATE

CURRENT_STATUS_UPDATED_BY

User identifier indicating who last updated the CSP benefit status.

VARCHAR2

12

DENIED_BY

User identifier indicating who denied the CSP benefit record.

VARCHAR2

12

DENIED_DATE

Date the CSP benefit record was denied.

DATE

DENIED_REASON

Description identifying the reason the CSP benefit was denied.

VARCHAR2

50

DENIED_REASON_CODE

Code identifying the reason the CSP benefit was denied.

VARCHAR2

2

ELIGIBLE_FOR_CAPPED

Indicator identifying whether the employee is eligible for capped CSP benefits (Y/N).

VARCHAR2

1

ELIGIBLE_FOR_MIT

Indicator identifying whether the employee is eligible for MIT-funded CSP benefits (Y/N).

VARCHAR2

1

ELIGIBLE_FOR_UNCAPPED

Indicator identifying whether the employee is eligible for uncapped CSP benefits (Y/N).

VARCHAR2

1

EMP_PERSONAL_EMAIL_CONSENT_FLG

Indicator identifying whether the employee has consented to use of a personal email address (Y/N).

VARCHAR2

1

END_DATE

End date for the CSP benefit record.

DATE

ENTERED_FOR_EMPL_FLG

Indicator identifying whether the CSP benefit record was entered on behalf of the employee (Y/N).

VARCHAR2

1

FOREIGN_DRAFT_AMOUNT

Amount of the foreign draft associated with the CSP payment.

NUMBER

13,2

FOREIGN_DRAFT_AMOUNT_2

Amount of the second foreign draft associated with the CSP payment.

NUMBER

13,2

FOREIGN_DRAFT_AMOUNT_3

Amount of the third foreign draft associated with the CSP payment.

NUMBER

13,2

FOREIGN_DRAFT_CURRENCY_RATE

Currency conversion rate applied to the foreign draft amount.

NUMBER

9,5

FOREIGN_DRAFT_CURRENCY_RATE_2

Currency conversion rate applied to the second foreign draft amount.

NUMBER

9,5

FOREIGN_DRAFT_CURRENCY_RATE_3

Currency conversion rate applied to the third foreign draft amount.

NUMBER

9,5

FOREIGN_DRAFT_DATE

Date the foreign draft was issued for the CSP payment.

DATE

FOREIGN_DRAFT_DATE_2

Date the second foreign draft was issued for the CSP payment.

DATE

FOREIGN_DRAFT_DATE_3

Date the third foreign draft was issued for the CSP payment.

DATE

FOREIGN_DRAFT_NUMBER

Foreign draft number associated with the CSP payment.

VARCHAR2

30

FOREIGN_DRAFT_NUMBER_2

Foreign draft number associated with the second CSP payment.

VARCHAR2

30

FOREIGN_DRAFT_NUMBER_3

Foreign draft number associated with the third CSP payment.

VARCHAR2

30

FOREIGN_TUITN_AMOUNT

Foreign tuition amount associated with the CSP benefit payment.

NUMBER

13,2

FOREIGN_TUITN_AMOUNT_2

Foreign tuition amount associated with the second CSP benefit payment segment.

VARCHAR2

30

FOREIGN_TUITN_AMOUNT_3

Foreign tuition amount associated with the third CSP benefit payment segment.

NUMBER

13,2

FOREIGN_TUITN_CURRENCY

Currency code associated with the foreign tuition amount.

VARCHAR2

5

FOREIGN_TUITN_CURRENCY_2

Currency code associated with the second foreign tuition amount.

VARCHAR2

5

FOREIGN_TUITN_CURRENCY_3

Currency code associated with the third foreign tuition amount.

VARCHAR2

5

FOREIGN_TUITN_CURRENCY_RATE

Currency conversion rate applied to the foreign tuition amount.

NUMBER

9,5

FOREIGN_TUITN_CURRENCY_RATE_2

Currency conversion rate applied to the second foreign tuition amount.

NUMBER

9,5

FOREIGN_TUITN_CURRENCY_RATE_3

Currency conversion rate applied to the third foreign tuition amount.

NUMBER

9,5

GROUPING_VALUE

Grouping value used by the source system for CSP processing.

VARCHAR2

4

HISTORICAL_RECORD_FLAG

Indicator identifying whether the record represents a historical CSP benefit entry (Y/N).

VARCHAR2

1

HR_ENTRY_MODE

HR entry mode used when creating or updating the CSP benefit record.

VARCHAR2

1

INFOTYPE_SCREEN_CONTROL

Infotype screen control code used by the source system.

VARCHAR2

2

IS_THIS_A_FULL_YEAR_PAYMENT

Indicator identifying whether the CSP benefit represents a full academic year payment (Y/N).

VARCHAR2

1

LAST_UPDATE_DATE

Date the CSP benefit record was last updated.

DATE

LAST_UPDATE_USER

User identifier indicating who last updated the CSP benefit record.

VARCHAR2

12

MIT_ID

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

VARCHAR2

9

MIT_SEMESTER_TUITION_AMOUNT

MIT semester tuition amount used in CSP award calculations.

NUMBER

13,2

OBJECT_ID

Object identifier used by the source system for CSP benefit records.

VARCHAR2

2

OVERRIDE_FLAG

Indicator identifying whether standard CSP rules were overridden for this benefit record (Y/N).

VARCHAR2

1

OVERRIDE_FLAG_2

Indicator identifying whether CSP rules were overridden for the second benefit segment (Y/N).

VARCHAR2

1

OVERRIDE_FLAG_3

Indicator identifying whether CSP rules were overridden for the third benefit segment (Y/N).

VARCHAR2

1

PERMANENT_SCHOOL_ID

Permanent school identifier associated with the dependent student.

VARCHAR2

10

PERSONAL_EMAIL

Personal email address provided for CSP-related communication.

VARCHAR2

80

PERSONNEL_NUMBER

Personnel number associated with the employee receiving CSP benefits.

VARCHAR2

8

PERSONNEL_SUBAREA

Personnel subarea description used to determine CSP eligibility.

VARCHAR2

40

PERSONNEL_SUBAREA_CODE

Personnel subarea code used to determine CSP eligibility.

VARCHAR2

4

PREVIOUS_PERMANENT_SCHOOL_ID

Permanent school identifier associated with the dependent prior to the current CSP record.

VARCHAR2

10

QTY_OF_BNFT_YRS_DEDUCT

Quantity of CSP benefit years deducted for this benefit record.

NUMBER

3,2

QTY_OF_BNFT_YRS_DEDUCT_2

Quantity of CSP benefit years deducted for the second benefit segment.

NUMBER

3,2

QTY_OF_BNFT_YRS_DEDUCT_3

Quantity of CSP benefit years deducted for the third benefit segment.

NUMBER

3,2

QTY_OF_BNFT_YRS_REMAINING

Quantity of CSP benefit years remaining for the employee.

NUMBER

3,2

QUANTITIY_OF_PAYMENTS

Number of CSP payments scheduled for the academic year.

VARCHAR2

5

REASON_FOR_MASTER_DATA_CHG

Reason code indicating why master data was changed.

VARCHAR2

2

REFERENCE_FIELDS_EXIST

Indicator identifying whether reference fields exist for the CSP infotype record (Y/N).

VARCHAR2

1

RELATED_FORM

Identifier or name of the related form associated with the CSP benefit record.

VARCHAR2

15

SEQUENCE_NUMBER

Sequence number identifying multiple CSP benefit records for the same employee.

VARCHAR2

3

SFS_ROSTER_AMT1

Student Financial Services roster amount 1 associated with CSP processing.

NUMBER

13,2

SFS_ROSTER_AMT2

Student Financial Services roster amount 2 associated with CSP processing.

NUMBER

13,2

SFS_ROSTER_AMT3

Student Financial Services roster amount 3 associated with CSP processing.

NUMBER

13,2

START_DATE

Start date for the CSP benefit record.

DATE

STUDENT_FIRST_NAME

First name of the dependent student associated with the CSP benefit.

VARCHAR2

40

STUDENT_ID

Student identifier associated with the dependent (as provided by source).

VARCHAR2

16

STUDENT_LAST_NAME

Last name of the dependent student associated with the CSP benefit.

VARCHAR2

40

STUDENT_MIDDLE_NAME

Middle name of the dependent student associated with the CSP benefit.

VARCHAR2

40

SUB_TYPE

Subtype code identifying the CSP benefit category (as defined by source).

VARCHAR2

4

TAX_DEPENDENT_IND

Indicator identifying whether the dependent student is a tax dependent (Y/N).

VARCHAR2

1

TEMPORARY_SCHOOL_ID

Temporary school identifier associated with the dependent student for this CSP record.

VARCHAR2

10

TEMPORARY_SCHOOL_ID_2

Second temporary school identifier associated with the CSP benefit record.

VARCHAR2

10

TEMPORARY_SCHOOL_ID_3

Third temporary school identifier associated with the CSP benefit record.

VARCHAR2

10

TEMPORARY_STUDENT_ID

Temporary student identifier associated with the dependent student.

VARCHAR2

16

TEMPORARY_STUDENT_ID_2

Second temporary student identifier associated with the dependent.

VARCHAR2

16

TEMPORARY_STUDENT_ID_3

Third temporary student identifier associated with the dependent.

VARCHAR2

16

TEXT_EXISTS_FOR_INFOTYPE

Indicator identifying whether additional text exists for the CSP infotype record (Y/N).

VARCHAR2

1

TRANSACTION_CODE

Transaction code associated with the CSP benefit record.

VARCHAR2

20

VERIFICATION_MODE

Verification mode used during CSP benefit processing (as defined by source).

VARCHAR2

1

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE

WIRE_CONFIRMATION_NUMBER

Wire transfer confirmation number associated with the CSP payment.

VARCHAR2

20

WIRE_CONFIRMATION_NUMBER_2

Wire transfer confirmation number associated with the second CSP payment.

VARCHAR2

20

WIRE_CONFIRMATION_NUMBER_3

Wire transfer confirmation number associated with the third CSP payment.

VARCHAR2

20

WIRE_TRANSACTION_NUMBER

Wire transfer transaction number associated with the CSP payment.

VARCHAR2

20

WIRE_TRANSACTION_NUMBER_2

Wire transfer transaction number associated with the second CSP payment.

VARCHAR2

20

WIRE_TRANSACTION_NUMBER_3

Wire transfer transaction number associated with the third CSP payment.

VARCHAR2

20

YEARLY_TUITION_AMOUNT

Yearly tuition amount used in CSP award calculations.

NUMBER

13,2

YEARLY_TUITION_CURRENCY

Currency code associated with the yearly tuition amount.

VARCHAR2

5