ISIR_SUS5_STGVW

(SQL View)
Index Back

SELECT A.ECTRANSID , A.ECQUEUEINSTANCE , A.ECTRANSINOUTSW , A.ISIR_SEQ_NO , B.IWD_TRANS_SOURCE , B.IWD_PROC_REC_TYPE , B.IWD_HIST_CORR_APP , B.SYSTEM_GENERATED , B.IWD_SOURCE_CORR , B.IWD_EFC_CHNG_FLAG , C.NSLDS_POST_SCREEN , C.NSLDS_POST_SCREEN2 , C.NSLDS_POST_SCREEN3 , B.ELEC_INSTITUT_IND , B.CPS_REPROCESS_CD , 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.IWD_APP_SOURCE , B.ADDR_ONLY_CHNG_FLG , B.ISIR_CPS_PUSHED , B.ISIR_SAR_C_CHNG , B.ISIR_ETI FROM PS_ISIR_00_1_EC A , PS_ISIR_00_2_EC B , PS_ISIR_00_3_EC C WHERE A.ECTRANSID = B.ECTRANSID AND A.ECTRANSID = C.ECTRANSID AND A.ECQUEUEINSTANCE = B.ECQUEUEINSTANCE AND A.ECQUEUEINSTANCE = C.ECQUEUEINSTANCE AND A.ECTRANSINOUTSW = B.ECTRANSINOUTSW AND A.ECTRANSINOUTSW = C.ECTRANSINOUTSW AND A.ISIR_SEQ_NO = B.ISIR_SEQ_NO AND A.ISIR_SEQ_NO = C.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 IWD_TRANS_SOURCE Character(2) VARCHAR2(2) NOT NULL Transaction Source Site Cd
6 IWD_PROC_REC_TYPE Character(1) VARCHAR2(1) NOT NULL field 133 on the 2002 ISIR
C=Correction Application
H=History/Duplicate
7 IWD_HIST_CORR_APP Character(2) VARCHAR2(2) NOT NULL History Correction Applied
8 SYSTEM_GENERATED Character(1) VARCHAR2(1) NOT NULL System Generated Indicator
A=Release from Drug Enf Hold
D=Duplicate Request
H=Applcation Released from Hold
I=INS Secondary Confirmation
L=Dup Req, Match data changed
N=NSLDS post-screening transact
P=Dup Req/Prison Match Change
R=Rematched Transaction
S=Dup SSN and no activity
Z=Reprocessed Transaction
9 IWD_SOURCE_CORR Character(1) VARCHAR2(1) NOT NULL Source of Correction
A=Applicant
D=CPS
S=School
10 IWD_EFC_CHNG_FLAG Character(1) VARCHAR2(1) NOT NULL EFC Change Flag
1=SAI Increase
2=SAI Decrease
11 NSLDS_POST_SCREEN Character(2) VARCHAR2(2) NOT NULL NSLDS Post-Screening Code
12 NSLDS_POST_SCREEN2 Character(2) VARCHAR2(2) NOT NULL NSLDS Post-Screening Code 2
13 NSLDS_POST_SCREEN3 Character(2) VARCHAR2(2) NOT NULL NSLDS Post-Screening Code 3
14 ELEC_INSTITUT_IND Character(1) VARCHAR2(1) NOT NULL Electronic Institution Ind
0=Federal School Code #10
1=Federal School Code #1
2=Federal School Code #2
3=Federal School Code #3
4=Federal School Code #4
5=Federal School Code #5
6=Federal School Code #6
7=Federal School Code #7
8=Federal School Code #8
9=Federal School Code #9
15 CPS_REPROCESS_CD Character(2) VARCHAR2(2) NOT NULL Reprocess Code
A=Rls From Drug Enforcement Hold
D=Duplicate Request
H=Application Released from Hold
L=NSLDS History Correction
R=Rematched Transaction
S=Duplicate SSN
Z=Reprocessed Transaction
16 SCHOOL_CHOICE_1 Character(6) VARCHAR2(6) NOT NULL Student's 1st Choice School
17 SCHOOL_CHOICE_2 Character(6) VARCHAR2(6) NOT NULL Student's 2nd Choice School
18 SCHOOL_CHOICE_3 Character(6) VARCHAR2(6) NOT NULL Student's 3rd Choice School
19 SCHOOL_CHOICE_4 Character(6) VARCHAR2(6) NOT NULL Student's 4th Choice School
20 SCHOOL_CHOICE_5 Character(6) VARCHAR2(6) NOT NULL Student's 5th Choice School
21 SCHOOL_CHOICE_6 Character(6) VARCHAR2(6) NOT NULL Student's 6th Choice School
22 IWD_APP_SOURCE Character(2) VARCHAR2(2) NOT NULL CPS Appl Source Site Cd
23 ADDR_ONLY_CHNG_FLG Character(1) VARCHAR2(1) NOT NULL Address Only Change Flag
1=Student's Mailing Address
2=Student's E-mail Address
3=Parent's E-mail Address
4=More than one address
24 ISIR_CPS_PUSHED Character(1) VARCHAR2(1) NOT NULL CPS Pushed ISIR Flag
25 ISIR_SAR_C_CHNG Character(1) VARCHAR2(1) NOT NULL ISIR SAR C Flag Changed
Y=FPS C Flag Has Changed
26 ISIR_ETI Character(1) VARCHAR2(1) NOT NULL ISIR Elec Trans Indicator
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=State Resdnt, daily ISIR
B=Non-Resdnt,daily ISIR
C=State Resdnt,pushed ISIR
D=Non-Resdnt,pushed ISIR
E=State Resdnt,ISIR reqst
F=Non-Resdnt,ISIR reqst