TL_TCD_EIP_VW

(SQL View)
 Index Back

View of TCD Intfc Err Queue

This is a view of the TCD Interface Error Queue

SELECT A.SUBSCRIBE_DTTM , A.TCD_MSG_TYPE , A.PUBNODE , A.PUBID FROM PS_TL_TCD_EIP_ERR A WHERE (EXISTS ( SELECT 'X' FROM PS_TL_ELP_ERR B WHERE A.SUBSCRIBE_DTTM = B.SUBSCRIBE_DTTM) OR EXISTS ( SELECT 'X' FROM PS_TL_PUNCH_ERR C WHERE A.SUBSCRIBE_DTTM = C.SUBSCRIBE_DTTM))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SUBSCRIBE_DTTM DateTime(26) TIMESTAMP Subscription Date Time
2 TCD_MSG_TYPE Character(1) VARCHAR2(1) NOT NULL TCD Message Type
E=Elapsed
P=Punched
3 PUBNODE Character(30) VARCHAR2(30) NOT NULL Application Messaging Publication Node. This refers to the Node that the Application Message Instance was published from.
4 PUBID Signed Number(11,0) DECIMAL(10) NOT NULL Publication Identifier