GPIT_RP_0001

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
4	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
5	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id
6	ORIG_CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Original Calendar Group ID
7	RSLT_SEG_NUM	Number(4,0)	SMALLINT NOT NULL	Result Segment Number
8	SLICE_END_DT	Date(10)	DATE	Element Slice End Date
9	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code
10	SLICE_BGN_DT	Date(10)	DATE	Element Slice Begin Date
11	SEG_END_DT	Date(10)	DATE	Payee Process Segment's End Date
12	SEG_BGN_DT	Date(10)	DATE	Payee Process Segment's Begin Date
13	PRD_END_DT	Date(10)	DATE	Pay Period End Date
14	GPIT_AL_CPAY_ENDDT	Date(10)	DATE	Current Pay End Date
15	PRD_BGN_DT	Date(10)	DATE	Period Begin Date
16	PYMT_DT	Date(10)	DATE	Payment Date
17	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
18	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
19	COMP_CODE_ITA	Character(30)	VARCHAR2(30) NOT NULL	Company Codes ITA
20	INAIL_CODE	Character(11)	VARCHAR2(11) NOT NULL	INAIL Code
21	INPS_CODE_ITA	Character(12)	VARCHAR2(12) NOT NULL	INPS Code ITA
22	INPDAI_CODE_ITA	Character(16)	VARCHAR2(16) NOT NULL	INPDAI Code ITA
23	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
24	ESTABID	Character(12)	VARCHAR2(12) NOT NULL	Establishment ID
25	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
26	ACTION	Character(3)	VARCHAR2(3) NOT NULL	Action
27	REASON	Character(30)	VARCHAR2(30) NOT NULL	Reason
28	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
29	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
30	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
31	MATRICULA_NBR_ITA	Number(6,0)	INTEGER NOT NULL	Matricula Number ITA
32	NATIONAL_ID	Character(20)	VARCHAR2(20) NOT NULL	National ID
33	SAL_ADMIN_PLAN	Character(4)	VARCHAR2(4) NOT NULL	Salary Administration Plan
34	GRADE	Character(3)	VARCHAR2(3) NOT NULL	Salary Grade
35	STEP	Number(2,0)	SMALLINT NOT NULL	Step
36	LABOR_AGREEMENT	Character(6)	VARCHAR2(6) NOT NULL	Labor Agreement
37	STD_HOURS	Number(7,2)	DECIMAL(6,2) NOT NULL	Standard Hours
38	EMPL_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Payroll Status A=Active D=Deceased L=Leave of Absence P=Leave With Pay Q=Retired With Pay R=Retired S=Suspended T=Terminated U=Terminated With Pay V=Terminated Pension Pay Out W=Short Work Break X=Retired-Pension Administration
39	EMPL_CTG	Character(6)	VARCHAR2(6) NOT NULL	Employee Category
40	EMPL_CTG_L1	Character(6)	VARCHAR2(6) NOT NULL	Employee Subcategory
41	EMPL_CLASS	Character(3)	VARCHAR2(3) NOT NULL	Employee Classification
42	JOB_ENTRY_DT	Date(10)	DATE	Job Entry Date
43	HIRE_DT	Date(10)	DATE	First Start Date
44	TERMINATION_DT	Date(10)	DATE	Termination Date
45	GPIT_NEXT_SEN_INCR	Date(10)	DATE	Next seniority increase date for reports
46	BIRTHDATE	Date(10)	DATE	Date of Birth
47	MAR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Marital Status C=Common-Law D=Divorced E=Separated H=Head of Household L=DissDeclLost Civil Partner M=Married P=Civil Partnership S=Single T=Surviving Civil Partner U=Unknown V=Dissolved Civil Partnership W=Widowed
48	SEX	Character(1)	VARCHAR2(1) NOT NULL	Gender F=Female M=Male U=Unknown X=Indeterminate/Intersex/Unspec
49	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
50	FTE	Number(8,6)	DECIMAL(7,6) NOT NULL	This field represent Full Time Equivalence
51	NATIONALITY_CD	Character(3)	VARCHAR2(3) NOT NULL	Nationality Code
52	NATIONALITY	Character(30)	VARCHAR2(30) NOT NULL	Nationality
53	SETID_DEPT	Character(5)	VARCHAR2(5) NOT NULL	Department SetID
54	SETID_LOCATION	Character(5)	VARCHAR2(5) NOT NULL	Location SetID
55	GPIT_GG_INPS	Number(2,0)	SMALLINT NOT NULL	INPS days for reports
56	GPIT_SETT_INPS	Number(1,0)	SMALLINT NOT NULL	INPS weeks for reports
57	PART_TIME_PERC_ITA	Number(8,4)	DECIMAL(7,4) NOT NULL	Percentage of Part Time
58	GPIT_ANF_TABLE	Character(3)	VARCHAR2(3) NOT NULL	Inps Table Number
59	GPIT_ANF_COMP	Number(2,0)	SMALLINT NOT NULL	ANF family component for reports
60	GPIT_ANF_CLASS	Number(2,0)	SMALLINT NOT NULL	ANF class for reports
61	GPIT_PAYMENT_METH	Character(18)	VARCHAR2(18) NOT NULL	Payment method for reports
62	GPIT_BANK_ABI	Character(5)	VARCHAR2(5) NOT NULL	ABI code for reports
63	GPIT_BANK_CAB	Character(5)	VARCHAR2(5) NOT NULL	CAB code for reports
64	GPIT_CUD_CITY	Character(30)	VARCHAR2(30) NOT NULL	City for CUD
65	GPIT_CUD_STATE	Character(6)	VARCHAR2(6) NOT NULL	State for CUD
66	GPIT_CUD_FISCOK	Number(1,0)	SMALLINT NOT NULL	Fiscal part of CUD
67	GPIT_CUD_PREVOK	Number(1,0)	SMALLINT NOT NULL	Contribution part for CUD
68	GPIT_INPS_CAT_ID	Character(1)	VARCHAR2(1) NOT NULL	INPS Category
69	GPIT_CUD_TIPOPT	Character(1)	VARCHAR2(1) NOT NULL	Part time code for CUD
70	GPIT_CUD_TIPORAPP	Character(1)	VARCHAR2(1) NOT NULL	Regular/temporary employees for CUD
71	GPIT_INPS_CDCTR_ID	Character(2)	VARCHAR2(2) NOT NULL	INPS Contribution Code
72	GPIT_INPS_ASSCOP	Number(2,0)	SMALLINT NOT NULL	Useful insurances
73	ACCOUNT_EC_ID	Character(35)	VARCHAR2(35) NOT NULL	Account Number used in banking.
74	BIRTHPLACE	Character(30)	VARCHAR2(30) NOT NULL	Birth Location
75	BIRTHSTATE	Character(6)	VARCHAR2(6) NOT NULL	Birth State
76	BIRTHCOUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Birth Country
77	GPIT_PYSL_DATEH1	Date(10)	DATE	dummy date
78	GPIT_PYSL_CHARH1	Character(20)	VARCHAR2(20) NOT NULL	Dummy character
79	GPIT_PYSL_AMTH8	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Dummy number
80	GPIT_PYSL_AMTH9	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Dummy number
81	GPIT_CITY_CODE	Character(4)	VARCHAR2(4) NOT NULL	City code payee
82	GPIT_TYPE_1_HIR	Character(2)	VARCHAR2(2) NOT NULL	Type
83	GPIT_TYPE_2_TER	Character(2)	VARCHAR2(2) NOT NULL	Type
84	GPIT_AMOUNT_N9	Number(9,0)	DECIMAL(9) NOT NULL	Amount
85	GPIT_WEEK1	Number(2,0)	SMALLINT NOT NULL	Week
86	GPIT_WEEK2	Number(2,0)	SMALLINT NOT NULL	Week