RUN_CNTL_AUC(SQL Table) |
Index Back |
|---|---|
Run Control for OptimizationParameter table for Batch Optimizaiton Engine run |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: OPR_DEF_TBL_FS.OPRID Prompt Table: OPR_DEF_TBL_PM |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_AUC_BU_NONVW |
| 4 | BUSINESS_UNIT_1 | Character(5) | VARCHAR2(5) NOT NULL |
Non-Joint Venture BU
Prompt Table: SP_AUC_BU_NONVW |
| 5 | OPRID_ENTERED_BY | Character(30) | VARCHAR2(30) NOT NULL |
Entered By
07/25/2011 MRAD 12383033 :Ensured that OPRID_ENTERED_BY is set with format type of MixedCase.
03/22/2013 GL 16482301: Switched OPRID_ENTERED_BY back to MixedCase again. Please don't change it to UpperCase!!!
FYI - The alternatives to use a User ID as uppercase:
1) Create your own User ID, add comments in the Field Properties, and fill out the Owner ID
2) Use %Upper meta-SQL in SQL statements
3) Use Upper function in peoplecodes
Prompt Table:
AUC_OPT_OPRID_V
|
| 6 | AUC_ID | Character(10) | VARCHAR2(10) NOT NULL |
Event ID
Prompt Table:
AUC_OPT_EVSR_VW
|
| 7 | AUC_GROUP_ID | Character(18) | VARCHAR2(18) NOT NULL | GroupID |
| 8 | LINE_NBR | Number(5,0) | INTEGER NOT NULL |
Line Number:
11/24/08 - Added TARGET label [PC product]
Prompt Table: AUC_AWD_DSTLN |
| 9 | AUC_OPT_BASED_ON | Character(1) | VARCHAR2(1) NOT NULL |
Optimization Based On
P=Price S=Score T=Total Cost |
| 10 | AUC_OPT_EXPORT_FLG | Character(1) | VARCHAR2(1) NOT NULL | Export Opt Recommendation |
| 11 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 12 | IN_PROCESS_FLG | Character(1) | VARCHAR2(1) NOT NULL |
In process flag
Y/N Table Edit |