def load_carrier(the_file, the_database=None): new_line_item_col_names = ("PRF_PHYSN_NPI", "TAX_NUM", "HCPCS_CD", "LINE_NCH_PMT_AMT", "LINE_BENE_PTB_DDCTBL_AMT", "LINE_BENE_PRMRY_PYR_PD_AMT", "LINE_COINSRNC_AMT", "LINE_ALOWD_CHRG_AMT", "LINE_PRCSG_IND_CD", "LINE_ICD9_DGNS_CD") new_line_item_matchers = tuple("^" + i for i in new_line_item_col_names) second_criteria = { "explode-criteria": ("^ICD9_DGNS_CD", ), "table-name": "carrier_diagnosis", "column-names": ("icd9", ) } first_criteria = { "explode-criteria": new_line_item_matchers, "table-name": "line_item", "column-names": new_line_item_col_names } daniel = strat.Exploding([first_criteria, second_criteria]) dbf.quick_load(the_file, the_database, "carrier_claim", delim=",", strategy=daniel)
def load_outpatient(the_file, the_database=None): print("running load_outpatient() with ", the_file) first_criteria = { "explode-criteria": ("^HCPCS_CD", ), "table-name": "hcpc_outpatient_procedure", "column-names": ('HCPCS_CD', ) } second_criteria = { "explode-criteria": ("^ICD9_PRCDR_CD", ), "table-name": "icd9_outpatient_procedure", "column-names": ("ICD9_PRCDR_CD", ) } third_criteria = { "explode-criteria": ("^ICD9_DGNS_CD", ), "table-name": "outpatient_diagnosis", "column-names": ("ICD9_DGNS_CD", ) } tuple_p = strat.Exploding( [first_criteria, second_criteria, third_criteria]) dbf.quick_load(the_file, the_database, "outpatient_claim", delim=",", strategy=tuple_p)
def load_beneficiary(the_file, the_database=None): print("running load_beneficiary() with ", the_file) dbf.quick_load(the_file, the_database, "beneficiary")
def load_drug_events(the_file, the_database=None): print("running load_drug_events() with ", the_file) dbf.quick_load(the_file, the_database, "drug_events")