| # |
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: GPCN_PHFSI_SET1.EFFDT
|
| 3 |
GPCN_PHFSI_ALL_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Individual Contribution Values
N=Individual Contribution Values
Y=All Contribution Values
Default Value: N
|
| 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
|