FCM DataStudio & Extract Data Dictionary

Updated 2024-11-20

Definitions and descriptions for the FCM DataStudio product and the native Data Extract

account_roles

column	type	description
id	integer	Primary key id
name	text

appropriateness_criteria_codes

column	type	description
id	integer	Primary key id
code	text
description	text
comments_required	boolean
comments_description	text

barriers

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	(DataStudio only). Reference to patients primary key id
id	integer	Primary key id
description	text
active	boolean
chart_id	integer	Reference to charts primary key id
created_at	datetime
updated_at	datetime
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id

billing_admin_fees

column	type	description
care_management_agency_id	integer	Reference to care_management_agencies primary key id
health_home_id	integer	Reference to health_homes primary key id
patient_id	integer	Reference to patients primary key id
id	integer	Primary key id
chart_id	integer	Reference to charts primary key id
managed_care_organization_id	integer
insurance_type_id	integer
claim_batch_id	integer
percentage_based_admin_fee_companion_claim_id	integer	Reference to billing_claims primary key id
admin_fee_configuration_id	integer
statement_id	integer	Reference to billing_statements primary key id
fee_reversal_id	integer
date_of_service	date
charge_amount	decimal
outreach_enrollment_code	text
patient_medicaid_id	text
patient_first_name	text
patient_last_name	text
patient_date_of_birth	date
patient_gender	text
patient_address1	text
patient_address2	text
patient_city	text
patient_state	text
patient_zip	text
health_home_billing_name	text
health_home_npi	text
health_home_billing_address_1	text
health_home_billing_address_2	text
health_home_billing_city	text
health_home_billing_state	text
health_home_billing_zip	text
health_home_billing_tax_id	text
created_at	datetime
updated_at	datetime
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id

billing_claim_transaction_types

column	type	description
id	integer	Primary key id
name	text
description	text

billing_claim_types

column	type	description
id	integer	Primary key id
name	text
description	text

billing_claims

column	type	description
care_management_agency_id	integer	Reference to care_management_agencies primary key id
health_home_id	integer	Reference to health_homes primary key id
patient_id	integer	Reference to patients primary key id
id	integer	Primary key id
claim_batch_id	integer
patient_medicaid_id	text
date_of_service	date
rate_code_id	integer	Reference to billing_rate_codes primary key id
rate_code_description	text	(DataStudio only). Value from billing_rate_codes.description
outreach_enrollment_code	text
patient_first_name	text
patient_last_name	text
patient_date_of_birth	date
patient_gender	text
patient_address1	text
patient_address2	text
patient_city	text
patient_state	text
patient_zip	text
created_at	datetime
updated_at	datetime
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id
charge_amount	decimal
insurance_type_id	integer
managed_care_organization_id	integer
claim_type_id	integer	Reference to billing_claim_types primary key id
claim_type_name	text	(DataStudio only). Value from billing_claim_types.name
base_claim_id	integer	Reference to billing_claims primary key id
statement_id	integer	Reference to billing_statements primary key id
voided_at	datetime
voided_by_id	integer	Reference to users primary key id
managed_care_plan_id	integer	Reference to managed_care_plans primary key id
payer_id	integer	Reference to payers primary key id
payer_name	text	(DataStudio only). Value from payers.name
edi_payer_name	text
edi_payer_id	text
payer_address_1	text
payer_address_2	text
payer_city	text
payer_state	text
payer_zip	text
health_home_billing_name	text
health_home_npi	text
health_home_billing_address_1	text
health_home_billing_address_2	text
health_home_billing_city	text
health_home_billing_state	text
health_home_billing_zip	text
health_home_billing_tax_id	text
hcbs_eligibility_assessment_id	integer
companion_1860_claim_id	integer	Reference to billing_claims primary key id
chart_id	integer	Reference to charts primary key id
in_billing_support_void_checkpoint_blocklist	boolean
amida_care_incentive_program_assessment_id	integer	Reference to patient_assessments primary key id
amida_care_incentive_program_signed_care_plan_id	integer	Reference to patient_signed_care_plans primary key id
btq_id	text
admin_fee_configuration_id	integer
in_billing_support_void_claim_submission_block_list	boolean
in_billing_support_rate_code_checkpoint_blocklist	boolean
claim_status_id	integer
written_off_at	datetime
written_off_by_id	integer	Reference to users primary key id
claim_write_off_reason_id	integer	Reference to claim_write_off_reasons primary key id
claim_write_off_reason_description	text	(DataStudio only). Value from claim_write_off_reasons.description

billing_claim_adjustments

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	(DataStudio only). Reference to patients primary key id
id	integer	Primary key id
billing_claim_transaction_id	integer	Reference to billing_claim_transactions primary key id
amount	decimal
billing_statement_id	integer	Reference to billing_statements primary key id
created_at	datetime
updated_at	datetime
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id

billing_claim_transactions

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	(DataStudio only). Reference to patients primary key id
id	integer	Primary key id
transaction_date	date
import_record_unique_identifier	text
amount	decimal
payor_control_number	text
check_number	text
remit_code	text
remark_codes	text
claim_transaction_file_id	integer
created_at	datetime
updated_at	datetime
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id
claim_id	integer
transaction_type_id	integer	Reference to billing_claim_transaction_types primary key id
transaction_type_name	text	(DataStudio only). Value from billing_claim_transaction_types.name
notes	text
statement_id	integer	Reference to billing_statements primary key id
remark_code_1	text
remark_code_2	text
remark_code_3	text
remark_code_4	text
remark_code_5	text
marked_for_replacement_at	datetime
marked_for_replacement_by_id	integer	Reference to users primary key id
interest_source_transaction_id	integer	Reference to billing_claim_transactions primary key id
raw_edi	text

billing_rate_codes

column	type	description
id	integer	Primary key id
code	text
revenue_code	text
procedure_code	text
procedure_modifier	text
description	text
adult_child_indicator	text

billing_statements

column	type	description
care_management_agency_id	integer	Reference to care_management_agencies primary key id
health_home_id	integer	Reference to health_homes primary key id
id	integer	Primary key id
statement_date	date
start_date	date
end_date	date
claim_payments_total	decimal
admin_fees_total	decimal
created_at	datetime
updated_at	datetime
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id
worker_working	boolean
include_admin_fees	boolean
billing_statement_batch_id	integer	Reference to billing_statement_batches primary key id
claim_adjustments_total	decimal
statement_adjustments_total	decimal

care_gap_sources

column	type	description
id	integer	Primary key id
name	text

care_manager_statuses

column	type	description
id	integer	Primary key id
name	text

care_managers

column	type	description
id	integer	Primary key id
first_name	text
last_name	text
status_id	integer	Reference to care_manager_statuses primary key id
status_name	text	(DataStudio only). Value from care_manager_statuses.name
created_at	datetime
updated_at	datetime
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id
cell_phone	text
work_phone	text

care_manager_gap_in_care_status_codes

column	type	description
id	integer	Primary key id
name	text

care_manager_gap_in_care_statuses

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	(DataStudio only). Reference to patients primary key id
id	integer	Primary key id
status_code_id	integer	Reference to care_manager_gap_in_care_status_codes primary key id
status_code_name	text	(DataStudio only). Value from care_manager_gap_in_care_status_codes.name
mco_gap_in_care_id	integer	Reference to mco_gaps_in_care primary key id
created_at	datetime
updated_at	datetime
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id

care_management_agencies

column	type	description
care_management_agency_id	integer	(In the Data Extract only this column is named 'id')
name	text

care_management_agencies_managers

column	type	description
care_management_agency_id	integer	Reference to care_management_agencies primary key id
care_manager_id	integer	Primary key id. Reference to care_managers primary key id

care_plan_goal_statuses

column	type	description
id	integer	Primary key id
name	text

care_plan_goals

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	(DataStudio only). Reference to patients primary key id
id	integer	Primary key id
care_plan_need_id	integer	Reference to care_plan_needs primary key id
start_date	date
target_completion_date	date
description	text
notes	text
completion_date	date
patient_care_plan_priority_id	integer	Reference to patient_care_plan_priorities primary key id
patient_care_plan_priority_name	text	(DataStudio only). Value from patient_care_plan_priorities.name
care_plan_goal_status_id	integer	Reference to care_plan_goal_statuses primary key id
care_plan_goal_status_name	text	(DataStudio only). Value from care_plan_goal_statuses.name
created_at	datetime
updated_at	datetime
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id

care_plan_download_files

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	Reference to health_homes primary key id
id	integer	Primary key id
document	text
completed_at	datetime
error_message	text
created_at	datetime
updated_at	datetime
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id

care_plan_download_records

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	(DataStudio only). Reference to patients primary key id
id	integer	Primary key id
care_plan_download_file_id	integer	Reference to care_plan_download_files primary key id
chart_id	integer	Reference to charts primary key id
care_plan_type	text
care_plan_effective_date	date
care_plan_end_date	date
care_plan_submission_date	date
care_plan_most_recent_modified_date	date
submitted_by_provider_name	text
submitted_by_user	text
members_most_recent_poc	text
responsible_signatory	text
member_id	text
date_of_birth	date
gender_per_mdw	text
first_name_per_mdw	text
last_name_per_mdw	text
member_supplied_first_name	text
member_supplied_last_name	text
member_supplied_phone_number	text
member_supplied_address_1	text
member_supplied_address_2	text
member_supplied_city	text
member_supplied_state	text
member_supplied_zip_code	text
member_supplied_email_address	text
mdw_member_address_line_1	text
mdw_member_address_line_2	text
mdw_member_city	text
mdw_member_state	text
mdw_member_zip_code	text
mdw_member_phone	text
member_fiscal_county_code_description	text
childrens_hcbs_member_service_county	text
health_home_name	text
health_home_mmis_provider_id	text
care_management_agency_name	text
care_management_agency_mmis_provider_id	text
segment_status	text
segment_start_date	date
segment_end_date	date
mcp_name	text
mcp_mmis_provider_id	text
mcp_type	text
mcp_start_date	date
mcp_end_date	date
p_g_lar_1_name	text
p_g_lar_1_address_same_as_member	text
p_g_lar_1_phone_number	text
p_g_lar_1_email_address	text
p_g_lar_1_address_line_1	text
p_g_lar_1_address_line_2	text
p_g_lar_1_city	text
p_g_lar_1_state	text
p_g_lar_1_zip_code	text
p_g_lar_2_name	text
p_g_lar_2_relationship	text
p_g_lar_2_address_same_as_member	text
p_g_lar_2_phone_number	text
p_g_lar_2_email_address	text
p_g_lar_2_address_line_1	text
p_g_lar_2_address_line_2	text
p_g_lar_2_city	text
p_g_lar_2_state	text
p_g_lar_2_zip_code	text
additional_p_g_lar_information	text
emergency_contact_name	text
emergency_contact_phone_number	text
other_emergency_supports	text
gender_identity	text
members_pronouns	text
sexual_orientation	text
gender_pronoun_sexual_orientation_comment	text
primary_language	text
secondary_language	text
language_comment	text
language_communication_comment	text
religion	text
member_diagnoses	text
member_preferences_and_strengths	text
barriers_to_achieving_goals	text
history_and_risk_factors_biological	text
history_and_risk_factors_psychological	text
history_and_risk_factors_family	text
history_and_risk_factors_community	text
history_and_risk_factors_cultural	text
care_manager_name	text
care_manager_email	text
care_manager_phone_number	text
team_support_name_1	text
team_support_1_role	text
team_support_1_contact_information	text
team_support_name_2	text
team_support_2_role	text
team_support_2_contact_information	text
team_support_name_3	text
team_support_3_role	text
team_support_3_contact_information	text
team_support_name_4	text
team_support_4_role	text
team_support_4_contact_information	text
team_support_name_5	text
team_support_5_role	text
team_support_5_contact_information	text
goals_and_objectives_1	text
interventions_and_supports_1_1	text
interventions_and_supports_1_1_date	date
interventions_and_supports_1_1_progress	text
interventions_and_supports_1_2	text
interventions_and_supports_1_2_date	date
interventions_and_supports_1_2_progress	text
interventions_and_supports_1_3	text
interventions_and_supports_1_3_date	date
interventions_and_supports_1_3_progress	text
interventions_and_supports_1_4	text
interventions_and_supports_1_4_date	date
interventions_and_supports_1_4_progress	text
interventions_and_supports_1_5	text
interventions_and_supports_1_5_date	date
interventions_and_supports_1_5_progress	text
interventions_and_supports_1_6	text
interventions_and_supports_1_6_date	date
interventions_and_supports_1_6_progress	text
interventions_and_supports_1_7	text
interventions_and_supports_1_7_date	date
interventions_and_supports_1_7_progress	text
interventions_and_supports_1_8	text
interventions_and_supports_1_8_date	date
interventions_and_supports_1_8_progress	text
goals_and_objectives_2	text
interventions_and_supports_2_1	text
interventions_and_supports_2_1_date	date
interventions_and_supports_2_1_progress	text
interventions_and_supports_2_2	text
interventions_and_supports_2_2_date	date
interventions_and_supports_2_2_progress	text
interventions_and_supports_2_3	text
interventions_and_supports_2_3_date	date
interventions_and_supports_2_3_progress	text
interventions_and_supports_2_4	text
interventions_and_supports_2_4_date	date
interventions_and_supports_2_4_progress	text
interventions_and_supports_2_5	text
interventions_and_supports_2_5_date	date
interventions_and_supports_2_5_progress	text
interventions_and_supports_2_6	text
interventions_and_supports_2_6_date	date
interventions_and_supports_2_6_progress	text
interventions_and_supports_2_7	text
interventions_and_supports_2_7_date	date
interventions_and_supports_2_7_progress	text
interventions_and_supports_2_8	text
interventions_and_supports_2_8_date	date
interventions_and_supports_2_8_progress	text
goals_and_objectives_3	text
interventions_and_supports_3_1	text
interventions_and_supports_3_1_date	date
interventions_and_supports_3_1_progress	text
interventions_and_supports_3_2	text
interventions_and_supports_3_2_date	date
interventions_and_supports_3_2_progress	text
interventions_and_supports_3_3	text
interventions_and_supports_3_3_date	date
interventions_and_supports_3_3_progress	text
interventions_and_supports_3_4	text
interventions_and_supports_3_4_date	date
interventions_and_supports_3_4_progress	text
interventions_and_supports_3_5	text
interventions_and_supports_3_5_date	date
interventions_and_supports_3_5_progress	text
interventions_and_supports_3_6	text
interventions_and_supports_3_6_date	date
interventions_and_supports_3_6_progress	text
interventions_and_supports_3_7	text
interventions_and_supports_3_7_date	date
interventions_and_supports_3_7_progress	text
interventions_and_supports_3_8	text
interventions_and_supports_3_8_date	date
interventions_and_supports_3_8_progress	text
goals_and_objectives_4	text
interventions_and_supports_4_1	text
interventions_and_supports_4_1_date	date
interventions_and_supports_4_1_progress	text
interventions_and_supports_4_2	text
interventions_and_supports_4_2_date	date
interventions_and_supports_4_2_progress	text
interventions_and_supports_4_3	text
interventions_and_supports_4_3_date	date
interventions_and_supports_4_3_progress	text
interventions_and_supports_4_4	text
interventions_and_supports_4_4_date	date
interventions_and_supports_4_4_progress	text
interventions_and_supports_4_5	text
interventions_and_supports_4_5_date	date
interventions_and_supports_4_5_progress	text
interventions_and_supports_4_6	text
interventions_and_supports_4_6_date	date
interventions_and_supports_4_6_progress	text
interventions_and_supports_4_7	text
interventions_and_supports_4_7_date	date
interventions_and_supports_4_7_progress	text
interventions_and_supports_4_8	text
interventions_and_supports_4_8_date	date
interventions_and_supports_4_8_progress	text
goals_and_objectives_5	text
interventions_and_supports_5_1	text
interventions_and_supports_5_1_date	date
interventions_and_supports_5_1_progress	text
interventions_and_supports_5_2	text
interventions_and_supports_5_2_date	date
interventions_and_supports_5_2_progress	text
interventions_and_supports_5_3	text
interventions_and_supports_5_3_date	date
interventions_and_supports_5_3_progress	text
interventions_and_supports_5_4	text
interventions_and_supports_5_4_date	date
interventions_and_supports_5_4_progress	text
interventions_and_supports_5_5	text
interventions_and_supports_5_5_date	date
interventions_and_supports_5_5_progress	text
interventions_and_supports_5_6	text
interventions_and_supports_5_6_date	date
interventions_and_supports_5_6_progress	text
interventions_and_supports_5_7	text
interventions_and_supports_5_7_date	date
interventions_and_supports_5_7_progress	text
interventions_and_supports_5_8	text
interventions_and_supports_5_8_date	date
interventions_and_supports_5_8_progress	text
goals_and_objectives_6	text
interventions_and_supports_6_1	text
interventions_and_supports_6_1_date	date
interventions_and_supports_6_1_progress	text
interventions_and_supports_6_2	text
interventions_and_supports_6_2_date	date
interventions_and_supports_6_2_progress	text
interventions_and_supports_6_3	text
interventions_and_supports_6_3_date	date
interventions_and_supports_6_3_progress	text
interventions_and_supports_6_4	text
interventions_and_supports_6_4_date	date
interventions_and_supports_6_4_progress	text
interventions_and_supports_6_5	text
interventions_and_supports_6_5_date	date
interventions_and_supports_6_5_progress	text
interventions_and_supports_6_6	text
interventions_and_supports_6_6_date	date
interventions_and_supports_6_6_progress	text
interventions_and_supports_6_7	text
interventions_and_supports_6_7_date	date
interventions_and_supports_6_7_progress	text
interventions_and_supports_6_8	text
interventions_and_supports_6_8_date	date
interventions_and_supports_6_8_progress	text
goals_and_objectives_7	text
interventions_and_supports_7_1	text
interventions_and_supports_7_1_date	date
interventions_and_supports_7_1_progress	text
interventions_and_supports_7_2	text
interventions_and_supports_7_2_date	date
interventions_and_supports_7_2_progress	text
interventions_and_supports_7_3	text
interventions_and_supports_7_3_date	date
interventions_and_supports_7_3_progress	text
interventions_and_supports_7_4	text
interventions_and_supports_7_4_date	date
interventions_and_supports_7_4_progress	text
interventions_and_supports_7_5	text
interventions_and_supports_7_5_date	date
interventions_and_supports_7_5_progress	text
interventions_and_supports_7_6	text
interventions_and_supports_7_6_date	date
interventions_and_supports_7_6_progress	text
interventions_and_supports_7_7	text
interventions_and_supports_7_7_date	date
interventions_and_supports_7_7_progress	text
interventions_and_supports_7_8	text
interventions_and_supports_7_8_date	date
interventions_and_supports_7_8_progress	text
goals_and_objectives_8	text
interventions_and_supports_8_1	text
interventions_and_supports_8_1_date	date
interventions_and_supports_8_1_progress	text
interventions_and_supports_8_2	text
interventions_and_supports_8_2_date	date
interventions_and_supports_8_2_progress	text
interventions_and_supports_8_3	text
interventions_and_supports_8_3_date	date
interventions_and_supports_8_3_progress	text
interventions_and_supports_8_4	text
interventions_and_supports_8_4_date	date
interventions_and_supports_8_4_progress	text
interventions_and_supports_8_5	text
interventions_and_supports_8_5_date	date
interventions_and_supports_8_5_progress	text
interventions_and_supports_8_6	text
interventions_and_supports_8_6_date	date
interventions_and_supports_8_6_progress	text
interventions_and_supports_8_7	text
interventions_and_supports_8_7_date	date
interventions_and_supports_8_7_progress	text
interventions_and_supports_8_8	text
interventions_and_supports_8_8_date	date
interventions_and_supports_8_8_progress	text
summary_of_additional_goals_and_objectives	text
caregiver_family_advocacy_and_support_services	text
cfass_status	text
cfass_provider_name	text
cfass_begin_date	date
cfass_authorization_start_date	date
cfass_authorization_end_date	date
cfass_freq_scope_indiv	text
cfass_freq_scope_group	text
community_habilitation_ch	text
status_ch	text
ch_provider_name	text
ch_begin_date	date
ch_authorization_start_date	date
ch_authorization_end_date	date
ch_freq_scope	text
community_self_advocacy_training_and_support_csats	text
csats_status	text
csats_provider_name	text
csats_begin_date	date
csats_authorization_start_date	date
csats_authorization_end_date	date
csats_freq_scope	text
crisis_respite_cr	text
cr_status	text
cr_provider_name	text
cr_begin_date	date
cr_authorization_start_date	date
cr_authorization_end_date	date
cr_freq_scope	text
day_habilitation_dh	text
dh_status	text
dh_provider_name	text
dh_begin_date	date
dh_authorization_start_date	date
dh_authorization_end_date	date
dh_freq_scope	text
palliative_care_counseling_and_support_services	text
pccss_status	text
pccss_provider_name	text
pccss_begin_date	date
pccss_authorization_start_date	date
pccss_authorization_end_date	date
pccss_freq_scope	text
palliative_care_expressive_therapy_pcet	text
pcet_status	text
pcet_provider_name	text
pcet_begin_date	date
pcet_authorization_start_date	date
pcet_authorization_end_date	date
pcet_freq_scope	text
palliative_care_massage_therapy_pcmt	text
pcmt_status	text
pcmt_provider_name	text
pcmt_begin_date	date
pcmt_authorization_start_date	date
pcmt_authorization_end_date	date
pcmt_freq_scope	text
palliative_care_pain_and_symptom_management_pcpsm	text
pcpsm_status	text
pcpsm_provider_name	text
pcpsm_begin_date	date
pcpsm_authorization_start_date	date
pcpsm_authorization_end_date	date
pcpsm_freq_scope	text
planned_respite_pr	text
pr_status	text
pr_provider_name	text
pr_begin_date	date
pr_authorization_start_date	date
pr_authorization_end_date	date
pr_freq_scope_indiv	text
pr_freq_scope_group	text
prevocational_services_ps	text
ps_status	text
ps_provider_name	text
ps_begin_date	date
ps_authorization_start_date	date
ps_freq_scope_indiv	date
ps_freq_scope_group	text
supported_employment_pe	text
reason_for_pe	text
pe_provider_name	text
pe_begin_date	date
pe_authorization_start_date	date
pe_authorization_end_date	date
pe_freq_scope	text
adult_hcbs_service_1	text
adult_hcbs_provider_1	text
adult_hcbs_frequency_1	text
adult_hcbs_scope_1	text
adult_hcbs_duration_1	text
adult_hcbs_service_2	text
adult_hcbs_provider_2	text
adult_hcbs_frequency_2	text
adult_hcbs_scope_2	text
adult_hcbs_duration_2	text
adult_hcbs_service_3	text
adult_hcbs_provider_3	text
adult_hcbs_frequency_3	text
adult_hcbs_scope_3	text
adult_hcbs_duration_3	text
adult_hcbs_service_4	text
adult_hcbs_provider_4	text
adult_hcbs_frequency_4	text
adult_hcbs_scope_4	text
adult_hcbs_duration_4	text
adult_hcbs_service_5	text
adult_hcbs_provider_5	text
adult_hcbs_frequency_5	text
adult_hcbs_scope_5	text
adult_hcbs_duration_5	text
risk_management_and_safeguards	text
backup_plan	text
member_residence_a_community_based_setting	text
does_member_want_to_live_in_this_setting	text
are_members_choices_limited_restricted	text
member_signature_date	date
p_g_lar_1_signature_date	date
p_g_lar_2_signature_date	date
created_at	datetime
updated_at	datetime

