ZZ_DMNDCRS_SRC

(SQL View)
 Index Back

Employee Demand/Course Search

"This search record is used to access to the panel ""Employee Demand by Course""."

SELECT A.BUDGET_PERIOD, A.BUSINESS_UNIT, B.COURSE, B.CATEGORY_CD, B.SUB_CATEGORY_CD, B.REAL_COURSE, B.DESCR FROM PS_TRN_DMNDEE_CRS A, PS_TRN_ALL_COURSE B WHERE A.COURSE = B.COURSE GROUP BY A.BUDGET_PERIOD, A.BUSINESS_UNIT, B.COURSE, B.CATEGORY_CD, B.SUB_CATEGORY_CD, B.REAL_COURSE, B.DESCR

  • Related Language Record: ZZ_DMNDCSRC_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 COURSE Character(6) VARCHAR2(6) NOT NULL Course Code

    Prompt Table: TRN_ALL_COURSE

    4 CATEGORY_CD Character(10) VARCHAR2(10) NOT NULL Category Code

    Prompt Table: TRN_CAT_TBL

    5 SUB_CATEGORY_CD Character(10) VARCHAR2(10) NOT NULL Subcategory Code

    Prompt Table: TRN_SUBCAT_TBL

    6 REAL_COURSE Character(7) VARCHAR2(7) NOT NULL Course Code
    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description