FINAID PAYROLL CWSP STATUS Table
A dimension table for the CWSP (College Work Study Program) account status for each of the student payroll distribution record.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
HAS_ASSIGNED_TO_CWSP |
A flag (Y=Yes, N=No) indicating whether the distribution has been assigned to College Work Study Program (CWSP). |
VARCHAR2 |
1 |
HAS_CHARGED_TO_CWSP |
A flag (Y=Yes, N=No) indicating whether the distribution has been charged to College Work Study Program (CWSP). |
VARCHAR2 |
1 |
IS_CWSP_ACCOUNT |
A flag (Y=Yes, N=No) indicating whether the account is eligible to have College Work Study Program (CWSP) charged against it. |
VARCHAR2 |
1 |
IS_FWSP |
Whether this is a FWSP (Federal Work Study Program) item. Currently, this flag is not being used, it's set to "N". |
VARCHAR2 |
1 |
IS_UROP_ACCOUNT |
A flag (Y=Yes, N=No) indicating whether the account is a UROP account. |
VARCHAR2 |
1 |
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 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |