| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
PROBINST |
Character(20) |
VARCHAR2(20) NOT NULL |
Optimization Problem Instance
Prompt Table:
SP_PRBINS_NONVW
|
| 3 |
PL_WB_TEMPLATE_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
PL_WB_TEMPLATE_ID
Prompt Table:
PL_WB_MTMPL_VW
|
| 4 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
%EDITTABLE
|
| 5 |
PL_RESOURCE_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
01/14/03 JC (CN#PL880-1): Added label SPL_WORK_CENTER
Prompt Table:
%EDITTABLE6
|
| 6 |
SPL_RESOURCE_CLASS |
Character(1) |
VARCHAR2(1) NOT NULL |
12/14/04 NRA - Added based on RESOURCE_CLASS (owned by Projects in SCM)
1=Aggregate Resource By Time
2=Aggregate Resource By Unit
|
| 7 |
WC_GROUP_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
F-SMERENDA-87: Planning Work center groups
Prompt Table:
EN_WC_GRP
|
| 8 |
PL_VIOLATION_RULE |
Character(1) |
VARCHAR2(1) NOT NULL |
PL_VIOLATION_RULE
A=All Resources
N=Consider Violations
Y=Ignore Violations
Default Value: A
|
| 9 |
EOEP_SRCH_COND |
Character(4) |
VARCHAR2(4) NOT NULL |
Criteria used to build query/sql where conditions.
<=<
<==<=
<>=<>
===
>=>
>==>=
BEG=begins with
CON=contains
IN=in
|
| 10 |
UTIL_PCT |
Signed Number(4,0) |
DECIMAL(3) NOT NULL |
Utilization Percentage
|
| 11 |
PLAN_BUCKET |
Character(1) |
VARCHAR2(1) NOT NULL |
08/03/99 MACN (CN#PL800-33.0) Changed the translate values from D, W, M to 0, 1, 2
0=Daily
1=Weekly
2=Monthly
|
| 12 |
CURRENT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
08/07/02 EGS (CN#PL880-1): Added.
10/18/02 JC (CN#PL880-1):Added FROM label
1=Date
2=Offset
Default Value: 2
|
| 13 |
CURRENT_OFFSET |
Signed Number(6,0) |
DECIMAL(5) NOT NULL |
09/05/01 EGS (CN#PL900-1): Added.
10/07/02 JC (CN#PL880-1): Added FROM_OFFSET label
Default Value: 0
|
| 14 |
CURRENT_DATE1 |
Date(10) |
DATE |
12/20/01 EGS (CN#PL900-1): Added
10/07/02 JC (CN#PL880-1): Added FROM_DATE label
|
| 15 |
PL_NUMBER_PERIODS |
Number(3,0) |
SMALLINT NOT NULL |
PL_NUMBER_PERIODS
|
| 16 |
DECIMAL_POSITIONS |
Number(2,0) |
SMALLINT NOT NULL |
Decimal Positions
Default Value: 2
|
| 17 |
PL_SUM_RSC_CLASS |
Character(1) |
VARCHAR2(1) NOT NULL |
PL_SUM_RSC_CLASS
Y/N Table Edit
Default Value: N
|
| 18 |
SHOW_DETAIL |
Character(1) |
VARCHAR2(1) NOT NULL |
Show Detail Values
N=No Detail
Y=Show Detail
Y/N Table Edit
Default Value: N
|
| 19 |
SHOW_PRODUCTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Show Production
Y/N Table Edit
Default Value: N
|
| 20 |
PL_SC_DATE_1 |
Date(10) |
DATE |
Start Date
|
| 21 |
PL_START_DT_CALC |
Character(4) |
VARCHAR2(4) NOT NULL |
Used to indicate whether the start date of the first bucket should be the Start Date Entered or the beginning of the Period in which the start date falls.
0001=Beginning of Period
0002=Start Date Entered
|
| 22 |
START_PLUGIN |
Character(1) |
VARCHAR2(1) NOT NULL |
START_PLUGIN
|
| 23 |
URL |
Character(254) |
VARCHAR2(254) NOT NULL |
Internet URL (Universal Resource Locator)
Prompt Table:
SPL_DOMN_URL_VW
|