TRN_SML_DEM_VW

(SQL View)
 Index Back

Initial Total Request View

Initial Total Request View

SELECT A.BUDGET_PERIOD, A.BUSINESS_UNIT, D.DESCR, A.DEMAND_ID, B.DESCR, B.EE_DEMAND_SW, SUM(A.DEMAND_APPROVED), MAX(B.TOTAL_DEMAND), MAX(B.TOTAL_DEMAND) - SUM(A.DEMAND_APPROVED) FROM PS_TRN_SIMULATION A, PS_TRN_DEMAND B, PS_TRN_SCENARIO C, PS_BUDGET_PERIOD D WHERE A.BUDGET_PERIOD = B.BUDGET_PERIOD AND A.DEMAND_ID = B.DEMAND_ID AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.BUDGET_PERIOD = C.BUDGET_PERIOD AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.DEPTID = C.DEPTID AND A.SCENARIO = C.SCENARIO AND C.SCENARIO_STATUS = 'A' AND A.BUDGET_PERIOD = D.BUDGET_PERIOD GROUP BY A.BUDGET_PERIOD, A.BUSINESS_UNIT, D.DESCR, A.DEMAND_ID, B.DESCR, EE_DEMAND_SW

  • Related Language Record: TN_SMLDEMVW_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUDGET_PERIOD Character(10) VARCHAR2(10) NOT NULL Budget Period

    Prompt Table: BUDGET_PERIOD

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

    Prompt Table: BUDGET_BUS_UNIT

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DEMAND_ID Character(10) VARCHAR2(10) NOT NULL Demand ID

    Prompt Table: TRN_DEMAND

    5 DESCR2 Character(30) VARCHAR2(30) NOT NULL Descr2
    6 EE_DEMAND_SW Character(1) VARCHAR2(1) NOT NULL Employee Demand Switch
    7 DEMAND_APPROVED Number(6,0) INTEGER NOT NULL Employees Approved
    8 TOTAL_DEMAND Number(6,0) INTEGER NOT NULL Total General Demand
    9 TOTAL_IGNORED Signed Number(7,0) DECIMAL(6) NOT NULL Employees Ignored