Each External Source that plays an active role in maintaining Registry data must contribute affiliation information used to characterize individuals to business rules and to infrastructure. This affiliation data provides basic categorization information of individuals for statistics, and supports value-added output from the registry, such as enterprise Privilege Group definitions.
Table: affiliation | |||
| What | Registry Attribute | Values | Comments |
|---|---|---|---|
| Person Key | person_key | [numeric] | Foreign key. |
| Source | source_cd | student faculty staff user | The domain of values for some of the asociated attributes is constrained by the source. See tables below for details. |
| Source instance | source_instance | Instance/occurrence number of affiliation data. | |
| Type of affiliation | affiliation_cd | [see below] | |
| Affiliation qualifier | qualifier_cd | [see below] | |
| Department code | department_cd | Code from source system. | |
| Department RegId | department_regid | Registry ID for department (awaits development of the Organization Registry). | |
| Department name | department_name | Name of department as passed from source system. | |
| Description | description | [text] | Value determined by source, e.g., CHRIS sends a Job Title here. |
| Status date/time | affiliation_status_datetime | [date/time] | Date/time as received/processed by the Registry, not a date set by the source. |
| Is relationship current? | active_relationship_ind | Y N | This source/relationship information is not deleted when a specific source withdraws its other registry data. Instead we preserve the last values because this is useful in managing and reconciling information. This attribute indicates the current status of a source relative to the registry. |
| Last modified by | update_sunetid | [sunetid] | SUNet identity of person or program who last modified this data. |
| When last updated | update_datetime | [datetime] | The date and time this data was updated.. |
Expanded forms of the coded values -- affiliation, department, etc -- are passed to the directory for display. The coded values are passed as infrastructure attributes.
| ||
| Infrastructure Attributes | ||
|---|---|---|
| Attribute | Value | Comments |
| affiliation_cd | student | |
| qualifier_cd | [none]
notregistered nonactive incoming onleave contingent | |
| department_cd | e.g., M040 | |
| Public Attributes | ||
| Attribute | Value | Comments |
| affiliation | Student | |
| department | e.g., Biology Department | |
| description | e.g., Freshman | |
| ||
| Infrastructure Attributes | ||
|---|---|---|
| Attribute | Value | Comments |
| affiliation_cd | faculty | |
| qualifier_cd | [none]
emeritus retired | |
| department_cd | e.g., M040 | |
| Public Attributes | ||
| Registry Attribute | Value | Comments |
| affiliation | Faculty | |
| department | e.g., Art Department | |
| description | e.g., Professor | |
| ||
| Infrastructure Attributes | ||
|---|---|---|
| Attribute | Value | Comments |
| affiliation_cd | staff | |
| qualifier_cd | [none]
contingent emeritus retired | |
| department_cd | e.g., M040 | |
| Public Attributes | ||
| Registry Attribute | Value | Comments |
| affiliation | Staff | |
| department | e.g., Computing & Comm Services | |
| description | e.g., Computer System Spec | |