MU_TP_TRANS_HST (SQL Table)	Index Back
Transaction Table Table of transactions to be processed by the Transaction Processor. This table is generated by any product that needs to process changes in the application. It is used primary by Mass Update processes. This is the Archive (shadow) table used in Data Archiving for the record: MU_TP_TRANS_TBL.

MU_TP_TRANS_HST

(SQL Table)

Transaction Table

Table of transactions to be processed by the Transaction Processor. This table is generated by any product that needs to process changes in the application. It is used primary by Mass Update processes. This is the Archive (shadow) table used in Data Archiving for the record: MU_TP_TRANS_TBL.

# 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 MU_EXEC_STATUS_FLG Character(1) VARCHAR2(1) NOT NULL Mass Update execution result status flag.
C=Cancel
F=Failure
R=Ready
S=Success
W=Warning

7 MU_TRANS_XML Long Character CLOB NOT NULL Transaction (XML)

#	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	MU_EXEC_STATUS_FLG	Character(1)	VARCHAR2(1) NOT NULL	Mass Update execution result status flag. C=Cancel F=Failure R=Ready S=Success W=Warning
7	MU_TRANS_XML	Long Character	CLOB NOT NULL	Transaction (XML)