care_plan_upload_files

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	Reference to health_homes primary key id
id	integer	Primary key id
completed_at	datetime
error_message	text
created_at	datetime
updated_at	datetime
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id
zip_file	text

care_plan_upload_records

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	(DataStudio only). Reference to patients primary key id
id	integer	Primary key id
care_plan_upload_file_id	integer	Reference to care_plan_upload_files primary key id
chart_id	integer	Reference to charts primary key id
signed_care_plan_id	integer	Reference to patient_signed_care_plans primary key id
record_type	text
care_plan_type	text
member_id	text
date_of_birth	text
member_supplied_first_name	text
member_supplied_last_name	text
member_supplied_phone_number	text
member_supplied_address_1	text
member_supplied_address_2	text
member_supplied_city	text
member_supplied_state	text
member_supplied_zip_code	text
member_supplied_email_address	text
responsible_signatory	text
p_g_lar_1_name	text
p_g_lar_1_address_same_as_member	text
p_g_lar_1_phone_number	text
p_g_lar_1_email_address	text
p_g_lar_1_address_line_1	text
p_g_lar_1_address_line_2	text
p_g_lar_1_city	text
p_g_lar_1_state	text
p_g_lar_1_zip_code	text
p_g_lar_2_name	text
p_g_lar_2_relationship	text
p_g_lar_2_address_same_as_member	text
p_g_lar_2_phone_number	text
p_g_lar_2_email_address	text
p_g_lar_2_address_line_1	text
p_g_lar_2_address_line_2	text
p_g_lar_2_city	text
p_g_lar_2_state	text
p_g_lar_2_zip_code	text
additional_p_g_lar_information	text
emergency_contact_name	text
emergency_contact_phone_number	text
other_emergency_supports	text
gender_identity	text
members_pronouns	text
sexual_orientation	text
gender_pronoun_sexual_orientation_comment	text
primary_language	text
secondary_language	text
language_communication_comment	text
religion	text
member_diagnoses	text
member_preferences_and_strengths	text
barriers_to_achieving_goals	text
history_and_risk_factors_biological	text
history_and_risk_factors_psychological	text
history_and_risk_factors_family	text
history_and_risk_factors_community	text
history_and_risk_factors_cultural	text
care_manager_name	text
care_manager_email	text
care_manager_phone_number	text
team_support_name_1	text
team_support_1_role	text
team_support_1_contact_information	text
team_support_name_2	text
team_support_2_role	text
team_support_2_contact_information	text
team_support_name_3	text
team_support_3_role	text
team_support_3_contact_information	text
team_support_name_4	text
team_support_4_role	text
team_support_4_contact_information	text
team_support_name_5	text
team_support_5_role	text
team_support_5_contact_information	text
goals_and_objectives_1	text
interventions_and_supports_1_1	text
interventions_and_supports_1_1_date	text
interventions_and_supports_1_1_progress	text
interventions_and_supports_1_2	text
interventions_and_supports_1_2_date	text
interventions_and_supports_1_2_progress	text
interventions_and_supports_1_3	text
interventions_and_supports_1_3_date	text
interventions_and_supports_1_3_progress	text
interventions_and_supports_1_4	text
interventions_and_supports_1_4_date	text
interventions_and_supports_1_4_progress	text
interventions_and_supports_1_5	text
interventions_and_supports_1_5_date	text
interventions_and_supports_1_5_progress	text
interventions_and_supports_1_6	text
interventions_and_supports_1_6_date	text
interventions_and_supports_1_6_progress	text
interventions_and_supports_1_7	text
interventions_and_supports_1_7_date	text
interventions_and_supports_1_7_progress	text
interventions_and_supports_1_8	text
interventions_and_supports_1_8_date	text
interventions_and_supports_1_8_progress	text
goals_and_objectives_2	text
interventions_and_supports_2_1	text
interventions_and_supports_2_1_date	text
interventions_and_supports_2_1_progress	text
interventions_and_supports_2_2	text
interventions_and_supports_2_2_date	text
interventions_and_supports_2_2_progress	text
interventions_and_supports_2_3	text
interventions_and_supports_2_3_date	text
interventions_and_supports_2_3_progress	text
interventions_and_supports_2_4	text
interventions_and_supports_2_4_date	text
interventions_and_supports_2_4_progress	text
interventions_and_supports_2_5	text
interventions_and_supports_2_5_date	text
interventions_and_supports_2_5_progress	text
interventions_and_supports_2_6	text
interventions_and_supports_2_6_date	text
interventions_and_supports_2_6_progress	text
interventions_and_supports_2_7	text
interventions_and_supports_2_7_date	text
interventions_and_supports_2_7_progress	text
interventions_and_supports_2_8	text
interventions_and_supports_2_8_date	text
interventions_and_supports_2_8_progress	text
goals_and_objectives_3	text
interventions_and_supports_3_1	text
interventions_and_supports_3_1_date	text
interventions_and_supports_3_1_progress	text
interventions_and_supports_3_2	text
interventions_and_supports_3_2_date	text
interventions_and_supports_3_2_progress	text
interventions_and_supports_3_3	text
interventions_and_supports_3_3_date	text
interventions_and_supports_3_3_progress	text
interventions_and_supports_3_4	text
interventions_and_supports_3_4_date	text
interventions_and_supports_3_4_progress	text
interventions_and_supports_3_5	text
interventions_and_supports_3_5_date	text
interventions_and_supports_3_5_progress	text
interventions_and_supports_3_6	text
interventions_and_supports_3_6_date	text
interventions_and_supports_3_6_progress	text
interventions_and_supports_3_7	text
interventions_and_supports_3_7_date	text
interventions_and_supports_3_7_progress	text
interventions_and_supports_3_8	text
interventions_and_supports_3_8_date	text
interventions_and_supports_3_8_progress	text
goals_and_objectives_4	text
interventions_and_supports_4_1	text
interventions_and_supports_4_1_date	text
interventions_and_supports_4_1_progress	text
interventions_and_supports_4_2	text
interventions_and_supports_4_2_date	text
interventions_and_supports_4_2_progress	text
interventions_and_supports_4_3	text
interventions_and_supports_4_3_date	text
interventions_and_supports_4_3_progress	text
interventions_and_supports_4_4	text
interventions_and_supports_4_4_date	text
interventions_and_supports_4_4_progress	text
interventions_and_supports_4_5	text
interventions_and_supports_4_5_date	text
interventions_and_supports_4_5_progress	text
interventions_and_supports_4_6	text
interventions_and_supports_4_6_date	text
interventions_and_supports_4_6_progress	text
interventions_and_supports_4_7	text
interventions_and_supports_4_7_date	text
interventions_and_supports_4_7_progress	text
interventions_and_supports_4_8	text
interventions_and_supports_4_8_date	text
interventions_and_supports_4_8_progress	text
goals_and_objectives_5	text
interventions_and_supports_5_1	text
interventions_and_supports_5_1_date	text
interventions_and_supports_5_1_progress	text
interventions_and_supports_5_2	text
interventions_and_supports_5_2_date	text
interventions_and_supports_5_2_progress	text
interventions_and_supports_5_3	text
interventions_and_supports_5_3_date	text
interventions_and_supports_5_3_progress	text
interventions_and_supports_5_4	text
interventions_and_supports_5_4_date	text
interventions_and_supports_5_4_progress	text
interventions_and_supports_5_5	text
interventions_and_supports_5_5_date	text
interventions_and_supports_5_5_progress	text
interventions_and_supports_5_6	text
interventions_and_supports_5_6_date	text
interventions_and_supports_5_6_progress	text
interventions_and_supports_5_7	text
interventions_and_supports_5_7_date	text
interventions_and_supports_5_7_progress	text
interventions_and_supports_5_8	text
interventions_and_supports_5_8_date	text
interventions_and_supports_5_8_progress	text
goals_and_objectives_6	text
interventions_and_supports_6_1	text
interventions_and_supports_6_1_date	text
interventions_and_supports_6_1_progress	text
interventions_and_supports_6_2	text
interventions_and_supports_6_2_date	text
interventions_and_supports_6_2_progress	text
interventions_and_supports_6_3	text
interventions_and_supports_6_3_date	text
interventions_and_supports_6_3_progress	text
interventions_and_supports_6_4	text
interventions_and_supports_6_4_date	text
interventions_and_supports_6_4_progress	text
interventions_and_supports_6_5	text
interventions_and_supports_6_5_date	text
interventions_and_supports_6_5_progress	text
interventions_and_supports_6_6	text
interventions_and_supports_6_6_date	text
interventions_and_supports_6_6_progress	text
interventions_and_supports_6_7	text
interventions_and_supports_6_7_date	text
interventions_and_supports_6_7_progress	text
interventions_and_supports_6_8	text
interventions_and_supports_6_8_date	text
interventions_and_supports_6_8_progress	text
goals_and_objectives_7	text
interventions_and_supports_7_1	text
interventions_and_supports_7_1_date	text
interventions_and_supports_7_1_progress	text
interventions_and_supports_7_2	text
interventions_and_supports_7_2_date	text
interventions_and_supports_7_2_progress	text
interventions_and_supports_7_3	text
interventions_and_supports_7_3_date	text
interventions_and_supports_7_3_progress	text
interventions_and_supports_7_4	text
interventions_and_supports_7_4_date	text
interventions_and_supports_7_4_progress	text
interventions_and_supports_7_5	text
interventions_and_supports_7_5_date	text
interventions_and_supports_7_5_progress	text
interventions_and_supports_7_6	text
interventions_and_supports_7_6_date	text
interventions_and_supports_7_6_progress	text
interventions_and_supports_7_7	text
interventions_and_supports_7_7_date	text
interventions_and_supports_7_7_progress	text
interventions_and_supports_7_8	text
interventions_and_supports_7_8_date	text
interventions_and_supports_7_8_progress	text
goals_and_objectives_8	text
interventions_and_supports_8_1	text
interventions_and_supports_8_1_date	text
interventions_and_supports_8_1_progress	text
interventions_and_supports_8_2	text
interventions_and_supports_8_2_date	text
interventions_and_supports_8_2_progress	text
interventions_and_supports_8_3	text
interventions_and_supports_8_3_date	text
interventions_and_supports_8_3_progress	text
interventions_and_supports_8_4	text
interventions_and_supports_8_4_date	text
interventions_and_supports_8_4_progress	text
interventions_and_supports_8_5	text
interventions_and_supports_8_5_date	text
interventions_and_supports_8_5_progress	text
interventions_and_supports_8_6	text
interventions_and_supports_8_6_date	text
interventions_and_supports_8_6_progress	text
interventions_and_supports_8_7	text
interventions_and_supports_8_7_date	text
interventions_and_supports_8_7_progress	text
interventions_and_supports_8_8	text
interventions_and_supports_8_8_date	text
interventions_and_supports_8_8_progress	text
summary_of_additional_goals_and_objectives	text
caregiver_family_advocacy_and_support_services	text
community_habilitation_ch	text
community_self_advocacy_training_and_support_csats	text
crisis_respite_cr	text
day_habilitation_dh	text
palliative_care_counseling_and_support_services	text
palliative_care_expressive_therapy_pcet	text
palliative_care_massage_therapy_pcmt	text
palliative_care_pain_and_symptom_management_pcpsm	text
planned_respite_pr	text
prevocational_services_ps	text
supported_employment_pe	text
adult_hcbs_service_1	text
adult_hcbs_provider_1	text
adult_hcbs_frequency_1	text
adult_hcbs_scope_1	text
adult_hcbs_duration_1	text
adult_hcbs_service_2	text
adult_hcbs_provider_2	text
adult_hcbs_frequency_2	text
adult_hcbs_scope_2	text
adult_hcbs_duration_2	text
adult_hcbs_service_3	text
adult_hcbs_provider_3	text
adult_hcbs_frequency_3	text
adult_hcbs_scope_3	text
adult_hcbs_duration_3	text
adult_hcbs_service_4	text
adult_hcbs_provider_4	text
adult_hcbs_frequency_4	text
adult_hcbs_scope_4	text
adult_hcbs_duration_4	text
adult_hcbs_service_5	text
adult_hcbs_provider_5	text
adult_hcbs_frequency_5	text
adult_hcbs_scope_5	text
adult_hcbs_duration_5	text
risk_management_and_safeguards	text
backup_plan	text
member_residence_a_community_based_setting	text
does_member_want_to_live_in_this_setting	text
are_members_choices_limited_restricted	text
member_signature_date	text
p_g_lar_1_signature_date	text
p_g_lar_2_signature_date	text
created_at	datetime
updated_at	datetime
document_number	integer
line_number	integer

care_plan_upload_record_types

column	type	description
id	integer	Primary key id
name	text
code	text

care_plan_upload_record_care_plan_types

column	type	description
id	integer	Primary key id
name	text
code	text

care_plan_error_files

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
id	integer	Primary key id
care_plan_upload_file_id	integer	Reference to care_plan_upload_files primary key id
completed_at	datetime
error_message	text
created_at	datetime
updated_at	datetime
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id

care_plan_error_records

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	(DataStudio only). Reference to patients primary key id
id	integer	Primary key id
care_plan_error_file_id	integer	Reference to care_plan_error_files primary key id
care_plan_upload_record_id	integer	Reference to care_plan_upload_records primary key id
line_number	integer
record_type	text
member_id	text
date_of_member_signature_on_care_plan	date
date_of_p_g_lar_1_signature_on_care_plan	date
date_of_p_g_lar_2_signature_on_care_plan	date
error_reason_code_id	integer	Reference to care_plan_error_reason_codes primary key id
error_reason_code_description	text	(DataStudio only). Value from care_plan_error_reason_codes.description
error_description	text
created_at	datetime
updated_at	datetime
filename	text

care_plan_error_reason_codes

column	type	description
id	integer	Primary key id
code	text
description	text

care_plan_needs

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	(DataStudio only). Reference to patients primary key id
id	integer	Primary key id
patient_care_plan_id	integer	Reference to patient_care_plans primary key id
start_date	date
description	text
resolution_date	date
created_at	datetime
updated_at	datetime
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id
care_plan_need_category_id	integer	Reference to care_plan_need_categories primary key id
care_plan_need_category_name	text	(DataStudio only). Value from care_plan_need_categories.name
notes	text
care_plan_need_status_id	integer	Reference to care_plan_need_statuses primary key id
care_plan_need_status_name	text	(DataStudio only). Value from care_plan_need_statuses.name

care_plan_need_categories

column	type	description
id	integer	Primary key id
name	text

care_plan_need_statuses

column	type	description
id	integer	Primary key id
name	text

care_plan_signatures

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	(DataStudio only). Reference to patients primary key id
id	integer	Primary key id
patient_care_plan_id	integer	Reference to patient_care_plans primary key id
patient_signed_care_plan_id	integer	Reference to patient_signed_care_plans primary key id
patient_signature	text
care_manager_signature	text
created_at	datetime
updated_at	datetime
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id
caregiver_or_legal_rep_signature	text
caregiver_or_legal_rep_name	text

