POSITION_NBRPrompt Table: POSITION_DATA
EFFDTDefault Value: %date
Prompt Table: PERSON
POSN_INCUM_VW(SQL View) |
Index Back |
|---|---|
Posn Incumbents - Emplid OnlyPOSN_INCUM_VW is a view which retrieves the emplid of the current incumbent by position number as on an effective date. It is used in the Department page to display the EMPLID of incumbent as related-display to Position_Nbr. |
| SELECT A.POSITION_NBR , A.EFFDT ,A.EFFSEQ , A.EMPLID FROM PS_JOB A WHERE A.EMPL_STATUS IN('A','P','L','S') AND A.POSITION_NBR <> ' ' AND A.EFFDT = ( SELECT MAX(C.EFFDT) FROM PS_JOB C WHERE C.EMPLID = A.EMPLID AND C.EMPL_RCD = A.EMPL_RCD AND C.EFFDT <= %CurrentDateIn) AND A.EFFSEQ = ( SELECT MAX(D.EFFSEQ) FROM PS_JOB D WHERE D.EMPLID = A.EMPLID AND D.EMPL_RCD = A.EMPL_RCD AND D.EFFDT = A.EFFDT) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | POSITION_NBR |
Character(8) | VARCHAR2(8) NOT NULL |
Position Number
Prompt Table: POSITION_DATA |
| 2 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 3 | EFFSEQ | Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 4 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |