SFA_EA_LOAD_DTL

(SQL Table)
 Index Back

EA Load - Detail Record

External Award Load detail record.

  • Parent record: SFA_EA_LOAD_HDR

    • # 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 SFA_EA_TYPE Character(3) VARCHAR2(3) NOT NULL External Award type (customer defined).

    Prompt Table: SFA_EA_TYPE

    7 SFA_EA_SOURCE Character(3) VARCHAR2(3) NOT NULL External Award source (customer defined).

    Prompt Table: SFA_EA_SOURCE

    8 SFA_EA_PROGRAM_CD Character(3) VARCHAR2(3) NOT NULL External Award program code (customer defined).

    Prompt Table: SFA_EA_PROGRAM

    9 SFA_EA_TRANS_SRCE Character(2) VARCHAR2(2) NOT NULL External Award data source (file, self service, manual entry, loans, SF)
    01=Manual Entry
    02=External File
    03=Loan Certification File
    04=Student Financials
    05=Self Service
    10 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: SFA_EA_STU_SRCH

    11 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
    12 BIRTHDATE Date(10) DATE Date of Birth
    13 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
    14 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
    15 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL MIDDLE_NAME
    16 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

    Prompt Table: STDNT_CAREER_V2

    17 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
    18 SFA_EA_PROC_DTTM DateTime(26) TIMESTAMP External award load process date/time stamp.
    19 SFA_EA_LOAN_CERT Character(1) VARCHAR2(1) NOT NULL External Award Loan Certification flag (Y/N).

    Y/N Table Edit

    20 SFA_EA_REPORT_CD Character(1) VARCHAR2(1) NOT NULL External Award reporting code.
    A=Add to existing
    N=New
    R=Replace existing
    21 ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Item Type

    Prompt Table: %EDITTABLE5

    22 REL_ITEM_TYPE Character(8) VARCHAR2(8) NOT NULL Related Item Group
    23 DISBURSEMENT_PLAN Character(2) VARCHAR2(2) NOT NULL Disbursement Plan

    Prompt Table: DISB_PLAN_TBL

    24 SPLIT_CODE Character(2) VARCHAR2(2) NOT NULL Split Code

    Prompt Table: DISB_SPLIT_VW

    25 NET_OFFER_AMT Number(12,2) DECIMAL(11,2) NOT NULL Net Offer Amount
    26 NET_AWARD_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL Net Award Amount
    27 OFFER_AMOUNT Number(12,2) DECIMAL(11,2) NOT NULL Offer Amount
    28 ACCEPT_AMOUNT Number(12,2) DECIMAL(11,2) NOT NULL Accept Amount
    29 AUTHORIZED_AMOUNT Number(12,2) DECIMAL(11,2) NOT NULL Authorized Amount
    30 DISBURSED_AMOUNT Number(12,2) DECIMAL(11,2) NOT NULL Disbursed Amount
    31 SFA_EA_PAY_STATUS Character(1) VARCHAR2(1) NOT NULL External award paid out (Y/N).

    Y/N Table Edit

    32 SFA_EA_SUSPEND_RSN Character(1) VARCHAR2(1) NOT NULL External Award Load suspend reason.
    M=Multiple matches for student
    N=Student not found
    33 SFA_EA_LOAD_ERROR Number(5,0) INTEGER NOT NULL External award load error code.
    34 AWARD_ACTION Character(1) VARCHAR2(1) NOT NULL Action Code
    A=Accept
    B=Offer/Accept
    C=Cancel
    D=Decline
    O=Offer
    X=Discard
    35 AWARD_STATUS Character(1) VARCHAR2(1) NOT NULL Award Status
    A=Accepted
    C=Cancelled
    D=Declined
    O=Offered
    36 AWARD_PERIOD Character(1) VARCHAR2(1) NOT NULL Award Period
    A=Academic
    N=Non Standard
    37 AUTO_CANCEL_TYPE Character(12) VARCHAR2(12) NOT NULL Auto Cancel Item Type
    38 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    39 CHARGE_PRIORITY Character(8) VARCHAR2(8) NOT NULL Charge Priority List
    40 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
    41 AWARD_MSG_CD Character(4) VARCHAR2(4) NOT NULL Award Message