TR_MAP_ITEMS

(SQL Table)
Index Back

CodeSet Mapping Items

Contains the different code mappings for a given field.

  • Parent record: TR_MAP_HEADER
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 MAPPING_GROUP_ID Character(10) VARCHAR2(10) NOT NULL Unique identifier for the mapping group.
    2 MAPPING_FIELD_NAME Character(25) VARCHAR2(25) NOT NULL Identifies the field being mapped.
    3 MAPPING_ID Number(9,0) DECIMAL(9) NOT NULL Unique identifier for a given mapping
    4 MAPPING_INPUT Character(30) VARCHAR2(30) NOT NULL Input value used to obtain the corresponding mapped value.
    5 MAPPING_OUTPUT Character(100) VARCHAR2(100) NOT NULL Output value returned when compared against the corresponding mapped value.