pyomop.cdm6 package

Submodules

pyomop.cdm6.cdm6_tables module

Derivative based on the original work here: https://github.com/thehyve/omop-cdm/blob/main/src/omop_cdm/regular/cdm600/tables.py Modifications made to this file: - Removed support for schema. - Added new tables

  • Licensed under the Apache License, Version 2.0 (the “License”);

  • you may not use this file except in compliance with the License.

  • You may obtain a copy of the License at

  • https://www.apache.org/licenses/LICENSE-2.0

  • Unless required by applicable law or agreed to in writing, software

  • distributed under the License is distributed on an “AS IS” BASIS,

  • WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.

  • See the License for the specific language governing permissions and

  • limitations under the License.

class pyomop.cdm6.cdm6_tables.AttributeDefinition(**kwargs)[source]

Bases: Base

attribute_definition_id: Mapped[int]
attribute_description: Mapped[str]
attribute_name: Mapped[str]
attribute_syntax: Mapped[str]
attribute_type_concept_id: Mapped[int]
class pyomop.cdm6.cdm6_tables.Base(**kwargs: Any)[source]

Bases: DeclarativeBase

metadata: ClassVar[MetaData] = MetaData()

Refers to the _schema.MetaData collection that will be used for new _schema.Table objects.

See also

orm_declarative_metadata

registry: ClassVar[_RegistryType] = <sqlalchemy.orm.decl_api.registry object>

Refers to the _orm.registry in use where new _orm.Mapper objects will be associated.

class pyomop.cdm6.cdm6_tables.CareSite(**kwargs)[source]

Bases: Base

care_site_id: Mapped[int]
care_site_name: Mapped[str | None]
care_site_source_value: Mapped[str | None]
location: Mapped[Location]
location_id: Mapped[int | None]
place_of_service_concept: Mapped[Concept]
place_of_service_concept_id: Mapped[int]
place_of_service_source_value: Mapped[str | None]
class pyomop.cdm6.cdm6_tables.CdmSource(**kwargs)[source]

Bases: Base

cdm_etl_reference: Mapped[str | None]
cdm_holder: Mapped[str | None]
cdm_release_date: Mapped[date | None]
cdm_source_abbreviation: Mapped[str | None]
cdm_source_name: Mapped[str]
cdm_version: Mapped[str | None]
source_description: Mapped[str | None]
source_documentation_reference: Mapped[str | None]
source_release_date: Mapped[date | None]
vocabulary_version: Mapped[str | None]
class pyomop.cdm6.cdm6_tables.Cohort(**kwargs)[source]

Bases: Base

cohort_definition_id: Mapped[int]
cohort_end_date: Mapped[str]
cohort_start_date: Mapped[str]
subject_id: Mapped[int]
class pyomop.cdm6.cdm6_tables.CohortAttribute(**kwargs)[source]

Bases: Base

attribute_definition_id: Mapped[int]
cohort_definition_id: Mapped[int]
cohort_end_date: Mapped[str]
cohort_start_date: Mapped[str]
subject_id: Mapped[int]
value_as_concept_id: Mapped[int]
value_as_number: Mapped[Decimal]
class pyomop.cdm6.cdm6_tables.CohortDefinition(**kwargs)[source]

Bases: Base

cohort_definition_description: Mapped[str]
cohort_definition_id: Mapped[int]
cohort_definition_name: Mapped[str]
cohort_definition_syntax: Mapped[str]
cohort_initiation_date: Mapped[str]
definition_type_concept_id: Mapped[int]
subject_concept_id: Mapped[int]
class pyomop.cdm6.cdm6_tables.Concept(**kwargs)[source]

Bases: Base

concept_class: Mapped[ConceptClass]
concept_class_id: Mapped[str]
concept_code: Mapped[str]
concept_id: Mapped[int]
concept_name: Mapped[str]
domain: Mapped[Domain]
domain_id: Mapped[str]
invalid_reason: Mapped[str | None]
standard_concept: Mapped[str | None]
valid_end_date: Mapped[date]
valid_start_date: Mapped[date]
vocabulary: Mapped[Vocabulary]
vocabulary_id: Mapped[str]
class pyomop.cdm6.cdm6_tables.ConceptAncestor(**kwargs)[source]

Bases: Base

