GPFR_DUCS_WA1

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
4	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
5	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id
6	ORIG_CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Original Calendar Group ID
7	RSLT_SEG_NUM	Number(4,0)	SMALLINT NOT NULL	Result Segment Number
8	GPFR_PAR3_CONT_FAM	Character(3)	VARCHAR2(3) NOT NULL	GPFR: Contribution Family Prompt Table: GPFR_DUCS_P3_VW
9	GPFR_DUCS_CON_TYP1	Character(3)	VARCHAR2(3) NOT NULL	GPFR: Contribution Type
10	GPFR_DUCS_ORDER	Number(2,0)	SMALLINT NOT NULL	Order number in the contribution setup
11	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
12	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
13	ESTABID	Character(12)	VARCHAR2(12) NOT NULL	Establishment ID
14	GPFR_DUCS_CON_TRS	Character(1)	VARCHAR2(1) NOT NULL	GPFR: Transportation Contribution
15	GPFR_DUCS_WA_MR	Character(10)	VARCHAR2(10) NOT NULL	Organism which will receive the Ducs file
16	GPFR_DUCS_WA_EN2	Character(22)	VARCHAR2(22) NOT NULL	Contract number
17	GPFR_DUCS_WA_CSC	Character(3)	VARCHAR2(3) NOT NULL	GPFR: CSC Code
18	GPFR_DUCS_WA_REF1	Character(3)	VARCHAR2(3) NOT NULL	COT Record, reference qualifier 1
19	GPFR_DUCS_WA_REF2	Character(3)	VARCHAR2(3) NOT NULL	COT Record, reference qualifier 2
20	GPFR_DUCS_WA_EN4_1	Number(1,0)	SMALLINT NOT NULL	Coming from payroll (via an Array and a Writeable Array)
21	GPFR_DUCS_WA_EN4_2	Number(1,0)	SMALLINT NOT NULL	1 for man, 0 for woman
22	GPFR_DUCS_WA_EN4_3	Number(1,0)	SMALLINT NOT NULL	1 for apprentice, zero else
23	GPFR_DUCS_WA_EN4_4	Number(1,0)	SMALLINT NOT NULL	1 if under Assedic insurance, zero else
24	GPFR_DUCS_WA_EN4_5	Number(1,0)	SMALLINT NOT NULL	1 if older than 65, zero else
25	GPFR_DUCS_WA_EN4_6	Number(1,0)	SMALLINT NOT NULL	1 if CES, zero else
26	GPFR_DUCS_WA_BAS	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Contribution Base in the DUCS WA
27	GPFR_DUCS_WA_R_EE	Number(9,4)	DECIMAL(8,4) NOT NULL	GPFR: Employee Rate
28	GPFR_DUCS_WA_R_ER	Number(9,4)	DECIMAL(8,4) NOT NULL	GPFR: Employer Rate
29	GPFR_DUCS_WA_R_AT	Number(9,4)	DECIMAL(8,4) NOT NULL	GPFR: AT Rate
30	GPFR_DUCS_WA_A_EE	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	GPFR: Employee Amount
31	GPFR_DUCS_WA_A_ER	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Employer Amount in the DUCS WA
32	GPFR_DUCS_WA_CNT1	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	GPFR: Employee Number
33	GPFR_DUCS_WA_CNT2	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	GPFR: Employee Nbr, sum lump
34	GPFR_DUCS_WA_IRC1	Character(10)	VARCHAR2(10) NOT NULL	GPFR: Institution Code
35	GPFR_DUCS_WA_PROF	Character(10)	VARCHAR2(10) NOT NULL	GPFR: Socio professional group
36	GPFR_DUCS_CON_T11	Character(3)	VARCHAR2(3) NOT NULL	GPFR: Positive Contribution Type 1
37	GPFR_DUCS_CON_T12	Character(3)	VARCHAR2(3) NOT NULL	GPFR: Negative Contribution Type 1
38	GPFR_DUCS_CON_T21	Character(3)	VARCHAR2(3) NOT NULL	GPFR: Positive Contribution Type 2
39	GPFR_DUCS_CON_T22	Character(3)	VARCHAR2(3) NOT NULL	GPFR: Negative Contribution Type 2
40	GPFR_DUCS_WA_RTDT	Date(10)	DATE	DUCS Rate Change Effective Date
41	GPFR_DUCS_CON_TAT	Character(1)	VARCHAR2(1) NOT NULL	DUCS Additional Transportation