QRY_TARGET_INFO

Description: |
QRY Table that contains all target code and code sets.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
QUERY_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | QUERY_ID | NUMERIC | No |
The unique identifier (.1 item) for the query record.
2 | LINE | INTEGER | No |
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 | QRY_TRGT_GEN_CODESYSTEM_C_NAME | VARCHAR | No |
This item stores the generic code system that, along with QRY 67, determine which condition the QRY is referencing as a documentation suggestion.
May contain organization-specific values: Yes
Category Entries:
2.16.840.1.113883.6.1
2.16.840.1.113883.6.96
2.16.840.1.113883.6.88
2.16.840.1.113883.6.277
2.16.840.1.113883.6.103
2.16.840.1.113883.6.104
2.16.840.1.113883.6.4
2.16.840.1.113883.6.90
2.16.840.1.113883.6.259
2.16.840.1.113883.5.1
2.16.840.1.113883.12.112
2.16.840.1.113883.6.238
2.16.840.1.113883.3.221.5
2.16.840.1.113883.12.292
2.16.840.1.113883.6.12
2.16.840.1.113883.6.285
2.16.840.1.113883.5.111
2.16.840.1.113883.6.13
2.16.840.1.113883.5.83
2.16.840.1.113883.2.1.3.2.4.15
2.16.840.1.113883.6.26
2.16.840.1.113883.5.2
2.16.840.1.113883.5.1076
2.16.840.1.113883.5.60
2.16.840.1.113883.5.4
2.16.840.1.113883.12.443
2.16.840.1.113883.3.26.1.5
2.16.840.1.113883.3.26.1.1
2.16.840.1.113883.3.26.2
2.16.840.1.113883.6.69
2.16.840.1.113883.6.100
1.0.3166.2.2.2
Medicare Provider Specialty Codes
2.16.840.1.113883.6.8
2.16.840.1.113762.1.4.1
Medicare Severity Diagnosis Related Groups
2.16.840.1.113883.6.50
2.16.840.1.113883.6.301.3
2.16.840.1.113883.6.301.1
Modifier
CPT Category II
American Society of Anesthesiologists Codes
2.16.840.1.114222.4.5.274
2.16.840.1.113883.4.642.3.51
2.16.840.1.113883.6.73
2.16.840.1.113883.2.4.4.8
2.16.840.1.113883.4.9
Critical Medication Information Storage
2.16.840.1.113883.6.94
2.16.840.1.113883.6.3
DBC diagnose
2.16.840.1.113883.6.3.2
2.16.840.1.113883.6.135
2.16.840.1.113883.2.1.3.2.4.16.58
1.2.208.176.2.4.12
2.16.840.1.113883.6.139
2.16.840.1.113883.6.43.1
ICD-10-GM
ICD-10-BE
2.16.840.1.113883.4.642.1.756
2.16.840.1.113883.18.19
2.16.840.1.113883.6.301.6
2.16.840.1.113883.6.301.7
2.16.840.1.113883.6.301.8
ICD-10-NO
1.2.840.114350.1.12.1.1.1.2.727688
1.2.840.114350.1.72.1.1.5.2.727688.69807367
2.16.840.1.113883.6.339
FEST Virkestoff
2.16.840.1.113883.4.642.3.241
2.16.840.1.113883.4.642.4.215
2.16.840.1.113883.2.4.4.9
HIPPS
PCQC
2.16.840.1.113883.6.68
Generic Sequence Number
2.16.840.1.113883.6.301.11
HL7 v3.0
http://terminology.hl7.org/CodeSystem/v3-NullFlavor
http://terminology.hl7.org/CodeSystem/v3-TribalEntityUS
http://terminology.hl7.org/CodeSystem/PHOccupationalDataForHealthODH
http://hl7.org/fhir/us/core/CodeSystem/us-core-category
2.16.840.1.113883.4.642.4.1048
2.16.840.1.113883.4.642.1.1125
http://terminology.hl7.org/CodeSystem/v2-0131
2.16.840.1.113883.4.642.4.2038
Epic Clinical Grouping Concept
1.2.840.114350.1.151.1
ACHC
2.16.840.1.113883.6.101
2.16.840.1.113883.6.256
https://radelement.org
2.16.840.1.113883.4.642.4.2
http://hl7.org/fhir/us/davinci-pdex-plan-net/CodeSystem/InsuranceProductTypeCS
http://hl7.org/fhir/organization-role
http://hl7.org/fhir/us/davinci-pdex-plan-net/CodeSystem/OrganizationAffiliationRoleCS
http://hl7.org/fhir/us/davinci-pdex-plan-net/CodeSystem/ProviderRoleCS
http://terminology.hl7.org/CodeSystem/practitioner-role
Epic Clinical Data Mapping
http://hl7.org/fhir/us/davinci-pdex-plan-net/CodeSystem/HealthcareServiceCategoryCS
X12 Data Element 355
UNECE Recommendation 20
UNECE Recommendation 21
Terveyden ja Hyvinvoinnin Laitos (THL)
1.2.246.537.6.96
1.2.246.537.6.3
1.2.246.537.6.4
1.2.246.537.6.89
1.2.246.537.6.5
1.2.246.537.6.263
1.2.246.537.6.264
1.2.246.537.6.30
1.2.246.537.6.1
2.16.840.1.113883.18.58
1.2.246.537.6.128
1.2.246.537.6.49
THL Welfare Areas
Cms Provider Category Subtype Code
Cms Claim Type Code
Cms Provider Specialty Code
Cms Place Of Service Code
Cms Federal Type Service Code
Cms Sex Code
Cms Race Code
Cms Fips County Code
Cms Fips State Code
Cms Fips State Abbreviation Code
Cms Claim Admission Type Code
Cms Claim Admission Source Code
Cms Claim Admission Source Code Newborn
Cms Claim Adjustment Type Code
Cms Beneficiary Patient Status Code
Cms Claim Outpatient Service Type Code
Cms Cms Aco Type
Cms Cms Aco Type Abbreviation
Cms Cms Aco Track
Cms Cms Aco Roster Start Date
Cms Cms Aco Derive Ssn From Hicn List
Cms Cms Aco Attribution Criteria
Cms Cms Aco Population Inclusion Criteria
Cms Usps State Code
Cms Ssa County Code
Cms Ssa State Code
Cms Alr Report Quarter Start Date
Cms Alr Report Quarter End Date
Cms Alr Eligibility Start Date Month
Cms Alr Eligibility End Date Month
Cms Preferred Providers
Cms General Practitioner
Cms Enrollment Category
Cms Icd10 Dx Chapter
Cms Icd10 Px Clinical Domain List
Cms Hipaa Relationship Code
Cms Cwf Relationship Code
Cms Claim Medicare NonPayment Reason Code
Cms Claim Carrier Payment Denial Code
Cms Claim Line Processing Indicator Code
Cms Most Generic Taxonomy For Specialty
Cms Preferred Specialty For Taxonomy
Cms Taxonomy Agencies
Cms Taxonomy Allopathic & Osteopathic Physicians
Cms Taxonomy Ambulatory Health Care Facilities
Cms Taxonomy Behavioral Health & Social Service Providers
Cms Taxonomy Chiropractic Providers
Cms Taxonomy Dental Providers
Cms Taxonomy Dietary & Nutritional Service Providers
Cms Taxonomy Emergency Medical Service Providers
Cms Taxonomy Eye and Vision Services Providers
Cms Taxonomy Group
Cms Taxonomy Hospital Units
Cms Taxonomy Hospitals
Cms Taxonomy Laboratories
Cms Taxonomy Managed Care Organizations
Cms Taxonomy Nursing & Custodial Care Facilities
Cms Taxonomy Nursing Service Providers
Cms Taxonomy Nursing Service Related Providers
Cms Taxonomy Other Service Providers
Cms Taxonomy Pharmacy Service Providers
Cms Taxonomy Physician Assistants & Advanced Practice Nursing Providers
Cms Taxonomy Podiatric Medicine & Surgery Service Providers
Cms Taxonomy Residential Treatment Facilities
Cms Taxonomy Respiratory, Developmental, Rehabilitative and Restorative Service Providers
Cms Taxonomy Respite Care Facility
Cms Taxonomy Speech, Language and Hearing Service Providers
Cms Taxonomy Student, Health Care
Cms Taxonomy Suppliers
Cms Taxonomy Technologists, Technicians & Other Technical Service Providers
Cms Taxonomy Transportation Services
Cms Taxonomy Specialization Agencies
Cms Taxonomy Specialization Allopathic & Osteopathic Physicians
Cms Taxonomy Specialization Ambulatory Health Care Facilities
Cms Taxonomy Specialization Behavioral Health & Social Service Providers
Cms Taxonomy Specialization Chiropractic Providers
Cms Taxonomy Specialization Dental Providers
Cms Taxonomy Specialization Dietary & Nutritional Service Providers
Cms Taxonomy Specialization Emergency Medical Service Providers
Cms Taxonomy Specialization Eye and Vision Services Providers
Cms Taxonomy Specialization Group
Cms Taxonomy Specialization Hospital Units
Cms Taxonomy Specialization Hospitals
Cms Taxonomy Specialization Laboratories
Cms Taxonomy Specialization Managed Care Organizations
Cms Taxonomy Specialization Nursing & Custodial Care Facilities
Cms Taxonomy Specialization Nursing Service Providers
Cms Taxonomy Specialization Nursing Service Related Providers
Cms Taxonomy Specialization Other Service Providers
Cms Taxonomy Specialization Pharmacy Service Providers
Cms Taxonomy Specialization Physician Assistants & Advanced Practice Nursing Providers
Cms Taxonomy Specialization Podiatric Medicine & Surgery Service Providers
Cms Taxonomy Specialization Residential Treatment Facilities
Cms Taxonomy Specialization Respiratory, Developmental, Rehabilitative and Restorative Service Providers
Cms Taxonomy Specialization Respite Care Facility
Cms Taxonomy Specialization Speech, Language and Hearing Service Providers
Cms Taxonomy Specialization Student, Health Care
Cms Taxonomy Specialization Suppliers
Cms Taxonomy Specialization Technologists, Technicians & Other Technical Service Providers
Cms Taxonomy Specialization Transportation Services
Interpreted Claim Detail Type Place of Service Code
Interpreted Claim Detail Type Place of Service Description
Interpreted Claim Detail Type CPT (Non Priority)
Interpreted Claim Detail Type CPT (Priority)
Interpreted Claim Detail Type HCPCS (Non Priority)
Interpreted Claim Detail Type HCPCS (Priority)
Interpreted Claim Detail Type Type of Bill
Interpreted Claim Detail Type UB Revenue Code
Outpatient Revenue Code List
Non-Outpatient Revenue Code List
4 | QRY_TARGET_EDG_CODE_SET_C_NAME | VARCHAR | No |
This item stores the diagnosis code set that, along with QRY 67, determine which condition the QRY is referencing as a documentation suggestion.
May contain organization-specific values: Yes
Category Entries:
ICD-9-CM
ICD-10-CM
ICD-10-CA
ICD-10-UK
DBC
ICD-10 Dutch
ICD-10-AM
A&E Diagnoses
SKS
ICD-10-THL
ICPC-2
ICD-O-3
ICD-10-GM
ICD-9-CM Supplemental
ICD-10-BE
ICD-10-NO
Apache
DSM-5
KinCor
ORPHA
SNOMED CT
MONDO
EPD Short List
Preferred Ancillary Code Sets
5 | QRY_TARGET_CODE | VARCHAR | No |
This item stores the diagnosis code which, along with QRY 65/66, determine which condition the QRY is referencing as a documentation suggestion.