SJ_JRNL_TMPL_VW(SQL View) |
Index Back |
---|---|
Simp Jrnl Entry - Tmpl PromptThis 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 |