TRN_DMNDPOP_VW

(SQL View)
 Index Back

Demand by Population View

Demand by Population View

SELECT A.BUDGET_PERIOD , B.BUSINESS_UNIT , B.DEPTID , A.DEMAND_ID , A.COURSE , A.DESCR , A.DESCRSHORT , A.EE_DEMAND_SW , A.ORIG_EMPLID , A.ORIGINATOR , A.CREATION_DT , A.REVISION_DT , A.DEMAND_PRIORITY , A.EXPIRATN_DT , A.TRN_DEMAND_STATUS , A.TOTAL_DEMAND , A.EMPLID , A.EMPL_RCD , A.SALARY_COST_BUDGET , %subrec(TRN_EXCHG_RT,A) , A.VARIABLE_COST , A.CURRENCY_CD , A.COST_UNIT_CD , A.NON_CATALOGUED , %subrec(TRN_DPT_SBR_FRA, B) , A.TRN_PLN_CATEGORY FROM PS_TRN_DEMAND A , PS_TRN_DEMAND_DEPT B WHERE A.BUDGET_PERIOD = B.BUDGET_PERIOD AND A.DEMAND_ID = B.DEMAND_ID AND A.EE_DEMAND_SW = 'N'

  • Related Language Record: TN_DMDPOPVW_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 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
    4 DEMAND_ID Character(10) VARCHAR2(10) NOT NULL Demand ID
    5 COURSE Character(6) VARCHAR2(6) NOT NULL Course Code

    Prompt Table: CRS_NOT_CATL_VW

    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    8 EE_DEMAND_SW Character(1) VARCHAR2(1) NOT NULL Employee Demand Switch

    Y/N Table Edit

    Default Value: N

    9 ORIG_EMPLID Character(11) VARCHAR2(11) NOT NULL Originating Emplid

    Default Value: DEPT_TBL.MANAGER_ID

    Prompt Table: PERSON_NAME

    10 ORIGINATOR Character(1) VARCHAR2(1) NOT NULL Originator
    E=Employee
    S=Supervisor

    Default Value: S

    11 CREATION_DT Date(10) DATE Creation Date

    Default Value: %Date

    12 REVISION_DT Date(10) DATE Revision Date
    13 DEMAND_PRIORITY Character(1) VARCHAR2(1) NOT NULL Demand Priority
    1=High
    2=Medium
    3=Low

    Default Value: 2

    14 EXPIRATN_DT Date(10) DATE Expiration Date
    15 TRN_DEMAND_STATUS Character(1) VARCHAR2(1) NOT NULL Demand Status
    F=Frozen
    N=New
    R=Reported
    S=Simulated

    Default Value: N

    16 TOTAL_DEMAND Number(6,0) INTEGER NOT NULL Total General Demand
    17 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    18 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
    19 SALARY_COST_BUDGET Number(19,3) DECIMAL(18,3) NOT NULL Empl. Training Budgeted Cost
    20 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier

    Default Value: 1

    21 TO_CUR Character(3) VARCHAR2(3) NOT NULL To Currency Code

    Default Value: TRN_BASE_CUR.BASE_CURRENCY

    22 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor

    Default Value: 1

    23 VARIABLE_COST Number(19,3) DECIMAL(18,3) NOT NULL Variable Cost
    24 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: BUS_UNIT_OPT_HR.EXCHNG_TO_CURRENCY

    Prompt Table: CURRENCY_CD_TBL

    25 COST_UNIT_CD Character(10) VARCHAR2(10) NOT NULL Cost Unit

    Default Value: STUD/H

    Prompt Table: TR_COST_UNIT_VW

    26 NON_CATALOGUED Character(1) VARCHAR2(1) NOT NULL Not in Catalog

    Y/N Table Edit

    Default Value: N

    27 DEPT_DMND_F_FRA Number(6,0) INTEGER NOT NULL Department Demand Female Number for France.
    28 DEPT_DMND_M_FRA Number(6,0) INTEGER NOT NULL Department Demand Male Number for France.
    29 DEPT_DMND_ONQ_FRA Number(6,0) INTEGER NOT NULL Department Demand Non Qualified Worker Number for France.
    30 DEPT_DMND_OQ_FRA Number(6,0) INTEGER NOT NULL Department Demand Qualified Worker Number for France.
    31 DEPT_DMND_E_FRA Number(6,0) INTEGER NOT NULL Department Demand Office Worker Number for France.
    32 DEPT_DMND_AM_FRA Number(6,0) INTEGER NOT NULL Department Demand Manager Number for France.
    33 DEPT_DMND_IC_FRA Number(6,0) INTEGER NOT NULL Department Demand Executive Number for France.
    34 TRN_PLN_CATEGORY Character(1) VARCHAR2(1) NOT NULL Feild for Training Plan Category
    0=Not Specified
    1=Adaptation to Job Changement
    2=Job Preservation
    3=Skill Development