-- uses company structure
company/www/team/teams-tasks.tcl:company_structure_info_full
company/www/admin/team/add-edit.tcl:    set rm_list [db_list_of_lists get_rms "select initcap(pretty_member_name), member_id from company_structure_info where parent_group_name = 'Regional Managers' order by lower(pretty_member_name)"]
mycsm/www/admin/report-object-view-detailed.tcl:    from company_structure_info
projectcrew/www/sa-tree.tcl:    select distinct(parent_group_id) from company_structure_info where parent_group_name = 'District Managers'}]
projectcrew/www/messaging.tcl:    from company_structure_info csi,
projectcrew/www/admin/company-structure-upload.tcl:	from company_structure_info
projectcrew/www/admin/company-structure-display.tcl:    from company_structure_info_full s
projectcrew/www/admin/company-position-remove.tcl:    from company_structure_info_full
projectcrew/www/admin/stores-structure-manage.tcl:    from company_structure_info_full c 
projectcrew/www/admin/company-structure-manage.xql:    from company_structure_info_full
projectcrew/www/admin/company-position-manage.tcl:	{![db_string get_a_name "select 1 from company_structure_info_full where group_name = :group_name and group_id <> :group_id" -default 0]}
projectcrew/sql/postgresql/company-and-store-views.sql:drop view company_structure_info;
projectcrew/sql/postgresql/company-structure.sql:                      join company_structure_info_full c


******** can change to company_dm_sa_map
visacard-db/www/index.tcl
stores/www/change-sa.tcl:    from company_structure_info
stores/www/ae.tcl:    from company_structure_info

******** can remove
csi-audit/www/audit-view-summary.tcl:            left join company_structure_info i on
csi-audit/www/audit-view.tcl:            left join company_structure_info i on
csi-audit/www/audit-view.tcl:        LEFT OUTER JOIN company_structure_info i ON (s.dm_id = i.member_id and i.parent_group_name = 'District Managers'),
csi-audit/www/audit-view-summary.xql:        LEFT OUTER JOIN company_structure_info i ON (s.dm_id = i.member_id and i.parent_group_name = 'District Managers')
csi-audit/www/audit-view-summary.xql:        LEFT OUTER JOIN company_structure_info i ON (s.dm_id = i.member_id and i.parent_group_name = 'District Managers')

******** rels based
acs-admin/www/users/member-state-change.tcl:		from company_structure_info 
acs-admin/www/users/delete.tcl:	    from company_structure_info 
acs-admin/www/users/users-bulk-upload-2.tcl:		    from company_structure_info

******** can move to dm_info rm_info tables
jobs-db/www/job-apply.tcl:                 company_structure_info_full f, 
jobs-db/www/xmlhttp/controlpanel/form_wfperform.tcl:		         company_structure_info_full f2,
jobs-db/www/xmlhttp/controlpanel/data_reports_applicants.tcl:             left join company_structure_info_full c on (c.member_id = f.dm_id and c.parent_group_name = 'District Managers'),
jobs-db/tcl/report-procs.tcl:                 company_structure_info_full f2,
projectcrew/www/quick-search.tcl:     from company_structure_info
projectcrew/www/user-cal-nav.tcl:set rm_list [util_memoize {db_list_of_lists get_rum "select distinct(email) as dm_email, member_id as dm_id from company_structure_info where parent_group_name = 'Regional Managers'"} $max_age]
projectcrew/www/admin/dms-email.tcl:            from company_structure_info csi2
projectcrew/tcl/project-procs.tcl:     from company_structure_info i,


-- key on DM so just check if it still works
packages/csi-audit/www/audit-view.tcl
packages/projectcrew/www/admin/dms-email.tcl

-- key on SA so just check if it still works
packages/stores/www/change-sa.tcl
packages/stores/www/ae.tcl

-- key on RM so just check if it still works
packages/projectcrew/www/user-cal-nav.tcl

-- key on RM, DM, SA so just check if it still works
packages/projectcrew/www/sa-tree.tcl

-- uses full view but key on SA
-- needs thorough checking
* packages/company/www/team/teams-tasks.tcl
* packages/stores/www/update-from-csv.tcl

-- needs rewrite of views
packages/projectcrew/sql/postgresql/company-and-store-views.sql
packages/projectcrew/sql/postgresql/company-structure.sql

-- needs to check for PM support
packages/projectcrew/www/quick-search.tcl
packages/projectcrew/www/admin/company-structure-upload.tcl
packages/projectcrew/www/admin/company-structure-display.tcl
packages/projectcrew/www/admin/company-position-remove.tcl
packages/projectcrew/www/admin/stores-structure-manage.tcl
packages/projectcrew/www/admin/company-structure-manage.xql
packages/projectcrew/www/admin/company-position-manage.tcl
packages/mycsm/www/admin/report-object-view-detailed.tcl
packages/projectcrew/tcl/project-procs.tcl (used by autosuggest)

-- no change, PM support will be in another tab
packages/projectcrew/www/messaging.tcl