Compass Data Tables
Compass Data Tables includes Fact and Dimension Tables created from Compass Longitudinal Patient Claims data tables.
Data is sourced in Compass Intelligent Object Connectors and populates when running the Load Compass Patient Claims to Global DDS job. You must type the table name as it appears in the table yml, in the Patient Claims Table/View runtime parameter.
Tables created:
- dim_diagnosis_code__v
- dim_diagnosis__v
- dim_patient__v
- dim_procedure__v
- dim_claims_product__v
- fact_patient__v
dim_diagnosis_code__v
| composite_key__v |
varchar(300) |
Connector Name|Diagnosis Code Key |
| source_system_id__v |
varchar(18) |
|
| native_id__v |
varchar(18) |
|
| source_connector_name__v |
varchar(100) |
Connector Name |
| source_table_name__v |
varchar(100) |
Table Name |
| diagnosis_code_key__v |
varchar(2000) |
|diagnosis_code_1|diagnosis_code_1_desc| OR |diagnosis_code_2|diagnosis_code_2_desc| OR |diagnosis_code_3|diagnosis_code_3_desc| OR |diagnosis_code_4|diagnosis_code_4_desc| |
| diagnosis_code__v |
varchar(50) |
diagnosis_code_1 OR diagnosis_code_2 OR diagnosis_code_3 OR diagnosis_code_4 |
| diagnosis_code_desc__v |
varchar(255) |
diagnosis_code_1_desc OR diagnosis_code_2_desc OR diagnosis_code_3_desc OR diagnosis_code_4_desc |
| diagnosis_class1__v |
varchar(255) |
diagnosis1_class1 OR diagnosis2_class1 OR diagnosis3_class1 OR diagnosis4_class1 |
| diagnosis_class2__v |
varchar(255) |
diagnosis1_class2 OR diagnosis2_class2 OR diagnosis3_class2 OR diagnosis4_class2 |
dim_diagnosis__v
| composite_key__v |
varchar(2000) |
|Connector_Name|diagnosis_code_1|diagnosis_code_2|diagnosis_code_3|diagnosis_code_4|diagnosis_icdtype| |
| source_system_id__v |
varchar(18) |
|
| native_id__v |
varchar(2000) |
|diagnosis_code_1|diagnosis_code_2|diagnosis_code_3|diagnosis_code_4|diagnosis_icdtype| |
| source_connector_name__v |
varchar(100) |
Connector Name |
| source_table_name__v |
varchar(100) |
Table Name |
| diag_key__v |
varchar(2000) |
|diagnosis_code_1|diagnosis_code_2|diagnosis_code_3|diagnosis_code_4|diagnosis_icdtype| |
| diagnosis1_class1__v |
varchar(255) |
diagnosis1_class1 |
| diagnosis1_class2__v |
varchar(255) |
diagnosis1_class2 |
| diagnosis2_class1__v |
varchar(255) |
diagnosis2_class1 |
| diagnosis2_class2__v |
varchar(255) |
diagnosis2_class2 |
| diagnosis3_class1__v |
varchar(255) |
diagnosis3_class1 |
| diagnosis3_class2__v |
varchar(255) |
diagnosis3_class2 |
| diagnosis4_class1__v |
varchar(255) |
diagnosis4_class1 |
| diagnosis4_class2__v |
varchar(255) |
diagnosis4_class1 |
| diagnosis_code_1__v |
varchar(15) |
diagnosis_code_1 |
| diagnosis_code_1_desc__v |
varchar(255) |
diagnosis_code_1_desc |
| diagnosis_code_2__v |
varchar(15) |
diagnosis_code_2 |
| diagnosis_code_2_desc__v |
varchar(255) |
diagnosis_code_2_desc |
| diagnosis_code_3__v |
varchar(15) |
diagnosis_code_3 |
| diagnosis_code_3_desc__v |
varchar(255) |
diagnosis_code_3_desc |
| diagnosis_code_4__v |
varchar(15) |
diagnosis_code_4 |
| diagnosis_code_4_desc__v |
varchar(255) |
diagnosis_code_4_desc |
| diagnosis_icd_type__v |
varchar(25) |
diagnosis_icdtype |
dim_patient__v
| composite_key__v |
varchar(100) |
|connector_name|patient_id|age|gender|state|zip3| |
| source_system_id__v |
varchar(18) |
|
| native_id__v |
varchar(180) |
patient_id |
| source_connector_name__v |
varchar(100) |
Connector Name |
| source_table_name__v |
varchar(100) |
Table Name |
| patient_key__v |
varchar(200) |
|patient_id|age|gender|state|zip3| |
| patient_id__v |
varchar(44) |
patient_id |
| age__v |
varchar(5) |
age |
| gender__v |
varchar(1) |
gender |
| state__v |
varchar(2) |
state |
| zip3__v |
varchar(3) |
zip3 |
dim_procedure__v
| composite_key__v |
varchar(150) |
|connector_name|procedure_code|procedure_code_modifier| |
| source_system_id__v |
varchar(18) |
|
| native_id__v |
varchar(100) |
procedure_code |
| source_connector_name__v |
varchar(100) |
Connector Name |
| source_table_name__v |
varchar(100) |
Table Name |
| procedure_key__v |
varchar(2000) |
|procedure_code|procedure_code_modifier| |
| procedure_code__v |
varchar(5) |
procedure_code |
| procedure_code_desc__v |
varchar(300) |
procedure_code_desc |
| procedure_code_modifier1__v |
varchar(2) |
procedure_code_modifier1 |
dim_claims_product__v
| composite_key__v |
varchar(100) |
|connector_name|product_id| |
| source_system_id__v |
varchar(18) |
|
| native_id__v |
varchar(18) |
product_id |
| source_connector_name__v |
varchar(100) |
Connector Name |
| source_table_name__v |
varchar(100) |
Table Name |
| product_key__v |
varchar(19) |
product_id |
| product_name__v |
varchar(200) |
product_name |
| product_desc__v |
varchar(100) |
product_desc |
| product_j_code__v |
varchar(6) |
product_j_code |
| strength__v |
varchar(255) |
strength |
| company_name__v |
varchar(255) |
company_name |
| route__v |
varchar(50) |
route |
| active_ingredient__v |
varchar(255) |
active_ingredient |
| ta1__v |
varchar(100) |
ta1 |
| ta2__v |
varchar(200) |
ta2 |
| ta3__v |
varchar(255) |
ta3 |
| product_category__v |
varchar(1) |
product_category |
| compound_name__v |
varchar(100) |
compound_name |
| otc__v |
varchar(1) |
otc |
| dose_form__v |
varchar(100) |
dose_form |
| obsolete_datetime__v |
date |
obsolete_datetime |
fact_patient__v
| composite_key__v |
varchar(100) |
|
| source_system_id__v |
varchar(18) |
|
| native_id__v |
varchar(18) |
|
| source_connector_name__v |
varchar(100) |
Connector Name |
| source_table_name__v |
varchar(100) |
Table Name |
| claim_id__v |
varchar(40) |
claim_id |
| days_supply__v |
numeric(30) |
days_supply |
| fill_number__v |
numeric(30) |
fill_number |
| line_charges__v |
numeric(30,2) |
line_charges |
| num_authorized_refills__v |
numeric(30) |
num_authorized_refills |
| patient_opc__v |
numeric(30,2) |
patient_opc |
| place_of_service__v |
varchar(40) |
place_of_service |
| place_of_service_desc__v |
varchar(40) |
place_of_service_desc |
| prescription_num__v |
varchar(40) |
prescription_num |
| qty_dispensed__v |
numeric(30,3) |
qty_dispensed |
| query_plan_id__v |
numeric(30) |
query_plan_id |
| query_record_id__v |
varchar(40) |
query_record_id |
| record_type__v |
varchar(30) |
record_type |
| total_payment__v |
numeric(30,2) |
total_payment |
| unit_of_measure__v |
varchar(40) |
unit_of_measure |
| unit_of_measure_desc__v |
varchar(4000) |
unit_of_measure_desc |
| units_of_service__v |
numeric(30,3) |
units_of_service |
| date_key__v |
varchar(4000) |
transaction_date |
| diag_key__v |
varchar(500) |
|diagnosis_code_1|diagnosis_code_2|diagnosis_code_3|diagnosis_code_4|diagnosis_icdtype| |
| hcp_key__v |
varchar(500) |
|hcp_vid|hcp_specialty_1|hcp_specialty_2|facility_vid|hcp_id| |
| patient_key__v |
varchar(100) |
|patient_id|age|gender|state|zip3| |
| product_id__v |
varchar(100) |
product_id |
| procedure_key__v |
varchar(50) |
|procedure_code|procedure_code_modifier| |
