Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse 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