TRN_DEMAND_EE

(SQL View)
 Index Back

Employee Demand Srch Vw

Employee Demand Srch Vw

SELECT A.BUDGET_PERIOD , A.BUSINESS_UNIT , A.EMPLID , A.COURSE , A.DEMAND_ID , 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.EMPL_RCD , A.SALARY_COST_BUDGET , A.RATE_MULT , A.TO_CUR , A.RATE_DIV , A.VARIABLE_COST , A.CURRENCY_CD , A.COST_UNIT_CD , A.NON_CATALOGUED , A.TRN_PLN_CATEGORY FROM PS_TRN_DEMAND A WHERE A.EE_DEMAND_SW = 'Y'

  • Related Language Record: TRN_DMD_EE_LANG

    • # 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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERS_SRCH_CURR

    4 COURSE Character(6) VARCHAR2(6) NOT NULL Course Code

    Prompt Table: CRS_NOT_CATL_VW

    5 DEMAND_ID Character(10) VARCHAR2(10) NOT NULL Demand ID
    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 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

    Prompt Table: EMPLMT_SRCH_GBL

    18 SALARY_COST_BUDGET Number(19,3) DECIMAL(18,3) NOT NULL Empl. Training Budgeted Cost
    19 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier

    Default Value: 1

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

    Default Value: TRN_BASE_CUR.BASE_CURRENCY

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

    Default Value: 1

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

    Default Value: BUS_UNIT_OPT_HR.EXCHNG_TO_CURRENCY

    Prompt Table: CURRENCY_CD_TBL

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

    Default Value: STUD/H

    Prompt Table: TR_COST_UNIT_VW

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

    Y/N Table Edit

    Default Value: N

    26 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

    Default Value: 0