STDNT_AID_ATVW

(SQL View)
 Index Back

Student Aid Attributes Table

STU_AID_ATTRIB is the child table to the Financial Aid table STUDENT_AID. A student applying for aid would have a new record each year, and this table contains the attributes, and high level information relating to the application, awarding and processing of financial aid for the year.

SELECT INSTITUTION, AID_YEAR, EMPLID, VERIFICATON_STATUS, VERIF_STATUS_CODE FROM PS_STDNT_AID_ATRBT

  • Parent record: STUDENT_AID

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: FA_INSTITUTN_VW.INSTITUTION

    Prompt Table: INSTITUTION_TBL

    2 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year

    Default Value: OPR_DEF_TBL_CS.AID_YEAR

    Prompt Table: STUDENT_AID

    3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PEOPLE_SRCH

    4 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

    Default Value: N

    5 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

    Default Value: N