FINAID FWS POSITION Table
A dimension table to be used in the Financial Aid Student Work Study (off-campus work) Star Schema. It contains all off-campus positions (with job title, description, program code, organization name, organization type, etc.) for the Financial Student Work Study program. The positions are grouped by program year.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ANTICIPATED_HOURS |
XXX |
VARCHAR2 |
60 |
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 |
FWS_PROGRAM_CODE |
Federal work study program code. Eg. AMCT for "America Counts", AMRD for "America Reads", OFFC for "Off Campus Community Service". |
VARCHAR2 |
4 |
FWS_PROGRAM_DESCRIPTION |
The descriptive text for FWS PROGRAM CODE |
VARCHAR2 |
30 |
FWS_PROGRAM_PERCENT |
The percentage associated with a FWS program for the program year. |
NUMBER |
4.3 |
FWS_PROGRAM_YEAR |
Federal work study program year. |
VARCHAR2 |
4 |
JOB_BEGIN_DATE |
Beginning date of this job |
DATE |
8 |
JOB_CREATE_DATE |
XXX |
DATE |
8 |
JOB_END_DATE |
The day the job becomes an ex-job. |
DATE |
8 |
JOB_LONG_DESCRIPTION |
XXX |
VARCHAR2 |
2000 |
JOB_SHORT_DESCRIPTION |
XXX |
VARCHAR2 |
60 |
JOB_TITLE |
In MIT's HR tables this field contains the official MIT job Title. This title is tied to the Job ID, and can only be changed by the Compensation Office. |
VARCHAR2 |
50 |
ORGANIZATION_NAME |
The name of the MIT Department or Unit to which the project is assigned, usually the home unit or the Principal Investigator or Co-Investigator. |
VARCHAR2 |
40 |
ORGANIZATION_STATUS |
XXX |
VARCHAR2 |
30 |
ORGANIZATION_TYPE |
XXX |
VARCHAR2 |
30 |
POSITION_BEGIN_DATE |
The date when the position becomes active. Most positions that were converted in the fall 2003 have this date set to 01/01/1900. |
DATE |
8 |
POSITION_CREATE_DATE |
XXX |
DATE |
8 |
POSITION_END_DATE |
The date when the position stops being active. The positions that have not been closed, will have 12/31/2999 in this field. |
DATE |
8 |
WAGE_RANGE |
XXX |
VARCHAR2 |
60 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |