PSAPMSGMON2VW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	QUEUENAME	Character(30)	VARCHAR2(30) NOT NULL	Channel Name (see PSQUEUEDEFN).
2	PUBSTATUS	Number(2,0)	SMALLINT NOT NULL	Publication Status
3	APMSG_XTB_0_SUM	Number(10,0)	DECIMAL(10) NOT NULL	Error: The number of messages with an error status.
4	APMSG_XTB_1_SUM	Number(10,0)	DECIMAL(10) NOT NULL	New: The number of messages with a new status.
5	APMSG_XTB_2_SUM	Number(10,0)	DECIMAL(10) NOT NULL	Started: The number of messages with a started status.
6	APMSG_XTB_3_SUM	Number(10,0)	DECIMAL(10) NOT NULL	Working: The number of messages with a working status.
7	APMSG_XTB_4_SUM	Number(10,0)	DECIMAL(10) NOT NULL	Done: The number of messages with a done status.
8	APMSG_XTB_5_SUM	Number(10,0)	DECIMAL(10) NOT NULL	Retry: The number of messages with a retry status.
9	APMSG_XTB_6_SUM	Number(10,0)	DECIMAL(10) NOT NULL	Timeout: The number of messages with a timeout status.
10	APMSG_XTB_7_SUM	Number(10,0)	DECIMAL(10) NOT NULL	Edited: The number of messages with an edited status.
11	APMSG_XTB_8_SUM	Number(10,0)	DECIMAL(10) NOT NULL	Cancelled: The number of messages with a cancelled status.
12	APMSG_XTB_9_SUM	Number(10,0)	DECIMAL(10) NOT NULL	CROSSTAB 9
13	APMSG_XTB_10_SUM	Number(10,0)	DECIMAL(10) NOT NULL	CROSSTAB 10
14	APMSG_XTB_11_SUM	Number(10,0)	DECIMAL(10) NOT NULL	CROSSTAB 11
15	APMSG_XTB_12_SUM	Number(10,0)	DECIMAL(10) NOT NULL	CROSSTAB 12