RB_IMPMAP_IN_VW

(SQL View)
 Index Back

mapping rule sequence

defines individual mapping rules

SELECT LI_IMPORT_ID , EFFDT , SEQ_NUM , LI_MAP_TYPE , LI_MAPPING_SRC , SOURCE_FIELD_NUM , LI_XLAT_SET_ID , LI_TEMPLATE_ID , LI_TREE_SEQ , FIELDNAME , VALUE_DISPLAY , LI_TEMPLATE_RULE , REQUIRED_FLAG , LI_ACTION , GROUP_SEQ_NUM , LI_UNIQUE_ID FROM PS_RB_IMPORT_MAP WHERE LI_MAP_TYPE = '01'

  • Parent record: RB_IMPORT_DEFN

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

    Prompt Table: RB_IMPORT_DEFN

    2 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    3 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
    4 LI_MAP_TYPE Character(2) VARCHAR2(2) NOT NULL what type of mapping is being defined?
    01=Basic
    02=Advanced

    Default Value: 01

    5 LI_MAPPING_SRC Character(2) VARCHAR2(2) NOT NULL from whence come values to be mapped?
    01=Field
    02=Constant
    03=Concatenate
    04=Translation Set

    Default Value: 01

    6 SOURCE_FIELD_NUM Number(3,0) SMALLINT NOT NULL Input File Source Field Input Number
    7 LI_XLAT_SET_ID Character(31) VARCHAR2(31) NOT NULL Translate Set ID
    8 LI_TEMPLATE_ID Character(31) VARCHAR2(31) NOT NULL template identifier
    9 LI_TREE_SEQ Number(3,0) SMALLINT NOT NULL in what position is this tree element?
    10 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    11 VALUE_DISPLAY Character(254) VARCHAR2(254) NOT NULL Value
    12 LI_TEMPLATE_RULE Character(2) VARCHAR2(2) NOT NULL action to take for a field in a given template
    01=Generate Standard Key
    02=Generate Sequence Key
    03=Reference Key
    04=Required Input
    05=Optional Input
    06=Value
    07=Value Reference
    08=Lookup Value
    09=Concatenation
    10=Insert Null
    11=Generate Id - Not Key
    12=Generate Datetime Stamp
    13=Fetch Text
    14=Staged Default
    15=Mandatory Value
    16=First of Group
    17=Write Contact Method
    18=Cache Contact Method
    19=Map Field Reference
    20=Bas SysId
    13 REQUIRED_FLAG Character(1) VARCHAR2(1) NOT NULL Required
    N=No
    Y=Yes

    Y/N Table Edit

    14 LI_ACTION Character(2) VARCHAR2(2) NOT NULL Import Action
    01=Import
    02=Ignore

    Default Value: 01

    15 GROUP_SEQ_NUM Number(6,0) INTEGER NOT NULL Specifies the system-assigned sequence number of a pending item within a group. A group is a postable entity that may be entered online or created by the system. In either case the group sequence number is automatically generated.
    16 LI_UNIQUE_ID Character(31) VARCHAR2(31) NOT NULL Unique_Id