EQTZ_PROC_LOG(SQL Table) |
Index Back |
|---|---|
Equitization Undo Table |
| # | 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
Prompt Table: SP_SETID_NONVW |
| 4 | EQUITIZATION_GROUP |
Character(10) | VARCHAR2(10) NOT NULL | Equitization Group |
| 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_LOG_SW | Character(1) | VARCHAR2(1) NOT NULL | Create Calculation Log |
| 11 | INCLUDE_ADJ_PER | Character(1) | VARCHAR2(1) NOT NULL | Include Adjustment Period(s) |
| 12 | JRNL_EDIT_OPTN | Character(1) | VARCHAR2(1) NOT NULL | Edit Journal(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 | JRNL_BGTCHK_OPTN | Character(1) | VARCHAR2(1) NOT NULL | Journal Budget Check option. Used in Journal Edit request or other GL processes (e.g. Allocations, Closing, Revaluation, ...) to flag if journals will be budget checked after they are edited valid. |
| 15 | 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. |
| 16 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 17 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 18 | CONSOL_RUN_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Run Status
A=Aborted E=Error S=Successful U=Undone |
| 19 | UNDO_PREV_PROCESS | Character(1) | VARCHAR2(1) NOT NULL | Undo Previous Process |
| 20 | UNDO_PREVPROC_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Undo Options
C=Matching Request Parameters L=Selected from List Default Value: C |
| 21 | JOURNAL_ID_FROM | Character(10) | VARCHAR2(10) NOT NULL | Range From Journal ID |
| 22 | JOURNAL_ID_TO | Character(10) | VARCHAR2(10) NOT NULL | Range to Journal ID |
| 23 | MESSAGE_SET_NBR | Number(5,0) | INTEGER NOT NULL | Message Set Number. This field refers to the Message Set Number in the Message Catalog. |
| 24 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
| 25 | MESSAGE_PARM1 | Character(30) | VARCHAR2(30) NOT NULL | Message Parameter 1 |
| 26 | MESSAGE_PARM2 | Character(30) | VARCHAR2(30) NOT NULL | Message Parameter 2 |
| 27 | MESSAGE_PARM3 | Character(30) | VARCHAR2(30) NOT NULL | Message Parameter 3 |
| 28 | MESSAGE_PARM4 | Character(30) | VARCHAR2(30) NOT NULL | Message Parameter 4 |