| Tables |
| Name: | aevs_carrier_codes_for_other_health_coverage |
|---|
| File: | automated-eligibility-verification-system-aevs-carrier-codes-for-other-health-coverage.csv |
|---|
| Count: | None |
|---|
| Columns: | [['fac_no', 'varchar(9)'], ['fac_name', 'varchar(40)'], ['beg_date', 'varchar(8)'], ['end_date', 'varchar(8)'], ['day_per', 'varchar(7)'], ['data_ind', 'varchar(8)'], ['comparable', 'varchar(10)'], ['county', 'varchar(6)'], ['hsa', 'varchar(3)'], ['hfpa', 'varchar(4)'], ['lic_cat', 'varchar(7)'], ['type_cntrl', 'varchar(14)'], ['legal_org', 'varchar(14)'], ['phone', 'varchar(13)'], ['address', 'varchar(30)'], ['city', 'varchar(19)'], ['zip_code', 'varchar(10)'], ['mcal_pronum', 'varchar(9)'], ['adminis', 'varchar(27)'], ['related', 'varchar(7)'], ['parent', 'varchar(41)'], ['bed_end', 'varchar(7)'], ['bed_avg', 'varchar(7)'], ['day_totl', 'varchar(8)'], ['occup', 'varchar(5)'], ['admits', 'varchar(6)'], ['dischs', 'varchar(6)'], ['day_mcar', 'varchar(8)'], ['day_mcal', 'varchar(8)'], ['day_self', 'varchar(8)'], ['day_oth', 'varchar(7)'], ['day_sn', 'varchar(6)'], ['day_ic', 'varchar(6)'], ['day_md', 'varchar(6)'], ['day_dd', 'varchar(6)'], ['day_subacu', 'varchar(10)'], ['day_subped', 'varchar(10)'], ['day_tic', 'varchar(7)'], ['day_hospic', 'varchar(10)'], ['day_oth_rt', 'varchar(10)'], ['nr_rt_totl', 'varchar(10)'], ['nr_an_totl', 'varchar(10)'], ['oth_op_rev', 'varchar(10)'], ['tot_hc_rev', 'varchar(10)'], ['tot_hc_exp', 'varchar(10)'], ['net_frm_hc', 'varchar(10)'], ['nonhc_net', 'varchar(9)'], ['inc_tax', 'varchar(7)'], ['ext_item', 'varchar(8)'], ['net_income', 'varchar(10)'], ['nr_rt_mcar', 'varchar(10)'], ['nr_rt_mcal', 'varchar(10)'], ['nr_rt_self', 'varchar(10)'], ['nr_rt_oth', 'varchar(9)'], ['nr_sn', 'varchar(7)'], ['nr_ic', 'varchar(7)'], ['nr_md', 'varchar(7)'], ['nr_dd', 'varchar(7)'], ['nr_subacu', 'varchar(9)'], ['nr_subped', 'varchar(9)'], ['nr_tic', 'varchar(6)'], ['nr_hospic', 'varchar(9)'], ['nr_oth_rt', 'varchar(9)'], ['nr_an_mcar', 'varchar(10)'], ['nr_an_mcal', 'varchar(10)'], ['nr_an_self', 'varchar(10)'], ['nr_an_oth', 'varchar(9)'], ['nr_psupply', 'varchar(10)'], ['nr_pt', 'varchar(7)'], ['nr_pharm', 'varchar(8)'], ['nr_lab', 'varchar(6)'], ['nr_hmhlth', 'varchar(9)'], ['nr_oth_an', 'varchar(9)'], ['exp_sal', 'varchar(7)'], ['exp_ben', 'varchar(7)'], ['exp_other', 'varchar(9)'], ['work_comp', 'varchar(9)'], ['exp_sn', 'varchar(7)'], ['exp_ic', 'varchar(6)'], ['exp_md', 'varchar(7)'], ['exp_dd', 'varchar(7)'], ['exp_subacu', 'varchar(10)'], ['exp_subped', 'varchar(10)'], ['exp_tic', 'varchar(7)'], ['exp_hospic', 'varchar(10)'], ['exp_oth_rt', 'varchar(10)'], ['exp_psuppl', 'varchar(10)'], ['exp_pt', 'varchar(6)'], ['exp_pharm', 'varchar(9)'], ['exp_lab', 'varchar(7)'], ['exp_hmhlth', 'varchar(10)'], ['exp_oth_an', 'varchar(10)'], ['exp_pom', 'varchar(7)'], ['exp_hkp', 'varchar(7)'], ['exp_ll', 'varchar(6)'], ['exp_diet', 'varchar(8)'], ['exp_ss', 'varchar(6)'], ['exp_actv', 'varchar(8)'], ['exp_insv', 'varchar(8)'], ['exp_admn', 'varchar(8)'], ['exp_dprec', 'varchar(9)'], ['exp_lease', 'varchar(9)'], ['exp_prptax', 'varchar(10)'], ['exp_prpins', 'varchar(10)'], ['exp_intppe', 'varchar(10)'], ['exp_intoth', 'varchar(10)'], ['exp_bdebt', 'varchar(9)'], ['cur_asst', 'varchar(8)'], ['asst_limtd', 'varchar(10)'], ['net_ppe', 'varchar(8)'], ['const_prog', 'varchar(10)'], ['inv_oth', 'varchar(8)'], ['intan_asst', 'varchar(10)'], ['tot_asst', 'varchar(8)'], ['cur_liab', 'varchar(8)'], ['def_cred', 'varchar(8)'], ['net_ltdebt', 'varchar(10)'], ['equity', 'varchar(9)'], ['liab_eq', 'varchar(8)'], ['rel_rec_cr', 'varchar(10)'], ['rel_rec_lt', 'varchar(10)'], ['rel_pay_cr', 'varchar(10)'], ['rel_pay_lt', 'varchar(10)'], ['landimp', 'varchar(8)'], ['bldgsimp', 'varchar(9)'], ['lease_imp', 'varchar(9)'], ['equipment', 'varchar(9)'], ['tot_ppe', 'varchar(8)'], ['acc_deprec', 'varchar(10)'], ['mort_pay', 'varchar(8)'], ['cap_lease', 'varchar(9)'], ['bond_pay', 'varchar(8)'], ['tot_ltdebt', 'varchar(10)'], ['cur_mat', 'varchar(8)'], ['cur_ratio', 'varchar(9)'], ['acid_ratio', 'varchar(10)'], ['days_ar', 'varchar(7)'], ['ltd_asst', 'varchar(8)'], ['debt_cov', 'varchar(8)'], ['op_margin', 'varchar(9)'], ['net_rtn_eq', 'varchar(10)'], ['trnovr_opr', 'varchar(10)'], ['asst_equty', 'varchar(10)'], ['ppe_bed', 'varchar(7)'], ['prdhr_mgt', 'varchar(9)'], ['prdhr_gnp', 'varchar(9)'], ['prdhr_rn', 'varchar(8)'], ['prdhr_lvn', 'varchar(9)'], ['prdhr_na', 'varchar(8)'], ['prdhr_tsp', 'varchar(9)'], ['prdhr_psy', 'varchar(9)'], ['prdhr_oth', 'varchar(9)'], ['prdhr_an', 'varchar(8)'], ['prdhr_pom', 'varchar(9)'], ['prdhr_hkp', 'varchar(9)'], ['prdhr_ll', 'varchar(8)'], ['prdhr_diet', 'varchar(10)'], ['prdhr_ss', 'varchar(8)'], ['prdhr_actv', 'varchar(10)'], ['prdhr_insv', 'varchar(10)'], ['prdhr_admn', 'varchar(10)'], ['prdhr_totl', 'varchar(10)'], ['tmp_hr_gnp', 'varchar(10)'], ['tmp_hr_rn', 'varchar(9)'], ['tmp_hr_lvn', 'varchar(10)'], ['tmp_hr_na', 'varchar(9)'], ['tmp_hr_psy', 'varchar(10)'], ['tmp_hr_oth', 'varchar(10)'], ['tmp_hr_tot', 'varchar(10)'], ['sw_mgt', 'varchar(7)'], ['sw_gnp', 'varchar(7)'], ['sw_rn', 'varchar(7)'], ['sw_lvn', 'varchar(7)'], ['sw_na', 'varchar(7)'], ['sw_tsp', 'varchar(7)'], ['sw_psy', 'varchar(7)'], ['sw_oth', 'varchar(7)'], ['sw_anc', 'varchar(7)'], ['sw_pom', 'varchar(7)'], ['sw_hkp', 'varchar(7)'], ['sw_ll', 'varchar(6)'], ['sw_diet', 'varchar(8)'], ['sw_ss', 'varchar(6)'], ['sw_actv', 'varchar(8)'], ['sw_insv', 'varchar(8)'], ['sw_admn', 'varchar(8)'], ['sw_totl', 'varchar(8)'], ['tmp_pd_gnp', 'varchar(10)'], ['tmp_pd_rn', 'varchar(9)'], ['tmp_pd_lvn', 'varchar(10)'], ['tmp_pd_na', 'varchar(9)'], ['tmp_pd_psy', 'varchar(10)'], ['tmp_pd_oth', 'varchar(10)'], ['tmp_pd_tot', 'varchar(10)'], ['emp_avg', 'varchar(7)'], ['emp_trnovr', 'varchar(10)'], ['emp_cont', 'varchar(8)']] |
|---|
| Name: | None |
|---|
| File: | datapackage.json |
|---|
| Count: | None |
|---|
| Columns: | [['fac_no', 'varchar(9)'], ['fac_name', 'varchar(40)'], ['beg_date', 'varchar(8)'], ['end_date', 'varchar(8)'], ['day_per', 'varchar(7)'], ['data_ind', 'varchar(8)'], ['comparable', 'varchar(10)'], ['county', 'varchar(6)'], ['hsa', 'varchar(3)'], ['hfpa', 'varchar(4)'], ['lic_cat', 'varchar(7)'], ['type_cntrl', 'varchar(14)'], ['legal_org', 'varchar(14)'], ['phone', 'varchar(13)'], ['address', 'varchar(30)'], ['city', 'varchar(19)'], ['zip_code', 'varchar(10)'], ['mcal_pronum', 'varchar(9)'], ['adminis', 'varchar(27)'], ['related', 'varchar(7)'], ['parent', 'varchar(41)'], ['bed_end', 'varchar(7)'], ['bed_avg', 'varchar(7)'], ['day_totl', 'varchar(8)'], ['occup', 'varchar(5)'], ['admits', 'varchar(6)'], ['dischs', 'varchar(6)'], ['day_mcar', 'varchar(8)'], ['day_mcal', 'varchar(8)'], ['day_self', 'varchar(8)'], ['day_oth', 'varchar(7)'], ['day_sn', 'varchar(6)'], ['day_ic', 'varchar(6)'], ['day_md', 'varchar(6)'], ['day_dd', 'varchar(6)'], ['day_subacu', 'varchar(10)'], ['day_subped', 'varchar(10)'], ['day_tic', 'varchar(7)'], ['day_hospic', 'varchar(10)'], ['day_oth_rt', 'varchar(10)'], ['nr_rt_totl', 'varchar(10)'], ['nr_an_totl', 'varchar(10)'], ['oth_op_rev', 'varchar(10)'], ['tot_hc_rev', 'varchar(10)'], ['tot_hc_exp', 'varchar(10)'], ['net_frm_hc', 'varchar(10)'], ['nonhc_net', 'varchar(9)'], ['inc_tax', 'varchar(7)'], ['ext_item', 'varchar(8)'], ['net_income', 'varchar(10)'], ['nr_rt_mcar', 'varchar(10)'], ['nr_rt_mcal', 'varchar(10)'], ['nr_rt_self', 'varchar(10)'], ['nr_rt_oth', 'varchar(9)'], ['nr_sn', 'varchar(7)'], ['nr_ic', 'varchar(7)'], ['nr_md', 'varchar(7)'], ['nr_dd', 'varchar(7)'], ['nr_subacu', 'varchar(9)'], ['nr_subped', 'varchar(9)'], ['nr_tic', 'varchar(6)'], ['nr_hospic', 'varchar(9)'], ['nr_oth_rt', 'varchar(9)'], ['nr_an_mcar', 'varchar(10)'], ['nr_an_mcal', 'varchar(10)'], ['nr_an_self', 'varchar(10)'], ['nr_an_oth', 'varchar(9)'], ['nr_psupply', 'varchar(10)'], ['nr_pt', 'varchar(7)'], ['nr_pharm', 'varchar(8)'], ['nr_lab', 'varchar(6)'], ['nr_hmhlth', 'varchar(9)'], ['nr_oth_an', 'varchar(9)'], ['exp_sal', 'varchar(7)'], ['exp_ben', 'varchar(7)'], ['exp_other', 'varchar(9)'], ['work_comp', 'varchar(9)'], ['exp_sn', 'varchar(7)'], ['exp_ic', 'varchar(6)'], ['exp_md', 'varchar(7)'], ['exp_dd', 'varchar(7)'], ['exp_subacu', 'varchar(10)'], ['exp_subped', 'varchar(10)'], ['exp_tic', 'varchar(7)'], ['exp_hospic', 'varchar(10)'], ['exp_oth_rt', 'varchar(10)'], ['exp_psuppl', 'varchar(10)'], ['exp_pt', 'varchar(6)'], ['exp_pharm', 'varchar(9)'], ['exp_lab', 'varchar(7)'], ['exp_hmhlth', 'varchar(10)'], ['exp_oth_an', 'varchar(10)'], ['exp_pom', 'varchar(7)'], ['exp_hkp', 'varchar(7)'], ['exp_ll', 'varchar(6)'], ['exp_diet', 'varchar(8)'], ['exp_ss', 'varchar(6)'], ['exp_actv', 'varchar(8)'], ['exp_insv', 'varchar(8)'], ['exp_admn', 'varchar(8)'], ['exp_dprec', 'varchar(9)'], ['exp_lease', 'varchar(9)'], ['exp_prptax', 'varchar(10)'], ['exp_prpins', 'varchar(10)'], ['exp_intppe', 'varchar(10)'], ['exp_intoth', 'varchar(10)'], ['exp_bdebt', 'varchar(9)'], ['cur_asst', 'varchar(8)'], ['asst_limtd', 'varchar(10)'], ['net_ppe', 'varchar(8)'], ['const_prog', 'varchar(10)'], ['inv_oth', 'varchar(8)'], ['intan_asst', 'varchar(10)'], ['tot_asst', 'varchar(8)'], ['cur_liab', 'varchar(8)'], ['def_cred', 'varchar(8)'], ['net_ltdebt', 'varchar(10)'], ['equity', 'varchar(9)'], ['liab_eq', 'varchar(8)'], ['rel_rec_cr', 'varchar(10)'], ['rel_rec_lt', 'varchar(10)'], ['rel_pay_cr', 'varchar(10)'], ['rel_pay_lt', 'varchar(10)'], ['landimp', 'varchar(8)'], ['bldgsimp', 'varchar(9)'], ['lease_imp', 'varchar(9)'], ['equipment', 'varchar(9)'], ['tot_ppe', 'varchar(8)'], ['acc_deprec', 'varchar(10)'], ['mort_pay', 'varchar(8)'], ['cap_lease', 'varchar(9)'], ['bond_pay', 'varchar(8)'], ['tot_ltdebt', 'varchar(10)'], ['cur_mat', 'varchar(8)'], ['cur_ratio', 'varchar(9)'], ['acid_ratio', 'varchar(10)'], ['days_ar', 'varchar(7)'], ['ltd_asst', 'varchar(8)'], ['debt_cov', 'varchar(8)'], ['op_margin', 'varchar(9)'], ['net_rtn_eq', 'varchar(10)'], ['trnovr_opr', 'varchar(10)'], ['asst_equty', 'varchar(10)'], ['ppe_bed', 'varchar(7)'], ['prdhr_mgt', 'varchar(9)'], ['prdhr_gnp', 'varchar(9)'], ['prdhr_rn', 'varchar(8)'], ['prdhr_lvn', 'varchar(9)'], ['prdhr_na', 'varchar(8)'], ['prdhr_tsp', 'varchar(9)'], ['prdhr_psy', 'varchar(9)'], ['prdhr_oth', 'varchar(9)'], ['prdhr_an', 'varchar(8)'], ['prdhr_pom', 'varchar(9)'], ['prdhr_hkp', 'varchar(9)'], ['prdhr_ll', 'varchar(8)'], ['prdhr_diet', 'varchar(10)'], ['prdhr_ss', 'varchar(8)'], ['prdhr_actv', 'varchar(10)'], ['prdhr_insv', 'varchar(10)'], ['prdhr_admn', 'varchar(10)'], ['prdhr_totl', 'varchar(10)'], ['tmp_hr_gnp', 'varchar(10)'], ['tmp_hr_rn', 'varchar(9)'], ['tmp_hr_lvn', 'varchar(10)'], ['tmp_hr_na', 'varchar(9)'], ['tmp_hr_psy', 'varchar(10)'], ['tmp_hr_oth', 'varchar(10)'], ['tmp_hr_tot', 'varchar(10)'], ['sw_mgt', 'varchar(7)'], ['sw_gnp', 'varchar(7)'], ['sw_rn', 'varchar(7)'], ['sw_lvn', 'varchar(7)'], ['sw_na', 'varchar(7)'], ['sw_tsp', 'varchar(7)'], ['sw_psy', 'varchar(7)'], ['sw_oth', 'varchar(7)'], ['sw_anc', 'varchar(7)'], ['sw_pom', 'varchar(7)'], ['sw_hkp', 'varchar(7)'], ['sw_ll', 'varchar(6)'], ['sw_diet', 'varchar(8)'], ['sw_ss', 'varchar(6)'], ['sw_actv', 'varchar(8)'], ['sw_insv', 'varchar(8)'], ['sw_admn', 'varchar(8)'], ['sw_totl', 'varchar(8)'], ['tmp_pd_gnp', 'varchar(10)'], ['tmp_pd_rn', 'varchar(9)'], ['tmp_pd_lvn', 'varchar(10)'], ['tmp_pd_na', 'varchar(9)'], ['tmp_pd_psy', 'varchar(10)'], ['tmp_pd_oth', 'varchar(10)'], ['tmp_pd_tot', 'varchar(10)'], ['emp_avg', 'varchar(7)'], ['emp_trnovr', 'varchar(10)'], ['emp_cont', 'varchar(8)']] |
|---|
|
|---|