FINAID FWS TIMESHEET DETAIL Table
Each record in this table represents a weekly time sheet for an off-campus position held by a student. Information in the time sheet record include: begin and end date of the week, total hours work for the week and on each day, weekly earnings, and payroll account information.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
FINAID_FWS_POSITION_KEY |
Use this field to join together the FINAID FWS POSITION and the FINAID FWS TIMESHEET DETAIL tables for information regarding a off-campus position of a student. |
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 |
FRIDAY_HOURS |
Total work hours on the Friday of the week. |
NUMBER |
4.2 |
FWS_PROGRAM_YEAR |
Federal work study program year. |
VARCHAR2 |
4 |
FWS_TIMESHEET_SOURCE |
XXX |
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 |
Total work hours on the Monday of the week. |
NUMBER |
4.2 |
PAYROLL_BILL_ACCOUNT |
XXX |
VARCHAR2 |
7 |
PAYROLL_CLASS_CODE |
XXX |
VARCHAR2 |
1 |
PAYROLL_COLLECTION |
XXX |
VARCHAR2 |
3 |
PAYROLL_DEPT_CODE |
XXX |
VARCHAR2 |
6 |
PAYROLL_OBJECT_NUMBER |
XXX |
VARCHAR2 |
6 |
PAYROLL_ORIG_ACCOUNT |
XXX |
VARCHAR2 |
7 |
PAYROLL_PROCESS |
XXX |
VARCHAR2 |
6 |
PAYROLL_RATE |
Hourly rate for the wage type. |
NUMBER |
5.2 |
SATURDAY_HOURS |
Total work hours on the Saturday of the week. |
NUMBER |
4.2 |
SUNDAY_HOURS |
Total work hours on the Sunday of the week. |
NUMBER |
4.2 |
THURSDAY_HOURS |
Total work hours on the Thursday of the week. |
NUMBER |
4.2 |
TOTAL_WORK_HOURS |
Total work hours for the week. |
NUMBER |
7.2 |
TUESDAY_HOURS |
Total work hours on the Tuesday of the week. |
NUMBER |
4.2 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |
WEDNESDAY_HOURS |
Total work hours on the Wednesday of the week. |
NUMBER |
4.2 |
WEEKLY_EARNINGS |
Total earnings for the week. |
NUMBER |
7.2 |
WEEK_BEGIN_DATE |
The begin date of the week |
DATE |
8 |
WEEK_END_DATE |
The end date of the week |
DATE |
8 |