RB_CIM_RUNCOL(SQL Table) |
Index Back |
|---|---|
Batch Run Collection TableThis table contains the list of batches to be processed by the Data Importer application engine process |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(30) | VARCHAR2(30) NOT NULL |
Run Control ID
Prompt Table: RB_CIM_RUNSPEC |
|
| 2 | Number(15,0) | DECIMAL(15) NOT NULL | CDH INTERFACE TABLE FIELD - BATCH_ID | |
| 3 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL |
Process Instance
Default Value: 0 |
| 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 |