RS_DMD_HDR_TAO

(SQL Table)
 Index Back

Demand Forecast Header Table

SCP - Demand Forecast Header Temp Table

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

Default Value: NEXT

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

Default Value: 1

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

Prompt Table: RS_DMD_OPRID

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