care_plan_task_responsibilities

column	type	description
id	integer	Primary key id
name	text

care_plan_task_statuses

column	type	description
id	integer	Primary key id
name	text

care_plan_tasks

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	(DataStudio only). Reference to patients primary key id
id	integer	Primary key id
care_plan_goal_id	integer	Reference to care_plan_goals primary key id
patient_care_plan_priority_id	integer	Reference to patient_care_plan_priorities primary key id
patient_care_plan_priority_name	text	(DataStudio only). Value from patient_care_plan_priorities.name
care_plan_task_status_id	integer	Reference to care_plan_task_statuses primary key id
care_plan_task_status_name	text	(DataStudio only). Value from care_plan_task_statuses.name
description	text
notes	text
target_completion_date	date
completion_date	date
created_at	datetime
updated_at	datetime
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id
task_responsibility_id	integer	Reference to care_plan_task_responsibilities primary key id
task_responsibility_name	text	(DataStudio only). Value from care_plan_task_responsibilities.name
task_responsibility_other	text

care_team_care_manager_user_links

column	type	description
id	integer	Primary key id
user_id	integer	Reference to users primary key id
care_manager_id	integer	Reference to care_managers primary key id
created_at	datetime
updated_at	datetime
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id

care_team_memberships

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	Reference to patients primary key id
id	integer	Primary key id
provider_id	integer	Reference to care_team_providers primary key id
provider_type_id	integer	Reference to care_team_provider_types primary key id
provider_type_name	text	(DataStudio only). Value from care_team_provider_types.name
start_date	text
followup_needed	boolean
active	boolean
created_at	datetime
updated_at	datetime
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id
end_date	text
chart_id	integer	Reference to charts primary key id

care_team_provider_credentials

column	type	description
id	integer	Primary key id
name	text

care_team_provider_titles

column	type	description
id	integer	Primary key id
name	text

care_team_provider_types

column	type	description
id	integer	Primary key id
name	text
category	text

care_team_providers

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	(DataStudio only). Reference to patients primary key id
id	integer	Primary key id
first_name	text
last_name	text
address	text
phone	text
email	text
facility	text
specialty	text
created_at	datetime
updated_at	datetime
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id
title_id	integer	Reference to care_team_provider_titles primary key id
title_name	text	(DataStudio only). Value from care_team_provider_titles.name
credential_id	integer	Reference to care_team_provider_credentials primary key id
credential_name	text	(DataStudio only). Value from care_team_provider_credentials.name

ces_risk_factors

column	type	description
id	integer	Primary key id
name	text
type_id	integer	Reference to ces_risk_factor_types primary key id
type_name	text	(DataStudio only). Value from ces_risk_factor_types.name
description	text
requires_additional_significant_risk_factor_information	boolean

ces_risk_factor_types

column	type	description
id	integer	Primary key id
name	text

ces_tools

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	(DataStudio only). Reference to patients primary key id
id	integer	Primary key id
chart_id	integer	Reference to charts primary key id
approved_by_id	integer	Reference to users primary key id
member_is_eligible_for_hh_plus	boolean
member_has_qualifying_diagnoses_id	integer	Reference to ces_tool_question_responses primary key id
member_has_qualifying_diagnoses_name	text	(DataStudio only). Value from ces_tool_question_responses.name
member_has_active_medicaid_id	integer	Reference to ces_tool_question_responses primary key id
member_has_active_medicaid_name	text	(DataStudio only). Value from ces_tool_question_responses.name
member_is_experiencing_significant_risk_factors	boolean
member_is_experiencing_general_risk_factors_id	integer	Reference to ces_tool_question_responses primary key id
member_is_experiencing_general_risk_factors_name	text	(DataStudio only). Value from ces_tool_question_responses.name
member_is_experiencing_stability_risk_factors_id	integer	Reference to ces_tool_question_responses primary key id
member_is_experiencing_stability_risk_factors_name	text	(DataStudio only). Value from ces_tool_question_responses.name
member_is_experiencing_skills_based_risk_factors_id	integer	Reference to ces_tool_question_responses primary key id
member_is_experiencing_skills_based_risk_factors_name	text	(DataStudio only). Value from ces_tool_question_responses.name
member_has_non_maintenance_goals_left_on_poc_id	integer	Reference to ces_tool_question_responses primary key id
member_has_non_maintenance_goals_left_on_poc_name	text	(DataStudio only). Value from ces_tool_question_responses.name
member_has_actively_engaged_in_last_six_months_id	integer	Reference to ces_tool_question_responses primary key id
member_has_actively_engaged_in_last_six_months_name	text	(DataStudio only). Value from ces_tool_question_responses.name
member_has_made_progress_in_last_six_months_id	integer	Reference to ces_tool_question_responses primary key id
member_has_made_progress_in_last_six_months_name	text	(DataStudio only). Value from ces_tool_question_responses.name
additional_information_for_significant_risk_factors	text
comments_on_items_answered_unclear	text
start_date	date
outcome_id	integer	Reference to ces_tool_outcomes primary key id
outcome_code	text	(DataStudio only). Value from ces_tool_outcomes.code
role_id	integer	Reference to ces_tool_roles primary key id
role_name	text	(DataStudio only). Value from ces_tool_roles.name
approved_at	datetime
created_at	datetime
updated_at	datetime
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id

ces_tool_outcomes

column	type	description
id	integer	Primary key id
description	text
code	text

ces_tool_question_responses

column	type	description
id	integer	Primary key id
name	text

ces_tool_ces_risk_factors

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	(DataStudio only). Reference to patients primary key id
id	integer	Primary key id
ces_tool_id	integer	Reference to ces_tools primary key id
risk_factor_id	integer	Reference to ces_risk_factors primary key id
risk_factor_name	text	(DataStudio only). Value from ces_risk_factors.name
created_at	datetime
updated_at	datetime
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id

ces_tool_roles

column	type	description
id	integer	Primary key id
name	text

charts

column	type	description
care_management_agency_id	integer	Reference to care_management_agencies primary key id
health_home_id	integer	Reference to health_homes primary key id
patient_id	integer	Reference to patients primary key id
id	integer	Primary key id

childrens_hcbs_disenrollment_reasons

column	type	description
id	integer	Primary key id
name	text

childrens_hcbs_disenrollment_statuses

column	type	description
id	integer	Primary key id
name	text

childrens_hcbs_population_types

column	type	description
id	integer	Primary key id
description	text
name	text

childrens_hcbs_workflows

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	(DataStudio only). Reference to patients primary key id
id	integer	Primary key id
chart_id	integer	Reference to charts primary key id
confirmed_interest_in_services_on	date
received_info_on	date
population_type_id	integer	Reference to childrens_hcbs_population_types primary key id
population_type_name	text	(DataStudio only). Value from childrens_hcbs_population_types.name
family_of_one	boolean
created_at	datetime
updated_at	datetime
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id
status_id	integer	Reference to childrens_hcbs_workflow_statuses primary key id
status_name	text	(DataStudio only). Value from childrens_hcbs_workflow_statuses.name
member_is_eligible_for_services	boolean
capacity_management_note	text
notice_date	date
disenrollment_status_id	integer	Reference to childrens_hcbs_disenrollment_statuses primary key id
disenrollment_status_name	text	(DataStudio only). Value from childrens_hcbs_disenrollment_statuses.name
notice_sent_to_health_home	date
care_team_members_notified	date
disenrollment_reason_id	integer	Reference to childrens_hcbs_disenrollment_reasons primary key id
disenrollment_reason_name	text	(DataStudio only). Value from childrens_hcbs_disenrollment_reasons.name
disenrollment_reason_other	text
disenrolled_on	date

childrens_hcbs_workflow_documents

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	(DataStudio only). Reference to patients primary key id
id	integer	Primary key id
childrens_hcbs_workflow_id	integer	Reference to childrens_hcbs_workflows primary key id
document_id	integer	Reference to patient_documents primary key id
childrens_hcbs_workflow_step_id	integer	Reference to childrens_hcbs_workflow_steps primary key id
childrens_hcbs_workflow_step_name	text	(DataStudio only). Value from childrens_hcbs_workflow_steps.name
created_at	datetime
updated_at	datetime
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id

childrens_hcbs_workflow_statuses

column	type	description
id	integer	Primary key id
name	text

childrens_hcbs_workflow_steps

column	type	description
id	integer	Primary key id
name	text

claim_write_off_reasons

column	type	description
id	integer	Primary key id
description	text

clinical_alert_observations

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	(DataStudio only). Reference to patients primary key id
id	integer	Primary key id
clinical_alert_id	integer	Reference to clinical_alerts primary key id
content	text
created_at	datetime
updated_at	datetime

clinical_alerts

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	(DataStudio only). Reference to patients primary key id
id	integer	Primary key id
chart_id	integer	Reference to charts primary key id
facility	text
clinical_alert_source_id	integer	Reference to clinical_alert_sources primary key id
clinical_alert_source_name	text	(DataStudio only). Value from clinical_alert_sources.name
clinical_alert_visit_type_id	integer	Reference to clinical_alert_visit_types primary key id
clinical_alert_visit_type_name	text	(DataStudio only). Value from clinical_alert_visit_types.name
occurred_at	datetime
created_at	datetime
updated_at	datetime
clinical_event_id	integer	Reference to clinical_events primary key id
received_at	datetime

clinical_alert_sources

column	type	description
id	integer	Primary key id
name	text

clinical_alert_visit_categories

column	type	description
id	integer	Primary key id
name	text

clinical_alert_visit_types

column	type	description
id	integer	Primary key id
name	text
category_id	integer

clinical_events

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	(DataStudio only). Reference to patients primary key id
id	integer	Primary key id
chart_id	integer	Reference to charts primary key id
created_at	datetime
updated_at	datetime
clinical_event_status_id	integer	Reference to clinical_event_statuses primary key id
clinical_event_status_name	text	(DataStudio only). Value from clinical_event_statuses.name

clinical_event_statuses

column	type	description
id	integer	Primary key id
name	text

custom_assessment_schemas

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	Reference to health_homes primary key id
id	integer	Primary key id
assessment_name	text
is_comprehensive	boolean
created_at	datetime
updated_at	datetime
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id

custom_assessment_schema_care_management_agencies

column	type	description
care_management_agency_id	integer	Reference to care_management_agencies primary key id
id	integer	Primary key id
custom_assessment_schema_id	integer	Reference to custom_assessment_schemas primary key id
created_at	datetime
updated_at	datetime

custom_assessment_schema_versions

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
id	integer	Primary key id
version_name	text
description	text
custom_assessment_schema_id	integer	Reference to custom_assessment_schemas primary key id
created_at	datetime
updated_at	datetime
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id
status_id	integer	Reference to custom_assessments_schema_version_statuses primary key id
status_name	text	(DataStudio only). Value from custom_assessments_schema_version_statuses.name

custom_assessment_schema_sections

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
id	integer	Primary key id
section_name	text
description	text
position	integer
custom_assessment_schema_version_id	integer	Reference to custom_assessment_schema_versions primary key id
created_at	datetime
updated_at	datetime
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id

custom_assessment_schema_questions

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
id	integer	Primary key id
question_text	text
question_type_id	integer	Reference to custom_assessments_schema_question_types primary key id
question_type_name	text	(DataStudio only). Value from custom_assessments_schema_question_types.name
position	integer
is_required	boolean
custom_assessment_schema_section_id	integer	Reference to custom_assessment_schema_sections primary key id
created_at	datetime
updated_at	datetime
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id
depends_on_question_id	integer	Reference to custom_assessment_schema_questions primary key id

custom_assessment_schema_question_options

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
id	integer	Primary key id
option_text	text
position	integer
custom_assessment_schema_question_id	integer	Reference to custom_assessment_schema_questions primary key id
created_at	datetime
updated_at	datetime
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id

custom_assessment_schema_question_option_dependencies

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
id	integer	Primary key id
question_id	integer	Reference to custom_assessment_schema_questions primary key id
depends_on_question_option_id	integer	Reference to custom_assessment_schema_question_options primary key id

custom_assessment_responses

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	(DataStudio only). Reference to patients primary key id
id	integer	Primary key id
custom_assessment_schema_version_id	integer	Reference to custom_assessment_schema_versions primary key id
chart_id	integer	Reference to charts primary key id
created_at	datetime
updated_at	datetime
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id
completed_at	datetime
completed_by_id	integer	Reference to users primary key id

custom_assessment_question_responses

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	(DataStudio only). Reference to patients primary key id
id	integer	Primary key id
custom_assessment_response_id	integer	Reference to custom_assessment_responses primary key id
custom_assessment_schema_question_id	integer	Reference to custom_assessment_schema_questions primary key id
date_value	date
text_value	text
single_select_option_id	integer	Reference to custom_assessment_schema_question_options primary key id
created_at	datetime
updated_at	datetime

custom_assessment_multi_select_option_responses

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	(DataStudio only). Reference to patients primary key id
id	integer	Primary key id
custom_assessment_question_response_id	integer	Reference to custom_assessment_question_responses primary key id
custom_assessment_schema_question_option_id	integer	Reference to custom_assessment_schema_question_options primary key id
created_at	datetime
updated_at	datetime

custom_assessments_schema_question_types

column	type	description
id	integer	Primary key id
name	text

custom_assessments_schema_version_statuses

column	type	description
id	integer	Primary key id
name	text

document_categories

column	type	description
id	integer	Primary key id
name	text

document_types

column	type	description
id	integer	Primary key id
name	text
document_category_id	integer	Reference to document_categories primary key id
document_category_name	text	(DataStudio only). Value from document_categories.name
allows_user_document_name	boolean
created_at	datetime
updated_at	datetime
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id

doh5055_forms

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	Reference to health_homes primary key id
patient_id	integer	Reference to patients primary key id
id	integer	Primary key id
health_home_name	text
health_home_phone_number	text
rhio_name	text
rhio_phone_number	text
consented	boolean
patient_name	text
patient_date_of_birth	date
signature	text
signed_on	date
legal_representative_name	text
legal_representative_relationship_to_patient	text
created_at	datetime
updated_at	datetime
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id
care_manager_id	integer	Reference to care_managers primary key id
patient_health_home_consent_id	integer	Reference to patient_health_home_consents primary key id
participating_partners_patient_signature	text
participating_partners_care_manager_signature	text
chart_id	integer	Reference to charts primary key id

doh5055_form_participating_partners

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	(DataStudio only). Reference to patients primary key id
id	integer	Primary key id
doh5055_form_id	integer	Reference to doh5055_forms primary key id
name	text
created_at	datetime
updated_at	datetime
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id
is_care_management_agency	boolean

email_encounter_details

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	(DataStudio only). Reference to patients primary key id
id	integer	Primary key id
responded_to	boolean
created_at	datetime
updated_at	datetime

email_encounter_details_targets

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	(DataStudio only). Reference to patients primary key id
id	integer	Primary key id
email_encounter_details_id	integer	Reference to email_encounter_details primary key id
target_id	integer	Reference to encounter_targets primary key id
target_name	text	(DataStudio only). Value from encounter_targets.name
created_at	datetime
updated_at	datetime

encounter_care_plan_tasks

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	(DataStudio only). Reference to patients primary key id
id	integer	Primary key id
patient_encounter_id	integer	Reference to patient_encounters primary key id
care_plan_task_id	integer	Reference to care_plan_tasks primary key id
created_at	datetime
updated_at	datetime
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id

encounter_clinical_events

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	(DataStudio only). Reference to patients primary key id
id	integer	Primary key id
encounter_id	integer	Reference to patient_encounters primary key id
clinical_event_id	integer	Reference to clinical_events primary key id
created_at	datetime
updated_at	datetime
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id

encounter_locations

column	type	description
id	integer	Primary key id
name	text

encounter_meeting_types

column	type	description
id	integer	Primary key id
name	text
display_text	text

encounter_targets

column	type	description
id	integer	Primary key id
name	text

fax_encounter_details

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	(DataStudio only). Reference to patients primary key id
id	integer	Primary key id
target_id	integer	Reference to encounter_targets primary key id
target_name	text	(DataStudio only). Value from encounter_targets.name
created_at	datetime
updated_at	datetime

harp_core_services_interest_records

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	Reference to patients primary key id
id	integer	Primary key id
status_id	integer	Reference to harp_core_services_interest_record_statuses primary key id
status_name	text	(DataStudio only). Value from harp_core_services_interest_record_statuses.name
recorded_on	date
created_at	datetime
updated_at	datetime
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id
chart_id	integer	Reference to charts primary key id

harp_core_services_interest_record_statuses

column	type	description
id	integer	Primary key id
name	text

harp_hcbs_approvals

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	Reference to patients primary key id
id	integer	Primary key id
losd_date	date
losd_file	text
created_at	datetime
updated_at	datetime
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id
chart_id	integer	Reference to charts primary key id

harp_hcbs_care_plans

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	Reference to patients primary key id
id	integer	Primary key id
created_at	datetime
updated_at	datetime
hcbs_eligibility_type_id	integer	Reference to harp_hcbs_eligibility_types primary key id
hcbs_eligibility_type_name	text	(DataStudio only). Value from harp_hcbs_eligibility_types.name
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id
triggers	text
activities_to_feel_better	text
risk_narrative	text
disaster_plan	text
address	text
home_phone	text
phone	text
email	text
address_chosen_by_individual	boolean
address_not_institution	boolean
education_employment_support_option_id	integer	Reference to harp_hcbs_care_plan_education_employment_support_options primary key id
education_employment_support_option_name	text	(DataStudio only). Value from harp_hcbs_care_plan_education_employment_support_options.name
education_employment_support_option_affirmation	boolean
chart_id	integer	Reference to charts primary key id

harp_hcbs_care_plan_backup_plan_contacts

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	Reference to patients primary key id
id	integer	Primary key id
hcbs_care_plan_id	integer	Reference to harp_hcbs_care_plans primary key id
service	text
contact	text
phone	text
availability	text
created_at	datetime
updated_at	datetime
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id

harp_hcbs_care_plan_behavioral_health_needs

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	Reference to patients primary key id
id	integer	Primary key id
hcbs_care_plan_id	integer	Reference to harp_hcbs_care_plans primary key id
service_name	text
diagnosis_code	text
service_description	text
rx_unit	text
frequency	text
provider_name	text
provider_specialty	text
provider_organization	text
provider_address	text
provider_phone	text
provider_email	text
created_at	datetime
updated_at	datetime
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id

harp_hcbs_care_plan_goals

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	Reference to patients primary key id
id	integer	Primary key id
hcbs_care_plan_id	integer	Reference to harp_hcbs_care_plans primary key id
category	text
past_efforts	text
objectives	text
preferences	text
strengths	text
potential_barriers	text
strategies	text
support	text
created_at	datetime
updated_at	datetime
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id
target_date	date

harp_hcbs_care_plan_education_employment_support_options

column	type	description
id	integer	Primary key id
name	text
description	text

