FA_BPKG_CRIT

(SQL Table)
 Index Back

Batch Pkg Selection Criteria

Batch Pkg Selection Criteria This table contains the fieldname and fieldvalues used to select students for batch packaging.

  • 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
    4 CRITERIA_NBR Number(3,0) SMALLINT NOT NULL Criteria Nbr

    Default Value: 1

    5 ORDER_SEQ Number(3,0) SMALLINT NOT NULL Sequence Order for Processing
    6 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

    Prompt Table: FA_BPKG_ASNVW

    7 FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101 Ref.)
    8 LENGTH Number(5,0) INTEGER NOT NULL Length
    9 DECIMALPOS Number(2,0) SMALLINT NOT NULL Decimal Positions
    10 FA_BPKG_ARITH Character(3) VARCHAR2(3) NOT NULL Arithmetic Operation
    <=Less Than
    <==Less Than or Equal to
    <>=Not Equal to
    ==Equal
    >=Greater Than
    >==Greater Than or Equal to
    LIK=Like
    LST=In List
    11 FA_CHAR Character(50) VARCHAR2(50) NOT NULL Character Field

    Prompt Table: %EDITTABLE

    12 FA_DATE Date(10) DATE Date
    13 FA_SIGNED_NBR Signed Number(13,2) DECIMAL(11,2) NOT NULL Signed Number
    14 LOGICAL_OPER Character(1) VARCHAR2(1) NOT NULL Logical Operator
    A=AND
    O=OR
    15 FA_LEFT_PAREN Character(3) VARCHAR2(3) NOT NULL Left Parenthesis
    16 FA_RIGHT_PAREN Character(3) VARCHAR2(3) NOT NULL Right Parenthesis