STAT_PERIOD_TBL

(SQL Table)
 Index Back

Academic Statistics Period Tbl

  • Related Language Record: STAT_PERIOD_LNG

    • # 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 ACAD_STATS_PERIOD Character(10) VARCHAR2(10) NOT NULL Academic Statistics Period
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: STAT_PERIOD_TBL.DESCR

    5 AS_OF_DATE Date(10) DATE As of Date
    6 ACAD_STATS_PD_TYPE Character(2) VARCHAR2(2) NOT NULL Statistics Period Type

    Default Value: SR

    Prompt Table: ACD_STAT_TP_TBL

    7 ACAD_STATS_PD_RULE Character(1) VARCHAR2(1) NOT NULL Academic Load Rule
    C=Contiguous Terms
    T=Term Load Rule Applies

    Default Value: T

    8 CONS_TRIGGER Character(2) VARCHAR2(2) NOT NULL Consolidation Trigger
    AD=As of Today
    AS=As of Date
    CD=Consolidation Date

    Default Value: AS

    9 CALC_CUM_STATS Character(1) VARCHAR2(1) NOT NULL Calculate Cumulative Stats

    Y/N Table Edit

    Default Value: Y

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

    Prompt Table: AID_YEAR_TBL