def load_claims(claims):
example = UwExample()
example.proj_start_date = date(claims.date.max().year + 1, 1, 1)
example.proj_end_date = date(example.proj_start_date.year, 12, 31)
example.unique_iden = generate_file_name()
example.example_name = example.unique_iden
example.proj_annual_enroll = int(claims.sort_index(by=['date'], ascending=[False])[:1].ee_count.min())
example.med_trend = MED_TREND
example.rx_trend = RX_TREND
example.med_margin_perc = 1
example.rx_margin_perc = 1
example.lag_med = 2
example.lag_rx = 1
db.session.add(example)
db.session.commit()
for index, row in claims.iterrows():
entry = Entry()
entry.date = row.date
entry.ee_count = int(row.ee_count)
entry.med_cost = float(row.med_cost)
entry.rx_cost = float(row.rx_cost)
entry.sl_reim = float(row.sl_reim)
entry.uw_example_id = example.id
db.session.add(entry)
db.session.commit()
return example.unique_iden
