ISIR_00_IN_VW

(SQL View)
 Index Back

ISIR 1999-2000 Inbound Dtl Vw

SQL Build process began on 12/29/98 at 2:00:02 PM for database FA700TS1 Informational: ISIR_00_IN_VW - view created successfully. (76,18) SQL Build process ended on 12/29/98 at 2:00:08 PM. 1 records processed, 0 errors, 0 warnings

SELECT A.ECTRANSID , A.ECQUEUEINSTANCE , A.ECTRANSINOUTSW , B.ISIR_SEQ_NO , B.EMPLID , B.SSN , B.ORIG_SSN , B.NAME_CD , B.IWD_TRANS_NBR , B.IWD_STD_LAST_NAME , B.IWD_STD_FIRST_NM02 , B.IWD_STU_MI , B.BIRTHDATE , C.VERF_SELECTION_IND , C.IWD_REJECT_CODES , C.IWD_PRIMARY_EFC , B.ADMIT_LVL , B.ISIR_LOAD_STATUS , B.ISIR_LOAD_ACTION , B.SUSPEND_REASON , B.DISCARD_REASON , B.PROCESS_INSTANCE , B.ERROR_CODE , A.CPS_SCHOOL_CODE , A.CPS_RECORD_TYPE , B.EFC_STATUS_MSG FROM PS_ISIR_00_HEAD_EC A , PS_ISIR_00_1_EC B , PS_ISIR_00_2_EC C WHERE A.ECTRANSID = B.ECTRANSID AND B.ECTRANSID = C.ECTRANSID AND A.ECQUEUEINSTANCE = B.ECQUEUEINSTANCE AND B.ECQUEUEINSTANCE = C.ECQUEUEINSTANCE AND A.ECTRANSINOUTSW = B.ECTRANSINOUTSW AND B.ECTRANSINOUTSW = C.ECTRANSINOUTSW AND B.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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
6 SSN Character(9) VARCHAR2(9) NOT NULL Social Security #
7 ORIG_SSN Character(9) VARCHAR2(9) NOT NULL Original SSN
8 NAME_CD Character(2) VARCHAR2(2) NOT NULL Name Code
9 IWD_TRANS_NBR Character(2) VARCHAR2(2) NOT NULL Transaction Number
10 IWD_STD_LAST_NAME Character(35) VARCHAR2(35) NOT NULL Last Name
11 IWD_STD_FIRST_NM02 Character(35) VARCHAR2(35) NOT NULL Student's First Name
12 IWD_STU_MI Character(15) VARCHAR2(15) NOT NULL Student Middle Initial
13 BIRTHDATE Date(10) DATE Date of Birth
14 VERF_SELECTION_IND Character(2) VARCHAR2(2) NOT NULL Verification Selection Ind
*=Subsequent Trans Select
N=Not Selected
Y=Selected
15 IWD_REJECT_CODES Character(110) VARCHAR2(110) NOT NULL Reject Reason Codes
16 IWD_PRIMARY_EFC Character(6) VARCHAR2(6) NOT NULL Primary EFC
17 ADMIT_LVL Character(1) VARCHAR2(1) NOT NULL Student's Admit Lvl
0=0 - Student Not Found
1=1 - Has Not Applied
2=2 - Inactive
3=3 - Applied/Pending
4=4 - Admitted
5=5 - Accepted/Continuing
18 ISIR_LOAD_STATUS Character(1) VARCHAR2(1) NOT NULL Load Status
C=Change Processed
E=Error Encountered
K=Skipped
L=Loaded
S=Suspended
U=Unprocessed
19 ISIR_LOAD_ACTION Character(1) VARCHAR2(1) NOT NULL Load Action
A=Add ISIR
I=Skip/Done
R=Recycle
20 SUSPEND_REASON Character(1) VARCHAR2(1) NOT NULL Suspend Reason
1=1 - Student ID not Found
2=2 - Student not at Load Level
3=3 - Final Review Flag Set
4=4 - No SAI Calculation
5=5 - Invalid School Code
6=6 - Student Id already Exists
7=ISIR Tran Nbr out of Sequence
8=8 - Registration Only Record
9=9 -Non-Unique Student ID Found
A=A - Student not at Admit Level
E=SAI Mismatch
F=10 - FA Term Not Built
H=13 - HHB Add Person Suspend
L=Load Update Profile Set To No
M=11 - Manually Set to Suspended
P=12- Packaging Completed
T=Prof Tran Nbr out of Sequence

Prompt Table: XLAT_SUSPRSN_VW

21 DISCARD_REASON Character(1) VARCHAR2(1) NOT NULL Skip Reason
1=1 - Student ID not Found
2=2 - Student not at Load Level
3=3 - Final Review Flag Set
4=4 - No EFC Calculation
5=5 - Invalid School Code
6=6 - Student Id already Exists

Prompt Table: XLAT_DISCRSN_VW

22 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
23 ERROR_CODE Character(1) VARCHAR2(1) NOT NULL Error Code
1=1 - Student ID not Found
2=2 - Student not at Load Level
3=3 - Final Review Flag Set
4=4 - No EFC Calculation
5=5 - Invalid School Code
6=6 - Student Id already Exists

Prompt Table: XLAT_ERRCODE_VW

24 CPS_SCHOOL_CODE Character(6) VARCHAR2(6) NOT NULL CPS School Code. Also known as Title IV School Code
25 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
26 EFC_STATUS_MSG Character(1) VARCHAR2(1) NOT NULL EFC Status after the ISIR Load
I=EFC Override Ignored
N=INAS Called
U=EFC Override Used