GPDE_SI_CAT_NEG

(SQL Table)
Index Back

Negative List for EE Category

This table contains a list of combinations that are illegal.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

2 GPDE_DV_EMPL_CAT Character(3) VARCHAR2(3) NOT NULL Employee Category
101=Regular SI Taxable
102=Apprentice
103=Old-Age Part Time
104=Consultant
105=Trainee
106=Student Trainee
107=Disabled
108=Early Retirement
109=Low Income Earner
110=Short-Term Employment
111=EE in Rehabilitation
112=Family member in agriculture
113=Part-time Farmer
114=PT Farmer, seasonal
116=FEI Compensation Receiver
118=Casual Worker
119=Old Age Pensioner
120=Pretended Freelancer
190=Insured only for Accident Ins
900=Public Servant
901=Managing Partner
903=Health Insured Pensioner
910=SI free Employee
3 GPDE_SI_STATUS_KV Character(1) VARCHAR2(1) NOT NULL Contribution Group
4 GPDE_SI_STATUS_PV Character(1) VARCHAR2(1) NOT NULL Contribution Group
5 GPDE_SI_STATUS_RV Character(1) VARCHAR2(1) NOT NULL Contribution Group
6 GPDE_SI_STATUS_AV Character(1) VARCHAR2(1) NOT NULL Contribution Group