GM_EC_DEG

#	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	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
5	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
6	RECORD_ID	Character(3)	VARCHAR2(3) NOT NULL	Record ID
7	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
8	ACCOMPLISHMENT	Character(8)	VARCHAR2(8) NOT NULL	Accomplishment
9	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
10	DT_ISSUED	Date(10)	DATE	Issue Date
11	MAJOR_CODE	Character(10)	VARCHAR2(10) NOT NULL	Major Code
12	MAJOR	Character(30)	VARCHAR2(30) NOT NULL	Major
13	SCHOOL_CODE	Character(10)	VARCHAR2(10) NOT NULL	School Code
14	SCHOOL	Character(30)	VARCHAR2(30) NOT NULL	School Name
15	ACCOMP_CATEGORY	Character(3)	VARCHAR2(3) NOT NULL	Accomplishment Category DEG=Degree HON=Honor or Award LIC=License or Certification LNG=Language MEM=Membership NVQ=NVQ TST=Test
16	DESCR1	Character(30)	VARCHAR2(30) NOT NULL	Descr
17	DESCR2	Character(30)	VARCHAR2(30) NOT NULL	Descr2