SSR_PERIOD_TBL

(SQL Table)
Index Back

Campus Period Table

This table holds the campus periods related data.

  • Related Language Record: SSR_PERIOD_LNG
  • Parent Record Of SSR_AC2EXPRDLVW SSR_AC_EXPRDEVW SSR_AC_EXPRDLVW SSR_AC_EXPRDVW2 SSR_AC_EXPRDVW3 SSR_AC_EXPRDXVW SSR_AC_EXPRD_VW SSR_EXAMPER_TBL SSR_PER_ENRLEXT SSR_PER_EXAMEXT SSR_PRDATTR_TBL SSR_RELPRD_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 SSR_PERIOD_ID Character(12) VARCHAR2(12) NOT NULL Academic Period ID
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 SSR_PERIOD_TYPE Character(4) VARCHAR2(4) NOT NULL Period Type
    ACYR=Academic Year
    EXAM=Exam Period
    FAYR=Financial Aid Year
    SPLN=Student Planning

    Default Value: EXAM

    5 SSR_PRD_START_DT Date(10) DATE NOT NULL Campus Period Start Date
    6 SSR_PRD_START_TIME Time(15) TIMESTAMP Campus Period Start Time
    7 SSR_PRD_END_DT Date(10) DATE NOT NULL Campus Period End Date
    8 SSR_PRD_END_TIME Time(15) TIMESTAMP Campus Period End Time
    9 SSR_PRD_ENRL_CB Character(1) VARCHAR2(1) NOT NULL Enter Enrollment Attributes

    Y/N Table Edit

    10 SSR_LAST_SCTN_NBR Number(5,0) INTEGER NOT NULL Last Sequence Nbr
    11 SSR_MAX_EOC_PGM_DT Date(10) DATE Max EOC Program Date
    12 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
    13 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
    14 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
    15 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time