AGC_INST_VW

(SQL View)
 Index Back

AGC Instances View

Activity Guide Composer Instances View

SELECT DISTINCT OPR.OPRID , TMPL.AGC_TEMPLATE_ID , LST.PTAI_LIST_ID , LST.PTAI_PARENT_TMPL , LST.PTAI_LABEL FROM PS_AGC_TMPL_TBL TMPL , PSOPRDEFN OPR , PS_PTAI_LIST LST WHERE TMPL.AGC_TEMPLATE_ID = %Substring(LST.PTAI_PARENT_TMPL,1,7) AND (EXISTS ( SELECT 'X' FROM PS_PTAI_LIST_PRIV PRIV WHERE PRIV.PTAI_LIST_ID = LST.PTAI_LIST_ID AND PRIV.PTAI_PRIVSET_ID ='PTAI_CONTRIBUTOR' AND EXISTS ( SELECT 'X' FROM PSROLEUSER ROL WHERE ROL.ROLEUSER = OPR.OPRID AND ((PRIV.PTAI_MBR_TYPE = 'USER' AND PRIV.PTAI_MBR_NAME = ROL.ROLEUSER) OR (PRIV.PTAI_MBR_TYPE = 'ROLE' AND PRIV.PTAI_MBR_NAME = ROL.ROLENAME)))))

  • Related Language Record: AGC_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 AGC_TEMPLATE_ID Character(7) VARCHAR2(7) NOT NULL Activity Guide Composer Template Id
    3 AGC_LIST_ID Character(31) VARCHAR2(31) NOT NULL Activity Guide Composer List Id
    4 PTAI_PARENT_TMPL Character(31) VARCHAR2(31) NOT NULL Template ID
    5 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description