RETURN TO COMPOSITE VIEW REPORTS LIST
Common Composite View Reports

SGHE Operational Data Store
Composite View Target: AR_YEAR_TYPE_DEFINITION

Description Source composite view contains the year types and codes as well as what aid and academic periods are associated with each.

Target Column Business Definition Database Data Type Source Name Source Column
ACADEMIC_PERIOD Valid academic period codes within the year selected. VARCHAR2(6)

ROBINST

RORTPRD

ROBINST_CURRENT_TERM_CODE

RORTPRD_TERM_CODE

ACADEMIC_PERIOD_DESC Academic period description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

AID_PERIOD Identifies parts of a year that students may be enrolled and receive financial assistance. For example, full year, academic period, etc. VARCHAR2(6)

RORTPRD

RORTPRD_APRD_CODE

AID_PERIOD_DESC Financial Aid period description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE

NA

SYSDATE

DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined. VARCHAR2(6)

NA

NA

END_DATE End date for the year based on the year type. DATE

ROBINST

ROBINST_AIDY_END_DATE

END_YEAR Year and century of the year end date. For Example, if the year end date is 30-JUN-1991, then year end year = 1991. NUMBER

ROBINST

ROBINST_AIDY_END_YEAR

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

NA

NA

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

NA

NA

START_DATE Official start date of the year. DATE

ROBINST

ROBINST_AIDY_START_DATE

START_YEAR Year and century of the year start date. E.g., if the year start date = 01-JUL-1990, then year start year = 1990. NUMBER

ROBINST

ROBINST_AIDY_START_YEAR

SUB_ACADEMIC_PERIOD This field identifies the session or part of the academic period associated with the information in the record. VARCHAR2(1)

NA

NA

SUB_ACADEMIC_PERIOD_DESC This field specifies the session or part of the academic period associated with the session code. VARCHAR2(1)

NA

NA

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

ROBINST

RORTPRD

ROBINST_AIDY_CODE

RORTPRD_AIDY_CODE

YEAR_CODE_DESC Description for this year value and type. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

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

CALCULATION

DECODE('AIDY','AIDY','AIDY',NULL)

DECODE('INST_AIDY','INST_AIDY','INST_AIDY',NULL)

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

CONSTANT

'AID YEAR'

'INSTITUTION AID YEAR AND CURRENT ACADEMIC PERIOD'

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

NA

NA



Ver: 3.1