GP_PKG_IDCOUNTRYGPAR_KEY_TYPEC=Component
R=Record
GPAR_KEY_NAMEGPAR_MAP_TYPEF=Field
O=Other
GPAR_MAP_FROMGPAR_NRP_EMD_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 | GPAR_KEY_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Define the Key Type for Element Mapping (Record or Component)
C=Component R=Record |
| 4 | GPAR_KEY_NAME |
Character(18) | VARCHAR2(18) NOT NULL | Element Mapping Name |
| 5 | GPAR_MAP_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Mapping Type
F=Field O=Other |
| 6 | GPAR_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 |