ISIR_SUS56SCHVW

(SQL View)

SELECT A.ECTRANSID , A.ECQUEUEINSTANCE , A.ECTRANSINOUTSW , A.ISIR_SEQ_NO , A.SCHOOL_CHOICE_1 , A.SCHOOL_CHOICE_2 , A.SCHOOL_CHOICE_3 , A.SCHOOL_CHOICE_4 , A.SCHOOL_CHOICE_5 , A.SCHOOL_CHOICE_6 , B.MULTI_INSTITUTION1 , B.MULTI_INSTITUTION2 , B.MULTI_INSTITUTION3 , B.MULTI_INSTITUTION4 , B.MULTI_INSTITUTION5 , B.MULTI_INSTITUTION6 , A.SFA_SCHL_CHOICE_7 , A.SFA_SCHL_CHOICE_8 , A.SFA_SCHL_CHOICE_9 , A.SFA_SCHL_CHOICE_10 , B.SFA_MULTI_INST7 , B.SFA_MULTI_INST8 , B.SFA_MULTI_INST9 , B.SFA_MULTI_INST10 FROM PS_ISIR_00_1_EC A , PS_ISIR_00_2_EC B WHERE A.ECTRANSID = B.ECTRANSID AND A.ECQUEUEINSTANCE = B.ECQUEUEINSTANCE AND A.ECTRANSINOUTSW = B.ECTRANSINOUTSW AND A.ISIR_SEQ_NO = B.ISIR_SEQ_NO

# 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 ISIR_SEQ_NO Number(5,0) INTEGER NOT NULL Sequence Number

5 SCHOOL_CHOICE_1 Character(6) VARCHAR2(6) NOT NULL Student's 1st Choice School

6 SCHOOL_CHOICE_2 Character(6) VARCHAR2(6) NOT NULL Student's 2nd Choice School

7 SCHOOL_CHOICE_3 Character(6) VARCHAR2(6) NOT NULL Student's 3rd Choice School

8 SCHOOL_CHOICE_4 Character(6) VARCHAR2(6) NOT NULL Student's 4th Choice School

9 SCHOOL_CHOICE_5 Character(6) VARCHAR2(6) NOT NULL Student's 5th Choice School

10 SCHOOL_CHOICE_6 Character(6) VARCHAR2(6) NOT NULL Student's 6th Choice School

11 MULTI_INSTITUTION1 Character(1) VARCHAR2(1) NOT NULL Multiple Institution Flag 1
0=School Generated, Daily
1=Non-School Generated, Daily
2=School Generated, Request
3=Non-School Generated, Request
4=School Gen, Daily, Pushed
5=Non-School Gen, Daily, Pushed
6=School Gen, Request, Pushed
7=Non-School Gen, Request, Pushe
8=Non-School Gen,Daily,SysGen
9=Non-School Gen,Request,SysGen
A=Correction to ACG data

12 MULTI_INSTITUTION2 Character(1) VARCHAR2(1) NOT NULL Multiple Institution Flag 2
0=School Generated, Daily
1=Non-School Generated, Daily
2=School Generated, Request
3=Non-School Generated, Request
4=School Gen, Daily, Pushed
5=Non-School Gen, Daily, Pushed
6=School Gen, Request, Pushed
7=Non-School Gen, Request, Pushe
8=Non-School Gen,Daily,SysGen
9=Non-School Gen,Request,SysGen
A=Correction to ACG data

13 MULTI_INSTITUTION3 Character(1) VARCHAR2(1) NOT NULL Multiple Institution Flag 3
0=School Generated, Daily
1=Non-School Generated, Daily
2=School Generated, Request
3=Non-School Generated, Request
4=School Gen, Daily, Pushed
5=Non-School Gen, Daily, Pushed
6=School Gen, Request, Pushed
7=Non-School Gen, Request, Pushe
8=Non-School Gen,Daily,SysGen
9=Non-School Gen,Request,SysGen
A=Correction to ACG data

14 MULTI_INSTITUTION4 Character(1) VARCHAR2(1) NOT NULL Multiple Institution Flag 4
0=School Generated, Daily
1=Non-School Generated, Daily
2=School Generated, Request
3=Non-School Generated, Request
4=School Gen, Daily, Pushed
5=Non-School Gen, Daily, Pushed
6=School Gen, Request, Pushed
7=Non-School Gen, Request, Pushe
8=Non-School Gen,Daily,SysGen
9=Non-School Gen,Request,SysGen
A=Correction to ACG data

15 MULTI_INSTITUTION5 Character(1) VARCHAR2(1) NOT NULL Multiple Institution Flag 5
0=School Generated, Daily
1=Non-School Generated, Daily
2=School Generated, Request
3=Non-School Generated, Request
4=School Gen, Daily, Pushed
5=Non-School Gen, Daily, Pushed
6=School Gen, Request, Pushed
7=Non-School Gen, Request, Pushe
8=Non-School Gen,Daily,SysGen
9=Non-School Gen,Request,SysGen
A=Correction to ACG data

