PSAPMSGMON2VW

(SQL View)
Index Back

PubCon Summary by CHNLNAME


SELECT QUEUENAME , PUBSTATUS , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 FROM PSIBPUBCON_VW

# 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