SS_FA_STDNT_HDR

(SQL Table)
 Index Back

Self Service Award Header

Header record for self service awarding transactions.

  • Parent Record Of SFA_AP_DESCLNG SFA_AWDPER_VW SFA_SS_AWARD_VW SFA_STD_AWDPER SFA_STD_AWDSWRK SFA_STD_AWD_WRK SS_FA_AWARD_VW SS_FA_STDNT_AWD

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

    Prompt Table: PEOPLE_SRCH

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

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

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

    Default Value: OPR_DEF_TBL_CS.AID_YEAR

    Prompt Table: AID_YEAR_TBL

    4 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
    5 DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    6 SS_FA_PKG_STATUS Character(1) VARCHAR2(1) NOT NULL Package Status
    1=New Package
    2=Revised Package
    3=Pending Update
    4=Successful
    5=Rejected
    6=Needs Review
    7=Successful with Adjustments