ADM_T189_III_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	RELIGIOUS_CD	Character(30)	VARCHAR2(30) NOT NULL	Religious Code
7	EDI_ID_CODE_QUAL	Character(3)	VARCHAR2(3) NOT NULL	Identification Code Qualifier 81=Classif of Instr Programs 82=Higher Ed General Info Survey AAW=Immunization Injection Code CA=Can College Info Crse Codes CC=Can Univ Stdnt Info Curr Codes LE=ISO 639 Language Codes RA=Religious Affiliation ZZ=Mutually Defined
8	EDI_DESCR1	Character(80)	VARCHAR2(80) NOT NULL	Description 1
9	TRANS_ROW_ID	Character(3)	VARCHAR2(3) NOT NULL	Transaction Row ID