EMPLIDEMPL_RCDGVT_POSN_INC_WS(SQL View) |
Index Back |
|---|---|
Posn Incumbents-Wrk ScrollGVT_POSN_INC_WS is a view which retrieves the current incumbents of a position by EmplID. This view is used in a work scroll on the Position Data 1 panel to support the cross-update to Job and Employment for current incumbents. |
| Select A.Emplid ,A.EMPL_RCD ,A.POSITION_NBR 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 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 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 3 | POSITION_NBR | Character(8) | VARCHAR2(8) NOT NULL | Position Number |