RS_SCENARIO_HDR

(SQL Table)
 Index Back

Consolidated Scenario Header

SCP - Consolidated Scenario Analysis Header Table

  • Related Language Record: RS_SNR_HDR_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SCENARIO_ID2 Character(15) VARCHAR2(15) NOT NULL SCP-Combined Scenario ID

    Default Value: NEXT

    2 FORECAST_ID_SUP Character(15) VARCHAR2(15) NOT NULL Supply Forecast ID
    3 FORECAST_ID_DMD Character(15) VARCHAR2(15) NOT NULL Demand Forecast ID
    4 SCENARIO_STATUS Character(1) VARCHAR2(1) NOT NULL SCP-Combined Scenario Statuses
    1=Pending
    2=Approved
    3=Obsolete

    Default Value: 1

    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 FROM_MONTH_SCP Character(2) VARCHAR2(2) NOT NULL SCP- From Month
    1=01 - January
    10=10 - October
    11=11 - November
    12=12 - December
    2=02 - February
    3=03 - March
    4=04 - April
    5=05 - May
    6=06 - June
    7=07 - July
    8=08 - August
    9=09 - September
    7 FROM_YEAR Number(4,0) SMALLINT NOT NULL From Year
    8 TO_MONTH_SCP Character(2) VARCHAR2(2) NOT NULL SCP- To Month
    1=01 - January
    10=10 - October
    11=11 - November
    12=12 - December
    2=02 - February
    3=03 - March
    4=04 - April
    5=05 - May
    6=06 - June
    7=07 - July
    8=08 - August
    9=09 - September
    9 TO_YEAR Number(4,0) SMALLINT NOT NULL To Year
    10 FROM_DATE Date(10) DATE From Date
    11 TO_DATE Date(10) DATE To Date
    12 ESTIMATED_COST_SUP Number(27,3) DECIMAL(26,3) NOT NULL SCP - Estimated Cost of Supply
    13 ALLOCATED_DEMAND Number(13,2) DECIMAL(12,2) NOT NULL SCP-Allocated Demand .
    14 BLENDED_RT_OPTION Character(1) VARCHAR2(1) NOT NULL SCP-Blended Rate Options in Consolidated Scenario
    1=Calculated
    2=Overridden

    Default Value: 1

    15 BLENDED_RATE_CAL Number(27,3) DECIMAL(26,3) NOT NULL SCP-This is the calculated Blended Rate in Combined Scenario
    16 BLENDED_RATE_ORD Number(27,3) DECIMAL(26,3) NOT NULL SCP- This is the Overidden Blended Rate in Consolidated Scenario
    17 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    18 FMS_DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the original entry.
    19 FMS_OPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the original entry.
    20 FMS_LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry.
    21 FMS_LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry.
    22 OPRID_APPROVED_BY Character(30) VARCHAR2(30) NOT NULL Approved By
    23 APPROVED_DTTM DateTime(26) TIMESTAMP SCC 09/16/04 - Approved Date and time