FAN_AWRDACTV_VW

(SQL View)
 Index Back

Student Award Activity View

Student Award Activity Audit View, showing only the most recent activity. This is a view of this table used for Fin Aid Award Notification Letter equation selection processing.

SELECT A.EMPLID ,A.INSTITUTION ,A.AID_YEAR ,A.ITEM_TYPE ,A.ACAD_CAREER ,A.ACTION_DTTM ,A.DISBURSEMENT_PLAN ,A.SPLIT_CODE ,A.DISBURSEMENT_ID ,A.OPRID ,A.AWARD_DISB_ACTION ,A.OFFER_AMOUNT ,A.ACCEPT_AMOUNT ,A.AUTHORIZED_AMOUNT ,A.DISB_AMOUNT ,A.CURRENCY_CD ,A.BUSINESS_UNIT ,A.ADJUST_REASON_CD ,A.ADJUST_AMOUNT ,A.LOAN_ADJUST_CD ,A.DISB_TO_DATE ,A.AUTH_TO_DATE ,A.PKG_APP_DATA_USED FROM PS_STDNT_AWRD_ACTV A WHERE A.ACTION_DTTM = ( SELECT MAX(B.ACTION_DTTM) FROM PS_STDNT_AWRD_ACTV B WHERE B.EMPLID = A.EMPLID AND B.INSTITUTION = A.INSTITUTION AND B.AID_YEAR = A.AID_YEAR AND B.ITEM_TYPE = A.ITEM_TYPE AND B.ACAD_CAREER = A.ACAD_CAREER )

  • Parent record: STDNT_AWARDS

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSONAL_DATA

    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: AID_YEAR_TBL

    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 ACTION_DTTM DateTime(26) TIMESTAMP Override Date Time
    7 DISBURSEMENT_PLAN Character(2) VARCHAR2(2) NOT NULL Disbursement Plan
    8 SPLIT_CODE Character(2) VARCHAR2(2) NOT NULL Split Code
    9 DISBURSEMENT_ID Character(2) VARCHAR2(2) NOT NULL Disbursement ID
    10 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    11 AWARD_DISB_ACTION Character(1) VARCHAR2(1) NOT NULL Disb ID Action
    A=Accepted
    B=Offer/Accepted
    C=Cancelled
    D=Declined
    H=Authorized
    O=Offered
    P=Disbursed
    R=Authorization Override
    12 OFFER_AMOUNT Number(12,2) DECIMAL(11,2) NOT NULL Offer Amount
    13 ACCEPT_AMOUNT Number(12,2) DECIMAL(11,2) NOT NULL Accept Amount
    14 AUTHORIZED_AMOUNT Number(12,2) DECIMAL(11,2) NOT NULL Authorized Amount
    15 DISB_AMOUNT Signed Number(13,2) DECIMAL(11,2) NOT NULL Disbursed Amount
    16 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    17 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    18 ADJUST_REASON_CD Character(3) VARCHAR2(3) NOT NULL Adjustment Reason

    Prompt Table: AWD_ADJ_RSN_TBL

    19 ADJUST_AMOUNT Signed Number(13,2) DECIMAL(11,2) NOT NULL Adjust Amount
    20 LOAN_ADJUST_CD Character(1) VARCHAR2(1) NOT NULL Loan Adjust Reason
    C=Change
    O=OverAward
    R=Re-Issue
    W=Withdrawal
    X=Cancellation
    21 DISB_TO_DATE Number(12,2) DECIMAL(11,2) NOT NULL Disbursed Total
    22 AUTH_TO_DATE Number(12,2) DECIMAL(11,2) NOT NULL Authorized Total
    23 PKG_APP_DATA_USED Character(1) VARCHAR2(1) NOT NULL Application Data Used
    F=ISIR
    I=Institutional Application
    N=Need Access
    N=Need Access
    P=Profile
    X=Exclusive of App Data