SJ_JOURNAL_TYPEPrompt Table: SJ_JOURNAL_TYPE
SJ_TEMPLATE_IDSEQ_NBR_3Prompt Table: GL_OPRID_DVW
Prompt Table: OPRCLASSDEFN_VW
Prompt Table: GL_ROLEDEFN_DVW
SJ_JRNL_TMP_SEC(SQL Table) |
Index Back |
|---|---|
Simple Journal Tmplt Security |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SJ_JOURNAL_TYPE |
Character(5) | VARCHAR2(5) NOT NULL |
Journal Type
Prompt Table: SJ_JOURNAL_TYPE |
| 2 | SJ_TEMPLATE_ID |
Character(30) | VARCHAR2(30) NOT NULL | Simplified Journal Tempale |
| 3 | SEQ_NBR_3 |
Number(3,0) | SMALLINT NOT NULL | Sequence |
| 4 | OPRID | Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: GL_OPRID_DVW |
| 5 | OPRCLASS | Character(30) | VARCHAR2(30) NOT NULL |
Operator Class
Prompt Table: OPRCLASSDEFN_VW |
| 6 | ROLENAME | Character(30) | VARCHAR2(30) NOT NULL |
The name of a Role in the Role Definition Table (see PSROLEDEFN).
Prompt Table: GL_ROLEDEFN_DVW |