harp_hcbs_care_plan_housing_questionnaires

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	(DataStudio only). Reference to patients primary key id
id	integer	Primary key id
hcbs_care_plan_id	integer	Reference to harp_hcbs_care_plans primary key id
completed_on	date
desired_location_address	text
current_living_situation_id	integer	Reference to harp_hcbs_care_plan_living_situations primary key id
current_living_situation_name	text	(DataStudio only). Value from harp_hcbs_care_plan_living_situations.name
last_lived_alone_at	date
desired_living_situation_id	integer	Reference to harp_hcbs_care_plan_living_situations primary key id
desired_living_situation_name	text	(DataStudio only). Value from harp_hcbs_care_plan_living_situations.name
willing_to_have_roommate	boolean
willing_to_live_alone	boolean
current_living_condition_description	text
current_living_condition_positive_qualities	text
current_living_condition_negative_qualities	text
desired_neighborhood_or_town	text
desired_neighborhood_or_town_explanation	text
desired_neighborhood_or_town_county	text
desired_location_near_services_importance_id	integer	Reference to harp_hcbs_care_plan_importances primary key id
desired_location_near_services_importance_name	text	(DataStudio only). Value from harp_hcbs_care_plan_importances.name
desired_location_allows_pets_importance_id	integer	Reference to harp_hcbs_care_plan_importances primary key id
desired_location_allows_pets_importance_name	text	(DataStudio only). Value from harp_hcbs_care_plan_importances.name
desired_location_allows_car_and_parking_importance_id	integer	Reference to harp_hcbs_care_plan_importances primary key id
desired_location_allows_car_and_parking_importance_name	text	(DataStudio only). Value from harp_hcbs_care_plan_importances.name
desired_location_on_desired_floor_importance_id	integer	Reference to harp_hcbs_care_plan_importances primary key id
desired_location_on_desired_floor_importance_name	text	(DataStudio only). Value from harp_hcbs_care_plan_importances.name
desired_floor	text
desired_location_allows_privacy_importance_id	integer	Reference to harp_hcbs_care_plan_importances primary key id
desired_location_allows_privacy_importance_name	text	(DataStudio only). Value from harp_hcbs_care_plan_importances.name
desired_location_has_people_around_importance_id	integer	Reference to harp_hcbs_care_plan_importances primary key id
desired_location_has_people_around_importance_name	text	(DataStudio only). Value from harp_hcbs_care_plan_importances.name
desired_location_near_grocery_store_importance_id	integer	Reference to harp_hcbs_care_plan_importances primary key id
desired_location_near_grocery_store_importance_name	text	(DataStudio only). Value from harp_hcbs_care_plan_importances.name
desired_location_near_workplace_importance_id	integer	Reference to harp_hcbs_care_plan_importances primary key id
desired_location_near_workplace_importance_name	text	(DataStudio only). Value from harp_hcbs_care_plan_importances.name
desired_location_near_family_importance_id	integer	Reference to harp_hcbs_care_plan_importances primary key id
desired_location_near_family_importance_name	text	(DataStudio only). Value from harp_hcbs_care_plan_importances.name
desired_location_near_church_importance_id	integer	Reference to harp_hcbs_care_plan_importances primary key id
desired_location_near_church_importance_name	text	(DataStudio only). Value from harp_hcbs_care_plan_importances.name
desired_location_near_provider_agency_importance_id	integer	Reference to harp_hcbs_care_plan_importances primary key id
desired_location_near_provider_agency_importance_name	text	(DataStudio only). Value from harp_hcbs_care_plan_importances.name
desired_location_near_pharmacy_importance_id	integer	Reference to harp_hcbs_care_plan_importances primary key id
desired_location_near_pharmacy_importance_name	text	(DataStudio only). Value from harp_hcbs_care_plan_importances.name
desired_location_important_things	text
desired_location_needs_no_steps	boolean
desired_location_needs_wheelchair_ramp	boolean
desired_location_needs_elevator	boolean
desired_location_needs_visual_impairment_assistive_devices	boolean
desired_location_needs_hearing_impairment_assistive_devices	boolean
desired_location_needs_disability_accessible_unit	boolean
desired_location_needs_other	text
action_steps_to_move	text
created_at	datetime
updated_at	datetime
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id
are_members_choices_limited_restricted	boolean
member_residence_a_community_based_setting	boolean
does_member_want_to_live_in_this_setting	boolean

harp_hcbs_care_plan_importances

column	type	description
id	integer	Primary key id
name	text

harp_hcbs_care_plan_interventions

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	Reference to patients primary key id
id	integer	Primary key id
hcbs_care_plan_id	integer	Reference to harp_hcbs_care_plans primary key id
status	text
duration	text
start_date	text
tests_treatment_service_referral	text
service_description	text
provider_name	text
provider_specialty	text
organization	text
phone	text
email	text
address	text
created_at	datetime
updated_at	datetime
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id
frequency	text
scope	text

harp_hcbs_care_plan_living_situations

column	type	description
id	integer	Primary key id
name	text

harp_hcbs_care_plan_medical_needs

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	Reference to patients primary key id
id	integer	Primary key id
hcbs_care_plan_id	integer	Reference to harp_hcbs_care_plans primary key id
service_name	text
diagnosis_code	text
service_description	text
rx_unit	text
frequency	text
provider_name	text
provider_specialty	text
provider_organization	text
provider_address	text
provider_phone	text
provider_email	text
created_at	datetime
updated_at	datetime
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id

harp_hcbs_care_plan_natural_disaster_contacts

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	Reference to patients primary key id
id	integer	Primary key id
hcbs_care_plan_id	integer	Reference to harp_hcbs_care_plans primary key id
name	text
days_or_times_not_available	text
phone	text
will_be_able_to_assist_with	text
created_at	datetime
updated_at	datetime
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id

harp_hcbs_care_plan_other_emergency_contacts

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	Reference to patients primary key id
id	integer	Primary key id
hcbs_care_plan_id	integer	Reference to harp_hcbs_care_plans primary key id
name	text
phone	text
address	text
relationship	text
created_at	datetime
updated_at	datetime
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id

harp_hcbs_care_plan_service_mco_approval_statuses

column	type	description
id	integer	Primary key id
name	text

harp_hcbs_care_plan_service_service_statuses

column	type	description
id	integer	Primary key id
name	text

harp_hcbs_care_plan_services

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	Reference to patients primary key id
id	integer	Primary key id
hcbs_care_plan_id	integer	Reference to harp_hcbs_care_plans primary key id
service	text
service_status_id	integer	Reference to harp_hcbs_care_plan_service_service_statuses primary key id
service_status_name	text	(DataStudio only). Value from harp_hcbs_care_plan_service_service_statuses.name
mco_approval_status_id	integer	Reference to harp_hcbs_care_plan_service_mco_approval_statuses primary key id
mco_approval_status_name	text	(DataStudio only). Value from harp_hcbs_care_plan_service_mco_approval_statuses.name
mco_name	text
mco_representative	text
reason	text
date_service_started	text
provider_specialty	text
provider_name	text
organization	text
address	text
work_phone	text
email	text
service_diagnosis_code	text
description	text
prescription_unit	text
frequency	text
created_at	datetime
updated_at	datetime
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id

harp_hcbs_care_plan_social_service_needs

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	Reference to patients primary key id
id	integer	Primary key id
hcbs_care_plan_id	integer	Reference to harp_hcbs_care_plans primary key id
service_name	text
diagnosis_code	text
service_description	text
rx_unit	text
frequency	text
provider_name	text
provider_specialty	text
provider_organization	text
provider_address	text
provider_phone	text
provider_email	text
created_at	datetime
updated_at	datetime
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id

harp_hcbs_care_plan_support_contacts

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	Reference to patients primary key id
id	integer	Primary key id
hcbs_care_plan_id	integer	Reference to harp_hcbs_care_plans primary key id
name	text
relation	text
contact_info	text
created_at	datetime
updated_at	datetime
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id

harp_hcbs_eligibility_assessments

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	Reference to patients primary key id
id	integer	Primary key id
date	date
result_id	integer	Reference to harp_hcbs_eligibility_types primary key id
result_name	text	(DataStudio only). Value from harp_hcbs_eligibility_types.name
created_at	datetime
updated_at	datetime
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id
chart_id	integer	Reference to charts primary key id
deleted_at	datetime
deleted_by_id	integer

harp_hcbs_eligibility_assessment_documents

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	(DataStudio only). Reference to patients primary key id
id	integer	Primary key id
file	text
kind_id	integer
hcbs_eligibility_assessment_id	integer	Reference to harp_hcbs_eligibility_assessments primary key id
created_at	datetime
updated_at	datetime
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id

harp_hcbs_eligibility_assessment_document_types

column	type	description
id	integer	Primary key id
name	text

harp_hcbs_eligibility_types

column	type	description
id	integer	Primary key id
name	text

harp_hcbs_enrollment_periods

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	Reference to patients primary key id
id	integer	Primary key id
start_date	date
end_date	date
created_at	datetime
updated_at	datetime
chart_id	integer	Reference to charts primary key id
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id

harp_hcbs_interest_records

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	Reference to patients primary key id
id	integer	Primary key id
status_id	integer	Reference to harp_hcbs_interest_record_statuses primary key id
status_name	text	(DataStudio only). Value from harp_hcbs_interest_record_statuses.name
recorded_on	date
created_at	datetime
updated_at	datetime
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id
chart_id	integer	Reference to charts primary key id

harp_hcbs_interest_record_statuses

column	type	description
id	integer	Primary key id
name	text

harp_signed_hcbs_care_plans

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	Reference to patients primary key id
id	integer	Primary key id
harp_hcbs_care_plan_id	integer	Reference to harp_hcbs_care_plans primary key id
uploaded_file	text
created_at	datetime
updated_at	datetime
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id

harp_workflow_statuses

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	Reference to patients primary key id
id	integer	Primary key id
created_at	datetime
updated_at	datetime
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id
hcbs_care_plan_id	integer	Reference to harp_hcbs_care_plans primary key id
approval_status_id	integer	Reference to harp_workflow_status_approval_statuses primary key id
approval_status_name	text	(DataStudio only). Value from harp_workflow_status_approval_statuses.name
approval_requested_on	date
hcbs_approval_id	integer	Reference to harp_hcbs_approvals primary key id
assessment_status_id	integer	Reference to harp_workflow_status_assessment_statuses primary key id
assessment_status_name	text	(DataStudio only). Value from harp_workflow_status_assessment_statuses.name
assessment_declined_on	date
assessment_in_progress_on	datetime
hcbs_eligibility_assessment_id	integer	Reference to harp_hcbs_eligibility_assessments primary key id
care_plan_submitted_on	date
harp_core_services_interest_record_id	integer	Reference to harp_core_services_interest_records primary key id
harp_hcbs_interest_record_id	integer	Reference to harp_hcbs_interest_records primary key id
harp_hcbs_enrollment_period_id	integer	Reference to harp_hcbs_enrollment_periods primary key id
chart_id	integer	Reference to charts primary key id

harp_workflow_status_approval_statuses

column	type	description
id	integer	Primary key id
name	text

harp_workflow_status_assessment_statuses

column	type	description
id	integer	Primary key id
name	text

hcbs_poc_recommended_providers_and_services

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	Reference to patients primary key id
id	integer	Primary key id
hcbs_care_plan_id	integer	Reference to harp_hcbs_care_plans primary key id
row_number	integer
service	text
provider_type_specialty	text
provider_name	text
organization_name_and_address	text
start_date	text
end_date	text
phone	text
frequency	text
email	text
description	text
created_at	datetime
updated_at	datetime
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id
continuous_service	boolean
scope	text
duration	text

health_homes

column	type	description
health_home_id	integer	(In the Data Extract only this column is named 'id')
name	text

health_home_care_management_agencies

column	type	description
care_management_agency_id	integer	Reference to care_management_agencies primary key id
health_home_id	integer	Reference to health_homes primary key id
id	integer	Primary key id
created_at	datetime
updated_at	datetime
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id
provides_health_home_plus_services	boolean
provides_adult_home_plus_services	boolean

in_person_encounter_details

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	(DataStudio only). Reference to patients primary key id
id	integer	Primary key id
contacted	boolean
meeting_type_id	integer	Reference to encounter_meeting_types primary key id
meeting_type_name	text	(DataStudio only). Value from encounter_meeting_types.name
location_id	integer	Reference to encounter_locations primary key id
location_name	text	(DataStudio only). Value from encounter_locations.name
created_at	datetime
updated_at	datetime

in_person_encounter_details_targets

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	(DataStudio only). Reference to patients primary key id
id	integer	Primary key id
target_id	integer	Reference to encounter_targets primary key id
target_name	text	(DataStudio only). Value from encounter_targets.name
in_person_encounter_details_id	integer	Reference to in_person_encounter_details primary key id
created_at	datetime
updated_at	datetime

legacy_care_conference_encounter_details

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	(DataStudio only). Reference to patients primary key id
id	integer	Primary key id
target_id	integer	Reference to encounter_targets primary key id
target_name	text	(DataStudio only). Value from encounter_targets.name
created_at	datetime
updated_at	datetime

legacy_other_encounter_details

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	(DataStudio only). Reference to patients primary key id
id	integer	Primary key id
created_at	datetime
updated_at	datetime

legacy_unsuccessful_enrolled_activity_encounter_details

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	(DataStudio only). Reference to patients primary key id
id	integer	Primary key id
created_at	datetime
updated_at	datetime

mail_encounter_details

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	(DataStudio only). Reference to patients primary key id
id	integer	Primary key id
target_id	integer	Reference to encounter_targets primary key id
target_name	text	(DataStudio only). Value from encounter_targets.name
created_at	datetime
updated_at	datetime

managed_care_plans

column	type	description
id	integer	Primary key id
name	text
mmis_id	text
created_at	datetime
updated_at	datetime
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id
payer_id	integer	Reference to payers primary key id
payer_name	text	(DataStudio only). Value from payers.name
managed_care_plan_type_id	integer

mco_gap_in_care_care_plan_tasks

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	(DataStudio only). Reference to patients primary key id
id	integer	Primary key id
mco_gap_in_care_id	integer	Reference to mco_gaps_in_care primary key id
care_plan_task_id	integer	Reference to care_plan_tasks primary key id
created_at	datetime
updated_at	datetime
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id

mco_gap_in_care_codes

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	(DataStudio only). Reference to patients primary key id
id	integer	Primary key id
description	text
care_gap_source_id	integer	Reference to care_gap_sources primary key id
care_gap_source_name	text	(DataStudio only). Value from care_gap_sources.name
created_at	datetime
updated_at	datetime
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id

mco_gap_in_care_messages

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	(DataStudio only). Reference to patients primary key id
id	integer	Primary key id
status_code_id	integer	Reference to mco_gap_in_care_status_codes primary key id
status_code_name	text	(DataStudio only). Value from mco_gap_in_care_status_codes.name
mco_gap_in_care_id	integer	Reference to mco_gaps_in_care primary key id
created_at	datetime
updated_at	datetime
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id

mco_gap_in_care_status_codes

column	type	description
id	integer	Primary key id
name	text

mco_gaps_in_care

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	(DataStudio only). Reference to patients primary key id
id	integer	Primary key id
chart_id	integer	Reference to charts primary key id
created_at	datetime
updated_at	datetime
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id
mco_gap_in_care_code_id	integer	Reference to mco_gap_in_care_codes primary key id

office_work_encounter_details

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	(DataStudio only). Reference to patients primary key id
id	integer	Primary key id
office_work_type_id	integer	Reference to office_work_types primary key id
office_work_type_name	text	(DataStudio only). Value from office_work_types.name
created_at	datetime
updated_at	datetime

office_work_types

column	type	description
id	integer	Primary key id
name	text

patient_adult_child_services_codes

column	type	description
id	integer	Primary key id
code	text
name	text
description	text

patient_assessment_able_to_manage_finances_reasons

column	type	description
id	integer	Primary key id
name	text

patient_assessment_access_to_transportation_modes

column	type	description
id	integer	Primary key id
name	text

patient_assessment_acs_case_reasons

column	type	description
id	integer	Primary key id
name	text

patient_assessment_any_outstanding_cases

column	type	description
id	integer	Primary key id
name	text

patient_assessment_assessed_for_hcbs

column	type	description
id	integer	Primary key id
name	text

patient_assessment_assessment_statuses

column	type	description
id	integer	Primary key id
name	text

patient_assessment_assistance_bathings

column	type	description
id	integer	Primary key id
name	text

patient_assessment_assistance_housekeepings

column	type	description
id	integer	Primary key id
name	text

patient_assessment_assistance_immigration_statuses

column	type	description
id	integer	Primary key id
name	text

patient_assessment_assistance_living_wills

column	type	description
id	integer	Primary key id
name	text

patient_assessment_assistance_meals

column	type	description
id	integer	Primary key id
name	text

patient_assessment_assistance_medications

column	type	description
id	integer	Primary key id
name	text

patient_assessment_assistance_other_types

column	type	description
id	integer	Primary key id
name	text

patient_assessment_assistance_permanency_plannings

column	type	description
id	integer	Primary key id
name	text

patient_assessment_assistance_power_of_attorneys

column	type	description
id	integer	Primary key id
name	text

patient_assessment_assistance_shoppings

column	type	description
id	integer	Primary key id
name	text

patient_assessment_assistance_standby_guardianships

column	type	description
id	integer	Primary key id
name	text

patient_assessment_assistance_toiletings

column	type	description
id	integer	Primary key id
name	text

patient_assessment_assistance_transportations

column	type	description
id	integer	Primary key id
name	text

patient_assessment_assistance_wills

column	type	description
id	integer	Primary key id
name	text

patient_assessment_assistive_equipments

column	type	description
id	integer	Primary key id
name	text

patient_assessment_barriers_to_keeping_mh_appts

column	type	description
id	integer	Primary key id
name	text

patient_assessment_care_manager_program_types

column	type	description
id	integer	Primary key id
name	text

patient_assessment_current_living_situations

column	type	description
id	integer	Primary key id
name	text

patient_assessment_current_living_situation_statuses

column	type	description
id	integer	Primary key id
name	text

patient_assessment_diabetes_statuses

column	type	description
id	integer	Primary key id
name	text

patient_assessment_demo_best_contact_methods

column	type	description
id	integer	Primary key id
name	text

patient_assessment_demo_citizenship_statuses

column	type	description
id	integer	Primary key id
name	text

patient_assessment_demo_ethnicities

column	type	description
id	integer	Primary key id
name	text

patient_assessment_demo_genders

column	type	description
id	integer	Primary key id
name	text

patient_assessment_demo_secondary_spoken_languages

column	type	description
id	integer	Primary key id
name	text

patient_assessment_demo_sexual_orientations

column	type	description
id	integer	Primary key id
name	text

patient_assessment_domestic_violence_frequencies

column	type	description
id	integer	Primary key id
name	text
value	integer

patient_assessment_duration_last_employments

column	type	description
id	integer	Primary key id
name	text

patient_assessment_education_opportunities_specifies

column	type	description
id	integer	Primary key id
name	text

patient_assessment_employment_statuses

column	type	description
id	integer	Primary key id
name	text

patient_assessment_enhanced_rent_program_types

column	type	description
id	integer	Primary key id
name	text

patient_assessment_er_visits_last12_months

column	type	description
id	integer	Primary key id
name	text

patient_assessment_er_visits_reasons

column	type	description
id	integer	Primary key id
name	text

patient_assessment_hepatitis_statuses

column	type	description
id	integer	Primary key id
name	text

