The employment_adhoc_sector_groups table

Each row defines one EmploymentAdHocSectorGroup, but not the group's membership - the memberships are defined in the employment_adhoc_sector_group_definitions table.

Column Name	Data Type	Description
group_id	integer	Unique identifier
name	varchar	Unique name of the Group

• group_id must be unique and greater than zero
• name must be unique. The required employment ad hoc sector groups must be lower case with underscores between words, e.g. lower_case_with_underscores_between_words. We recommend that all names follow this style.

For example, if we had an ad-hoc group ``retail'' that included sectors id=56 ``automobile_sales'', id=29 ``department_store_sales'', and id=38 ``wireless_phone_sales'', and another group ``transportation'' that included sectors ``automobile_sales'' and id=6 ``trucking'', these tables would be:

|employment_adhoc_sector_groups|
group_id	name
1	``retail''
2	``transportation''

|employment_adhoc_sector_group_definitions|
sector_id	group_id
1	56
1	29
2	29
1	38
2	6

Required |employment_adhoc_sector_groups|

If a model is used in the simulation, then for each of the groups it requires there must be a single row with its name equal to the name of the group. The comparison is case-insensitive and insensitive to leading and trailing spaces. For example, both `` basic'' and ``basic'' would be fine.

The following groups are required for these models:

• Employment Location Choice Model
  • basic
  • retail
  • service

• Employment Non-Home-Based Location Choice Model
  • basic
  • retail
  • service
  • elc_sector

• Scaling Procedure for Jobs Model
  • scalable_sectors

• Household Location Choice Model
  • retail