ADM_T189_DEG_EC (SQL Table)	Index Back
Adm Applicant Deg EC Admissions Application Electronic Commerce EDI Staging Table. Degree record for TS189 Transcript transactions. Use ADM_T189_DEG_EC to store degrees a student has received.

ADM_T189_DEG_EC

(SQL Table)

Adm Applicant Deg EC

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

Parent record: ADM_T189_HDR_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_SSE_NBR Number(3,0) SMALLINT NOT NULL SSE 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

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 EXT_CAREER Character(4) VARCHAR2(4) NOT NULL External Career
GRAD=Graduate
HS=High School
LAW=Law
MED=Medical
UGRD=Undergraduate

13 EXT_DATA_NBR Number(3,0) SMALLINT NOT NULL External Data Nbr

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	EDI_SSE_NBR	Number(3,0)	SMALLINT NOT NULL	SSE 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
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	EXT_CAREER	Character(4)	VARCHAR2(4) NOT NULL	External Career GRAD=Graduate HS=High School LAW=Law MED=Medical UGRD=Undergraduate
13	EXT_DATA_NBR	Number(3,0)	SMALLINT NOT NULL	External Data Nbr
14	TRANS_ROW_ID	Character(3)	VARCHAR2(3) NOT NULL	Transaction Row ID