Skip to end of metadata
Go to start of metadata

Summary

This document describes support of affiliation groups in the UW Groups service, including naming, data integration, data quality, life cycle, and access control. Affiliation groups are intended to support effective and efficient day-to-day operations of current UW programs by providing timely, accurate groups representing various affiliations which individuals have with the UW.  Affiliation groups are based on data integration between the UW Identity Registry and the groups service. Many groups are updated near-real time and some are updated nightly.

Examples

The following table illustrates several affiliation groups:

Group ID

Display Name

Effective Membership

uw_affiliation_undergraduate

UW Undergraduate Students

UW students who are identified as undergraduates.

uw_affiliation_graduate

UW Graduate Students

UW students who are identified as graduate or professional students.

uw_affiliation_uw-medicine-workforce

UW Medicine Workforce Members

Members of the UW Medicine Workforce that use clinical applications as identified by UW Medicine IT Services User Access Administration(uaa@u.washington.edu).

uw_affiliation_affiliate-employee

UW Affiliate Employees

Contingent Workers with an active position in Workday.

Affiliation Group IDs

Affiliation groups are identified by UW Group IDs that conform to the UW Group Naming Plan. The following affiliation/organization stem is reserved for them:

  uw_affiliation

Data Integration

The UW Person Registry is the source for the affiliations represented by the affiliation groups. In turn, the Person Registry relies on several data sources, including the student database (SDB), the UW HR system, the Washington State DOH health practitioner database, etc. As the data from the various sources are processed and reconciled, affiliations are assigned to individuals. Because an individual may have multiple affiliations with the UW, an individual may be a member of more than one affiliation group. To contain costs and support smooth operations, UW-IT manages affiliations using the concept of a "grace period". That is, the status of an individual's affiliation changes from current to grace to former, where the intermediate grace period eases transitions from current to former status. Most of the affiliation group memberships retained members who are either current or in grace periods. The duration of the grace period varies, depending on affiliation.

The following table summarizes the most relevant aspects of data integration between the Person Registry and the groups service, related to identifiers, display names, membership derivation, and grace period information.

Group

Display Name

Membership
Original Data Source

Real-time updates

Membership Derivation

Grace Period

uw_affiliation_undergraduate

UW Undergraduate Students

student database (SDB)

YES

In SDB, class is one of (01, 02, 03, 04, 05, 06)
AND
admitted for a future quarter OR enrolled in current or future quarter

1 quarter

uw_affiliation_graduate

UW Graduate Students

student database (SDB)

YES

In SDB, class is one of (00, 08, 11, 12, 13, 14)
AND
enrolled in current or future quarter OR on-leave

1 quarter

uw_affiliation_graduate-current

UW Current Graduate Students

student database (SDB)

YES

In SDB, class is one of (00, 08, 11, 12, 13, 14)
AND
enrolled in the current quarter only, including on-leave (in SDB) graduate students

none

uw_affiliation_graduate-grad


UW Graduate Students - Graduate

student database (SDB)

YES

In SDB, class is 08
AND
enrolled in current or future quarter OR on-leave

1 quarter

uw_affiliation_seattle-student-undergraduate

UW Seattle Undergraduate Students

student database (SDB)YES

In SDB, primary_branch is 0, class is one of (01, 02, 03, 04, 05, 06)
AND
admitted for a future quarter OR enrolled in current or future quarter

1 quarter

uw_affiliation_seattle-student-graduate

UW Seattle Graduate Students

student database (SDB)

YES

In SDB, primary_branch is 0, class is one of (00, 08, 11, 12, 13, 14)
AND
admitted for a future quarter OR enrolled in current or future quarter OR on-leave

1 quarter

uw_affiliation_bothell-student-undergraduate

UW Bothell Undergraduate Students

student database (SDB)

YES

In SDB, primary_branch is 1, class is one of (01, 02, 03, 04, 05, 06)
AND
admitted for a future quarter OR enrolled in current or future quarter 

1 quarter

uw_affiliation_bothell-student-graduate

UW Bothell Graduate Students

student database (SDB)

YES

In SDB, primary_branch is 1, class is one of (00, 08, 11, 12, 13, 14)
AND
admitted for a future quarter OR enrolled in current or future quarter OR on-leave

1 quarter

uw_affiliation_tacoma-student-undergraduate

UW Tacoma Undergraduate Students

student database (SDB)

YES

In SDB, primary_branch is 2, class is one of (01, 02, 03, 04, 05, 06)
AND
admitted for a future quarter OR enrolled in current or future quarter

1 quarter

uw_affiliation_tacoma-student-graduate

UW Tacoma Graduate Students

student database (SDB)

YES

