SFA_EASTAGE_VW1

(SQL View)
 Index Back

EA Staging - Detail Record

External Award Staging detail record.

SELECT INSTITUTION ,AID_YEAR ,SFA_EA_TYPE ,SFA_EA_SOURCE ,SFA_EA_TRANS_NBR ,SFA_EA_SEQNO ,NATIONAL_ID ,BIRTHDATE ,LAST_NAME ,FIRST_NAME ,MIDDLE_NAME ,EMPLID ,ACAD_CAREER ,SFA_EA_PROC_STAT ,SFA_EA_PROC_DTTM ,SFA_EA_PROGRAM_CD ,SFA_EA_LOAN_CERT ,SFA_EA_REPORT_CD ,ITEM_TYPE ,REL_ITEM_TYPE ,DESCR ,DISBURSEMENT_PLAN ,SPLIT_CODE ,NET_AWARD_AMT ,DISBURSED_AMOUNT ,SFA_EA_PAY_STATUS ,SFA_EA_ADJ_REASON ,SFA_EA_INELIGIBLE ,SFA_EA_SUSPEND_RSN ,SFA_EA_LOAD_ERROR ,SFA_EA_SS_VISIBLE ,FIN_AID_TYPE ,SFA_EA_AWRD_ACTION ,DESCRLONG FROM PS_SFA_EASTAGE_DTL

  • Parent record: SFA_EASTAGE_HDR

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

    Default Value: SFA_RUN_EASTAGE.INSTITUTION

    Prompt Table: INSTITUTION_TBL

    2 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year

    Default Value: SFA_RUN_EASTAGE.AID_YEAR

    Prompt Table: AID_YEAR_TBL

    3 SFA_EA_TYPE Character(3) VARCHAR2(3) NOT NULL External Award type (customer defined).

    Prompt Table: SFA_EA_TYPE

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

    Prompt Table: SFA_EA_SOURCE

    5 SFA_EA_TRANS_NBR Number(15,0) DECIMAL(15) NOT NULL Transaction number used for staging external awards to the database.
    6 SFA_EA_SEQNO Number(5,0) INTEGER NOT NULL Unique sequence for EA transactions.
    7 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
    8 BIRTHDATE Date(10) DATE Date of Birth
    9 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
    10 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
    11 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL MIDDLE_NAME
    12 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: SFA_EA_STU_SRCH

    13 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: SFA_EA_TRMCARVW

    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_PROGRAM_CD Character(3) VARCHAR2(3) NOT NULL External Award program code (customer defined).

    Prompt Table: SFA_EA_PROGRAM

    17 SFA_EA_LOAN_CERT Character(1) VARCHAR2(1) NOT NULL External Award Loan Certification flag (Y/N).

    Y/N Table Edit

    18 SFA_EA_REPORT_CD Character(1) VARCHAR2(1) NOT NULL External Award reporting code.
    A=Add to existing
    N=New
    R=Replace existing

    Default Value: R

    19 ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Item Type

    Prompt Table: %EDITTABLE

    20 REL_ITEM_TYPE Character(8) VARCHAR2(8) NOT NULL Related Item Group

    Prompt Table: SFA_REL_ITM_VW5

    21 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    22 DISBURSEMENT_PLAN Character(2) VARCHAR2(2) NOT NULL Disbursement Plan

    Prompt Table: DISB_PLAN_TBL

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

    Prompt Table: DISB_SPLIT_VW

    24 NET_AWARD_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL Net Award Amount
    25 DISBURSED_AMOUNT Number(12,2) DECIMAL(11,2) NOT NULL Disbursed Amount
    26 SFA_EA_PAY_STATUS Character(1) VARCHAR2(1) NOT NULL External award paid out (Y/N).

    Y/N Table Edit

    27 SFA_EA_ADJ_REASON Character(3) VARCHAR2(3) NOT NULL External award adjustment reason.
    28 SFA_EA_INELIGIBLE Character(3) VARCHAR2(3) NOT NULL External award ineligibility code.
    29 SFA_EA_SUSPEND_RSN Character(1) VARCHAR2(1) NOT NULL External Award Load suspend reason.
    M=Multiple matches for student
    N=Student not found
    30 SFA_EA_LOAD_ERROR Number(5,0) INTEGER NOT NULL External award load error code.
    31 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).

    Y/N Table Edit

    32 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
    33 SFA_EA_AWRD_ACTION Character(1) VARCHAR2(1) NOT NULL Externa Award load action.
    B=Offer/Accept
    O=Offer
    34 DESCRLONG Long Character CLOB Long Description