FINAID FWS POSITION Table
View exposing Federal Work Study position records associated with student employment under financial aid programs.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ANTICIPATED_HOURS |
Anticipated hours associated with the record. |
VARCHAR2 |
60 |
FINAID_FWS_POSITION_KEY |
Surrogate key identifying the finaid fws position. |
VARCHAR2 |
15 |
FWS_PROGRAM_CODE |
Code identifying fws program. |
VARCHAR2 |
4 |
FWS_PROGRAM_DESCRIPTION |
Description of fws program. |
VARCHAR2 |
30 |
FWS_PROGRAM_PERCENT |
Fws program percent associated with the record. |
NUMBER |
4,3 |
FWS_PROGRAM_YEAR |
Fws program year associated with the record. |
VARCHAR2 |
4 |
JOB_BEGIN_DATE |
Date associated with job begin. |
DATE |
|
JOB_CREATE_DATE |
Date associated with job create. |
DATE |
|
JOB_END_DATE |
Date associated with job end. |
DATE |
|
JOB_LONG_DESCRIPTION |
Description of job long. |
VARCHAR2 |
2000 |
JOB_SHORT_DESCRIPTION |
Description of job short. |
VARCHAR2 |
60 |
JOB_TITLE |
Job title associated with the record. |
VARCHAR2 |
60 |
ORGANIZATION_NAME |
Organization name associated with the record. |
VARCHAR2 |
60 |
ORGANIZATION_STATUS |
Organization status associated with the record. |
VARCHAR2 |
30 |
ORGANIZATION_TYPE |
Organization type associated with the record. |
VARCHAR2 |
30 |
POSITION_BEGIN_DATE |
Date associated with position begin. |
DATE |
|
POSITION_CREATE_DATE |
Date associated with position create. |
DATE |
|
POSITION_END_DATE |
Date associated with position end. |
DATE |
|
WAGE_RANGE |
Wage range associated with the record. |
VARCHAR2 |
60 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |