OPRIDPrompt Table: OPERATOR_VW
RUN_CNTL_IDBUSINESS_UNITAUC_IDAUC_ROUNDAUC_VERSIONB=Bidder
C=Customer
P=Public
U=Uploaded
V=Supplier
N=No
Y=Yes
Default Value: 9
Default Value: 9
AUC_RUN_CNTL1(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: OPERATOR_VW |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 4 | AUC_ID |
Character(10) | VARCHAR2(10) NOT NULL | Event ID |
| 5 | AUC_ROUND |
Number(5,0) | INTEGER NOT NULL | Event Round |
| 6 | AUC_VERSION |
Number(5,0) | INTEGER NOT NULL | Event Version |
| 7 | BIDNUM | Signed Number(6,0) | DECIMAL(5) NOT NULL | Bid ID |
| 8 | BIDDER_SETID | Character(5) | VARCHAR2(5) NOT NULL | Bidder Setid |
| 9 | BIDDER_ID | Character(15) | VARCHAR2(15) NOT NULL | Bidder ID |
| 10 | BIDDER_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Bidder Type
B=Bidder C=Customer P=Public U=Uploaded V=Supplier |
| 11 | BIDDER_LOC | Character(10) | VARCHAR2(10) NOT NULL | Bidder Location |
| 12 | IN_PROCESS_FLG | Character(1) | VARCHAR2(1) NOT NULL | In process flag |
| 13 | EMAIL_FLG | Character(1) | VARCHAR2(1) NOT NULL |
When the email flag is checked, the user will notified a specific user regarding an activity.
N=No Y=Yes |
| 14 | AUC_EMAIL_TYPE | Character(10) | VARCHAR2(10) NOT NULL | Email Notification Type |
| 15 | RET_CODE | Number(1,0) | SMALLINT NOT NULL |
Return Code
Default Value: 9 |
| 16 | BID_EXISTS_RESP | Number(1,0) | SMALLINT NOT NULL |
Bidder Exists
Default Value: 9 |
| 17 | URL | Character(254) | VARCHAR2(254) NOT NULL | Internet URL (Universal Resource Locator) |
| 18 | AUC_DTTM_START | DateTime(26) | TIMESTAMP | Date Time Start |
| 19 | AUC_DTTM_FINISH | DateTime(26) | TIMESTAMP | Date Time Finish |
| 20 | AUC_PREV_DATE | Date(10) | DATE | Collaboration Due Date |
| 21 | AUC_NOTIFY_FLG | Character(1) | VARCHAR2(1) NOT NULL | Notify |
| 22 | AUC_PDF_FLG | Character(1) | VARCHAR2(1) NOT NULL | Create PDF on Event Post |