PAYROLL STUDENT TUITION PP Table
View exposing payroll student tuition pp data.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AMOUNT |
Amount associated with the record. |
NUMBER |
|
APPT_SUBTYPE_CODE |
Code identifying appt subtype. |
VARCHAR2 |
48 |
COST_COLLECTOR_KEY |
Surrogate key identifying the cost collector. |
VARCHAR2 |
144 |
FINANCIAL_AID_YEAR |
Financial aid year associated with the record. |
VARCHAR2 |
48 |
GL_ACCOUNT_KEY |
Surrogate key identifying the gl account. |
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 |
PAY_BASIS_CODE |
Code identifying pay basis. |
VARCHAR2 |
84 |
PAY_DIST_PERCENT |
Pay dist percent associated with the record. |
NUMBER |
5,2 |
PERSONNEL_KEY |
Surrogate key identifying the personnel. |
VARCHAR2 |
96 |
PRORATION_PERIOD_END_DATE |
Date associated with proration period end. |
DATE |
|
PRORATION_PERIOD_START_DATE |
Date associated with proration period start. |
DATE |
|
TERM_COMPLETION_PERCENT |
Term completion percent associated with the record. |
NUMBER |
8,4 |
TERM_COMPLETION_PERCENT_INCR |
Term completion percent incr associated with the record. |
NUMBER |
8,4 |
TIME_MONTH_KEY |
Surrogate key identifying the time month. |
VARCHAR2 |
72 |