FINAID FWS TIMESHEET DETAIL Table
View exposing Federal Work Study timesheet detail records associated with student work-study employment and earnings.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
FINAID_FWS_POSITION_KEY |
Surrogate key identifying the finaid fws position. |
VARCHAR2 |
14 |
FINAID_WORK_STUDENT_KEY |
Surrogate key identifying the finaid work student. |
VARCHAR2 |
25 |
FINAID_YEAR_KEY |
Surrogate key identifying the finaid year. |
VARCHAR2 |
16 |
FISCAL_YEAR |
Fiscal year associated with the record. |
VARCHAR2 |
16 |
FRIDAY_HOURS |
Friday hours associated with the record. |
NUMBER |
4,2 |
FWS_PROGRAM_YEAR |
Fws program year associated with the record. |
VARCHAR2 |
4 |
FWS_TIMESHEET_SOURCE |
Fws timesheet source associated with the record. |
VARCHAR2 |
1 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
MONDAY_HOURS |
Monday hours associated with the record. |
NUMBER |
4,2 |
PAYROLL_BILL_ACCOUNT |
Payroll bill account associated with the record. |
VARCHAR2 |
7 |
PAYROLL_CLASS_CODE |
Code identifying payroll class. |
VARCHAR2 |
1 |
PAYROLL_COLLECTION |
Payroll collection associated with the record. |
VARCHAR2 |
3 |
PAYROLL_DEPT_CODE |
Code identifying payroll dept. |
VARCHAR2 |
6 |
PAYROLL_OBJECT_NUMBER |
Payroll object number associated with the record. |
VARCHAR2 |
6 |
PAYROLL_ORIG_ACCOUNT |
Payroll orig account associated with the record. |
VARCHAR2 |
7 |
PAYROLL_PROCESS |
Payroll process associated with the record. |
VARCHAR2 |
6 |
PAYROLL_RATE |
Payroll rate associated with the record. |
NUMBER |
5,2 |
SATURDAY_HOURS |
Saturday hours associated with the record. |
NUMBER |
4,2 |
SUNDAY_HOURS |
Sunday hours associated with the record. |
NUMBER |
4,2 |
THURSDAY_HOURS |
Thursday hours associated with the record. |
NUMBER |
4,2 |
TOTAL_WORK_HOURS |
Total work hours associated with the record. |
NUMBER |
7,2 |
TUESDAY_HOURS |
Tuesday hours associated with the record. |
NUMBER |
4,2 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |
|
WEDNESDAY_HOURS |
Wednesday hours associated with the record. |
NUMBER |
4,2 |
WEEKLY_EARNINGS |
Weekly earnings associated with the record. |
NUMBER |
7,2 |
WEEK_BEGIN_DATE |
Date associated with week begin. |
DATE |
|
WEEK_END_DATE |
Date associated with week end. |
DATE |