def load_eu_premium(line): p = Premium() p.insurer_id = int(line[0]) # G_ID p.country = line[1] # C_ID p.group = line[2] # C_GRP p.region = line[4] # R_ID p.age_group = line[5] # M_ID p.with_accident = int(line[6]) == 5 # VAR_ID p.internal_type = line[7] # V_ID p.insurance_type = line[8] # V_TYP p.primary_age_subgroup = int(line[9]) == 1 # isBase_V2 p.age_group_id = line[10] # V2_ID p.age_group_type = line[11] # V2_TYP p.is_base_insurance = int(line[12]) == 1 # isBase_P p.is_base_franchise = int(line[13]) == 1 # isBase_F p.franchise_level = int(line[14]) # F_Stufe p.franchise = int(line[15]) # F p.premium = premium_in_cents(line[17]) # P (in cents) p.insurance_description = line[17] # V_KBEZ return p
def load_ch_premium(line): p = Premium() p.insurer_id = int(line[0]) # G_ID p.canton = line[1] # C_ID p.group = line[2] # C_GRP p.inquiry_year = int(line[3]) # EJAHR p.region = line[5] # R_ID p.age_group = line[6] # M_ID p.with_accident = int(line[7]) == 5 # VAR_ID p.internal_type = line[8] # V_ID p.insurance_type = line[9] # V_TYP p.primary_age_subgroup = int(line[10]) == 1 # isBase_V2 p.age_group_id = line[11] # V2_ID p.age_group_type = line[12] # V2_TYP p.is_base_insurance = int(line[13]) == 1 # isBase_P p.is_base_franchise = int(line[14]) == 1 # isBase_F p.franchise_level = int(line[15]) # F_Stufe p.franchise = int(line[16]) # F p.premium = premium_in_cents(line[17]) # P (in cents) p.model_sort_id = int(line[18]) # V_SORT_NR p.insurance_description = line[19] # V_KBEZ p.primary_insurance_type = line[20] # isBASE_V p.is_fully_active = line[21] != u'1.1' # isTaetig return p