Payroll Personnel Data Warehouse


Table and Fields Description

Table Description --- CTLWSF

The table which contains the split percentage for funding of work study programs. The data originates from the Payroll Control Table (CTL).


Fields Definition

Field Name Business Name Data Type Description
WSF_BEGIN_DATE WORK STUDY FUND BEGIN DATE DATE The date on which a work study fund split is effective.
WSF_FUNDING_FAU FUND NUMBER VARCHAR2(30) The number identifying a specific work study funding.
WSF_LAST_ACTION LAST ACTION CODE VARCHAR2(1) The code indicating the most recent action applied to the record.
WSF_LAST_ACTION_DT LAST ACTION DATE DATE The effective date of the most recent action.
WSF_PROGRAM_CODE WORK STUDY PROGRAM CODE VARCHAR2(4) The code indicating the type of work study program.
WSF_SPLIT_PERCENT SPLIT PERCENTAGE NUMBER(5,4) The percentage of the charge which is chargeable to the fund.

Top of this page Table Description Data Dictionary PPS Main Menu



Sent Comment to: PPS Data Warehouse Support
Last Updated: January 21, 1997