PSARCH_IDPSARCH_BATCHNUMMU_TRANS_SRCMU_TRANS_REFMU_TRANS_IDSEQ_NUM5LANGUAGE_CDMU_TP_HST_LNG(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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 8 | DESCRLONG | Long Character | CLOB | Long Description |