patient_assessment_hepatitis_types

column	type	description
id	integer	Primary key id
name	text

patient_assessment_highest_education_levels

column	type	description
id	integer	Primary key id
name	text

patient_assessment_hiv_statuses

column	type	description
id	integer	Primary key id
name	text

patient_assessment_hospitalization_reasons

column	type	description
id	integer	Primary key id
name	text

patient_assessment_housing_assistance_program_types

column	type	description
id	integer	Primary key id
name	text

patient_assessment_how_long_expected_in_current_living_situations

column	type	description
id	integer	Primary key id
name	text

patient_assessment_hypertension_statuses

column	type	description
id	integer	Primary key id
name	text

patient_assessment_lacks_reliable_transportations

column	type	description
id	integer	Primary key id
name	text

patient_assessment_last_ppd_results

column	type	description
id	integer	Primary key id
name	text

patient_assessment_length_of_stays

column	type	description
id	integer	Primary key id
name	text

patient_assessment_lived_with_most_in_past6_months

column	type	description
id	integer	Primary key id
name	text

patient_assessment_mammogram_statuses

column	type	description
id	integer	Primary key id
name	text

patient_assessment_medication_adherence_difficulty_frequencies

column	type	description
id	integer	Primary key id
name	text

patient_assessment_medication_adherence_last_missed_dose_dates

column	type	description
id	integer	Primary key id
name	text

patient_assessment_medication_adherence_weekly_missed_dose_frequencies

column	type	description
id	integer	Primary key id
name	text

patient_assessment_medication_concerns_reasons

column	type	description
id	integer	Primary key id
name	text

patient_assessment_mh_interested_provider_types

column	type	description
id	integer	Primary key id
name	text

patient_assessment_obesity_statuses

column	type	description
id	integer	Primary key id
name	text

patient_assessment_occasions

column	type	description
id	integer	Primary key id
name	text

patient_assessment_out_of_food_frequencies

column	type	description
id	integer	Primary key id
name	text

patient_assessment_pap_smear_statuses

column	type	description
id	integer	Primary key id
name	text

patient_assessment_pay_rent_reasons

column	type	description
id	integer	Primary key id
name	text

patient_assessment_phq9_qs

column	type	description
id	integer	Primary key id
name	text

patient_assessment_phq9_q10s

column	type	description
id	integer	Primary key id
name	text

patient_assessment_preferred_learning_styles

column	type	description
id	integer	Primary key id
name	text

patient_assessment_pregnancy_statuses

column	type	description
id	integer	Primary key id
name	text

patient_assessment_risk_attempted_suicides

column	type	description
id	integer	Primary key id
name	text

patient_assessment_risk_barriers_to_condom_uses

column	type	description
id	integer	Primary key id
name	text

patient_assessment_risk_history_of_violences

column	type	description
id	integer	Primary key id
name	text

patient_assessment_risk_homicidal_ideations

column	type	description
id	integer	Primary key id
name	text

patient_assessment_risk_how_often_do_you_use_condoms

column	type	description
id	integer	Primary key id
name	text

patient_assessment_risk_thoughts_of_committing_suicides

column	type	description
id	integer	Primary key id
name	text

patient_assessment_su_alcohol_evers

column	type	description
id	integer	Primary key id
name	text

patient_assessment_su_alcohol_last3_months

column	type	description
id	integer	Primary key id
name	text

patient_assessment_su_alcohol_last3_months_frequencies

column	type	description
id	integer	Primary key id
name	text

patient_assessment_su_audit1s

column	type	description
id	integer	Primary key id
name	text

patient_assessment_su_audit10s

column	type	description
id	integer	Primary key id
name	text

patient_assessment_su_audit2s

column	type	description
id	integer	Primary key id
name	text

patient_assessment_su_audit3s

column	type	description
id	integer	Primary key id
name	text

patient_assessment_su_audit4s

column	type	description
id	integer	Primary key id
name	text

patient_assessment_su_audit5s

column	type	description
id	integer	Primary key id
name	text

patient_assessment_su_audit6s

column	type	description
id	integer	Primary key id
name	text

patient_assessment_su_audit7s

column	type	description
id	integer	Primary key id
name	text

patient_assessment_su_audit8s

column	type	description
id	integer	Primary key id
name	text

patient_assessment_su_audit9s

column	type	description
id	integer	Primary key id
name	text

patient_assessment_su_cocaine_evers

column	type	description
id	integer	Primary key id
name	text

patient_assessment_su_cocaine_last3_months

column	type	description
id	integer	Primary key id
name	text

patient_assessment_su_cocaine_last3_months_frequencies

column	type	description
id	integer	Primary key id
name	text

patient_assessment_su_crack_evers

column	type	description
id	integer	Primary key id
name	text

patient_assessment_su_crack_last3_months

column	type	description
id	integer	Primary key id
name	text

patient_assessment_su_crack_last3_months_frequencies

column	type	description
id	integer	Primary key id
name	text

patient_assessment_su_heroin_evers

column	type	description
id	integer	Primary key id
name	text

patient_assessment_su_heroin_last3_months

column	type	description
id	integer	Primary key id
name	text

patient_assessment_su_heroin_last3_months_frequencies

column	type	description
id	integer	Primary key id
name	text

patient_assessment_su_marijuana_evers

column	type	description
id	integer	Primary key id
name	text

patient_assessment_su_marijuana_last3_months

column	type	description
id	integer	Primary key id
name	text

patient_assessment_su_marijuana_last3_months_frequencies

column	type	description
id	integer	Primary key id
name	text

patient_assessment_su_meth_evers

column	type	description
id	integer	Primary key id
name	text

patient_assessment_su_meth_last3_months

column	type	description
id	integer	Primary key id
name	text

patient_assessment_su_meth_last3_months_frequencies

column	type	description
id	integer	Primary key id
name	text

patient_assessment_su_other_substance_evers

column	type	description
id	integer	Primary key id
name	text

patient_assessment_su_other_substance_last3_months

column	type	description
id	integer	Primary key id
name	text

patient_assessment_su_other_substance_last3_months_frequencies

column	type	description
id	integer	Primary key id
name	text

patient_assessment_su_past_treatment_modalities

column	type	description
id	integer	Primary key id
name	text

patient_assessment_su_pcp_hallucinogens_evers

column	type	description
id	integer	Primary key id
name	text

patient_assessment_su_pcp_hallucinogens_last3_months

column	type	description
id	integer	Primary key id
name	text

patient_assessment_su_pcp_hallucinogens_last3_months_frequencies

column	type	description
id	integer	Primary key id
name	text

patient_assessment_su_rx_pills_evers

column	type	description
id	integer	Primary key id
name	text

patient_assessment_su_rx_pills_last3_months

column	type	description
id	integer	Primary key id
name	text

patient_assessment_su_rx_pills_last3_months_frequencies

column	type	description
id	integer	Primary key id
name	text

patient_assessment_su_tobacco_evers

column	type	description
id	integer	Primary key id
name	text

patient_assessment_su_tobacco_last3_months

column	type	description
id	integer	Primary key id
name	text

patient_assessment_su_tobacco_last3_months_frequencies

column	type	description
id	integer	Primary key id
name	text

patient_assessment_supportive_housing_types

column	type	description
id	integer	Primary key id
name	text

patient_assessment_utilities_threatened_off_statuses

column	type	description
id	integer	Primary key id
name	text

patient_assessment_utilizing_hcbs

column	type	description
id	integer	Primary key id
name	text

patient_assessment_worried_out_of_food_frequencies

column	type	description
id	integer	Primary key id
name	text

patient_assessment_write_out_money_order_reasons

column	type	description
id	integer	Primary key id
name	text

