EMPL_CTG_L1_GPS (SQL Table)	Index Back
GPS Employee Category Stores Employee Category attributes that are specific to the German Public Sector.

EMPL_CTG_L1_GPS

(SQL Table)

GPS Employee Category

Stores Employee Category attributes that are specific to the German Public Sector.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: OPR_DEF_TBL_HR.SETID
Prompt Table: SET_VLD_HR_14

2 LABOR_AGREEMENT Character(6) VARCHAR2(6) NOT NULL Labor Agreement
Prompt Table: EMPL_CTG

3 EMPL_CTG Character(6) VARCHAR2(6) NOT NULL Employee Category
Prompt Table: EMPL_CTG_L1

4 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

5 GPS_EMP_CTGRY_TYPE Character(1) VARCHAR2(1) NOT NULL Employee Category Type is an indicator used to determine whether certain GPS attributes are applicable, such as probation periods, pre-service periods, GPS jobs, case group and BDA date.
A=Apprentice
B=Blue Collar Worker
C=Civil Servant on Tenure
I=Judge per Instruction
J=Judge on Probation
O=Other
P=Civil Servant on Probation
R=Civil Servant on Recall
S=Public Sector Employee
T=Trainee
U=Judge on Tenure
V=Civil Servant in Retirement
W=White Collar Worker
Default Value: O

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_HR.SETID Prompt Table: SET_VLD_HR_14
2	LABOR_AGREEMENT	Character(6)	VARCHAR2(6) NOT NULL	Labor Agreement Prompt Table: EMPL_CTG
3	EMPL_CTG	Character(6)	VARCHAR2(6) NOT NULL	Employee Category Prompt Table: EMPL_CTG_L1
4	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
5	GPS_EMP_CTGRY_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Employee Category Type is an indicator used to determine whether certain GPS attributes are applicable, such as probation periods, pre-service periods, GPS jobs, case group and BDA date. A=Apprentice B=Blue Collar Worker C=Civil Servant on Tenure I=Judge per Instruction J=Judge on Probation O=Other P=Civil Servant on Probation R=Civil Servant on Recall S=Public Sector Employee T=Trainee U=Judge on Tenure V=Civil Servant in Retirement W=White Collar Worker Default Value: O