TRN_DEMAND_VW

(SQL View)
Index Back

Demand View

Demand View

SELECT BUDGET_PERIOD ,BUSINESS_UNIT ,DEMAND_ID ,COURSE ,DESCRSHORT ,REVISION_DT ,TRN_DEMAND_STATUS FROM PS_TRN_DEMAND

  • Related Language Record: TN_DMNDVW_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: TRN_ALL_COURSE

    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    6 REVISION_DT Date(10) DATE Revision Date

    Default Value: %Date

    7 TRN_DEMAND_STATUS Character(1) VARCHAR2(1) NOT NULL Demand Status
    F=Frozen
    N=New
    R=Reported
    S=Simulated

    Default Value: N