|
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.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 , B.SFA_REJ_ST_CHG_FLG , B.SFA_VF_SEL_CHG_FLG , A.SFA_SCHL_CHOICE_7 , A.SFA_SCHL_CHOICE_8 , A.SFA_SCHL_CHOICE_9 , A.SFA_SCHL_CHOICE_10 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 |
IWD_SOURCE_CORR |
Character(1) |
VARCHAR2(1) NOT NULL |
Source of Correction
A=Applicant
D=CPS
S=School
|
| 9 |
IWD_EFC_CHNG_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
EFC Change Flag
1=SAI Increase
2=SAI Decrease
|
| 10 |
NSLDS_POST_SCREEN |
Character(2) |
VARCHAR2(2) NOT NULL |
NSLDS Post-Screening Code
|
| 11 |
NSLDS_POST_SCREEN2 |
Character(2) |
VARCHAR2(2) NOT NULL |
NSLDS Post-Screening Code 2
|
| 12 |
NSLDS_POST_SCREEN3 |
Character(2) |
VARCHAR2(2) NOT NULL |
NSLDS Post-Screening Code 3
|
| 13 |
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
|
| 14 |
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
|
| 15 |
SCHOOL_CHOICE_1 |
Character(6) |
VARCHAR2(6) NOT NULL |
Student's 1st Choice School
|
| 16 |
SCHOOL_CHOICE_2 |
Character(6) |
VARCHAR2(6) NOT NULL |
Student's 2nd Choice School
|
| 17 |
SCHOOL_CHOICE_3 |
Character(6) |
VARCHAR2(6) NOT NULL |
Student's 3rd Choice School
|
| 18 |
SCHOOL_CHOICE_4 |
Character(6) |
VARCHAR2(6) NOT NULL |
Student's 4th Choice School
|
| 19 |
SCHOOL_CHOICE_5 |
Character(6) |
VARCHAR2(6) NOT NULL |
Student's 5th Choice School
|
| 20 |
SCHOOL_CHOICE_6 |
Character(6) |
VARCHAR2(6) NOT NULL |
Student's 6th Choice School
|
| 21 |
IWD_APP_SOURCE |
Character(2) |
VARCHAR2(2) NOT NULL |
CPS Appl Source Site Cd
|
| 22 |
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
|
| 23 |
ISIR_CPS_PUSHED |
Character(1) |
VARCHAR2(1) NOT NULL |
CPS Pushed ISIR Flag
|
| 24 |
ISIR_SAR_C_CHNG |
Character(1) |
VARCHAR2(1) NOT NULL |
ISIR SAR C Flag Changed
Y=FPS C Flag Has Changed
|
| 25 |
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
|
| 26 |
SFA_REJ_ST_CHG_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Rejected Status Change Flag
1=REJ ST C Flag Has Changed
|
| 27 |
SFA_VF_SEL_CHG_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Verification Select Chng Flag
C=Change in Verif Tracking Grp
Y=VF SEL C Flag Has Changed
|
| 28 |
SFA_SCHL_CHOICE_7 |
Character(6) |
VARCHAR2(6) NOT NULL |
Student's 7th Choice School
|
| 29 |
SFA_SCHL_CHOICE_8 |
Character(6) |
VARCHAR2(6) NOT NULL |
Student's 8th Choice School
|
| 30 |
SFA_SCHL_CHOICE_9 |
Character(6) |
VARCHAR2(6) NOT NULL |
Student's 9th Choice School
|
| 31 |
SFA_SCHL_CHOICE_10 |
Character(6) |
VARCHAR2(6) NOT NULL |
Student's 10th Choice School
|