Overview
Following is an overview of the Local Contact (LC) lookup subsystem on both GAE sites. The Local Contact system is a tool used by users to find GAE contacts assigned to a Local including President, Center staff, Board members, UD's and AR's.
The Local Contact system is almost the same on both sites although the Private site has additional data band functionality since it is used by other subsystems that are "not" offered on the Public site such as the Purge/Verify subsystem.
Structure
The Local Contact system is made up of five major database tables:
1. Local table (loc 0n Private; localassociation on Public)) Contains list of all Local & SGAE's including the Uniserv Dir, District, Center, etc.
2. Director table (locDir) Contains contact information of all Uniserv Directors.
3. Board table (locBoard) Contains contact info on the Board of Directors.
4. Center table (locCenter) Contains Center admin contact information.
5. Roles table (RolesXref) Contains info on all GAE governance including Board, LAP's, UD's, AR's, etc.
Updating the tables
The various tables are updated in different ways. The biggest difference by far is how the Roles table (RoleXref) is updated.
1. Mass Updating of the Role (RolesXref) table Weekly this table is updated using a Role extract that is downloaded from NEA's I&A system. It's important that this continue because the extract consists of over 3000 records and it's a collection of updates made throughtout GAE.
The Role extract conatins all GAE governance including (Board, Presidents, Staff,Committees, D's, AR's, etc. The RolesXref table on the Public site is used to by GAE IT staff to update the inhouse email and phone directories.An XML script is run weekly on the web to extract a list of Presidents and AR's.See "Updating with Extracts" for details.
2. Individual table updating All other tables are mainly updated via edit screens in the Admin Control Panel (ACP). The links are:
a.Local Associations
b.Local Boards
c.Local Centers
d.Local Directors
e.Local Presidents (No longer used)
These tables are updated manually mainly because it is not practical to automate using NEA Extracts.Each of these links will be discussed in separate How To pages.
3. Year end Mass Updating At yearend and when redistricting occurs, there are
normally a fair amount of changes.These are normally done by downloading the database and updating the tables directly using MS Access. Access allows the tables to be viewed and updated in a process very similar to updating an excel spreadsheet.
4. Special Role Override Updating As mentioned earlier, the Purge/Verify system uses the Role (RolesXref) table to determine who can access various rosters and update screens.This function has more to do with Purge/Verify than the Local Contact system.See "How to Override Roles" for details.
Pages that Use the Tables
Following is a list of screens that are mainly associated with the Local Contact Lookup:
1. Local Assoc Update (admin_locassoc.asp) Allows direct updating of the Local table
2. Board Update (admin_locboard.asp) Allows direct updating of the Board table.
3. UD Update (admin_locdir.asp) Allows direct updating of the UD table.
4. Center Update (admin_loccenter.asp) Allows direct updating of the Center table.
5. Local Contact (search_assoc.asp) Both sites have a version of this web page and allow users to select a Local and display various contacts such as President, Center, UD, etc.
6. AR List (rpt_locARList.asp) This link is displayed on the Local Contact Result page. When selected, it lists all AR's for the selected Local.
7. Service Centers (rpt_cenlist.asp) On the Private site, you may view Staff assigned to a
a.Association Information (Main menu)
b.Service Centers (Sub menu)
c.Metro, North, West or Metro (Menu item)
d,Staff link
***Note***
There are various inter dependencies between the tables. The Local table is the key in that it contains keys to pull corresponding data from the Center, UD, Board and RolesXref tables for a Local.