ADM_T189_ATV_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	TRANS_CNTRL_NBR	Character(9)	VARCHAR2(9) NOT NULL	Transaction Set Control Number
5	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
6	EDI_ATV_QUAL	Character(3)	VARCHAR2(3) NOT NULL	Qualifier Code SA=Student Activity Type Code SB=Student Award Code ZZ=Mutually Defined
7	EDI_ATV_CD	Character(5)	VARCHAR2(5) NOT NULL	Activity/Award Code
8	EDI_DESCR1	Character(80)	VARCHAR2(80) NOT NULL	Description 1
9	EDI_DESCR2	Character(80)	VARCHAR2(80) NOT NULL	Description 2
10	EDI_ATV_LENGTH	Character(15)	VARCHAR2(15) NOT NULL	Time In Activity
11	EDI_ATV_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Unit of Measure for Activity
12	TRANS_ROW_ID	Character(3)	VARCHAR2(3) NOT NULL	Transaction Row ID