GPIT_CTRRP_TMP1

(SQL Table)
Index Back

Contribution Report Record

Contribution Report Record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
3 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
4 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID
5 INPS_POS_CD_ITA Character(4) VARCHAR2(4) NOT NULL INPS Position Code ITA
6 GPIT_INPS_CAT_ID Character(1) VARCHAR2(1) NOT NULL INPS Category
7 GPIT_INPS_CDCTR_ID Character(2) VARCHAR2(2) NOT NULL INPS Contribution Code
8 GPIT_SECTION_ID Character(16) VARCHAR2(16) NOT NULL Section ID
9 GPIT_SEQ_NUM2 Number(3,0) SMALLINT NOT NULL Sequence Number
10 GPIT_SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence Number
11 GPIT_SECTION_TYPE Character(1) VARCHAR2(1) NOT NULL Section Type
E=Employer + Employee Contrib.
G=General
12 DESCR Character(30) VARCHAR2(30) NOT NULL Description
13 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr
14 GPIT_SIGN Character(1) VARCHAR2(1) NOT NULL Sign
A=Add
S=Subtract
15 GPIT_PIN_NUM Number(8,0) INTEGER NOT NULL Pin Number
16 BASE_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculated Base Value
17 CALC_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
18 CALC_ADJ_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Adjustment Value
19 BASE_ADJ_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Base Adjustment