SFA_EASTAGE_HDR

(SQL Table)
 Index Back

EA Staging - Header record

Header table for Financial Aid External Award Staging process.

  • Parent Record Of SFA_EASTAGE_DTL SFA_EASTAGE_LN1 SFA_EASTAGE_LN2 SFA_EASTAGE_LN3 SFA_EASTAGE_LN4 SFA_EASTAGE_VW1 SFA_EASTAGE_VW2 SFA_EASTGDTL_LN SFA_SS_EASTG_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SFA_EA_TRANS_NBR Number(15,0) DECIMAL(15) NOT NULL Transaction number used for staging external awards to the database.
    2 TRANSACTION_DATE Date(10) DATE TRANSACTION_DATE

    Default Value: %Date

    3 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    4 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
    5 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    6 SCCFP_MAP_ID Number(15,0) DECIMAL(15) NOT NULL Mapping ID - the unique key that identifies the file mapping

    Prompt Table: SFA_EA_SCCFPMAP

    7 FILENAME Character(80) VARCHAR2(80) NOT NULL File Name
    8 CPS_SCHOOL_CODE Character(6) VARCHAR2(6) NOT NULL CPS School Code. Also known as Title IV School Code
    9 SFA_EA_STDNT_COUNT Number(5,0) INTEGER NOT NULL External award student count as read from file.
    10 SFA_EA_AWARD_TOTAL Signed Number(13,2) DECIMAL(11,2) NOT NULL External award amount total read from file.
    11 SFA_EA_RSLT_COUNT Number(5,0) INTEGER NOT NULL Actual total transaction count from EA File staging process.
    12 SFA_EA_RSLT_TOTAL Signed Number(13,2) DECIMAL(11,2) NOT NULL Actual award total from EA File staging process.
    13 SFA_EA_FILE_STATUS Character(1) VARCHAR2(1) NOT NULL File status resulting from an EA Staging process.
    E=Error
    P=Processed
    W=Warning
    14 PKG_STATUS_CD Number(5,0) INTEGER NOT NULL Package Status