OPRIDCOUNTRYDefault Value: GP_OPR_RULE_PRF.COUNTRY
Prompt Table: GP_ED_CTRY_VW
PIN_CATEGORYPrompt Table: GP_PIN_CAT_C_VW
ENTRY_TYPE_ELEMPrompt Table:
GP_ENT_E_D_VW
Set Control Field: DESCR
GP_ED_SETC_SRCH(SQL View) |
Index Back |
|---|---|
Element Setup SearchThis search record selects from the Element Setup |
| SELECT PRF.OPRID , ED.COUNTRY ,ED.PIN_CATEGORY ,ED.ENTRY_TYPE_ELEM FROM PS_GP_ED_SETUP_CAT ED ,PS_GP_OPR_RULE_PRF PRF WHERE PRF.COUNTRY = 'ALL' OR PRF.COUNTRY = ED.COUNTRY OR ED.COUNTRY = 'ALL' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | COUNTRY |
Character(3) | VARCHAR2(3) NOT NULL |
Country
Default Value: GP_OPR_RULE_PRF.COUNTRY Prompt Table: GP_ED_CTRY_VW |
| 3 | PIN_CATEGORY |
Character(4) | VARCHAR2(4) NOT NULL |
Element Category
Prompt Table: GP_PIN_CAT_C_VW |
| 4 | ENTRY_TYPE_ELEM |
Character(3) | VARCHAR2(3) NOT NULL |
entry type element
Prompt Table:
GP_ENT_E_D_VW
|