| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 FORECAST_ID_DMD |
Character(15) |
VARCHAR2(15) NOT NULL |
Demand Forecast ID
Default Value: NEXT
|
| 2 |
DEMAND_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Demand ID
|
| 3 |
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
|
| 4 |
PROJ_ROLE |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Role
|
| 5 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 6 |
RANK |
Number(3,0) |
SMALLINT NOT NULL |
Priority Ranking
|
| 7 |
PRIORITY_DMD |
Character(1) |
VARCHAR2(1) NOT NULL |
Priority
1=1 - Critical
2=2 - High
3=3 - Medium
4=4 - Low
|
| 8 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 9 |
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
|
| 10 |
PROGRAM |
Character(15) |
VARCHAR2(15) NOT NULL |
Program
|
| 11 |
DEMAND_CAT |
Character(4) |
VARCHAR2(4) NOT NULL |
Demand Category
1=Operational
2=Strategic
Default Value: 2
|
| 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 |
UOM_SCP |
Character(1) |
VARCHAR2(1) NOT NULL |
SCP - Demand Setup UOM
1=Days
2=Hours
|
| 15 |
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.
|
| 16 |
APPLICATION_AREA |
Character(10) |
VARCHAR2(10) NOT NULL |
The general area in which an application belongs. Examples: "Financials", "Human Resources", etc.
|
| 17 |
RELEASE |
Character(15) |
VARCHAR2(15) NOT NULL |
Release - Carries Release Information driven by the BUSINESS_UNIT
|
| 18 |
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
|
| 19 |
DEMAND_SRC |
Character(4) |
VARCHAR2(4) NOT NULL |
Demand Source
1=Projects
2=External
|
| 20 |
STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Status Indicator
A=Active
I=Inactive
Default Value: A
|
| 21 |
REQUESTOR_NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Requestor
|
| 22 |
REQUEST_DT |
Date(10) |
DATE |
Request Date
|
| 23 |
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
|
| 24 |
FROM_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
From Year
|
| 25 |
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
|
| 26 |
TO_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
To Year
|
| 27 |
FROM_DATE |
Date(10) |
DATE |
From Date
|
| 28 |
TO_DATE |
Date(10) |
DATE |
To Date
|