The translation list for the work study program code. This entity contains the program belongs to the CTLWSF. The data originates from the Payroll Control Table (CTL).
| Field Name | Business Name | Data Type | Description |
|---|---|---|---|
| WSP_APPROP_FAU | APPROPRIATION ACCOUNT | VARCHAR2(30) | The number of an account against which work study salary or wage expense are charged. |
| WSP_BENEFITS_IND | BENEFITS INDICATOR | VARCHAR2(1) | The code indicating whether the work study program is benefits eligible. |
| WSP_CATEG_CODE | CATEGORY CODE | VARCHAR2(1) | The code indicating the work study program category (F=federal, S=State, U=university). |
| WSP_GL_DESC | GENERAL LEDGER DESCRIPTION | VARCHAR2(18) | The description which is used in the General Ledger for the account title. |
| WSP_LAST_ACTION | LAST ACTION CODE | VARCHAR2(1) | The code indicating the most recent action applied to the record. |
| WSP_LAST_ACTION_DT | LAST ACTION DATE | DATE | The effect date of the most recent action. |
| WSP_PGM_END_DATE | PROGRAM END DATE | DATE | The date on which the work study program ended or is expected to end. |
| WSP_PROGRAM_CODE | WORK STUDY PROGRAM CODE | VARCHAR2(4) | The code indicating the type of work study program. |
| WSP_PROGRAM_NAME | WORK STUDY PROGRAM NAME | VARCHAR2(30) | The name of the work study program. |
| Top of this page | Data Dictionary | PPS Main Menu |
Sent Comments to PPS Data Warehouse Support at paysy-support@ucdavis.edu
Last Updated: January 21, 1997