16 MULTI_INSTITUTION6 Character(1) VARCHAR2(1) NOT NULL Multiple Institution Flag 6
0=School Generated, Daily
1=Non-School Generated, Daily
2=School Generated, Request
3=Non-School Generated, Request
4=School Gen, Daily, Pushed
5=Non-School Gen, Daily, Pushed
6=School Gen, Request, Pushed
7=Non-School Gen, Request, Pushe
8=Non-School Gen,Daily,SysGen
9=Non-School Gen,Request,SysGen
A=Correction to ACG data

17 SFA_SCHL_CHOICE_7 Character(6) VARCHAR2(6) NOT NULL Student's 7th Choice School

18 SFA_SCHL_CHOICE_8 Character(6) VARCHAR2(6) NOT NULL Student's 8th Choice School

19 SFA_SCHL_CHOICE_9 Character(6) VARCHAR2(6) NOT NULL Student's 9th Choice School

20 SFA_SCHL_CHOICE_10 Character(6) VARCHAR2(6) NOT NULL Student's 10th Choice School

21 SFA_MULTI_INST7 Character(1) VARCHAR2(1) NOT NULL Multiple Institution Flag 7
0=School Generated, Daily
1=Non-School Generated, Daily
2=School Generated, Request
3=Non-School Generated, Request
4=School Gen, Daily, Pushed
5=Non-School Gen, Daily, Pushed
6=School Gen, Request, Pushed
7=Non-School Gen, Request, Pushe
8=Non-School Gen,Daily,SysGen
9=Non-School Gen,Request,SysGen
A=Correction to ACG data

22 SFA_MULTI_INST8 Character(1) VARCHAR2(1) NOT NULL Multiple Institution Flag 8
0=School Generated, Daily
1=Non-School Generated, Daily
2=School Generated, Request
3=Non-School Generated, Request
4=School Gen, Daily, Pushed
5=Non-School Gen, Daily, Pushed
6=School Gen, Request, Pushed
7=Non-School Gen, Request, Pushe
8=Non-School Gen,Daily,SysGen
9=Non-School Gen,Request,SysGen
A=Correction to ACG data

23 SFA_MULTI_INST9 Character(1) VARCHAR2(1) NOT NULL Multiple Institution Flag 9
0=School Generated, Daily
1=Non-School Generated, Daily
2=School Generated, Request
3=Non-School Generated, Request
4=School Gen, Daily, Pushed
5=Non-School Gen, Daily, Pushed
6=School Gen, Request, Pushed
7=Non-School Gen, Request, Pushe
8=Non-School Gen,Daily,SysGen
9=Non-School Gen,Request,SysGen
A=Correction to ACG data

24 SFA_MULTI_INST10 Character(1) VARCHAR2(1) NOT NULL Multiple Institution Flag 10
0=School Generated, Daily
1=Non-School Generated, Daily
2=School Generated, Request
3=Non-School Generated, Request
4=School Gen, Daily, Pushed
5=Non-School Gen, Daily, Pushed
6=School Gen, Request, Pushed
7=Non-School Gen, Request, Pushe
8=Non-School Gen,Daily,SysGen
9=Non-School Gen,Request,SysGen
A=Correction to ACG data

