GPS_PLN_DTL_VW (SQL View)	Index Back
GPS Planing Details View Flattended out view that retrieves information to a post plan and its post plan details

GPS_PLN_DTL_VW

(SQL View)

GPS Planing Details View

Flattended out view that retrieves information to a post plan and its post plan details

SELECT A.SETID , A.YEAR , A.GPS_POST_PLN_TYPE , A.GPS_ROWID , A.GPS_GRADE , A.GPS_RANK , A.GPS_POST_TYPE , A.GPS_ACTION , A.SEQUENCE , A.GPS_DEPT_TGT , A.GPS_FRACTION , A.STATUS , A.GPS_NUMBER , A.GPS_NBR_DONE , B.GPS_BDG_ORG1 , B.GPS_BDG_ORG2 , B.GPS_BDG_ORG3 , B.GPS_BDG_ORG4 , B.GPS_BDG_ORG5 , A.GPS_ROWID_TGT , A.GPS_BDG_ORG1_TGT , A.GPS_BDG_ORG2_TGT , A.GPS_BDG_ORG3_TGT , A.GPS_BDG_ORG4_TGT , A.GPS_BDG_ORG5_TGT , A.GPS_POST_TYPE_TGT , A.GPS_SETID_TGT , A.GPS_GRADE_TGT , A.GPS_RANK_TGT FROM PS_GPS_POSTPLN_DTL A , PS_GPS_POSTPLN_TBL B WHERE A.SETID = B.SETID AND A.YEAR = B.YEAR AND A.GPS_POST_PLN_TYPE = B.GPS_POST_PLN_TYPE AND A.GPS_ROWID = B.GPS_ROWID

# 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
Default Value: 0

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.

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

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_ACTION Character(8) VARCHAR2(8) NOT NULL Action as executed on GPS Post
Prompt Table: GPS_ACTION_VW

9 SEQUENCE Number(2,0) SMALLINT NOT NULL Chartfield Sequence
Default Value: 1

10 GPS_DEPT_TGT Character(10) VARCHAR2(10) NOT NULL Target department
Prompt Table: DEPT_TBL

11 GPS_FRACTION Number(9,2) DECIMAL(8,2) NOT NULL GPS Fraction

12 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
A=Active
I=Inactive
Default Value: A

13 GPS_NUMBER Number(6,0) INTEGER NOT NULL GPS Amount of Posts to create
Default Value: 1

14 GPS_NBR_DONE Number(6,0) INTEGER NOT NULL GPS number of planning instructions done in clean-up phase
Default Value: 0

15 GPS_BDG_ORG1 Character(8) VARCHAR2(8) NOT NULL Budgeting Organization
Prompt Table: GPS_ORG_DVW

16 GPS_BDG_ORG2 Character(8) VARCHAR2(8) NOT NULL Budgeting Organization
Prompt Table: %EDITTABLE

17 GPS_BDG_ORG3 Character(8) VARCHAR2(8) NOT NULL Budgeting Organization
Prompt Table: %EDITTABLE2

18 GPS_BDG_ORG4 Character(8) VARCHAR2(8) NOT NULL Budgeting Organization
Prompt Table: %EDITTABLE3

19 GPS_BDG_ORG5 Character(8) VARCHAR2(8) NOT NULL Budgeting Organization
Prompt Table: %EDITTABLE4

20 GPS_ROWID_TGT Character(45) VARCHAR2(45) NOT NULL RowID, a condensed version of the key fields of a budgeting system

21 GPS_BDG_ORG1_TGT Character(8) VARCHAR2(8) NOT NULL Budgeting Organization - Public Sector Germany
Prompt Table: GPS_ORG_DVW

22 GPS_BDG_ORG2_TGT Character(8) VARCHAR2(8) NOT NULL Budgeting Organization
Prompt Table: %EDITTABLE

23 GPS_BDG_ORG3_TGT Character(8) VARCHAR2(8) NOT NULL Budgeting Organization
Prompt Table: %EDITTABLE2

24 GPS_BDG_ORG4_TGT Character(8) VARCHAR2(8) NOT NULL Budgeting Organization
Prompt Table: %EDITTABLE3

