PAYROLL STUDENT TUITION Table
View exposing payroll student tuition data.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
APPT_SUBTYPE |
Appt subtype associated with the record. |
VARCHAR2 |
1200 |
APPT_SUBTYPE_CODE |
Code identifying appt subtype. |
VARCHAR2 |
48 |
APPT_SUBTYPE_CODE_SUBSTR |
Appt subtype code substr associated with the record. |
VARCHAR2 |
48 |
COST_COLLECTOR_KEY |
Surrogate key identifying the cost collector. |
VARCHAR2 |
144 |
DISTRIBUTION_AMOUNT |
Distribution amount associated with the record. |
NUMBER |
38,16 |
DISTRIBUTION_PERCENT |
Distribution percent associated with the record. |
NUMBER |
5,2 |
FINANCIAL_AID_YEAR |
Financial aid year associated with the record. |
VARCHAR2 |
48 |
GL_ACCOUNT_KEY |
Surrogate key identifying the gl account. |
VARCHAR2 |
120 |
HR_ORG_UNIT_KEY |
Surrogate key identifying the hr org unit. |
VARCHAR2 |
120 |
HR_POSITION_KEY |
Surrogate key identifying the hr position. |
VARCHAR2 |
120 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
1200 |
ORIGINAL_BASE_AMOUNT |
Original base amount associated with the record. |
NUMBER |
15,2 |
PAY_BASIS_CODE |
Code identifying pay basis. |
VARCHAR2 |
84 |
PERSONNEL_KEY |
Surrogate key identifying the personnel. |
VARCHAR2 |
96 |
SUSPENSE_COST_COLLECTOR_KEY |
Surrogate key identifying the suspense cost collector. |
VARCHAR2 |
144 |
TIME_MONTH_KEY |
Surrogate key identifying the time month. |
VARCHAR2 |
72 |