OPRIDRUN_CNTL_IDSETIDDefault Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW
B=Begins With
E=Equals
B=Begins With
E=Equals
Prompt Table: SP_BUPRCR_NONVW
A=Active
I=Inactive
O=Open
PV_RUN_OS_UPD(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). |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 4 | PV_OS_OPERATOR1 | Character(1) | VARCHAR2(1) NOT NULL |
Operator
B=Begins With E=Equals |
| 5 | PV_OS_OPERATOR2 | Character(1) | VARCHAR2(1) NOT NULL |
Operator
B=Begins With E=Equals |
| 6 | PV_ORD_SHEET_ID | Character(20) | VARCHAR2(20) NOT NULL | Order Sheet ID |
| 7 | PV_OS_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Order Sheet Description |
| 8 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL |
GL Business Unit
Prompt Table: SP_BUPRCR_NONVW |
| 9 | PV_OS_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Order Sheet Status
A=Active I=Inactive O=Open |