GPMX_ELEM_MAP_D

(SQL Table)
Index Back

Element Mapping Detail

Element Mapping Detail

  • Parent record: GPMX_ELEM_MAP
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

    2 GPMX_KEY_TYPE Character(1) VARCHAR2(1) NOT NULL Define the Key Type for Element Mapping (Record or Component)
    C=Component
    R=Record
    3 GPMX_KEY_NAME Character(18) VARCHAR2(18) NOT NULL Element Mapping Name

    Prompt Table: %RECNAME_EDIT

    4 GPMX_MAP_TYPE Character(1) VARCHAR2(1) NOT NULL Mapping Type
    F=Field
    O=Other
    5 GPMX_MAP_FROM Character(18) VARCHAR2(18) NOT NULL Element that is going to be mapped (Field or Variable)

    Prompt Table: %RECNAME_EDIT
    Set Control Field: GPMX_KEY_NAME

    6 ENTRY_TYPE_ID Character(3) VARCHAR2(3) NOT NULL Element Entry Type ID

    Prompt Table: GP_ENTRY_TYPE

    7 PIN_ELEM_NUM Number(8,0) INTEGER NOT NULL Element Number

    Prompt Table: %GP_EDIT_FLD2