IN_ITMSYNC_VW

(SQL View)

SELECT EIP_CTL_ID , SETID , EIP_REFERENCE , EIP_DTA_STATUS , AUDIT_ACTN , ORIG_DT_TIMESTAMP FROM PS_EO_EIP_CTL WHERE MSGNAME = 'ITEM_SYNC' AND EIP_DTA_STATUS IN ('0','1','4')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EIP_CTL_ID Character(25) VARCHAR2(25) NOT NULL Enterprise Components EIP (enterprise integration point) control field

2 SETID Character(5) VARCHAR2(5) NOT NULL SetID

3 EIP_REFERENCE Character(30) VARCHAR2(30) NOT NULL EIP Reference

4 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

5 AUDIT_ACTN Character(1) VARCHAR2(1) NOT NULL Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add
C=Change Old (PPR Only)
D=Delete
K=Change - Old Values
N=Change - New Values
O=Change - Original Values

6 ORIG_DT_TIMESTAMP DateTime(26) TIMESTAMP Orig Date Timestamp

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EIP_CTL_ID	Character(25)	VARCHAR2(25) NOT NULL	Enterprise Components EIP (enterprise integration point) control field
2	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
3	EIP_REFERENCE	Character(30)	VARCHAR2(30) NOT NULL	EIP Reference
4	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
5	AUDIT_ACTN	Character(1)	VARCHAR2(1) NOT NULL	Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted. A=Add C=Change Old (PPR Only) D=Delete K=Change - Old Values N=Change - New Values O=Change - Original Values
6	ORIG_DT_TIMESTAMP	DateTime(26)	TIMESTAMP	Orig Date Timestamp