AGC_TMPL_S_VW

(SQL View)
 Index Back

AGC Template Security View

Activity Guide Composer Template Security View

SELECT OPR.OPRID , TMPL.AGC_TEMPLATE_ID , TMPL.DESCR100 , TMPL.DESCRLONG , TMPL.AGC_ACTIVE_FLAG , TMPL.AGC_CATEGORY_ID FROM PS_AGC_TMPL_TBL TMPL , PSOPRDEFN OPR WHERE 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: AGC_TMPL_S_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 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
    4 DESCRLONG Long Character CLOB Long Description
    5 AGC_ACTIVE_FLAG Character(1) VARCHAR2(1) NOT NULL Activity Guide Composer Active Flag
    N=No
    Y=Yes
    6 AGC_CATEGORY_ID Character(15) VARCHAR2(15) NOT NULL Activity Guide Category

    Prompt Table: AGC_CAT_TBL