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 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL |
Run Control ID
Prompt Table: RB_CIM_RUNSPEC |
2 | BATCH_ID | 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 |