Reporting View Target: YEAR_TYPE

Go To View:	RETURN TO REPORTING VIEW 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 Academic period associated with this year type definition. 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 Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)
NA

NA

AID_PERIOD Identifies parts of a year that students may be enrolled and receive financial assistance. For example, full year, academic period, 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

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

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

STVTERM_START_DATE

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

ROBINST_AIDY_CODE
RORTPRD_AIDY_CODE
STVACYR_CODE
STVTERM_FA_PROC_YR

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.1

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	Academic period associated with this year type definition.	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	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
AID_PERIOD	Identifies parts of a year that students may be enrolled and receive financial assistance. For example, full year, academic period, 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
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
START_DATE	Official start date for the year based on the year type.	DATE	STVTERM	STVTERM_START_DATE
YEAR_CODE	Year value to be associated this record. This may be from any of the year validations in the system.	VARCHAR2(63)	ROBINST RORTPRD STVACYR STVTERM	ROBINST_AIDY_CODE RORTPRD_AIDY_CODE STVACYR_CODE STVTERM_FA_PROC_YR
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'