GPIT_PCUD_T4 (SQL Table)	Index Back
Final table for CUD form Table which contains the final CUD form for each employee

GPIT_PCUD_T4

(SQL Table)

Final table for CUD form

Table which contains the final CUD form for each employee

# 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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

4 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

5 GPIT_PRD_BGN_DT Date(10) DATE NOT NULL Field for the Previdential CUD Report which contains the begin date of the period of a final CUD form.

6 GPIT_PRD_END_DT Date(10) DATE NOT NULL Field for the Previdential CUD Report which contains the end date of the period of a final CUD form.

7 GPIT_CUD_QUALIF Character(1) VARCHAR2(1) NOT NULL Field for CUD Report

8 GPIT_CUD_TIPOPT Character(1) VARCHAR2(1) NOT NULL Part time code for CUD

9 GPIT_CUD_TIPORAPP Character(1) VARCHAR2(1) NOT NULL Regular/temporary employees for CUD

10 GPIT_CUD_ENTE Character(2) VARCHAR2(2) NOT NULL Field that contains the value of the box 4 related to the Previdential CUD

11 INPS_CODE_ITA Character(12) VARCHAR2(12) NOT NULL INPS Code ITA

12 GPIT_INPS_CDCTR_ID Character(2) VARCHAR2(2) NOT NULL INPS Contribution Code

13 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'

14 ROW_NUM Number(3,0) SMALLINT NOT NULL Row Number

15 GPIT_CUD_EVT_TYPE Character(2) VARCHAR2(2) NOT NULL Field for the Previdential CUD Report which contains the event type for the Section 2 (box 28)

16 NAME Character(50) VARCHAR2(50) NOT NULL Name

17 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group

18 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID

19 GPIT_CUD_BGNDT_SP Date(10) DATE Event start date for CUD form

20 GPIT_CUD_ENDDT_SP Date(10) DATE Event end date for CUD form

21 GPIT_CUD_EVT_AMT Number(19,6) DECIMAL(18,6) NOT NULL Field for the Previdential CUD Report which contains the amount paid related to the event (box 31)

22 GPIT_CUD_EVT_WEEKS Number(3,0) SMALLINT NOT NULL Field for the Previdential CUD Report which contains the number of weeks related to the event (box 32)

#	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	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
4	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
5	GPIT_PRD_BGN_DT	Date(10)	DATE NOT NULL	Field for the Previdential CUD Report which contains the begin date of the period of a final CUD form.
6	GPIT_PRD_END_DT	Date(10)	DATE NOT NULL	Field for the Previdential CUD Report which contains the end date of the period of a final CUD form.
7	GPIT_CUD_QUALIF	Character(1)	VARCHAR2(1) NOT NULL	Field for CUD Report
8	GPIT_CUD_TIPOPT	Character(1)	VARCHAR2(1) NOT NULL	Part time code for CUD
9	GPIT_CUD_TIPORAPP	Character(1)	VARCHAR2(1) NOT NULL	Regular/temporary employees for CUD
10	GPIT_CUD_ENTE	Character(2)	VARCHAR2(2) NOT NULL	Field that contains the value of the box 4 related to the Previdential CUD
11	INPS_CODE_ITA	Character(12)	VARCHAR2(12) NOT NULL	INPS Code ITA
12	GPIT_INPS_CDCTR_ID	Character(2)	VARCHAR2(2) NOT NULL	INPS Contribution Code
13	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'
14	ROW_NUM	Number(3,0)	SMALLINT NOT NULL	Row Number
15	GPIT_CUD_EVT_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Field for the Previdential CUD Report which contains the event type for the Section 2 (box 28)
16	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
17	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
18	ESTABID	Character(12)	VARCHAR2(12) NOT NULL	Establishment ID
19	GPIT_CUD_BGNDT_SP	Date(10)	DATE	Event start date for CUD form
20	GPIT_CUD_ENDDT_SP	Date(10)	DATE	Event end date for CUD form
21	GPIT_CUD_EVT_AMT	Number(19,6)	DECIMAL(18,6) NOT NULL	Field for the Previdential CUD Report which contains the amount paid related to the event (box 31)
22	GPIT_CUD_EVT_WEEKS	Number(3,0)	SMALLINT NOT NULL	Field for the Previdential CUD Report which contains the number of weeks related to the event (box 32)