RETURN TO REPORTING VIEW REPORTS LIST
Student Reporting View Reports

SGHE 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: 3.1