ISIR_EX_TRAL_EC

#	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_DEST_NBR	Character(7)	VARCHAR2(7) NOT NULL	TG Number
7	IWD_CREATE_DATE	Date(10)	DATE	File Create Date
8	IWD_CREATE_TIME	Character(6)	VARCHAR2(6) NOT NULL	File Create Time
9	IWD_AWARD_YEAR	Character(4)	VARCHAR2(4) NOT NULL	Award Year
10	IWD_TOTAL_REC_CNT	Number(5,0)	INTEGER NOT NULL	Total Records
11	IWD_TRANS_SRC_CD	Character(1)	VARCHAR2(1) NOT NULL	Transaction Source Code 1=Electroni Initial App 2=Electronic Renewal App 3=Electronic History Correction 4=FAFSA Express 5=ACT 6=Web FAFSA/Renewal FAFSA 7=NCS 8=PIC
12	IWD_TRANS_SITE_CD	Character(1)	VARCHAR2(1) NOT NULL	Transaction Site Source Code
13	IWD_ACCEPT_REC_CNT	Number(7,0)	INTEGER NOT NULL	Accepted Student Record Count
14	IWD_ERROR_REC_CNT	Number(7,0)	INTEGER NOT NULL	Error Record Count
15	IWD_NOT_IN_DB_CNT	Number(7,0)	INTEGER NOT NULL	Not in CPS DB Count
16	IWD_BATCH_IND	Character(1)	VARCHAR2(1) NOT NULL	Batch Indicator
17	IWD_TOTAL_REC_O	Character(5)	VARCHAR2(5) NOT NULL	Total Records In Batch