| # |
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_HOUSE_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
PHF Indicator
Y/N Table Edit
|
| 4 |
GPCN_HOUSE_VOL_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
PHF VOL Indicator
Y/N Table Edit
|
| 5 |
GPCN_INJURY_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Injury SI Indicator
Y/N Table Edit
|
| 6 |
GPCN_MATERNITY_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Maternity Indicator
Y/N Table Edit
|
| 7 |
GPCN_MEDICAL_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Medical SI Indicator
Y/N Table Edit
|
| 8 |
GPCN_PENSION_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Pension SI Indicator
Y/N Table Edit
|
| 9 |
GPCN_SUP_MED_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Supplementary Medical Indicator
Y/N Table Edit
|
| 10 |
GPCN_UNEMPLOY_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Unemployment Indicator
Y/N Table Edit
|
| 11 |
GPCN_PHFSI_ALL_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Individual Contribution Values
N=Individual Contribution Values
Y=All Contribution Values
Default Value: Y
|
| 12 |
GPCN_CONT_METHOD |
Character(2) |
VARCHAR2(2) NOT NULL |
PHF/SI Contribution Method
Default Value: 1
Prompt Table:
GPCN_CONMT_P_VW
|
| 13 |
GPCN_HUKOU_TYPE |
Character(20) |
VARCHAR2(20) NOT NULL |
Employee Hukou Type
Default Value: OTHER
Prompt Table:
GPCN_HUKOU_P_VW
|
| 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
Prompt Table:
GPCN_ACCTS_P_VW
|
| 15 |
GPCN_ACOUNT_NUM |
Character(20) |
VARCHAR2(20) NOT NULL |
Employee Account Number
|
| 16 |
GPCN_CHANGE_REASON |
Character(30) |
VARCHAR2(30) NOT NULL |
Reason of Account Status change
Prompt Table:
GPCN_ACCTR_P_VW
|
| 17 |
GPCN_MONTHLY_BASE |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Employee Monthly Base Salary
|
| 18 |
GPCN_TERM_PAY_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Termination Payroll Indicator
Y/N Table Edit
|