SETIDDefault Value: OPR_DEF_TBL_HR.SETID
GPS_POST_IDEFFDTDefault Value: %date
EFFSEQA=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
GPS_STF_DTL_VW(SQL View) |
Index Back |
|---|---|
GPS Post Detailpost details view used in staffing. show posts with associated active plan. |
| SELECT DISTINCT TBL.SETID , POST.GPS_POST_ID , DTL.EFFDT , DTL.EFFSEQ , DTL.GPS_STATUS , DTL.GPS_FRACTION FROM PS_GPS_POSTPLN_TBL TBL , PS_GPS_POSTPLN_ROW ROW1 , PS_GPS_POST POST , PS_GPS_POST_DTL DTL WHERE TBL.SETID = ROW1.SETID AND TBL.YEAR = ROW1.YEAR AND TBL.GPS_POST_PLN_TYPE = ROW1.GPS_POST_PLN_TYPE AND TBL.GPS_ROWID = ROW1.GPS_ROWID AND POST.SETID = ROW1.SETID AND POST.YEAR = ROW1.YEAR AND POST.GPS_POST_PLN_TYPE = ROW1.GPS_POST_PLN_TYPE AND POST.GPS_ROWID = ROW1.GPS_ROWID AND POST.GPS_GRADE = ROW1.GPS_GRADE AND POST.GPS_RANK = ROW1.GPS_RANK AND POST.GPS_POST_TYPE = ROW1.GPS_POST_TYPE AND DTL.SETID = ROW1.SETID AND DTL.GPS_POST_ID = POST.GPS_POST_ID AND DTL.GPS_ROWID = POST.GPS_ROWID AND DTL.GPS_GRADE = POST.GPS_GRADE AND DTL.GPS_RANK = POST.GPS_RANK AND DTL.GPS_POST_TYPE = POST.GPS_POST_TYPE AND TBL.GPS_PLN_STATUS IN ('CLNP','DONE','ACTV') |
| # | 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_FRACTION | Number(9,2) | DECIMAL(8,2) NOT NULL | GPS Fraction |