IN_ITMEIPSID_VW

(SQL View)
 Index Back

SELECT DISTINCT CTL.MSGNAME , MST.SETID , CTL.EIP_CTL_ID , CTL.EIP_REFERENCE , CTL.EIP_DTA_STATUS , CTL.AUDIT_ACTN , CTL.ORIG_DT_TIMESTAMP FROM PS_EO_EIP_CTL CTL , PS_MASTER_ITEM_EC MST WHERE CTL.EIP_PROGRAM = 'ITEM' AND CTL.EIP_CTL_ID = MST.EIP_CTL_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 MSGNAME Character(30) VARCHAR2(30) NOT NULL Application Message Name. Name of the Application Message Definition. (see PSMSGDEFN).
2 SETID Character(5) VARCHAR2(5) NOT NULL SetID
3 EIP_CTL_ID Character(25) VARCHAR2(25) NOT NULL Enterprise Components EIP (enterprise integration point) control field
4 EIP_REFERENCE Character(30) VARCHAR2(30) NOT NULL EIP Reference
5 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
6 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
7 ORIG_DT_TIMESTAMP DateTime(26) TIMESTAMP Orig Date Timestamp