FCM DataStudio & Extract Data Dictionary
Updated 2025-12-05
Definitions and descriptions for the FCM DataStudio product and the native Data Extract
Additional resources:
account_roles
| column | type | description |
|---|---|---|
| id | integer | Primary key id |
| name | text |
appropriateness_assessment_occasions
| column | type | description |
|---|---|---|
| id | integer | Primary key id |
| name | text | |
| description | text |
appropriateness_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 | (DataStudio only). Reference to patients primary key id |
| id | integer | Primary key id |
| segment_id | integer | Reference to patient_segments primary key id |
| criteria_code_id | integer | Reference to appropriateness_criteria_codes primary key id |
| criteria_code_description | text | (DataStudio only). Value from appropriateness_criteria_codes.description |
| comments | text | |
| start_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 |
| occasion_id | integer | Reference to appropriateness_assessment_occasions primary key id |
| occasion_description | text | (DataStudio only). Value from appropriateness_assessment_occasions.description |
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 | Reference to claim_statuses primary key id |
| claim_status_name | text | (DataStudio only). Value from claim_statuses.name |
| 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_manager_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 | (DataStudio only). Reference to patients primary key id |
| id | integer | Primary key id |
| care_manager_id | integer | Reference to care_managers primary key id |
| 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 |
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 |
|---|---|---|
| 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 | |
| receiving_or_interested_in_adult_hcbs_or_core | text |
care_plan_upload_files
| column | type | description |
|---|---|---|
| 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 | |
| receiving_or_interested_in_adult_hcbs_or_core | text |
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 |
|---|---|---|
| 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_suggestions
| column | type | description |
|---|---|---|
| health_home_id | integer | Reference to health_homes primary key id |
| id | integer | Primary key id |
| text | text | |
| archived | 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 |
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 | |
| strengths | 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 |
|---|---|---|
| id | integer | Primary key id |
| first_name | text | |
| last_name | text | |
| address | text | |
| phone | text | |
| 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 |
| created_at | datetime | |
| updated_at | datetime | |
| creator_id | integer | Reference to users primary key id |
| updater_id | integer | Reference to users primary key id |
| race_id | integer | Reference to patient_races primary key id |
| race_name | text | (DataStudio only). Value from patient_races.name |
| race_other | text | |
| religion_id | integer | Reference to patient_religions primary key id |
| religion_name | text | (DataStudio only). Value from patient_religions.name |
| religion_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 |
| 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 | |
| home_phone | text | |
| cell_phone | text | |
| other_phone | text | |
| text | ||
| emergency_contact_name | text | |
| emergency_contact_phone | text | |
| 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 |
| pronouns_id | integer | Reference to patient_pronouns primary key id |
| pronouns_name | text | (DataStudio only). Value from patient_pronouns.name |
| custom_pronouns | text | |
| social_security_number | text | |
| nysid | text | |
| other_patient_details | text | |
| converting_tcm_client | boolean | |
| patient_care_management_program_type_id | integer | Reference to patient_care_management_program_types primary key id |
| patient_care_management_program_type_name | text | (DataStudio only). Value from patient_care_management_program_types.name |
| address | text | |
| address_2 | text | |
| city | text | |
| state | text | |
| zip | text |
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 | |
| annual_physical_wellness_exam_notes | text | |
| latest_annual_physical_wellness_exam_date | date | |
| mco_notified_date | date | |
| hcbs_provider_notified_date | 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 |
claim_statuses
| column | type | description |
|---|---|---|
| id | integer | Primary key id |
| name | 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 |
|---|---|---|
| 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 |
| health_home_id | integer | (DataStudio only). Reference to health_homes 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 |
|---|---|---|
| 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 |
|---|---|---|
| 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 |
|---|---|---|
| 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 |
|---|---|---|
| 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_care_suggestions
| column | type | description |
|---|---|---|
| id | integer | Primary key id |
| care_suggestion_id | integer | Reference to care_suggestions 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 | |
| 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 |
|---|---|---|
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| provides_high_fidelity_wrap_services | boolean |
health_home_serving_children_telehealths
| column | type | description |
|---|---|---|
| id | integer | Primary key id |
| name | text |
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 |
medicaid_identities
| 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 |
| 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 |
| created_at | datetime | |
| updated_at | datetime | |
| creator_id | integer | Reference to users primary key id |
| updater_id | integer | Reference to users 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 |
parent_guardian_legally_authorized_representatives
| 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 |
| name | text | |
| relationship_id | integer | Reference to patient_parent_guardian_relationships primary key id |
| relationship_name | text | (DataStudio only). Value from patient_parent_guardian_relationships.name |
| relationship_other | text | |
| phone | text | |
| text | ||
| address | text | |
| address_2 | text | |
| city | text | |
| state | text | |
| 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 |
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 | |
| 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 | |
| health_home_serving_children_telehealth_id | integer | Reference to health_home_serving_children_telehealths primary key id |
| health_home_serving_children_telehealth_name | text | (DataStudio only). Value from health_home_serving_children_telehealths.name |
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_parent_guardian_relationships
| column | type | description |
|---|---|---|
| id | integer | Primary key id |
| name | 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_referral_types
| column | type | description |
|---|---|---|
| id | integer | Primary key id |
| name | 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 |
|---|---|---|
| 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 |
payer_billing_support_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 |
| payer_id | integer | Reference to payers primary key id |
| billing_support_download_record_id | integer | Reference to tracking_billing_support_download_records primary key id |
referrals
| 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 |
| type_id | integer | Reference to patient_referral_types primary key id |
| date | date | |
| details | 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 |
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 | |
| most_recent_hcbs_assessment_date | date | |
| expanded_hh_plus_population_description | text | |
| in_person | text | |
| telehealth | text | |
| active_k1 | boolean | |
| cest_start_date | date | |
| cest_outcome | text | |
| consent_to_enroll_date | date | |
| segment_begin_date | date | |
| initial_cest_due_date | date | |
| cest_end_date | date | |
| adult_or_child_services_provided_indicator | text | |
| excluded_from_cest_policy_as_exp_hh_plus | boolean | |
| last_dos_with_exp_hh_plus | date | |
| aot_member_per_omh | boolean | |
| cma_omh_hh_plus | boolean | |
| cma_ai_hh_plus | boolean | |
| cma_hfw | boolean | |
| member_hfw | boolean |
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_in_person_requirements_waived_for_med_frag_members
| column | type | description |
|---|---|---|
| id | integer | Primary key id |
| name | 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_questionnaire_member_unable_to_participate_in_care_plans
| column | type | description |
|---|---|---|
| id | integer | Primary key id |
| name | 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 |
| in_person_encounter_count | integer | |
| telehealth_encounter_count | integer | |
| in_person_requirements_waived_for_medically_fragile_member_id | integer | Reference to tracking_billing_support_questionnaire_in_person_requirements_waived_for_med_frag_members primary key id |
| in_person_requirements_waived_for_medically_fragile_member_name | text | (DataStudio only). Value from tracking_billing_support_questionnaire_in_person_requirements_waived_for_med_frag_members.name |
| member_unable_to_participate_in_care_plan_id | integer | Reference to tracking_billing_support_questionnaire_member_unable_to_participate_in_care_plans primary key id |
| member_unable_to_participate_in_care_plan_name | text | (DataStudio only). Value from tracking_billing_support_questionnaire_member_unable_to_participate_in_care_plans.name |
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 | |
| 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 |