ancestor_concept: Mapped[Concept]
ancestor_concept_id: Mapped[int]
descendant_concept: Mapped[Concept]
descendant_concept_id: Mapped[int]
max_levels_of_separation: Mapped[int]
min_levels_of_separation: Mapped[int]
class pyomop.cdm6.cdm6_tables.ConceptClass(**kwargs)[source]

Bases: Base

concept_class_concept: Mapped[Concept]
concept_class_concept_id: Mapped[int]
concept_class_id: Mapped[str]
concept_class_name: Mapped[str]
class pyomop.cdm6.cdm6_tables.ConceptRelationship(**kwargs)[source]

Bases: Base

concept_1: Mapped[Concept]
concept_2: Mapped[Concept]
concept_id_1: Mapped[int]
concept_id_2: Mapped[int]
invalid_reason: Mapped[str | None]
relationship: Mapped[Relationship]
relationship_id: Mapped[str]
valid_end_date: Mapped[date]
valid_start_date: Mapped[date]
class pyomop.cdm6.cdm6_tables.ConceptSynonym(**kwargs)[source]

Bases: Base

concept: Mapped[Concept]
concept_id: Mapped[int]
concept_synonym_name: Mapped[str]
language_concept: Mapped[Concept]
language_concept_id: Mapped[int]
class pyomop.cdm6.cdm6_tables.ConditionEra(**kwargs)[source]

Bases: Base

condition_concept: Mapped[Concept]
condition_concept_id: Mapped[int]
condition_era_end_datetime: Mapped[datetime]
condition_era_id: Mapped[int]
condition_era_start_datetime: Mapped[datetime]
condition_occurrence_count: Mapped[int | None]
person: Mapped[Person]
person_id: Mapped[int]
class pyomop.cdm6.cdm6_tables.ConditionOccurrence(**kwargs)[source]

Bases: Base

condition_concept: Mapped[Concept]
condition_concept_id: Mapped[int]
condition_end_date: Mapped[date | None]
condition_end_datetime: Mapped[datetime | None]
condition_occurrence_id: Mapped[int]
condition_source_concept: Mapped[Concept]
condition_source_concept_id: Mapped[int]
condition_source_value: Mapped[str | None]
condition_start_date: Mapped[date | None]
condition_start_datetime: Mapped[datetime]
condition_status_concept: Mapped[Concept]
condition_status_concept_id: Mapped[int]
condition_status_source_value: Mapped[str | None]
condition_type_concept: Mapped[Concept]
condition_type_concept_id: Mapped[int]
person: Mapped[Person]
person_id: Mapped[int]
provider: Mapped[Provider]
provider_id: Mapped[int | None]
stop_reason: Mapped[str | None]
visit_detail: Mapped[VisitDetail]
visit_detail_id: Mapped[int | None]
visit_occurrence: Mapped[VisitOccurrence]
visit_occurrence_id: Mapped[int | None]
class pyomop.cdm6.cdm6_tables.Cost(**kwargs)[source]

Bases: Base

billed_date: Mapped[date | None]
cost: Mapped[Decimal | None]
cost_concept: Mapped[Concept]
cost_concept_id: Mapped[int]
cost_event_field_concept_id: Mapped[int]
cost_event_id: Mapped[int]
cost_id: Mapped[int]
cost_source_concept: Mapped[Concept]
cost_source_concept_id: Mapped[int]
cost_source_value: Mapped[str | None]
cost_type_concept: Mapped[Concept]
cost_type_concept_id: Mapped[int]
currency_concept: Mapped[Concept]
currency_concept_id: Mapped[int]
drg_concept: Mapped[Concept]
drg_concept_id: Mapped[int]
drg_source_value: Mapped[str | None]
incurred_date: Mapped[date]
paid_date: Mapped[date | None]
payer_plan_period: Mapped[PayerPlanPeriod]
payer_plan_period_id: Mapped[int | None]
person: Mapped[Person]
person_id: Mapped[int]
revenue_code_concept: Mapped[Concept]
revenue_code_concept_id: Mapped[int]
revenue_code_source_value: Mapped[str | None]
class pyomop.cdm6.cdm6_tables.DeviceCost(**kwargs)[source]

Bases: Base

