GDP_INST_VW

(SQL View)
 Index Back

GDP Template Priv. View

Guided Process Instance Privilege View - Used to display the Guided Process instances created and accessible by the operater on the Guided Process Summary.

SELECT OPR.OPRID , GPT.GDP_TEMPLATE_ID , LST.PTAI_LIST_ID , LST.PTAI_LABEL FROM PS_GDP_TMPL_TBL GPT , PSOPRDEFN OPR , PS_PTAI_LIST LST WHERE GPT.GDP_TEMPLATE_ID = LST.PTAI_PARENT_TMPL 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'))

  • Related Language Record: GDP_INST_LVW

    • # 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 GDP_LIST_ID Character(31) VARCHAR2(31) NOT NULL Guided Process List ID (PTAI List ID assigned to Guided Process Template)
    4 GDP_LABEL Character(100) VARCHAR2(100) NOT NULL Guided Process Title