|
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 legacy system's term code, for snapshots taken prior to Summer 2022.
SRS terms use the format of YYYYT where YYYY is the calendar year, and T is:
A = Spring
B = Summer
C = Fall
|
Banner Term
Indexed - no
Format - varchar2 (30)
May be null? no |
Pennant term code, for snapshots taken since the Summer of 2022.
Banner term use the format of YYYYT where YYYY is the calendar year, and T is:
10 = Spring
20 = Summer
30 = Fall
|
Term in English
Indexed - no
Format - varchar2 (25)
May be null? no |
The Term decoded into Semester text.
|
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.
|