currency_concept_id: Mapped[int]
device_cost_id: Mapped[int]
device_exposure_id: Mapped[int]
paid_by_coordination_benefits: Mapped[Decimal]
paid_by_payer: Mapped[Decimal]
paid_coinsurance: Mapped[Decimal]
paid_copay: Mapped[Decimal]
paid_toward_deductible: Mapped[Decimal]
payer_plan_period_id: Mapped[int]
total_out_of_pocket: Mapped[Decimal]
total_paid: Mapped[Decimal]
class pyomop.cdm6.cdm6_tables.DeviceExposure(**kwargs)[source]

Bases: Base

device_concept: Mapped[Concept]
device_concept_id: Mapped[int]
device_exposure_end_date: Mapped[date | None]
device_exposure_end_datetime: Mapped[datetime | None]
device_exposure_id: Mapped[int]
device_exposure_start_date: Mapped[date | None]
device_exposure_start_datetime: Mapped[datetime]
device_source_concept: Mapped[Concept]
device_source_concept_id: Mapped[int]
device_source_value: Mapped[str | None]
device_type_concept: Mapped[Concept]
device_type_concept_id: Mapped[int]
person: Mapped[Person]
person_id: Mapped[int]
provider: Mapped[Provider]
provider_id: Mapped[int | None]
quantity: Mapped[int | None]
unique_device_id: Mapped[str | None]
visit_detail: Mapped[VisitDetail]
visit_detail_id: Mapped[int | None]
visit_occurrence: Mapped[VisitOccurrence]
visit_occurrence_id: Mapped[int | None]
class pyomop.cdm6.cdm6_tables.Domain(**kwargs)[source]

Bases: Base

domain_concept: Mapped[Concept]
domain_concept_id: Mapped[int]
domain_id: Mapped[str]
domain_name: Mapped[str]
class pyomop.cdm6.cdm6_tables.DoseEra(**kwargs)[source]

Bases: Base

dose_era_end_datetime: Mapped[datetime]
dose_era_id: Mapped[int]
dose_era_start_datetime: Mapped[datetime]
dose_value: Mapped[Decimal]
drug_concept: Mapped[Concept]
drug_concept_id: Mapped[int]
person: Mapped[Person]
person_id: Mapped[int]
unit_concept: Mapped[Concept]
unit_concept_id: Mapped[int]
class pyomop.cdm6.cdm6_tables.DrugCost(**kwargs)[source]

Bases: Base

average_wholesale_price: Mapped[Decimal]
currency_concept_id: Mapped[int]
dispensing_fee: Mapped[Decimal]
drug_cost_id: Mapped[int]
drug_exposure_id: Mapped[int]
ingredient_cost: Mapped[Decimal]
paid_by_coordination_benefits: Mapped[Decimal]
paid_by_payer: Mapped[Decimal]
paid_coinsurance: Mapped[Decimal]
paid_copay: Mapped[Decimal]
paid_toward_deductible: Mapped[Decimal]
payer_plan_period_id: Mapped[int]
total_out_of_pocket: Mapped[Decimal]
total_paid: Mapped[Decimal]
class pyomop.cdm6.cdm6_tables.DrugEra(**kwargs)[source]

Bases: Base

drug_concept: Mapped[Concept]
drug_concept_id: Mapped[int]
drug_era_end_datetime: Mapped[datetime]
drug_era_id: Mapped[int]
drug_era_start_datetime: Mapped[datetime]
drug_exposure_count: Mapped[int | None]
gap_days: Mapped[int | None]
person: Mapped[Person]
person_id: Mapped[int]
class pyomop.cdm6.cdm6_tables.DrugExposure(**kwargs)[source]

Bases: Base

