GPS_PSTPLN_R_VW

(SQL View)
Index Back

Post Plan Row

Post Plan Row

SELECT R.SETID , R.YEAR , R.GPS_POST_PLN_TYPE , R.GPS_ROWID , R.GPS_GRADE , R.GPS_RANK , R.GPS_POST_TYPE , R.GPS_ALLOWANCE , R.GPS_PLN_STATUS , R.STATUS_DT , R.GPS_IN_BEHALF_OF , R.GPS_TARGET_SOLL , R.GPS_TGTSOLL_SRC_YR , R.GPS_KU_ID , R.GPS_KW_ID , R.GPS_POST_AVERAGE , R.GPS_ROW_ORIG_FLG , R.GPS_DESCR1 , R.GPS_DESCR2 , R.LASTUPDOPRID , R.LASTUPDDTTM ,I.GPS_TYPE_AVAILABLE FROM PS_GPS_POSTPLN_ROW R , PS_GPS_POSTTYP_TBL I WHERE I.SETID = R.SETID AND I.GPS_POST_TYPE = R.GPS_POST_TYPE AND I.GPS_BDG_SYSTEM = %TrimSubstr(R.GPS_ROWID, 1, 1) AND I.EFFDT = ( SELECT MAX(EFFDT) FROM PS_GPS_POSTTYP_TBL SUB WHERE SUB.SETID = R.SETID AND I.GPS_BDG_SYSTEM = SUB.GPS_BDG_SYSTEM AND I.GPS_POST_TYPE = SUB.GPS_POST_TYPE AND SUB.EFFDT <= %CurrentDateIn)

# 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_02

2 YEAR Character(4) VARCHAR2(4) NOT NULL Character field to represent a year
3 GPS_POST_PLN_TYPE Character(1) VARCHAR2(1) NOT NULL Post Plan TYpe
0=Base Plan
1=1. Amendment Plan
2=2. Amendment Plan
3=3. Amendment Plan
4=4. Amendment Plan
4 GPS_ROWID Character(45) VARCHAR2(45) NOT NULL RowID, a condensed version of the key fields of a budgeting system
5 GPS_GRADE Character(8) VARCHAR2(8) NOT NULL Salary Grade.

Prompt Table: %EDITTABLE5

6 GPS_RANK Character(15) VARCHAR2(15) NOT NULL Rank for GPS

Prompt Table: %EDITTABLE11

7 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)
8 GPS_ALLOWANCE Character(1) VARCHAR2(1) NOT NULL allowance Flag

Y/N Table Edit

Default Value: N

9 GPS_PLN_STATUS Character(4) VARCHAR2(4) NOT NULL Plan Status
ACTV=Active Plan
APPR=Approved Plan
CHNG=Changed
CLNP=Plan in Clean-Up Phase
CLSD=Plan Closed
COPY=Copied Plan
DENY=Denied
DONE=Clean-Up Done
NEW=New Plan

Default Value: NEW

10 STATUS_DT Date(10) DATE NOT NULL Status Date

Default Value: %date

11 GPS_IN_BEHALF_OF Number(15,0) DECIMAL(15) NOT NULL On Behalf Of

Prompt Table: GPS_IN_BEHALF

12 GPS_TARGET_SOLL Signed Number(10,2) DECIMAL(8,2) NOT NULL plan soll
13 GPS_TGTSOLL_SRC_YR Signed Number(10,2) DECIMAL(8,2) NOT NULL plan soll as taken over from source plan.

Default Value: 0

14 GPS_KU_ID Number(7,0) INTEGER NOT NULL KU Remark
15 GPS_KW_ID Number(7,0) INTEGER NOT NULL KW Remark Stellenvermerk
16 GPS_POST_AVERAGE Signed Number(10,2) DECIMAL(8,2) NOT NULL GPS Post Average (statistical field that is used to identify a post plan row to be used for statistical purposes)
17 GPS_ROW_ORIG_FLG Character(1) VARCHAR2(1) NOT NULL GPS flag indicating in what phase the post plan row was created. (Planning/Administration). Can have two values P = planning, A = administration
A=in Administration
P=in Planning

Default Value: P

18 GPS_DESCR1 Character(50) VARCHAR2(50) NOT NULL Description 1
19 GPS_DESCR2 Character(50) VARCHAR2(50) NOT NULL Description 2
20 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
21 LASTUPDDTTM DateTime(26) TIMESTAMP NOT NULL Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

Default Value: %datetime

22 GPS_TYPE_AVAILABLE Character(1) VARCHAR2(1) NOT NULL Post Type availability. Through which phases a post type is available.
1=Planning Phase
2=Administration Phase
3=Both