| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 FORECAST_ID_SUP |
Character(15) |
VARCHAR2(15) NOT NULL |
Supply Forecast ID
|
| 2 |
POOL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Pool ID field.
Prompt Table:
%EDITTABLE
|
| 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
Prompt Table:
RS_PROJROLE_VW
|
| 5 |
REGION_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to.
Prompt Table:
RS_SCP_REGION
|
| 6 |
PER_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Personnel Status
E=Employee
N=Non-Employee
|
| 7 |
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
|
| 8 |
FROM_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
From Year
|
| 9 |
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
|
| 10 |
TO_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
To Year
|
| 11 |
FROM_DATE |
Date(10) |
DATE |
From Date
|
| 12 |
TO_DATE |
Date(10) |
DATE |
To Date
|
| 13 |
COMMENTS |
Long Character |
CLOB |
Comment
|
| 14 |
CAPACITY |
Signed Number(14,2) |
DECIMAL(12,2) NOT NULL |
SCP- Forecasted Supply stored as capacity.
|
| 15 |
UOM_SCP |
Character(1) |
VARCHAR2(1) NOT NULL |
SCP - Demand Setup UOM
1=Days
2=Hours
|
| 16 |
FULL_TIME_RES_SUP |
Signed Number(14,2) |
DECIMAL(12,2) NOT NULL |
Full Time Resources
|
| 17 |
SETID_REGION |
Character(5) |
VARCHAR2(5) NOT NULL |
Region SetID
|
| 18 |
FMS_DTTM_STAMP |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the original entry.
|
| 19 |
FMS_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies the User ID which made the original entry.
|
| 20 |
FMS_LASTUPDDTTM |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry.
|
| 21 |
FMS_LASTUPDOPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies the User ID which made the last update to an entry.
|