RAD_CRIT_TBL

(SQL Table)
Index Back

RAD Criteria Table

This table contains all the Renewal Application Data criteria by RAD type.

  • Parent record: RAD_CRIT_TYPE
  • # 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 RAD_TYPE Character(8) VARCHAR2(8) NOT NULL RAD Type

    Prompt Table: RAD_CRIT_TYPE

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

    Prompt Table: RAD_PSRECFLD_VW

    5 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
    6 FIELD_VALUE Character(30) VARCHAR2(30) NOT NULL Field Value

    Prompt Table: %EDITTABLE

    7 FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101 Ref.)