days_supply: Mapped[int | None]
dose_unit_source_value: Mapped[str | None]
drug_concept: Mapped[Concept]
drug_concept_id: Mapped[int]
drug_exposure_end_date: Mapped[date | None]
drug_exposure_end_datetime: Mapped[datetime]
drug_exposure_id: Mapped[int]
drug_exposure_start_date: Mapped[date | None]
drug_exposure_start_datetime: Mapped[datetime]
drug_source_concept: Mapped[Concept]
drug_source_concept_id: Mapped[int]
drug_source_value: Mapped[str | None]
drug_type_concept: Mapped[Concept]
drug_type_concept_id: Mapped[int]
lot_number: Mapped[str | None]
person: Mapped[Person]
person_id: Mapped[int]
provider: Mapped[Provider]
provider_id: Mapped[int | None]
quantity: Mapped[Decimal | None]
refills: Mapped[int | None]
route_concept: Mapped[Concept]
route_concept_id: Mapped[int]
route_source_value: Mapped[str | None]
sig: Mapped[str | None]
stop_reason: Mapped[str | None]
verbatim_end_date: Mapped[date | None]
visit_detail: Mapped[VisitDetail]
visit_detail_id: Mapped[int | None]
visit_occurrence: Mapped[VisitOccurrence]
visit_occurrence_id: Mapped[int | None]
class pyomop.cdm6.cdm6_tables.DrugStrength(**kwargs)[source]

Bases: Base

amount_unit_concept: Mapped[Concept]
amount_unit_concept_id: Mapped[int | None]
amount_value: Mapped[Decimal | None]
box_size: Mapped[int | None]
denominator_unit_concept: Mapped[Concept]
denominator_unit_concept_id: Mapped[int | None]
denominator_value: Mapped[Decimal | None]
drug_concept: Mapped[Concept]
drug_concept_id: Mapped[int]
ingredient_concept: Mapped[Concept]
ingredient_concept_id: Mapped[int]
invalid_reason: Mapped[str | None]
numerator_unit_concept: Mapped[Concept]
numerator_unit_concept_id: Mapped[int | None]
numerator_value: Mapped[Decimal | None]
valid_end_date: Mapped[date]
valid_start_date: Mapped[date]
class pyomop.cdm6.cdm6_tables.FactRelationship(**kwargs)[source]

Bases: Base

domain_concept_1: Mapped[Concept]
domain_concept_2: Mapped[Concept]
domain_concept_id_1: Mapped[int]
domain_concept_id_2: Mapped[int]
fact_id_1: Mapped[int]
fact_id_2: Mapped[int]
fact_relationship_id: Mapped[int]
relationship_concept: Mapped[Concept]
relationship_concept_id: Mapped[int]
class pyomop.cdm6.cdm6_tables.Location(**kwargs)[source]

Bases: Base

address_1: Mapped[str | None]
address_2: Mapped[str | None]
city: Mapped[str | None]
country: Mapped[str | None]
county: Mapped[str | None]
latitude: Mapped[Decimal | None]
location_id: Mapped[int]
location_source_value: Mapped[str | None]
longitude: Mapped[Decimal | None]
region_concept: Mapped[Concept]
region_concept_id: Mapped[int | None]
state: Mapped[str | None]
zip: Mapped[str | None]
class pyomop.cdm6.cdm6_tables.LocationHistory(**kwargs)[source]

Bases: Base

domain_id: Mapped[str]
end_date: Mapped[date | None]
entity_id: Mapped[int]
location: Mapped[Location]
location_history_id: Mapped[int]
location_id: Mapped[int]
relationship_type_concept: Mapped[Concept]
relationship_type_concept_id: Mapped[int]
start_date: Mapped[date]
class pyomop.cdm6.cdm6_tables.Measurement(**kwargs)[source]

Bases: Base

measurement_concept: Mapped[Concept]
measurement_concept_id: Mapped[int]
measurement_date: Mapped[date | None]
measurement_datetime: Mapped[datetime]
measurement_id: Mapped[int]
measurement_source_concept: Mapped[Concept]
measurement_source_concept_id: Mapped[int]
measurement_source_value: Mapped[str | None]
measurement_time: Mapped[str | None]
measurement_type_concept: Mapped[Concept]
measurement_type_concept_id: Mapped[int]
operator_concept: Mapped[Concept]
operator_concept_id: Mapped[int | None]
person: Mapped[Person]
person_id: Mapped[int]
provider: Mapped[Provider]
provider_id: Mapped[int | None]
range_high: Mapped[Decimal | None]
range_low: Mapped[Decimal | None]
unit_concept: Mapped[Concept]
unit_concept_id: Mapped[int | None]
unit_source_value: Mapped[str | None]
value_as_concept: Mapped[Concept]
value_as_concept_id: Mapped[int | None]
value_as_number: Mapped[Decimal | None]
value_source_value: Mapped[str | None]
visit_detail: Mapped[VisitDetail]
visit_detail_id: Mapped[int | None]
visit_occurrence: Mapped[VisitOccurrence]
visit_occurrence_id: Mapped[int | None]
class pyomop.cdm6.cdm6_tables.Metadata(**kwargs)[source]

