GPFR_DUCS_COT

(SQL Table)
Index Back

DUCS COT Record

DUCS COT Record

# 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_DUCS_REG_FLG Character(1) VARCHAR2(1) NOT NULL DUCS Regularization Flag

Y/N Table Edit

Default Value: N

5 GPFR_ROW_NUM Number(5,0) INTEGER NOT NULL Used as counter for row or column number
6 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.
7 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
8 GPFR_DUCS_COT_CD Character(3) VARCHAR2(3) NOT NULL GPFR: Coded Instruction
9 GPFR_DUCS_COT_INST Character(3) VARCHAR2(3) NOT NULL GPFR: Detailed Coded Instruction
10 GPFR_DUCS_COT_LINE Character(6) VARCHAR2(6) NOT NULL GPFR: Lines Number
11 GPFR_DUCS_COT_DATE Character(35) VARCHAR2(35) NOT NULL GPFR: Reference Period
12 GPFR_DUCS_COT_RATE Character(8) VARCHAR2(8) NOT NULL Rate in the DUCS COT record
13 GPFR_DUCS_COT_FMT Character(3) VARCHAR2(3) NOT NULL GPFR: Period Type
14 GPFR_DUCS_COT_AMTR Signed Number(20,6) DECIMAL(18,6) NOT NULL Recalculated amount (rate * sum of base) in the COT DUCS Record
15 GPFR_DUCS_COT_PCT Character(8) VARCHAR2(8) NOT NULL GPFR: Contribution Rate
16 GPFR_DUCS_RECORD Character(3) VARCHAR2(3) NOT NULL GPFR: Record Code
17 GPFR_PAR3_CONT_FAM Character(3) VARCHAR2(3) NOT NULL GPFR: Contribution Family
18 GPFR_DUCS_COT_TYPE Character(3) VARCHAR2(3) NOT NULL GPFR: Contribution Type
19 GPFR_DUCS_COT_TYP1 Character(3) VARCHAR2(3) NOT NULL GPFR: Amount Type 1
20 GPFR_DUCS_COT_TYP2 Character(3) VARCHAR2(3) NOT NULL GPFR: Amount Type 2
21 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)
22 GPFR_DUCS_COT_AMT1 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 1 in the COT DUCS Record
23 GPFR_DUCS_COT_CUR1 Character(3) VARCHAR2(3) NOT NULL GPFR: Currency 1
24 GPFR_DUCS_COT_AMT2 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 2 in the COT DUCS Record
25 GPFR_DUCS_COT_CUR2 Character(3) VARCHAR2(3) NOT NULL GPFR: Currency 2
26 GPFR_DUCS_COT_NBR1 Signed Number(9,2) DECIMAL(7,2) NOT NULL Payees Number 1 in the COT DUCS Record
27 GPFR_DUCS_COT_NBR2 Signed Number(9,2) DECIMAL(7,2) NOT NULL Payees Number 2 in the COT DUCS Record
28 GPFR_DUCS_COT_RCD1 Character(3) VARCHAR2(3) NOT NULL GPFR: Reference Code 1
29 GPFR_DUCS_COT_REF1 Character(35) VARCHAR2(35) NOT NULL GPFR: Reference Family 1
30 GPFR_DUCS_COT_RCD2 Character(3) VARCHAR2(3) NOT NULL GPFR: Reference Code 2
31 GPFR_DUCS_COT_REF2 Character(35) VARCHAR2(35) NOT NULL GPFR: Reference Family 2
32 GPFR_DUCS_COT_RNUM Signed Number(20,6) DECIMAL(18,6) NOT NULL Numeric rate for the DUCS COT records
33 GPFR_DUCS_RTRO_FLG Number(6,0) INTEGER NOT NULL DUCS Retro Flag 0 - Retro 1 - Current