GPFR_DUC_WA_HST

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