AGC_TMPL_D_VW

(SQL View)
 Index Back

AGC Template Date View

Activity Guide Template Date View

SELECT OPR.OPRID , TMPL.AGC_TEMPLATE_ID , TMPL.EFFDT , TMPL.DESCR100 FROM PS_AGC_TMPL_TBL TMPL , PSOPRDEFN OPR WHERE (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_D_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_EFFDT Date(10) DATE Activity Guide Composer Effective Date

    Default Value: %date

    4 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description