CORR09_EDI_SRCH (SQL View)	Index Back
2008-2009 CORR/DUPR View View for verifying EDI info on outgoing Correction and Duplicate Request records for 2008-2009.

CORR09_EDI_SRCH

(SQL View)

2008-2009 CORR/DUPR View

View for verifying EDI info on outgoing Correction and Duplicate Request records for 2008-2009.

SELECT A.ECTRANSID , A.ECQUEUEINSTANCE , A.ECTRANSINOUTSW , A.IWD_BATCH_NBR , A.IWD_RECORD_TYPE , A.IWD_CREATE_DATE , B.IWD_TOTAL_REC_CNT FROM PS_ISIR_EX_HEAD_EC A , PS_ISIR_EX_TRAL_EC B WHERE A.ECTRANSID = B.ECTRANSID AND A.ECQUEUEINSTANCE = B.ECQUEUEINSTANCE AND A.ECTRANSINOUTSW = B.ECTRANSINOUTSW AND A.ECTRANSID IN ('CORR09IN','SIGS09IN') AND A.AID_YEAR = '2009'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 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)

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

3 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

4 IWD_BATCH_NBR Character(23) VARCHAR2(23) NOT NULL Batch Number

5 IWD_RECORD_TYPE Character(1) VARCHAR2(1) NOT NULL Record Type
7=PIN Request
A=Initial Applications
C=Corrections/Duplicates
F=FDR Request
H=Corrections/Duplicate Req
R=Renewal Applications
S=Signature Corrections

6 IWD_CREATE_DATE Date(10) DATE File Create Date

7 IWD_TOTAL_REC_CNT Number(5,0) INTEGER NOT NULL Total Records

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	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)
2	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.
3	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
4	IWD_BATCH_NBR	Character(23)	VARCHAR2(23) NOT NULL	Batch Number
5	IWD_RECORD_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Record Type 7=PIN Request A=Initial Applications C=Corrections/Duplicates F=FDR Request H=Corrections/Duplicate Req R=Renewal Applications S=Signature Corrections
6	IWD_CREATE_DATE	Date(10)	DATE	File Create Date
7	IWD_TOTAL_REC_CNT	Number(5,0)	INTEGER NOT NULL	Total Records