GPAR_NRP_EMD_VW(SQL View) |
Index Back |
|---|---|
Element MappingElement Mapping to Components or Records |
| SELECT COUNTRY ,GPAR_KEY_TYPE ,GPAR_KEY_NAME ,GPAR_MAP_TYPE ,GPAR_MAP_FROM ,ENTRY_TYPE_ID ,PIN_ELEM_NUM + 50000000 FROM PS_GPAR_ELEM_MAP_D |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 2 | GPAR_KEY_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Define the Key Type for Element Mapping (Record or Component)
C=Component R=Record |
| 3 | GPAR_KEY_NAME | Character(18) | VARCHAR2(18) NOT NULL | Element Mapping Name |
| 4 | GPAR_MAP_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Mapping Type
F=Field O=Other |
| 5 | GPAR_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 |
| 7 | PIN_ELEM_NUM | Number(8,0) | INTEGER NOT NULL | Element Number |