| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PERSON
|
| 2 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Record
|
| 3 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: EMPLOYMENT.HIRE_DT
|
| 4 |
GPDE_SI_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
SI Coverage Type
01=Health Insurance
02=Nursing Care Insurance
03=Old Age Pension Insurance
04=Unemployment Insurance
|
| 5 |
GPDE_SI_COVERAGE |
Character(1) |
VARCHAR2(1) NOT NULL |
Insurance Coverage Type
0=None
1=Mandatory
2=Voluntary
3=Private
|
| 6 |
GPDE_SI_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Contribution Group
Default Value: 0
Prompt Table:
GPDE_SI_STA_VW
|
| 7 |
GPDE_SI_REGION |
Character(1) |
VARCHAR2(1) NOT NULL |
Region
0=General
1=East
2=West
Default Value: 2
Prompt Table:
GPDE_SI_REG_VW
|
| 8 |
GPDE_SI_PROV |
Character(8) |
VARCHAR2(8) NOT NULL |
Social Insurance Provider
Prompt Table:
%EDITTABLE
|
| 9 |
GPDE_SI_RATE_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Calculation Rate
Prompt Table:
GPDE_SI_STRT_VW
|
| 10 |
GPDE_SI_TOTAL_COST |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
Total Computed Cost
|
| 11 |
GPDE_SI_EE_COST |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Employee Contribution
|
| 12 |
GPDE_SI_ER_COST |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Employer Contribution
|
| 13 |
GPDE_TX_FREE_AMT |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Maximum Taxfree Amount
|
| 14 |
GPDE_SI_TAKE_DED |
Character(1) |
VARCHAR2(1) NOT NULL |
Employer Remits to Provider
Y/N Table Edit
Default Value: N
|
| 15 |
GPDE_SI_PRIM_PROV |
Character(1) |
VARCHAR2(1) NOT NULL |
Primary Provider
Y/N Table Edit
Default Value: N
|
| 16 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 17 |
GPDE_SI_PV_CHILD |
Character(1) |
VARCHAR2(1) NOT NULL |
Children for PV Calculation
Y/N Table Edit
Default Value: N
|