OPRIDGDP_TEMPLATE_IDLANGUAGE_CDGDP_INST_LVW(SQL View) |
Index Back |
|---|---|
GDP Template Priv. Rel Lang VwGuided Process Privelege Related Language View |
| SELECT OPR.OPRID , GPT.GDP_TEMPLATE_ID , LSTL.LANGUAGE_CD , LSTL.PTAI_LABEL FROM PS_GDP_TMPL_TBL GPT , PSOPRDEFN OPR , PS_PTAI_LIST LST , PS_PTAI_LIST_LNG LSTL WHERE GPT.GDP_TEMPLATE_ID = LST.PTAI_PARENT_TMPL AND LST.PTAI_LIST_ID = LSTL.PTAI_LIST_ID AND OPR.OPRID = LST.CREATEOPRID AND EXISTS ( SELECT 'X' FROM PS_GDP_TMPL_PRIV PRL , PSROLEUSER ROL WHERE PRL.GDP_MBR_TYPE = 'ROLE' AND PRL.GDP_MBR_NAME = ROL.ROLENAME AND ROL.ROLEUSER = OPR.OPRID AND PRL.GDP_PRIVSET_ID IN ('PTAI_CONTRIBUTOR', 'PTAI_ADMINISTRATOR')) |
| # | 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 | GDP_TEMPLATE_ID |
Character(10) | VARCHAR2(10) NOT NULL | Guided Process Template ID |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | GDP_LABEL | Character(100) | VARCHAR2(100) NOT NULL | Guided Process Title |