Reporting View Target: SCHEDULE

Go To View:	RETURN TO REPORTING VIEW 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 Definition Database Data Type Source Name Source Column

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

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

SSRATTR_CRN

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 for the record 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

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. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

Ver: 8.1

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 Definition	Database Data Type	Source Name	Source Column
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 descriprion.	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
COURSE_REFERENCE_NUMBER	Identifies the course reference number for which you are creating a section attribute code.	VARCHAR2(63)	SSRATTR	SSRATTR_CRN
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 for the record 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
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.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC