GPIT_PCUD_I2

(SQL Table)
Index Back

Intermediate table for S.S.CUD

Intermediate table for Social Security CUD Report which contains all keys for the final CUD forms.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
5 GPIT_CUD_QUALIF Character(1) VARCHAR2(1) NOT NULL Field for CUD Report
6 GPIT_CUD_TIPOPT Character(1) VARCHAR2(1) NOT NULL Part time code for CUD
7 GPIT_CUD_TIPORAPP Character(1) VARCHAR2(1) NOT NULL Regular/temporary employees for CUD
8 GPIT_CUD_ENTE Character(2) VARCHAR2(2) NOT NULL Field that contains the value of the box 4 related to the Previdential CUD
9 INPS_CODE_ITA Character(12) VARCHAR2(12) NOT NULL INPS Code ITA
10 GPIT_INPS_CDCTR_ID Character(2) VARCHAR2(2) NOT NULL INPS Contribution Code
11 GPIT_EVT_TYPE Character(2) VARCHAR2(2) NOT NULL Field for the Previdential CUD Report which is used to save the value of special payment in case of 'AS' or 'AE'
12 ROW_NUM Number(3,0) SMALLINT NOT NULL Row Number