FINAID PAYROLL DIST DETAIL Table
Financial Aid Student Payroll Distribution Detail ("Student Employment") Table. It contains detailed distribution transactions of all student payroll data. Each record represents a single payroll distribution.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AID_APPLICANT_KEY |
Key identifying an entry in the Financial Aid Applicant Table. This field should only be used for linking tables together, not for reporting. The field is a concatenation of the fields of MIT ID and Aid Year |
VARCHAR2 |
13 |
CHARGED_CWSP_AMOUNT |
The dollar amount of this payroll distribution that has been charged to College Work Study Program (CWSP). |
NUMBER |
15 |
COST_COLLECTOR_KEY |
Key used to join the Cost Collector to the financial transaction, and to get the master data that were current at the time of the transaction. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
12 |
FINAID_PAY_SEQ_NO |
Financial Aid Student Payroll Sequence Number. |
VARCHAR2 |
10 |
FINAID_WORK_STUDENT_KEY |
Use this field to join between the FINAID WORK STUDENT table to a financial aid fact table which contains the same-name field, eg. FINAID WORK EARNINGS DETAIL, FINAID PAYROLL DIST DETAIL. |
VARCHAR2 |
13 |
FINAID_YEAR_KEY |
Key identifying an entry in the FINAID YEAR Table. This field should only be used for linking tables together, not for reporting. |
VARCHAR2 |
4 |
FISCAL_YEAR |
The 4 digit year. The fiscal year at MIT runs from July 1st through June 30th. (e.g.: June 30, 1997 would be fiscal year 1997, July 1, 1997 would be fiscal year 1998) |
VARCHAR2 |
4 |
GL_ACCOUNT_KEY |
Key used to join the GL_ACCOUNT to the financial transaction, and to get the master data that were current at the time of the transaction. This field should only be used for joining data, NOT for reporting. |
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 |
Use this field to join together the FINAID PAYROLL DIST DETAIL and FINAID PAYROLL CWSP STATUS tables for information on the college work study payroll distributions and the status of the pertaining accounts. |
VARCHAR2 |
5 |
PAY_BEGIN_DATE |
The beginning date (Monday) of a work/paid week. |
DATE |
8 |
PAY_DIST_TYPE_KEY |
Key indentifying an entry in the FINAID PAY DIST TYPE table. This field should only be used for linking/joining tables together, NOT for reporting. |
VARCHAR2 |
6 |
PAY_END_DATE |
The ending date (Sunday) of a work/paid week. |
DATE |
8 |
PREMIUM_AMOUNT |
The total dollar amount earned for the premium pay rate in the pay period. |
NUMBER |
9 |
PREMIUM_HOURS |
The total hours worked for the premium pay rate in the pay period. |
NUMBER |
7 |
REGULAR_AMOUNT |
The total dollar amount earned for the regular pay rate in the pay period. |
NUMBER |
9 |
REGULAR_HOURS |
The total hours worked for the regular pay rate in the pay period. |
NUMBER |
7 |
REGULAR_OR_PREMIUM |
The pay rate: Regular or Premium/Overtime. |
VARCHAR2 |
1 |
TOTAL_AMOUNT |
The total dollar amount earned (for both regular and premium pay rates) in the pay period. |
NUMBER |
9 |
TOTAL_HOURS |
The total hours works (for both regular and premium pay rates) in the pay period. |
NUMBER |
7 |
VOUCHER_DATE |
Voucher date |
DATE |
8 |
VOUCHER_NUMBER |
Voucher Number |
VARCHAR2 |
10 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |