Reporting View Target: SCHEDULE

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

SGHE Banner Operational Data Store
Reporting View Target: SCHEDULE_ATTRIBUTE

Description Contains data about attributes associated with a schedule offering. These attributes are used to identify characteristics of the section or offering. For example, first year, second year, writing skill, science lab, computer skill, etc.
Key & Frequency One row per academic period per course reference number and schedule attribute.
Recommended Search Columns SCHEDULE_ATTRIBUTE, ACADEMIC_PERIOD
ACADEMIC_PERIOD, COURSE_REFERENCE_NUMBER

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column

ACADEMIC_PERIOD Academic Period Identifies the academic period or term associated with the information in the attribute record. VARCHAR2(63)
SSRATTR

SSRATTR_TERM_CODE

ACADEMIC_PERIOD_DESC Academic Period Description Academic Period descriprion. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

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

NA

COURSE_REFERENCE_NUMBER Course Reference Number Identifies the course reference number for which you are creating a section attribute code. VARCHAR2(63)
SSRATTR

SSRATTR_CRN

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

NA

MULTI_SOURCE_DESC Multi Source Description Institution description for the record when the optional multi-institution facility feature has been applied. VARCHAR2(255)
NA

NA

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

NA

SCHEDULE_ATTRIBUTE Schedule Attribute Defines an attribute associated with a schedule offering or section, that may be used for grouping sections in reporting. VARCHAR2(63)
SSRATTR

SSRATTR_ATTR_CODE

SCHEDULE_ATTRIBUTE_DESC Schedule Attribute Description Schedule attribute description. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

Ver: 9.0

Description	Contains data about attributes associated with a schedule offering. These attributes are used to identify characteristics of the section or offering. For example, first year, second year, writing skill, science lab, computer skill, etc.
Key & Frequency	One row per academic period per course reference number and schedule attribute.
Recommended Search Columns	SCHEDULE_ATTRIBUTE, ACADEMIC_PERIOD ACADEMIC_PERIOD, COURSE_REFERENCE_NUMBER

Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column
ACADEMIC_PERIOD	Academic Period	Identifies the academic period or term associated with the information in the attribute record.	VARCHAR2(63)	SSRATTR	SSRATTR_TERM_CODE
ACADEMIC_PERIOD_DESC	Academic Period Description	Academic Period descriprion.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
ADMINISTRATIVE_GROUP	Administrative Group	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
COURSE_REFERENCE_NUMBER	Course Reference Number	Identifies the course reference number for which you are creating a section attribute code.	VARCHAR2(63)	SSRATTR	SSRATTR_CRN
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Multi Source Description	Institution description for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
SCHEDULE_ATTRIBUTE	Schedule Attribute	Defines an attribute associated with a schedule offering or section, that may be used for grouping sections in reporting.	VARCHAR2(63)	SSRATTR	SSRATTR_ATTR_CODE
SCHEDULE_ATTRIBUTE_DESC	Schedule Attribute Description	Schedule attribute description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC