OPRIDPIN_NUMLANGUAGE_CDELEM_GRP_USE_OPTNALL=All-Purpose
ELG=Eligibility
ELN=Applications
PRC=Process Set
GP_EG_SRCH_LV(SQL View) |
Index Back |
|---|---|
Element Group Srch Rel LangRelated Language view for Elemeng Group component (this is the same related language view as GP_PIN_SRCH_LV except it also shows ELEM_GRP_USE_OPTN which is used on Element Group search as well) |
| SELECT C.OPRID , B.PIN_NUM , B.PIN_NUM , L.LANGUAGE_CD , L.PIN_NM , L.DESCR , D.ELEM_GRP_USE_OPTN FROM PS_GP_PIN B , PS_GP_OPR_RULE_PRF C , PS_GP_PIN_LANG L , PS_GP_ELEM_GRP D WHERE L.PIN_NUM = B.PIN_NUM AND B.PIN_NUM = D.PIN_NUM |
| # | 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 | PIN_NUM |
Number(8,0) | INTEGER NOT NULL | PIN Number |
| 3 | PIN_SRCH_NUM | Number(8,0) | INTEGER NOT NULL | Field used in PIN component search views |
| 4 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | PIN_NM | Character(18) | VARCHAR2(18) NOT NULL | Element Name field |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | ELEM_GRP_USE_OPTN |
Character(3) | VARCHAR2(3) NOT NULL |
Attribute of Element Group inidicating the use and purpose of this particular element group.
ALL=All-Purpose ELG=Eligibility ELN=Applications PRC=Process Set |