SETIDDefault Value: OPR_DEF_TBL_HR.SETID
GPS_REMARK_IDGPS_REMARK_SEQD=Inactive
E=Executed
I=Individualized
N=New
P=Planned
Default Value: P
Prompt Table: GPS_POST_GRD_VW
Prompt Table: %EDITTABLE11
GPS_REMARK_DTL(SQL Table) |
Index Back |
|---|---|
GPS remark dtlcontains 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 |
| # | 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_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
execution status of a remark
D=Inactive E=Executed I=Individualized N=New P=Planned Default Value: P |
| 5 | GPS_EXECUTE_YEAR | Character(4) | VARCHAR2(4) NOT NULL | Earliest Execution |
| 6 | GPS_CREATE_YEAR | Character(4) | VARCHAR2(4) NOT NULL | Year of Creation |
| 7 | GPS_GRADE_TGT | Character(8) | VARCHAR2(8) NOT NULL |
GPS Grade Target
Prompt Table: GPS_POST_GRD_VW |
| 8 | GPS_RANK_TGT | Character(15) | VARCHAR2(15) NOT NULL |
GPS Rank Target
Prompt Table: %EDITTABLE11 |
| 9 | GPS_EXECUTION_DT | Date(10) | DATE | remark execution date |
| 10 | GPS_COMMENT | Character(254) | VARCHAR2(254) NOT NULL | GPS comments |