OPRIDDefault Value: PSOPRDEFN.OPRID
Prompt Table: PSOPRDEFN
RUN_CNTL_IDSEQ_NUMEOEW_PROC_SEQPrompt Table: EOEW_MAP_DFN
EOEW_RUN_PRC_VW(SQL View) |
Index Back |
|---|---|
ETL Runtime process cache |
| SELECT OPRID , RUN_CNTL_ID , SEQ_NUM , EOEW_PROC_SEQ , PROCESS_INSTANCE , EOEW_GRP_OBJ , EOEW_MAP_OBJ , EOEW_CHUNK_SQL FROM PS_EOEW_RUN_PROC |
| # | 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: PSOPRDEFN.OPRID Prompt Table: PSOPRDEFN |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Sequence |
| 4 | EOEW_PROC_SEQ |
Number(3,0) | SMALLINT NOT NULL | Process Sequence Number |
| 5 | PRCSINSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 6 | EOEW_GRP_OBJ | Character(15) | VARCHAR2(15) NOT NULL | Map Group |
| 7 | EOEW_MAP_OBJ | Character(15) | VARCHAR2(15) NOT NULL |
Map Object
Prompt Table: EOEW_MAP_DFN |
| 8 | EOEW_CHUNK_SQL | Character(254) | VARCHAR2(254) NOT NULL | Chunking Where clause |