PSARCH_IDPSARCH_BATCHNUMMU_TRANS_SRCMU_TRANS_REFMU_TRANS_IDSEQ_NUM5C=Cancel
E=Error
M=Message
W=Warning
MU_TP_LOG_HST(SQL Table) |
Index Back |
|---|---|
Transaction MessagesMessages and Exceptions generated by the Transaction Processor during changes in the application (Execution or Transaction Processor Log table). This is the Archive (shadow) table used in Data Archiving for the record: MU_TP_TRANS_LOG. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PSARCH_ID |
Character(8) | VARCHAR2(8) NOT NULL | Archive ID (see PSARCHTEMPLATE). |
| 2 | PSARCH_BATCHNUM |
Number(30,0) | DECIMAL(30) NOT NULL | Archive Batch Number |
| 3 | MU_TRANS_SRC |
Character(10) | VARCHAR2(10) NOT NULL | Transaction Source |
| 4 | MU_TRANS_REF |
Character(15) | VARCHAR2(15) NOT NULL | Transaction Reference |
| 5 | MU_TRANS_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Transaction ID |
| 6 | SEQ_NUM5 |
Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 7 | LASTUPDDTTM | DateTime(26) | TIMESTAMP NOT NULL | 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. |
| 8 | LASTUPDOPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 9 | MSG_SEVERITY | Character(1) | VARCHAR2(1) NOT NULL |
Message Severity
C=Cancel E=Error M=Message W=Warning |
| 10 | DESCRLONG | Long Character | CLOB | Long Description |