GP_PKG_IDCOUNTRYGPMX_KEY_TYPEC=Component
R=Record
GPMX_KEY_NAMEGPMX_MAP_TYPEF=Field
O=Other
GPMX_MAP_FROMGPMX_NRP_ELM_AD(SQL Table) |
Index Back |
|---|---|
Element Mapping DetailElement Mapping Detail |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GP_PKG_ID |
Character(10) | VARCHAR2(10) NOT NULL | Field used for element packaging |
| 2 | COUNTRY |
Character(3) | VARCHAR2(3) NOT NULL | Country |
| 3 | GPMX_KEY_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Define the Key Type for Element Mapping (Record or Component)
C=Component R=Record |
| 4 | GPMX_KEY_NAME |
Character(18) | VARCHAR2(18) NOT NULL | Element Mapping Name |
| 5 | GPMX_MAP_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Mapping Type
F=Field O=Other |
| 6 | GPMX_MAP_FROM |
Character(18) | VARCHAR2(18) NOT NULL | Element that is going to be mapped (Field or Variable) |
| 7 | ENTRY_TYPE_ID | Character(3) | VARCHAR2(3) NOT NULL | Element Entry Type ID |
| 8 | PIN_ELEM_NUM | Number(8,0) | INTEGER NOT NULL | Element Number |