FINAID PAYROLL CWSP STATUS Table
View exposing reference values describing payroll status for student community work-study program participation.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
HAS_ASSIGNED_TO_CWSP |
Indicator identifying whether assigned to cwsp (Y/N). |
VARCHAR2 |
1 |
HAS_CHARGED_TO_CWSP |
Indicator identifying whether charged to cwsp (Y/N). |
VARCHAR2 |
1 |
IS_CWSP_ACCOUNT |
Indicator identifying whether cwsp account (Y/N). |
VARCHAR2 |
1 |
IS_FWSP |
Indicator identifying whether fwsp (Y/N). |
VARCHAR2 |
1 |
IS_UROP_ACCOUNT |
Indicator identifying whether urop account (Y/N). |
VARCHAR2 |
1 |
PAYROLL_CWSP_STATUS_KEY |
Surrogate key identifying the payroll cwsp status. |
VARCHAR2 |
5 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |