GPS_POSTTYP_DTL (SQL Table)	Index Back
Post Type Definition and Mappi Post Type definition and Mapping Table

GPS_POSTTYP_DTL

(SQL Table)

Post Type Definition and Mappi

Post Type definition and Mapping Table

# 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

2 GPS_BDG_SYSTEM Character(1) VARCHAR2(1) NOT NULL Budgeting System
D=Doppik
K=Kameralistik
O=Other

3 GPS_POST_TYPE Character(3) VARCHAR2(3) NOT NULL Post Type
AND=Other (Civil Service)
ANE=Other (Employee)
ANG=Public Sector Employee
ANW=Civil Servant on Recall
AZU=Apprentice
BEA=Civil Servant
ERE=Replacement Post (Employee)
ERS=Replacement Post (Civil Serv.)
LEB=Empty Post (Civil Service)
LEE=Empty Post (Employee)

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

5 GPS_VALUE Character(8) VARCHAR2(8) NOT NULL Value
Prompt Table: GPS_ORG_DVW2

#	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
2	GPS_BDG_SYSTEM	Character(1)	VARCHAR2(1) NOT NULL	Budgeting System D=Doppik K=Kameralistik O=Other
3	GPS_POST_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Post Type AND=Other (Civil Service) ANE=Other (Employee) ANG=Public Sector Employee ANW=Civil Servant on Recall AZU=Apprentice BEA=Civil Servant ERE=Replacement Post (Employee) ERS=Replacement Post (Civil Serv.) LEB=Empty Post (Civil Service) LEE=Empty Post (Employee)
4	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
5	GPS_VALUE	Character(8)	VARCHAR2(8) NOT NULL	Value Prompt Table: GPS_ORG_DVW2