RB_CIM_RUNCOL

(SQL Table)
Index Back

Batch Run Collection Table

This table contains the list of batches to be processed by the Data Importer application engine process

  • Parent record: RB_CIM_RUNSPEC
  • # 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