GPCN_NRP_PSH_AD

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GP_PKG_ID	Character(10)	VARCHAR2(10) NOT NULL	Field used for element packaging
2	PSARCH_ID	Character(8)	VARCHAR2(8) NOT NULL	Archive ID (see PSARCHTEMPLATE).
3	PSARCH_BATCHNUM	Number(30,0)	DECIMAL(30) NOT NULL	Archive Batch Number
4	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
5	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
6	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
7	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
8	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id
9	ORIG_CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Original Calendar Group ID
10	RSLT_SEG_NUM	Number(4,0)	SMALLINT NOT NULL	Result Segment Number
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	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
14	GPCN_ACOUNT_NUM	Character(20)	VARCHAR2(20) NOT NULL	Employee Account Number
15	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
16	GPCN_CHANGE_REASON	Character(30)	VARCHAR2(30) NOT NULL	Reason of Account Status change
17	GPCN_HUKOU_TYPE	Character(20)	VARCHAR2(20) NOT NULL	Employee Hukou Type
18	GPCN_MONTHLY_BASE	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Employee Monthly Base Salary
19	GPCN_PREV_AVG_SAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Employee Average Monthly Salary for Previous Year
20	GPCN_CONT_BASE_ER	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Employer Contribution base
21	GPCN_CONT_PCT_ER	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Employer Contribution Percentage
22	GPCN_CONT_BASE_EE	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Employee Contribution Base
23	GPCN_CONT_PCT_EE	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Employee Contribution Percentage
24	GPCN_CONT_AMT_EE	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Employee Contribution Amount
25	GPCN_CONT_AMT_ER	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Employer Contribution Amount
26	GPCN_CONT_TOT_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Total Contribution Amount
27	GPCN_CONT_ADJ_EE	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Employee Contribution Adjustment
28	GPCN_CONT_ADJ_ER	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Employer Contribution Adjustment
29	GPCN_CONT_METHOD	Character(2)	VARCHAR2(2) NOT NULL	PHF/SI Contribution Method
30	GPCN_START_DT	Date(10)	DATE	Start Date
31	GPCN_TER_DATE	Date(10)	DATE	Termination date for PHF/SI Contribution
32	GPCN_PHFSI_PRBN_YN	Character(1)	VARCHAR2(1) NOT NULL	Indicates whether or not PHFSI deductions should be paid whilst an employee is on probation
33	GPCN_PHFSI_TERM_YN	Character(1)	VARCHAR2(1) NOT NULL	Indicates whether or not PHFSI deductions should be paid whilst an employee is on termination