pecos_enrollment_specialty

Primary Key:

• enrollment_id
• start_date
• end_date

Checks:

• pecos_enrollment_specialty_secondary_specialty_codes_check - claims.is_sorted_text_array(secondary_specialty_codes)

Foreign Keys:

• enrollment_id => pecos_enrollment.enrollment_id
• primary_specialty_code => pecos_specialty_type_lookup.specialty_type_code

Indexes:

• pecos_enrollment_specialty_code_idx - primary_specialty_code
• pecos_enrollment_specialty_enrollment_id_idx - enrollment_id
• pecos_enrollment_specialty_overlapping_dates_excl - enrollment_id, daterange(start_date, end_date, '[)'::text)

Column	Data Type	Nullable	Indexed	Description
enrollment_id	text	No	Yes	Unique ID assigned to each new provider enrollment application Generated through expression:
primary_specialty_code	text	No	Yes	Primary specialty type code Generated through expression:
secondary_specialty_codes	text[]	No	No	Secondary specialty type codes Generated through expression:
start_date	date	No	Yes	- Generated through expression:
end_date	date	No	Yes	- Generated through expression: