COUNTRYPrompt Table: COUNTRY_TBL
GPBR_KEY_TYPEC=Component
R=Record
GPBR_KEY_NAMEPrompt Table: %RECNAME_EDIT
GPBR_MAP_TYPEF=Field
O=Other
GPBR_MAP_FROMPrompt Table: %RECNAME_EDIT2
Prompt Table: %GP_EDIT_FLD2
GPBR_ELEM_MAP_D(SQL Table) |
Index Back |
|---|---|
Element Mapping DetailElement Mapping Detail |
| # | 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 |