Documentation Index
Fetch the complete documentation index at: https://docs.encoreos.io/llms.txt
Use this file to discover all available pages before exploring further.
Generated file. Do not hand-edit sections below; re-run npm run db:docs:generate.
- Generated at: 2026-05-13T13:38:53.712Z
- Source:
reports/audits/migration-inventory.json (migration-inventory)
- Tables: 570
Inventory by Core
| Core | Tables |
|---|
| PF | 141 |
| CE | 17 |
| RH | 2 |
| FA | 40 |
| HR | 27 |
| GR | 28 |
| FW | 29 |
| FM | 1 |
| IT | 2 |
| CL | 128 |
| PM | 153 |
| OTHER | 2 |
PF tables
| Table | Schema | Columns | Indexes | FKs | Policies | RLS |
|---|
pf_asam_loc_levels | public | n/a | n/a | n/a | n/a | unknown |
pf_assignable_roles | public | n/a | n/a | n/a | n/a | unknown |
pf_bulk_operation_items | public | n/a | n/a | n/a | n/a | unknown |
pf_bulk_operations | public | n/a | n/a | n/a | n/a | unknown |
pf_business_processes | public | n/a | n/a | n/a | n/a | unknown |
pf_chatbot_configs | public | n/a | n/a | n/a | n/a | unknown |
pf_chatbot_messages | public | n/a | n/a | n/a | n/a | unknown |
pf_chatbot_sessions | public | n/a | n/a | n/a | n/a | unknown |
pf_code_cross_mappings | public | n/a | n/a | n/a | n/a | unknown |
pf_code_crosswalks | public | n/a | n/a | n/a | n/a | unknown |
pf_code_favorites | public | n/a | n/a | n/a | n/a | unknown |
pf_code_modifiers | public | n/a | n/a | n/a | n/a | unknown |
pf_code_recent | public | n/a | n/a | n/a | n/a | unknown |
pf_code_set_versions | public | n/a | n/a | n/a | n/a | unknown |
pf_code_sets | public | n/a | n/a | n/a | n/a | unknown |
pf_compliance_checks | public | n/a | n/a | n/a | n/a | unknown |
pf_compliance_evidence | public | n/a | n/a | n/a | n/a | unknown |
pf_condition_evaluation_cache | public | n/a | n/a | n/a | n/a | unknown |
pf_condition_evaluation_metrics | public | n/a | n/a | n/a | n/a | unknown |
pf_condition_evaluation_metrics_archive | public | n/a | n/a | n/a | n/a | unknown |
pf_conversation_members | public | n/a | n/a | n/a | n/a | unknown |
pf_conversations | public | n/a | n/a | n/a | n/a | unknown |
pf_cpt_codes | public | n/a | n/a | n/a | n/a | unknown |
pf_credential_vault | public | n/a | n/a | n/a | n/a | unknown |
pf_custom_metric_values | public | n/a | n/a | n/a | n/a | unknown |
pf_custom_metrics | public | n/a | n/a | n/a | n/a | unknown |
pf_data_lifecycle_events | public | n/a | n/a | n/a | n/a | unknown |
pf_data_lineage | public | n/a | n/a | n/a | n/a | unknown |
pf_data_lineage_archive | public | n/a | n/a | n/a | n/a | unknown |
pf_data_migration_connections | public | n/a | n/a | n/a | n/a | unknown |
pf_data_migration_mappings | public | n/a | n/a | n/a | n/a | unknown |
pf_data_migration_runs | public | n/a | n/a | n/a | n/a | unknown |
pf_document_expiration_log | public | n/a | n/a | n/a | n/a | unknown |
pf_domain_events | public | n/a | n/a | n/a | n/a | unknown |
pf_edge_function_metrics | public | n/a | n/a | n/a | n/a | unknown |
pf_email_signatures | public | n/a | n/a | n/a | n/a | unknown |
pf_entity_field_config_versions | public | n/a | n/a | n/a | n/a | unknown |
pf_export_files | public | n/a | n/a | n/a | n/a | unknown |
pf_export_requests | public | n/a | n/a | n/a | n/a | unknown |
pf_export_templates | public | n/a | n/a | n/a | n/a | unknown |
pf_feature_flag_usage | public | n/a | n/a | n/a | n/a | unknown |
pf_feature_flags | public | n/a | n/a | n/a | n/a | unknown |
pf_gesture_analytics_events | public | n/a | n/a | n/a | n/a | unknown |
pf_github_webhook_events | public | n/a | n/a | n/a | n/a | unknown |
pf_google_workspace_connections | public | n/a | n/a | n/a | n/a | unknown |
pf_google_workspace_mappings | public | n/a | n/a | n/a | n/a | unknown |
pf_google_workspace_sync_runs | public | n/a | n/a | n/a | n/a | unknown |
pf_google_workspace_user_links | public | n/a | n/a | n/a | n/a | unknown |
pf_hcpcs_codes | public | n/a | n/a | n/a | n/a | unknown |
pf_headshot_campaign_members | public | n/a | n/a | n/a | n/a | unknown |
pf_headshot_campaigns | public | n/a | n/a | n/a | n/a | unknown |
pf_headshot_jobs | public | n/a | n/a | n/a | n/a | unknown |
pf_headshot_results | public | n/a | n/a | n/a | n/a | unknown |
pf_headshot_uploads | public | n/a | n/a | n/a | n/a | unknown |
pf_icd10_codes | public | n/a | n/a | n/a | n/a | unknown |
pf_import_batches | public | n/a | n/a | n/a | n/a | unknown |
pf_import_mapping_templates | public | n/a | n/a | n/a | n/a | unknown |
pf_import_records | public | n/a | n/a | n/a | n/a | unknown |
pf_inbox_snoozes | public | n/a | n/a | n/a | n/a | unknown |
pf_ip_allowlist | public | n/a | n/a | n/a | n/a | unknown |
pf_ip_blocklist | public | n/a | n/a | n/a | n/a | unknown |
pf_jurisdiction_profiles | public | n/a | n/a | n/a | n/a | unknown |
pf_legal_holds | public | n/a | n/a | n/a | n/a | unknown |
pf_locus_loc_levels | public | n/a | n/a | n/a | n/a | unknown |
pf_message_bookmarks | public | n/a | n/a | n/a | n/a | unknown |
pf_message_read_receipts | public | n/a | n/a | n/a | n/a | unknown |
pf_messages | public | n/a | n/a | n/a | n/a | unknown |
pf_notification_template_variables | public | n/a | n/a | n/a | n/a | unknown |
pf_onboarding_sessions | public | n/a | n/a | n/a | n/a | unknown |
pf_onboarding_step_batches | public | n/a | n/a | n/a | n/a | unknown |
pf_org_api_keys | public | n/a | n/a | n/a | n/a | unknown |
pf_org_data_sync_events | public | n/a | n/a | n/a | n/a | unknown |
pf_org_hierarchies | public | n/a | n/a | n/a | n/a | unknown |
pf_org_jurisdiction_config | public | n/a | n/a | n/a | n/a | unknown |
pf_org_quick_action_selections | public | n/a | n/a | n/a | n/a | unknown |
pf_page_layout_templates | public | n/a | n/a | n/a | n/a | unknown |
pf_page_layout_versions | public | n/a | n/a | n/a | n/a | unknown |
pf_page_layout_visibility_rules | public | n/a | n/a | n/a | n/a | unknown |
pf_page_layout_wizards | public | n/a | n/a | n/a | n/a | unknown |
pf_patient_identities | public | n/a | n/a | n/a | n/a | unknown |
pf_payer_code_rules | public | n/a | n/a | n/a | n/a | unknown |
pf_phi_classifications | public | n/a | n/a | n/a | n/a | unknown |
pf_picklist_default_definitions | public | n/a | n/a | n/a | n/a | unknown |
pf_picklist_default_items | public | n/a | n/a | n/a | n/a | unknown |
pf_process_execution_snapshots | public | n/a | n/a | n/a | n/a | unknown |
pf_provisioning_requests | public | n/a | n/a | n/a | n/a | unknown |
pf_provisioning_steps | public | n/a | n/a | n/a | n/a | unknown |
pf_provisioning_template_assignments | public | n/a | n/a | n/a | n/a | unknown |
pf_provisioning_template_bundles | public | n/a | n/a | n/a | n/a | unknown |
pf_provisioning_templates | public | n/a | n/a | n/a | n/a | unknown |
pf_query_performance_logs | public | n/a | n/a | n/a | n/a | unknown |
pf_quick_action_catalog | public | n/a | n/a | n/a | n/a | unknown |
pf_quota_violations | public | n/a | n/a | n/a | n/a | unknown |
pf_rate_limit_state | public | n/a | n/a | n/a | n/a | unknown |
pf_rate_limit_violations | public | n/a | n/a | n/a | n/a | unknown |
pf_rate_limits | public | n/a | n/a | n/a | n/a | unknown |
pf_recording_consents | public | n/a | n/a | n/a | n/a | unknown |
pf_resource_quotas | public | n/a | n/a | n/a | n/a | unknown |
pf_resource_usage | public | n/a | n/a | n/a | n/a | unknown |
pf_retention_log | public | n/a | n/a | n/a | n/a | unknown |
pf_retention_policies | public | n/a | n/a | n/a | n/a | unknown |
pf_scheduled_messages | public | n/a | n/a | n/a | n/a | unknown |
pf_security_alert_configs | public | n/a | n/a | n/a | n/a | unknown |
pf_security_alert_delivery_failures | public | n/a | n/a | n/a | n/a | unknown |
pf_security_events | public | n/a | n/a | n/a | n/a | unknown |
pf_service_accounts | public | n/a | n/a | n/a | n/a | unknown |
pf_site_jurisdiction_config | public | n/a | n/a | n/a | n/a | unknown |
pf_sla_thresholds | public | n/a | n/a | n/a | n/a | unknown |
pf_sla_violations | public | n/a | n/a | n/a | n/a | unknown |
pf_swim_lane_diagram_versions | public | n/a | n/a | n/a | n/a | unknown |
pf_swim_lane_diagrams | public | n/a | n/a | n/a | n/a | unknown |
pf_task_automation_rules | public | n/a | n/a | n/a | n/a | unknown |
pf_task_checklist_items | public | n/a | n/a | n/a | n/a | unknown |
pf_task_dependencies | public | n/a | n/a | n/a | n/a | unknown |
pf_task_templates | public | n/a | n/a | n/a | n/a | unknown |
pf_task_time_entries | public | n/a | n/a | n/a | n/a | unknown |
pf_teams_notification_config | public | n/a | n/a | n/a | n/a | unknown |
pf_tenant_domains | public | n/a | n/a | n/a | n/a | unknown |
pf_tenant_themes | public | n/a | n/a | n/a | n/a | unknown |
pf_transcription_attestations | public | n/a | n/a | n/a | n/a | unknown |
pf_transcription_audit | public | n/a | n/a | n/a | n/a | unknown |
pf_transcription_audit_retention_policy | public | n/a | n/a | n/a | n/a | unknown |
pf_transcription_citations | public | n/a | n/a | n/a | n/a | unknown |
pf_transcription_cost_ledger | public | n/a | n/a | n/a | n/a | unknown |
pf_transcription_draft_revisions | public | n/a | n/a | n/a | n/a | unknown |
pf_transcription_drafts | public | n/a | n/a | n/a | n/a | unknown |
pf_transcription_jurisdiction_routing | public | n/a | n/a | n/a | n/a | unknown |
pf_transcription_module_settings | public | n/a | n/a | n/a | n/a | unknown |
pf_transcription_segments | public | n/a | n/a | n/a | n/a | unknown |
pf_transcription_session_participants | public | n/a | n/a | n/a | n/a | unknown |
pf_transcription_sessions | public | n/a | n/a | n/a | n/a | unknown |
pf_transcription_templates | public | n/a | n/a | n/a | n/a | unknown |
pf_transcription_vendor_baas | public | n/a | n/a | n/a | n/a | unknown |
pf_transcription_vendor_calls | public | n/a | n/a | n/a | n/a | unknown |
pf_transcription_vendors | public | n/a | n/a | n/a | n/a | unknown |
pf_user_activation_requests | public | n/a | n/a | n/a | n/a | unknown |
pf_user_devices | public | n/a | n/a | n/a | n/a | unknown |
pf_user_sessions | public | n/a | n/a | n/a | n/a | unknown |
pf_validation_rule_executions | public | n/a | n/a | n/a | n/a | unknown |
pf_validation_rules | public | n/a | n/a | n/a | n/a | unknown |
pf_wizard_org_defaults | public | n/a | n/a | n/a | n/a | unknown |
CE tables
| Table | Schema | Columns | Indexes | FKs | Policies | RLS |
|---|
ce_calendar_connections | public | n/a | n/a | n/a | n/a | unknown |
ce_calendar_events | public | n/a | n/a | n/a | n/a | unknown |
ce_contact_relationships | public | n/a | n/a | n/a | n/a | unknown |
ce_event_attendees | public | n/a | n/a | n/a | n/a | unknown |
ce_events | public | n/a | n/a | n/a | n/a | unknown |
ce_lead_conversions | public | n/a | n/a | n/a | n/a | unknown |
ce_message_routing_rules | public | n/a | n/a | n/a | n/a | unknown |
ce_scheduled_messages | public | n/a | n/a | n/a | n/a | unknown |
ce_screening_attempts | public | n/a | n/a | n/a | n/a | unknown |
ce_screening_questionnaires | public | n/a | n/a | n/a | n/a | unknown |
ce_screening_results | public | n/a | n/a | n/a | n/a | unknown |
ce_screening_sla_config | public | n/a | n/a | n/a | n/a | unknown |
ce_sequence_enrollments | public | n/a | n/a | n/a | n/a | unknown |
ce_sequence_execution_log | public | n/a | n/a | n/a | n/a | unknown |
ce_sequence_outbound_executions | public | n/a | n/a | n/a | n/a | unknown |
ce_sequence_steps | public | n/a | n/a | n/a | n/a | unknown |
ce_sequences | public | n/a | n/a | n/a | n/a | unknown |
RH tables
| Table | Schema | Columns | Indexes | FKs | Policies | RLS |
|---|
rh_grievance_attachments | public | n/a | n/a | n/a | n/a | unknown |
rh_grievances | public | n/a | n/a | n/a | n/a | unknown |
FA tables
| Table | Schema | Columns | Indexes | FKs | Policies | RLS |
|---|
fa_1099_forms | public | n/a | n/a | n/a | n/a | unknown |
fa_account_mappings | public | n/a | n/a | n/a | n/a | unknown |
fa_alert_thresholds | public | n/a | n/a | n/a | n/a | unknown |
fa_card_transactions | public | n/a | n/a | n/a | n/a | unknown |
fa_category_mappings | public | n/a | n/a | n/a | n/a | unknown |
fa_coa_templates | public | n/a | n/a | n/a | n/a | unknown |
fa_collection_queue | public | n/a | n/a | n/a | n/a | unknown |
fa_compliance_account_mapping | public | n/a | n/a | n/a | n/a | unknown |
fa_consolidation_adjustments | public | n/a | n/a | n/a | n/a | unknown |
fa_dashboard_definitions | public | n/a | n/a | n/a | n/a | unknown |
fa_dashboard_widgets | public | n/a | n/a | n/a | n/a | unknown |
fa_deferred_revenue | public | n/a | n/a | n/a | n/a | unknown |
fa_entities | public | n/a | n/a | n/a | n/a | unknown |
fa_entity_relationships | public | n/a | n/a | n/a | n/a | unknown |
fa_expense_rule_conditions | public | n/a | n/a | n/a | n/a | unknown |
fa_expense_rules | public | n/a | n/a | n/a | n/a | unknown |
fa_gr_event_log | public | n/a | n/a | n/a | n/a | unknown |
fa_import_jobs | public | n/a | n/a | n/a | n/a | unknown |
fa_kpi_definitions | public | n/a | n/a | n/a | n/a | unknown |
fa_kpi_history | public | n/a | n/a | n/a | n/a | unknown |
fa_period_close_audit | public | n/a | n/a | n/a | n/a | unknown |
fa_plaid_transfer_intents | public | n/a | n/a | n/a | n/a | unknown |
fa_pm_event_log | public | n/a | n/a | n/a | n/a | unknown |
fa_ramp_connections | public | n/a | n/a | n/a | n/a | unknown |
fa_recurring_transaction_templates | public | n/a | n/a | n/a | n/a | unknown |
fa_report_annotations | public | n/a | n/a | n/a | n/a | unknown |
fa_report_favorites | public | n/a | n/a | n/a | n/a | unknown |
fa_report_versions | public | n/a | n/a | n/a | n/a | unknown |
fa_revenue_contracts | public | n/a | n/a | n/a | n/a | unknown |
fa_revenue_milestones | public | n/a | n/a | n/a | n/a | unknown |
fa_revenue_recognitions | public | n/a | n/a | n/a | n/a | unknown |
fa_revenue_schedule_modifications | public | n/a | n/a | n/a | n/a | unknown |
fa_revenue_schedule_periods | public | n/a | n/a | n/a | n/a | unknown |
fa_revenue_schedules | public | n/a | n/a | n/a | n/a | unknown |
fa_revenue_source_event_log | public | n/a | n/a | n/a | n/a | unknown |
fa_tax_distributions | public | n/a | n/a | n/a | n/a | unknown |
fa_tax_reports | public | n/a | n/a | n/a | n/a | unknown |
fa_tax_years | public | n/a | n/a | n/a | n/a | unknown |
fa_template_applications | public | n/a | n/a | n/a | n/a | unknown |
fa_w2_forms | public | n/a | n/a | n/a | n/a | unknown |
HR tables
| Table | Schema | Columns | Indexes | FKs | Policies | RLS |
|---|
hr_benefits_guides | public | n/a | n/a | n/a | n/a | unknown |
hr_career_paths | public | n/a | n/a | n/a | n/a | unknown |
hr_contractor_classification_tests | public | n/a | n/a | n/a | n/a | unknown |
hr_contractor_contracts | public | n/a | n/a | n/a | n/a | unknown |
hr_contractor_credentials | public | n/a | n/a | n/a | n/a | unknown |
hr_contractor_time_entries | public | n/a | n/a | n/a | n/a | unknown |
hr_contractors | public | n/a | n/a | n/a | n/a | unknown |
hr_enrollment_reminder_logs | public | n/a | n/a | n/a | n/a | unknown |
hr_everify_audit_events | public | n/a | n/a | n/a | n/a | unknown |
hr_everify_cases | public | n/a | n/a | n/a | n/a | unknown |
hr_everify_config | public | n/a | n/a | n/a | n/a | unknown |
hr_fingerprint_clearance_incidents | public | n/a | n/a | n/a | n/a | unknown |
hr_fingerprint_clearances | public | n/a | n/a | n/a | n/a | unknown |
hr_interview_scorecard_templates | public | n/a | n/a | n/a | n/a | unknown |
hr_interview_scorecards | public | n/a | n/a | n/a | n/a | unknown |
hr_job_board_import_checkpoints | public | n/a | n/a | n/a | n/a | unknown |
hr_job_board_webhook_events | public | n/a | n/a | n/a | n/a | unknown |
hr_leadership_programs | public | n/a | n/a | n/a | n/a | unknown |
hr_payment_checks | public | n/a | n/a | n/a | n/a | unknown |
hr_policies | public | n/a | n/a | n/a | n/a | unknown |
hr_policy_acknowledgments | public | n/a | n/a | n/a | n/a | unknown |
hr_policy_distributions | public | n/a | n/a | n/a | n/a | unknown |
hr_site_geofence | public | n/a | n/a | n/a | n/a | unknown |
hr_staffing_agencies | public | n/a | n/a | n/a | n/a | unknown |
hr_succession_plans | public | n/a | n/a | n/a | n/a | unknown |
hr_talent_pipelines | public | n/a | n/a | n/a | n/a | unknown |
hr_tax_form_state_items | public | n/a | n/a | n/a | n/a | unknown |
GR tables
| Table | Schema | Columns | Indexes | FKs | Policies | RLS |
|---|
gr_accreditation_caps | public | n/a | n/a | n/a | n/a | unknown |
gr_accreditation_mock_surveys | public | n/a | n/a | n/a | n/a | unknown |
gr_accreditation_tracer_packs | public | n/a | n/a | n/a | n/a | unknown |
gr_benchmarking_aggregates | public | n/a | n/a | n/a | n/a | unknown |
gr_benchmarking_consents | public | n/a | n/a | n/a | n/a | unknown |
gr_board_minutes | public | n/a | n/a | n/a | n/a | unknown |
gr_board_resolutions | public | n/a | n/a | n/a | n/a | unknown |
gr_coi_attestations | public | n/a | n/a | n/a | n/a | unknown |
gr_holiday_calendar | public | n/a | n/a | n/a | n/a | unknown |
gr_incident_corrective_actions | public | n/a | n/a | n/a | n/a | unknown |
gr_incident_findings | public | n/a | n/a | n/a | n/a | unknown |
gr_incident_investigations | public | n/a | n/a | n/a | n/a | unknown |
gr_incident_regulatory_reports | public | n/a | n/a | n/a | n/a | unknown |
gr_incident_risk_links | public | n/a | n/a | n/a | n/a | unknown |
gr_incidents | public | n/a | n/a | n/a | n/a | unknown |
gr_inservice_reminder_log | public | n/a | n/a | n/a | n/a | unknown |
gr_procedure_compliance_score_snapshots | public | n/a | n/a | n/a | n/a | unknown |
gr_procedure_template_regulatory_bodies | public | n/a | n/a | n/a | n/a | unknown |
gr_procedure_templates | public | n/a | n/a | n/a | n/a | unknown |
gr_regulatory_change_events | public | n/a | n/a | n/a | n/a | unknown |
gr_regulatory_change_impacts | public | n/a | n/a | n/a | n/a | unknown |
gr_regulatory_change_snapshots | public | n/a | n/a | n/a | n/a | unknown |
gr_regulatory_reporting_rules | public | n/a | n/a | n/a | n/a | unknown |
gr_regulatory_sources | public | n/a | n/a | n/a | n/a | unknown |
gr_state_kb_collections | public | n/a | n/a | n/a | n/a | unknown |
gr_state_kb_documents | public | n/a | n/a | n/a | n/a | unknown |
gr_training_requirement_links | public | n/a | n/a | n/a | n/a | unknown |
gr_whistleblower_reports | public | n/a | n/a | n/a | n/a | unknown |
FW tables
| Table | Schema | Columns | Indexes | FKs | Policies | RLS |
|---|
fw_approval_routing_rules | public | n/a | n/a | n/a | n/a | unknown |
fw_business_calendars | public | n/a | n/a | n/a | n/a | unknown |
fw_calendar_holidays | public | n/a | n/a | n/a | n/a | unknown |
fw_compliance_audit_entries | public | n/a | n/a | n/a | n/a | unknown |
fw_dead_letter_queue | public | n/a | n/a | n/a | n/a | unknown |
fw_decision_table_versions | public | n/a | n/a | n/a | n/a | unknown |
fw_decision_tables | public | n/a | n/a | n/a | n/a | unknown |
fw_dependency_graph | public | n/a | n/a | n/a | n/a | unknown |
fw_execution_rate_counters | public | n/a | n/a | n/a | n/a | unknown |
fw_execution_steps | public | n/a | n/a | n/a | n/a | unknown |
fw_form_prefill_rules | public | n/a | n/a | n/a | n/a | unknown |
fw_kpi_configurations | public | n/a | n/a | n/a | n/a | unknown |
fw_kpi_report_schedules | public | n/a | n/a | n/a | n/a | unknown |
fw_kpi_snapshots | public | n/a | n/a | n/a | n/a | unknown |
fw_rate_limit_configs | public | n/a | n/a | n/a | n/a | unknown |
fw_regulatory_change_log | public | n/a | n/a | n/a | n/a | unknown |
fw_rule_evaluations | public | n/a | n/a | n/a | n/a | unknown |
fw_submission_sections | public | n/a | n/a | n/a | n/a | unknown |
fw_webhook_endpoints | public | n/a | n/a | n/a | n/a | unknown |
fw_webhook_logs | public | n/a | n/a | n/a | n/a | unknown |
fw_webhook_secrets | public | n/a | n/a | n/a | n/a | unknown |
fw_workflow_audit_events | public | n/a | n/a | n/a | n/a | unknown |
fw_workflow_best_practices | public | n/a | n/a | n/a | n/a | unknown |
fw_workflow_circuit_breakers | public | n/a | n/a | n/a | n/a | unknown |
fw_workflow_compensation_actions | public | n/a | n/a | n/a | n/a | unknown |
fw_workflow_compliance_scores | public | n/a | n/a | n/a | n/a | unknown |
fw_workflow_optimization_suggestions | public | n/a | n/a | n/a | n/a | unknown |
fw_workflow_recovery_workflows | public | n/a | n/a | n/a | n/a | unknown |
fw_workflow_retry_configs | public | n/a | n/a | n/a | n/a | unknown |
FM tables
| Table | Schema | Columns | Indexes | FKs | Policies | RLS |
|---|
fm_fleet_reservations | public | n/a | n/a | n/a | n/a | unknown |
IT tables
| Table | Schema | Columns | Indexes | FKs | Policies | RLS |
|---|
it_change_implementations | public | n/a | n/a | n/a | n/a | unknown |
it_knowledge_base_versions | public | n/a | n/a | n/a | n/a | unknown |
CL tables
| Table | Schema | Columns | Indexes | FKs | Policies | RLS |
|---|
cl_988_transfers | public | n/a | n/a | n/a | n/a | unknown |
cl_aftercare_plans | public | n/a | n/a | n/a | n/a | unknown |
cl_ai_documentation_sessions | public | n/a | n/a | n/a | n/a | unknown |
cl_ai_note_attributions | public | n/a | n/a | n/a | n/a | unknown |
cl_allergies | public | n/a | n/a | n/a | n/a | unknown |
cl_allergy_alert_overrides | public | n/a | n/a | n/a | n/a | unknown |
cl_ambient_session_events | public | n/a | n/a | n/a | n/a | unknown |
cl_ambient_sessions | public | n/a | n/a | n/a | n/a | unknown |
cl_ambient_transcripts | public | n/a | n/a | n/a | n/a | unknown |
cl_assessment_instruments | public | n/a | n/a | n/a | n/a | unknown |
cl_assessment_sections | public | n/a | n/a | n/a | n/a | unknown |
cl_assessment_template_sections | public | n/a | n/a | n/a | n/a | unknown |
cl_assessment_templates | public | n/a | n/a | n/a | n/a | unknown |
cl_assessments | public | n/a | n/a | n/a | n/a | unknown |
cl_audit_dashboard_break_glass_reviews | public | n/a | n/a | n/a | n/a | unknown |
cl_between_session_checkins | public | n/a | n/a | n/a | n/a | unknown |
cl_biometrics | public | n/a | n/a | n/a | n/a | unknown |
cl_care_gaps | public | n/a | n/a | n/a | n/a | unknown |
cl_cds_alerts | public | n/a | n/a | n/a | n/a | unknown |
cl_cds_rules | public | n/a | n/a | n/a | n/a | unknown |
cl_clinical_standing_orders | public | n/a | n/a | n/a | n/a | unknown |
cl_cod_assessments | public | n/a | n/a | n/a | n/a | unknown |
cl_cod_treatment_plan_extension | public | n/a | n/a | n/a | n/a | unknown |
cl_concurrent_reviews | public | n/a | n/a | n/a | n/a | unknown |
cl_consent_requests | public | n/a | n/a | n/a | n/a | unknown |
cl_consents | public | n/a | n/a | n/a | n/a | unknown |
cl_controlled_substance_inventory | public | n/a | n/a | n/a | n/a | unknown |
cl_data_exchange_log | public | n/a | n/a | n/a | n/a | unknown |
cl_ddi_alert_suppressions | public | n/a | n/a | n/a | n/a | unknown |
cl_ddi_overrides | public | n/a | n/a | n/a | n/a | unknown |
cl_designated_contacts | public | n/a | n/a | n/a | n/a | unknown |
cl_diagnoses | public | n/a | n/a | n/a | n/a | unknown |
cl_disclosure_log | public | n/a | n/a | n/a | n/a | unknown |
cl_electronic_consents | public | n/a | n/a | n/a | n/a | unknown |
cl_environmental_assessments | public | n/a | n/a | n/a | n/a | unknown |
cl_family_notification_log | public | n/a | n/a | n/a | n/a | unknown |
cl_fhir_resources | public | n/a | n/a | n/a | n/a | unknown |
cl_follow_up_contacts | public | n/a | n/a | n/a | n/a | unknown |
cl_group_attendance | public | n/a | n/a | n/a | n/a | unknown |
cl_group_curricula | public | n/a | n/a | n/a | n/a | unknown |
cl_group_encounter_generations | public | n/a | n/a | n/a | n/a | unknown |
cl_group_session_telehealth_metadata | public | n/a | n/a | n/a | n/a | unknown |
cl_group_sessions | public | n/a | n/a | n/a | n/a | unknown |
cl_inbasket_item_activity | public | n/a | n/a | n/a | n/a | unknown |
cl_inbasket_items | public | n/a | n/a | n/a | n/a | unknown |
cl_incidents | public | n/a | n/a | n/a | n/a | unknown |
cl_intake_assessments | public | n/a | n/a | n/a | n/a | unknown |
cl_lethal_means_assessments | public | n/a | n/a | n/a | n/a | unknown |
cl_loc_assessments | public | n/a | n/a | n/a | n/a | unknown |
cl_loinc_codes | public | n/a | n/a | n/a | n/a | unknown |
cl_marketplace_bundle_items | public | n/a | n/a | n/a | n/a | unknown |
cl_marketplace_bundles | public | n/a | n/a | n/a | n/a | unknown |
cl_marketplace_imports | public | n/a | n/a | n/a | n/a | unknown |
cl_medication_adherence | public | n/a | n/a | n/a | n/a | unknown |
cl_medication_education | public | n/a | n/a | n/a | n/a | unknown |
cl_medication_reconciliations | public | n/a | n/a | n/a | n/a | unknown |
cl_medications | public | n/a | n/a | n/a | n/a | unknown |
cl_metabolic_monitoring_events | public | n/a | n/a | n/a | n/a | unknown |
cl_module_settings | public | n/a | n/a | n/a | n/a | unknown |
cl_moud_enrollments | public | n/a | n/a | n/a | n/a | unknown |
cl_moud_medication_events | public | n/a | n/a | n/a | n/a | unknown |
cl_moud_monitoring_events | public | n/a | n/a | n/a | n/a | unknown |
cl_multi_party_encounters | public | n/a | n/a | n/a | n/a | unknown |
cl_multi_party_participants | public | n/a | n/a | n/a | n/a | unknown |
cl_note_940_override_audit | public | n/a | n/a | n/a | n/a | unknown |
cl_note_templates | public | n/a | n/a | n/a | n/a | unknown |
cl_note_treatment_goals | public | n/a | n/a | n/a | n/a | unknown |
cl_notification_delivery_attempts | public | n/a | n/a | n/a | n/a | unknown |
cl_notification_escalation_chains | public | n/a | n/a | n/a | n/a | unknown |
cl_notification_events | public | n/a | n/a | n/a | n/a | unknown |
cl_notification_policies | public | n/a | n/a | n/a | n/a | unknown |
cl_order_results | public | n/a | n/a | n/a | n/a | unknown |
cl_order_set_activations | public | n/a | n/a | n/a | n/a | unknown |
cl_order_set_templates | public | n/a | n/a | n/a | n/a | unknown |
cl_order_templates | public | n/a | n/a | n/a | n/a | unknown |
cl_orders | public | n/a | n/a | n/a | n/a | unknown |
cl_outcome_measures | public | n/a | n/a | n/a | n/a | unknown |
cl_pathway_definitions | public | n/a | n/a | n/a | n/a | unknown |
cl_pathway_milestones | public | n/a | n/a | n/a | n/a | unknown |
cl_pathway_progress | public | n/a | n/a | n/a | n/a | unknown |
cl_pathway_templates | public | n/a | n/a | n/a | n/a | unknown |
cl_pathway_variances | public | n/a | n/a | n/a | n/a | unknown |
cl_patient_charts | public | n/a | n/a | n/a | n/a | unknown |
cl_patient_cohort_definitions | public | n/a | n/a | n/a | n/a | unknown |
cl_patient_cohort_memberships | public | n/a | n/a | n/a | n/a | unknown |
cl_patient_cohorts | public | n/a | n/a | n/a | n/a | unknown |
cl_patient_pathways | public | n/a | n/a | n/a | n/a | unknown |
cl_patient_submissions | public | n/a | n/a | n/a | n/a | unknown |
cl_pdmp_configuration | public | n/a | n/a | n/a | n/a | unknown |
cl_pdmp_queries | public | n/a | n/a | n/a | n/a | unknown |
cl_peer_encounters | public | n/a | n/a | n/a | n/a | unknown |
cl_pending_lab_results | public | n/a | n/a | n/a | n/a | unknown |
cl_pharmacies | public | n/a | n/a | n/a | n/a | unknown |
cl_prescriptions | public | n/a | n/a | n/a | n/a | unknown |
cl_problem_history | public | n/a | n/a | n/a | n/a | unknown |
cl_problems | public | n/a | n/a | n/a | n/a | unknown |
cl_program_attendance_summaries | public | n/a | n/a | n/a | n/a | unknown |
cl_program_enrollments | public | n/a | n/a | n/a | n/a | unknown |
cl_program_outcomes | public | n/a | n/a | n/a | n/a | unknown |
cl_program_schedules | public | n/a | n/a | n/a | n/a | unknown |
cl_progress_notes | public | n/a | n/a | n/a | n/a | unknown |
cl_quality_measure_periods | public | n/a | n/a | n/a | n/a | unknown |
cl_readmission_risk_scores | public | n/a | n/a | n/a | n/a | unknown |
cl_redisclosure_log | public | n/a | n/a | n/a | n/a | unknown |
cl_reference_labs | public | n/a | n/a | n/a | n/a | unknown |
cl_reference_ranges | public | n/a | n/a | n/a | n/a | unknown |
cl_referral_status_history | public | n/a | n/a | n/a | n/a | unknown |
cl_report_definitions | public | n/a | n/a | n/a | n/a | unknown |
cl_report_runs | public | n/a | n/a | n/a | n/a | unknown |
cl_review_appeals | public | n/a | n/a | n/a | n/a | unknown |
cl_review_schedules | public | n/a | n/a | n/a | n/a | unknown |
cl_risk_screenings | public | n/a | n/a | n/a | n/a | unknown |
cl_risk_stratifications | public | n/a | n/a | n/a | n/a | unknown |
cl_safety_plan_shares | public | n/a | n/a | n/a | n/a | unknown |
cl_safety_plans | public | n/a | n/a | n/a | n/a | unknown |
cl_sdoh_screenings | public | n/a | n/a | n/a | n/a | unknown |
cl_social_referrals | public | n/a | n/a | n/a | n/a | unknown |
cl_standing_order_executions | public | n/a | n/a | n/a | n/a | unknown |
cl_standing_order_protocols | public | n/a | n/a | n/a | n/a | unknown |
cl_tefca_exchange_log | public | n/a | n/a | n/a | n/a | unknown |
cl_treatment_goal_bank | public | n/a | n/a | n/a | n/a | unknown |
cl_treatment_goals | public | n/a | n/a | n/a | n/a | unknown |
cl_treatment_interventions | public | n/a | n/a | n/a | n/a | unknown |
cl_treatment_plan_signatures | public | n/a | n/a | n/a | n/a | unknown |
cl_treatment_plan_templates | public | n/a | n/a | n/a | n/a | unknown |
cl_treatment_plans | public | n/a | n/a | n/a | n/a | unknown |
cl_vital_signs | public | n/a | n/a | n/a | n/a | unknown |
cl_warm_handoffs | public | n/a | n/a | n/a | n/a | unknown |
PM tables
| Table | Schema | Columns | Indexes | FKs | Policies | RLS |
|---|
pm_ai_coding_suggestion_audits | public | n/a | n/a | n/a | n/a | unknown |
pm_ai_coding_suggestions | public | n/a | n/a | n/a | n/a | unknown |
pm_analytics_appointment_confirmed_log | public | n/a | n/a | n/a | n/a | unknown |
pm_analytics_appointment_created_log | public | n/a | n/a | n/a | n/a | unknown |
pm_analytics_funnel_daily | public | n/a | n/a | n/a | n/a | unknown |
pm_analytics_no_show_risk | public | n/a | n/a | n/a | n/a | unknown |
pm_analytics_revenue_impact | public | n/a | n/a | n/a | n/a | unknown |
pm_analytics_screening_log | public | n/a | n/a | n/a | n/a | unknown |
pm_analytics_waitlist_abandon_risk | public | n/a | n/a | n/a | n/a | unknown |
pm_analytics_waitlist_log | public | n/a | n/a | n/a | n/a | unknown |
pm_appeal_submissions | public | n/a | n/a | n/a | n/a | unknown |
pm_appeal_templates | public | n/a | n/a | n/a | n/a | unknown |
pm_appointment_match_log | public | n/a | n/a | n/a | n/a | unknown |
pm_appointment_reminders | public | n/a | n/a | n/a | n/a | unknown |
pm_appointments | public | n/a | n/a | n/a | n/a | unknown |
pm_assistance_program_referrals | public | n/a | n/a | n/a | n/a | unknown |
pm_audit_log | public | n/a | n/a | n/a | n/a | unknown |
pm_auth_concurrent_reviews | public | n/a | n/a | n/a | n/a | unknown |
pm_auth_denial_appeals | public | n/a | n/a | n/a | n/a | unknown |
pm_auth_reviews | public | n/a | n/a | n/a | n/a | unknown |
pm_bad_debt_writeoffs | public | n/a | n/a | n/a | n/a | unknown |
pm_batch_jobs | public | n/a | n/a | n/a | n/a | unknown |
pm_benefit_details | public | n/a | n/a | n/a | n/a | unknown |
pm_benefit_estimates | public | n/a | n/a | n/a | n/a | unknown |
pm_billing_suggestion_rules | public | n/a | n/a | n/a | n/a | unknown |
pm_capitation_contracts | public | n/a | n/a | n/a | n/a | unknown |
pm_capitation_periods | public | n/a | n/a | n/a | n/a | unknown |
pm_capitation_reconciliations | public | n/a | n/a | n/a | n/a | unknown |
pm_capitation_roster_events | public | n/a | n/a | n/a | n/a | unknown |
pm_carc_codes | public | n/a | n/a | n/a | n/a | unknown |
pm_charge_recon_daily_summary | public | n/a | n/a | n/a | n/a | unknown |
pm_charge_reconciliation_results | public | n/a | n/a | n/a | n/a | unknown |
pm_charges | public | n/a | n/a | n/a | n/a | unknown |
pm_charity_care_applications | public | n/a | n/a | n/a | n/a | unknown |
pm_checkin_discrepancies | public | n/a | n/a | n/a | n/a | unknown |
pm_claim_denials | public | n/a | n/a | n/a | n/a | unknown |
pm_claim_lines | public | n/a | n/a | n/a | n/a | unknown |
pm_claim_notes | public | n/a | n/a | n/a | n/a | unknown |
pm_claims | public | n/a | n/a | n/a | n/a | unknown |
pm_clearinghouse_config | public | n/a | n/a | n/a | n/a | unknown |
pm_code_modifier_rules | public | n/a | n/a | n/a | n/a | unknown |
pm_collection_actions | public | n/a | n/a | n/a | n/a | unknown |
pm_collections_external_referrals | public | n/a | n/a | n/a | n/a | unknown |
pm_contract_modeling_scenarios | public | n/a | n/a | n/a | n/a | unknown |
pm_contracted_rates | public | n/a | n/a | n/a | n/a | unknown |
pm_coordinator_tasks | public | n/a | n/a | n/a | n/a | unknown |
pm_cost_categories | public | n/a | n/a | n/a | n/a | unknown |
pm_cost_estimate_line_items | public | n/a | n/a | n/a | n/a | unknown |
pm_cost_rates | public | n/a | n/a | n/a | n/a | unknown |
pm_denial_models | public | n/a | n/a | n/a | n/a | unknown |
pm_denial_predictions | public | n/a | n/a | n/a | n/a | unknown |
pm_edi_enrollment_status_history | public | n/a | n/a | n/a | n/a | unknown |
pm_emergency_contacts | public | n/a | n/a | n/a | n/a | unknown |
pm_encounter_costs | public | n/a | n/a | n/a | n/a | unknown |
pm_encounters | public | n/a | n/a | n/a | n/a | unknown |
pm_era_files | public | n/a | n/a | n/a | n/a | unknown |
pm_era_orphan_lines | public | n/a | n/a | n/a | n/a | unknown |
pm_era_reconciliation_results | public | n/a | n/a | n/a | n/a | unknown |
pm_fee_schedule_entries | public | n/a | n/a | n/a | n/a | unknown |
pm_fee_schedules | public | n/a | n/a | n/a | n/a | unknown |
pm_fhir_access_log | public | n/a | n/a | n/a | n/a | unknown |
pm_fhir_app_registrations | public | n/a | n/a | n/a | n/a | unknown |
pm_financial_assistance_applications | public | n/a | n/a | n/a | n/a | unknown |
pm_financial_counseling_sessions | public | n/a | n/a | n/a | n/a | unknown |
pm_gfe_appointment_cpt_mapping | public | n/a | n/a | n/a | n/a | unknown |
pm_gfe_disputes | public | n/a | n/a | n/a | n/a | unknown |
pm_good_faith_estimates | public | n/a | n/a | n/a | n/a | unknown |
pm_group_definitions | public | n/a | n/a | n/a | n/a | unknown |
pm_group_enrollments | public | n/a | n/a | n/a | n/a | unknown |
pm_group_schedule | public | n/a | n/a | n/a | n/a | unknown |
pm_guarantors | public | n/a | n/a | n/a | n/a | unknown |
pm_information_blocking_log | public | n/a | n/a | n/a | n/a | unknown |
pm_institutional_claim_details | public | n/a | n/a | n/a | n/a | unknown |
pm_insurance_policies | public | n/a | n/a | n/a | n/a | unknown |
pm_kiosk_checkins | public | n/a | n/a | n/a | n/a | unknown |
pm_managed_care_authorizations | public | n/a | n/a | n/a | n/a | unknown |
pm_module_settings | public | n/a | n/a | n/a | n/a | unknown |
pm_otp_billing_periods | public | n/a | n/a | n/a | n/a | unknown |
pm_otp_programs | public | n/a | n/a | n/a | n/a | unknown |
pm_otp_service_components | public | n/a | n/a | n/a | n/a | unknown |
pm_patient_access_consents | public | n/a | n/a | n/a | n/a | unknown |
pm_patient_addresses | public | n/a | n/a | n/a | n/a | unknown |
pm_patient_communication_preferences | public | n/a | n/a | n/a | n/a | unknown |
pm_patient_cost_estimates | public | n/a | n/a | n/a | n/a | unknown |
pm_patient_financial_assessments | public | n/a | n/a | n/a | n/a | unknown |
pm_patient_merge_conflicts | public | n/a | n/a | n/a | n/a | unknown |
pm_patient_merge_log | public | n/a | n/a | n/a | n/a | unknown |
pm_patient_payment_plans | public | n/a | n/a | n/a | n/a | unknown |
pm_patient_site_transfers | public | n/a | n/a | n/a | n/a | unknown |
pm_patient_statements | public | n/a | n/a | n/a | n/a | unknown |
pm_patients | public | n/a | n/a | n/a | n/a | unknown |
pm_payer_contracts | public | n/a | n/a | n/a | n/a | unknown |
pm_payer_edi_enrollments | public | n/a | n/a | n/a | n/a | unknown |
pm_payer_enrollments | public | n/a | n/a | n/a | n/a | unknown |
pm_payer_modifier_rule_versions | public | n/a | n/a | n/a | n/a | unknown |
pm_payer_modifier_rules | public | n/a | n/a | n/a | n/a | unknown |
pm_payer_performance_snapshots | public | n/a | n/a | n/a | n/a | unknown |
pm_payers | public | n/a | n/a | n/a | n/a | unknown |
pm_payment_applications | public | n/a | n/a | n/a | n/a | unknown |
pm_payment_plan_installments | public | n/a | n/a | n/a | n/a | unknown |
pm_payment_plans | public | n/a | n/a | n/a | n/a | unknown |
pm_payments | public | n/a | n/a | n/a | n/a | unknown |
pm_portal_packet_assignments | public | n/a | n/a | n/a | n/a | unknown |
pm_portal_packet_items | public | n/a | n/a | n/a | n/a | unknown |
pm_portal_sessions | public | n/a | n/a | n/a | n/a | unknown |
pm_portal_users | public | n/a | n/a | n/a | n/a | unknown |
pm_preadmission_form_templates | public | n/a | n/a | n/a | n/a | unknown |
pm_preadmission_packets | public | n/a | n/a | n/a | n/a | unknown |
pm_prior_authorizations | public | n/a | n/a | n/a | n/a | unknown |
pm_program_insurance_revenue_matrix | public | n/a | n/a | n/a | n/a | unknown |
pm_provider_caseloads | public | n/a | n/a | n/a | n/a | unknown |
pm_provider_enrollment_events | public | n/a | n/a | n/a | n/a | unknown |
pm_provider_enrollments | public | n/a | n/a | n/a | n/a | unknown |
pm_provider_identifier_validations | public | n/a | n/a | n/a | n/a | unknown |
pm_provider_schedules | public | n/a | n/a | n/a | n/a | unknown |
pm_provider_time_off | public | n/a | n/a | n/a | n/a | unknown |
pm_rarc_codes | public | n/a | n/a | n/a | n/a | unknown |
pm_rcm_automation_rules | public | n/a | n/a | n/a | n/a | unknown |
pm_rcm_benchmarks | public | n/a | n/a | n/a | n/a | unknown |
pm_rcm_rule_executions | public | n/a | n/a | n/a | n/a | unknown |
pm_rcm_snapshots | public | n/a | n/a | n/a | n/a | unknown |
pm_rcm_work_queue_items | public | n/a | n/a | n/a | n/a | unknown |
pm_referral_documents | public | n/a | n/a | n/a | n/a | unknown |
pm_referral_packet_items | public | n/a | n/a | n/a | n/a | unknown |
pm_referrals | public | n/a | n/a | n/a | n/a | unknown |
pm_resources | public | n/a | n/a | n/a | n/a | unknown |
pm_revenue_code_mappings | public | n/a | n/a | n/a | n/a | unknown |
pm_rooms | public | n/a | n/a | n/a | n/a | unknown |
pm_rpa_bot_configurations | public | n/a | n/a | n/a | n/a | unknown |
pm_rpa_bot_executions | public | n/a | n/a | n/a | n/a | unknown |
pm_rpa_execution_daily_summaries | public | n/a | n/a | n/a | n/a | unknown |
pm_rpa_module_settings | public | n/a | n/a | n/a | n/a | unknown |
pm_rpa_staged_documents | public | n/a | n/a | n/a | n/a | unknown |
pm_scrub_custom_edits | public | n/a | n/a | n/a | n/a | unknown |
pm_scrub_rule_definitions | public | n/a | n/a | n/a | n/a | unknown |
pm_scrub_rule_overrides | public | n/a | n/a | n/a | n/a | unknown |
pm_secondary_claims | public | n/a | n/a | n/a | n/a | unknown |
pm_site_billing_config | public | n/a | n/a | n/a | n/a | unknown |
pm_sliding_fee_schedules | public | n/a | n/a | n/a | n/a | unknown |
pm_statement_deliveries | public | n/a | n/a | n/a | n/a | unknown |
pm_statement_runs | public | n/a | n/a | n/a | n/a | unknown |
pm_superbills | public | n/a | n/a | n/a | n/a | unknown |
pm_task_audit_log | public | n/a | n/a | n/a | n/a | unknown |
pm_telehealth_configuration | public | n/a | n/a | n/a | n/a | unknown |
pm_telehealth_sessions | public | n/a | n/a | n/a | n/a | unknown |
pm_transaction_batches | public | n/a | n/a | n/a | n/a | unknown |
pm_transaction_log | public | n/a | n/a | n/a | n/a | unknown |
pm_vbp_incentive_payments | public | n/a | n/a | n/a | n/a | unknown |
pm_vbp_measures | public | n/a | n/a | n/a | n/a | unknown |
pm_vbp_programs | public | n/a | n/a | n/a | n/a | unknown |
pm_waitlist | public | n/a | n/a | n/a | n/a | unknown |
pm_waitlist_entries | public | n/a | n/a | n/a | n/a | unknown |
pm_waitlist_outreach_log | public | n/a | n/a | n/a | n/a | unknown |
OTHER tables
| Table | Schema | Columns | Indexes | FKs | Policies | RLS |
|---|
fpl_thresholds | public | n/a | n/a | n/a | n/a | unknown |
org_compliance_configs | public | n/a | n/a | n/a | n/a | unknown |
