RS_DMD_DTL_WS

(SQL Table)
Index Back

Scenario Demand Detail

SCP - Consolidated Scenario Demand Detail Working Scroll

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SCENARIO_ID2 Character(15) VARCHAR2(15) NOT NULL SCP-Combined Scenario ID
2 FORECAST_ID_DMD Character(15) VARCHAR2(15) NOT NULL Demand Forecast ID
3 DEMAND_ID Character(15) VARCHAR2(15) NOT NULL Demand ID
4 SETID_ROLE Character(5) VARCHAR2(5) NOT NULL SetID Role is used in the resource profile to allow select a valid project role.

Prompt Table: SP_SETID_NONVW

5 DEMAND_CAT Character(4) VARCHAR2(4) NOT NULL Demand Category
1=Operational
2=Strategic
6 PROJ_ROLE Character(15) VARCHAR2(15) NOT NULL Project Role
7 DESCR Character(30) VARCHAR2(30) NOT NULL Description
8 COMMITMENT_ACTION Character(1) VARCHAR2(1) NOT NULL SCP- Commitment Action for each Demand in Commitment Line Page of Consolidated Scenario
1=Commit
2=Defer

Default Value: 1

9 RANK Number(3,0) SMALLINT NOT NULL Priority Ranking
10 PRIORITY_DMD Character(1) VARCHAR2(1) NOT NULL Priority
1=1 - Critical
2=2 - High
3=3 - Medium
4=4 - Low
11 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
12 PROJECT_TYPE Character(5) VARCHAR2(5) NOT NULL Project Type
A=Activity
G=Grant
H=Phase
P=Project
S=Segment

Prompt Table: PROJ_TYPE_TBL

13 PROGRAM Character(15) VARCHAR2(15) NOT NULL Program

Prompt Table: PGM_PROG_SRCH

14 EFFORT Number(13,2) DECIMAL(12,2) NOT NULL Effort
15 FULL_TIME_RES_DMD Number(13,2) DECIMAL(12,2) NOT NULL Full Time Resource - Demand
16 UOM_SCP Character(1) VARCHAR2(1) NOT NULL SCP - Demand Setup UOM
1=Days
2=Hours
17 APPLICATION Character(10) VARCHAR2(10) NOT NULL Usually refers to a software application, such as "Payables", "Projects", "Purchasing", etc. An application needs to be defined under an application area.

Prompt Table: PGM_APPLICAT_AC

18 APPLICATION_AREA Character(10) VARCHAR2(10) NOT NULL The general area in which an application belongs. Examples: "Financials", "Human Resources", etc.

Prompt Table: PGM_APPLAREA_AC

19 RELEASE Character(15) VARCHAR2(15) NOT NULL Release - Carries Release Information driven by the BUSINESS_UNIT

Prompt Table: PGM_RELEASE_ALL

20 CATEGORY_IND Character(10) VARCHAR2(10) NOT NULL An additional attribute of the project, program, or project request for further classification. This field is user-defined. Examples of usage include "Strategic", "Operational", "Tactical", etc.

Prompt Table: PGM_CATEGORY_AC

21 DEMAND_SRC Character(4) VARCHAR2(4) NOT NULL Demand Source
1=Projects
2=External
22 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
A=Active
I=Inactive
23 STATUS_DMD Character(1) VARCHAR2(1) NOT NULL The processing state of a project.
A=Active
P=Pending
24 FROM_DATE Date(10) DATE From Date
25 TO_DATE Date(10) DATE To Date
26 ALLOCATED_DEMAND Number(13,2) DECIMAL(12,2) NOT NULL SCP-Allocated Demand .
27 ALERT Character(1) VARCHAR2(1) NOT NULL SCP - To indicate negative Variance.

Y/N Table Edit

Default Value: N

28 REQUESTOR_NAME Character(50) VARCHAR2(50) NOT NULL Requestor
29 REQUEST_DT Date(10) DATE Request Date
30 START_DT Date(10) DATE Start Date
31 END_DT Date(10) DATE End Date