HCSC_TMPL_S_LVW

(SQL View)
 Index Back

Notif Template Security View

Notification Template Security View

SELECT OPR.OPRID , TMPL.HCSC_EMAIL_TMPL_ID , GLNTMPL.LANGUAGE_CD , GLNTMPL.DESCR FROM PS_HCSC_NOTIF_TMPL TMPL , PS_WL_TEMPLATE_GLN GLNTMPL , PSOPRDEFN OPR WHERE TMPL.HCSC_EMAIL_TMPL_ID = GLNTMPL.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 for HCSC_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 HCSC_EMAIL_TMPL_ID Character(30) VARCHAR2(30) NOT NULL Email Template ID
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description