|
SELECT DISTINCT A.PROCESS_INSTANCE , %subrec(PL_CAP_RPT_SBR,A) , G.START_DATE , G.END_DATE , G.CAPACITY_DATE , 'Dyn Col Label1' , 'Dyn Col Label2' , 'Dyn Col Label3' , 'Dyn Col Label4' , 'Dyn Col Label5' , B.XLATLONGNAME , C.XLATLONGNAME , D.XLATLONGNAME , E.XLATLONGNAME , F.XLATLONGNAME , 'GMT' FROM PS_PL_CAP_USG_HTAO A , PSXLATITEM B , PSXLATITEM C , PSXLATITEM D , PSXLATITEM E , PSXLATITEM F , PS_PL_PROBINST G WHERE B.FIELDNAME='YES_OR_NO' AND B.FIELDVALUE = A.PL_SUM_RSC_CLASS AND C.FIELDNAME='YES_OR_NO' AND C.FIELDVALUE = A.SHOW_DETAIL AND D.FIELDNAME='YES_OR_NO' AND D.FIELDVALUE = A.SHOW_PRODUCTION AND E.FIELDNAME='PLAN_BUCKET' AND E.FIELDVALUE = A.PLAN_BUCKET AND F.FIELDNAME='PL_VIOLATION_RULE' AND F.FIELDVALUE = A.PL_VIOLATION_RULE AND A.PROBINST = G.PROBINST
|
| # |
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
|
| 24 |
START_DATE |
Date(10) |
DATE |
Start Date for Gen Standing PO
|
| 25 |
END_DATE |
Date(10) |
DATE |
End Date
|
| 26 |
CAPACITY_DATE |
Date(10) |
DATE |
08/31/01 EGS (CN#PL900-1): Added.
|
| 27 |
DYN_CHAR_COL1 |
Character(30) |
VARCHAR2(30) NOT NULL |
Dynamic Character Column 1
|
| 28 |
DYN_CHAR_COL2 |
Character(30) |
VARCHAR2(30) NOT NULL |
Dynamic Character Column 2
|
| 29 |
DYN_CHAR_COL3 |
Character(30) |
VARCHAR2(30) NOT NULL |
Dynamic Character Column 3
|
| 30 |
DYN_CHAR_COL4 |
Character(30) |
VARCHAR2(30) NOT NULL |
Dynamic Character Column 4
|
| 31 |
DYN_CHAR_COL5 |
Character(30) |
VARCHAR2(30) NOT NULL |
Dynamic Character Column 5
|
| 32 |
DESCR_VALUE_1 |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 33 |
DESCR_VALUE_2 |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 34 |
DESCR_VALUE_3 |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 35 |
DESCR_VALUE_4 |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 36 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 37 |
TIMEZONE |
Character(9) |
VARCHAR2(9) NOT NULL |
Time Zone
|