OPRIDPOSITION_NBRA=Approved
P=Proposed
R=Frozen
POSN_SUCC_SRCH(SQL View) |
Index Back |
|---|---|
Position Match Search.Search view that selects rows from Postion Data when those position are involved in a role. |
| SELECT SEC.OPRID , A.POSITION_NBR , A.DESCR , A.POSN_STATUS , A.BUSINESS_UNIT , A.DEPTID , A.JOBCODE FROM PS_POSITION_DATA A , PS_DEPT_SEC_SRCH SEC WHERE A.KEY_POSITION = 'Y' AND EXISTS ( SELECT 'X' FROM PS_CM_ROLE B WHERE B.POSITION_NBR = A.POSITION_NBR) AND SEC.SETID = ( SELECT SETID FROM PS_SET_CNTRL_REC SC WHERE SC.SETCNTRLVALUE = A.BUSINESS_UNIT AND SC.RECNAME = 'DEPT_TBL') AND A.DEPTID = SEC.DEPTID AND A.EFFDT = ( SELECT MAX(D.EFFDT) FROM PS_POSITION_DATA D WHERE D.POSITION_NBR = A.POSITION_NBR) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | POSITION_NBR |
Character(8) | VARCHAR2(8) NOT NULL | Position Number |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | POSN_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Position Status
A=Approved P=Proposed R=Frozen |
| 5 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 6 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 7 | POSN_JOBCODE | Character(6) | VARCHAR2(6) NOT NULL | Position Job Code |