POSN_M_SRCH_LVW

(SQL View)
 Index Back

Search Vw-Position Mgmt

POSITION_SRCH 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 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 A.POSITION_NBR ,A.EFFDT ,A.EFFSEQ ,L.LANGUAGE_CD ,L.DESCR FROM PS_POSITION_DATA_E A , PS_POSN_DATA_LNG_E L WHERE L.POSITION_NBR=A.POSITION_NBR AND L.EFFDT=A.EFFDT AND L.EFFSEQ=A.EFFSEQ

  • Related Language Record for POSN_MGR_SRC_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number
    2 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    3 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description