RS_DEMAND_SRCH

(SQL View)
 Index Back

SQL View for Demand Forecast

SCP - SQL View to Browse for Demand

SELECT DISTINCT BUSINESS_UNIT ,DEMAND_ID ,DESCR ,PROJECT_TYPE ,PROGRAM ,DEMAND_CAT ,SUM(EFFORT ) ,UOM_SCP ,SUM(FULL_TIME_RES_DMD ) ,APPLICATION ,APPLICATION_AREA ,RELEASE ,CATEGORY_IND ,DEMAND_SRC ,STATUS ,REQUESTOR_NAME FROM %Table(RS_DMD_CACH ) GROUP BY BUSINESS_UNIT ,DEMAND_ID ,DESCR ,PROJECT_TYPE ,PROGRAM ,DEMAND_CAT , UOM_SCP ,APPLICATION ,APPLICATION_AREA ,RELEASE ,CATEGORY_IND ,DEMAND_SRC ,STATUS , REQUESTOR_NAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BU_PC_NONVW

2 DEMAND_ID Character(15) VARCHAR2(15) NOT NULL Demand ID
3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
4 PROJECT_TYPE Character(5) VARCHAR2(5) NOT NULL Project Type
A=Activity
G=Grant
H=Phase
P=Project
S=Segment
5 PROGRAM Character(15) VARCHAR2(15) NOT NULL Program
6 DEMAND_CAT Character(4) VARCHAR2(4) NOT NULL Demand Category
1=Operational
2=Strategic
7 EFFORT Number(13,2) DECIMAL(12,2) NOT NULL Effort
8 UOM_SCP Character(1) VARCHAR2(1) NOT NULL SCP - Demand Setup UOM
1=Days
2=Hours
9 FULL_TIME_RES_DMD Number(13,2) DECIMAL(12,2) NOT NULL Full Time Resource - Demand
10 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.
11 APPLICATION_AREA Character(10) VARCHAR2(10) NOT NULL The general area in which an application belongs. Examples: "Financials", "Human Resources", etc.
12 RELEASE Character(15) VARCHAR2(15) NOT NULL Release - Carries Release Information driven by the BUSINESS_UNIT
13 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.
14 DEMAND_SRC Character(4) VARCHAR2(4) NOT NULL Demand Source
1=Projects
2=External

Default Value: 1

15 STATUS_DMD Character(1) VARCHAR2(1) NOT NULL The processing state of a project.
A=Active
P=Pending
16 REQUESTOR_NAME Character(50) VARCHAR2(50) NOT NULL Requestor