GPS_PSTPLN_R_VW(SQL View) |
Index Back |
---|---|
Post Plan RowPost 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 |