GPCN_RSLT_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 Prompt Table: PERSON_NAME
3	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
4	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
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	GPCN_CONTRIB_AREA	Character(30)	VARCHAR2(30) NOT NULL	Contribution Area
12	GPCN_CONTRIB_TYPE	Character(20)	VARCHAR2(20) NOT NULL	Contribution Type
13	GPCN_ACOUNT_NUM	Character(20)	VARCHAR2(20) NOT NULL	Employee Account Number
14	GPCN_ACNT_STATUS	Character(25)	VARCHAR2(25) NOT NULL	Account Status 01=New Enrollment 02=Transfer-in from same district 03=Transfer from same admin area 04=Transfer from diff admin area 05=Rejoin 06=Retire 07=Transfer to same admin area 08=Transfer to diff admin area 09=End of Employment Contract 10=Death of Employee 11=Others
15	GPCN_CHANGE_REASON	Character(30)	VARCHAR2(30) NOT NULL	Reason of Account Status change
16	GPCN_HUKOU_TYPE	Character(20)	VARCHAR2(20) NOT NULL	Employee Hukou Type
17	GPCN_MONTHLY_BASE	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Employee Monthly Base Salary
18	GPCN_PREV_AVG_SAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Employee Average Monthly Salary for Previous Year
19	GPCN_CONT_PCT_ER	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Employer Contribution Percentage
20	GPCN_CONT_BASE_ER	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Employer Contribution base
21	GPCN_CONT_BASE_EE	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Employee Contribution Base
22	GPCN_CONT_PCT_EE	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Employee Contribution Percentage
23	GPCN_CONT_AMT_EE	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Employee Contribution Amount
24	GPCN_CONT_AMT_ER	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Employer Contribution Amount
25	GPCN_CONT_TOT_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Total Contribution Amount
26	GPCN_CONT_ADJ_EE	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Employee Contribution Adjustment
27	GPCN_CONT_ADJ_ER	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Employer Contribution Adjustment