Bases: Base

metadata_concept_id: Mapped[int]
metadata_date: Mapped[date | None]
metadata_datetime: Mapped[datetime | None]
metadata_type_concept_id: Mapped[int]
name: Mapped[str]
value_as_concept_id: Mapped[int | None]
value_as_string: Mapped[str | None]
class pyomop.cdm6.cdm6_tables.Note(**kwargs)[source]

Bases: Base

encoding_concept: Mapped[Concept]
encoding_concept_id: Mapped[int]
language_concept: Mapped[Concept]
language_concept_id: Mapped[int]
note_class_concept: Mapped[Concept]
note_class_concept_id: Mapped[int]
note_date: Mapped[date | None]
note_datetime: Mapped[datetime]
note_event_field_concept_id: Mapped[int]
note_event_id: Mapped[int | None]
note_id: Mapped[int]
note_source_value: Mapped[str | None]
note_text: Mapped[str]
note_title: Mapped[str | None]
note_type_concept: Mapped[Concept]
note_type_concept_id: Mapped[int]
person: Mapped[Person]
person_id: Mapped[int]
provider: Mapped[Provider]
provider_id: Mapped[int | None]
visit_detail: Mapped[VisitDetail]
visit_detail_id: Mapped[int | None]
visit_occurrence: Mapped[VisitOccurrence]
visit_occurrence_id: Mapped[int | None]
class pyomop.cdm6.cdm6_tables.NoteNlp(**kwargs)[source]

Bases: Base

lexical_variant: Mapped[str]
nlp_date: Mapped[date]
nlp_datetime: Mapped[datetime | None]
nlp_system: Mapped[str | None]
note: Mapped[Note]
note_id: Mapped[int]
note_nlp_concept: Mapped[Concept]
note_nlp_concept_id: Mapped[int]
note_nlp_id: Mapped[int]
note_nlp_source_concept: Mapped[Concept]
note_nlp_source_concept_id: Mapped[int]
offset: Mapped[str | None]
section_concept: Mapped[Concept]
section_concept_id: Mapped[int]
snippet: Mapped[str | None]
term_exists: Mapped[str | None]
term_modifiers: Mapped[str | None]
term_temporal: Mapped[str | None]
class pyomop.cdm6.cdm6_tables.Observation(**kwargs)[source]

Bases: Base

obs_event_field_concept: Mapped[Concept]
obs_event_field_concept_id: Mapped[int]
observation_concept: Mapped[Concept]
observation_concept_id: Mapped[int]
observation_date: Mapped[date | None]
observation_datetime: Mapped[datetime]
observation_event_id: Mapped[int | None]
observation_id: Mapped[int]
observation_source_concept: Mapped[Concept]
observation_source_concept_id: Mapped[int]
observation_source_value: Mapped[str | None]
observation_type_concept: Mapped[Concept]
observation_type_concept_id: Mapped[int]
person: Mapped[Person]
person_id: Mapped[int]
provider: Mapped[Provider]
provider_id: Mapped[int | None]
qualifier_concept: Mapped[Concept]
qualifier_concept_id: Mapped[int | None]
qualifier_source_value: Mapped[str | None]
unit_concept: Mapped[Concept]
unit_concept_id: Mapped[int | None]
unit_source_value: Mapped[str | None]
value_as_concept: Mapped[Concept]
value_as_concept_id: Mapped[int | None]
value_as_datetime: Mapped[datetime | None]
value_as_number: Mapped[Decimal | None]
value_as_string: Mapped[str | None]
visit_detail: Mapped[VisitDetail]
visit_detail_id: Mapped[int | None]
visit_occurrence: Mapped[VisitOccurrence]
visit_occurrence_id: Mapped[int | None]
class pyomop.cdm6.cdm6_tables.ObservationPeriod(**kwargs)[source]

Bases: Base

observation_period_end_date: Mapped[date]
observation_period_id: Mapped[int]
observation_period_start_date: Mapped[date]
period_type_concept: Mapped[Concept]
period_type_concept_id: Mapped[int]
person: Mapped[Person]
person_id: Mapped[int]
class pyomop.cdm6.cdm6_tables.PayerPlanPeriod(**kwargs)[source]

