GPFR_DUCS_SUM

(SQL Table)
Index Back

TRC Urssaf Monthly Summary

TRC Urssaf Monthly Summary

# 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_DUCS_REFPER Character(6) VARCHAR2(6) NOT NULL TRC Reference Period
7 GPFR_DUCS_REG_FLG Character(1) VARCHAR2(1) NOT NULL DUCS Regularization Flag

Y/N Table Edit

Default Value: N

8 GPFR_DUCS_R3_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 1 for the EN3 DUCS Record. Used in the SUM record.
9 GPFR_DUCS_R3_CUR Character(3) VARCHAR2(3) NOT NULL GPFR: Currency
10 GPFR_DUCS_NUMBER2 Number(10,0) DECIMAL(10) NOT NULL DUCS Process Instance
11 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance