Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Common Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: YEAR_TYPE_DEFINITION

Description Contains the necessary information that ties each academic/aid period to a type of reporting year. This allows reporting by a type of year and provides the institution with a year map.
Key & Frequency One row per year type per year code.
Recommended Search Columns YEAR_TYPE, YEAR_CODE, AID_PERIOD
YEAR_TYPE, YEAR_CODE, ACADEMIC_PERIOD
YEAR_TYPE, ACADEMIC_PERIOD, YEAR_CODE

Target Column Business Definition Database Data Type Source Name Source Column
ACADEMIC_PERIOD Represents an academic period or a portion of the academic year. Academic periods may divide the year into terms, quarters or some other portion of time. This is usually set up to track the academic data like enrollment to a more finite level than the academic year. VARCHAR2(63)

ROBINST

RORTPRD

STVTERM

ROBINST_CURRENT_TERM_CODE

RORTPRD_TERM_CODE

STVTERM_CODE

ACADEMIC_PERIOD_DESC Academic period description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

ADMINISTRATIVE_GROUP Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

AID_PERIOD Represents a financial aid period or portion of an aid year associated. Aid periods can be a single academic period or set of them as appropriate for tracking the aid awarded, accepted, paid, etc. VARCHAR2(63)

RORTPRD

RORTPRD_APRD_CODE

AID_PERIOD_DESC Financial Aid period description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

END_DATE Official end date for the year based on the year type. DATE

STVTERM

STVTERM_END_DATE

END_YEAR Year and century of the End date. Example: If the End Date = 30-JUN-1991, then Year End Year = 1991. NUMBER

ROBINST

ROBINST_AIDY_END_YEAR

MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)

NA

NA

MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)

NA

NA

PROCESS_GROUP Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

READMIT_ACADEMIC_PERIOD Readmit academic period associated with this year type definition. VARCHAR2(63)

SOBTERM

SOBTERM_READMIT_REQ

READMIT_ACADEMIC_PERIOD_DESC Readmit academic period description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

START_DATE Official start date for the year based on the year type. DATE

STVTERM

STVTERM_START_DATE

START_YEAR Year and century of the Start date. Example: If the Start Date = 01-JUL-1990, then Start Year = 1990. NUMBER

ROBINST

ROBINST_AIDY_START_YEAR

YEAR_CODE Year value to be associated this record. This may be from any of the year validations in the system. VARCHAR2(63)

STVTERM

STVTERM_ACYR_CODE

YEAR_CODE_DESC Year value and type description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

YEAR_TYPE Type of year being defined. This may be an academic, financial aid, fiscal or calendar year type. VARCHAR2(63)

CONSTANT

CONSTANT

CONSTANT

CONSTANT

'ACYR'

'AIDY'

'FA_PROC_YR'

'INST_AIDY'

YEAR_TYPE_DESC Year type description. For example, fiscal, academic, calendar, financial aid year. VARCHAR2(255)

CONSTANT

CONSTANT

CONSTANT

CONSTANT

'ACADEMIC YEAR'

'AID YEAR'

'FINANCIAL AID PROCESSING YEAR FOR AN ACADEMIC PERIOD'

'INSTITUTION AID YEAR AND CURRENT ACADEMIC PERIOD'



Ver: 8.5