RB_CIM_RSPEC_VW

(SQL View)
 Index Back

Data Importer Run Parameters

View of the Constituent Data Importer run specification (parameters) where key is based on Process Instance instead of Run Control

SELECT PROCESS_INSTANCE , RUN_CNTL_ID , CIM_RUN_TYPE , CIM_LOG_LEVEL , START_DTTM , END_DTTM , SETID , RA_LIST_ID , BYPASS_VAL , BYPASS_UPD , BYPASS_ADD , BYPASS_SM , CIM_NOSM_ACTION , CREATED_BY_USER , CREATED_DTTM FROM %Table(RB_CIM_RUNSPEC) WHERE PROCESS_INSTANCE <> 0

  • Parent Record Of RB_CIM_RCOL_VW RB_CIM_RLOG_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

    Default Value: NEXT

    3 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

    Default Value: I

    4 CIM_LOG_LEVEL Number(1,0) SMALLINT NOT NULL Logging Level Indicator

    Default Value: 0

    5 START_DTTM DateTime(26) TIMESTAMP start date time
    6 END_DTTM DateTime(26) TIMESTAMP end date time
    7 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

    Prompt Table: SP_SETID_NONVW

    8 RA_LIST_ID Character(15) VARCHAR2(15) NOT NULL Audience ID

    Prompt Table: RA_LIST_IMP_VW

    9 BYPASS_VAL Character(1) VARCHAR2(1) NOT NULL Bypass validation operation when processing rows or sets of rows
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    10 BYPASS_UPD Character(1) VARCHAR2(1) NOT NULL Bypass all update/modification processing indicator
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    11 BYPASS_ADD Character(1) VARCHAR2(1) NOT NULL Field to indicate that no new records should be processed
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    12 BYPASS_SM Character(1) VARCHAR2(1) NOT NULL Bypass executing search / match operations in order to identify individuals
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    13 CIM_NOSM_ACTION Character(1) VARCHAR2(1) NOT NULL Field used to specify the action to be performed when the Search/Match infrastructure is disabled. Update and Error are not valid here.
    A=Add Person
    I=Ignore
    R=Ready for Processing
    S=Suspend
    14 CREATED_BY_USER Character(30) VARCHAR2(30) NOT NULL Created By
    15 CREATED_DTTM DateTime(26) TIMESTAMP NOT NULL Created Datetime

    Default Value: %DateTime