TN_GBLDEMVW_LNG

(SQL View)
Index Back

Training Simulation View

Training Simulation View

SELECT A.BUDGET_PERIOD, A.BUSINESS_UNIT, B.SCENARIO, A.DEPTID, A.DEMAND_ID, D.LANGUAGE_CD, D.DESCR FROM PS_TRN_SIMULATION A, PS_TRN_SCENARIO B, PS_BUDGET_PER_LANG D

  • Related Language Record for TRN_GBL_DEM_VW
  • # 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 SCENARIO Character(10) VARCHAR2(10) NOT NULL Scenario
    4 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
    5 DEMAND_ID Character(10) VARCHAR2(10) NOT NULL Demand ID
    6 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description