FINAID PAYROLL DIST DETAIL Table
View exposing payroll distribution detail records associated with financial aid work-study programs.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AID_APPLICANT_KEY |
Surrogate key identifying the aid applicant. |
VARCHAR2 |
13 |
CHARGED_CWSP_AMOUNT |
Charged cwsp amount associated with the record. |
NUMBER |
18,2 |
COST_COLLECTOR_KEY |
Surrogate key identifying the cost collector. |
VARCHAR2 |
12 |
FINAID_PAY_SEQ_NO |
Finaid pay seq no associated with the record. |
VARCHAR2 |
10 |
FINAID_WORK_STUDENT_KEY |
Surrogate key identifying the finaid work student. |
VARCHAR2 |
13 |
FINAID_YEAR_KEY |
Surrogate key identifying the finaid year. |
VARCHAR2 |
4 |
FISCAL_YEAR |
Fiscal year associated with the record. |
VARCHAR2 |
4 |
GL_ACCOUNT_KEY |
Surrogate key identifying the gl account. |
VARCHAR2 |
10 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
PAYROLL_CWSP_STATUS_KEY |
Surrogate key identifying the payroll cwsp status. |
VARCHAR2 |
5 |
PAY_BEGIN_DATE |
Date associated with pay begin. |
DATE |
|
PAY_DIST_TYPE_KEY |
Surrogate key identifying the pay dist type. |
VARCHAR2 |
6 |
PAY_END_DATE |
Date associated with pay end. |
DATE |
|
PREMIUM_AMOUNT |
Premium amount associated with the record. |
NUMBER |
7,2 |
PREMIUM_HOURS |
Premium hours associated with the record. |
NUMBER |
5,2 |
REGULAR_AMOUNT |
Regular amount associated with the record. |
NUMBER |
7,2 |
REGULAR_HOURS |
Regular hours associated with the record. |
NUMBER |
5,2 |
REGULAR_OR_PREMIUM |
Regular or premium associated with the record. |
VARCHAR2 |
1 |
TOTAL_AMOUNT |
Total amount associated with the record. |
NUMBER |
8,2 |
TOTAL_HOURS |
Total hours associated with the record. |
NUMBER |
6,2 |
VOUCHER_DATE |
Date associated with voucher. |
DATE |
|
VOUCHER_NUMBER |
Voucher number associated with the record. |
VARCHAR2 |
10 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |