JRNL_APPR_WL(SQL Table) |
Index Back |
|---|---|
Journal Approval Worklist Rec |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSPROCNAME |
Character(30) | VARCHAR2(30) NOT NULL | Business Process Name (see PSBUSPROCDEFN). |
| 2 | ACTIVITYNAME |
Character(30) | VARCHAR2(30) NOT NULL | Name of a Business Process Activity (see PSACTIVITYDEFN). |
| 3 | EVENTNAME |
Character(30) | VARCHAR2(30) NOT NULL | Defines a routing event for PS Workflow |
| 4 | WORKLISTNAME |
Character(30) | VARCHAR2(30) NOT NULL | Worklist Name |
| 5 | INSTANCEID |
Number(10,0) | DECIMAL(10) NOT NULL | For a given worklist the unique number of rows in PSWORKLIST |
| 6 | TRANSACTIONID |
Number(10,0) | DECIMAL(10) NOT NULL | Transaction Identifier |
| 7 | APPR_INSTANCE |
Number(9,0) | DECIMAL(9) NOT NULL | Unique number for each runtime occurrence of a virtual approver process |
| 8 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 9 | JOURNAL_ID |
Character(10) | VARCHAR2(10) NOT NULL | Identifies a journal entry, consisting of a header and one or more lines. The Journal ID itself does not have to be unique, but together with the journal business unit and journal date, it forms a unique journal identifier. |
| 10 | JOURNAL_DATE |
Date(10) | DATE | Specifies the date the journal was created. |
| 11 | JRNL_IU_HDR_STATUS |
Character(1) | VARCHAR2(1) NOT NULL |
Journal Header Status
E=Journal Has Errors N=No Status - Needs to be Edited P=Main Jrnl Posted (InterUnit) U=Main Jrnl Unposted (InterUnit) V=Valid Journal - Edits Complete |
| 12 | UNPOST_SEQ | Number(2,0) | SMALLINT NOT NULL | Identifies the sequence of journal entries when a journal is "unposted". When a journal is posted the UnPost Sequence is automatically set to "0". When a journal is unposted, a new reversing entry is automatically created with an UnPost Sequence of "1". |
| 13 | BUSINESS_UNIT_LN | Character(5) | VARCHAR2(5) NOT NULL | Line Business Unit |