TRN_DMNDDEPT_VW

(SQL View)
 Index Back

Demand by Population Search

Demand by Population Search

SELECT SEC.OPRID , A.BUDGET_PERIOD , E.BUSINESS_UNIT , B.DEPTID , C.DESCR FROM PS_BUDGET_PERIOD A , PS_TRN_DEMAND_DEPT B , PS_DEPT_TBL C , PS_TRN_DEMAND D , PS_BUDGET_BUS_UNIT E , PS_DEPT_SEC_SRCH SEC WHERE SEC.SETID = ( SELECT SETID FROM PS_SET_CNTRL_REC SC WHERE SC.SETCNTRLVALUE = B.BUSINESS_UNIT AND SC.RECNAME = 'DEPT_TBL') AND C.SETID = SEC.SETID AND C.DEPTID = SEC.DEPTID AND B.DEPTID = SEC.DEPTID AND A.BUDGET_PERIOD = B.BUDGET_PERIOD AND D.BUDGET_PERIOD = A.BUDGET_PERIOD AND D.DEMAND_ID = B.DEMAND_ID AND D.EE_DEMAND_SW = 'N' AND E.BUDGET_PERIOD = A.BUDGET_PERIOD AND E.BUSINESS_UNIT = D.BUSINESS_UNIT AND E.BUSINESS_UNIT = B.BUSINESS_UNIT AND (C.EFFDT>=%CurrentDateIn OR C.EFFDT= ( SELECT MAX(D.EFFDT) FROM PS_DEPT_TBL D WHERE C.DEPTID = D.DEPTID AND D.SETID = C.SETID AND D.EFFDT<=%CurrentDateIn))

  • Related Language Record: TN_DMNDEPVW_LNG

    • # 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 BUDGET_PERIOD Character(10) VARCHAR2(10) NOT NULL Budget Period

    Prompt Table: BUDGET_PERIOD

    3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: BUDGET_BUS_UNIT

    4 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: DEPT_TBL

    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description