Skip to end of metadata
Go to start of metadata

Summary

This document describes support for curriculum groups in the UW groups service including naming, data integration, data quality, lifecycle and access control.

Curriculum groups represent all the students and instructors of record for all the courses within a particular curriculum for a particular year and quarter.

These institutional groups are based on data integration between the student data base (SDB) and the groups service. They are updated nightly, Sunday through Friday.

Curriculum groups are created by request. To request curriculum groups for your department, email iam-support@uw.edu.

Examples

The following table illustrates several curriculum groups from the hierarchy representing the ART curriculum:

Group ID

Display Name

Effective Membership

uw_curriculum_art

ART Course Students and Instructors

Students and instructors of record for all courses in the ART curriculum for the current quarter

uw_curriculum_art_prev
uw_curriculum_art_next

ART Course Students and Instructors, previous or next quarter

Students and instructors of record for all courses in the ART curriculum for the previous or next quarter

uw_curriculum_art_students

ART Course Students

Students for all courses in the ART curriculum for the current quarter

uw_curriculum_art_students_prev
uw_curriculum_art_students_next

ART Course Students, previous or next quarter

Students for all courses in the ART curriculum for the previous or next quarter

uw_curriculum_art_instructors

ART Course Instructors

Instructors of record for all courses in the ART curriculum for the current quarter

uw_curriculum_art_instructors_prev
uw_curriculum_art_instructors_next

ART Course Instructors, previous or next quarter

Instructors of record for all courses in the ART curriculum for the previous or next quarter

uw_curriculum_art_2012sum

ART Course Students and Instructors Summer 2012

Students and instructors of record for all courses in the ART curriculum for Summer 2012

uw_curriculum_art_students_2012aut

ART Course Students Autumn 2012

Students for all courses in the ART curriculum for Autumn 2012

uw_curriculum_art_instructors_2012aut

ART Course Instructors Autumn 2012

Instructors for all courses in the ART curriculum for Autumn 2012

Curriculum Group IDs

Curriculum groups are identified by UW Group IDs that conform to the UW Group Naming Plan.

The following stem is reserved for them:

  uw_curriculum

Each curriculum with groups has the following groups:

  uw_curriculum_<curric-code>

  uw_curriculum_<curric-code>_prev

  uw_curriculum_<curric-code>_next

  uw_curriculum_<curric-code>_students

  uw_curriculum_<curric-code>_students_prev

  uw_curriculum_<curric-code>_students_next

  uw_curriculum_<curric-code>_instructors

  uw_curriculum_<curric-code>_instructors_prev

  uw_curriculum_<curric-code>_instructors_next

Additional groups identify membership by year and quarter:

  uw_curriculum_<curric-code>_<yyyy><qqq>

  uw_curriculum_<curric-code>_students_<yyyy><qqq>

  uw_curriculum_<curric-code>_instructors_<yyyy><qqq>

Here <yyyy> is the 4-digit year and <qqq> is either "win", "spr", "sum" or "aut" corresponding with the term.

Data Integration

The following table summarizes the most relevant aspects of data integration between the SDB and the groups service, related to identifiers, display names, descriptions, memberships, contacts and access controls.

Group Attribute

Data Integration Notes

Group ID

Group IDs for curriculum groups include curriculum codes from SDB.

Since curriculum codes are uppercase and can contain spaces and occasional ampersands, the following transformations are applied to conform with UW group naming conventions:

  1. Initial and trailing spaces are removed
  2. All letters are converted to lower case
  3. All internal spaces are replaced with dashes
  4. All ampersand characters are replaced with a dash followed by "and" followed by a dash
  5. Any remaining characters not in "-", "A-Z", "0-9" are replaced with the period "." character

Group Display Name

Curriculum groups include curriculum codes, year, and quarter in the group display name, e.g.:

ARCH Course Students and Instructors
ARCH Course Students and Instructors, previous quarter
ARCH Course Students and Instructors, next quarter
ARCH Course Students and Instructors Autumn 2012

Group Description

Curriculum group descriptions not only describe the groups but also communicate appropriate use guidelines:

"This group is updated nightly from the Student Database. It is available for appropriate business purposes in support of programs designed for UW students. Access to the membership is controlled because it contains a limited amount of student information that falls under the protections of FERPA. See http://www.washington.edu/students/reg/ferpafac.html for more information about use of FERPA-protected information. Please contact help@uw.edu for questions about using this group."

