GPAR_NRP_EMD_VW(SQL View) |
Index Back |
|---|---|
Element Mapping DetailElement Mapping Detail |
| 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
Prompt Table: COUNTRY_TBL |
| 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
Prompt Table: %RECNAME_EDIT |
| 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)
Prompt Table:
%RECNAME_EDIT
|
| 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 |