OPRIDPOSITION_NBRPOSN_SRCH_E_QRY(SQL View) |
Index Back |
|---|---|
Search Vw-Position MgmtPOSITION_SRCH_E is a search view which uses departmental security to grant access to the positions based on the departments to which they are assigned. Users will only see positions located in departments for which they have security clearance. It is used as the search record for the Position Data panels in Fluid Position Management in all access modes except for Add mode. If you wish to enforce departmental security when a user adds a position which is already in the database, this record should be used as the search record for Add mode as well. |
| SELECT DISTINCT SEC.OPRID , A.POSITION_NBR FROM PS_POSITION_DATA_E A , PS_DEPT_SEC_SRCH SEC WHERE 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_E D WHERE A.POSITION_NBR = D.POSITION_NBR AND D.EFFDT<=%CurrentDateIn ) AND A.EFFSEQ= ( SELECT MAX(EFFSEQ) FROM PS_POSITION_DATA_E E WHERE E.POSITION_NBR=A.POSITION_NBR AND E.EFFDT=A.EFFDT) |
| # | 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 |