GPDE_SI_CAT_NEG(SQL Table) |
Index Back |
---|---|
Negative List for EE CategoryThis 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 |