Group Membership List

Curriculum group memberships are reconciled nightly, Sunday through Friday, to accurately represent current operational data rather than historical data. Members are identified by UW NetID in the groups identified by year and quarter. These groups are nested as members of the other groups to avoid duplicating the same source memberships in multiple groups.

Note: Students without a UW NetID are not included in the membership lists.

Group Access Controls

Curriculum groups have a membership viewer control that enforces the defined access control policy (see below). Only members of the uw_employee group and u_groups_curriculum_read-access group are authorized to view these memberships.

Group Contact Person

Curriculum groups have no owner specified.

Exchange Status

Curriculum groups cannot be enabled for use in UW Exchange. This business rule is in place to ensure the privacy restriction on the group memberships, which the current design of the UW Exchange service cannot enforce by itself.

Data Quality Standards

This section summarizes data quality standards for curriculum groups represented in the groups service.

Data Validation Rules: Validation rules are applied only to ensure that data integrated from SDB conforms to the constraints of the groups data model. Therefore, the validity of the values for curriculum group IDs, names and memberships is primarily determined by the validity of the source data provisioned from SDB and the validation rules applied upstream of the groups service.

Timeliness of Updates: Under normal operating conditions, once data is updated in SDB, updates will propagate to the groups service every Sunday night through Friday night.

Defined Error Rates: Overall, the groups service relies on SDB, as the system of record, to define the frequency of errors in curriculum data. However, some discrepancies are expected between SDB and curriculum groups for previous quarters, since not all updates to previous quarter data are propagated to the groups service. The groups service maintains previous quarter data based on the last time it was included in the source data feed.

Integrity Monitoring: The integrity of curriculum data is ensured during secure transport between SDB and the groups service. Physical, system and administrative controls are used on the groups service to maintain integrity.

Reliability: Curriculum groups are provisioned from SDB using a process monitored to ensure reliability and availability of the groups. When abnormalities such as potentially corrupt or incomplete data feeds are detected during the provisioning process, updates are not applied until the abnormalities are reviewed. The reliability of curriculum groups, once provisioned, is that of the groups service itself: 24 hours a day, 7 days a week, with rare exceptions.

Lifecycle Policy

The following lifecycle policy provides advanced notification of curriculum group availability to help customers make informed information technology decisions, anticipate deprovisioning, identify other business needs and provide feedback.

Lifecycle Policy: The lifecycle policy for curriculum groups retains group data for three quarters. That is, at any given point in time, the groups service will include curriculum groups for the current quarter and three previous quarters, plus any future quarters (when available). Curriculum groups that are four or more quarters old will be deleted.

The method for determining the current quarter is to transition from one quarter to the next on the Thursday before the first day of each new quarter, with no transition between summer A and B terms. This schedule also determines when the older groups will be deleted.

Access Control Policy

Classification: The Registrar classifies curriculum group data as FERPA protected. This restricted classification forms the basis of the following access control policy and appropriate use guidelines. It is also the basis of the required membership viewer control and group description text (both above).

Access Control Policy: Having considered the privacy, security and compliance concerns and acknowledging the business needs and widespread operational efficiencies enabled via curriculum groups, the Registrar has established an access control policy that grants permission to view curriculum group memberships to all UW employees (i.e. current faculty, staff and student employees) as well as processes acting on behalf of UW employees. Non-employee access (including students, affiliates and other third parties) may be authorized by the Office of the Registrar on a case-by-case basis, based on establishing a business need and/or an appropriate data sharing agreement.

Appropriate Use Guidelines: Use of curriculum groups is subject to the following appropriate use guidelines. Permission to view curriculum group memberships is granted on the condition that authorized clients use the memberships for appropriate business purposes in support of programs designed for students. Authorized clients are responsible for enforcing the defined access control policy (above) and may not share curriculum group memberships with non-employees without first obtaining authorization to do so. Copying and posting the membership of a curriculum group in a public location, or sending the membership via email, is unadvised and may violate the access control policy. Curriculum groups may be used in limited ways to contact students in support of programs designed for students. All users are expected to know and follow the rules related to ethical and appropriate use of UW computing and networking resources. These rules include guidelines on email use that apply to the use of curriculum groups with email.

References

SDB Documentation