GPBR_NRP_EMD_VW

(SQL View)
 Index Back

Element Mapping Detail

Element Mapping Detail

SELECT COUNTRY ,GPBR_KEY_TYPE ,GPBR_KEY_NAME ,GPBR_MAP_TYPE ,GPBR_MAP_FROM ,ENTRY_TYPE_ID ,PIN_ELEM_NUM + 50000000 FROM PS_GPBR_ELEM_MAP_D

  • Parent record: GPBR_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 GPBR_KEY_TYPE Character(1) VARCHAR2(1) NOT NULL Define the Key Type for Element Mapping (Record or Component)
    C=Component
    R=Record
    3 GPBR_KEY_NAME Character(18) VARCHAR2(18) NOT NULL Element Mapping Name

    Prompt Table: %RECNAME_EDIT

    4 GPBR_MAP_TYPE Character(1) VARCHAR2(1) NOT NULL Mapping Type
    F=Field
    O=Other
    5 GPBR_MAP_FROM Character(18) VARCHAR2(18) NOT NULL Element that is going to be mapped (Field or Variable)
    6 ENTRY_TYPE_ID Character(3) VARCHAR2(3) NOT NULL Element Entry Type ID

    Prompt Table: %RECNAME_EDIT2

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

    Prompt Table: %GP_EDIT_FLD2