ISIR_INTERPRET

(SQL Table)
 Index Back

Asumd, Rejctd, Comntd Data

This table contains those data elements necessary to support professional judgement overrides.

  • 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: PERSON

    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 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    5 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
    6 TABLE_ID Character(1) VARCHAR2(1) NOT NULL Child Table Key

    Default Value: 1

    7 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    8 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
    9 REJ_OVR_IND_STDNT Character(1) VARCHAR2(1) NOT NULL Student Independnt Status
    1=Yes
    2=No
    10 REJ_OVR_DEP_STDNT Character(1) VARCHAR2(1) NOT NULL Student Debt GT Value
    1=Yes
    2=No
    11 REJ_OVR_STDNT_NAME Character(1) VARCHAR2(1) NOT NULL Student First/Last Name
    1=Yes
    2=No
    12 REJ_OVR_INV_DEBT Character(1) VARCHAR2(1) NOT NULL Stu/Par Invest Value
    1=Yes
    2=No
    13 REJ_OVR_BIG_FAMILY Character(1) VARCHAR2(1) NOT NULL Large Family Size
    1=Yes
    2=No
    14 ASMPTN_OVR_FAM_MEM Character(1) VARCHAR2(1) NOT NULL Parent Nbr In Family
    1=Yes
    2=No
    15 ASMPTN_OVR_COL_P Character(1) VARCHAR2(1) NOT NULL Parent Num In College
    1=Yes
    2=No
    16 ASMPTN_OVR_AGI_P Character(1) VARCHAR2(1) NOT NULL Parent AGI
    1=Yes
    2=No
    17 ASMPTN_OVR_COL_S Character(1) VARCHAR2(1) NOT NULL Student Num In College
    1=Yes
    2=No
    18 ASMPTN_OVR_AGI_S Character(1) VARCHAR2(1) NOT NULL Student AGI
    1=Yes
    2=No
    19 ASMPTN_OVR_SSN_BEN Character(1) VARCHAR2(1) NOT NULL Student SocSec Benefits (0099)
    1=Yes
    2=No
    20 ASMPTN_OVR_WS3_P Character(1) VARCHAR2(1) NOT NULL Par Inc. From WKB/C Asmd 0
    1=Yes
    2=No
    21 ASMPTN_OVR_WS3_S Character(1) VARCHAR2(1) NOT NULL Stu Inc. From WKB/C Asmd 0
    1=Yes
    2=No
    22 ASMPTN_OVR_WSA_P Character(1) VARCHAR2(1) NOT NULL Par Total from WSA Asmd
    1=Yes
    23 ASMPTN_OVR_WSA_S Character(1) VARCHAR2(1) NOT NULL Stu Total from WSA Asmd
    1=Yes
    24 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
    25 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
    26 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
    27 ASMD_PAR_EXP_TAX Character(1) VARCHAR2(1) NOT NULL Expected Tax Status
    28 ASMD_SPOMO_EXP_INC Signed Number(6,0) DECIMAL(5) NOT NULL Spouse/Mother Expected Income
    29 ASMD_STUFA_EXP_INC Signed Number(6,0) DECIMAL(5) NOT NULL Student/Father Expected Income
    30 ASMD_EXP_TAX_PAID Signed Number(7,0) DECIMAL(6) NOT NULL Expected Tax Paid
    31 ASMD_CITIZENSHIP Character(1) VARCHAR2(1) NOT NULL Assumed Citizenship
    1=Assumed Student is a Citizen
    2=Assumd Student Is Elg Non-Cit
    32 ASMD_STU_MAR_STAT Character(1) VARCHAR2(1) NOT NULL Assumed Marital Status-Student
    33 ASMD_STU_DOB_PRIOR Character(1) VARCHAR2(1) NOT NULL DOB Before
    34 ASMD_STU_MARRIED Character(1) VARCHAR2(1) NOT NULL Assumed Value Student Married
    35 ASMD_STU_VA_STAT Character(1) VARCHAR2(1) NOT NULL Assumed Veteran
    36 ASMD_STU_LGL_DEP Character(1) VARCHAR2(1) NOT NULL Assumed Dependents
    37 ASMD_STU_NBR_INFAM Character(2) VARCHAR2(2) NOT NULL Number Of Family Members-Stu
    38 ASMD_STU_NBR_COLL Number(2,0) SMALLINT NOT NULL Number in College
    39 ASMD_STU_AGI Signed Number(8,0) DECIMAL(7) NOT NULL Assumed AGI-Student
    40 ASMD_STU_ERN_INC Signed Number(8,0) DECIMAL(7) NOT NULL Assumed Stu's Earned Income
    41 ASMD_SPS_ERN_INC Signed Number(8,0) DECIMAL(7) NOT NULL Assumed Sps's Earned Income
    42 ASMD_STU_WKB Signed Number(6,0) DECIMAL(5) NOT NULL Assumed WKB - Stu
    43 ASMD_STU_TAX_PAID Signed Number(8,0) DECIMAL(7) NOT NULL Assumed U. S. Tax Paid
    44 ASMD_PAR_MAR_STAT Character(1) VARCHAR2(1) NOT NULL Assumed Marital Status-Parent
    45 ASMD_PAR_NBR_INFAM Character(2) VARCHAR2(2) NOT NULL Number Of Family Members-Par
    46 ASMD_PAR_NBR_COLL Number(2,0) SMALLINT NOT NULL Assumed Number in College
    47 ASMD_PAR_AGI Signed Number(8,0) DECIMAL(7) NOT NULL Assumed AGI-Parent
    48 ASMD_DAD_ERN_INC Signed Number(8,0) DECIMAL(7) NOT NULL Assumed Father's Earned Income
    49 ASMD_MOM_ERN_INC Signed Number(8,0) DECIMAL(7) NOT NULL Assumed Mother's Earned Income
    50 ASMD_PAR_ERN_INC Signed Number(7,0) DECIMAL(6) NOT NULL Assumed Par's Earned Inc Cred
    51 ASMD_PAR_WKB Signed Number(6,0) DECIMAL(5) NOT NULL Assumed WKB - Par
    52 ASMD_PAR_TAX_PAID Number(7,0) INTEGER NOT NULL Par Tax Paid
    53 ASMD_FATHER_SSN Character(9) VARCHAR2(9) NOT NULL Assumed Father's SSN
    54 ASMD_MOTHER_SSN Character(9) VARCHAR2(9) NOT NULL Assumed Mother's SSN
    55 ASMD_STU_EIC Signed Number(6,0) DECIMAL(5) NOT NULL Earned Income Credit
    56 ASMD_CHILDREN Character(1) VARCHAR2(1) NOT NULL Children
    57 ASMD_STU_WKC Signed Number(9,0) DECIMAL(8) NOT NULL Worksheet C Total
    58 ASMD_PAR_WKC Signed Number(9,0) DECIMAL(8) NOT NULL Assumed WKC - Par
    59 REJ_OVR_BIRTH_YEAR Character(1) VARCHAR2(1) NOT NULL Date of Birth Yr is 1900-1928
    1=Yes
    60 REJ_OVR_TAX_RANGE Character(1) VARCHAR2(1) NOT NULL Taxes paid is high, but < AGI
    1=Yes
    61 REJ_OVR_TAXRNG_DEP Character(1) VARCHAR2(1) NOT NULL Taxes paid is high, but < AGI
    1=Yes
    62 SFA_REJ_OVR_TX_PAR Character(1) VARCHAR2(1) NOT NULL Reject Override 12
    1=Yes
    2=No
    63 SFA_REJ_OVR_DADSSN Character(1) VARCHAR2(1) NOT NULL Reject Override J
    1=Yes
    2=No
    64 SFA_REJ_OVR_MOMSSN Character(1) VARCHAR2(1) NOT NULL Reject Override K
    1=Yes
    2=No
    65 SFA_REJ_OVR_TX_STU Character(1) VARCHAR2(1) NOT NULL Reject Override 3
    1=Yes
    2=No
    66 SFA_REJ_OVR_MR_STU Character(1) VARCHAR2(1) NOT NULL Reject Override 4
    1=Yes
    67 SFA_REJ_OVR_NO_TAX Character(1) VARCHAR2(1) NOT NULL Reject Override 20
    1=Yes
    68 SFA_ASM_YTH_SCH_VL Character(1) VARCHAR2(1) NOT NULL Unaccompanied Youth (School)
    69 SFA_ASM_YTH_HUD_VL Character(1) VARCHAR2(1) NOT NULL Unaccompanied Youth (HUD)
    70 SFA_ASM_RSK_HOM_VL Character(1) VARCHAR2(1) NOT NULL Risk of Homelessness
    71 SFA_REJ_OVR_MAR_ST Character(1) VARCHAR2(1) NOT NULL Reject Override 21
    1=Yes
    72 SFA_STU_ASM_AST_VL Character(1) VARCHAR2(1) NOT NULL Asset Threshold Exceeded
    Y=Yes
    73 SFA_PAR_ASM_AST_VL Character(1) VARCHAR2(1) NOT NULL Asset Threshold Exceeded
    Y=Yes