Person Unit Relationships

A person unit relationship (PUR) assigns a person to a given unit.  In order to register for courses or register people for courses, a PUR is required.  When an active PUR is available, the session dashboard will show each unit available to the user.

When a person is created using the Unit User > My People page or Mass Additions, the PUR is created automatically. If a person is created under Camp User > People page, the PUR must be created manually.

Navigation
  • Unit User Top Menu > Mass Additions
  • Unit User > My People
  • Camp User > People
Validations
  • The start date must begin before the end date. Both must be valid dates. Microsoft SQL Server defaults empty dates to 01/01/1753 for the beginning of time, and 12/31/9999 for the end of time. These dates will be defaulted in the database record if left blank.
  • Active Organization is required.
  • Active Unit is required.
  • Active Person is required.
  • The PUR can only exist once for a person, unit, region, and organization.
Structure Definition
Person Unit Relationship Attribute Definition
PersonUnitRelID Unique Identifier for the Person Unit Record.
PersonID Person ID of the person being assigned.
PersonFullName Full Name of the Person
OrganizationID Organization of the Unit being Assigned.
UnitID Unit ID of the unit being assigned.
UnitCode Unit Code of the unit being assigned.
RegionID Region ID of the region being assigned.
RegionCode Region Code of the region being assigned.
ActiveFlag Active Yes or No
StartDate The beginning date the assignment should be active. This should be the date you want a person to show up for course registration.
EndDate The end date the assignment should be active. This should be the date you want a person to end an assignment to an organization.
CreateDate The date the record was created.
CreatedBy The user that created the record.
LastUpdateDate The date the record was last updated.
LastUpdatedBy The user that last updated the record.
Related Topics
Maintaining People
Person Org Relationships