ECAUDIT_01_VW (SQL View)	Index Back
EC Audit Staging Area View Associative table between ECQUEUE, ECTRANSGROUPLOG, and ECPACKAGELOG

ECAUDIT_01_VW

(SQL View)

EC Audit Staging Area View

Associative table between ECQUEUE, ECTRANSGROUPLOG, and ECPACKAGELOG

SELECT B.EC_PACKAGE_CNTL_NB, B.EC_PACKAGE_VER, B.EC_TRANS_GROUP_NBR, B.EC_TRANS_GROUP_VER, B.ECQUEUEINSTANCE, B.ECTRANSID, B.ECTRANSINOUTSW, B.ECBUSDOCID, P.EC_EXT_TP_ID, P.EC_INT_TP_ID, P.DTTM_STAMP, P.STATS_START, P.STATS_STOP, P.ECCOMPLETIONSTATUS, P.ECLOADTOTAL, P.ECERRORTOTAL, P.EC_APP_FIELD_1, P.EC_APP_FIELD_2, P.EC_APP_FIELD_3 FROM PS_ECPACKAGELOG P, PS_ECBUSDOCLINK B where p.ec_package_cntl_nb = b.ec_package_cntl_nb and p.ec_package_ver = b.ec_package_ver

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EC_PACKAGE_CNTL_NB Character(10) VARCHAR2(10) NOT NULL EC Package Control ID

2 EC_PACKAGE_VER Character(6) VARCHAR2(6) NOT NULL EC Package Version

3 EC_TRANS_GROUP_NBR Character(18) VARCHAR2(18) NOT NULL EC Transaction Group Cntl Nbr

4 EC_TRANS_GROUP_VER Character(6) VARCHAR2(6) NOT NULL EC Transaction Group Version

5 ECQUEUEINSTANCE Number(9,0) DECIMAL(9) NOT NULL Electronic Commerce Queue Instance ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables.

6 ECTRANSID Character(15) VARCHAR2(15) NOT NULL Electronic Commerce Transaction ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. ECTRANSID in EDI Manager identifies a transaction type(like "PO" for Purchase Orders)

7 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

8 ECBUSDOCID Number(9,0) DECIMAL(9) NOT NULL EC Business Document ID

9 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.

10 EC_INT_TP_ID Character(16) VARCHAR2(16) NOT NULL EC Internal Trading Partner ID

11 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.

12 STATS_START DateTime(26) TIMESTAMP Start Time For Stats Gathering

13 STATS_STOP DateTime(26) TIMESTAMP Stop Time For Stats Gathering

14 ECCOMPLETIONSTATUS Character(4) VARCHAR2(4) NOT NULL EC Completion Status
FAIL=Transaction Failed Process
PASS=Transaction Passed Process

15 ECLOADTOTAL Number(9,0) DECIMAL(9) NOT NULL EC Inbound Load Total

16 ECERRORTOTAL Number(9,0) DECIMAL(9) NOT NULL EC Inbound Error Total

17 EC_APP_FIELD_1 Character(40) VARCHAR2(40) NOT NULL EC Applicartion Defined Field

18 EC_APP_FIELD_2 Character(40) VARCHAR2(40) NOT NULL EC Applicartion Defined Field

19 EC_APP_FIELD_3 Character(40) VARCHAR2(40) NOT NULL EC Application Defined Field

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EC_PACKAGE_CNTL_NB	Character(10)	VARCHAR2(10) NOT NULL	EC Package Control ID
2	EC_PACKAGE_VER	Character(6)	VARCHAR2(6) NOT NULL	EC Package Version
3	EC_TRANS_GROUP_NBR	Character(18)	VARCHAR2(18) NOT NULL	EC Transaction Group Cntl Nbr
4	EC_TRANS_GROUP_VER	Character(6)	VARCHAR2(6) NOT NULL	EC Transaction Group Version
5	ECQUEUEINSTANCE	Number(9,0)	DECIMAL(9) NOT NULL	Electronic Commerce Queue Instance ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables.
6	ECTRANSID	Character(15)	VARCHAR2(15) NOT NULL	Electronic Commerce Transaction ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. ECTRANSID in EDI Manager identifies a transaction type(like "PO" for Purchase Orders)
7	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
8	ECBUSDOCID	Number(9,0)	DECIMAL(9) NOT NULL	EC Business Document ID
9	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.
10	EC_INT_TP_ID	Character(16)	VARCHAR2(16) NOT NULL	EC Internal Trading Partner ID
11	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.
12	STATS_START	DateTime(26)	TIMESTAMP	Start Time For Stats Gathering
13	STATS_STOP	DateTime(26)	TIMESTAMP	Stop Time For Stats Gathering
14	ECCOMPLETIONSTATUS	Character(4)	VARCHAR2(4) NOT NULL	EC Completion Status FAIL=Transaction Failed Process PASS=Transaction Passed Process
15	ECLOADTOTAL	Number(9,0)	DECIMAL(9) NOT NULL	EC Inbound Load Total
16	ECERRORTOTAL	Number(9,0)	DECIMAL(9) NOT NULL	EC Inbound Error Total
17	EC_APP_FIELD_1	Character(40)	VARCHAR2(40) NOT NULL	EC Applicartion Defined Field
18	EC_APP_FIELD_2	Character(40)	VARCHAR2(40) NOT NULL	EC Applicartion Defined Field
19	EC_APP_FIELD_3	Character(40)	VARCHAR2(40) NOT NULL	EC Application Defined Field