patient_assessments

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	Reference to patients primary key id
id	integer	Primary key id
patient_assessment_occasion_id	integer	Reference to patient_assessment_occasions primary key id
patient_assessment_occasion_name	text	(DataStudio only). Value from patient_assessment_occasions.name
created_at	datetime
updated_at	datetime
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id
hiv_test_desired	boolean
hiv_test_referral_location	text
hiv_test_referral_date_test_performed	text
hiv_test_referral_test_result	text
last_cd_4_date	text
last_cd_4_result	text
last_viral_load_date	text
last_viral_load_result	text
last_syphilis_screening_date	text
last_syphilis_screening_result	text
treated_for_syphilis	boolean
treated_for_syphilis_date	text
anal_pap_date	text
anal_pap_result	text
last_a1c_date	text
last_a1c_result	text
last_ldl_date	text
last_ldl_result	text
patient_taking_ace_arbs	boolean
last_potassium_date	text
last_potassium_result	text
last_gfr_date	text
last_gfr_result	text
patient_has_pcp	boolean
pcp_name	text
pcp_facility_name	text
pcp_facility_address	text
pcp_phone	text
is_pcp_hiv_pcp	boolean
last_pcp_visit	text
next_pcp_visit	text
pcp_help_scheduling_appt	boolean
would_like_pcp_assistance	boolean
other_provider_1_provider_name	text
other_provider_1_facility_name	text
other_provider_1_address	text
other_provider_1_phone	text
other_provider_1_specialty	text
other_provider_1_last_visit	text
other_provider_2_provider_name	text
other_provider_2_facility_name	text
other_provider_2_address	text
other_provider_2_phone	text
other_provider_2_specialty	text
other_provider_2_last_visit	text
other_provider_3_provider_name	text
other_provider_3_facility_name	text
other_provider_3_address	text
other_provider_3_phone	text
other_provider_3_specialty	text
other_provider_3_last_visit	text
stayed_overnight_in_hospital	boolean
hospitalization_date	text
name_of_hospital	text
length_of_stay_id	integer	Reference to patient_assessment_length_of_stays primary key id
length_of_stay_name	text	(DataStudio only). Value from patient_assessment_length_of_stays.name
hospitalization_reason_id	integer	Reference to patient_assessment_hospitalization_reasons primary key id
hospitalization_reason_name	text	(DataStudio only). Value from patient_assessment_hospitalization_reasons.name
er_visits_last_12_months_id	integer	Reference to patient_assessment_er_visits_last12_months primary key id
er_visits_last_12_months_name	text	(DataStudio only). Value from patient_assessment_er_visits_last12_months.name
er_visits_reason_id	integer	Reference to patient_assessment_er_visits_reasons primary key id
er_visits_reason_name	text	(DataStudio only). Value from patient_assessment_er_visits_reasons.name
name_of_er	text
patient_on_medications_right_now	boolean
medication_issues_or_concerns	boolean
medication_concerns_reason_id	integer	Reference to patient_assessment_medication_concerns_reasons primary key id
medication_concerns_reason_name	text	(DataStudio only). Value from patient_assessment_medication_concerns_reasons.name
medication_advice_desired	boolean
medication_adherence_difficulty_frequency_id	integer	Reference to patient_assessment_medication_adherence_difficulty_frequencies primary key id
medication_adherence_difficulty_frequency_name	text	(DataStudio only). Value from patient_assessment_medication_adherence_difficulty_frequencies.name
medication_adherence_weekly_missed_dose_frequency_id	integer	Reference to patient_assessment_medication_adherence_weekly_missed_dose_frequencies primary key id
medication_adherence_weekly_missed_dose_frequency_name	text	(DataStudio only). Value from patient_assessment_medication_adherence_weekly_missed_dose_frequencies.name
medication_adherence_last_missed_dose_date_id	integer	Reference to patient_assessment_medication_adherence_last_missed_dose_dates primary key id
medication_adherence_last_missed_dose_date_name	text	(DataStudio only). Value from patient_assessment_medication_adherence_last_missed_dose_dates.name
medication_adherence_score	integer
patient_out_of_medications	boolean
patient_has_dnr	boolean
patient_has_healthcare_proxy	boolean
healthcare_proxy_name	text
healthcare_proxy_phone	text
patient_has_allergies	boolean
medication_allergies	text
food_allergies	text
environmental_allergies	text
patient_in_pain_today	boolean
level_of_pain	integer
hpv_vaccine_interest	boolean
pregnancy_status_id	integer	Reference to patient_assessment_pregnancy_statuses primary key id
pregnancy_status_name	text	(DataStudio only). Value from patient_assessment_pregnancy_statuses.name
estimated_due_date	text
enrolled_in_prenatal_care	boolean
prenatal_provider_name	text
prenatal_provider_address	text
prenatal_provider_phone	text
last_prenatal_visit_date	text
next_prenatal_visit_date	text
last_mammogram_date	text
last_mammogram_result	text
last_mammogram_occurred_in_past_year	boolean
last_mammogram_provider_name	text
last_mammogram_provider_address	text
last_mammogram_provider_phone	text
last_pap_date	text
last_pap_result	text
last_pap_occurred_in_past_year	boolean
last_pap_provider_name	text
last_pap_provider_address	text
last_pap_provider_phone	text
colonoscopy_performed	boolean
colonoscopy_date	text
colonoscopy_result	text
colonoscopy_provider_name	text
colonoscopy_provider_address	text
colonoscopy_provider_phone	text
vision_provider_name	text
vision_provider_address	text
vision_provider_phone	text
dental_provider_name	text
dental_provider_address	text
dental_provider_phone	text
information_about_immunizations	boolean
last_ppd_date	text
last_ppd_result_id	integer	Reference to patient_assessment_last_ppd_results primary key id
last_ppd_result_name	text	(DataStudio only). Value from patient_assessment_last_ppd_results.name
last_chest_xray	text
hepatitis_status_id	integer	Reference to patient_assessment_hepatitis_statuses primary key id
hepatitis_status_name	text	(DataStudio only). Value from patient_assessment_hepatitis_statuses.name
hepatitis_type_id	integer	Reference to patient_assessment_hepatitis_types primary key id
hepatitis_type_name	text	(DataStudio only). Value from patient_assessment_hepatitis_types.name
hepatitis_vaccinations_received	boolean
hepatitis_vaccinations_interest	boolean
seasonal_flu_vaccine_received	boolean
seasonal_flu_vaccine_date	text
seasonal_flu_vaccine_interest	boolean
pneumovax_vaccine_received	boolean
pneumovax_vaccine_date	text
pneumovax_vaccine_interest	boolean
currently_receiving_mh_treatment	boolean
mh_current_provider_type_id	integer	Reference to care_team_provider_types primary key id
mh_current_provider_type_name	text	(DataStudio only). Value from care_team_provider_types.name
mh_current_provider_name	text
mh_current_address	text
mh_current_phone	text
interested_in_receiving_mh_treatment	boolean
mh_interested_provider_type_id	integer	Reference to patient_assessment_mh_interested_provider_types primary key id
mh_interested_provider_type_name	text	(DataStudio only). Value from patient_assessment_mh_interested_provider_types.name
mh_interested_provider_name	text
mh_interested_address	text
mh_interested_phone	text
keeps_mh_appointments_consistently	boolean
barriers_to_keeping_mh_appts_id	integer	Reference to patient_assessment_barriers_to_keeping_mh_appts primary key id
barriers_to_keeping_mh_appts_name	text	(DataStudio only). Value from patient_assessment_barriers_to_keeping_mh_appts.name
phq2_q1	boolean
phq2_q2	boolean
phq9_q1_id	integer	Reference to patient_assessment_phq9_qs primary key id
phq9_q1_name	text	(DataStudio only). Value from patient_assessment_phq9_qs.name
phq9_q2_id	integer	Reference to patient_assessment_phq9_qs primary key id
phq9_q2_name	text	(DataStudio only). Value from patient_assessment_phq9_qs.name
phq9_q3_id	integer	Reference to patient_assessment_phq9_qs primary key id
phq9_q3_name	text	(DataStudio only). Value from patient_assessment_phq9_qs.name
phq9_q4_id	integer	Reference to patient_assessment_phq9_qs primary key id
phq9_q4_name	text	(DataStudio only). Value from patient_assessment_phq9_qs.name
phq9_q5_id	integer	Reference to patient_assessment_phq9_qs primary key id
phq9_q5_name	text	(DataStudio only). Value from patient_assessment_phq9_qs.name
phq9_q6_id	integer	Reference to patient_assessment_phq9_qs primary key id
phq9_q6_name	text	(DataStudio only). Value from patient_assessment_phq9_qs.name
phq9_q7_id	integer	Reference to patient_assessment_phq9_qs primary key id
phq9_q7_name	text	(DataStudio only). Value from patient_assessment_phq9_qs.name
phq9_q8_id	integer	Reference to patient_assessment_phq9_qs primary key id
phq9_q8_name	text	(DataStudio only). Value from patient_assessment_phq9_qs.name
phq9_q9_id	integer	Reference to patient_assessment_phq9_qs primary key id
phq9_q9_name	text	(DataStudio only). Value from patient_assessment_phq9_qs.name
phq9_q10_id	integer	Reference to patient_assessment_phq9_q10s primary key id
phq9_q10_name	text	(DataStudio only). Value from patient_assessment_phq9_q10s.name
phq9_score	integer
su_tobacco_ever_id	integer	Reference to patient_assessment_su_tobacco_evers primary key id
su_tobacco_ever_name	text	(DataStudio only). Value from patient_assessment_su_tobacco_evers.name
su_tobacco_last_3_months_id	integer	Reference to patient_assessment_su_tobacco_last3_months primary key id
su_tobacco_last_3_months_name	text	(DataStudio only). Value from patient_assessment_su_tobacco_last3_months.name
su_tobacco_last_3_months_frequency_id	integer	Reference to patient_assessment_su_tobacco_last3_months_frequencies primary key id
su_tobacco_last_3_months_frequency_name	text	(DataStudio only). Value from patient_assessment_su_tobacco_last3_months_frequencies.name
su_alcohol_ever_id	integer	Reference to patient_assessment_su_alcohol_evers primary key id
su_alcohol_ever_name	text	(DataStudio only). Value from patient_assessment_su_alcohol_evers.name
su_alcohol_last_3_months_id	integer	Reference to patient_assessment_su_alcohol_last3_months primary key id
su_alcohol_last_3_months_name	text	(DataStudio only). Value from patient_assessment_su_alcohol_last3_months.name
su_alcohol_last_3_months_frequency_id	integer	Reference to patient_assessment_su_alcohol_last3_months_frequencies primary key id
su_alcohol_last_3_months_frequency_name	text	(DataStudio only). Value from patient_assessment_su_alcohol_last3_months_frequencies.name
su_marijuana_ever_id	integer	Reference to patient_assessment_su_marijuana_evers primary key id
su_marijuana_ever_name	text	(DataStudio only). Value from patient_assessment_su_marijuana_evers.name
su_marijuana_last_3_months_id	integer	Reference to patient_assessment_su_marijuana_last3_months primary key id
su_marijuana_last_3_months_name	text	(DataStudio only). Value from patient_assessment_su_marijuana_last3_months.name
su_marijuana_last_3_months_frequency_id	integer	Reference to patient_assessment_su_marijuana_last3_months_frequencies primary key id
su_marijuana_last_3_months_frequency_name	text	(DataStudio only). Value from patient_assessment_su_marijuana_last3_months_frequencies.name
su_cocaine_ever_id	integer	Reference to patient_assessment_su_cocaine_evers primary key id
su_cocaine_ever_name	text	(DataStudio only). Value from patient_assessment_su_cocaine_evers.name
su_cocaine_last_3_months_id	integer	Reference to patient_assessment_su_cocaine_last3_months primary key id
su_cocaine_last_3_months_name	text	(DataStudio only). Value from patient_assessment_su_cocaine_last3_months.name
su_cocaine_last_3_months_frequency_id	integer	Reference to patient_assessment_su_cocaine_last3_months_frequencies primary key id
su_cocaine_last_3_months_frequency_name	text	(DataStudio only). Value from patient_assessment_su_cocaine_last3_months_frequencies.name
su_crack_ever_id	integer	Reference to patient_assessment_su_crack_evers primary key id
su_crack_ever_name	text	(DataStudio only). Value from patient_assessment_su_crack_evers.name
su_crack_last_3_months_id	integer	Reference to patient_assessment_su_crack_last3_months primary key id
su_crack_last_3_months_name	text	(DataStudio only). Value from patient_assessment_su_crack_last3_months.name
su_crack_last_3_months_frequency_id	integer	Reference to patient_assessment_su_crack_last3_months_frequencies primary key id
su_crack_last_3_months_frequency_name	text	(DataStudio only). Value from patient_assessment_su_crack_last3_months_frequencies.name
su_heroin_ever_id	integer	Reference to patient_assessment_su_heroin_evers primary key id
su_heroin_ever_name	text	(DataStudio only). Value from patient_assessment_su_heroin_evers.name
su_heroin_last_3_months_id	integer	Reference to patient_assessment_su_heroin_last3_months primary key id
su_heroin_last_3_months_name	text	(DataStudio only). Value from patient_assessment_su_heroin_last3_months.name
su_heroin_last_3_months_frequency_id	integer	Reference to patient_assessment_su_heroin_last3_months_frequencies primary key id
su_heroin_last_3_months_frequency_name	text	(DataStudio only). Value from patient_assessment_su_heroin_last3_months_frequencies.name
su_pcp_hallucinogens_ever_id	integer	Reference to patient_assessment_su_pcp_hallucinogens_evers primary key id
su_pcp_hallucinogens_ever_name	text	(DataStudio only). Value from patient_assessment_su_pcp_hallucinogens_evers.name
su_pcp_hallucinogens_last_3_months_id	integer	Reference to patient_assessment_su_pcp_hallucinogens_last3_months primary key id
su_pcp_hallucinogens_last_3_months_name	text	(DataStudio only). Value from patient_assessment_su_pcp_hallucinogens_last3_months.name
su_pcp_hallucinogens_last_3_months_frequency_id	integer	Reference to patient_assessment_su_pcp_hallucinogens_last3_months_frequencies primary key id
su_pcp_hallucinogens_last_3_months_frequency_name	text	(DataStudio only). Value from patient_assessment_su_pcp_hallucinogens_last3_months_frequencies.name
su_meth_ever_id	integer	Reference to patient_assessment_su_meth_evers primary key id
su_meth_ever_name	text	(DataStudio only). Value from patient_assessment_su_meth_evers.name
su_meth_last_3_months_id	integer	Reference to patient_assessment_su_meth_last3_months primary key id
su_meth_last_3_months_name	text	(DataStudio only). Value from patient_assessment_su_meth_last3_months.name
su_meth_last_3_months_frequency_id	integer	Reference to patient_assessment_su_meth_last3_months_frequencies primary key id
su_meth_last_3_months_frequency_name	text	(DataStudio only). Value from patient_assessment_su_meth_last3_months_frequencies.name
su_rx_pills_ever_id	integer	Reference to patient_assessment_su_rx_pills_evers primary key id
su_rx_pills_ever_name	text	(DataStudio only). Value from patient_assessment_su_rx_pills_evers.name
su_rx_pills_last_3_months_id	integer	Reference to patient_assessment_su_rx_pills_last3_months primary key id
su_rx_pills_last_3_months_name	text	(DataStudio only). Value from patient_assessment_su_rx_pills_last3_months.name
su_rx_pills_last_3_months_frequency_id	integer	Reference to patient_assessment_su_rx_pills_last3_months_frequencies primary key id
su_rx_pills_last_3_months_frequency_name	text	(DataStudio only). Value from patient_assessment_su_rx_pills_last3_months_frequencies.name
su_problem	boolean
su_reduction_interest	boolean
su_reduction_specify	text
su_treatment_harm_reduction_current	boolean
su_treatment_self_help_current	boolean
su_treatment_recovery_readiness_current	boolean
su_treatment_outpatient_substance_current	boolean
su_treatment_outpatient_alcohol_current	boolean
su_treatment_methadone_maintenance_current	boolean
su_treatment_inpatient_substance_current	boolean
su_treatment_inpatient_alcohol_current	boolean
su_treatment_detox_current	boolean
su_current_provider_facility_name	text
su_current_provider_address	text
su_current_provider_phone	text
su_current_treatment_date_started	text
su_treatment_interest	boolean
su_treatment_interest_harm_reduction	boolean
su_treatment_interest_inpatient	boolean
su_treatment_interest_outpatient	boolean
su_treatment_interest_detox	boolean
current_living_situation_id	integer	Reference to patient_assessment_current_living_situations primary key id
current_living_situation_name	text	(DataStudio only). Value from patient_assessment_current_living_situations.name
current_living_situation_since_when	text
homeless_zip_code	text
hiv_housing_program	text
current_housing_issues	boolean
doubled_up_in_unit	boolean
health_safety_concerns	boolean
eviction_or_pending_eviction	boolean
expanding_household_space_issue	boolean
conflict_with_others_in_household	boolean
release_from_institutional_setting	boolean
other_housing_issues	text
income_per_month	text
receives_salary_regular_employment	boolean
receives_unemployment	boolean
receives_alimony_or_child_support	boolean
receives_veterans_benefits	boolean
receives_enhanced_rent	boolean
receives_energy_assistance	boolean
receives_social_security	boolean
receives_medicaid_medicare	boolean
receives_hasa	boolean
receives_public_assistance	boolean
receives_ssi	boolean
receives_ssd	boolean
receives_food_stamps	boolean
receives_tanf	boolean
receives_other_entitlements	text
hasa_pa_worker	text
hasa_pa_worker_telephone_number	text
hasa_pa_center	text
hasa_pa_supervisor_name	text
hasa_pa_supervisor_number	text
in_rental_arrears	boolean
rental_arrears_amount	text
total_monthly_expenses	text
has_a_representative_payee	boolean
representative_payee_name	text
interested_in_setting_up_direct_rent_payments	boolean
needs_fair_hearing_appeal_process	boolean
explain_needs_fair_hearing_appeal_process	text
medicaid_recertification_date	text
has_spend_downs	boolean
spend_down_amount_per_month	text
number_household_members	integer
household_member_1_name	text
household_member_1_age	text
household_member_1_relationship	text
household_member_1_hiv_status	text
household_member_2_name	text
household_member_2_age	text
household_member_2_relationship	text
household_member_2_hiv_status	text
household_member_3_name	text
household_member_3_age	text
household_member_3_relationship	text
household_member_3_hiv_status	text
household_member_4_name	text
household_member_4_age	text
household_member_4_relationship	text
household_member_4_hiv_status	text
household_member_5_name	text
household_member_5_age	text
household_member_5_relationship	text
household_member_5_hiv_status	text
ever_had_acs_case	boolean
acs_case_reason_id	integer	Reference to patient_assessment_acs_case_reasons primary key id
acs_case_reason_name	text	(DataStudio only). Value from patient_assessment_acs_case_reasons.name
acs_case_currently_open	boolean
acs_caseworker	text
acs_caseworker_phone	text
someone_to_talk_to	boolean
has_religious_affiliation	boolean
religious_affiliation_type	text
has_child_with_medical_issues	boolean
children_medical_issues_specify	text
has_child_with_mh_issues	boolean
children_mh_issues_specify	text
ever_been_incarcerated	boolean
incarcerated_where	text
incarcerated_when	text
incarceration_length	text
incarceration_nature	text
currently_on_parole_or_probation	boolean
po_name	text
po_phone	text
parole_until_when	text
assistance_specify_other_type	text
receiving_home_care	boolean
home_care_agency_name	text
home_care_agency_phone	text
home_care_frequency	text
home_care_satisfied	boolean
assistance_bathing_id	integer	Reference to patient_assessment_assistance_bathings primary key id
assistance_bathing_name	text	(DataStudio only). Value from patient_assessment_assistance_bathings.name
assistance_toileting_id	integer	Reference to patient_assessment_assistance_toiletings primary key id
assistance_toileting_name	text	(DataStudio only). Value from patient_assessment_assistance_toiletings.name
assistance_medications_id	integer	Reference to patient_assessment_assistance_medications primary key id
assistance_medications_name	text	(DataStudio only). Value from patient_assessment_assistance_medications.name
assistance_meals_id	integer	Reference to patient_assessment_assistance_meals primary key id
assistance_meals_name	text	(DataStudio only). Value from patient_assessment_assistance_meals.name
assistance_housekeeping_id	integer	Reference to patient_assessment_assistance_housekeepings primary key id
assistance_housekeeping_name	text	(DataStudio only). Value from patient_assessment_assistance_housekeepings.name
assistance_shopping_id	integer	Reference to patient_assessment_assistance_shoppings primary key id
assistance_shopping_name	text	(DataStudio only). Value from patient_assessment_assistance_shoppings.name
assistive_equipment_id	integer	Reference to patient_assessment_assistive_equipments primary key id
assistive_equipment_name	text	(DataStudio only). Value from patient_assessment_assistive_equipments.name
assistive_equipment_other	text
assistance_transportation_id	integer	Reference to patient_assessment_assistance_transportations primary key id
assistance_transportation_name	text	(DataStudio only). Value from patient_assessment_assistance_transportations.name
highest_education_level_id	integer	Reference to patient_assessment_highest_education_levels primary key id
highest_education_level_name	text	(DataStudio only). Value from patient_assessment_highest_education_levels.name
interested_in_education_opportunities	boolean
education_opportunities_specify_id	integer	Reference to patient_assessment_education_opportunities_specifies primary key id
education_opportunities_specify_name	text	(DataStudio only). Value from patient_assessment_education_opportunities_specifies.name
preferred_learning_style_id	integer	Reference to patient_assessment_preferred_learning_styles primary key id
preferred_learning_style_name	text	(DataStudio only). Value from patient_assessment_preferred_learning_styles.name
preferred_learning_style_other	text
learning_barriers_blindness	boolean
learning_barriers_deafness	boolean
learning_barriers_understanding	boolean
learning_barriers_reading	boolean
learning_barriers_learning_disability	boolean
learning_barriers_developmental_disability	boolean
learning_barriers_other_disability	boolean
learning_barriers_other_disability_specify	text
benefit_health_literacy_med_adherence	boolean
benefit_health_literacy_medical	boolean
benefit_health_literacy_mh	boolean
benefit_health_literacy_substance_abuse	boolean
risk_how_often_do_you_use_condoms_id	integer	Reference to patient_assessment_risk_how_often_do_you_use_condoms primary key id
risk_how_often_do_you_use_condoms_name	text	(DataStudio only). Value from patient_assessment_risk_how_often_do_you_use_condoms.name
risk_barriers_to_condom_use_id	integer	Reference to patient_assessment_risk_barriers_to_condom_uses primary key id
risk_barriers_to_condom_use_name	text	(DataStudio only). Value from patient_assessment_risk_barriers_to_condom_uses.name
risk_ever_been_hurt_or_afraid	boolean
risk_hurt_explain	text
risk_feels_unsafe_in_current_environment	boolean
risk_feels_unsafe_explain	text
risk_how_is_situation_today	text
risk_in_a_violent_relationship	boolean
risk_violent_relationship_explain	text
risk_has_a_safety_plan	boolean
risk_in_controlling_relationship	boolean
risk_in_controlling_relationship_explain	text
risk_thoughts_of_committing_suicide_id	integer	Reference to patient_assessment_risk_thoughts_of_committing_suicides primary key id
risk_thoughts_of_committing_suicide_name	text	(DataStudio only). Value from patient_assessment_risk_thoughts_of_committing_suicides.name
risk_explain_suicidal_past	text
risk_has_suicide_plan	boolean
risk_has_suicide_plan_explain	text
risk_attempted_suicide_id	integer	Reference to patient_assessment_risk_attempted_suicides primary key id
risk_attempted_suicide_name	text	(DataStudio only). Value from patient_assessment_risk_attempted_suicides.name
risk_attempted_suicide_dates	text
risk_attempted_suicide_method	text
risk_attempted_suicide_precipitating_events	text
risk_history_of_violence_id	integer	Reference to patient_assessment_risk_history_of_violences primary key id
risk_history_of_violence_name	text	(DataStudio only). Value from patient_assessment_risk_history_of_violences.name
risk_history_of_violence_explanation	text
risk_homicidal_ideation_id	integer	Reference to patient_assessment_risk_homicidal_ideations primary key id
risk_homicidal_ideation_name	text	(DataStudio only). Value from patient_assessment_risk_homicidal_ideations.name
risk_past_homicidal_ideation_explain	text
risk_date_of_last_ideation	text
risk_present_homicidal_ideation_explain	text
risk_poor_nutrition	boolean
risk_poor_hygiene	boolean
risk_safety_issues	boolean
risk_med_treat_refusal	boolean
risk_other	boolean
summary_substance_use	text
deprecated_summary_cm_signature	text
mark_as_done_date	date
deprecated_summary_supervisor_signature	text
supervisor_approval_date	date
employment_status_id	integer	Reference to patient_assessment_employment_statuses primary key id
employment_status_name	text	(DataStudio only). Value from patient_assessment_employment_statuses.name
interested_finding_job	boolean
finding_job_employment_agency_referral	boolean
finding_job_readiness_training	boolean
finding_job_occupational_training	boolean
assistance_will_id	integer	Reference to patient_assessment_assistance_wills primary key id
assistance_will_name	text	(DataStudio only). Value from patient_assessment_assistance_wills.name
assistance_living_will_id	integer	Reference to patient_assessment_assistance_living_wills primary key id
assistance_living_will_name	text	(DataStudio only). Value from patient_assessment_assistance_living_wills.name
assistance_power_of_attorney_id	integer	Reference to patient_assessment_assistance_power_of_attorneys primary key id
assistance_power_of_attorney_name	text	(DataStudio only). Value from patient_assessment_assistance_power_of_attorneys.name
assistance_immigration_status_id	integer	Reference to patient_assessment_assistance_immigration_statuses primary key id
assistance_immigration_status_name	text	(DataStudio only). Value from patient_assessment_assistance_immigration_statuses.name
assistance_standby_guardianship_id	integer	Reference to patient_assessment_assistance_standby_guardianships primary key id
assistance_standby_guardianship_name	text	(DataStudio only). Value from patient_assessment_assistance_standby_guardianships.name
assistance_permanency_planning_id	integer	Reference to patient_assessment_assistance_permanency_plannings primary key id
assistance_permanency_planning_name	text	(DataStudio only). Value from patient_assessment_assistance_permanency_plannings.name
assistance_other_type_id	integer	Reference to patient_assessment_assistance_other_types primary key id
assistance_other_type_name	text	(DataStudio only). Value from patient_assessment_assistance_other_types.name
summary	text
demo_ssn	text
demo_address	text
demo_phone_home	text
demo_phone_cell	text
demo_email_address	text
demo_emergency_contact_name	text
demo_emergency_contact_relationship_to_client	text
demo_emergency_contact_phone_home	text
demo_emergency_contact_phone_cell	text
demo_emergency_contact_address	text
demo_pharmacy_name	text
demo_pharmacy_phone	text
demo_gender_id	integer	Reference to patient_assessment_demo_genders primary key id
demo_gender_name	text	(DataStudio only). Value from patient_assessment_demo_genders.name
demo_race_id	integer	Reference to patient_races primary key id
demo_race_name	text	(DataStudio only). Value from patient_races.name
demo_race_other	text
demo_ethnicity_id	integer	Reference to patient_assessment_demo_ethnicities primary key id
demo_ethnicity_name	text	(DataStudio only). Value from patient_assessment_demo_ethnicities.name
demo_primary_spoken_language_id	integer	Reference to patient_primary_spoken_languages primary key id
demo_primary_spoken_language_name	text	(DataStudio only). Value from patient_primary_spoken_languages.name
demo_secondary_spoken_language_id	integer	Reference to patient_assessment_demo_secondary_spoken_languages primary key id
demo_secondary_spoken_language_name	text	(DataStudio only). Value from patient_assessment_demo_secondary_spoken_languages.name
demo_citizenship_status_id	integer	Reference to patient_assessment_demo_citizenship_statuses primary key id
demo_citizenship_status_name	text	(DataStudio only). Value from patient_assessment_demo_citizenship_statuses.name
demo_other_country_of_citizenship	text
demo_sexual_orientation_id	integer	Reference to patient_assessment_demo_sexual_orientations primary key id
demo_sexual_orientation_name	text	(DataStudio only). Value from patient_assessment_demo_sexual_orientations.name
demo_best_contact_method_id	integer	Reference to patient_assessment_demo_best_contact_methods primary key id
demo_best_contact_method_name	text	(DataStudio only). Value from patient_assessment_demo_best_contact_methods.name
demo_can_receive_texts	boolean
hospitalization_reason_other	text
er_visits_reason_other	text
demo_primary_spoken_language_other	text
demo_secondary_spoken_language_other	text
imported	boolean
import_record_unique_identifier	text
assessment_text	text
ever_tested_hiv	boolean
social_worker_info	text
last_blood_pressure_date	text
last_blood_pressure_result	text
blood_pressure_monitor_at_home	boolean
mh_treatment_in_past	boolean
mh_treatment_in_past_explain	text
mh_currently_feel_stable	boolean
mh_currently_feel_stable_explain	text
medical_disclosure_issues	boolean
medical_disclosure_issues_explain	text
additional_medical_concerns	boolean
additional_medical_concerns_explain	text
last_bmi_date	text
last_bmi_result	text
vision_visit_past_year	boolean
dental_visit_past_year	boolean
podiatrist_visit_past_year	boolean
keeps_medical_appointments_consistently	boolean
nutrition_visit_past_six_months	boolean
other_provider_1_follow_up_appt_needed	boolean
other_provider_2_follow_up_appt_needed	boolean
other_provider_3_follow_up_appt_needed	boolean
su_other_substance_ever_id	integer	Reference to patient_assessment_su_other_substance_evers primary key id
su_other_substance_ever_name	text	(DataStudio only). Value from patient_assessment_su_other_substance_evers.name
su_other_substance_last_3_months_id	integer	Reference to patient_assessment_su_other_substance_last3_months primary key id
su_other_substance_last_3_months_name	text	(DataStudio only). Value from patient_assessment_su_other_substance_last3_months.name
su_other_substance_last_3_months_frequency_id	integer	Reference to patient_assessment_su_other_substance_last3_months_frequencies primary key id
su_other_substance_last_3_months_frequency_name	text	(DataStudio only). Value from patient_assessment_su_other_substance_last3_months_frequencies.name
su_modality	text
su_when_where	text
su_ever_been_in_treatment_program	boolean
su_treatment_harm_reduction_past	boolean
su_treatment_self_help_past	boolean
su_treatment_recovery_readiness_past	boolean
su_treatment_outpatient_substance_past	boolean
su_treatment_outpatient_alcohol_past	boolean
su_treatment_methadone_maintenance_past	boolean
su_treatment_inpatient_substance_past	boolean
su_treatment_inpatient_alcohol_past	boolean
su_treatment_detox_past	boolean
supportive_housing_program_name	text
supportive_housing_case_manager	text
need_help_with_housing	boolean
need_help_with_housing_explain	text
enhanced_rent_program_type_id	integer	Reference to patient_assessment_enhanced_rent_program_types primary key id
enhanced_rent_program_type_name	text	(DataStudio only). Value from patient_assessment_enhanced_rent_program_types.name
enhanced_rent_program_type_other	text
rental_arrears_reason	text
has_children	boolean
number_of_children	integer
nys_id	text
podiatry_provider_name	text
podiatry_provider_address	text
podiatry_provider_phone	text
su_other_substance_specify	text
su_audit_1_id	integer	Reference to patient_assessment_su_audit1s primary key id
su_audit_1_name	text	(DataStudio only). Value from patient_assessment_su_audit1s.name
su_audit_2_id	integer	Reference to patient_assessment_su_audit2s primary key id
su_audit_2_name	text	(DataStudio only). Value from patient_assessment_su_audit2s.name
su_audit_3_id	integer	Reference to patient_assessment_su_audit3s primary key id
su_audit_3_name	text	(DataStudio only). Value from patient_assessment_su_audit3s.name
su_audit_4_id	integer	Reference to patient_assessment_su_audit4s primary key id
su_audit_4_name	text	(DataStudio only). Value from patient_assessment_su_audit4s.name
su_audit_5_id	integer	Reference to patient_assessment_su_audit5s primary key id
su_audit_5_name	text	(DataStudio only). Value from patient_assessment_su_audit5s.name
su_audit_6_id	integer	Reference to patient_assessment_su_audit6s primary key id
su_audit_6_name	text	(DataStudio only). Value from patient_assessment_su_audit6s.name
su_audit_7_id	integer	Reference to patient_assessment_su_audit7s primary key id
su_audit_7_name	text	(DataStudio only). Value from patient_assessment_su_audit7s.name
su_audit_8_id	integer	Reference to patient_assessment_su_audit8s primary key id
su_audit_8_name	text	(DataStudio only). Value from patient_assessment_su_audit8s.name
su_audit_9_id	integer	Reference to patient_assessment_su_audit9s primary key id
su_audit_9_name	text	(DataStudio only). Value from patient_assessment_su_audit9s.name
su_audit_10_id	integer	Reference to patient_assessment_su_audit10s primary key id
su_audit_10_name	text	(DataStudio only). Value from patient_assessment_su_audit10s.name
su_dast_1	boolean
su_dast_2	boolean
su_dast_3	boolean
su_dast_4	boolean
su_dast_5	boolean
su_dast_6	boolean
su_dast_7	boolean
su_dast_8	boolean
su_dast_9	boolean
su_dast_10	boolean
demo_read_english	boolean
demo_read_other_language	boolean
demographics_notes	text
medical_notes	text
mental_health_notes	text
phq_9_notes	text
substance_use_notes	text
housing_notes	text
income_entitlements_notes	text
family_notes	text
legal_notes	text
adl_notes	text
education_notes	text
employment_notes	text
risk_assessment_notes	text
pcp_title	text
pcp_first_name	text
pcp_last_name	text
pcp_credentials	text
pcp_notes	text
other_provider_1_provider_title	text
other_provider_1_provider_first_name	text
other_provider_1_provider_last_name	text
other_provider_1_provider_credentials	text
other_provider_2_provider_title	text
other_provider_2_provider_first_name	text
other_provider_2_provider_last_name	text
other_provider_2_provider_credentials	text
other_provider_3_provider_title	text
other_provider_3_provider_first_name	text
other_provider_3_provider_last_name	text
other_provider_3_provider_credentials	text
prenatal_provider_title	text
prenatal_provider_first_name	text
prenatal_provider_last_name	text
prenatal_provider_credentials	text
prenatal_provider_facility	text
prenatal_provider_notes	text
vision_provider_title	text
vision_provider_first_name	text
vision_provider_last_name	text
vision_provider_credentials	text
vision_provider_facility	text
vision_provider_notes	text
dental_provider_title	text
dental_provider_first_name	text
dental_provider_last_name	text
dental_provider_credentials	text
dental_provider_facility	text
dental_provider_notes	text
mh_current_provider_title	text
mh_current_provider_first_name	text
mh_current_provider_last_name	text
mh_current_provider_credentials	text
mh_current_provider_facility	text
mh_current_provider_notes	text
su_current_provider_notes	text
podiatry_provider_title	text
podiatry_provider_first_name	text
podiatry_provider_last_name	text
podiatry_provider_credentials	text
podiatry_provider_facility	text
podiatry_provider_notes	text
pcp_specialty	text
pcp_date_started	text
pcp_followup_needed	boolean
pcp_email	text
dental_has_provider	boolean
mh_has_provider	boolean
podiatry_has_provider	boolean
prenatal_has_provider	boolean
pcp_has_provider	boolean
su_has_provider	boolean
vision_has_provider	boolean
su_current_provider_specialty	text
su_current_provider_start_date	text
su_current_provider_title	text
su_current_provider_first_name	text
su_current_provider_last_name	text
su_current_provider_credentials	text
su_current_provider_email	text
assessment_type	text
completion_date	date
notes	text
document	text
import_comprehensive_assessment_file_id	integer
uploaded_file	text
patient_assessment_comprehensive_id	integer
chart_id	integer	Reference to charts primary key id
someone_to_talk_to_description	text
outreach_plan	text
patient_strengths	text
patient_treatment_preferences	text
patient_barriers_to_care	text
strategies_to_overcome_barriers	text
disaster_plan	text
demo_cultural_preferences	text
physical_rehab_has_provider	boolean
physical_rehab_visit_past_year	boolean
physical_rehab_provider_title	text
physical_rehab_provider_first_name	text
physical_rehab_provider_last_name	text
physical_rehab_provider_credentials	text
physical_rehab_provider_facility	text
physical_rehab_provider_address	text
physical_rehab_provider_phone	text
physical_rehab_provider_notes	text
patient_assessed_for_hcbs_id	integer	Reference to patient_assessment_assessed_for_hcbs primary key id
patient_assessed_for_hcbs_name	text	(DataStudio only). Value from patient_assessment_assessed_for_hcbs.name
plan_for_hcbs_assessment	text
patient_utilizing_hcbs_id	integer	Reference to patient_assessment_utilizing_hcbs primary key id
patient_utilizing_hcbs_name	text	(DataStudio only). Value from patient_assessment_utilizing_hcbs.name
next_steps_to_engage_in_hcbs	text
other_provider_1_has_provider	boolean
other_provider_2_has_provider	boolean
other_provider_3_has_provider	boolean
had_syphilis_screening	boolean
had_anal_pap	boolean
hiv_status_id	integer	Reference to patient_assessment_hiv_statuses primary key id
hiv_status_name	text	(DataStudio only). Value from patient_assessment_hiv_statuses.name
diabetes_status_id	integer	Reference to patient_assessment_diabetes_statuses primary key id
diabetes_status_name	text	(DataStudio only). Value from patient_assessment_diabetes_statuses.name
hypertension_status_id	integer	Reference to patient_assessment_hypertension_statuses primary key id
hypertension_status_name	text	(DataStudio only). Value from patient_assessment_hypertension_statuses.name
obesity_status_id	integer	Reference to patient_assessment_obesity_statuses primary key id
obesity_status_name	text	(DataStudio only). Value from patient_assessment_obesity_statuses.name
mammogram_status_id	integer	Reference to patient_assessment_mammogram_statuses primary key id
mammogram_status_name	text	(DataStudio only). Value from patient_assessment_mammogram_statuses.name
pap_smear_status_id	integer	Reference to patient_assessment_pap_smear_statuses primary key id
pap_smear_status_name	text	(DataStudio only). Value from patient_assessment_pap_smear_statuses.name
su_treatment_interest_other	text
has_hasa_pa_worker	boolean
learning_barriers_none	boolean
benefit_health_literacy_none	boolean
finding_job_other_resource	text
risk_self_neglect_none	boolean
risk_other_specify	text
current_living_situation_status_id	integer	Reference to patient_assessment_current_living_situation_statuses primary key id
current_living_situation_status_name	text	(DataStudio only). Value from patient_assessment_current_living_situation_statuses.name
housing_problem_pest	boolean
housing_problem_mold	boolean
housing_problem_lead	boolean
housing_problem_heat	boolean
housing_problem_oven	boolean
housing_problem_smoke_detector	boolean
housing_problem_water_leak	boolean
housing_problem_none	boolean
risk_physically_hurt_frequency_id	integer	Reference to patient_assessment_domestic_violence_frequencies primary key id
risk_physically_hurt_frequency_name	text	(DataStudio only). Value from patient_assessment_domestic_violence_frequencies.name
risk_insult_frequency_id	integer	Reference to patient_assessment_domestic_violence_frequencies primary key id
risk_insult_frequency_name	text	(DataStudio only). Value from patient_assessment_domestic_violence_frequencies.name
risk_threaten_frequency_id	integer	Reference to patient_assessment_domestic_violence_frequencies primary key id
risk_threaten_frequency_name	text	(DataStudio only). Value from patient_assessment_domestic_violence_frequencies.name
risk_scream_frequency_id	integer	Reference to patient_assessment_domestic_violence_frequencies primary key id
risk_scream_frequency_name	text	(DataStudio only). Value from patient_assessment_domestic_violence_frequencies.name
risk_safety_plan	text
worried_out_of_food_frequency_id	integer	Reference to patient_assessment_worried_out_of_food_frequencies primary key id
worried_out_of_food_frequency_name	text	(DataStudio only). Value from patient_assessment_worried_out_of_food_frequencies.name
out_of_food_frequency_id	integer	Reference to patient_assessment_out_of_food_frequencies primary key id
out_of_food_frequency_name	text	(DataStudio only). Value from patient_assessment_out_of_food_frequencies.name
utilities_threatened_off_status_id	integer	Reference to patient_assessment_utilities_threatened_off_statuses primary key id
utilities_threatened_off_status_name	text	(DataStudio only). Value from patient_assessment_utilities_threatened_off_statuses.name
lacks_reliable_transportation_id	integer	Reference to patient_assessment_lacks_reliable_transportations primary key id
lacks_reliable_transportation_name	text	(DataStudio only). Value from patient_assessment_lacks_reliable_transportations.name
assistance_transportation_other	text
marked_as_done_by_id	integer	Reference to users primary key id
supervisor_approved_by_id	integer	Reference to users primary key id
locker_id	integer	Reference to users primary key id
locker_name	text
locked_at	datetime
addendum	text
completed_by_id	integer	Reference to users primary key id

