WKF_CNT_RDT_ESP (SQL Table)	Index Back
Contract Reduction Data ESP Reduction Data related with Employee Contract.

WKF_CNT_RDT_ESP

(SQL Table)

Contract Reduction Data ESP

Reduction Data related with Employee Contract.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PERSON

2 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract Number

3 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

4 REDCTN_ID_ESP Character(3) VARCHAR2(3) NOT NULL Reduction ID
Prompt Table: %EDITTABLE

5 REDCTN_CLASS_ESP Character(3) VARCHAR2(3) NOT NULL Reduction Class
1=By Contract
2=By Employee
3=By Employer

6 CNT_REDUCTION_ESP Character(1) VARCHAR2(1) NOT NULL Permanent Intermitent flag
1=By Contract
2=By Employee
3=By Employer

7 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
Default Value: A

8 END_DT Date(10) DATE end date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract Number
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	REDCTN_ID_ESP	Character(3)	VARCHAR2(3) NOT NULL	Reduction ID Prompt Table: %EDITTABLE
5	REDCTN_CLASS_ESP	Character(3)	VARCHAR2(3) NOT NULL	Reduction Class 1=By Contract 2=By Employee 3=By Employer
6	CNT_REDUCTION_ESP	Character(1)	VARCHAR2(1) NOT NULL	Permanent Intermitent flag 1=By Contract 2=By Employee 3=By Employer
7	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
8	END_DT	Date(10)	DATE	end date