AGC_TMPL_S_LVW

(SQL View)
 Index Back

AGC Template Security View

Activity Guide Composer Template Security View

SELECT OPR.OPRID , TMPL.AGC_TEMPLATE_ID , TMPLNG.LANGUAGE_CD , TMPLNG.DESCR100 , TMPLNG.DESCRLONG FROM PS_AGC_TMPL_TBL TMPL , PS_AGC_TMPL_LNG TMPLNG , PSOPRDEFN OPR WHERE TMPL.AGC_TEMPLATE_ID = TMPLNG.AGC_TEMPLATE_ID AND TMPL.EFFDT = ( SELECT MAX(TMPL_ED.EFFDT) FROM PS_AGC_TMPL_TBL TMPL_ED WHERE TMPL_ED.AGC_TEMPLATE_ID = TMPL.AGC_TEMPLATE_ID) AND (NOT EXISTS ( SELECT 'X' FROM PS_AGC_TMPL_PRIV PRIV1 WHERE PRIV1.AGC_TEMPLATE_ID = TMPL.AGC_TEMPLATE_ID) OR EXISTS ( SELECT 'X' FROM PS_AGC_TMPL_PRIV PRIV2 , PSROLEUSER ROL WHERE PRIV2.AGC_TEMPLATE_ID = TMPL.AGC_TEMPLATE_ID AND PRIV2.AGC_ROLENAME = ROL.ROLENAME AND ROL.ROLEUSER = OPR.OPRID AND PRIV2.AGC_ADMIN = 'Y' AND PRIV2.AGC_PRIVSET_ID = 'PTAI_ADMINISTRATOR'))

  • Related Language Record for AGC_TMPL_S_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
    5 DESCRLONG Long Character CLOB Long Description