FAN_AIDATRBT_VW

(SQL View)
 Index Back

Student Aid Attributes View

This is a view of the STDNT_AID_ATRBT table used for Financial Aid Award Notification Letter equation selection processing.

SELECT EMPLID , INSTITUTION , AID_YEAR , PROCESSING_STATUS , VERIFICATON_STATUS , SFA_REVIEW_STATUS , SCHOLARSHIP_STATUS , PACKAGING_METHOD , PKG_PLAN_ID , SAT_ACADEMIC_PRG , DISBURSEMENT_HOLD , COUNSELOR , COMMUNITY_SERVICE , QA_VERF_SELECT , QA_SELECTED , AID_APP_STATUS , VERIF_STATUS_CODE , PELL_PROCESS_FIELD , ED_RECORD_STATUS , ED_LEVEL_SAT , PELL_EFFDT , PELL_EFFSEQ , PELL_TRANS_NBR , USE_SECONDARY_EFC , ACAD_CAREER , PAR_CREDIT_WORTHY , TITLEIV_ELIG , SS_MATCH , SS_REGISTRATION , INS_MATCH , SSN_MATCH , VA_MATCH , NSLDS_LOAN_DEFAULT , SSA_CITIZENSHP_IND , NSLDS_MATCH , DL_HEAL_LN_SW , DRUG_OFFENSE_CONV , PRISONER_MATCH , LN_INTERVW_STATUS , LN_EXIT_INTER_STAT , SSN_MATCH_OVRD , SSA_CITIZEN_OVRD , INS_MATCH_OVRD , VA_MATCH_OVRD , SS_MATCH_OVRD , SS_REGISTER_OVRD , NSLDS_OVRD , PRISONER_OVRD , DRUG_OFFENSE_OVRD , ISIR_SEC_INS_MATCH , PKG_LASTUPDDTTM , FA_SS_AWD_SECURITY , FA_SS_INQ_SECURITY , FA_SS_FAN_SECURITY , FATHER_SSN_MATCH , MOTHER_SSN_MATCH , PAR_SSN_MATCH_OVRD , SFA_AGGR_SOURCE , SFA_AGGR_SRC_USED , SFA_PKG_DEP_STAT FROM PS_STDNT_AID_ATRBT WHERE 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 PROCESSING_STATUS Character(1) VARCHAR2(1) NOT NULL Aid Package Processing Status
    0=No Electronic Application
    1=Applied
    2=Ready For Counselor Review
    3=Ready for Packaging
    4=Repackage
    9=Packaging Completed
    5 VERIFICATON_STATUS Character(1) VARCHAR2(1) NOT NULL ED Verification Status
    C=ED Verification Complete
    N=Not Required
    P=Verification Pending
    R=Required to be Performed
    6 SFA_REVIEW_STATUS Character(1) VARCHAR2(1) NOT NULL Review Status
    C=Review Complete
    I=Incomplete
    7 SCHOLARSHIP_STATUS Character(1) VARCHAR2(1) NOT NULL Scholarship Status
    E=Evaluated
    N=Not Evaluated
    8 PACKAGING_METHOD Character(1) VARCHAR2(1) NOT NULL Aid Packaging Method
    0=Not Packaged
    5=Auto Packaged
    9=Counselor Packaged
    9 PKG_PLAN_ID Character(10) VARCHAR2(10) NOT NULL Packaging Plan ID

    Prompt Table: PKG_PLAN_TBL

    10 SAT_ACADEMIC_PRG Character(1) VARCHAR2(1) NOT NULL Used on Packaging Status Summary to note current Satisfactory Academic Progress status.
    A=Academic Plan
    N=Not Meeting Satis Acad Prgrs
    P=Probation
    U=SAP Undetermined
    W=Warning
    Y=Meeting Satis Acad Progress
    11 DISBURSEMENT_HOLD Character(1) VARCHAR2(1) NOT NULL Disbursement Hold
    F=Hold Federal Aid
    I=Hold Institutional Aid
    L=Hold All Loans
    12 COUNSELOR Character(11) VARCHAR2(11) NOT NULL Counselor

    Prompt Table: PEOPLE_SRCH

    13 COMMUNITY_SERVICE Character(1) VARCHAR2(1) NOT NULL Community Service Indicator
    1=Community Service Placement
    2=Not Community Service
    14 QA_VERF_SELECT Character(1) VARCHAR2(1) NOT NULL Inst Verification Status
    1=Non Select
    2=Selected for Verification
    3=Document Select
    15 QA_SELECTED Character(1) VARCHAR2(1) NOT NULL QA Sample
    1=Not Selected as QA Sample
    2=Selected as QA Sample
    16 AID_APP_STATUS Character(1) VARCHAR2(1) NOT NULL Aid Application Status
    A=Application Active for All Aid
    C=Application Canceled
    R=Apply for Restricted Aid Only
    17 VERIF_STATUS_CODE Character(1) VARCHAR2(1) NOT NULL ED Verification Status Cd
    A=Accurate Data
    B=Blank
    C=Calculated
    N=Not Selected
    R=Reprocessed
    S=Selected, Not Verified
    T=Tolerance
    V=Verified
    W=Without Documentation
    18 PELL_PROCESS_FIELD Character(1) VARCHAR2(1) NOT NULL Pell Processing Status
    A=Accepted By ED
    G=Repackaged
    L=Selected
    N=Not Sent
    P=Pending
    R=Reported to ED
    S=Ready to Send
    V=Review
    19 ED_RECORD_STATUS Character(1) VARCHAR2(1) NOT NULL ED Record Status
    A=Accepted w/ Assumptions
    D=Duplicate
    E=Error
    I=Accepted
    R=Rejected
    20 ED_LEVEL_SAT Character(1) VARCHAR2(1) NOT NULL SAT Education Level
    21 PELL_EFFDT Date(10) DATE Effective Date

    Prompt Table: PELL_INFO_VW3

    22 PELL_EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence

    Prompt Table: PELL_INFO_VW4

    23 PELL_TRANS_NBR Number(2,0) SMALLINT NOT NULL Transaction Num

    Prompt Table: PELL_INFO_VW2

    24 USE_SECONDARY_EFC Character(1) VARCHAR2(1) NOT NULL Use Secondary EFC

    Y/N Table Edit

    25 ACAD_CAREER Character(4) VARCHAR2(4) NOT NULL Academic Career
    BAC=Bachelor (NLD)
    BBL=Vocational Coaching (NLD)
    BOL=Vocational Training (NLD)
    BUSN=Graduate Business
    CNED=Continuing Education
    CRED=Semester Credit
    EDU=Education (NLD)
    EXED=Extended Education
    GRAD=Graduate
    LAW=Law
    MEDS=Medical School
    NONA=Non Award
    PGRD=Postgraduate
    RSCH=Research
    TECH=Technical
    UENG=Undergraduate Engineering
    UGRD=Undergraduate
    VAVO=Advanced General Educ. (NLD)
    VETM=Veterinary Medicine

    Prompt Table: AID_YEAR_CAREER

    26 PAR_CREDIT_WORTHY Character(1) VARCHAR2(1) NOT NULL Parent Credit Worthiness
    I=Institutional Override

    Y/N Table Edit

    27 TITLEIV_ELIG Character(1) VARCHAR2(1) NOT NULL Title IV Fund Eligibility
    I=Institutional Override

    Y/N Table Edit

    28 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
    29 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
    30 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
    31 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
    32 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
    33 NSLDS_LOAN_DEFAULT Character(1) VARCHAR2(1) NOT NULL NSLDS Loan Default
    34 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
    35 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
    36 DL_HEAL_LN_SW Character(1) VARCHAR2(1) NOT NULL HEAL Eligible

    Y/N Table Edit

    37 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
    38 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
    39 LN_INTERVW_STATUS Character(1) VARCHAR2(1) NOT NULL Loan Entrance Interview Status
    C=Complete
    I=Institution Required
    P=Pending Resolution
    40 LN_EXIT_INTER_STAT Character(1) VARCHAR2(1) NOT NULL Loan Exit Interview Status
    C=Complete
    I=Insitution Required
    P=Pending Resolution
    41 SSN_MATCH_OVRD Character(1) VARCHAR2(1) NOT NULL SSN Match Override

    Y/N Table Edit

    42 SSA_CITIZEN_OVRD Character(1) VARCHAR2(1) NOT NULL SSA Citizen Override

    Y/N Table Edit

    43 INS_MATCH_OVRD Character(1) VARCHAR2(1) NOT NULL INS Match Override

    Y/N Table Edit

    44 VA_MATCH_OVRD Character(1) VARCHAR2(1) NOT NULL VA Match Override

    Y/N Table Edit

    45 SS_MATCH_OVRD Character(1) VARCHAR2(1) NOT NULL SS Match Override

    Y/N Table Edit

    46 SS_REGISTER_OVRD Character(1) VARCHAR2(1) NOT NULL SS Register Override

    Y/N Table Edit

    47 NSLDS_OVRD Character(1) VARCHAR2(1) NOT NULL NSLDS Override

    Y/N Table Edit

    48 PRISONER_OVRD Character(1) VARCHAR2(1) NOT NULL Prisoner Override

    Y/N Table Edit

    49 DRUG_OFFENSE_OVRD Character(1) VARCHAR2(1) NOT NULL Drug Offense Override

    Y/N Table Edit

    50 ISIR_SEC_INS_MATCH Character(1) VARCHAR2(1) NOT NULL Sec INS Match Flag
    C=Not yet confirmed by INS
    N=Citizenship Not Confirmed
    P=Pending Confirmation
    X=Not enough info to confirm
    Y=Citizenship Confirmed
    51 PKG_LASTUPDDTTM DateTime(26) TIMESTAMP Last Updated
    52 FA_SS_AWD_SECURITY Character(1) VARCHAR2(1) NOT NULL Self Service Awarding Access
    A=Allow Access
    F=Use Filter Options
    N=Deny Access
    53 FA_SS_INQ_SECURITY Character(1) VARCHAR2(1) NOT NULL Self-Service Inquiry Access
    N=Deny Access
    Y=Allow Access

    Y/N Table Edit

    54 FA_SS_FAN_SECURITY Character(1) VARCHAR2(1) NOT NULL Self-Serv On-line FAN Access
    N=Deny Access
    Y=Allow Access

    Y/N Table Edit

    55 FATHER_SSN_MATCH Character(1) VARCHAR2(1) NOT NULL Father's SSN Match
    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
    I=Institutional Override
    56 MOTHER_SSN_MATCH Character(1) VARCHAR2(1) NOT NULL Mother's SSN Match
    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
    I=Institutional Override
    57 PAR_SSN_MATCH_OVRD Character(1) VARCHAR2(1) NOT NULL Parents SSN Match Override

    Y/N Table Edit

    Default Value: N

    58 SFA_AGGR_SOURCE Character(1) VARCHAR2(1) NOT NULL FA-Aggregate Source for Packaging
    D=FA Installation Default
    N=NSLDS Total
    P=PS Aggregates

    Default Value: D

    59 SFA_AGGR_SRC_USED Character(1) VARCHAR2(1) NOT NULL FA-Aggregate Source Used by Packaging
    N=NSLDS Total
    P=PS Aggregates
    60 SFA_PKG_DEP_STAT Character(1) VARCHAR2(1) NOT NULL FA-Aggregates: Dependency Status used during Award Packaging
    D=Dependent
    I=Independent
    M=Married
    S=Sole Support