SFA_SS_EASTG_VW

(SQL View)
 Index Back

EA Staging - Detail Record

External Award Staging detail record.

SELECT DISTINCT A.EMPLID , A.INSTITUTION , A.AID_YEAR , A.SFA_EA_TRANS_NBR , A.SFA_EA_SEQNO , A.ITEM_TYPE , A.DESCR FROM PS_SFA_EASTAGE_DTL A , PS_SFA_EASTAGE_HDR B WHERE A.SFA_EA_TRANS_NBR = B.SFA_EA_TRANS_NBR AND B.SFA_EA_TRANS_SRCE = '05'

  • Related Language Record: SFA_EASTAGE_LN3

  • Parent record: SFA_EASTAGE_HDR

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: SFA_EA_STU_SRCH

    2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

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

    Prompt Table: AID_YEAR_TBL

    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 ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Item Type

    Prompt Table: SFA_EA_ITM_SSVW

    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description