TL_ELP_ERR_SRCH (SQL View)	Index Back
TCD Elapse Intfc Error Srch Vw The view was created to be a search view used to enter the TCD Elapsed Error panel group.

TL_ELP_ERR_SRCH

(SQL View)

TCD Elapse Intfc Error Srch Vw

The view was created to be a search view used to enter the TCD Elapsed Error panel group.

SELECT A.SUBSCRIBE_DTTM , B.PUBNODE , B.PUBID FROM PS_TL_ELP_ERR A , PS_TL_TCD_EIP_ERR B WHERE A.SUBSCRIBE_DTTM = B.SUBSCRIBE_DTTM

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SUBSCRIBE_DTTM DateTime(26) TIMESTAMP Subscription Date Time

2 PUBNODE Character(30) VARCHAR2(30) NOT NULL Application Messaging Publication Node. This refers to the Node that the Application Message Instance was published from.

3 PUBID Signed Number(11,0) DECIMAL(10) NOT NULL Publication Identifier

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