EPO_DEPART_SRCH

(SQL View)
 Index Back

Search Vw-Security for Dept

EPO_DEPART_SRCH is a search view which uses departmental security to grant access to the departments themselves, or other records keyed by department. Users will only see departments which they have security clearance to acccess. For Objectives Management we are filtering out Inactive Departments.

SELECT %Sql(SCRTY_SEL_DEPTKEY, OPR,DEPT) , DEPT.DESCR , DEPT.COMPANY , DEPT.SETID_LOCATION , DEPT.LOCATION FROM %Sql(SCRTY_DEPT_FROM) WHERE %Sql(SCRTY_WHERE_DEPT) AND DEPT.EFF_STATUS = 'A'

  • Related Language Record: EPO_DSRCH_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SET_DEPT_VLD_VW

    2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    3 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: DEPT_TBL

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
    6 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location Set ID

    Prompt Table: SETID_TBL

    7 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

    Prompt Table: SET_LOC_CURR_VW