| Field Name |
Business Name |
Data Type |
Description |
| FNW_ADC_CODE |
ADD/DELETE/CHANGE FLAG |
VARCHAR2(1) |
The code indicating the most recent update activity applied to
the
individual during the current fiscal year (A=add, D=delete,
or C=change. |
| FNW_AS_OF_DATE |
AS OF DATE |
DATE |
The date on which the associated work study limit was established |
| FNW_DEPT_CODE |
DEPARTMENT CODE |
VARCHAR2(6) |
The code indicating the department to which the associated work
study limit
entry applies (BLANK=All departments-generic limit,
UNLIM=All depts-no limit, or
XXXXXX=Specific department) |
| FNW_EMPLOYEE_ID |
EMPLOYEE ID NUMBER |
VARCHAR2(9) |
The unique employee identification number |
| FNW_FISCAL_YEAR |
FISCAL YEAR |
NUMBER(22,5) |
The fiscal year to which the associated work study limit entry
(EDB
0615-0619) applies |
| FNW_FYTD_GROSS |
FISCAL YEAR-TO-DATE GROSS AMOUNT |
NUMBER(22,7) |
The fiscal year-to-date total of work study earnings for the
associated
work study limit key and work study limit |
| FNW_LIMIT |
WORK STUDY LIMIT |
NUMBER(22,5) |
The maximum gross pay which may be charged to the work study funds
for the
associated work study limit key |
| FNW_PRIOR_DATE |
PRIOR DATE |
DATE |
The value of work study limit-last change date immediately prior
to the
current value |
| FNW_PRIOR_LIMIT |
PRIOR LIMIT AMOUNT |
NUMBER(22,5) |
The value of work study limit immediately preceding the current value |
| FNW_WORK_STUDY_PGM |
WORK STUDY PROGRAM |
VARCHAR2(1) |
The code indicating the work study program of the associated work
study
limit entry |