Bases: Base

contract_concept: Mapped[Concept]
contract_concept_id: Mapped[int]
contract_person: Mapped[Person]
contract_person_id: Mapped[int | None]
contract_source_concept: Mapped[Concept]
contract_source_concept_id: Mapped[int]
contract_source_value: Mapped[str | None]
family_source_value: Mapped[str | None]
payer_concept: Mapped[Concept]
payer_concept_id: Mapped[int]
payer_plan_period_end_date: Mapped[date]
payer_plan_period_id: Mapped[int]
payer_plan_period_start_date: Mapped[date]
payer_source_concept: Mapped[Concept]
payer_source_concept_id: Mapped[int]
payer_source_value: Mapped[str | None]
person: Mapped[Person]
person_id: Mapped[int]
plan_concept: Mapped[Concept]
plan_concept_id: Mapped[int]
plan_source_concept: Mapped[Concept]
plan_source_concept_id: Mapped[int]
plan_source_value: Mapped[str | None]
sponsor_concept: Mapped[Concept]
sponsor_concept_id: Mapped[int]
sponsor_source_concept: Mapped[Concept]
sponsor_source_concept_id: Mapped[int]
sponsor_source_value: Mapped[str | None]
stop_reason_concept: Mapped[Concept]
stop_reason_concept_id: Mapped[int]
stop_reason_source_concept: Mapped[Concept]
stop_reason_source_concept_id: Mapped[int]
stop_reason_source_value: Mapped[str | None]
class pyomop.cdm6.cdm6_tables.Person(**kwargs)[source]

Bases: Base

birth_datetime: Mapped[datetime | None]
care_site: Mapped[CareSite]
care_site_id: Mapped[int | None]
day_of_birth: Mapped[int | None]
death_datetime: Mapped[datetime | None]
ethnicity_concept: Mapped[Concept]
ethnicity_concept_id: Mapped[int]
ethnicity_source_concept: Mapped[Concept]
ethnicity_source_concept_id: Mapped[int]
ethnicity_source_value: Mapped[str | None]
gender_concept: Mapped[Concept]
gender_concept_id: Mapped[int]
gender_source_concept: Mapped[Concept]
gender_source_concept_id: Mapped[int]
gender_source_value: Mapped[str | None]
location: Mapped[Location]
location_id: Mapped[int | None]
month_of_birth: Mapped[int | None]
person_id: Mapped[int]
person_source_value: Mapped[str | None]
provider: Mapped[Provider]
provider_id: Mapped[int | None]
race_concept: Mapped[Concept]
race_concept_id: Mapped[int]
race_source_concept: Mapped[Concept]
race_source_concept_id: Mapped[int]
race_source_value: Mapped[str | None]
year_of_birth: Mapped[int]
class pyomop.cdm6.cdm6_tables.ProcedureCost(**kwargs)[source]

Bases: Base

currency_concept_id: Mapped[int]
paid_by_coordination_benefits: Mapped[Decimal]
paid_by_payer: Mapped[Decimal]
paid_coinsurance: Mapped[Decimal]
paid_copay: Mapped[Decimal]
paid_toward_deductible: Mapped[Decimal]
payer_plan_period_id: Mapped[int]
procedure_cost_id: Mapped[int]
procedure_occurrence_id: Mapped[int]
revenue_code_concept_id: Mapped[int]
revenue_code_source_value: Mapped[str]
total_out_of_pocket: Mapped[Decimal]
total_paid: Mapped[Decimal]
class pyomop.cdm6.cdm6_tables.ProcedureOccurrence(**kwargs)[source]

Bases: Base

modifier_concept: Mapped[Concept]
modifier_concept_id: Mapped[int]
modifier_source_value: Mapped[str | None]
person: Mapped[Person]
person_id: Mapped[int]
procedure_concept: Mapped[Concept]
procedure_concept_id: Mapped[int]
procedure_date: Mapped[date | None]
procedure_datetime: Mapped[datetime]
procedure_occurrence_id: Mapped[int]
procedure_source_concept: Mapped[Concept]
procedure_source_concept_id: Mapped[int]
procedure_source_value: Mapped[str | None]
procedure_type_concept: Mapped[Concept]
procedure_type_concept_id: Mapped[int]
provider: Mapped[Provider]
provider_id: Mapped[int | None]
quantity: Mapped[int | None]
visit_detail: Mapped[VisitDetail]
visit_detail_id: Mapped[int | None]
visit_occurrence: Mapped[VisitOccurrence]
visit_occurrence_id: Mapped[int | None]
class pyomop.cdm6.cdm6_tables.Provider(**kwargs)[source]

