RB_CIM_RCOL_VW(SQL View) |
Index Back |
|---|---|
Batch Run Collection ViewView of the Constituent Data Importer Batch Collection where key is based on Process Instance instead of Run Control |
| SELECT PROCESS_INSTANCE ,BATCH_ID ,RUN_CNTL_ID ,CIM_RUNBAT_STAT ,START_DTTM ,END_DTTM ,CONFIG_ID ,CNT_ROWS ,CNT_ADDED ,CNT_ERRORS ,CNT_IGNORED ,CNT_POSTED ,CNT_PROCESSED ,CNT_PURGED ,CNT_SKIPPED ,CNT_SUSPENDED ,CNT_UNCHANGED ,CNT_UPDATED FROM %Table(RB_CIM_RUNCOL) WHERE PROCESS_INSTANCE <> 0 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL |
Process Instance
Default Value: 0 |
| 2 | BATCH_ID |
Number(15,0) | DECIMAL(15) NOT NULL | CDH INTERFACE TABLE FIELD - BATCH_ID |
| 3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL |
Run Control ID
Prompt Table: RB_CIM_RUNSPEC |
| 4 | CIM_RUNBAT_STAT | Character(1) | VARCHAR2(1) NOT NULL |
Execution status of a specific batch included in a run collection
A=Aborted C=Completed I=In Process P=Pending Q=Queued Default Value: Q |
| 5 | START_DTTM | DateTime(26) | TIMESTAMP | start date time |
| 6 | END_DTTM | DateTime(26) | TIMESTAMP | end date time |
| 7 | CONFIG_ID | Character(20) | VARCHAR2(20) NOT NULL |
Configuration ID
Prompt Table: RB_SM_CONFIG |
| 8 | CNT_ROWS | Number(9,0) | DECIMAL(9) NOT NULL |
Total Row Count
Default Value: 0 |
| 9 | CNT_ADDED | Number(9,0) | DECIMAL(9) NOT NULL |
Count of the number of new rows/people created
Default Value: 0 |
| 10 | CNT_ERRORS | Number(9,0) | DECIMAL(9) NOT NULL |
Number of rows failing validation or generating errors
Default Value: 0 |
| 11 | CNT_IGNORED | Number(9,0) | DECIMAL(9) NOT NULL |
Number of rows marked as ignored
Default Value: 0 |
| 12 | CNT_POSTED | Number(9,0) | DECIMAL(9) NOT NULL |
Count of rows posted (add or update)
Default Value: 0 |
| 13 | CNT_PROCESSED | Number(9,0) | DECIMAL(9) NOT NULL |
Count of the number of rows processed
Default Value: 0 |
| 14 | CNT_PURGED | Number(9,0) | DECIMAL(9) NOT NULL |
Count of rows purged
Default Value: 0 |
| 15 | CNT_SKIPPED | Number(9,0) | DECIMAL(9) NOT NULL |
Number of rows not processed for some reason
Default Value: 0 |
| 16 | CNT_SUSPENDED | Number(9,0) | DECIMAL(9) NOT NULL |
Number of rows marked as Suspended
Default Value: 0 |
| 17 | CNT_UNCHANGED | Number(9,0) | DECIMAL(9) NOT NULL |
Number of rows unchanged. These rows had no effect on the underlying data
Default Value: 0 |
| 18 | CNT_UPDATED | Number(9,0) | DECIMAL(9) NOT NULL |
Number of rows/constituents updated (modified or changed)
Default Value: 0 |