Jobs The jobs table contains an inventory of jobs for the region. It is usually derived from either ES202 Unemployment Insurance data which monitor businesses by state for unemployment insurance purposes (and have had issues historically with under-reporting self-employed and proprietor employment, and also with headquarter reporting of jobs in multi-establishment firms) or from commercial sources such as InfoUSA (which have different issues of rolling updates).
| Column Name | Data Type | Required | Description |
|---|---|---|---|
| job_id | Integer | Y | Unique id for each job |
| building_id | Integer | Y | Unique id for the building in which the job is located |
| home_based_status | Integer | Y | 1 if the job is home-based, 0 otherwise |
| sector_id | Integer | Y | Unique id of the employment sector of the job |
Topic revision: r3 - 05 Jan 2010 - 15:30:47 - JesseAyers
Create New Topic
Index
Search
Changes
Notifications
RSS Feed
Statistics
Preferences
Community |
|
Copyright © by the contributing authors. All material on this collaboration platform is the property of the contributing authors. Ideas, requests, problems regarding Foswiki? Send feedback