EN_STGMCOITM_VW (SQL View)	Index Back
item errors by MCO 8/15/03 RML Agile Exceptions - Stage item errors by MCO

EN_STGMCOITM_VW

(SQL View)

item errors by MCO

8/15/03 RML Agile Exceptions - Stage item errors by MCO

SELECT DISTINCT c.MESSAGE_TEXT , a.ORIG_DT_TIMESTAMP , a.EIP_DTA_STATUS , a.PUBID , a.PUBNODE , a.CHNLNAME FROM PS_EO_EIP_CTL a , PSMSGCATDEFN c WHERE a.EIP_DTA_STATUS <> '2' AND a.EIP_REFERENCE LIKE 'PDX%' AND a.EIP_PROGRAM = 'ITEM' AND c.MESSAGE_SET_NBR = 7026 AND c.MESSAGE_NBR = 204 AND a.ORIG_DT_TIMESTAMP = ( SELECT MAX(x.ORIG_DT_TIMESTAMP) FROM PS_EO_EIP_CTL x WHERE x.PUBID = a.PUBID) AND NOT EXISTS ( SELECT 'x' FROM PS_EN_REVISION_EC ec WHERE a.EIP_CTL_ID = ec.EIP_CTL_ID)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TEXT254 Character(254) VARCHAR2(254) NOT NULL Text

2 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

3 EIP_DTA_STATUS Character(1) VARCHAR2(1) NOT NULL EIP Dta status
0=New
1=Error
2=Complete
3=In Process
4=Reprocess
5=Incomplete
6=Cancelled
7=Hold

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

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

6 CHNLNAME Character(30) VARCHAR2(30) NOT NULL Channel Name (see PSCHNLDEFN).

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TEXT254	Character(254)	VARCHAR2(254) NOT NULL	Text
2	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
3	EIP_DTA_STATUS	Character(1)	VARCHAR2(1) NOT NULL	EIP Dta status 0=New 1=Error 2=Complete 3=In Process 4=Reprocess 5=Incomplete 6=Cancelled 7=Hold
4	PUBID	Signed Number(11,0)	DECIMAL(10) NOT NULL	Publication Identifier
5	PUBNODE	Character(30)	VARCHAR2(30) NOT NULL	Application Messaging Publication Node. This refers to the Node that the Application Message Instance was published from.
6	CHNLNAME	Character(30)	VARCHAR2(30) NOT NULL	Channel Name (see PSCHNLDEFN).