GPDE_SI_POS_LNG (SQL View)	Index Back
Prompt Position In Job Prompt Position In Job

GPDE_SI_POS_LNG

(SQL View)

Prompt Position In Job

SELECT A.EFFDT , A.GPDE_DV_EMPL_CAT , A.GPDE_SI_STATUS_RV , A.GPDE_SI_POS_IN_JOB , X.LANGUAGE_CD , X.XLATLONGNAME FROM PS_GPDE_SI_POS_VW A , PSXLATITEMLANG X WHERE X.FIELDNAME = 'GPDE_SI_POS_IN_JOB' AND X.FIELDVALUE = A.GPDE_SI_POS_IN_JOB

Related Language Record for GPDE_SI_POS_VW

# 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 GPDE_SI_STATUS_RV Character(1) VARCHAR2(1) NOT NULL Contribution Group

4 GPDE_SI_POS_IN_JOB Character(1) VARCHAR2(1) NOT NULL Position
0=0 Apprentice
1=1 Blue Collar, non prof
2=2 Blue Collar Prof
3=3 BC Foreman
4=4 White Collar
5=5 Disabled
6=6 Rehabilitation
7=7 Homeworker;domestic business
8=8 Part Time < 18 Hrs.
9=9 Part Time >= 18 Hrs.

5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

6 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	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	GPDE_SI_STATUS_RV	Character(1)	VARCHAR2(1) NOT NULL	Contribution Group
4	GPDE_SI_POS_IN_JOB	Character(1)	VARCHAR2(1) NOT NULL	Position 0=0 Apprentice 1=1 Blue Collar, non prof 2=2 Blue Collar Prof 3=3 BC Foreman 4=4 White Collar 5=5 Disabled 6=6 Rehabilitation 7=7 Homeworker;domestic business 8=8 Part Time < 18 Hrs. 9=9 Part Time >= 18 Hrs.
5	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
6	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description