EO_EIP_CTL_VW

(SQL View)
 Index Back

View of EO_EIP_CTL

View of EO_EIP_CTL. Used in Error Management Utility.

SELECT EIP_CTL_ID ,PROCESS_INSTANCE , SETID , BUSINESS_UNIT , EIP_DTA_STATUS , ORIG_DT_TIMESTAMP , LASTUPDDTTM , EIP_SOURCE , OPRID , EIP_PROGRAM , PUBNODE , CHNLNAME , PUBID , MSGNAME , SUBNAME , EIP_REFERENCE , AUDIT_ACTN FROM PS_EO_EIP_CTL

# 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 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
3 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
5 EIP_DTA_STATUS Character(1) VARCHAR2(1) NOT NULL EIP Dta status
0=New Transaction
1=Error found on the transaction
2=Complete
3=In Process
4=Reprocess
5=Incomplete
6=Cancelled
7=Hold
6 ORIG_DT_TIMESTAMP DateTime(26) TIMESTAMP Orig Date Timestamp
7 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.
8 EIP_SOURCE Character(1) VARCHAR2(1) NOT NULL EIP Source
1=Message Agent
2=Transaction Page
3=Batch Loader
4=Automatically Generated
5=Application Message
9 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
10 EIP_PROGRAM Character(10) VARCHAR2(10) NOT NULL Enterprise Components EIP (enterprise integration point) program field
601=Consumer Sync
701=BOM Sync
801=Item Revision
901=Item Bus Unit Sync
902=Item Sync
11 PUBNODE Character(30) VARCHAR2(30) NOT NULL Application Messaging Publication Node. This refers to the Node that the Application Message Instance was published from.
12 CHNLNAME Character(30) VARCHAR2(30) NOT NULL Channel Name (see PSCHNLDEFN).
13 PUBID Signed Number(11,0) DECIMAL(10) NOT NULL Publication Identifier
14 MSGNAME Character(30) VARCHAR2(30) NOT NULL Application Message Name. Name of the Application Message Definition. (see PSMSGDEFN).
15 SUBNAME Character(30) VARCHAR2(30) NOT NULL Name of a Subscription, which defines which subscription process is invoked when you receive an application message.
16 EIP_REFERENCE Character(30) VARCHAR2(30) NOT NULL EIP Reference
17 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