SFA_SS_OA_AWDVW

(SQL View)
 Index Back

Outside Aid Awards View

View of student's reportes Outside Aid Awards; used in Fluid self service.

SELECT A.EMPLID , A.INSTITUTION , A.AID_YEAR , A.ITEM_TYPE , A.ACAD_CAREER , A.OFFER_AMOUNT , A.ACCEPT_AMOUNT , B.SFA_EA_TRANS_NBR , B.SFA_EA_SEQNO , B.DESCR , B.FIN_AID_TYPE , C.TRANSACTION_DATE , B.NET_AWARD_AMT , B.SFA_EA_PROC_STAT , B.SFA_EA_PROC_DTTM , B.SFA_EA_SS_VISIBLE , B.DESCRLONG FROM PS_STDNT_AWARDS A , PS_SFA_EASTAGE_DTL B , PS_SFA_EASTAGE_HDR C WHERE A.EMPLID = B.EMPLID AND A.INSTITUTION = B.INSTITUTION AND A.AID_YEAR = B.AID_YEAR AND A.ITEM_TYPE = B.ITEM_TYPE AND A.ACAD_CAREER = B.ACAD_CAREER AND A.SFA_EA_INDICATOR = 'Y' AND B.SFA_EA_TRANS_NBR = ( SELECT MAX(B2.SFA_EA_TRANS_NBR) FROM PS_SFA_EASTAGE_DTL B2 WHERE B2.EMPLID = A.EMPLID AND B2.INSTITUTION = A.INSTITUTION AND B2.AID_YEAR = A.AID_YEAR AND B2.ITEM_TYPE = A.ITEM_TYPE AND B2.ACAD_CAREER = A.ACAD_CAREER AND B2.SFA_EA_PROC_STAT IN ('A', 'P')) AND B.SFA_EA_SEQNO = ( SELECT MAX(B3.SFA_EA_SEQNO) FROM PS_SFA_EASTAGE_DTL B3 WHERE B3.EMPLID = A.EMPLID AND B3.INSTITUTION = A.INSTITUTION AND B3.AID_YEAR = A.AID_YEAR AND B3.ITEM_TYPE = A.ITEM_TYPE AND B3.ACAD_CAREER = A.ACAD_CAREER AND B3.SFA_EA_PROC_STAT IN ('A','P') AND B3.SFA_EA_PROC_DTTM = ( SELECT MAX(B1.SFA_EA_PROC_DTTM) FROM PS_SFA_EASTAGE_DTL B1 WHERE B1.EMPLID = A.EMPLID AND B1.INSTITUTION = A.INSTITUTION AND B1.AID_YEAR = A.AID_YEAR AND B1.ITEM_TYPE = A.ITEM_TYPE AND B1.ACAD_CAREER = A.ACAD_CAREER AND B1.SFA_EA_PROC_STAT IN ('A','P'))) AND B.SFA_EA_TRANS_NBR = C.SFA_EA_TRANS_NBR

  • Related Language Record: SFA_EASTAGE_LN2

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
    3 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year
    4 ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Item Type
    5 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
    6 OFFER_AMOUNT Number(12,2) DECIMAL(11,2) NOT NULL Offer Amount
    7 ACCEPT_AMOUNT Number(12,2) DECIMAL(11,2) NOT NULL Accept Amount
    8 SFA_EA_TRANS_NBR Number(15,0) DECIMAL(15) NOT NULL Transaction number used for staging external awards to the database.
    9 SFA_EA_SEQNO Number(5,0) INTEGER NOT NULL Unique sequence for EA transactions.
    10 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    11 FIN_AID_TYPE Character(4) VARCHAR2(4) NOT NULL Fin Aid Type
    A=Athletic
    B=Bursary
    F=Fellowship
    G=Grant
    L=Loan
    S=Scholarship
    V=Waiver
    W=Work/Study
    12 TRANSACTION_DATE Date(10) DATE TRANSACTION_DATE
    13 NET_AWARD_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL Net Award Amount
    14 SFA_EA_PROC_STAT Character(1) VARCHAR2(1) NOT NULL External award processing status.
    A=Adjusted
    D=Duplicate
    E=Error
    I=In Process Abend
    K=Skip
    P=Processed
    R=Reported
    S=Suspend
    U=Unprocessed
    15 SFA_EA_PROC_DTTM DateTime(26) TIMESTAMP External award load process date/time stamp.
    16 SFA_EA_SS_VISIBLE Character(1) VARCHAR2(1) NOT NULL External Award - set admin comments visible/not visible on student self service component (Y/N).
    17 DESCRLONG Long Character CLOB Long Description