Bases: Base

care_site: Mapped[CareSite]
care_site_id: Mapped[int | None]
dea: Mapped[str | None]
gender_concept: Mapped[Concept]
gender_concept_id: Mapped[int]
gender_source_concept: Mapped[Concept]
gender_source_concept_id: Mapped[int]
gender_source_value: Mapped[str | None]
npi: Mapped[str | None]
provider_id: Mapped[int]
provider_name: Mapped[str | None]
provider_source_value: Mapped[str | None]
specialty_concept: Mapped[Concept]
specialty_concept_id: Mapped[int]
specialty_source_concept: Mapped[Concept]
specialty_source_concept_id: Mapped[int]
specialty_source_value: Mapped[str | None]
year_of_birth: Mapped[int | None]
class pyomop.cdm6.cdm6_tables.Relationship(**kwargs)[source]

Bases: Base

defines_ancestry: Mapped[str]
is_hierarchical: Mapped[str]
relationship_concept: Mapped[Concept]
relationship_concept_id: Mapped[int]
relationship_id: Mapped[str]
relationship_name: Mapped[str]
reverse_relationship: Mapped[Relationship]
reverse_relationship_id: Mapped[str]
class pyomop.cdm6.cdm6_tables.SourceToConceptMap(**kwargs)[source]

Bases: Base

invalid_reason: Mapped[str | None]
source_code: Mapped[str]
source_code_description: Mapped[str | None]
source_concept_id: Mapped[int]
source_vocabulary: Mapped[Vocabulary]
source_vocabulary_id: Mapped[str]
target_concept: Mapped[Concept]
target_concept_id: Mapped[int]
target_vocabulary: Mapped[Vocabulary]
target_vocabulary_id: Mapped[str]
valid_end_date: Mapped[date]
valid_start_date: Mapped[date]
class pyomop.cdm6.cdm6_tables.Specimen(**kwargs)[source]

Bases: Base

anatomic_site_concept_id: Mapped[int]
anatomic_site_source_value: Mapped[str]
disease_status_concept_id: Mapped[int]
disease_status_source_value: Mapped[str]
person_id: Mapped[int]
quantity: Mapped[Decimal]
specimen_concept_id: Mapped[int]
specimen_date: Mapped[str]
specimen_id: Mapped[int]
specimen_source_id: Mapped[str]
specimen_source_value: Mapped[str]
specimen_time: Mapped[str]
specimen_type_concept_id: Mapped[int]
unit_concept_id: Mapped[int]
unit_source_value: Mapped[str]
class pyomop.cdm6.cdm6_tables.SurveyConduct(**kwargs)[source]

Bases: Base

assisted_concept: Mapped[Concept]
assisted_concept_id: Mapped[int]
assisted_source_value: Mapped[str | None]
collection_method_concept: Mapped[Concept]
collection_method_concept_id: Mapped[int]
collection_method_source_value: Mapped[str | None]
person: Mapped[Person]
person_id: Mapped[int]
provider: Mapped[Provider]
provider_id: Mapped[int | None]
respondent_type_concept: Mapped[Concept]
respondent_type_concept_id: Mapped[int]
respondent_type_source_value: Mapped[str | None]
response_visit_occurrence: Mapped[VisitOccurrence]
response_visit_occurrence_id: Mapped[int | None]
survey_concept: Mapped[Concept]
survey_concept_id: Mapped[int]
survey_conduct_id: Mapped[int]
survey_end_date: Mapped[date | None]
survey_end_datetime: Mapped[datetime]
survey_source_concept: Mapped[Concept]
survey_source_concept_id: Mapped[int]
survey_source_identifier: Mapped[str | None]
survey_source_value: Mapped[str | None]
survey_start_date: Mapped[date | None]
survey_start_datetime: Mapped[datetime | None]
survey_version_number: Mapped[str | None]
timing_concept: Mapped[Concept]
timing_concept_id: Mapped[int]
timing_source_value: Mapped[str | None]
validated_survey_concept: Mapped[Concept]
validated_survey_concept_id: Mapped[int]
validated_survey_source_value: Mapped[str | None]
visit_detail: Mapped[VisitDetail]
visit_detail_id: Mapped[int | None]
visit_occurrence: Mapped[VisitOccurrence]
visit_occurrence_id: Mapped[int | None]
class pyomop.cdm6.cdm6_tables.VisitCost(**kwargs)[source]

