ADM_T189_SSE_EC (SQL Table)	Index Back
Adm Applicant SSE EC Admissions Application Electronic Commerce EDI Staging Table. Entry/Exit record for TS189 Applicant transactions. Use ADM_T189_SSE_EC to store entry into or withdrawal from a school.

ADM_T189_SSE_EC

(SQL Table)

Adm Applicant SSE EC

Admissions Application Electronic Commerce EDI Staging Table. Entry/Exit record for TS189 Applicant transactions. Use ADM_T189_SSE_EC to store entry into or withdrawal from a school.

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 ENTRY_DT Date(10) DATE This field pertains to the date a person enters a country on a specific visa.

7 EXIT_DT Date(10) DATE Exit Date

8 EDI_STATUS_RSN Character(3) VARCHAR2(3) NOT NULL Status Reason Code
B52=Dropout
D10=Other Attendence
D11=Other School in District
D12=Oth Public School in District
D13=Other Public School out state
D14=Over Age
D15=Standard Diploma
D16=Special Diploma
D17=Certification of Completion
D18=Special Certificate of Complt
D19=General Education Devlp Diplma
D20=Non-public
D21=Hardship
D22=Not Entered in School
D23=Public Schl 1st Time in State
D24=Returned to regular education
D30=Declined services
EB4=Graduated

9 PRIORITY_NBR Number(3,0) SMALLINT NOT NULL Priority

10 APP_ERROR Character(1) VARCHAR2(1) NOT NULL Application Error
Y/N Table Edit
Default Value: N

11 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	ENTRY_DT	Date(10)	DATE	This field pertains to the date a person enters a country on a specific visa.
7	EXIT_DT	Date(10)	DATE	Exit Date
8	EDI_STATUS_RSN	Character(3)	VARCHAR2(3) NOT NULL	Status Reason Code B52=Dropout D10=Other Attendence D11=Other School in District D12=Oth Public School in District D13=Other Public School out state D14=Over Age D15=Standard Diploma D16=Special Diploma D17=Certification of Completion D18=Special Certificate of Complt D19=General Education Devlp Diplma D20=Non-public D21=Hardship D22=Not Entered in School D23=Public Schl 1st Time in State D24=Returned to regular education D30=Declined services EB4=Graduated
9	PRIORITY_NBR	Number(3,0)	SMALLINT NOT NULL	Priority
10	APP_ERROR	Character(1)	VARCHAR2(1) NOT NULL	Application Error Y/N Table Edit Default Value: N
11	TRANS_ROW_ID	Character(3)	VARCHAR2(3) NOT NULL	Transaction Row ID