TRN_SML_ACT_VW

(SQL View)
Index Back

Training Simulation Table

Training Simulation Table

SELECT A.BUDGET_PERIOD, A.BUSINESS_UNIT, A.DEPTID, SUM(A.DEMAND_APPROVED) FROM PS_TRN_SIMULATION A, PS_TRN_SCENARIO B WHERE A.BUDGET_PERIOD = B.BUDGET_PERIOD AND A.DEPTID = B.DEPTID AND A.SCENARIO = B.SCENARIO AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND B.SCENARIO_STATUS = 'A' GROUP BY A.BUDGET_PERIOD, A.BUSINESS_UNIT, A.DEPTID

# 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 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

Prompt Table: DEPT_TBL

4 DEMAND_APPROVED Number(6,0) INTEGER NOT NULL Employees Approved