ISIR_NEED_VW2

(SQL View)
 Index Back

Need Summary View

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

SELECT A.EMPLID, A.INSTITUTION, A.AID_YEAR, D.AWARD_PERIOD, A.EFFDT,A.EFFSEQ, A.TABLE_ID, B.AGI, C.DEPNDNCY_STAT, A.DEP_STU_A_CONTRIB, A.DEP_STU_I_CONTRIB, A.TOTAL_STU_CONTRIB, A.ALWNC_AGAINST_TI, A.AVAILABLE_INCOME, A.ADJ_PAR_CONTRIB, A.PRIMARY_EFC, A.TOTAL_INCOME, A.VALID_EFC_CALC, D.FED_YEAR_COA, D.INST_YEAR_COA, D.FED_NEED, D.INST_NEED, D.FED_EFC, D.INST_EFC, D.INST_NEED_BASE_AID, D.FED_NEED_BASE_AID, D.FED_UNMET_NEED, D.INST_UNMET_NEED, D.FED_OVRAWD_AMT, D.INST_OVRAWD_AMT, A.PRORATED_EFC, D.FED_SPECIAL_AID, D.INST_SPECIAL_AID, D.FED_TOTAL_AID, D.INST_TOTAL_AID FROM PS_ISIR_COMPUTED A, PS_ISIR_PARENT B, PS_ISIR_STUDENT C, PS_STDNT_AWD_PER D WHERE A.EMPLID = B.EMPLID AND A.EMPLID = C.EMPLID AND A.EMPLID = D.EMPLID AND A.INSTITUTION = B.INSTITUTION AND A.INSTITUTION = C.INSTITUTION AND A.INSTITUTION = D.INSTITUTION AND A.AID_YEAR = B.AID_YEAR AND A.AID_YEAR = C.AID_YEAR AND A.AID_YEAR = D.AID_YEAR AND A.EFFDT=B.EFFDT AND A.EFFDT=C.EFFDT AND A.EFFSEQ=B.EFFSEQ AND A.EFFSEQ=C.EFFSEQ

  • 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: 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 AWARD_PERIOD Character(1) VARCHAR2(1) NOT NULL Award Period
    A=Academic
    N=Non Standard
    5 EFFDT Date(10) DATE Effective Date

    Default Value: %date

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

    Default Value: 1

    8 AGI Signed Number(11,0) DECIMAL(10) NOT NULL Adjusted Gross Income
    9 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
    10 DEP_STU_A_CONTRIB Signed Number(8,0) DECIMAL(7) NOT NULL Student Asset Contribution
    11 DEP_STU_I_CONTRIB Signed Number(8,0) DECIMAL(7) NOT NULL Student Income Contribution
    12 TOTAL_STU_CONTRIB Signed Number(8,0) DECIMAL(7) NOT NULL Total Student Contribution
    13 ALWNC_AGAINST_TI Signed Number(8,0) DECIMAL(7) NOT NULL Total Allowances
    14 AVAILABLE_INCOME Signed Number(9,0) DECIMAL(8) NOT NULL Available Income
    15 ADJ_PAR_CONTRIB Signed Number(8,0) DECIMAL(7) NOT NULL Parent Contribution
    16 PRIMARY_EFC Signed Number(7,0) DECIMAL(6) NOT NULL Primary EFC
    17 TOTAL_INCOME Signed Number(16,0) DECIMAL(15) NOT NULL Total Income
    18 VALID_EFC_CALC Character(1) VARCHAR2(1) NOT NULL Valid EFC Calc
    19 FED_YEAR_COA Number(9,2) DECIMAL(8,2) NOT NULL Fed Year COA
    20 INST_YEAR_COA Number(9,2) DECIMAL(8,2) NOT NULL Inst Year COA
    21 FED_NEED Number(9,2) DECIMAL(8,2) NOT NULL Fed Need
    22 INST_NEED Number(9,2) DECIMAL(8,2) NOT NULL Inst Need
    23 FED_EFC Signed Number(7,0) DECIMAL(6) NOT NULL Federal EFC
    24 INST_EFC Number(6,0) INTEGER NOT NULL Institutional EFC
    25 INST_NEED_BASE_AID Number(9,2) DECIMAL(8,2) NOT NULL N/B Aid (Inst)
    26 FED_NEED_BASE_AID Number(9,2) DECIMAL(8,2) NOT NULL N/B Aid (Fed)
    27 FED_UNMET_NEED Number(9,2) DECIMAL(8,2) NOT NULL Unmet Need (Fed)
    28 INST_UNMET_NEED Number(9,2) DECIMAL(8,2) NOT NULL Unmet Need (Inst)
    29 FED_OVRAWD_AMT Number(9,2) DECIMAL(8,2) NOT NULL Overaward (Fed)
    30 INST_OVRAWD_AMT Number(9,2) DECIMAL(8,2) NOT NULL Overaward (Inst)
    31 PRORATED_EFC Signed Number(7,0) DECIMAL(6) NOT NULL Prorated EFC
    32 FED_SPECIAL_AID Number(9,2) DECIMAL(8,2) NOT NULL Special Need/Cost Aid (Fed)
    33 INST_SPECIAL_AID Number(9,2) DECIMAL(8,2) NOT NULL Special Need/Cost Aid (Inst)
    34 FED_TOTAL_AID Number(9,2) DECIMAL(8,2) NOT NULL Total Aid (Fed)
    35 INST_TOTAL_AID Number(9,2) DECIMAL(8,2) NOT NULL Total Aid (Inst)