patient_care_management_program_types

column	type	description
id	integer	Primary key id
name	text

patient_care_plan_priorities

column	type	description
id	integer	Primary key id
name	text

patient_care_plan_statuses

column	type	description
id	integer	Primary key id
name	text

patient_care_plans

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	Reference to patients primary key id
id	integer	Primary key id
patient_care_plan_status_id	integer	Reference to patient_care_plan_statuses primary key id
patient_care_plan_status_name	text	(DataStudio only). Value from patient_care_plan_statuses.name
effective_date	date
completion_date	date
created_at	datetime
updated_at	datetime
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id
chart_id	integer	Reference to charts primary key id

patient_core_services

column	type	description
id	integer	Primary key id
name	text
short_name	text
created_at	datetime
updated_at	datetime
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id

patient_demographic_data

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	(DataStudio only). Reference to patients primary key id
id	integer	Primary key id
first_name	text
last_name	text
date_of_birth	date
gender_id	integer	Reference to patient_demographic_gender primary key id
gender_description	text	(DataStudio only). Value from patient_demographic_gender.description
medicaid_gender_id	integer	Reference to patient_demographic_gender primary key id
medicaid_gender_description	text	(DataStudio only). Value from patient_demographic_gender.description
pronouns_id	integer	Reference to patient_pronouns primary key id
pronouns_name	text	(DataStudio only). Value from patient_pronouns.name
custom_pronouns	text
medicaid_member_id	text
nysid	text
race_id	integer	Reference to patient_races primary key id
race_name	text	(DataStudio only). Value from patient_races.name
race_other	text
ethnicity_id	integer	Reference to patient_assessment_demo_ethnicities primary key id
ethnicity_name	text	(DataStudio only). Value from patient_assessment_demo_ethnicities.name
religion_id	integer	Reference to patient_religions primary key id
religion_name	text	(DataStudio only). Value from patient_religions.name
religion_other	text
primary_spoken_language_id	integer	Reference to patient_primary_spoken_languages primary key id
primary_spoken_language_name	text	(DataStudio only). Value from patient_primary_spoken_languages.name
primary_spoken_language_other	text
other_patient_details	text
address	text
address_2	text
city	text
state	text
zip	text
home_phone	text
cell_phone	text
other_phone	text
email	text
care_manager_id	integer	Reference to care_managers primary key id
created_at	datetime
updated_at	datetime
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id
parent_guardian_name	text
parent_guardian_relationship_id	integer
parent_guardian_relationship_other	text
parent_guardian_phone	text
parent_guardian_email	text
parent_guardian_address	text
parent_guardian_address_2	text
parent_guardian_city	text
parent_guardian_state	text
parent_guardian_zip	text
emergency_contact_name	text
emergency_contact_phone	text

patient_demographic_gender

column	type	description
id	integer	Primary key id
description	text

patient_diagnoses

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	Reference to patients primary key id
id	integer	Primary key id
diagnosis_value_id	integer	Reference to patient_diagnosis_values primary key id
diagnosis_value_name	text	(DataStudio only). Value from patient_diagnosis_values.name
diagnosis_value_other	text
is_primary	boolean
created_at	datetime
updated_at	datetime
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id
chart_id	integer	Reference to charts primary key id

patient_diagnosis_values

column	type	description
id	integer	Primary key id
name	text

patient_direct_biller_indicator_override_types

column	type	description
id	integer	Primary key id
name	text
description	text

patient_documents

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	Reference to patients primary key id
id	integer	Primary key id
uploaded_file	text
description	text
created_at	datetime
updated_at	datetime
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id
document_type_id	integer	Reference to document_types primary key id
document_type_name	text	(DataStudio only). Value from document_types.name
other_document_type_name	text
chart_id	integer	Reference to charts primary key id
date	date

patient_end_date_reason_categories

column	type	description
id	integer	Primary key id
code	text
description	text

patient_end_date_reason_codes

column	type	description
id	integer	Primary key id
code	text
description	text

patient_encounters

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	Reference to patients primary key id
id	integer	Primary key id
date	date
patient_encounter_type_id	integer	Reference to patient_legacy_encounter_types primary key id
patient_encounter_type_name	text	(DataStudio only). Value from patient_legacy_encounter_types.name
notes	text
created_at	datetime
updated_at	datetime
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id
locked_at	datetime
locker_id	integer	Reference to users primary key id
locker_name	text
core_service_id	integer	Reference to patient_core_services primary key id
source_system_identifier	text
import_btq_activity_record_id	integer
chart_id	integer	Reference to charts primary key id
details_id	integer
details_type	text
is_about_admission_or_discharge	boolean

phone_encounter_details

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	(DataStudio only). Reference to patients primary key id
id	integer	Primary key id
contacted	boolean
meeting_type_id	integer	Reference to encounter_meeting_types primary key id
meeting_type_name	text	(DataStudio only). Value from encounter_meeting_types.name
voicemail	boolean
created_at	datetime
updated_at	datetime

phone_encounter_details_targets

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	(DataStudio only). Reference to patients primary key id
id	integer	Primary key id
phone_encounter_details_id	integer	Reference to phone_encounter_details primary key id
target_id	integer	Reference to encounter_targets primary key id
target_name	text	(DataStudio only). Value from encounter_targets.name
created_at	datetime
updated_at	datetime

patient_flags

column	type	description
id	integer	Primary key id
name	text
abbreviation	text
description	text

patient_flag_assignments

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	Reference to patients primary key id
id	integer	Primary key id
patient_flag_id	integer	Reference to patient_flags primary key id
patient_flag_name	text	(DataStudio only). Value from patient_flags.name
created_at	datetime
updated_at	datetime
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id
chart_id	integer	Reference to charts primary key id

patient_health_home_consents

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	Reference to health_homes primary key id
patient_id	integer	Reference to patients primary key id
id	integer	Primary key id
date_of_consent	date
uploaded_file	text
created_at	datetime
updated_at	datetime
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id
consented_by_care_manager_id	integer	Reference to care_managers primary key id
chart_id	integer	Reference to charts primary key id
verbal	boolean

patient_legacy_encounter_types

column	type	description
id	integer	Primary key id
name	text
abbreviation	text

patient_medications

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	Reference to patients primary key id
id	integer	Primary key id
name	text
dosage	text
reason	text
start_date_description	text
end_date_description	text
active	boolean
created_at	datetime
updated_at	datetime
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id
chart_id	integer	Reference to charts primary key id

patient_outreach_enrollment_codes

column	type	description
id	integer	Primary key id
code	text
description	text

patient_primary_spoken_languages

column	type	description
id	integer	Primary key id
name	text

patient_pronouns

column	type	description
id	integer	Primary key id
description	text
name	text

patient_races

column	type	description
id	integer	Primary key id
name	text

patient_referral_codes

column	type	description
id	integer	Primary key id
code	text
description	text

patient_religions

column	type	description
id	integer	Primary key id
name	text

patient_segments

column	type	description
care_management_agency_id	integer	Reference to care_management_agencies primary key id
health_home_id	integer	Reference to health_homes primary key id
patient_id	integer	Reference to patients primary key id
id	integer	Primary key id
start_date	date
end_date	date
managed_care_organization_id	integer
insurance_type_id	integer
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id
end_date_reason_code_id	integer	Reference to patient_end_date_reason_codes primary key id
end_date_reason_code_description	text	(DataStudio only). Value from patient_end_date_reason_codes.description
referral_code_id	integer	Reference to patient_referral_codes primary key id
referral_code_description	text	(DataStudio only). Value from patient_referral_codes.description
outreach_enrollment_code_id	integer	Reference to patient_outreach_enrollment_codes primary key id
outreach_enrollment_code_description	text	(DataStudio only). Value from patient_outreach_enrollment_codes.description
created_at	datetime
updated_at	datetime
direct_biller_indicator_override_type_id	integer	Reference to patient_direct_biller_indicator_override_types primary key id
direct_biller_indicator_override_type_name	text	(DataStudio only). Value from patient_direct_biller_indicator_override_types.name
end_date_reason_comment	text
adult_child_services_code_id	integer	Reference to patient_adult_child_services_codes primary key id
adult_child_services_code_name	text	(DataStudio only). Value from patient_adult_child_services_codes.name
pended	boolean
segment_pend_reason_id	integer	Reference to segment_pend_reasons primary key id
segment_pend_reason_description	text	(DataStudio only). Value from segment_pend_reasons.description
pend_parent_segment_id	integer	Reference to patient_segments primary key id
chart_id	integer	Reference to charts primary key id
end_date_reason_new_medicaid_member_id	text
appropriateness_criteria_code_id	integer	Reference to appropriateness_criteria_codes primary key id
appropriateness_criteria_code_description	text	(DataStudio only). Value from appropriateness_criteria_codes.description
appropriateness_comments	text