Bases: Base

currency_concept_id: Mapped[int]
paid_by_coordination_benefits: Mapped[Decimal]
paid_by_payer: Mapped[Decimal]
paid_coinsurance: Mapped[Decimal]
paid_copay: Mapped[Decimal]
paid_toward_deductible: Mapped[Decimal]
payer_plan_period_id: Mapped[int]
total_out_of_pocket: Mapped[Decimal]
total_paid: Mapped[Decimal]
visit_cost_id: Mapped[int]
visit_occurrence_id: Mapped[int]
class pyomop.cdm6.cdm6_tables.VisitDetail(**kwargs)[source]

Bases: Base

admitted_from_concept: Mapped[Concept]
admitted_from_concept_id: Mapped[int]
admitted_from_source_value: Mapped[str | None]
care_site: Mapped[CareSite]
care_site_id: Mapped[int | None]
discharge_to_concept: Mapped[Concept]
discharge_to_concept_id: Mapped[int]
discharge_to_source_value: Mapped[str | None]
person: Mapped[Person]
person_id: Mapped[int]
preceding_visit_detail: Mapped[VisitDetail]
preceding_visit_detail_id: Mapped[int | None]
provider: Mapped[Provider]
provider_id: Mapped[int | None]
visit_detail_concept: Mapped[Concept]
visit_detail_concept_id: Mapped[int]
visit_detail_end_date: Mapped[date | None]
visit_detail_end_datetime: Mapped[datetime]
visit_detail_id: Mapped[int]
visit_detail_parent: Mapped[VisitDetail]
visit_detail_parent_id: Mapped[int | None]
visit_detail_source_concept: Mapped[Concept]
visit_detail_source_concept_id: Mapped[int]
visit_detail_source_value: Mapped[str | None]
visit_detail_start_date: Mapped[date | None]
visit_detail_start_datetime: Mapped[datetime]
visit_detail_type_concept: Mapped[Concept]
visit_detail_type_concept_id: Mapped[int]
visit_occurrence: Mapped[VisitOccurrence]
visit_occurrence_id: Mapped[int]
class pyomop.cdm6.cdm6_tables.VisitOccurrence(**kwargs)[source]

Bases: Base

admitted_from_concept: Mapped[Concept]
admitted_from_concept_id: Mapped[int]
admitted_from_source_value: Mapped[str | None]
care_site: Mapped[CareSite]
care_site_id: Mapped[int | None]
discharge_to_concept: Mapped[Concept]
discharge_to_concept_id: Mapped[int]
discharge_to_source_value: Mapped[str | None]
person: Mapped[Person]
person_id: Mapped[int]
preceding_visit_occurrence: Mapped[VisitOccurrence]
preceding_visit_occurrence_id: Mapped[int | None]
provider: Mapped[Provider]
provider_id: Mapped[int | None]
visit_concept: Mapped[Concept]
visit_concept_id: Mapped[int]
visit_end_date: Mapped[date | None]
visit_end_datetime: Mapped[datetime]
visit_occurrence_id: Mapped[int]
visit_source_concept: Mapped[Concept]
visit_source_concept_id: Mapped[int]
visit_source_value: Mapped[str | None]
visit_start_date: Mapped[date | None]
visit_start_datetime: Mapped[datetime]
visit_type_concept: Mapped[Concept]
visit_type_concept_id: Mapped[int]
class pyomop.cdm6.cdm6_tables.Vocabulary(**kwargs)[source]

Bases: Base

vocabulary_concept: Mapped[Concept]
vocabulary_concept_id: Mapped[int]
vocabulary_id: Mapped[str]
vocabulary_name: Mapped[str]
vocabulary_reference: Mapped[str]
vocabulary_version: Mapped[str | None]

Module contents