GP_EPM_GUI_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	ORIG_CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Original Calendar Group ID
8	RSLT_SEG_NUM	Number(4,0)	SMALLINT NOT NULL	Result Segment Number
9	GP_RPT_KEY	Character(22)	VARCHAR2(22) NOT NULL	Output Result Key
10	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
11	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
12	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
13	RUN_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Run Type Name
14	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
15	PYMT_DT	Date(10)	DATE	Payment Date
16	PRD_BGN_DT	Date(10)	DATE	Period Begin Date
17	PRD_END_DT	Date(10)	DATE	Pay Period End Date
18	SEG_BGN_DT	Date(10)	DATE	Payee Process Segment's Begin Date
19	SEG_END_DT	Date(10)	DATE	Payee Process Segment's End Date
20	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
21	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
22	ESTABID	Character(12)	VARCHAR2(12) NOT NULL	Establishment ID
23	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract Number
24	SETID_DEPT	Character(5)	VARCHAR2(5) NOT NULL	Department SetID
25	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
26	SETID_LOCATION	Character(5)	VARCHAR2(5) NOT NULL	Location SetID
27	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
28	EMPL_CTG	Character(6)	VARCHAR2(6) NOT NULL	Employee Category