|
SELECT A.ECTRANSID , A.ECQUEUEINSTANCE , A.ECTRANSINOUTSW , A.ISIR_SEQ_NO , H.CPS_RECORD_TYPE , H.IWD_TRANS_SOURCE , A.IWD_INPUT_REC_TYPE , A.BATCH_NUMBER , B.IWD_ELEC_APP_SOURC , 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 FROM PS_ISIR_00_HEAD_EC H , PS_ISIR_00_1_EC A , PS_ISIR_00_2_EC B , PS_ISIR_00_3_EC C WHERE H.ECTRANSID = A.ECTRANSID AND H.ECTRANSID = B.ECTRANSID AND H.ECTRANSID = C.ECTRANSID AND H.ECQUEUEINSTANCE = A.ECQUEUEINSTANCE AND H.ECQUEUEINSTANCE = B.ECQUEUEINSTANCE AND H.ECQUEUEINSTANCE = C.ECQUEUEINSTANCE AND H.ECTRANSINOUTSW = A.ECTRANSINOUTSW AND H.ECTRANSINOUTSW = B.ECTRANSINOUTSW AND H.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 |
CPS_RECORD_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Record Type
#A=Electronic App ISIRs
#B=Renewal App ISIRs
#C=Correction/Duplicate ISIRs
#E=Automatic ISIRs
#F=Federal Data Requests
#G=System Generated
#I=Year to Date
#K=State Agency Non-resident
#L=State Agency Resident ISIRs
#S=Signature Corrections
#Y=Reprocessed Records
#Z=CPS System Generated
|
| 6 |
IWD_TRANS_SOURCE |
Character(2) |
VARCHAR2(2) NOT NULL |
Transaction Source Site Cd
|
| 7 |
IWD_INPUT_REC_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
field 116 on the 2001 ISIR Detail
C=Correction Application
D=Duplicate Request
H=History Correction
Q=EDE Quick Correction
R=Renewal FAFSA/Web
S=Web Signatures
V=EDE Verification Corrections
|
| 8 |
BATCH_NUMBER |
Character(23) |
VARCHAR2(23) NOT NULL |
CPS Batch Number
|
| 9 |
IWD_ELEC_APP_SOURC |
Character(1) |
VARCHAR2(1) NOT NULL |
Electronic App Entry Source
2=FAA Entry
3=Easy FAFSA
4=FAFSA Express Diskette
5=FAFSA Web Download
6=Spanish - FOTW
7=Renewal FOTW
8=English FOTW
9=FAA Access
|
| 10 |
IWD_PROC_REC_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
field 133 on the 2002 ISIR
C=Correction Application
H=History/Duplicate
|
| 11 |
IWD_HIST_CORR_APP |
Character(2) |
VARCHAR2(2) NOT NULL |
History Correction Applied
|
| 12 |
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
|
| 13 |
IWD_SOURCE_CORR |
Character(1) |
VARCHAR2(1) NOT NULL |
Source of Correction
A=Applicant
D=CPS
S=School
|
| 14 |
IWD_EFC_CHNG_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
EFC Change Flag
1=SAI Increase
2=SAI Decrease
|
| 15 |
NSLDS_POST_SCREEN |
Character(2) |
VARCHAR2(2) NOT NULL |
NSLDS Post-Screening Code
|
| 16 |
NSLDS_POST_SCREEN2 |
Character(2) |
VARCHAR2(2) NOT NULL |
NSLDS Post-Screening Code 2
|
| 17 |
NSLDS_POST_SCREEN3 |
Character(2) |
VARCHAR2(2) NOT NULL |
NSLDS Post-Screening Code 3
|
| 18 |
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
|
| 19 |
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
|
| 20 |
SCHOOL_CHOICE_1 |
Character(6) |
VARCHAR2(6) NOT NULL |
Student's 1st Choice School
|
| 21 |
SCHOOL_CHOICE_2 |
Character(6) |
VARCHAR2(6) NOT NULL |
Student's 2nd Choice School
|
| 22 |
SCHOOL_CHOICE_3 |
Character(6) |
VARCHAR2(6) NOT NULL |
Student's 3rd Choice School
|
| 23 |
SCHOOL_CHOICE_4 |
Character(6) |
VARCHAR2(6) NOT NULL |
Student's 4th Choice School
|
| 24 |
SCHOOL_CHOICE_5 |
Character(6) |
VARCHAR2(6) NOT NULL |
Student's 5th Choice School
|
| 25 |
SCHOOL_CHOICE_6 |
Character(6) |
VARCHAR2(6) NOT NULL |
Student's 6th Choice School
|