HCSC_TMPL_S_VW

(SQL View)
 Index Back

Notif Template Security View

Notification Template Security View

SELECT OPR.OPRID , TMPL.HCSC_EMAIL_TMPL_ID , GTMPL.DESCR FROM PS_HCSC_NOTIF_TMPL TMPL , PS_WL_TEMPLATE_GEN GTMPL , PSOPRDEFN OPR WHERE TMPL.HCSC_EMAIL_TMPL_ID = GTMPL.WL_TEMPLATE_ID AND (EXISTS ( SELECT 'X' FROM PS_HCSC_NOTIF_TMPL TMPL1 WHERE TMPL1.HCSC_EMAIL_TMPL_ID = TMPL.HCSC_EMAIL_TMPL_ID AND TMPL1.HCSC_TMPL_SEC_TYPE = 'P') OR EXISTS ( SELECT 'X' FROM PS_HCSC_TMPL_ROLE TROL2 , PSROLEUSER ROL WHERE TROL2.HCSC_EMAIL_TMPL_ID = TMPL.HCSC_EMAIL_TMPL_ID AND TMPL.HCSC_TMPL_SEC_TYPE = 'S' AND TROL2.ROLENAME = ROL.ROLENAME AND ROL.ROLEUSER = OPR.OPRID))

  • Related Language Record: HCSC_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 HCSC_EMAIL_TMPL_ID Character(30) VARCHAR2(30) NOT NULL Email Template ID
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description