Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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. The Many groups are updated nightly, Sunday through Fridaynear-real time and some are updated nightly.

Examples

The following table illustrates several affiliation groups:

...

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)

NO

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

none

uw_affiliation_tacoma-student

Current Tacoma students

student database (SDB)

NO

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

none

uw_affiliation_seattle-student

Current Seattle students

student database (SDB)

NO

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 status

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 status
1 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 status
1 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 AL

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, Position with ECS code B, C, D, E, H, I, P, S, or T.

15 days

uw_affiliation_student-employee

UW Student Employees

UW HR system (Workday)

YES

Active in UW HR system, Position with ECS code G or U

15 days

uw_affiliation_affiliate-employee

UW Affiliate Employees

UW HR system (Workday)

YES

Active in UW HR system, Position with ECS Code V (Contingent)

15 days

uw_affiliation_cascadia-user

Cascadia Community College Members

Cascadia Community College

YES

Active in Cascadia Active Directory

15 days

uw_affiliation_cascadia-student

Cascadia Community College Students

Cascadia Community College

YES

Active in Cascadia Active Directory as student

15 days

uw_affiliation_cascadia-employee

Cascadia Community College Employees

Cascadia Community College

YESActive in Cascadia Active Directory as employee15 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

category_code=53 (SCCA Employee)

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

category_code=54 (SCCA Affiliate)

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

category_code=55 (FHCRC Employee)

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

category_code=56 (FHCRC Affiliate)

none

uw_affiliation_heal-wa

HEAL-WA

Washington State DOH

YES

Valid Washington State health practitioner license holders (except Dentists)

category_code = 57 (HEAL WA)

16 days
uw_affiliation_uwp-providerUW Physicians ProvidersUW PhysiciansYESActive in UWP HR system as a "provider"none
uw_affiliation_uwnc-staffUW Neighborhood Clinics StaffUW Neighborhood Clinics YESActive in UW Neighborhood Clinics HR system as "staff"


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

...

Group

Display Name

Membership
Original Data Source

Real-time updates

Membership Derivation

uw_employee

uw_employee

UW HR system (Workday)

YES

In Workday, Primary ECS Code is B, C, D, E, H, I, P, S, T, F, N, G, or U

uw_faculty

uw_faculty

UW HR system

(Workday)

YES

In Workday, Primary ECS Code is F or N

uw_staff

uw_staff

UW HR system

(Workday)

YES

In Workday, Primary ECS Code is B, C, D, E, H, I, P, S, T, G, or U

uw_student

uw_student

student database (SDB)

YES

In SDB, status is not N and status is not X

uw_affiliate

uw_affiliate

Person Registry

YES

Holds a category_code of  13, 15, 17, 20, 25, 26, 28, 39, 40, 41, 45, or 53-56 with a status_code of 1 but does not hold a category_code of 1, 2, 4, 5, 14, 16, 18, 19, 34, or 35 with a status_code of 1

...

Timeliness of Updates: Under normal operating conditions, updates will propagate to the groups service every Sunday night through Friday night.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.

...