SJ_JRNL_TMPL_VW

(SQL View)
Index Back

Simp Jrnl Entry - Tmpl Prompt

This view is used as the prompt record for the Template on the Search page.

SELECT DISTINCT A.SJ_JOURNAL_TYPE , A.SJ_TEMPLATE_ID , A.CF_SECURITY , C.OPRID , C.ROLENAME , C.OPRCLASS FROM PS_SJ_JRNL_TMPLT A , PS_SJ_JRNL_HDR_DEF B , PS_SJ_JRNL_TMP_SEC C WHERE A.SJ_JOURNAL_TYPE = B.SJ_JOURNAL_TYPE AND A.SJ_TEMPLATE_ID = B.SJ_TEMPLATE_ID AND A.SJ_JOURNAL_TYPE = C.SJ_JOURNAL_TYPE AND A.SJ_TEMPLATE_ID = C.SJ_TEMPLATE_ID AND (C.OPRID = %OperatorId OR A.CF_SECURITY = '0' OR C.ROLENAME IN ( SELECT ROLENAME FROM PSROLEUSER WHERE ROLEUSER = %OperatorId) OR C.OPRCLASS IN ( SELECT CLASSID FROM PSROLECLASS WHERE ROLENAME IN ( SELECT ROLENAME FROM PSROLEUSER WHERE ROLEUSER = %OperatorId)))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SJ_JOURNAL_TYPE Character(5) VARCHAR2(5) NOT NULL Journal Type
2 SJ_TEMPLATE_ID Character(30) VARCHAR2(30) NOT NULL Simplified Journal Tempale
3 CF_SECURITY Character(1) VARCHAR2(1) NOT NULL Enable ChartField Securtity
0=No Security
1=User ID
2=Role
3=Permission List
4 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
5 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).
6 OPRCLASS Character(30) VARCHAR2(30) NOT NULL Operator Class