ADM_T130_DEG_EC (SQL Table)	Index Back
Adm Appl Trnscrpt Deg EC Admissions Application Electronic Commerce EDI Staging Table. Degree record for TS130 Transcript transactions. Use ADM_TRNS_DEG_EC to store degrees a student has received.

ADM_T130_DEG_EC

(SQL Table)

Adm Appl Trnscrpt Deg EC

Admissions Application Electronic Commerce EDI Staging Table. Degree record for TS130 Transcript transactions. Use ADM_TRNS_DEG_EC to store degrees a student has received.

Parent record: ADM_T130_SES_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 SES_NUMBER Number(3,0) SMALLINT NOT NULL Session Number

6 EXT_DEGREE_NBR Number(3,0) SMALLINT NOT NULL External Degree Number

7 DEGREE Character(8) VARCHAR2(8) NOT NULL Degree
Prompt Table: DEGREE_TBL

8 DESCR Character(30) VARCHAR2(30) NOT NULL Description

9 DEGREE_DT Date(10) DATE Admissions degree date.

10 DEGREE_STATUS Character(1) VARCHAR2(1) NOT NULL Degree Status
C=Complete
D=Discontinued
I=In Progress
N=Incomplete
Default Value: C

11 HONORS_CATEGORY Character(4) VARCHAR2(4) NOT NULL Honors Category
CL=Cum Laude
MCL=Magna Cum Laude
NONE=None
SCL=Summa Cum Laude

12 FIELD_OF_STUDY_1 Character(30) VARCHAR2(30) NOT NULL Field of Study 1

13 FIELD_OF_STUDY_2 Character(30) VARCHAR2(30) NOT NULL Field of Study 2

14 TRANS_ROW_ID Character(3) VARCHAR2(3) NOT NULL Transaction Row ID

#	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	SES_NUMBER	Number(3,0)	SMALLINT NOT NULL	Session Number
6	EXT_DEGREE_NBR	Number(3,0)	SMALLINT NOT NULL	External Degree Number
7	DEGREE	Character(8)	VARCHAR2(8) NOT NULL	Degree Prompt Table: DEGREE_TBL
8	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
9	DEGREE_DT	Date(10)	DATE	Admissions degree date.
10	DEGREE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Degree Status C=Complete D=Discontinued I=In Progress N=Incomplete Default Value: C
11	HONORS_CATEGORY	Character(4)	VARCHAR2(4) NOT NULL	Honors Category CL=Cum Laude MCL=Magna Cum Laude NONE=None SCL=Summa Cum Laude
12	FIELD_OF_STUDY_1	Character(30)	VARCHAR2(30) NOT NULL	Field of Study 1
13	FIELD_OF_STUDY_2	Character(30)	VARCHAR2(30) NOT NULL	Field of Study 2
14	TRANS_ROW_ID	Character(3)	VARCHAR2(3) NOT NULL	Transaction Row ID