TRANS_PROC_LOG(SQL Table) |
Index Back |
|---|---|
Translation 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 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 5 | CURR_STEP |
Character(10) | VARCHAR2(10) NOT NULL | Process Step |
| 6 | REQUEST_DATE |
Date(10) | DATE | Requested |
| 7 | LED_REQ_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Specifies if the process request uses full ledger or incremental ledger data.
F=Full I=Incremental Default Value: F |
| 8 | CREATE_JRNL_ENTRY | Character(1) | VARCHAR2(1) NOT NULL |
Create Journal Entries
Y/N Table Edit |
| 9 | CREATE_LOG_SW | Character(1) | VARCHAR2(1) NOT NULL |
Create Calculation Log
Y/N Table Edit |
| 10 | INCLUDE_ADJ_PER | Character(1) | VARCHAR2(1) NOT NULL |
Include Adjustment Period(s)
Y/N Table Edit |
| 11 | JRNL_EDIT_OPTN | Character(1) | VARCHAR2(1) NOT NULL | Edit Journal(s) |
| 12 | 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 |
| 13 | 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. |
| 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 | TRANS_RUN_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Run Status
A=Aborted E=Error S=Successful U=Process was Undone |
| 18 | UNDO_PREV_PROCESS | Character(1) | VARCHAR2(1) NOT NULL |
Undo Previous Process
Y/N Table Edit |
| 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 | FISCAL_YEAR | Number(4,0) | SMALLINT NOT NULL | Fiscal Year |
| 22 | ACCOUNTING_PERIOD | Number(3,0) | SMALLINT NOT NULL | Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table. |
| 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 |