Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Procedure Occurrence Modifier #92

Closed
clairblacketer opened this issue Aug 2, 2017 · 0 comments

Comments

Projects
None yet
1 participant
@clairblacketer
Copy link
Contributor

commented Aug 2, 2017

Rename 'Qualifier' to 'Modifier' in Procedure_occurrence


Proposal

Relevant table: Procedure_occurrence

  • Rename Qualifier_Source_Value to Modifier_Source_Value
Field Required Type Description
procedure_occurrence_id Yes integer A system-generated unique identifier for each Procedure Occurrence.
person_id Yes integer A foreign key identifier to the Person who is subjected to the Procedure. The demographic details of that Person are stored in the PERSON table.
procedure_concept_id Yes integer A foreign key that refers to a standard procedure Concept identifier in the Standardized Vocabularies.
procedure_date Yes date The date on which the Procedure was performed.
procedure_datetime No datetime The date and time on which the Procedure was performed.
procedure_type_concept_id Yes integer A foreign key to the predefined Concept identifier in the Standardized Vocabularies reflecting the type of source data from which the procedure record is derived.
modifier_concept_id No integer A foreign key to a Standard Concept identifier for a modifier to the Procedure (e.g. bilateral)
quantity No integer The quantity of procedures ordered or administered.
provider_id No integer A foreign key to the provider in the provider table who was responsible for carrying out the procedure.
visit_occurrence_id No integer A foreign key to the visit in the visit table during which the Procedure was carried out.
procedure_source_value No varchar(50) The source code for the Procedure as it appears in the source data. This code is mapped to a standard procedure Concept in the Standardized Vocabularies and the original code is, stored here for reference. Procedure source codes are typically ICD-9-Proc, CPT-4, HCPCS or OPCS-4 codes.
procedure_source_concept_id No integer A foreign key to a Procedure Concept that refers to the code used in the source.
modifier_source_value qualifier_source_value No varchar(50) The source code for the qualifier as it appears in the source data.

@clairblacketer clairblacketer added this to the CDM v5.3.0 milestone Oct 25, 2017

clairblacketer added a commit that referenced this issue Nov 9, 2017

Addresses #64, #70, #79, #92, #120, #132, #131 in code, documentation…
… is still being updated to reflect these changes.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.