patient_signed_care_plans

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	Reference to patients primary key id
id	integer	Primary key id
patient_care_plan_id	integer	Reference to patient_care_plans primary key id
uploaded_file	text
created_at	datetime
updated_at	datetime
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id
patient_signed_on	date

patients

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
id	integer	Primary key id
date_of_birth	date
first_name	text
last_name	text
medicaid_member_id	text
care_manager_id	integer	Reference to care_managers primary key id

payers

column	type	description
id	integer	Primary key id
name	text

reviews_actions

column	type	description
id	integer	Primary key id
name	text

reviews_care_plan_review_requests

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	(DataStudio only). Reference to patients primary key id
id	integer	Primary key id
patient_care_plan_id	integer	Reference to patient_care_plans primary key id
created_at	datetime
updated_at	datetime
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id

reviews_care_plan_reviews

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	(DataStudio only). Reference to patients primary key id
id	integer	Primary key id
patient_care_plan_id	integer	Reference to patient_care_plans primary key id
action_id	integer	Reference to reviews_actions primary key id
action_name	text	(DataStudio only). Value from reviews_actions.name
notes	text
created_at	datetime
updated_at	datetime
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id

risk_factor_categories

column	type	description
id	integer	Primary key id
name	text

risk_factors

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	(DataStudio only). Reference to patients primary key id
id	integer	Primary key id
category_id	integer	Reference to risk_factor_categories primary key id
category_name	text	(DataStudio only). Value from risk_factor_categories.name
description	text
active	boolean
chart_id	integer	Reference to charts primary key id
created_at	datetime
updated_at	datetime
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id

segment_pend_reasons

column	type	description
id	integer	Primary key id
description	text

strengths

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	(DataStudio only). Reference to patients primary key id
id	integer	Primary key id
description	text
active	boolean
chart_id	integer	Reference to charts primary key id
created_at	datetime
updated_at	datetime
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id

supervisory_teams_care_management_agency_teams

column	type	description
care_management_agency_id	integer	Reference to care_management_agencies primary key id
id	integer	Primary key id
supervisory_teams_team_id	integer	Reference to supervisory_teams_teams primary key id
created_at	datetime
updated_at	datetime

supervisory_teams_members

column	type	description
id	integer	Primary key id
care_manager_id	integer	Reference to care_managers primary key id
created_at	datetime
updated_at	datetime

supervisory_teams_memberships

column	type	description
id	integer	Primary key id
member_id	integer	Reference to supervisory_teams_members primary key id
supervisory_teams_team_id	integer	Reference to supervisory_teams_teams primary key id
created_at	datetime
updated_at	datetime

supervisory_teams_supervisors

column	type	description
id	integer	Primary key id
user_id	integer	Reference to users primary key id
created_at	datetime
updated_at	datetime

supervisory_teams_supervisor_teams

column	type	description
id	integer	Primary key id
supervisor_id	integer	Reference to supervisory_teams_supervisors primary key id
supervisory_teams_team_id	integer	Reference to supervisory_teams_teams primary key id
created_at	datetime
updated_at	datetime

supervisory_teams_teams

column	type	description
id	integer	Primary key id
name	text
created_at	datetime
updated_at	datetime

text_encounter_details

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	(DataStudio only). Reference to patients primary key id
id	integer	Primary key id
responded_to	boolean
created_at	datetime
updated_at	datetime

text_encounter_details_targets

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	(DataStudio only). Reference to patients primary key id
id	integer	Primary key id
text_encounter_details_id	integer	Reference to text_encounter_details primary key id
target_id	integer	Reference to encounter_targets primary key id
target_name	text	(DataStudio only). Value from encounter_targets.name
created_at	datetime
updated_at	datetime

tracking_billing_support_download_record_omh_hh_plus_eligibility_status_codes

column	type	description
id	integer	Primary key id
code	text
description	text

tracking_billing_support_download_records

column	type	description
care_management_agency_id	integer	Reference to care_management_agencies primary key id
health_home_id	integer	Reference to health_homes primary key id
patient_id	integer	Reference to patients primary key id
id	integer	Primary key id
tracking_billing_support_download_file_id	integer
add_void_indicator	text
member_id	text
service_date	date
health_home_mmis_id	text
billing_instance_type	text
member_fiscal_county_code	text
managed_care_organization_mmis_id	text
diagnosis_code	text
medicaid_eligibility_status	boolean
pend_reason_code	text
pend_reason_code_description	text
member_fiscal_county_code_description	text
date_assessment_entered	date
care_management_agency_name	text
care_management_agency_mmis_provider_id	text
health_home_name	text
managed_care_plan_name	text
billing_entity_mmis_id	text
billing_entity_name	text
member_zip_code	text
member_first_name	text
member_last_name	text
member_dob	date
gender	text
harp	text
hiv_status	boolean
hiv_viral_load	text
hiv_t_cell_count	text
member_living_status	boolean
hud_category	text
incarceration_release_date	date
mental_illness_or_physical_health_inpatient_discharge_date	date
substance_abuse_inpatient_stay_discharge_date	date
sud_active_use_functional_impairment	boolean
core_service_provided	boolean
aot_member	boolean
aot_minimum_services_provided	boolean
act_member	boolean
impacted_adult_home_class_member	boolean
ah_member_qualifies_for_adult_home_plus_care_management	text
ah_member_transitioned_to_community	boolean
ah_member_continues_to_quality	boolean
ah_member_interested_in_transitioning	boolean
rate_code	text
rate_code_description	text
rate_amount	decimal
claim_status	text
date_of_transaction	date
payment_cycle	text
denial_reason_code	text
denial_reason_code_description	text
denial_reason_code_2	text
denial_reason_code_description_2	text
claim_provider_id	text
claim_provider_name	text
claim_rate_code	text
claim_provider_id_equals_mapp_billed_entity_mmis_id	boolean
claim_rate_code_equals_mapp_hml_rate_code	boolean
latest_transaction	boolean
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id
created_at	datetime
updated_at	datetime
direct_biller_indicator	text
child_in_foster_care	boolean
last_transaction_date_time	datetime
insert_date	date
assessment_completion_date	date
void_date	date
hud_one_within_past_six_months	boolean
date_member_housed	date
hh_plus_minimum_service_provided	boolean
incarceration	text
mental_illness_or_physical_health_inpatient_stay	text
substance_abuse_inpatient_stay	text
provided_service_indicator	text
managed_care_plan_id	integer	Reference to managed_care_plans primary key id
uas_complexity_assessment	text
chart_id	integer	Reference to charts primary key id
expanded_hh_plus_population	text
encounter_claim	text
payor	text
month_submitted	text
mcp_type	text
validation_code	text
validation_code_description	text
plan_of_care_date	date
cans_acuity	text
omh_hh_plus_eligible	text
omh_hh_plus_elig_status_desc	text
sed_smi	boolean
hiv_aids	boolean
complex_trauma_under_twenty_one_years_of_age	boolean
sickle_cell	boolean
childrens_hcbs_only	boolean
mental_health_excluding_smi_sed	boolean
substance_abuse	boolean
asthma	boolean
diabetes	boolean
heart_disease	boolean
overweight	boolean
one_or_more_dd_conditions	boolean
childrens_hcbs_and_other_conditions	boolean
adult_hcbs_and_other_conditions	boolean
other_qualifying_condition	boolean
description_of_other_health_home_qualifying_conditions	text

tracking_billing_support_questionnaire_act_members

column	type	description
id	integer	Primary key id
name	text
code	text

tracking_billing_support_questionnaire_ah_member_continues_to_qualifies

column	type	description
id	integer	Primary key id
name	text
code	text

tracking_billing_support_questionnaire_ah_member_interested_in_transitionings

column	type	description
id	integer	Primary key id
name	text
code	text

tracking_billing_support_questionnaire_ah_member_qualifies_for_adult_home_plus_care_managements

column	type	description
id	integer	Primary key id
name	text
code	text

tracking_billing_support_questionnaire_ah_member_transitioned_to_communities

column	type	description
id	integer	Primary key id
name	text
code	text

tracking_billing_support_questionnaire_aot_members

column	type	description
id	integer	Primary key id
name	text
code	text

tracking_billing_support_questionnaire_aot_minimum_services_provideds

column	type	description
id	integer	Primary key id
name	text
code	text

tracking_billing_support_questionnaire_assessor_received_in_reach_form_and_made_contacts

column	type	description
id	integer	Primary key id
name	text
code	text

tracking_billing_support_questionnaire_child_in_foster_cares

column	type	description
id	integer	Primary key id
name	text
code	text

tracking_billing_support_questionnaire_core_service_provideds

column	type	description
id	integer	Primary key id
name	text
code	text

tracking_billing_support_questionnaire_expanded_hh_plus_populations

column	type	description
id	integer	Primary key id
key	text
code	text

tracking_billing_support_questionnaire_hh_plus_minimum_services_provideds

column	type	description
id	integer	Primary key id
name	text
code	text

tracking_billing_support_questionnaire_hiv_statuses

column	type	description
id	integer	Primary key id
name	text
code	text

tracking_billing_support_questionnaire_hiv_t_cell_counts

column	type	description
id	integer	Primary key id
name	text
code	text

tracking_billing_support_questionnaire_hiv_viral_loads

column	type	description
id	integer	Primary key id
name	text
code	text

tracking_billing_support_questionnaire_hud_categories

column	type	description
id	integer	Primary key id
name	text
code	text

tracking_billing_support_questionnaire_hud_one_within_past_six_months

column	type	description
id	integer	Primary key id
name	text
code	text

tracking_billing_support_questionnaire_incarcerations

column	type	description
id	integer	Primary key id
name	text
code	text

tracking_billing_support_questionnaire_member_houseds

column	type	description
id	integer	Primary key id
name	text
code	text

tracking_billing_support_questionnaire_member_housing_statuses

column	type	description
id	integer	Primary key id
name	text
code	text

tracking_billing_support_questionnaire_mental_illnesses

column	type	description
id	integer	Primary key id
name	text
code	text

tracking_billing_support_questionnaire_substance_abuses

column	type	description
id	integer	Primary key id
name	text
code	text

tracking_billing_support_questionnaire_sud_active_use_functional_impairments

column	type	description
id	integer	Primary key id
name	text
code	text

tracking_billing_support_questionnaire_uas_assessment_refuseds

column	type	description
id	integer	Primary key id
name	text
code	text

tracking_billing_support_questionnaire_uas_complexity_assessments

column	type	description
id	integer	Primary key id
name	text
code	text

tracking_billing_support_questionnaires

column	type	description
care_management_agency_id	integer	Reference to care_management_agencies primary key id
health_home_id	integer	Reference to health_homes primary key id
patient_id	integer	Reference to patients primary key id
id	integer	Primary key id
service_date	date
diagnosis_code	text
description_of_other_health_home_qualifying_conditions	text
hiv_status_id	integer	Reference to tracking_billing_support_questionnaire_hiv_statuses primary key id
hiv_status_name	text	(DataStudio only). Value from tracking_billing_support_questionnaire_hiv_statuses.name
member_housing_status_id	integer	Reference to tracking_billing_support_questionnaire_member_housing_statuses primary key id
member_housing_status_name	text	(DataStudio only). Value from tracking_billing_support_questionnaire_member_housing_statuses.name
incarceration_id	integer	Reference to tracking_billing_support_questionnaire_incarcerations primary key id
incarceration_name	text	(DataStudio only). Value from tracking_billing_support_questionnaire_incarcerations.name
incarceration_release_date	date
mental_illness_id	integer	Reference to tracking_billing_support_questionnaire_mental_illnesses primary key id
mental_illness_name	text	(DataStudio only). Value from tracking_billing_support_questionnaire_mental_illnesses.name
mental_illness_stay_discharge_date	date
substance_abuse_id	integer	Reference to tracking_billing_support_questionnaire_substance_abuses primary key id
substance_abuse_name	text	(DataStudio only). Value from tracking_billing_support_questionnaire_substance_abuses.name
substance_abuse_discharge_date	date
sud_active_use_functional_impairment_id	integer	Reference to tracking_billing_support_questionnaire_sud_active_use_functional_impairments primary key id
sud_active_use_functional_impairment_name	text	(DataStudio only). Value from tracking_billing_support_questionnaire_sud_active_use_functional_impairments.name
aot_member_id	integer	Reference to tracking_billing_support_questionnaire_aot_members primary key id
aot_member_name	text	(DataStudio only). Value from tracking_billing_support_questionnaire_aot_members.name
aot_minimum_services_provided_id	integer	Reference to tracking_billing_support_questionnaire_aot_minimum_services_provideds primary key id
aot_minimum_services_provided_name	text	(DataStudio only). Value from tracking_billing_support_questionnaire_aot_minimum_services_provideds.name
act_member_id	integer	Reference to tracking_billing_support_questionnaire_act_members primary key id
act_member_name	text	(DataStudio only). Value from tracking_billing_support_questionnaire_act_members.name
assessor_received_in_reach_form_and_made_contact_id	integer	Reference to tracking_billing_support_questionnaire_assessor_received_in_reach_form_and_made_contacts primary key id
assessor_received_in_reach_form_and_made_contact_name	text	(DataStudio only). Value from tracking_billing_support_questionnaire_assessor_received_in_reach_form_and_made_contacts.name
uas_assessment_date	date
uas_assessment_refused_id	integer	Reference to tracking_billing_support_questionnaire_uas_assessment_refuseds primary key id
uas_assessment_refused_name	text	(DataStudio only). Value from tracking_billing_support_questionnaire_uas_assessment_refuseds.name
date_uas_assessment_refused	date
created_at	datetime
updated_at	datetime
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id
core_service_provided_id	integer	Reference to tracking_billing_support_questionnaire_core_service_provideds primary key id
core_service_provided_name	text	(DataStudio only). Value from tracking_billing_support_questionnaire_core_service_provideds.name
hiv_t_cell_count_id	integer	Reference to tracking_billing_support_questionnaire_hiv_t_cell_counts primary key id
hiv_t_cell_count_name	text	(DataStudio only). Value from tracking_billing_support_questionnaire_hiv_t_cell_counts.name
hiv_viral_load_id	integer	Reference to tracking_billing_support_questionnaire_hiv_viral_loads primary key id
hiv_viral_load_name	text	(DataStudio only). Value from tracking_billing_support_questionnaire_hiv_viral_loads.name
hud_category_id	integer	Reference to tracking_billing_support_questionnaire_hud_categories primary key id
hud_category_name	text	(DataStudio only). Value from tracking_billing_support_questionnaire_hud_categories.name
void	boolean
sequence_number	integer
ah_member_qualifies_for_adult_home_plus_care_management_id	integer	Reference to tracking_billing_support_questionnaire_ah_member_qualifies_for_adult_home_plus_care_managements primary key id
ah_member_qualifies_for_adult_home_plus_care_management_name	text	(DataStudio only). Value from tracking_billing_support_questionnaire_ah_member_qualifies_for_adult_home_plus_care_managements.name
ah_member_transitioned_to_community_id	integer	Reference to tracking_billing_support_questionnaire_ah_member_transitioned_to_communities primary key id
ah_member_transitioned_to_community_name	text	(DataStudio only). Value from tracking_billing_support_questionnaire_ah_member_transitioned_to_communities.name
ah_member_continues_to_qualify_id	integer	Reference to tracking_billing_support_questionnaire_ah_member_continues_to_qualifies primary key id
ah_member_continues_to_qualify_name	text	(DataStudio only). Value from tracking_billing_support_questionnaire_ah_member_continues_to_qualifies.name
ah_member_interested_in_transitioning_id	integer	Reference to tracking_billing_support_questionnaire_ah_member_interested_in_transitionings primary key id
ah_member_interested_in_transitioning_name	text	(DataStudio only). Value from tracking_billing_support_questionnaire_ah_member_interested_in_transitionings.name
child_in_foster_care_id	integer	Reference to tracking_billing_support_questionnaire_child_in_foster_cares primary key id
child_in_foster_care_name	text	(DataStudio only). Value from tracking_billing_support_questionnaire_child_in_foster_cares.name
hud_one_within_past_six_months_id	integer	Reference to tracking_billing_support_questionnaire_hud_one_within_past_six_months primary key id
hud_one_within_past_six_months_name	text	(DataStudio only). Value from tracking_billing_support_questionnaire_hud_one_within_past_six_months.name
member_housed_id	integer	Reference to tracking_billing_support_questionnaire_member_houseds primary key id
member_housed_name	text	(DataStudio only). Value from tracking_billing_support_questionnaire_member_houseds.name
date_member_housed	date
expanded_hh_plus_population_id	integer	Reference to tracking_billing_support_questionnaire_expanded_hh_plus_populations primary key id
expanded_hh_plus_population_key	text	(DataStudio only). Value from tracking_billing_support_questionnaire_expanded_hh_plus_populations.key
hh_plus_minimum_services_provided_id	integer	Reference to tracking_billing_support_questionnaire_hh_plus_minimum_services_provideds primary key id
hh_plus_minimum_services_provided_name	text	(DataStudio only). Value from tracking_billing_support_questionnaire_hh_plus_minimum_services_provideds.name
imported	boolean
uas_complexity_assessment_id	integer	Reference to tracking_billing_support_questionnaire_uas_complexity_assessments primary key id
uas_complexity_assessment_name	text	(DataStudio only). Value from tracking_billing_support_questionnaire_uas_complexity_assessments.name
chart_id	integer	Reference to charts primary key id

user_care_management_agencies

column	type	description
care_management_agency_id	integer	Reference to care_management_agencies primary key id
id	integer	Primary key id
user_id	integer	Reference to users primary key id
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id
created_at	datetime
updated_at	datetime

user_health_homes

column	type	description
health_home_id	integer	Reference to health_homes primary key id
id	integer	Primary key id
user_id	integer	Reference to users primary key id
created_at	datetime
updated_at	datetime
creator_id	integer	Reference to users primary key id
updater_id	integer	Reference to users primary key id

users

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
id	integer	Primary key id
first_name	text
last_name	text
email	text
cell_number	text
active	boolean
role_id	integer	Reference to account_roles primary key id
role_name	text	(DataStudio only). Value from account_roles.name
enable_billing_module	boolean
read_only	boolean
created_at	datetime
creator_id	integer	Reference to users primary key id
updated_at	datetime
updater_id	integer	Reference to users primary key id

video_encounter_details

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	(DataStudio only). Reference to patients primary key id
id	integer	Primary key id
contacted	boolean
meeting_type_id	integer	Reference to encounter_meeting_types primary key id
meeting_type_name	text	(DataStudio only). Value from encounter_meeting_types.name
created_at	datetime
updated_at	datetime

video_encounter_details_targets

column	type	description
care_management_agency_id	integer	(DataStudio only). Reference to care_management_agencies primary key id
health_home_id	integer	(DataStudio only). Reference to health_homes primary key id
patient_id	integer	(DataStudio only). Reference to patients primary key id
id	integer	Primary key id
video_encounter_details_id	integer	Reference to video_encounter_details primary key id
target_id	integer	Reference to encounter_targets primary key id
target_name	text	(DataStudio only). Value from encounter_targets.name
created_at	datetime
updated_at	datetime