TRN_GNRDMND4_VW

(SQL View)
Index Back

General Demand Prompt View

General Demand Prompt View

SELECT BUDGET_PERIOD, BUSINESS_UNIT, DEMAND_ID, DESCR, DEMAND_PRIORITY, CREATION_DT, REVISION_DT, TOTAL_DEMAND FROM PS_TRN_DEMAND WHERE EE_DEMAND_SW = 'N'

  • Related Language Record: TRN_MND4VW_LNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUDGET_PERIOD Character(10) VARCHAR2(10) NOT NULL Budget Period
    2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    3 DEMAND_ID Character(10) VARCHAR2(10) NOT NULL Demand ID
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DEMAND_PRIORITY Character(1) VARCHAR2(1) NOT NULL Demand Priority
    1=High
    2=Medium
    3=Low
    6 CREATION_DT Date(10) DATE Creation Date
    7 REVISION_DT Date(10) DATE Revision Date
    8 TOTAL_DEMAND Number(6,0) INTEGER NOT NULL Total General Demand

    Default Value: 0