PROCESS_INSTANCEREQUEST_NBRSETIDCONSOLIDATION_SETTREE_NAMETREE_LEVELTREE_NODEAS_OF_DATECURRENCY_CDE=Error - Edit Error(s)
N=No Status
V=Valid - No Edit Errors
Default Value: N
A=Aborted
E=Error
S=Successful
U=Undone
CONSOL_PROC_LOG(SQL Table) |
Index Back |
|---|---|
Consolidation Process Log |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | REQUEST_NBR |
Number(4,0) | SMALLINT NOT NULL | Request Number |
| 3 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 4 | CONSOLIDATION_SET |
Character(10) | VARCHAR2(10) NOT NULL | Consolidation Set |
| 5 | TREE_NAME |
Character(18) | VARCHAR2(18) NOT NULL | Tree Name |
| 6 | TREE_LEVEL |
Character(10) | VARCHAR2(10) NOT NULL | Tree Level Number |
| 7 | TREE_NODE |
Character(20) | VARCHAR2(20) NOT NULL | Node name |
| 8 | AS_OF_DATE |
Date(10) | DATE | As of Date |
| 9 | CURRENCY_CD |
Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 10 | CREATE_JRNL_ENTRY | Character(1) | VARCHAR2(1) NOT NULL | Create Journal Entries |
| 11 | CREATE_LOG_SW | Character(1) | VARCHAR2(1) NOT NULL | Create Calculation Log |
| 12 | INCLUDE_ADJ_PER | Character(1) | VARCHAR2(1) NOT NULL | Include Adjustment Period(s) |
| 13 | JRNL_EDIT_ERR_STAT | Character(1) | VARCHAR2(1) NOT NULL |
A flag that indicates whether or not there are edit errors in a journal entry.
E=Error - Edit Error(s) N=No Status V=Valid - No Edit Errors Default Value: N |
| 14 | DTTM_STAMP_SEC | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 15 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 16 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 17 | CONSOL_RUN_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Run Status
A=Aborted E=Error S=Successful U=Undone |
| 18 | UNDO_PREV_PROCESS | Character(1) | VARCHAR2(1) NOT NULL | Undo Previous Process |
| 19 | JOURNAL_ID_FROM | Character(10) | VARCHAR2(10) NOT NULL | Range From Journal ID |
| 20 | JOURNAL_ID_TO | Character(10) | VARCHAR2(10) NOT NULL | Range to Journal ID |
| 21 | MESSAGE_SET_NBR | Number(5,0) | INTEGER NOT NULL | Message Set Number. This field refers to the Message Set Number in the Message Catalog. |
| 22 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
| 23 | MESSAGE_PARM1 | Character(30) | VARCHAR2(30) NOT NULL | Message Parameter 1 |
| 24 | MESSAGE_PARM2 | Character(30) | VARCHAR2(30) NOT NULL | Message Parameter 2 |
| 25 | MESSAGE_PARM3 | Character(30) | VARCHAR2(30) NOT NULL | Message Parameter 3 |
| 26 | MESSAGE_PARM4 | Character(30) | VARCHAR2(30) NOT NULL | Message Parameter 4 |