PSAPMSGMON5VW

index back

SubCon Summary by CHNLNAME


SELECT QUEUENAME , PUBSTATUS , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 FROM PSIBSUBCON_VW

PeopleSoft Field Name Field Type Column Type Description
QUEUENAME Character(30) VARCHAR2(30) NOT NULL Channel Name (see PSQUEUEDEFN).
PUBSTATUS Number(2,0) SMALLINT NOT NULL Publication Status
APMSG_XTB_0_SUM Number(10,0) DECIMAL(10) NOT NULL Error: The number of messages with an error status.
APMSG_XTB_1_SUM Number(10,0) DECIMAL(10) NOT NULL New: The number of messages with a new status.
APMSG_XTB_2_SUM Number(10,0) DECIMAL(10) NOT NULL Started: The number of messages with a started status.
APMSG_XTB_3_SUM Number(10,0) DECIMAL(10) NOT NULL Working: The number of messages with a working status.
APMSG_XTB_4_SUM Number(10,0) DECIMAL(10) NOT NULL Done: The number of messages with a done status.
APMSG_XTB_5_SUM Number(10,0) DECIMAL(10) NOT NULL Retry: The number of messages with a retry status.
APMSG_XTB_6_SUM Number(10,0) DECIMAL(10) NOT NULL Timeout: The number of messages with a timeout status.
APMSG_XTB_7_SUM Number(10,0) DECIMAL(10) NOT NULL Edited: The number of messages with an edited status.
APMSG_XTB_8_SUM Number(10,0) DECIMAL(10) NOT NULL Cancelled: The number of messages with a cancelled status.
APMSG_XTB_9_SUM Number(10,0) DECIMAL(10) NOT NULL CROSSTAB 9
APMSG_XTB_10_SUM Number(10,0) DECIMAL(10) NOT NULL CROSSTAB 10
APMSG_XTB_11_SUM Number(10,0) DECIMAL(10) NOT NULL CROSSTAB 11
APMSG_XTB_12_SUM Number(10,0) DECIMAL(10) NOT NULL CROSSTAB 12
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20