EPO_DEPT_SCH_VW

(SQL View)
Index Back

Department Search Results

Left Outer Join View Used to display search results in search banner grid.

SELECT DEPT.SETID , DEPT.DEPTID , %Upper(DEPT.DESCR) , DEPT.DESCR , PG.EPO_PAGE_ID , PG.EFFDT , PG.EPO_PAGE_OWNER_ID , PG.EPO_PAGE_OWNER_RCD , PG.NAME , PG.LAST_NAME_SRCH , PG.FIRST_NAME_SRCH FROM PS_DEPT_TBL_EFF_VW DEPT LEFT OUTER JOIN PS_EPO_PGHDR_EFF_V PG ON DEPT.SETID = PG.SETID AND DEPT.DEPTID = PG.EPO_NODE_Id

  • Related Language Record: EPO_DEPT_SCH_LV
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DEPT_DESCR Character(30) VARCHAR2(30) NOT NULL Department Description
    5 EPO_PAGE_ID Number(8,0) INTEGER NOT NULL Objectives Management: Objective Page ID
    6 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    7 EPO_PAGE_OWNER_ID Character(11) VARCHAR2(11) NOT NULL Objectives Management: Emplid of the person who owns the Objective Page
    8 EPO_PAGE_OWNER_RCD Number(3,0) SMALLINT NOT NULL Page Owner Record Number
    9 NAME Character(50) VARCHAR2(50) NOT NULL Name
    10 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
    11 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name