FP_SETID_RANKFP_RANK_STARTFP_THRUDATEFP_SETID_RANK_ENDFP_RANK_ENDOPRIDEMPLIDFPAPROM_SRCH(SQL View) |
Index Back |
|---|---|
Srch Prom Employee + SecSelection of IDs with career whose grades are the same as promotable employees' starting grades. |
| SELECT C.FP_SETID_RANK , C.FP_RANK_START , C.FP_THRUDATE , C.FP_SETID_RANK_END , C.FP_RANK_END , SEC.OPRID , SEC.EMPLID , B.EMPL_RCD ,SEC.NAME , SEC.LAST_NAME_SRCH FROM PS_PERS_SRCH_GBL SEC , PS_FPAEELEGALSTAT W , PS_FPAEECAREER V , PS_FPMPROMTABL_TBL C %Sql(SCRTY_FPS_FROM, B) WHERE SEC.EMPLID = B.EMPLID AND SEC.EMPL_RCD = B.EMPL_RCD AND C.FP_RANK_START = V.FP_RANK_CD AND V.EFFDT <= C.FP_THRUDATE AND (V.EMPLID = SEC.EMPLID AND V.EMPL_RCD = B.EMPL_RCD) AND (W.EMPLID = SEC.EMPLID AND W.EMPL_RCD = B.EMPL_RCD AND W.FP_HIR_DOS_SIT = '02') %Sql(SCRTY_FPS_WHERE, B) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FP_SETID_RANK |
Character(5) | VARCHAR2(5) NOT NULL | Set ID |
| 2 | FP_RANK_START |
Character(6) | VARCHAR2(6) NOT NULL | Grade of Origin |
| 3 | FP_THRUDATE |
Date(10) | DATE | Starting Date |
| 4 | FP_SETID_RANK_END |
Character(5) | VARCHAR2(5) NOT NULL | Set ID |
| 5 | FP_RANK_END |
Character(6) | VARCHAR2(6) NOT NULL | New Grade |
| 6 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 7 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 8 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 9 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 10 | LAST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | Last Name |