GPDE_SI_BA_CHK (SQL Table)	Index Back
Validation BA Code Validation BA Code. The table contains all combinations of the fields - Employee Category - BA Code that are valid for an EE's SI data. The table is effective dated. If one of the fields contains no value (is blank) then all possible values are permitted. For multiple blank values all combinations are permitted. This wildcard logic is implemented by the view GPDE_SI_BA_VW, which is used for prompting on the EE SI Data page.

GPDE_SI_BA_CHK

(SQL Table)

Validation BA Code

Validation BA Code. The table contains all combinations of the fields - Employee Category - BA Code that are valid for an EE's SI data. The table is effective dated. If one of the fields contains no value (is blank) then all possible values are permitted. For multiple blank values all combinations are permitted. This wildcard logic is implemented by the view GPDE_SI_BA_VW, which is used for prompting on the EE SI Data page.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EFFDT Date(10) DATE 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 BA_CD Character(5) VARCHAR2(5) NOT NULL BA Code

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EFFDT	Date(10)	DATE	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	BA_CD	Character(5)	VARCHAR2(5) NOT NULL	BA Code