FA_FATERM_CLASS

(SQL Table)
Index Back

Class Detail for FATerm

  • Parent record: STDNT_FA_TERM
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PEOPLE_SRCH

    2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

    3 STRM Character(4) VARCHAR2(4) NOT NULL Term

    Prompt Table: TERM_VAL_TBL

    4 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    5 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
    6 CLASS_NBR Number(5,0) INTEGER NOT NULL Class Nbr
    7 ROW_NUM Number(3,0) SMALLINT NOT NULL Row Number
    8 START_DT Date(10) DATE Start Date
    9 END_DT Date(10) DATE end date
    10 UNT_TAKEN_FA Number(9,3) DECIMAL(8,3) NOT NULL Fin Aid Progress Units Taken
    11 FA_OEE_CLASS Character(1) VARCHAR2(1) NOT NULL Open Enrollment Class

    Y/N Table Edit