GPCN_PHFSI_DTL2

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
3	GPCN_CONTRIB_TYPE	Character(20)	VARCHAR2(20) NOT NULL	Contribution Type
4	GPCN_CONT_METHOD	Character(2)	VARCHAR2(2) NOT NULL	PHF/SI Contribution Method Default Value: 1 Prompt Table: GPCN_CONMT_P_VW
5	GPCN_HUKOU_TYPE	Character(20)	VARCHAR2(20) NOT NULL	Employee Hukou Type Default Value: OTHER Prompt Table: GPCN_HUKOU_P_VW
6	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 Prompt Table: GPCN_ACCTS_P_VW
7	GPCN_ACOUNT_NUM	Character(20)	VARCHAR2(20) NOT NULL	Employee Account Number
8	GPCN_CHANGE_REASON	Character(30)	VARCHAR2(30) NOT NULL	Reason of Account Status change Prompt Table: GPCN_ACCTR_P_VW
9	GPCN_MONTHLY_BASE	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Employee Monthly Base Salary
10	GPCN_TERM_PAY_IND	Character(1)	VARCHAR2(1) NOT NULL	Termination Payroll Indicator Y/N Table Edit