AGC_TMPL_D_LVW

(SQL View)
 Index Back

AGC Template Date Rel Lang

Activity Guide Template Date Related Language View

SELECT OPR.OPRID , TMPL.AGC_TEMPLATE_ID , TMPL.EFFDT , TMPLNG.LANGUAGE_CD , TMPLNG.DESCR100 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 = TMPLNG.EFFDT 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_D_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 AGC_EFFDT Date(10) DATE Activity Guide Composer Effective Date
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description