GPS_REMARK_VW (SQL View)	Index Back
GPS remark dtl contains detail information on what and when. what: what is the target the post is going to be moved to when: when can a remark be executed

GPS_REMARK_VW

(SQL View)

GPS remark dtl

contains detail information on what and when. what: what is the target the post is going to be moved to when: when can a remark be executed

SELECT A.SETID , A.GPS_REMARK_ID , A.GPS_REMARK_SEQ , B.GPS_REMARK_TYPE , A.GPS_REMARK_STATUS , A.GPS_EXECUTE_YEAR , A.GPS_CREATE_YEAR , A.GPS_GRADE_TGT , A.GPS_RANK_TGT , A.GPS_EXECUTION_DT , A.GPS_COMMENT FROM %Table(GPS_REMARK_DTL) A , %Table(GPS_REMARK_TBL) B WHERE A.SETID = B.SETID AND A.GPS_REMARK_ID = B.GPS_REMARK_ID

# 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_REMARK_ID Number(7,0) INTEGER NOT NULL GPS remark id [Vermerk] Container ID

3 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.

4 GPS_REMARK_TYPE Character(2) VARCHAR2(2) NOT NULL remark type KU or KW
KU=can be changed
KW=can be removed

5 GPS_REMARK_STATUS Character(1) VARCHAR2(1) NOT NULL execution status of a remark
D=Inactive
E=Executed
I=Individualized
N=New
P=Planned

6 GPS_EXECUTE_YEAR Character(4) VARCHAR2(4) NOT NULL Earliest Execution

7 GPS_CREATE_YEAR Character(4) VARCHAR2(4) NOT NULL Year of Creation

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

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

10 GPS_EXECUTION_DT Date(10) DATE remark execution date

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

#	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_REMARK_ID	Number(7,0)	INTEGER NOT NULL	GPS remark id [Vermerk] Container ID
3	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.
4	GPS_REMARK_TYPE	Character(2)	VARCHAR2(2) NOT NULL	remark type KU or KW KU=can be changed KW=can be removed
5	GPS_REMARK_STATUS	Character(1)	VARCHAR2(1) NOT NULL	execution status of a remark D=Inactive E=Executed I=Individualized N=New P=Planned
6	GPS_EXECUTE_YEAR	Character(4)	VARCHAR2(4) NOT NULL	Earliest Execution
7	GPS_CREATE_YEAR	Character(4)	VARCHAR2(4) NOT NULL	Year of Creation
8	GPS_GRADE_TGT	Character(8)	VARCHAR2(8) NOT NULL	GPS Grade Target Prompt Table: GPS_POST_GRD_VW
9	GPS_RANK_TGT	Character(15)	VARCHAR2(15) NOT NULL	GPS Rank Target
10	GPS_EXECUTION_DT	Date(10)	DATE	remark execution date
11	GPS_COMMENT	Character(254)	VARCHAR2(254) NOT NULL	GPS comments