#	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	ISIR_SEQ_NO	Number(5,0)	INTEGER NOT NULL	Sequence Number
5	SCHOOL_CHOICE_1	Character(6)	VARCHAR2(6) NOT NULL	Student's 1st Choice School
6	SCHOOL_CHOICE_2	Character(6)	VARCHAR2(6) NOT NULL	Student's 2nd Choice School
7	SCHOOL_CHOICE_3	Character(6)	VARCHAR2(6) NOT NULL	Student's 3rd Choice School
8	SCHOOL_CHOICE_4	Character(6)	VARCHAR2(6) NOT NULL	Student's 4th Choice School
9	SCHOOL_CHOICE_5	Character(6)	VARCHAR2(6) NOT NULL	Student's 5th Choice School
10	SCHOOL_CHOICE_6	Character(6)	VARCHAR2(6) NOT NULL	Student's 6th Choice School
11	MULTI_INSTITUTION1	Character(1)	VARCHAR2(1) NOT NULL	Multiple Institution Flag 1 0=School Generated, Daily 1=Non-School Generated, Daily 2=School Generated, Request 3=Non-School Generated, Request 4=School Gen, Daily, Pushed 5=Non-School Gen, Daily, Pushed 6=School Gen, Request, Pushed 7=Non-School Gen, Request, Pushe 8=Non-School Gen,Daily,SysGen 9=Non-School Gen,Request,SysGen A=Correction to ACG data
12	MULTI_INSTITUTION2	Character(1)	VARCHAR2(1) NOT NULL	Multiple Institution Flag 2 0=School Generated, Daily 1=Non-School Generated, Daily 2=School Generated, Request 3=Non-School Generated, Request 4=School Gen, Daily, Pushed 5=Non-School Gen, Daily, Pushed 6=School Gen, Request, Pushed 7=Non-School Gen, Request, Pushe 8=Non-School Gen,Daily,SysGen 9=Non-School Gen,Request,SysGen A=Correction to ACG data
13	MULTI_INSTITUTION3	Character(1)	VARCHAR2(1) NOT NULL	Multiple Institution Flag 3 0=School Generated, Daily 1=Non-School Generated, Daily 2=School Generated, Request 3=Non-School Generated, Request 4=School Gen, Daily, Pushed 5=Non-School Gen, Daily, Pushed 6=School Gen, Request, Pushed 7=Non-School Gen, Request, Pushe 8=Non-School Gen,Daily,SysGen 9=Non-School Gen,Request,SysGen A=Correction to ACG data
14	MULTI_INSTITUTION4	Character(1)	VARCHAR2(1) NOT NULL	Multiple Institution Flag 4 0=School Generated, Daily 1=Non-School Generated, Daily 2=School Generated, Request 3=Non-School Generated, Request 4=School Gen, Daily, Pushed 5=Non-School Gen, Daily, Pushed 6=School Gen, Request, Pushed 7=Non-School Gen, Request, Pushe 8=Non-School Gen,Daily,SysGen 9=Non-School Gen,Request,SysGen A=Correction to ACG data
15	MULTI_INSTITUTION5	Character(1)	VARCHAR2(1) NOT NULL	Multiple Institution Flag 5 0=School Generated, Daily 1=Non-School Generated, Daily 2=School Generated, Request 3=Non-School Generated, Request 4=School Gen, Daily, Pushed 5=Non-School Gen, Daily, Pushed 6=School Gen, Request, Pushed 7=Non-School Gen, Request, Pushe 8=Non-School Gen,Daily,SysGen 9=Non-School Gen,Request,SysGen A=Correction to ACG data
16	MULTI_INSTITUTION6	Character(1)	VARCHAR2(1) NOT NULL	Multiple Institution Flag 6 0=School Generated, Daily 1=Non-School Generated, Daily 2=School Generated, Request 3=Non-School Generated, Request 4=School Gen, Daily, Pushed 5=Non-School Gen, Daily, Pushed 6=School Gen, Request, Pushed 7=Non-School Gen, Request, Pushe 8=Non-School Gen,Daily,SysGen 9=Non-School Gen,Request,SysGen A=Correction to ACG data
17	SFA_SCHL_CHOICE_7	Character(6)	VARCHAR2(6) NOT NULL	Student's 7th Choice School
18	SFA_SCHL_CHOICE_8	Character(6)	VARCHAR2(6) NOT NULL	Student's 8th Choice School
19	SFA_SCHL_CHOICE_9	Character(6)	VARCHAR2(6) NOT NULL	Student's 9th Choice School
20	SFA_SCHL_CHOICE_10	Character(6)	VARCHAR2(6) NOT NULL	Student's 10th Choice School
21	SFA_MULTI_INST7	Character(1)	VARCHAR2(1) NOT NULL	Multiple Institution Flag 7 0=School Generated, Daily 1=Non-School Generated, Daily 2=School Generated, Request 3=Non-School Generated, Request 4=School Gen, Daily, Pushed 5=Non-School Gen, Daily, Pushed 6=School Gen, Request, Pushed 7=Non-School Gen, Request, Pushe 8=Non-School Gen,Daily,SysGen 9=Non-School Gen,Request,SysGen A=Correction to ACG data
22	SFA_MULTI_INST8	Character(1)	VARCHAR2(1) NOT NULL	Multiple Institution Flag 8 0=School Generated, Daily 1=Non-School Generated, Daily 2=School Generated, Request 3=Non-School Generated, Request 4=School Gen, Daily, Pushed 5=Non-School Gen, Daily, Pushed 6=School Gen, Request, Pushed 7=Non-School Gen, Request, Pushe 8=Non-School Gen,Daily,SysGen 9=Non-School Gen,Request,SysGen A=Correction to ACG data
23	SFA_MULTI_INST9	Character(1)	VARCHAR2(1) NOT NULL	Multiple Institution Flag 9 0=School Generated, Daily 1=Non-School Generated, Daily 2=School Generated, Request 3=Non-School Generated, Request 4=School Gen, Daily, Pushed 5=Non-School Gen, Daily, Pushed 6=School Gen, Request, Pushed 7=Non-School Gen, Request, Pushe 8=Non-School Gen,Daily,SysGen 9=Non-School Gen,Request,SysGen A=Correction to ACG data
24	SFA_MULTI_INST10	Character(1)	VARCHAR2(1) NOT NULL	Multiple Institution Flag 10 0=School Generated, Daily 1=Non-School Generated, Daily 2=School Generated, Request 3=Non-School Generated, Request 4=School Gen, Daily, Pushed 5=Non-School Gen, Daily, Pushed 6=School Gen, Request, Pushed 7=Non-School Gen, Request, Pushe 8=Non-School Gen,Daily,SysGen 9=Non-School Gen,Request,SysGen A=Correction to ACG data