In SDB, primary_branch is 2, class is one of (00, 08, 11, 12, 13, 14)
AND
admitted for a future quarter OR enrolled in current or future quarter OR on-leave

1 quarter

uw_affiliation_bothell-student

Current Bothell students

student database (SDB)

YES

In SDB, primary_branch is 1, and enrolled in current quarter

none

uw_affiliation_tacoma-student

Current Tacoma students

student database (SDB)

YES

In SDB, primary_branch is 2, and enrolled in current quarter

none

uw_affiliation_seattle-student

Current Seattle students

student database (SDB)

YES

In SDB, primary_branch is 0, and enrolled in current quarter

none

uw_affiliation_extension-student

UW Extension Students

student database (SDB)

YES

In SDB: EO flag

1 quarter
uw_affiliation_continuum-student_graduateUW Continuum College Graduate Students

student database (SDB)

YESIn SDB: class is one of (08, 11, 12, 13, 14) AND EO flag1 quarter
uw_affiliation_continuum-student_undergraduateUW Continuum College Undergraduate Studentsstudent database (SDB)YESIn SDB: class is one of (01, 02, 03, 04, 05) AND EO flag1 quarter

uw_affiliation_applicant

UW Applicants

student database (SDB)

YES

In SDB: application for future quarter

1 quarter

uw_affiliation_alumni

UW Alumni

Alumni Advancement database

YES

In Advancement database, type is alumni

30 days

uw_affiliation_alumni-association-members

UW Alumni Association Members

Alumni Advancement database

YES

In Advancement database, alumni_member is A

none
uw_affiliation_staff-employeeUW Staff Employees

UW HR system (Workday)

YES

Active in UW HR system, Has position in job family groups: Staff, Stipend Family, Student Employees, or Union/Bargaining Unit.

14 days

uw_affiliation_student-employee

UW Student Employees

UW HR system (Workday)

YES

Active in UW HR system, Position with job family group: Student Employee

14 days

uw_affiliation_affiliate-employee

UW Affiliate Employees

UW HR system (Workday)

YES

Active in UW HR system, Position with job family group: Contingent Workers

14 days

uw_affiliation_cascadia-user

Cascadia Community College Members

Cascadia Community College

YES

In Cascadia Active Directory

14 days

uw_affiliation_cascadia-student

Cascadia Community College Students

Cascadia Community College

YES

In Cascadia Active Directory as student

14 days

uw_affiliation_cascadia-employee

Cascadia Community College Employees

Cascadia Community College

YESIn Cascadia Active Directory as employee14 days

uw_affiliation_uw-medicine-workforce

UW Medicine Workforce Members

UW Medicine IT Services

YES

Identified as "UW Medicine Workforce" by UW Medicine ITS 

none
uw_affiliation_wwami-medical-residentMedical residents in FMRN and Spokane Internal Medicine programs who are eligible for employee computing services and UW Libraries services

New Innovations Resident Database

Spokane Providence Medical Center HR

YES

Individuals active for the current academic year by UW WWAMI Family Medicine or WWAMI Spokane Internal Medicine

none

uw_affiliation_uw-medicine-affiliate

UW Medicine Affiliates

UW Medicine IT Services

YES

Identified as "UW Medicine Affiliates" by UW Medicine ITS

none

uw_affiliation_scca-employee

Seattle Cancer Care Alliance Employees

Seattle Cancer Care Alliance

YES

Company = 'CCA' and
PayGroup = 'CCA' and
EmployeeStatus is one of A, L, or P

none

uw_affiliation_scca-affiliate

Seattle Cancer Care Alliance Affiliates

Seattle Cancer Care Alliance

YES

Company = 'CCA' and
PayGroup = 'AFF' and
EmployeeStatus is one of A, L, or P

none

uw_affiliation_fhcrc-employee

Fred Hutchinson Cancer Research Center Employees

Fred Hutchinson Cancer Research Center

YES

Company = 'FHC' and
PayGroup = 'FHC and
EmployeeStatus is one of A, L, or P

none

uw_affiliation_fhcrc-affiliate

Fred Hutchinson Cancer Research Center Affiliates

Fred Hutchinson Cancer Research Center

YES

Company = 'FHC' and
PayGroup = 'AFF' and
EmployeeStatus is one of A, L, or P

none

uw_affiliation_heal-wa

HEAL-WA

Washington State DOH

YES

Valid Washington State health practitioner license holders (except Dentists)

16 days
uw_affiliation_uwp-providerUW Physicians ProvidersUW PhysiciansYESActive in UWP HR system as a "provider"none
uw_affiliation_professional-staffUW Professional Staff EmployeesUW HR system (Workday)NO

In ODS with ECS code = 'E'.

To learn more, refer to the UW Professional Staff Group information page.

