AllRehabSimulator

Row counts

SourceConnector stagingSeedsMart stagingIntermediateFinalPublish

Source38 models

caboodle.clinicalnotefact~522k rowscaboodle.coveragedim~833k rowscaboodle.departmentdim~3.8M rowscaboodle.encounterfact~547k rowscaboodle.providerdim~2.5M rowsclarity.cl_icd_px~2.3M rowsclarity.clarity_bed~102k rowsclarity.clarity_dep~554k rowsclarity.clarity_eap~339k rowsclarity.clarity_edg~81k rowsclarity.clarity_epm~2.0M rowsclarity.clarity_prc~1.7M rowsclarity.clarity_rom~2.7M rowsclarity.f_sched_appt~3.3M rowsclarity.hno_info~120k rowsclarity.hno_note_text~3.7M rowsclarity.hsp_account~755k rowsclarity.hsp_acct_dx_list~2.3M rowsclarity.hsp_acct_px_list~2.6M rowsclarity.ip_flwsht_meas~769k rowsclarity.ip_flwsht_rec~1.3M rowsclarity.note_enc_info~3.3M rowsclarity.order_metrics~598k rowsclarity.order_proc~441k rowsclarity.pat_enc_hsp~231k rowsclarity.pat_enc_wt_lst~741k rowsclarity.pat_enc_wt_lst_dp~1.5M rowsclarity.pat_enc_wt_lst_nt~704k rowsclarity.patient~588k rowsclarity.zc_disch_disp~2.0M rowsclarity.zc_financial_class~101k rowsclarity.zc_note_type~1.6M rowsclarity.zc_pat_class~599k rowsclarity.zc_pat_service~4.0M rowspredictions.los_remaining_v0~361k rowssimulator_state.chain~4.0M rowssimulator_state.encounters~3.3M rowssimulator_state.tasks~82k rows

Connector staging34 models

caboodle__stg_clinicalnotefact~810k rowscaboodle__stg_coveragedim~471k rowscaboodle__stg_departmentdim~283k rowscaboodle__stg_encounterfact~1.3M rowscaboodle__stg_providerdim~41k rowsclarity__stg_cl_icd_px~757k rowsclarity__stg_clarity_bed~41k rowsclarity__stg_clarity_dep~124k rowsclarity__stg_clarity_eap~2.1M rowsclarity__stg_clarity_edg~738k rowsclarity__stg_clarity_epm~294k rowsclarity__stg_clarity_prc~49k rowsclarity__stg_clarity_rom~43k rowsclarity__stg_f_sched_appt~1.4M rowsclarity__stg_hno_info~1.0M rowsclarity__stg_hno_note_text~1.6M rowsclarity__stg_hsp_account~1.9M rowsclarity__stg_hsp_acct_dx_list~40k rowsclarity__stg_hsp_acct_px_list~263k rowsclarity__stg_ip_flwsht_meas~835k rowsclarity__stg_ip_flwsht_rec~90k rowsclarity__stg_note_enc_info~881k rowsclarity__stg_order_metrics~2.1M rowsclarity__stg_order_proc~135k rowsclarity__stg_pat_enc_hsp~321k rowsclarity__stg_pat_enc_wt_lst~1.8M rowsclarity__stg_pat_enc_wt_lst_dp~380k rowsclarity__stg_pat_enc_wt_lst_nt~176k rowsclarity__stg_patient~390k rowsclarity__stg_zc_disch_disp~56k rowsclarity__stg_zc_financial_class~161k rowsclarity__stg_zc_note_type~67k rowsclarity__stg_zc_pat_class~123k rowsclarity__stg_zc_pat_service~42k rows

Seeds14 seeds

rehab_discipline_proc3 rulesrehab_do_not_waitlist_keyword6 rulesrehab_dx_override_keyword2 rulesrehab_genmed_hosp_service1 rulesrehab_obs_pat_class1 rulesrehab_six_clicks_flowsheet2 rulesrehab_stroke_dx_code6 rulesrehab_stroke_order_set6 rulesrehab_tavr_dx_code3 rulesrehab_tavr_imcu_dept1 rulesrehab_tavr_px_prefix2 rulesrehab_trauma_order_set2 rulesrehab_visit_type4 rulesrehab_waitlist_department3 rules

Mart staging12 models

rehab__stg_pipeline_heartbeat~1.0M rowsstg_clinical_note~177k rowsstg_coverage~1.3M rowsstg_department~122k rowsstg_encounter~678k rowsstg_hno_info~190k rowsstg_hno_note_text~679k rowsstg_hsp_account~42k rowsstg_order_proc~69k rowsstg_pat_enc_hsp~1.3M rowsstg_provider~1.7M rowsstg_sched_appt~2.0M rows

Intermediate23 models

int_cohort~1.2k rowsint_encounter_notes~31k rowsint_encounters~31k rowsint_note_task_map~129k rowsint_staff_capacity~130k rowsint_therapy_tasks~84k rowsrehab__int_appointment~14k rowsrehab__int_code_set_health~5.1k rowsrehab__int_encounter~94k rowsrehab__int_encounter_dx~85k rowsrehab__int_encounter_px~1.2k rowsrehab__int_note_keyword~81k rowsrehab__int_patient_identity~18k rowsrehab__int_pipeline_heartbeat~4.7k rowsrehab__int_prediction~40k rowsrehab__int_queue_item~39k rowsrehab__int_six_clicks~1.1k rowsrehab__int_stroke_order~64k rowsrehab__int_tavr_px_code~1.0k rowsrehab__int_tavr_signal~47k rowsrehab__int_trauma_order~926 rowsrehab__int_waitlist_item~53k rowsrehab__int_waitlist_note~4.2k rows

Final9 models

chain~6.2k rowschain_notes~5.3k rowsencounters~349 rowsrehab__agg_queue_item_feature_daily~1.1k rowsrehab__report_app_queue_metadata~1.7k rowsrehab__report_pipeline_heartbeat~260 rowsrehab__report_queue_item_feature~6.3k rowsstaff_capacity~2.8k rowstasks~966 rows

Publish7 models

rehab__pub_app_queue_metadata~1.5k rowsrehab__pub_pipeline_heartbeat~3.9k rowsrehab__pub_report_queue_item_feature~2.0k rowssimulator__pub_chain~603 rowssimulator__pub_encounters~249 rowssimulator__pub_staff_capacity~1.1k rowssimulator__pub_tasks~1.8k rows