SFA_AWDPER_VW

(SQL View)
 Index Back

SS Student's Award periods

Table used to select Award periods available to a Student in Self Service.

SELECT DISTINCT A.INSTITUTION ,A.AID_YEAR , A.SFA_AWARD_PER FROM PS_SFA_STD_AWDALL A UNION SELECT DISTINCT B.INSTITUTION ,B.AID_YEAR , B.SFA_AWARD_PER FROM PS_SFA_STD_AWDPER B

  • Parent record: SS_FA_STDNT_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 SFA_AWARD_PER Character(1) VARCHAR2(1) NOT NULL Award Period
    A=Academic
    N=Non Standard
    Y=Aid Year