RS_APPLICATION (SQL View)	Index Back
Dynamic View - Demand Forecast SCP - Dynamic View for Demand Forecast

RS_APPLICATION

(SQL View)

Dynamic View - Demand Forecast

SCP - Dynamic View for Demand Forecast

SELECT DISTINCT APPLICATION , RELEASE ,PROGRAM ,APPLICATION_AREA FROM PS_RS_DMD_CACH

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 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.

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

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	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.
2	RELEASE	Character(15)	VARCHAR2(15) NOT NULL	Release - Carries Release Information driven by the BUSINESS_UNIT
3	PROGRAM	Character(15)	VARCHAR2(15) NOT NULL	Program
4	APPLICATION_AREA	Character(10)	VARCHAR2(10) NOT NULL	The general area in which an application belongs. Examples: "Financials", "Human Resources", etc.