PV_RUN_OS2_VLD(SQL Table) |
Index Back |
---|---|
Order Sheet Mass ValidateRun control record for Order Sheet Mass Validate AE process |
# | 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 |
2 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
3 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
4 | PV_ORD_SHEET_ID | Character(20) | VARCHAR2(20) NOT NULL | Order Sheet ID |
5 | PV_OS_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Order Sheet Description |
6 | VALIDATION_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Validation Status
E=Error I=Initial V=Valid |
7 | SELECT_CHKBOX2 | Character(1) | VARCHAR2(1) NOT NULL |
Check Box for Site Selected on comparison Matrix Page
N=No Y=Yes |