FA_INST_DEFN

(SQL Table)
Index Back

Inst Batch Pckg Definition Tbl

Institutional Batch Packaging Definition Table This table indicates the institutional batch packaging definition description. This is the parent table to the Inst Batch Packaging Criteria table where the selection criteria is defined.

  • Parent Record Of FA_INST_CRIT
  • # 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
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: FA_INST_DEFN.DESCR