25 GPS_BDG_ORG5_TGT Character(8) VARCHAR2(8) NOT NULL Budgeting Organization
Prompt Table: %EDITTABLE4

26 GPS_POST_TYPE_TGT 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 Servi)
LEB=Empty Post (Civil Service)
LEE=Empty Post (Employee)

27 GPS_SETID_TGT Character(5) VARCHAR2(5) NOT NULL GPS Target SETID
Default Value: OPR_DEF_TBL_HR.SETID
Prompt Table: SET_VLD_HR_05

28 GPS_GRADE_TGT Character(8) VARCHAR2(8) NOT NULL GPS Grade Target
Prompt Table: GPS_POST_GRD_VW

29 GPS_RANK_TGT Character(15) VARCHAR2(15) NOT NULL GPS Rank Target

#	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 Default Value: 0
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.
6	GPS_RANK	Character(15)	VARCHAR2(15) NOT NULL	Rank for GPS
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_ACTION	Character(8)	VARCHAR2(8) NOT NULL	Action as executed on GPS Post Prompt Table: GPS_ACTION_VW
9	SEQUENCE	Number(2,0)	SMALLINT NOT NULL	Chartfield Sequence Default Value: 1
10	GPS_DEPT_TGT	Character(10)	VARCHAR2(10) NOT NULL	Target department Prompt Table: DEPT_TBL
11	GPS_FRACTION	Number(9,2)	DECIMAL(8,2) NOT NULL	GPS Fraction
12	STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status Indicator A=Active I=Inactive Default Value: A
13	GPS_NUMBER	Number(6,0)	INTEGER NOT NULL	GPS Amount of Posts to create Default Value: 1
14	GPS_NBR_DONE	Number(6,0)	INTEGER NOT NULL	GPS number of planning instructions done in clean-up phase Default Value: 0
15	GPS_BDG_ORG1	Character(8)	VARCHAR2(8) NOT NULL	Budgeting Organization Prompt Table: GPS_ORG_DVW
16	GPS_BDG_ORG2	Character(8)	VARCHAR2(8) NOT NULL	Budgeting Organization Prompt Table: %EDITTABLE
17	GPS_BDG_ORG3	Character(8)	VARCHAR2(8) NOT NULL	Budgeting Organization Prompt Table: %EDITTABLE2
18	GPS_BDG_ORG4	Character(8)	VARCHAR2(8) NOT NULL	Budgeting Organization Prompt Table: %EDITTABLE3
19	GPS_BDG_ORG5	Character(8)	VARCHAR2(8) NOT NULL	Budgeting Organization Prompt Table: %EDITTABLE4
20	GPS_ROWID_TGT	Character(45)	VARCHAR2(45) NOT NULL	RowID, a condensed version of the key fields of a budgeting system
21	GPS_BDG_ORG1_TGT	Character(8)	VARCHAR2(8) NOT NULL	Budgeting Organization - Public Sector Germany Prompt Table: GPS_ORG_DVW
22	GPS_BDG_ORG2_TGT	Character(8)	VARCHAR2(8) NOT NULL	Budgeting Organization Prompt Table: %EDITTABLE
23	GPS_BDG_ORG3_TGT	Character(8)	VARCHAR2(8) NOT NULL	Budgeting Organization Prompt Table: %EDITTABLE2
24	GPS_BDG_ORG4_TGT	Character(8)	VARCHAR2(8) NOT NULL	Budgeting Organization Prompt Table: %EDITTABLE3
25	GPS_BDG_ORG5_TGT	Character(8)	VARCHAR2(8) NOT NULL	Budgeting Organization Prompt Table: %EDITTABLE4
26	GPS_POST_TYPE_TGT	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 Servi) LEB=Empty Post (Civil Service) LEE=Empty Post (Employee)
27	GPS_SETID_TGT	Character(5)	VARCHAR2(5) NOT NULL	GPS Target SETID Default Value: OPR_DEF_TBL_HR.SETID Prompt Table: SET_VLD_HR_05
28	GPS_GRADE_TGT	Character(8)	VARCHAR2(8) NOT NULL	GPS Grade Target Prompt Table: GPS_POST_GRD_VW
29	GPS_RANK_TGT	Character(15)	VARCHAR2(15) NOT NULL	GPS Rank Target