none
uw_affiliation_staff-non-uwm-workforceUW Staff Employees who are not an active UW Medicine Workforce member. Group to be deleted after 2FA is universally required.UW HR system (Workday),
UW Medicine IT Services
NO

Active in UW HR system, Has position in job family groups: Staff, Stipend Family, Student Employees, or Union/Bargaining Unit.

Not listed as "UW Medicine Workforce" by UW Medicine ITS staff

none
uw_affiliation_faculty-non-uwm-workforceWorkers with an academic appointment who are not an active UW Medicine Workforce member. Group to be deleted after 2FA is universally required.UW HR system (Workday),
UW Medicine IT Services
NO

Active in UW HR system, Has position in job family groups: Faculty or Unpaid Academic Worker.

Not listed as "UW Medicine Workforce" by UW Medicine ITS staff

none


There is also a set of legacy eduPersonAffiliation groups, not in the uw_affiliation stem (see eduPerson Affiliation Reference).  These eduPerson affiliation groups are:

Group

Display Name

Membership
Original Data Source

Real-time updates

Membership Derivation

Grace Period

uw_employee

uw_employee

UW HR system (Workday)

YES

In Workday with a worker position, not contingent workers

14 days after separation

uw_faculty

uw_faculty

UW HR system

(Workday)

YES

In Workday with a paid academic worker position 

14 days after separation

uw_staff

uw_staff

UW HR system

(Workday)

YES

In Workday with a position in job family groups: Academic Personnel, Staff, Stipend, Student Employees, or Union/Bargaining Unit, 

14 days after separation

uw_student

uw_student

student database (SDB)

YES

In SDB and status is: admitted for future quarter, pre-registered for future quarter, enrolled for current quarter, on-leave, or active Continuum College flag (EO flag).

Yes

One quarter of grace, not including summer quarter

uw_alumUW AlumniAdvancement databaseYESIn Advancement and has alumni flag set to yesYes

uw_affiliate

uw_affiliate

Person Registry

YES

Is active in: UW Medicine (AMC), a contingent worker in Workday, an applicant in SDB, a active affiliate in Advancement DB, a Cascadia user, in SCCA/FHCRC Workday system. 

Also included are all users who were sponsored to obtain a UW NetID.

Required: User does not have another eduPerson affiliation (also represented by uw_employee, uw_faculty, uw_staff, uw_student, or uw_alum groups)

yes, for most

Data Quality Standards

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

Data Validation Rules: Validation rules are applied only to ensure that affiliation data conform to the constraints of the groups data model. Therefore, the accuracy of affiliation groups, including names and memberships, is primarily determined by the quality and validity of the source data. To ease transitions, members which have been removed from the source data are retained in the groups for the period of time specified in the Grace Period column, above.

Timeliness of Updates: Under normal operating conditions, real-time updates are sent within 10 seconds of a change in the identity system.  During periods of large turnover, eg. start of quarter, updates may be delayed by up to 8 hours.  Groups updated nightly are updated 7 days a week.

Defined Error Rates: Overall, the groups service relies on the data sources, as the systems of record, to define the frequency of errors in affiliations data.

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

Reliability: Affiliation groups are provisioned using processes 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 affiliation groups, once provisioned, is that of the groups service itself: 24 hours a day, 7 days a week, with rare exceptions.

Affiliation Group Lifecycle Policy

The following lifecycle policy provides notification of affiliation group availability to help customers make informed information technology decisions, anticipate de-provisioning, identify other business needs, and provide feedback.

Lifecycle Policy: Affiliation groups are retained indefinitely. While the groups themselves will be retained, the membership of the groups will of course change over time, as peoples' affiliations change.

Access Control Policy

The affiliation group memberships are restricted based on their size and the confidentiality of the membership data. This restricted classification forms the basis of the following access control policy and appropriate use guidelines. It is also the basis for membership viewer controls on some of the group memberships.

Access Control Policy: Having considered the privacy, security, and compliance concerns and acknowledging the business needs and operational efficiencies enabled via affiliation groups, the responsible custodians have established an access control policy that grants permission to view memberships only to authorized users. Requests for access (by applications, students, affiliates, and other third parties) may be authorized on a case-by-case basis, based on establishing a business need and/or an appropriate data sharing agreement.

Appropriate Use Guidelines: Use of affiliation groups is subject to the following appropriate use guidelines. Permission to view affiliation group memberships is granted on the condition that authorized clients use the memberships for appropriate business purposes. Authorized clients are responsible for enforcing the defined access control policy and may not share affiliation group memberships without first obtaining authorization to do so. Sending unsolicited email to the membership of an affiliation group may violate UW privacy policy. 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 affiliation groups with email.