RS_FR_DMD_HDR

(SQL Table)
 Index Back

Demand Forecast Header Table

SCP - Demand Forecast Header Table

  • Related Language Record: RS_FR_DMD_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 FORECAST_ID_DMD Character(15) VARCHAR2(15) NOT NULL Demand Forecast ID

    Default Value: NEXT

    2 SCENARIO_STATUS Character(1) VARCHAR2(1) NOT NULL SCP-Combined Scenario Statuses
    1=Pending
    2=Approved
    3=Obsolete

    Default Value: 1

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 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
    5 FROM_YEAR Number(4,0) SMALLINT NOT NULL From Year
    6 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
    7 TO_YEAR Number(4,0) SMALLINT NOT NULL To Year
    8 FROM_DATE Date(10) DATE From Date
    9 TO_DATE Date(10) DATE To Date
    10 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

    Prompt Table: RS_DMD_OPRID

    11 EFFORT Number(13,2) DECIMAL(12,2) NOT NULL Effort
    12 FULL_TIME_RES_DMD Number(13,2) DECIMAL(12,2) NOT NULL Full Time Resource - Demand
    13 DESCRLONG Long Character CLOB Long Description
    14 FMS_DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the original entry.
    15 FMS_OPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the original entry.
    16 FMS_LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry.
    17 FMS_LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry.