ADM_T130_PCL_EC (SQL Table)	Index Back
TS130 Previous College Staging Admissions Application Electronic Commerce EDI Staging Table. Use ADM_TRNS_PCL_EC to store previous college data for an applicant.

ADM_T130_PCL_EC

(SQL Table)

TS130 Previous College Staging

Admissions Application Electronic Commerce EDI Staging Table. Use ADM_TRNS_PCL_EC to store previous college data for an applicant.

# 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 EDI_INST_CD_QUAL Character(2) VARCHAR2(2) NOT NULL Institution Code Qualifier

7 INSTITUTION_DESCR Character(30) VARCHAR2(30) NOT NULL Institution

8 BEGIN_DT Date(10) DATE Begin Date

9 END_DATE Date(10) DATE End Date

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

11 CHAR_DT Character(10) VARCHAR2(10) NOT NULL Character Date

12 EDI_DESCR Character(30) VARCHAR2(30) NOT NULL EDI Description Field

13 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
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	EDI_INST_CD_QUAL	Character(2)	VARCHAR2(2) NOT NULL	Institution Code Qualifier
7	INSTITUTION_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Institution
8	BEGIN_DT	Date(10)	DATE	Begin Date
9	END_DATE	Date(10)	DATE	End Date
10	DEGREE	Character(8)	VARCHAR2(8) NOT NULL	Degree Prompt Table: DEGREE_TBL
11	CHAR_DT	Character(10)	VARCHAR2(10) NOT NULL	Character Date
12	EDI_DESCR	Character(30)	VARCHAR2(30) NOT NULL	EDI Description Field
13	TRANS_ROW_ID	Character(3)	VARCHAR2(3) NOT NULL	Transaction Row ID