Postions Table

In a User's Profile, their Roles are selected. The Roles give these Users access to a different segments of the Site. The Positions Table further defines where or what the User can interact within a segment.

The Positions Table has entries for:

Type

Examples include ClubOfficer, LeagueOfficer, Assignor, Scheduler and Registrar. These are inputted and set by RidgeStar.

User

Any User in the database can be selected using the expand and contract (eliminate) buttons and the pull down. There is no restriction by Role.

Title

Currently this is for information purposes only and no logic is based on the Title.

Grouping

Within Grouping restricitons can be placed regarding AgeLevel, Gender, PlayingLeague, RegistrationLeague or Club

Example Type=ClubOfficer

For each Club there is a listing of the Club Officers. This listing is populated by Type=ClubOfficer and Grouping=name of Club. A User can be added in the Positions Table as a ClubOfficer, but not have access to the ClubOfficer segment. To get to the ClubOfficer segment the User must have a Role=ClubOfficer. A Club could have in their table of Officers someone without access to the ClubOfficer segment. Maybe the 'Corner flag manager' or 'Assistant to the Field Paint Storage Coordinator'

Example Type=LeagueOfficer

Identical to the ClubOfficer. Inclusion in the Positions Table as Type=LegueOfficer puts the User into the Information Contacts segment. For access to the LeagueOfficer segment, the User needs to have a Role=LeagueOfficer in their Profile.

Example Type=Assignor, Registrar, Scheduler

When a User has the Role of Assignor, Registrar or Scheduler they are given unlimited access to these Segments. To restrict access to portions of the database all Users with these Roles should also have Position Table entries. The Type=Assignor (or Type=Registrar or Type=Scheduler) . The Title doesn't matter. The Grouping entries then restrict which Matches (for Scheduler and Assignor) or which Teams and Users (for Registrar). the Positions Table User can modify. It is most common to restrict by Club, but it could be made for an Assignor to be responsible for only Abronzino U16 and above matches. .
To repeat

Users`with`these`Roles`should`also`have`Position`Table`entries.

Sequence

For ClubOfficers appearing in the Clubs segment or for LeagueOfficers appearing in the Information segment, the order that the entries appear can be set by the Sequence in the Positions Table. That is how you make the President appear at the top.