GPS_POST_LST_VW

(SQL View)
 Index Back

GPS Post Detail Last Record

The last data record of GPS_POST_DTL, future dated record is included.

SELECT A.SETID ,A.GPS_POST_ID ,A.EFFDT ,A.EFFSEQ ,A.GPS_STATUS ,A.GPS_ACTION ,A.END_DT ,A.GPS_ROWID ,A.DEPTID ,A.GPS_POST_TYPE ,A.GPS_GRADE ,A.GPS_RANK ,A.GPS_FRACTION ,A.GPS_REMARK_ID ,A.GPS_REMARK_SEQ ,A.LASTUPDOPRID ,A.LASTUPDDTTM ,A.GPS_COMMENT FROM PS_GPS_POST_DTL A WHERE A.EFFDT = ( SELECT MAX(sub.EFFDT) FROM PS_GPS_POST_DTL sub WHERE sub.SETID = A.SETID AND sub.GPS_POST_ID = A.GPS_POST_ID ) AND A.EFFSEQ = ( SELECT MAX(sub2.EFFSEQ) FROM PS_GPS_POST_DTL sub2 WHERE sub2.SETID = A.SETID AND sub2.GPS_POST_ID = A.GPS_POST_ID AND sub2.EFFDT = A.EFFDT)

# 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 END_DT Date(10) DATE end date
8 GPS_ROWID Character(45) VARCHAR2(45) NOT NULL RowID, a condensed version of the key fields of a budgeting system
9 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

Prompt Table: DEPT_TBL

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

Prompt Table: GPS_POST_GRD_VW

12 GPS_RANK Character(15) VARCHAR2(15) NOT NULL Rank for GPS
13 GPS_FRACTION Number(9,2) DECIMAL(8,2) NOT NULL GPS Fraction
14 GPS_REMARK_ID Number(7,0) INTEGER NOT NULL GPS remark id [Vermerk] Container ID
15 GPS_REMARK_SEQ Number(4,0) SMALLINT NOT NULL GPS remark seq The individual remark sequence number. A post plan row gets associated a container ID. How many remarks (of a certain type) are associated to this post plan row is determined by the number of rows associated to this remark container.
16 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.
17 LASTUPDDTTM DateTime(26) TIMESTAMP 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

18 GPS_COMMENT Character(254) VARCHAR2(254) NOT NULL GPS comments