RB_IMPORT_DEFN

(SQL Table)
 Index Back

Import Definition

high-level record for import definition

  • Related Language Record: RB_IMPORT_LNG

  • Parent Record Of RB_FILESPEC_VW RB_IMPMAP_AD_VW RB_IMPMAP_IN_VW RB_IMPORT_MAP RB_IMP_FILESPEC

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LI_IMPORT_ID Character(31) VARCHAR2(31) NOT NULL Import ID

    Default Value: NEXT

    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    4 LI_IMPT_STATUS Character(2) VARCHAR2(2) NOT NULL Effective Status
    01=In Process
    02=Active

    Default Value: 01

    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 LI_SOURCE_IND Character(30) VARCHAR2(30) NOT NULL source indicator for import field value
    8 LI_IMPORT_TYPE_ID Character(31) VARCHAR2(31) NOT NULL Import Tyoe ID (import with role)

    Prompt Table: RB_IMP_TYPE_TBL

    9 LI_MATCHING_ID Character(31) VARCHAR2(31) NOT NULL matching spec id

    Prompt Table: RB_MATCHING_DFN

    10 DTTM_IMPORTED DateTime(26) TIMESTAMP Imported Date Time
    11 LI_IMP_EMPTY_FLAG Character(1) VARCHAR2(1) NOT NULL should empty fields have import values written to them?

    Y/N Table Edit

    Default Value: Y

    12 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File
    13 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename
    14 LI_DELIMITER Character(1) VARCHAR2(1) NOT NULL Delimiter Import
    0=Comma
    1=Semicolon
    2=Tab

    Default Value: 0

    15 LI_HEADER_FLAG Character(1) VARCHAR2(1) NOT NULL does the file have a header?

    Y/N Table Edit

    Default Value: Y

    16 LI_HEADER_ROW_NUM Number(3,0) SMALLINT NOT NULL what row contains the header?
    17 LI_SKIP_NUM_LINES Number(3,0) SMALLINT NOT NULL how many lines should we skip from the header?
    18 LI_FILE_LAYOUT Character(30) VARCHAR2(30) NOT NULL File Layout ID
    19 LI_TARGET_ID Character(31) VARCHAR2(31) NOT NULL field target identifier

    Prompt Table: RB_TARGET_DEFN

    20 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

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

    Prompt Table: RA_LIST_IMP_VW

    22 LI_GROUP_FLAG Character(1) VARCHAR2(1) NOT NULL should these fields be grouped by?

    Y/N Table Edit

    Default Value: N