GPFR_DUCS_HDC

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GPFR_DUCS_NUMBER	Number(10,0)	DECIMAL(10) NOT NULL	DUCS Process Instance
2	GPFR_DUCS_CD	Character(10)	VARCHAR2(10) NOT NULL	GPFR: DUCS Code
3	GPFR_DUCS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	GPFR: DUCS Type
4	GPFR_ROW_NUM	Number(5,0)	INTEGER NOT NULL	Used as counter for row or column number
5	GPFR_ROW_NUM2	Number(5,0)	INTEGER NOT NULL	Used as counter for row or column number (level2). Used in the DUCS/BDA/TRC reports.
6	GPFR_PAR3_CONT_FAM	Character(3)	VARCHAR2(3) NOT NULL	GPFR: Contribution Family
7	GPFR_DUCS_COT_TYPE	Character(3)	VARCHAR2(3) NOT NULL	GPFR: Contribution Type
8	GPFR_DUCS_COT_DATE	Character(35)	VARCHAR2(35) NOT NULL	GPFR: Reference Period
9	GPFR_DUCS_COT_RATE	Character(8)	VARCHAR2(8) NOT NULL	Rate in the DUCS COT record
10	GPFR_DUCS_COT_PCT	Character(8)	VARCHAR2(8) NOT NULL	GPFR: Contribution Rate
11	GPFR_DUCS_COT_TYP1	Character(3)	VARCHAR2(3) NOT NULL	GPFR: Amount Type 1
12	GPFR_DUCS_COT_TYP2	Character(3)	VARCHAR2(3) NOT NULL	GPFR: Amount Type 2
13	GPFR_DUCS_COT_KEY	Character(50)	VARCHAR2(50) NOT NULL	Concatenation field used for the GPFR_DUCS_COT table, because the number of keys is greater than 16 (technical limit)
14	GPFR_DUCS_COT_REF1	Character(35)	VARCHAR2(35) NOT NULL	GPFR: Reference Family 1
15	GPFR_DUCS_COT_REF2	Character(35)	VARCHAR2(35) NOT NULL	GPFR: Reference Family 2
16	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
17	GPFR_DUCS_REG_FLG	Character(1)	VARCHAR2(1) NOT NULL	DUCS Regularization Flag Y/N Table Edit Default Value: N
18	GPFR_DUCS_COT_NBR1	Signed Number(9,2)	DECIMAL(7,2) NOT NULL	Payees Number 1 in the COT DUCS Record
19	GPFR_DUCS_COT_NBR2	Signed Number(9,2)	DECIMAL(7,2) NOT NULL	Payees Number 2 in the COT DUCS Record
20	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance