SFA_BPKG_STDLVW

(SQL View)
 Index Back

Prompt view of FA_BPKG_STDLIST

View of FA_BPKG_STDLIST table containing selection criteria for Students who are ready to package. Used on FA_BPKG_SEL_VW for field FA_BPKG_QUERY_DEFN.

SELECT DISTINCT INSTITUTION , AID_YEAR , FA_BPKG_QUERY_DEFN FROM PS_FA_BPKG_STDLIST WHERE FA_INST_BPKG_SW = 'N'

  • Parent record: FA_BPKG_DEFN

    • # 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 FA_BPKG_QUERY_DEFN Character(50) VARCHAR2(50) NOT NULL Selection Definition