ECAUDIT_05_VW

index back

EC Audit Staging Area View

Associative table between ECQUEUE, ECTRANSGROUPLOG, and ECPACKAGELOG
SELECT DISTINCT B.EC_PACKAGE_CNTL_NB, B.EC_PACKAGE_VER, B.EC_TRANS_GROUP_NBR, B.EC_TRANS_GROUP_VER, G.ECTRANSINOUTSW, G.EC_EXT_TP_ID, G.EC_INT_TP_ID, G.DTTM_STAMP, G.STATS_START, G.STATS_STOP, G.E CCOMPLETIONSTATUS, G.ECLOADTOTAL, G.ECERRORTOTAL, G.EC_APP_FIELD_1, G.EC_APP_FIELD_2, G.EC_APP_FIELD_3 FROM PS_ECTRANSGROUPLOG G, PS_ECBUSDOCLINK B WHERE G.EC_TRANS_GROUP_NBR = B.EC_TRANS_GROUP_NBR AND G.EC_TRANS_GROUP_VER = B.EC_TRANS_GROUP_VER

PeopleSoft Field Name Field Type Column Type Description
EC_PACKAGE_CNTL_NB Character(10) VARCHAR2(10) NOT NULL EC Package Control ID
EC_PACKAGE_VER Character(6) VARCHAR2(6) NOT NULL EC Package Version
EC_TRANS_GROUP_NBR Character(18) VARCHAR2(18) NOT NULL EC Transaction Group Cntl Nbr
EC_TRANS_GROUP_VER Character(6) VARCHAR2(6) NOT NULL EC Transaction Group Version
ECTRANSINOUTSW Character(1) VARCHAR2(1) NOT NULL Electronic Commerce Inbound/Outbound Switch. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. The field value is "I" for Inbound Transactions, and "O" for Outbound.
I=Inbound
O=Outbound
EC_EXT_TP_ID Character(16) VARCHAR2(16) NOT NULL Electronic Commerce External Trading Partner ID. Used in EDI Manager. The External Trading Partners are the customers, vendors, etc. that will do business with the PeopleSoft enterprise. External TPID can be found out from the external businesses directly or from the VAN.
EC_INT_TP_ID Character(16) VARCHAR2(16) NOT NULL EC Internal Trading Partner ID
DTTM_STAMP 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.
STATS_START DateTime(26) TIMESTAMP Start Time For Stats Gathering
STATS_STOP DateTime(26) TIMESTAMP Stop Time For Stats Gathering
ECCOMPLETIONSTATUS Character(4) VARCHAR2(4) NOT NULL EC Completion Status
FAIL=Transaction Failed Process
PASS=Transaction Passed Process
ECLOADTOTAL Number(9,0) DECIMAL(9) NOT NULL EC Inbound Load Total
ECERRORTOTAL Number(9,0) DECIMAL(9) NOT NULL EC Inbound Error Total
EC_APP_FIELD_1 Character(40) VARCHAR2(40) NOT NULL EC Applicartion Defined Field
EC_APP_FIELD_2 Character(40) VARCHAR2(40) NOT NULL EC Applicartion Defined Field
EC_APP_FIELD_3 Character(40) VARCHAR2(40) NOT NULL EC Application Defined Field
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19