ISIR_CNTRL_VW

(SQL View)
 Index Back

ISIR Internals/Control Data

This table contains those data elements necessary to maintain the FAFSA application and changes to ISIR data.

SELECT A.EMPLID , A.INSTITUTION , A.AID_YEAR , A.EFFDT , A.EFFSEQ , A.ISIR_TXN_NBR , A.ORIG_SSN , A.NAME_CD , A.SS_MATCH , A.SS_REGISTRATION , A.INS_MATCH , A.SSN_MATCH , A.DT_APP_RECEIVED , A.PELL_ELIGIBILITY , A.SAR_C_FLAG , A.VERF_SELECTION_IND , A.INS_VERF_NUM , A.SSA_CITIZENSHP_IND , B.DEPNDNCY_STAT , C.NSLDS_MATCH , A.VA_MATCH , A.PRISONER_MATCH , B.DRUG_OFFENSE_CONV , A.TRANS_PROCESS_DT , A.APP_SOURCE_CODE , A.CORRECTION_STATUS , A.CORR_STAT_DT , A.ISIR_CORR_SRC , A.INST_PROCESS_DT ,B.IWD_STD_LAST_NAME FROM PS_ISIR_CONTROL A , PS_ISIR_STUDENT B , PS_ISIR_INTERPRET C WHERE A.EFFDT = ( SELECT MAX (EFFDT) FROM PS_ISIR_CONTROL A1 WHERE A1.EMPLID = A.EMPLID AND A1.INSTITUTION =A.INSTITUTION AND A1.AID_YEAR = A.AID_YEAR AND A1.EFFSEQ = A.EFFSEQ AND A1.EFFDT <= %CurrentDateIn) AND A.EFFSEQ= ( SELECT MAX(EFFSEQ) FROM PS_ISIR_CONTROL A2 WHERE A2.EMPLID =A.EMPLID AND A2.INSTITUTION = A.INSTITUTION AND A2.AID_YEAR = A.AID_YEAR AND A2.EFFDT =A.EFFDT) AND A.EMPLID=B.EMPLID AND A.INSTITUTION = B.INSTITUTION AND A.AID_YEAR = B.AID_YEAR AND A.EFFDT= B.EFFDT AND A.EFFSEQ=B.EFFSEQ AND B.TABLE_ID='1' AND A.EMPLID=C.EMPLID AND A.INSTITUTION = C.INSTITUTION AND A.AID_YEAR = C.AID_YEAR AND A.EFFDT= C.EFFDT AND A.EFFSEQ=C.EFFSEQ AND C.TABLE_ID='1'

  • Parent record: STUDENT_AID

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PEOPLE_SRCH

    2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

    3 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year

    Prompt Table: STUDENT_AID

    4 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    5 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
    6 ISIR_TXN_NBR Number(2,0) SMALLINT NOT NULL Transaction Num
    7 ORIG_SSN Character(9) VARCHAR2(9) NOT NULL Original SSN
    8 NAME_CD Character(2) VARCHAR2(2) NOT NULL Name Code
    9 SS_MATCH Character(1) VARCHAR2(1) NOT NULL Selective Service Match
    I=Institutional Override
    L=Record Returned Late
    N=Regist Status Not Confirmed
    T=Temporarily Exempt
    Y=Registration Status Confirmed
    Z=Record Mismatch
    10 SS_REGISTRATION Character(1) VARCHAR2(1) NOT NULL Selective Service Registration
    I=Institutional Override
    L=Record Returned Late
    N=Registration not completed
    T=Temporarily Exempt
    Y=Registration Confirmed
    Z=Record Mismatch
    11 INS_MATCH Character(1) VARCHAR2(1) NOT NULL INS Match
    D=Duplicate case
    I=Invalid ARN
    L=Record Returned Late
    N=Citizenship Not Confirmed
    Y=Citizenship Confirmed
    Z=Record Mismatch
    12 SSN_MATCH Character(1) VARCHAR2(1) NOT NULL SSN Match
    0=Record Returned Late
    1=No Match
    2=SSN and Name, no DOB
    3=SSN Only, No Name
    4=SSN, Name, and DOB Match
    5=All match Date of Death
    6=SSN not verified
    8=Record Not Sent to SSA
    9=Record Mismatch
    I=Institutional Override
    13 DT_APP_RECEIVED Date(10) DATE Date Application Received
    14 PELL_ELIGIBILITY Character(1) VARCHAR2(1) NOT NULL Federal PELL Eligibility
    Y=Yes
    15 SAR_C_FLAG Character(1) VARCHAR2(1) NOT NULL Indicates When 'C' Printed SAR
    Y=SAR C Flag Set
    16 VERF_SELECTION_IND Character(2) VARCHAR2(2) NOT NULL Verification Selection Ind
    *=Subsequent Trans Select
    N=Not Selected
    Y=Selected
    17 INS_VERF_NUM Character(15) VARCHAR2(15) NOT NULL INS Verification Nbr
    18 SSA_CITIZENSHP_IND Character(1) VARCHAR2(1) NOT NULL SSA Citizenship Indicator
    *=Foreign born
    A=U.S. Citizen
    B=Legal Alien, work eligible
    C=Legal Alien, work ineligible
    D=Other
    E=Alien/student restrc/wk elig
    F=Alien, conditionally legal
    I=Institutional Override
    N=No Match on Name or DOB
    19 DEPNDNCY_STAT Character(1) VARCHAR2(1) NOT NULL Dependency Status
    1=Independent
    2=Dependent
    3=Indepenedent/Pro Judgmnt
    D=Dependent
    I=Independent
    X=Dependent Reject
    Y=Independent Reject
    Z=Provisional Independent
    20 NSLDS_MATCH Character(1) VARCHAR2(1) NOT NULL NSLDS Match
    0=Init of Flag or Late
    1=Eligible for Title IV aid
    2=Default
    3=Overpayment
    4=Default and Overpayment
    5=Eligible Partial Title IV Aid
    7=Match, but no data
    8=Transaction Not Sent
    9=Mismatch
    21 VA_MATCH Character(1) VARCHAR2(1) NOT NULL Veteran Status Match Flag
    1=Veteran status confirmed
    2=Record found on VA db not Qual
    3=Record not found on VA db
    4=Active Duty
    8=Record not sent to VA
    22 PRISONER_MATCH Character(1) VARCHAR2(1) NOT NULL Prisoner Match
    0=Not sent to SSA/Not a Prisoner
    1=Prisoner in Local Facility
    2=In State or Federal Facility
    8=Not sent for match
    I=Institutional Override
    23 DRUG_OFFENSE_CONV Character(1) VARCHAR2(1) NOT NULL Drug Offense Conviction
    1=Eligible
    2=Partially Eligible
    3=Ineligible or Don't know
    I=Institutional Override
    24 TRANS_PROCESS_DT Date(10) DATE Transaction Process Date
    25 APP_SOURCE_CODE Character(1) VARCHAR2(1) NOT NULL Application Source Code
    0=Need Access
    0=Need Access
    1=Electronic Initial Application
    2=Electronic Renewal Aplication
    3=Electronic Correction
    4=FAFSA Express
    5=ACT
    6=I-NET
    7=NCS
    8=Profile
    9=Institutional Application
    O=FT Canada Student Loan
    P=PT Canada Student Loan
    26 CORRECTION_STATUS Character(1) VARCHAR2(1) NOT NULL Correction Status
    1=Correction(s) Pending
    2=Send Correction(s)
    3=Correction(s) Sent
    4=Correction(s) Accepted
    5=Corrections Rejected
    6=Do Not Send Corrections
    27 CORR_STAT_DT Date(10) DATE Correction Status Date
    28 ISIR_CORR_SRC Character(1) VARCHAR2(1) NOT NULL Correction Source
    A=Applicant
    D=CPS
    S=School
    29 INST_PROCESS_DT Date(10) DATE Institution Process Date
    30 IWD_STD_LAST_NAME Character(35) VARCHAR2(35) NOT NULL Last Name