PSAPMSGMON1VW

index back

PubCon Summary by MSGNAME


SELECT IB_OPERATIONNAME , VERSIONNAME , PUBSTATUS , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 FROM PSIBPUBCON_VW

PeopleSoft Field NameField TypeColumn TypeDescription
IB_OPERATIONNAMECharacter(30)VARCHAR2(30) NOT NULLService Operation (see PSOPERATION).
VERSIONNAMECharacter(30)VARCHAR2(30) NOT NULLService Operation Version
PUBSTATUSNumber(2,0)SMALLINT NOT NULLPublication Status
APMSG_XTB_0_SUMNumber(10,0)DECIMAL(10) NOT NULLError: The number of messages with an error status.
APMSG_XTB_1_SUMNumber(10,0)DECIMAL(10) NOT NULLNew: The number of messages with a new status.
APMSG_XTB_2_SUMNumber(10,0)DECIMAL(10) NOT NULLStarted: The number of messages with a started status.
APMSG_XTB_3_SUMNumber(10,0)DECIMAL(10) NOT NULLWorking: The number of messages with a working status.
APMSG_XTB_4_SUMNumber(10,0)DECIMAL(10) NOT NULLDone: The number of messages with a done status.
APMSG_XTB_5_SUMNumber(10,0)DECIMAL(10) NOT NULLRetry: The number of messages with a retry status.
APMSG_XTB_6_SUMNumber(10,0)DECIMAL(10) NOT NULLTimeout: The number of messages with a timeout status.
APMSG_XTB_7_SUMNumber(10,0)DECIMAL(10) NOT NULLEdited: The number of messages with an edited status.
APMSG_XTB_8_SUMNumber(10,0)DECIMAL(10) NOT NULLCancelled: The number of messages with a cancelled status.
APMSG_XTB_9_SUMNumber(10,0)DECIMAL(10) NOT NULLCROSSTAB 9
APMSG_XTB_10_SUMNumber(10,0)DECIMAL(10) NOT NULLCROSSTAB 10
APMSG_XTB_11_SUMNumber(10,0)DECIMAL(10) NOT NULLCROSSTAB 11
APMSG_XTB_12_SUMNumber(10,0)DECIMAL(10) NOT NULLCROSSTAB 12
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19