GPS_POST_T_VW

(SQL View)
 Index Back

GPS Terminated Post View

Flattended out view that retrieves information of terminated posts` details

SELECT A.SETID ,A.GPS_POST_ID ,A.EFFDT ,A.EFFSEQ ,A.GPS_STATUS ,A.GPS_ACTION ,A.GPS_ROWID ,A.DEPTID ,A.GPS_POST_TYPE ,A.GPS_GRADE ,A.GPS_RANK ,A.GPS_FRACTION ,A.GPS_COMMENT FROM %Table(GPS_POST_DTL) A WHERE A.GPS_STATUS = 'T' OR A.GPS_STATUS = 'U'

# 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_POST_ID Character(8) VARCHAR2(8) NOT NULL GPS post id
3 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

4 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
5 GPS_STATUS Character(1) VARCHAR2(1) NOT NULL status of row in gps_post_dtl table
A=Active
B=Blocked
C=Copied Post
I=Inactive
N=New Post
O=Occupied
P=Pending
R=Reserved
S=Temporarily Blocked
T=Terminated
U=Cut
V=Vacant

Default Value: A

6 GPS_ACTION Character(8) VARCHAR2(8) NOT NULL Action as executed on GPS Post
7 GPS_ROWID Character(45) VARCHAR2(45) NOT NULL RowID, a condensed version of the key fields of a budgeting system
8 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

Prompt Table: DEPT_TBL

9 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)
10 GPS_GRADE Character(8) VARCHAR2(8) NOT NULL Salary Grade.

Prompt Table: GPS_POST_GRD_VW

11 GPS_RANK Character(15) VARCHAR2(15) NOT NULL Rank for GPS
12 GPS_FRACTION Number(9,2) DECIMAL(8,2) NOT NULL GPS Fraction
13 GPS_COMMENT Character(254) VARCHAR2(254) NOT NULL GPS comments