occupation_record

A single job or role carried out by an individual during a specified period of time.

A single job or role carried out by an individual during a specified period of time.

Purpose. To record details about a single job or role carried out by an individual during a specified period of time.

Source

Columns

Constraints

check ((job_title_role_code is null and job_title_role_system is null and job_title_role_valueset_id is null) or (job_title_role is not null and job_title_role_code is not null and job_title_role_system is not null and job_title_role_valueset_id is not null))
check ((paid_employment_status_code is null and paid_employment_status_system is null and paid_employment_status_valueset_id is null) or (paid_employment_status is not null and paid_employment_status_code is not null and paid_employment_status_system is not null and paid_employment_status_valueset_id is not null))
check ((full_time_equivalent_coded_text_code is null and full_time_equivalent_coded_text_system is null and full_time_equivalent_coded_text_valueset_id is null) or (full_time_equivalent_coded_text is not null and full_time_equivalent_coded_text_code is not null and full_time_equivalent_coded_text_system is not null and full_time_equivalent_coded_text_valueset_id is not null))
check ((full_time_equivalent_proportion_numerator is null and full_time_equivalent_proportion_denominator is null) or (full_time_equivalent_proportion_numerator is not null and full_time_equivalent_proportion_denominator is not null))
check (full_time_equivalent_proportion_denominator is null or full_time_equivalent_proportion_denominator <> 0)
check (full_time_equivalent_proportion_denominator is null or full_time_equivalent_proportion_denominator = 100)
check (full_time_equivalent_proportion_numerator is null or full_time_equivalent_proportion_numerator >= 0)
check (num_nonnulls(full_time_equivalent_coded_text, full_time_equivalent_proportion_numerator) <= 1)
check ((time_allocated_magnitude is null and time_allocated_units is null) or (time_allocated_magnitude is not null and time_allocated_units is not null))
check (time_allocated_magnitude is null or (time_allocated_units = 'h/d' and time_allocated_magnitude >= 0) or (time_allocated_units = 'h/wk' and time_allocated_magnitude >= 0) or (time_allocated_units = 'h/mo' and time_allocated_magnitude >= 0) or (time_allocated_units = 'h/a' and time_allocated_magnitude >= 0) or (time_allocated_units = 'd/wk' and time_allocated_magnitude >= 0) or (time_allocated_units = 'd/mo' and time_allocated_magnitude >= 0) or (time_allocated_units = 'wk/mo' and time_allocated_magnitude >= 0) or (time_allocated_units = 'd/a' and time_allocated_magnitude >= 0) or (time_allocated_units = 'wk/a' and time_allocated_magnitude >= 0) or (time_allocated_units = 'mo/a' and time_allocated_magnitude >= 0))
check ((industry_category_code is null and industry_category_system is null and industry_category_valueset_id is null) or (industry_category is not null and industry_category_code is not null and industry_category_system is not null and industry_category_valueset_id is not null))
check ((job_category_code is null and job_category_system is null and job_category_valueset_id is null) or (job_category is not null and job_category_code is not null and job_category_system is not null and job_category_valueset_id is not null))

References

Referenced by

• occupation_record_organisation_details via occupation_record_id
• occupation_summary_occupation_episode via occupation_record_id

Child tables

1 table hang off occupation_record, one row per repetition.

occupation_record_organisation_details

Child table — one row per repetition, deleted with its parent.

Unique

• occupation_record_id, position
• occupation_record_id, organization_id

References

Indexes

• occupation_record_organisation_details_organization_id_idx on organization_id

Value sets