MU_TP_TRANS_VW (SQL View)	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�s used primary by Mass Update processes.

MU_TP_TRANS_VW

(SQL View)

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�s used primary by Mass Update processes.

SELECT MU_ID , MU_EXEC_STATUS_FLG ,COUNT(*) FROM PS_MU_CHANGE_TBL GROUP BY MU_ID , MU_EXEC_STATUS_FLG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 MU_ID Character(15) VARCHAR2(15) NOT NULL Mass Update ID

2 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

3 EXECUTE_COUNT Number(10,0) DECIMAL(10) NOT NULL Count

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	MU_ID	Character(15)	VARCHAR2(15) NOT NULL	Mass Update ID
2	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
3	EXECUTE_COUNT	Number(10,0)	DECIMAL(10) NOT NULL	Count