GPTH_ITF_TMP

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
4	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
5	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
6	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id
7	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
8	USER_KEY1	Character(25)	VARCHAR2(25) NOT NULL	User Key 1
9	USER_KEY2	Character(25)	VARCHAR2(25) NOT NULL	User Key 2
10	USER_KEY3	Character(25)	VARCHAR2(25) NOT NULL	User Key 3
11	USER_KEY4	Character(25)	VARCHAR2(25) NOT NULL	User Key 4
12	USER_KEY5	Character(25)	VARCHAR2(25) NOT NULL	User Key 5
13	USER_KEY6	Character(25)	VARCHAR2(25) NOT NULL	User Key 6
14	NAME_PREFIX	Character(4)	VARCHAR2(4) NOT NULL	Name Prefix
15	GPTH_NAME1	Character(80)	VARCHAR2(80) NOT NULL	Tax-Payee's First Name
16	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
17	MIDDLE_NAME	Character(30)	VARCHAR2(30) NOT NULL	MIDDLE_NAME
18	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
19	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
20	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
21	ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address 2
22	ADDRESS3	Character(55)	VARCHAR2(55) NOT NULL	Address 3
23	ADDRESS4	Character(55)	VARCHAR2(55) NOT NULL	Address 4
24	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
25	COUNTY	Character(30)	VARCHAR2(30) NOT NULL	County
26	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: STATE_TBL
27	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
28	NATIONAL_ID	Character(20)	VARCHAR2(20) NOT NULL	National ID
29	GPTH_PER_TAX_ID	Character(20)	VARCHAR2(20) NOT NULL	Person Tax ID
30	PYMT_DT	Date(10)	DATE	Payment Date
31	PRD_BGN_DT	Date(10)	DATE	Period Begin Date
32	PRD_END_DT	Date(10)	DATE	Pay Period End Date
33	ACM_FROM_DT	Date(10)	DATE	From Date
34	ACM_THRU_DT	Date(10)	DATE	Through Date
35	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
36	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
37	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
38	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
39	ESTABID	Character(12)	VARCHAR2(12) NOT NULL	Establishment ID
40	SETID_DEPT	Character(5)	VARCHAR2(5) NOT NULL	Department SetID
41	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
42	SETID_LOCATION	Character(5)	VARCHAR2(5) NOT NULL	Location SetID
43	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
44	GPTH_GOV	Character(1)	VARCHAR2(1) NOT NULL	This field represents that if the report is an Government report
45	GPTH_SEQ_NUM	Character(6)	VARCHAR2(6) NOT NULL	Sequence number for tax report
46	GPTH_TAX_ID	Character(10)	VARCHAR2(10) NOT NULL	Tax identification number
47	GPTH_TAX_BRANCH	Character(4)	VARCHAR2(4) NOT NULL	Tax branch number
48	GPTH_TAX_ID_L	Character(13)	VARCHAR2(13) NOT NULL	Tax identification number 13
49	CALC_RSLT_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Calculation Numeric Result
50	PIN_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Element Type
51	PIN_NM	Character(18)	VARCHAR2(18) NOT NULL	Element Name field
52	PIN_CODE	Character(22)	VARCHAR2(22) NOT NULL	Unique identifier of a PIN (alternate to PIN number). critical for use in merging packages of elements from one database onto another when PINs may or may not be renumbered as they are moved across. Constructed from PIN_NM + COUNTRY of the element definition (GP_PIN)
53	PIN_CUSTOM1	Character(20)	VARCHAR2(20) NOT NULL	Customer FIelds
54	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
55	SEQ_NUM8	Number(8,0)	INTEGER NOT NULL	Sequence Number