TRN_DEMAND_SRCH

(SQL View)
 Index Back

Demand Search

Demand Search

SELECT A.BUDGET_PERIOD, A.BUSINESS_UNIT, A.DEMAND_ID, A.COURSE, A.DESCR FROM PS_TRN_DEMAND A WHERE A.EE_DEMAND_SW='N'

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

    Prompt Table: CRS_NOT_CATL_VW

    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description