RB_CIM_HIST_VW

(SQL View)
 Index Back

Data Import Batch Run History

This view returns the run history for a higher education data import batch.

SELECT B.BATCH_ID , A.RUN_CNTL_ID , A.PROCESS_INSTANCE , A.CIM_RUN_TYPE , A.CREATED_DTTM , A.CREATED_BY_USER , A.SETID , A.RA_LIST_ID , B.CIM_RUNBAT_STAT , B.START_DTTM , B.END_DTTM , B.CNT_PROCESSED FROM PS_RB_CIM_RUNSPEC A , PS_RB_CIM_RUNCOL B WHERE B.RUN_CNTL_ID = A.RUN_CNTL_ID AND B.PROCESS_INSTANCE = A.PROCESS_INSTANCE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BATCH_ID Number(15,0) DECIMAL(15) NOT NULL CDH INTERFACE TABLE FIELD - BATCH_ID
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
4 CIM_RUN_TYPE Character(1) VARCHAR2(1) NOT NULL Field used to indicate the type of Data Importer mode/operation to execute (Import or Purge)
I=Import
P=Purge
5 CREATED_DTTM DateTime(26) TIMESTAMP Created Datetime
6 CREATED_BY_USER Character(30) VARCHAR2(30) NOT NULL Created By
7 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
8 RA_LIST_ID Character(15) VARCHAR2(15) NOT NULL Audience ID
9 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
10 START_DTTM DateTime(26) TIMESTAMP start date time
11 END_DTTM DateTime(26) TIMESTAMP end date time
12 CNT_PROCESSED Number(9,0) DECIMAL(9) NOT NULL Count of the number of rows processed