| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Sequence Number
|
| 2 |
LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Line Number:
11/24/08 - Added TARGET label [PC product]
Default Value: 1
|
| 3 |
LOAD_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Load Description
|
| 4 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
SP_BU_PC_NONVW
|
| 5 |
DEMAND_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Demand ID
|
| 6 |
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
|
| 7 |
PROJ_ROLE |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Role
Prompt Table:
PROJ_ROLE
|
| 8 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 9 |
PROGRAM |
Character(15) |
VARCHAR2(15) NOT NULL |
Program
Prompt Table:
PGM_PROG_SRCH
|
| 10 |
DEMAND_CAT |
Character(4) |
VARCHAR2(4) NOT NULL |
Demand Category
1=Operational
2=Strategic
|
| 11 |
EFFORT |
Number(13,2) |
DECIMAL(12,2) NOT NULL |
Effort
|
| 12 |
UOM_SCP |
Character(1) |
VARCHAR2(1) NOT NULL |
SCP - Demand Setup UOM
1=Days
2=Hours
|
| 13 |
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
|
| 14 |
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
|
| 15 |
RELEASE |
Character(15) |
VARCHAR2(15) NOT NULL |
Release - Carries Release Information driven by the BUSINESS_UNIT
Prompt Table:
PGM_RELEASE_ALL
|
| 16 |
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
|
| 17 |
STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Status Indicator
A=Active
I=Inactive
|
| 18 |
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
|
| 19 |
FROM_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
From Year
|
| 20 |
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
|
| 21 |
TO_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
To Year
|
| 22 |
FROM_DATE |
Date(10) |
DATE |
From Date
|
| 23 |
TO_DATE |
Date(10) |
DATE |
To Date
|
| 24 |
REQUESTOR_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Requestor id
Prompt Table:
PERSONAL_DATA
|
| 25 |
REQUEST_DATE |
Date(10) |
DATE |
Requested
|
| 26 |
DESCR100 |
Character(100) |
VARCHAR2(100) NOT NULL |
Length 100 Description
|