SFA_EA_LOAD_DSB

(SQL Table)
Index Back

EA Load - Disbursement Record

External Award Load disburseemnt detail record.

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

    Default Value: OPR_DEF_TBL_CS.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: AID_YEAR_TBL

    3 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    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 DISBURSEMENT_ID Character(2) VARCHAR2(2) NOT NULL Disbursement ID
    7 SFA_EA_DISB_SEQNO Number(2,0) SMALLINT NOT NULL External award disbursement sequence.
    8 SCHEDULED_AWARD Number(12,2) DECIMAL(11,2) NOT NULL Scheduled Award
    9 OFFER_BALANCE Number(12,2) DECIMAL(11,2) NOT NULL Offer Balance
    10 ACCEPT_BALANCE Number(12,2) DECIMAL(11,2) NOT NULL Accept Balance
    11 AUTHORIZED_BALANCE Number(12,2) DECIMAL(11,2) NOT NULL Authorized Balance
    12 DISBURSED_BALANCE Signed Number(13,2) DECIMAL(11,2) NOT NULL Disbursed Balance
    13 NET_DISB_BALANCE Number(12,2) DECIMAL(11,2) NOT NULL Net Disb Balance
    14 SFA_AGGR_BALANCE Number(12,2) DECIMAL(11,2) NOT NULL FA-Aggregates: Aggregate Balance
    15 DISBURSED_AMOUNT Number(12,2) DECIMAL(11,2) NOT NULL Disbursed Amount
    16 SFA_EA_PAY_STATUS Character(1) VARCHAR2(1) NOT NULL External award paid out (Y/N).

    Y/N Table Edit

    17 STRM Character(4) VARCHAR2(4) NOT NULL Term
    18 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    19 AGGREGATE_AREA Character(10) VARCHAR2(10) NOT NULL Aggregate Area
    20 AGGREGATE_LEVEL Character(2) VARCHAR2(2) NOT NULL Aggregate Level
    21 CPS_SCHOOL_CODE Character(6) VARCHAR2(6) NOT NULL CPS School Code. Also known as Title IV School Code