Penn Computing

University of Pennsylvania
Penn Computing << go backback
TIME Table   Tables and Data Elements   Tuition Distribution Home   Data Warehouse Home

Time Dimension Table - Data Element Index

Select a data element to view its definition and its indexed, format, and null values.

Snapshot Data

  • Extract Date
  • Final Snap for Term Indicator
  • Snap Period
  • SRS Term
  • Term in English
  • Term Start Date
  • Term End Date
  • Accounting Period Data


    Data element

    Definition

    Accounting Period

    Indexed - no
    Format - varchar2 (6)
    May be null? no

    The Accounting Period stated in MON-YY format. MON is the calendar month (stored in upper case), and YY is the calendar year. Note that the beginning and ending dates of an ACCOUNTING_PERIOD are not the same as the first and last day of the calendar month.

    Example: JUL-96 (July 1996, which occurs in fiscal year 1997).

    Calendar Year

    Indexed - no
    Format - varchar2 (4)
    May be null? no

    The calendar year for the ACCOUNTING_PERIOD. The calendar year begins January 1 and ends December 31.

    Example: 1996 (the CALENDAR_YEAR for ACCOUNTING_PERIOD JUL-96).

    Extract Date

    Indexed - no
    Format - date
    May be null? yes

    The date of the extract as well as the date that BRS closes for their month end.

    Final Snap for Term Indicator

    Indexed - no
    Format - varchar2 (1)
    May be null? no

    The 1-character Indicator (Y/N) showing whether the extract is the last shot for the term.

    Fiscal Month Seq

    Indexed - no
    Format - varchar2 (2)
    May be null? no

    The month number (or accounting period) of the fiscal year. This field is used for sorting.

    Fiscal Year

    Indexed - no
    Format - varchar2 (4)
    May be null? no

    The financial year. Penn's fiscal year begins July 1 of one calendar year and ends June 30 of the next calendar year.

    GAAP Percentage

    Indexed - no
    Format - number(3)
    May be null? no

    The Percentage used by the Tuition Distribution system for booking the Billed Amounts over a term. This number is only being used for the Revenue Recognition Journals and is provided in the Business Objects Universe solely for reconciliation purposes.

    Month

    Indexed - no
    Format - char (10)
    May be null? no

    The number that identifies the calendar month (or accounting period).

    Example: 01 (January); 11 (November).

    Quarter Seq

    Indexed - no
    Format - char (3)
    May be null? no

    The quarter of the fiscal year.

    Example: 1 (first quarter, July to September)

    Snap Period

    Indexed - no
    Format - integer
    May be null? no

    The number of an extract within a term. Generally, Snap Periods run 1 to 5.

    SRS Term

    Indexed - no
    Format - varchar2 (30)
    May be null? no

    The Section School code concatenated with the description.

    Term in English

    Indexed - no
    Format - varchar2 (25)
    May be null? no

    The SRS Term decoded into Semester text.

    A = Spring, B = Summer, C = Fall

    Term Start Date

    Indexed - no
    Format - date
    May be null? no

    The start date for the extract term, as defined by the Registrar's Term Schedule.

    Term End Date

    Indexed - no
    Format - date
    May be null? no

    The end date for the extract term, as defined by the Registrar's Term Schedule.

    TIME Table   Tables and Data Elements   Tuition Distribution Home   Data Warehouse Home

    Questions about this page? Email us at da-staff@isc.upenn.edu

    Information Systems and Computing
    University of Pennsylvania
    Information Systems and Computing, University of Pennsylvania