TRN_DEPTDMND_VW

(SQL View)
 Index Back

Trn Department Demand View

Trn Department Demand View

SELECT A.BUDGET_PERIOD , A.BUSINESS_UNIT , A.DEPTID , A.DEMAND_ID , A.DEPT_DEMAND , A.UPDATE_DEPTID_SW , %subrec(TRN_DPT_SBR_FRA,A) FROM PS_TRN_DEMAND_DEPT A WHERE EXISTS ( SELECT 'X' FROM PS_TRN_DEMAND B WHERE A.BUDGET_PERIOD = B.BUDGET_PERIOD AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.DEMAND_ID = B.DEMAND_ID AND B.EE_DEMAND_SW = 'N')

# 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_ID Character(10) VARCHAR2(10) NOT NULL Demand ID

Prompt Table: TRN_DEMAND

5 DEPT_DEMAND Number(6,0) INTEGER NOT NULL Department Demand
6 UPDATE_DEPTID_SW Character(1) VARCHAR2(1) NOT NULL User Updated Department

Y/N Table Edit

Default Value: Y

7 DEPT_DMND_F_FRA Number(6,0) INTEGER NOT NULL Department Demand Female Number for France.
8 DEPT_DMND_M_FRA Number(6,0) INTEGER NOT NULL Department Demand Male Number for France.
9 DEPT_DMND_ONQ_FRA Number(6,0) INTEGER NOT NULL Department Demand Non Qualified Worker Number for France.
10 DEPT_DMND_OQ_FRA Number(6,0) INTEGER NOT NULL Department Demand Qualified Worker Number for France.
11 DEPT_DMND_E_FRA Number(6,0) INTEGER NOT NULL Department Demand Office Worker Number for France.
12 DEPT_DMND_AM_FRA Number(6,0) INTEGER NOT NULL Department Demand Manager Number for France.
13 DEPT_DMND_IC_FRA Number(6,0) INTEGER NOT NULL Department Demand Executive Number for France.