Occupational task exposures data formats
Occupational scenarios.
Download empty dataset template:
Occupational scenarios
Definitions of occupational exposure scenarios, described as combinations of different tasks/activities and task determinants (e.g., use of RPE).
Accepted table names: OccupationalScenarios.
| Name | Type | Description | Aliases | Required |
|---|---|---|---|---|
id |
AlphaNumeric (50) |
Identifier of specific scenario. |
id, idScenario, idOccupationalScenario |
Yes |
Name |
AlphaNumeric (100) |
The name of the scenario. |
Name |
No |
Description |
AlphaNumeric (200) |
Description of the scenario. |
Description |
No |
Occupational tasks
Definitions of occupational tasks.
Accepted table names: OccupationalTasks.
| Name | Type | Description | Aliases | Required |
|---|---|---|---|---|
id |
AlphaNumeric (50) |
Identifier of specific task. |
id, idTask, idOccupationalTask |
Yes |
Name |
AlphaNumeric (100) |
The name of the occupational task. |
Name |
No |
Description |
AlphaNumeric (200) |
Description of the occupational task. |
Description |
No |
Occupational scenario tasks
Table linking occupational tasks/activities to scenarios. I.e., describing what activities are part of a scenario, including details on task duration and other determinants (e.g., use of RPE), described via the contributing tasks relationship.
Accepted table names: OccupationalScenarioTasks, ScenarioTasks, ContributingScenarios.
| Name | Type | Description | Aliases | Required |
|---|---|---|---|---|
idOccupationalScenario |
AlphaNumeric (50) |
Reference to the scenario. |
idOccupationalScenario, idScenario |
Yes |
idOccupationalTask |
AlphaNumeric (50) |
Reference to the task that is part of the scenario. |
idOccupationalTask, idTask |
Yes |
Duration |
Numeric |
Duration of performing the task within this scenario. |
Duration |
Yes |
Frequency |
Numeric |
Frequency with which the task is executed within this scenario, specified in number of times per day/week/etc. The resolution of the frequency is specified by the frequency resolution field. |
Frequency |
Yes |
FrequencyResolution |
FrequencyResolutionType | Resolution of the specific task frequency (e.g. per day, per week, etc.). |
FrequencyResolution |
Yes |
RPE type |
RPEType | Type of RPE (e.g., None, RPE). If not specified then considered to be undefined. |
RPEType, RPE |
No |
Occupational task exposures
Exposure (percentile) estimates of the occupational tasks.
Accepted table names: OccupationalTaskExposures, TaskExposures.
| Name | Type | Description | Aliases | Required |
|---|---|---|---|---|
idOccupationalTask |
AlphaNumeric (50) |
Activity for which the estimate applies. |
idTask, idOccupationalTask |
Yes |
ExposureRoute |
ExposureRoute | The exposure route. |
ExposureRoute, Route |
Yes |
idSubstance |
AlphaNumeric (50) |
The code of the substance. |
idSubstance, SubstanceId, SubstanceCode, Substance |
Yes |
RPE type |
RPEType | Type of RPE considered for this activity exposure estimate. If not specified, then considered to be undefined. |
RPEType, RPE |
No |
Unit |
JobTaskExposureUnit | Unit of the estimate. |
Unit, JobTaskExposureUnit |
Yes |
ExposureType |
JobTaskExposureEstimateType | Type of the exposure estimate. |
ExposureType, EstimateType |
No |
Percentage |
Numeric |
The percentage to which the percentile value belongs. |
Percentage, Percentile |
Yes |
Value |
Numeric |
The percentile value. I.e., the exposure value belonging to the specified percentage. |
Value, Exposure |
Yes |
Reference |
AlphaNumeric (200) |
Reference to the source from which this exposure value is obtained. |
Reference, References, Source, Sources |
No |