BUSINESS_UNITDEMAND_IDA=Active
P=Pending
1=Projects
2=External
RS_DEMAND(SQL View) |
Index Back |
|---|---|
SQL View for Demand ForecastSCP - SQL View to Browse for Demand |
| SELECT DISTINCT BUSINESS_UNIT , DEMAND_ID ,APPLICATION_AREA ,APPLICATION ,PROGRAM ,RELEASE , STATUS , DEMAND_SRC FROM %Table(RS_DMD_CACH ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | DEMAND_ID |
Character(15) | VARCHAR2(15) NOT NULL | Demand ID |
| 3 | APPLICATION_AREA | Character(10) | VARCHAR2(10) NOT NULL | The general area in which an application belongs. Examples: "Financials", "Human Resources", etc. |
| 4 | 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. |
| 5 | PROGRAM | Character(15) | VARCHAR2(15) NOT NULL | Program |
| 6 | RELEASE | Character(15) | VARCHAR2(15) NOT NULL | Release - Carries Release Information driven by the BUSINESS_UNIT |
| 7 | STATUS_DMD | Character(1) | VARCHAR2(1) NOT NULL |
The processing state of a project.
A=Active P=Pending |
| 8 | DEMAND_SRC | Character(4) | VARCHAR2(4) NOT NULL |
Demand Source
1=Projects 2=External |