BDGT_FORMLA_DFN

(SQL Table)
 Index Back

Budget Formula Table

Budget Formula Table - 07/29/96 - E.D. This table contains the fieldname and fieldvalues used in a formula that defines a budget item code for a particular budget category. Part of Financial Aid - Budget Assignment.

  • Parent record: BDGT_FORMLA_TBL

    • # 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 BGT_ITEM_CATEGORY Character(4) VARCHAR2(4) NOT NULL Budget Item Category

    Prompt Table: BUDGET_CATG_VW

    4 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %Date

    5 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number
    6 CRITERIA_NBR Number(3,0) SMALLINT NOT NULL Criteria Nbr

    Default Value: 1

    7 SFA_CRITERIA_NBR Number(5,0) INTEGER NOT NULL Criteria Nbr

    Default Value: 1

    8 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

    Prompt Table: STDNT_BGT_ASNVW

    9 FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101 Ref.)
    10 SEQUENCE_NBR Number(2,0) SMALLINT NOT NULL Sequence Number
    11 ARITH_OPER 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
    BLK=Is Blank
    LIK=Like
    12 FIELD_VALUE Character(30) VARCHAR2(30) NOT NULL Field Value

    Prompt Table: %EDITTABLE

    13 LOGICAL_OPER Character(1) VARCHAR2(1) NOT NULL Logical Operator
    A=AND
    O=OR
    14 SEQUENCE_NBR_3 Number(3,0) SMALLINT NOT NULL Sequence Nbr