ADM_T189_REF_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 Default Value: I
4	TRANS_CNTRL_NBR	Character(9)	VARCHAR2(9) NOT NULL	Transaction Set Control Number
5	EDI_REF_ID	Character(30)	VARCHAR2(30) NOT NULL	Reference Identification
6	EDI_REF_ID_QUAL	Character(2)	VARCHAR2(2) NOT NULL	Reference ID Qual 30=United States Govn Visa Number 48=Agency's Student Number 49=Family Unit Number 4A=Personal Identification Number 50=State Student ID Number 56=Corrected SSN 57=Prior Incorrect SSN A6=Employee ID Number C0=Canadian Social Insurance Nbr E4=Charge Card Number LR=Local Student ID Number MV=Migrant Number SY=Social Security Number V2=Visa Type V4=State Dept I-20 Form Number V5=State Dept IAP-66 Form Number ZZ=Mutually Defined
7	DESCR100	Character(100)	VARCHAR2(100) NOT NULL	Length 100 Description
8	EDI_DATE1_QUAL	Character(3)	VARCHAR2(3) NOT NULL	EDI Date 1 Qualifier 007=Effective Date 036=Expiration Date 043=Publication Date 050=Received Date 055=Confirmed Date 102=Issue Date 103=Award Date 196=Start Date 197=End Date 198=Completion Date 222=Birth Date 237=Student Signed 270=Date Filed 275=Approved Date 330=Referral Date 331=Evaluation Date 332=Placement Date 333=Individual Education Plan 334=Re-evaluation Date 335=Dismissal Date 336=Employment Begin Date 337=Employment End Date 442=Date of Death 467=Signature Date 574=Action Begin Date 576=Action End Date
9	EDI_DATE1	Date(10)	DATE	Date 1
10	EDI_DATE2_QUAL	Character(3)	VARCHAR2(3) NOT NULL	EDI Date 2 Qualifier 007=Effective Date 036=Expiration Date
11	EDI_DATE2	Date(10)	DATE	Date 2
12	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
13	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: STATE_NAMES_TBL
14	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
15	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: COUNTRY_TBL
16	EDI_LOC_QUAL	Character(2)	VARCHAR2(2) NOT NULL	Location Qualifier AC=City and State CA=Country of Origin CC=Country CI=City CY=County DR=District of Residence DT=Domicile Type Code F=Current Address H=Home Address L=Local Address M=Mailing Address O=Office Address P=Permanent Address PT=3 Digit Canadian Postal Code PU=6 Digit Canadial Postal Code RE=Regional Education Service SB=Suburban SD=School District SP=State or Province SS=School TN=Township UR=Urban ZZ=Mutually Defined
17	EDI_LOC_ID	Character(35)	VARCHAR2(35) NOT NULL	TS189 Location Identification
18	EDI_ENTITY_ID_CD	Character(2)	VARCHAR2(2) NOT NULL	Entity Identification Cd 1R=Postsecondary 2F=State 2R=Federal Facility BU=Place of Business C7=County C8=City CY=Country H6=School District HS=High School ZZ=Mutually Defined
19	EDI_ENTITY_NAME	Character(35)	VARCHAR2(35) NOT NULL	Entity Name
20	TRANS_ROW_ID	Character(3)	VARCHAR2(3) NOT NULL	Transaction Row ID