ITM_TP_TERM_LMT

(SQL Table)
 Index Back

Award Limits by Term Type

Award Limits by Term Type

  • Parent record: ITEM_TYPE_FA

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SP_SETID_NONVW

    2 ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Item Type

    Prompt Table: ITEM_TYP_FA3_VW

    3 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year

    Prompt Table: ITEM_TYPE_FA

    4 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    5 TERM_CATEGORY Character(1) VARCHAR2(1) NOT NULL Term Category
    0=Full Year
    1=1st Semester
    2=2nd Semester
    3=Summer Session AUS
    4=Winter Session AUS
    C=Medical Clinical
    I=Intersession Term
    M=Medical Level 1
    R=Regular Term
    S=Summer Term
    W=Winter Term

    Default Value: R

    6 MINIMUM_AWARDS Number(9,2) DECIMAL(8,2) NOT NULL Minimum Award Total
    7 MAXIMUM_AWARDS Number(9,2) DECIMAL(8,2) NOT NULL Maximum Award Total
    8 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: INSTALLATION.EXCHNG_TO_CURRENCY

    Prompt Table: CURRENCY_CD_TBL