INAS_SIM_INT

(SQL Table)
 Index Back

Asumd, Rejctd, Comntd Data

This table contains those data elements necessary to support professional judgement overrides during the FM Simulation process.

  • 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 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
    56 REJ_OVR_BIRTH_YEAR Character(1) VARCHAR2(1) NOT NULL Date of Birth Yr is 1900-1928
    1=Yes
    57 REJ_OVR_TAX_RANGE Character(1) VARCHAR2(1) NOT NULL Taxes paid is high, but < AGI
    1=Yes
    58 DEPNDNCY_OVERRIDE Character(1) VARCHAR2(1) NOT NULL Dependency Override Indicator
    1=Dependent To Independent
    2=Cancel Dep Override-Corr Only
    3=Override Failed
    4=Homeless Youth Determination
    59 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
    60 EFC_OVRD_DSPLAY_FM Character(1) VARCHAR2(1) NOT NULL Flag that triggers the display of EFC Override labels.
    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 CORR_DOB Character(1) VARCHAR2(1) NOT NULL Correct Date of Birth Flag
    67 CORR_CIT_STATUS Character(1) VARCHAR2(1) NOT NULL Correct Citzenship Status Flag
    68 SFA_REJ_OVR_MR_STU Character(1) VARCHAR2(1) NOT NULL Reject Override 4
    1=Yes
    69 SFA_REJ_OVR_NO_TAX Character(1) VARCHAR2(1) NOT NULL Reject Override 20
    1=Yes
    70 SFA_ASM_YTH_SCH_VL Character(1) VARCHAR2(1) NOT NULL Unaccompanied Youth (School)
    71 SFA_ASM_YTH_HUD_VL Character(1) VARCHAR2(1) NOT NULL Unaccompanied Youth (HUD)
    72 SFA_ASM_RSK_HOM_VL Character(1) VARCHAR2(1) NOT NULL Risk of Homelessness
    73 SFA_REJ_OVR_MAR_ST Character(1) VARCHAR2(1) NOT NULL Reject Override 21
    1=Yes
    74 SFA_STU_ASM_AST_VL Character(1) VARCHAR2(1) NOT NULL Asset Threshold Exceeded
    Y=Yes
    75 SFA_PAR_ASM_AST_VL Character(1) VARCHAR2(1) NOT NULL Asset Threshold Exceeded
    Y=Yes