RB_CIM_RUNSPEC

(SQL Table)
 Index Back

Data Importer Run Parameters

Record used to stored the majority of run parameters for executing a Data Import process for CRM Higher Education importing of Suspects and Prospects.

  • Parent Record Of RB_CIM_RUNCOL RB_CIM_RUN_LOG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

    Default Value: NEXT

    2 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    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