FAN_ISIR_INT_VW

(SQL View)
 Index Back

Asumd, Rejctd, Comntd View

This table contains those data elements necessary to support professional judgement overrides. This is a view of this table used for Fin Aid Award Notification Letter equation selection processing.

SELECT A.EMPLID ,A.INSTITUTION ,A.AID_YEAR ,A.CURRENCY_CD ,A.NSLDS_MATCH ,A.REJ_OVR_IND_STDNT ,A.REJ_OVR_DEP_STDNT ,A.REJ_OVR_STDNT_NAME ,A.REJ_OVR_INV_DEBT ,A.REJ_OVR_BIG_FAMILY ,A.ASMPTN_OVR_FAM_MEM ,A.ASMPTN_OVR_COL_P ,A.ASMPTN_OVR_AGI_P ,A.ASMPTN_OVR_COL_S ,A.ASMPTN_OVR_AGI_S ,A.ASMPTN_OVR_SSN_BEN ,A.ASMPTN_OVR_WS3_P ,A.ASMPTN_OVR_WS3_S ,A.ASMPTN_OVR_WSA_P ,A.ASMPTN_OVR_WSA_S ,A.ASMD_STU_TAX_STAT ,A.ASMD_STU_EXP_TAX ,A.ASMD_PAR_TAX_STAT ,A.ASMD_PAR_EXP_TAX ,A.ASMD_SPOMO_EXP_INC ,A.ASMD_STUFA_EXP_INC ,A.ASMD_EXP_TAX_PAID ,A.ASMD_CITIZENSHIP ,A.ASMD_STU_MAR_STAT ,A.ASMD_STU_DOB_PRIOR ,A.ASMD_STU_MARRIED ,A.ASMD_STU_VA_STAT ,A.ASMD_STU_LGL_DEP ,A.ASMD_STU_NBR_INFAM ,A.ASMD_STU_NBR_COLL ,A.ASMD_STU_AGI ,A.ASMD_STU_ERN_INC ,A.ASMD_SPS_ERN_INC ,A.ASMD_STU_WKB ,A.ASMD_STU_TAX_PAID ,A.ASMD_PAR_MAR_STAT ,A.ASMD_PAR_NBR_INFAM ,A.ASMD_PAR_NBR_COLL ,A.ASMD_PAR_AGI ,A.ASMD_DAD_ERN_INC ,A.ASMD_MOM_ERN_INC ,A.ASMD_PAR_ERN_INC ,A.ASMD_PAR_WKB ,A.ASMD_PAR_TAX_PAID ,A.ASMD_FATHER_SSN ,A.ASMD_MOTHER_SSN ,A.ASMD_STU_EIC ,A.ASMD_CHILDREN ,A.ASMD_STU_WKC ,A.ASMD_PAR_WKC FROM PS_ISIR_INTERPRET A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_ISIR_INTERPRET B WHERE B.EMPLID = A.EMPLID AND B.INSTITUTION = A.INSTITUTION AND B.AID_YEAR = A.AID_YEAR AND B.EFFDT <= %CurrentDateIn ) AND A.EFFSEQ = ( SELECT MAX(C.EFFSEQ) FROM PS_ISIR_INTERPRET C WHERE C.EMPLID = A.EMPLID AND C.INSTITUTION = A.INSTITUTION AND C.AID_YEAR = A.AID_YEAR AND C.EFFDT = A.EFFDT ) AND A.TABLE_ID = '1'

  • Parent record: ISIR_CONTROL

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

    Prompt Table: PERSONAL_DATA

    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: ISIR_CONTROL

    4 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    5 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
    6 REJ_OVR_IND_STDNT Character(1) VARCHAR2(1) NOT NULL Student Independnt Status
    1=Yes
    2=No
    7 REJ_OVR_DEP_STDNT Character(1) VARCHAR2(1) NOT NULL Student Debt GT Value
    1=Yes
    2=No
    8 REJ_OVR_STDNT_NAME Character(1) VARCHAR2(1) NOT NULL Student First/Last Name
    1=Yes
    2=No
    9 REJ_OVR_INV_DEBT Character(1) VARCHAR2(1) NOT NULL Stu/Par Invest Value
    1=Yes
    2=No
    10 REJ_OVR_BIG_FAMILY Character(1) VARCHAR2(1) NOT NULL Large Family Size
    1=Yes
    2=No
    11 ASMPTN_OVR_FAM_MEM Character(1) VARCHAR2(1) NOT NULL Parent Nbr In Family
    1=Yes
    2=No
    12 ASMPTN_OVR_COL_P Character(1) VARCHAR2(1) NOT NULL Parent Num In College
    1=Yes
    2=No
    13 ASMPTN_OVR_AGI_P Character(1) VARCHAR2(1) NOT NULL Parent AGI
    1=Yes
    2=No
    14 ASMPTN_OVR_COL_S Character(1) VARCHAR2(1) NOT NULL Student Num In College
    1=Yes
    2=No
    15 ASMPTN_OVR_AGI_S Character(1) VARCHAR2(1) NOT NULL Student AGI
    1=Yes
    2=No
    16 ASMPTN_OVR_SSN_BEN Character(1) VARCHAR2(1) NOT NULL Student SocSec Benefits (0099)
    1=Yes
    2=No
    17 ASMPTN_OVR_WS3_P Character(1) VARCHAR2(1) NOT NULL Par Inc. From WKB/C Asmd 0
    1=Yes
    2=No
    18 ASMPTN_OVR_WS3_S Character(1) VARCHAR2(1) NOT NULL Stu Inc. From WKB/C Asmd 0
    1=Yes
    2=No
    19 ASMPTN_OVR_WSA_P Character(1) VARCHAR2(1) NOT NULL Par Total from WSA Asmd
    1=Yes
    20 ASMPTN_OVR_WSA_S Character(1) VARCHAR2(1) NOT NULL Stu Total from WSA Asmd
    1=Yes
    21 ASMD_STU_TAX_STAT Character(1) VARCHAR2(1) NOT NULL Tax Status 1995
    1=Assumed Tax Filer
    2=Assumed Tax Filer
    3=Assumed Non Tax Filer
    4=Assumed Non Tax Filer
    22 ASMD_STU_EXP_TAX Character(1) VARCHAR2(1) NOT NULL Expected Tax Stat
    1=Assumed Tax Filer
    2=Assumed Tax Filer
    3=Assumed Non Tax Filer
    4=Assumed Non Tax Filer
    23 ASMD_PAR_TAX_STAT Character(1) VARCHAR2(1) NOT NULL Tax Status 1995
    1=Assumed Tax Filer
    2=Assumed Tax Filer
    3=Assumed Non Tax Filer
    4=Assumed Non Tax Filer
    24 ASMD_PAR_EXP_TAX Character(1) VARCHAR2(1) NOT NULL Expected Tax Status
    25 ASMD_SPOMO_EXP_INC Signed Number(6,0) DECIMAL(5) NOT NULL Spouse/Mother Expected Income
    26 ASMD_STUFA_EXP_INC Signed Number(6,0) DECIMAL(5) NOT NULL Student/Father Expected Income
    27 ASMD_EXP_TAX_PAID Signed Number(7,0) DECIMAL(6) NOT NULL Expected Tax Paid
    28 ASMD_CITIZENSHIP Character(1) VARCHAR2(1) NOT NULL Assumed Citizenship
    1=Assumed Student is a Citizen
    2=Assumd Student Is Elg Non-Cit
    29 ASMD_STU_MAR_STAT Character(1) VARCHAR2(1) NOT NULL Assumed Marital Status-Student
    30 ASMD_STU_DOB_PRIOR Character(1) VARCHAR2(1) NOT NULL DOB Before
    31 ASMD_STU_MARRIED Character(1) VARCHAR2(1) NOT NULL Assumed Value Student Married
    32 ASMD_STU_VA_STAT Character(1) VARCHAR2(1) NOT NULL Assumed Veteran
    33 ASMD_STU_LGL_DEP Character(1) VARCHAR2(1) NOT NULL Assumed Dependents
    34 ASMD_STU_NBR_INFAM Character(2) VARCHAR2(2) NOT NULL Number Of Family Members-Stu
    35 ASMD_STU_NBR_COLL Number(2,0) SMALLINT NOT NULL Number in College
    36 ASMD_STU_AGI Signed Number(8,0) DECIMAL(7) NOT NULL Assumed AGI-Student
    37 ASMD_STU_ERN_INC Signed Number(8,0) DECIMAL(7) NOT NULL Assumed Stu's Earned Income
    38 ASMD_SPS_ERN_INC Signed Number(8,0) DECIMAL(7) NOT NULL Assumed Sps's Earned Income
    39 ASMD_STU_WKB Signed Number(6,0) DECIMAL(5) NOT NULL Assumed WKB - Stu
    40 ASMD_STU_TAX_PAID Signed Number(8,0) DECIMAL(7) NOT NULL Assumed U. S. Tax Paid
    41 ASMD_PAR_MAR_STAT Character(1) VARCHAR2(1) NOT NULL Assumed Marital Status-Parent
    42 ASMD_PAR_NBR_INFAM Character(2) VARCHAR2(2) NOT NULL Number Of Family Members-Par
    43 ASMD_PAR_NBR_COLL Number(2,0) SMALLINT NOT NULL Assumed Number in College
    44 ASMD_PAR_AGI Signed Number(8,0) DECIMAL(7) NOT NULL Assumed AGI-Parent
    45 ASMD_DAD_ERN_INC Signed Number(8,0) DECIMAL(7) NOT NULL Assumed Father's Earned Income
    46 ASMD_MOM_ERN_INC Signed Number(8,0) DECIMAL(7) NOT NULL Assumed Mother's Earned Income
    47 ASMD_PAR_ERN_INC Signed Number(7,0) DECIMAL(6) NOT NULL Assumed Par's Earned Inc Cred
    48 ASMD_PAR_WKB Signed Number(6,0) DECIMAL(5) NOT NULL Assumed WKB - Par
    49 ASMD_PAR_TAX_PAID Number(7,0) INTEGER NOT NULL Par Tax Paid
    50 ASMD_FATHER_SSN Character(9) VARCHAR2(9) NOT NULL Assumed Father's SSN
    51 ASMD_MOTHER_SSN Character(9) VARCHAR2(9) NOT NULL Assumed Mother's SSN
    52 ASMD_STU_EIC Signed Number(6,0) DECIMAL(5) NOT NULL Earned Income Credit
    53 ASMD_CHILDREN Character(1) VARCHAR2(1) NOT NULL Children
    54 ASMD_STU_WKC Signed Number(9,0) DECIMAL(8) NOT NULL Worksheet C Total
    55 ASMD_PAR_WKC Signed Number(9,0) DECIMAL(8) NOT NULL Assumed WKC - Par