ISIR_SUSP_SRCH7

(SQL View)
 Index Back

SELECT DISTINCT A.OPRCLASS , A.ECTRANSID , A.ECQUEUEINSTANCE , A.ECTRANSINOUTSW , B.CPS_RECORD_TYPE , A.ISIR_SEQ_NO , B.CPS_SCHOOL_CODE , A.SSN , A.SSN_MSK , A.EMPLID , A.ISIR_LOAD_STATUS , QUEUE.ECQUEUESTATUS , A.NAME_CD , A.BIRTHDATE , A.BIRTHDATE_MSK , A.IWD_STD_LAST_NAME , A.IWD_STD_FIRST_NM02 , A.IWD_STU_MI , A.ISIR_LOAD_ACTION FROM PS_ISIR_00_1_EC_VW A , PS_ISIR_00_HEAD_EC B , PS_ECQUEUE QUEUE WHERE A.ECTRANSID = QUEUE.ECTRANSID AND A.ECQUEUEINSTANCE = QUEUE.ECQUEUEINSTANCE AND A.ECTRANSINOUTSW = QUEUE.ECTRANSINOUTSW AND A.ECTRANSID = B.ECTRANSID AND A.ECQUEUEINSTANCE = B.ECQUEUEINSTANCE AND A.ECTRANSINOUTSW = B.ECTRANSINOUTSW AND QUEUE.ECQUEUESTATUS <> 'P' AND B.IWD_AWARD_YEAR = '0607'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRCLASS Character(30) VARCHAR2(30) NOT NULL Operator Class
2 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)
3 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.
4 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
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 ISIR_SEQ_NO Number(5,0) INTEGER NOT NULL Sequence Number
7 CPS_SCHOOL_CODE Character(6) VARCHAR2(6) NOT NULL CPS School Code. Also known as Title IV School Code
8 SSN Character(9) VARCHAR2(9) NOT NULL Social Security #
9 SSN_MSK Character(9) VARCHAR2(9) NOT NULL Social Security #
10 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
11 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
12 ECQUEUESTATUS Character(1) VARCHAR2(1) NOT NULL EC Queue Status
E=Error
L=Loaded
P=Processed
13 NAME_CD Character(2) VARCHAR2(2) NOT NULL Name Code
14 BIRTHDATE Date(10) DATE Date of Birth
15 BIRTHDATE_MSK Character(10) VARCHAR2(10) NOT NULL Date of Birth
16 IWD_STD_LAST_NAME Character(35) VARCHAR2(35) NOT NULL Last Name
17 IWD_STD_FIRST_NM02 Character(35) VARCHAR2(35) NOT NULL Student's First Name
18 IWD_STU_MI Character(15) VARCHAR2(15) NOT NULL Student Middle Initial
19 ISIR_LOAD_ACTION Character(1) VARCHAR2(1) NOT NULL Load Action
A=Add ISIR
I=Skip/Done
R=Recycle