SFA_EASTGDSBVW2

(SQL View)
 Index Back

EA Staging - Disbursement View

Financial Aid External Award disbursment data by EMLID.

SELECT A.EMPLID ,A.INSTITUTION ,A.AID_YEAR ,A.SFA_EA_TRANS_NBR ,A.SFA_EA_SEQNO ,B.SFA_EA_DISB_SEQNO ,B.STRM ,B.DISBURSEMENT_ID ,B.SCHEDULED_AWARD ,B.DISBURSED_AMOUNT ,B.SFA_EA_PAY_STATUS FROM PS_SFA_EASTAGE_DTL A , PS_SFA_EASTAGE_DSB B WHERE A.SFA_EA_TRANS_NBR = B.SFA_EA_TRANS_NBR AND A.SFA_EA_SEQNO = B.SFA_EA_SEQNO

  • Parent record: SFA_EASTAGE_DTL

    • # 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 SFA_EA_TRANS_NBR Number(15,0) DECIMAL(15) NOT NULL Transaction number used for staging external awards to the database.
    5 SFA_EA_SEQNO Number(5,0) INTEGER NOT NULL Unique sequence for EA transactions.
    6 SFA_EA_DISB_SEQNO Number(2,0) SMALLINT NOT NULL External award disbursement sequence.
    7 STRM Character(4) VARCHAR2(4) NOT NULL Term

    Prompt Table: TERM_TBL

    8 DISBURSEMENT_ID Character(2) VARCHAR2(2) NOT NULL Disbursement ID
    9 SCHEDULED_AWARD Number(12,2) DECIMAL(11,2) NOT NULL Scheduled Award
    10 DISBURSED_AMOUNT Number(12,2) DECIMAL(11,2) NOT NULL Disbursed Amount
    11 SFA_EA_PAY_STATUS Character(1) VARCHAR2(1) NOT NULL External award paid out (Y/N).

    Y/N Table Edit