GPDE_SI_STAT_RT

(SQL Table)
Index Back

SI Rate Code

SI Rate Code per branch and contribution group

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 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
2 EFFDT Date(10) DATE NOT NULL Effective Date
3 GPDE_SI_STATUS Character(1) VARCHAR2(1) NOT NULL Contribution Group
4 GPDE_SI_RATE_CD Character(3) VARCHAR2(3) NOT NULL Calculation Rate

Prompt Table: GPDE_SI_RATE_CD

5 DEFAULT_FLAG Character(1) VARCHAR2(1) NOT NULL Set As Default
N=No
Y=Yes

Y/N Table Edit

Default Value: N