{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Inicio","AMI","Información","Salud Flexible","reglas"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":0,"defined_names":20,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Inicio","index":0,"n_rows":37,"n_cols":9,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"*Solo completar los datos por el cual desea rehacer"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Debe decir : "]

{"sheet":"AMI","index":1,"n_rows":220,"n_cols":22,"rows_kept":220,"cut":false,"hidden":false,"merged":[[106,10,106,14],[84,3,84,16],[89,1,89,16],[90,1,90,2],[86,3,86,16],[92,1,92,2],[70,10,70,16],[70,3,70,9],[70,1,70,2],[81,10,81,14],[82,10,82,14],[73,1,73,2],[73,3,73,9],[73,10,73,16],[85,3,85,16],[75,3,75,16],[77,1,79,2],[77,3,79,16],[75,1,75,2],[71,1,72,2],[71,3,72,9],[71,10,72,16],[115,1,117,2],[115,3,115,16],[116,3,116,16],[117,3,117,16],[100,3,100,16],[100,1,100,2],[84,1,87,2],[87,3,87,16],[98,1,98,2],[98,3,98,9],[98,10,98,16],[96,1,97,2],[96,3,97,9],[96,10,97,16],[91,1,91,2],[91,3,91,9],[91,10,91,16],[92,3,92,9],[92,10,92,16],[90,3,90,9],[90,10,90,16],[93,1,95,2],[93,3,95,9],[93,10,95,16],[63,11,63,12],[63,13,63,16],[68,1,68,2],[68,10,68,16],[69,10,69,16],[68,3,68,9],[69,3,69,9],[67,1,67,16],[65,1,65,2],[65,3,65,16],[69,1,69,2],[28,10,28,14],[16,10,16,14],[29,10,29,14],[31,1,33,2],[31,3,31,16],[35,1,35,2],[37,1,39,2],[37,3,39,16],[46,3,46,16],[41,10,41,14],[42,10,42,14],[44,1,44,2],[18,3,18,9],[21,3,21,16],[22,3,22,16],[24,3,26,16],[20,3,20,16],[32,3,32,16],[18,1,18,2],[20,1,22,2],[24,1,26,2],[33,3,33,16],[35,3,35,16],[15,10,15,14],[1,6,1,7],[10,12,10,13],[12,5,12,6],[12,7,12,8],[12,9,12,10],[13,5,13,6],[13,7,13,8],[13,9,13,10],[13,11,13,12],[9,4,9,7],[7,2,7,7],[7,9,7,10],[9,9,9,10],[8,12,9,16],[7,12,7,16],[11,1,11,16],[12,1,12,4],[12,11,12,12],[12,13,12,16],[13,1,13,4],[13,13,13,16],[2,6,2,7],[4,0,5,7],[189,1,189,2],[189,3,189,11],[192,3,192,6],[195,3,195,6],[195,8,195,9],[195,10,195,12],[195,13,195,16],[153,3,153,9],[166,3,166,8],[153,1,153,2],[157,1,157,2],[157,3,157,16],[159,1,161,2],[159,3,161,16],[166,11,166,14],[163,10,163,14],[177,10,177,14],[186,10,186,14],[173,1,175,2],[173,3,175,16],[166,1,166,2],[182,1,184,2],[180,1,180,2],[180,3,180,16],[52,3,52,16],[44,3,44,10],[110,1,110,2],[111,1,111,2],[112,1,112,2],[113,1,113,2],[110,3,110,11],[111,3,111,11],[112,3,112,11],[113,3,113,11],[109,1,109,11],[44,12,44,14],[61,1,61,16],[102,1,104,2],[102,3,104,16],[62,9,62,10],[62,11,62,12],[62,13,62,16],[58,10,58,14],[59,10,59,14],[63,1,63,4],[63,5,63,6],[63,7,63,8],[63,9,63,10],[199,1,201,2],[199,3,201,16],[197,1,197,2],[197,3,197,16],[195,1,195,2],[191,1,191,2],[192,1,192,2],[191,3,191,6],[191,8,191,9],[191,10,191,12],[191,13,191,16],[192,13,192,16],[192,10,192,12],[192,8,192,9],[193,1,193,2],[193,3,193,6],[193,8,193,9],[193,10,193,12],[193,13,193,16],[194,1,194,2],[194,3,194,6],[194,8,194,9],[194,10,194,12],[194,13,194,16],[144,3,144,16],[142,1,142,2],[144,1,144,2],[146,1,148,2],[146,3,148,16],[126,1,126,2],[119,1,121,2],[119,3,121,16],[131,1,131,16],[178,10,178,14],[187,10,187,14],[155,1,155,2],[155,3,155,16],[171,1,171,2],[171,3,171,16],[132,1,132,4],[132,5,132,6],[132,7,132,8],[132,9,132,10],[132,11,132,12],[132,13,132,16],[133,1,133,4],[133,5,133,6],[133,7,133,8],[133,9,133,10],[133,11,133,12],[133,13,133,16],[135,1,137,2],[135,3,137,16],[182,3,184,16],[139,10,139,14],[150,10,150,14],[168,1,169,2],[168,3,168,16],[169,3,169,16],[51,3,51,16],[49,1,52,2],[46,1,47,2],[107,10,107,14],[124,10,124,14],[140,10,140,14],[151,10,151,14],[164,10,164,14],[129,3,129,16],[126,3,126,16],[128,1,129,2],[128,3,128,16],[123,10,123,14],[47,3,47,16],[49,3,49,16],[50,3,50,16],[54,1,56,2],[54,3,56,16],[62,1,62,4],[62,5,62,6],[62,7,62,8],[142,3,142,16],[203,10,203,14],[204,10,204,14],[206,1,206,2],[206,3,206,11],[208,1,208,2],[208,3,208,6],[208,8,208,9],[208,10,208,12],[208,13,208,16],[209,1,209,2],[209,3,209,6],[209,8,209,9],[209,10,209,12],[209,13,209,16],[210,1,210,2],[210,3,210,6],[210,8,210,9],[210,10,210,12],[210,13,210,16],[219,1,221,2],[219,3,221,16],[214,1,217,2],[211,1,211,2],[211,3,211,6],[211,8,211,9],[211,10,211,12],[211,13,211,16],[212,1,212,2],[212,3,212,6],[212,8,212,9],[212,10,212,12],[212,13,212,16],[214,3,214,16],[215,3,215,16],[217,3,217,16],[216,3,216,16]]}
[]
[null,null,null,null,null,null,"ASUNTO :",null,{"$f":"+ASUNTOS","v":" / Continuidad y Preexistencias / Póliza : Seleccione -  / Corredor: "},null,null,null,"*"]
[null,null,null,null,null,null,"CORREO :",null,{"$f":"+U22","v":"recepcion@rimac.com.pe"},{"$f":"+U23","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Versión 3.22"]
["FORMATO AMI"]
[]
[]
[null,"Corredor",null,null,null,null,null,null,"Fecha",null,null,null,"TENER EN CUENTA"]
[null,null,null,null,null,null,null,null,null,null,null,null,"La operación se ejecutará según la fecha ingresada en este recuadro. Validar las indicaciones de lo contrario se usará la fecha de la solicitud."]
[null,"Producto","Seleccione",null,{"$f":"IF(C10=\"Seleccione\",\"\",_xlfn.XLOOKUP(C10,Codigo,Producto,\"\"))","v":""},null,null,null,"N° Póliza",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+T60","v":"Continuidad y Preexistencias"}]
[]
[null,"Datos del Contratante"]
[null,"Nombres y apellidos / Razon social",null,null,null,"Tipo de Dcto",null,"Nro. de Dcto",null,"Correo electrónico",null,"Teléfono",null,"Dirección"]
[null,null,null,null,null,"Seleccione"]
[]
[null,"ANULACIÓN "]
[null,"Tiempo de atención - 5 días"]
[]
[null,"Motivo de Anulación :",null,"Seleccione"]
[]
[null,"IMPORTANTE",null,"La anulación de una póliza solo puede ejecutarse desde la fecha de solicitud en adelante. De solicitar fecha retroactiva se trabajará operación a fecha de solicitud.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B14&\" / \"&V10&\" / Póliza : \"&C10&\" - \"&J10&\" / Corredor: \"&C8","v":" / Continuidad y Preexistencias / Póliza : Seleccione -  / Corredor: "}]
[null,null,null,"Si se requiere anulación con fecha a futuro el cliente deberá pagar por todo el tiempo coberturado hasta la fecha solicitante.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+U60","v":"recepcion@rimac.com.pe"}]
[null,null,null,"En caso de fallecimiento y no aplique liberación de primas se debe adjuntar el certificado de defunción.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U61","v":" "}]
[]
[null,"OBSERVACIONES ADICIONALES"]
[]
[]
[]
[null,"CAMBIO DE AGENCIAMIENTO"]
[null,"Tiempo de atención - 3 días"]
[]
[null,"OBLIGATORIO",null,"Carta de nombramiento según formato SBS correctamente llenada."]
[null,null,null,"En caso de persona jurídica se debe enviar carta de nombramiento en hoja membretada."]
[null,null,null,"En caso de persona natural se debe enviar carta de nombramiento + copia del DNI vigente del contratante."]
[]
[null,"IMPORTANTE",null,"Carta de nombramiento no debe tener firma superpuesta (pegada)"]
[]
[null,"OBSERVACIONES ADICIONALES"]
[]
[]
[]
[null,"MIGRACIÓN  | Cambio de producto"]
[null,"Tiempo de atención - 5 días"]
[]
[null,"Nuevo producto :",null,"Seleccione",null,null,null,null,null,null,null,null,"Seleccione plan para Salud Flexible"]
[]
[null,"OBLIGATORIO",null,"DPS editable o tradicional correctamente llenada."]
[null,null,null,"Obligatorio indicar código de plan para Salud Flexible - "]
[]
[null,"IMPORTANTE",null,"No se aceptan DPS con firmas superpuestas (pegadas)."]
[null,null,null,"Póliza inicial se anulará completamente y se migrarán solo a los asegurados que se muestren en la nueva DPS, salvo que corredor especifique otra indicación."]
[null,null,null,"DPS editable debe contar con firma biométrica."]
[null,null,null,"DPS tradicional debe estar escaneada con firma manuscrita."]
[]
[null,"OBSERVACIONES ADICIONALES"]
[]
[]
[]
[null,"CAMBIO DE CONTRATANTE"]
[null,"Tiempo de atención - 5 días",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Continuidad y Preexistencias","recepcion@rimac.com.pe"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,"Datos del nuevo contratante",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,"Nombres y apellidos / Razon social",null,null,null,"Tipo de Dcto",null,"Nro. de Dcto",null,"Correo electrónico",null,"Teléfono",null,"Dirección"]
[null,null,null,null,"Seleccione","Seleccione"]
[]
[null,"OBLIGATORIO",null,"Llenar todos los datos del nuevo contratante en el recuadro superior."]
[]
[null,"INDICACIONES PARA ELEGIR FECHA"]
[null,"TIPO DE PÓLIZA",null,"PÓLIZA REGULAR",null,null,null,null,null,null,"PÓLIZA SEMIREGULAR"]
[null,"DESCRIPCIÓN",null,"Pólizas cuyo inicio de vigencia es el 01 del mes",null,null,null,null,null,null,"Pólizas cuyo inicio de vigencia es cualquier día del mes diferente a 01"]
[null,"VIGENCIA",null,"Considerar el 01 del mes anterior, mes actual o mes siguiente de la fecha de solicitud.",null,null,null,null,null,null,"Considerar mismo día de su vigencia en el mes anterior, actual o siguiente de la fecha de solicitud"]
[null,"EJEMPLO",null,"Póliza inicia 01/04 y se genera trámite de cambio de contratante en octubre. Cambio de contratante puede realizarse el 01/09, el 01/10 o el 01/11.",null,null,null,null,null,null,"Póliza inicia 16/04 y se genera trámite de cambio de contratante en octubre. Cambio de contratante puede realizarse el 16/09, el 16/10 o el 16/11."]
[]
[null,"FECHA ERRADA",null,"Si se indica fecha incorrecta se tomará el 01 más cercano a la fecha de la solicitud.",null,null,null,null,null,null,"Si se indica fecha incorrecta se tomará el día de vigencia más cercano a la fecha de la solicitud."]
[]
[null,"IMPORTANTE",null,"El cliente deberá pagar por todo el tiempo coberturado hasta la fecha solicitada."]
[]
[null,"OBSERVACIONES ADICIONALES"]
[]
[]
[]
[null,"INCLUSIÓN"]
[null,"Tiempo de atención - 3 días"]
[]
[null,"OBLIGATORIO",null,"DPS editable o tradicional correctamente llenada."]
[null,null,null,"DPS editable debe contar con firma biométrica."]
[null,null,null,"DPS tradicional debe estar escaneada con firma manuscrita."]
[null,null,null,"Recién nacido con menos de 60 días debe enviar Acta de nacimiento o Certificado de Nacido Vivo con nombres y apellidos completos de RN."]
[]
[null,"INDICACIONES PARA ELEGIR FECHA"]
[null,"TIPO DE PÓLIZA",null,"PÓLIZA REGULAR",null,null,null,null,null,null,"PÓLIZA SEMIREGULAR"]
[null,"DESCRIPCIÓN",null,"Pólizas cuyo inicio de vigencia es el 01 del mes",null,null,null,null,null,null,"Pólizas cuyo inicio de vigencia es cualquier día del mes diferente a 01"]
[null,"VIGENCIA",null,"Considerar el 01 del mes actual o mes siguiente de la fecha de solicitud.",null,null,null,null,null,null,"Inclusión de dependiente puede realizarse en cualquier día del mes."]
[null,"EJEMPLO",null,"Póliza inicia 01/04 y se genera trámite de inclusión en octubre. Si se ingresa antes del 15/10 la inclusión se puede realizar el 01/10 o el 01/11. Si solicitud ingresa a partir del 16/10 la inclusión se puede realizar al 01/11.",null,null,null,null,null,null,"Póliza inicia 16/04 por tanto inclusión puede realizarse en cualquier fecha no retroactiva salvo para el caso de recién nacidos."]
[]
[]
[null,"RECIÉN NACIDOS",null,"Puede considerar el 01 del mes de nacimiento siempre que no haya pasado más de 60 días desde su fecha de nacimiento a la fecha de solicitud.",null,null,null,null,null,null,"Puede realizarse desde su fecha de nacimiento siempre que no haya pasado más de 60 días desde su fecha de nacimiento a la fecha de solicitud."]
[]
[null,"FECHA ERRADA",null,"Si se elige fecha incorrecta se tomará el 01 más cercano a la fecha de la solicitud.",null,null,null,null,null,null,"Si se elige fecha incorrecta se realizará a la fecha de la solicitud."]
[]
[null,"IMPORTANTE",null,"No se aceptan DPS con firmas superpuestas (pegadas)."]
[]
[null,"OBSERVACIONES ADICIONALES"]
[]
[]
[]
[null,"EXCLUSIÓN"]
[null,"Tiempo de atención - 3 días"]
[]
[null,"NOMBRE DE ASEGURADOS A EXCLUIR"]
[null,"ASEGURADO 01"]
[null,"ASEGURADO 02"]
[null,"ASEGURADO 03"]
[null,"ASEGURADO 04"]
[]
[null,"IMPORTANTE",null,"Si la operación incluye modificar al contratante por favor generar solicitud como CAMBIO DE CONTRATANTE."]
[null,null,null,"Tener en cuenta que de excluir al titular se colocará como nuevo titular al siguiente afiliado de mayor edad."]
[null,null,null,"El cliente deberá pagar por todo el tiempo coberturado hasta la fecha solicitante."]
[]
[null,"OBSERVACIONES ADICIONALES"]
[]
[]
[]
[null,"LIBERACIÓN DE PRIMA"]
[null,"Tiempo de atención - 5 días"]
[]
[null,"OBLIGATORIO",null,"Acta de fallecimiento de titular / Certificado de defunción de titular."]
[]
[null,"IMPORTANTE",null,"El cliente deberá pagar por todo el tiempo coberturado hasta la fecha de fallecimiento de titular."]
[null,null,null,"En caso de que titular y contratante sea la misma persona debe ingresar a continuación los datos del nuevo contratante de forma obligatoria."]
[]
[null,"Datos del nuevo contratante"]
[null,"Nombres y apellidos / Razon social",null,null,null,"Tipo de Dcto",null,"Nro. de Dcto",null,"Correo electrónico",null,"Teléfono",null,"Dirección"]
[null,null,null,null,"Seleccione","Seleccione"]
[]
[null,"OBSERVACIONES ADICIONALES"]
[]
[]
[]
[null,"REHABILITACIÓN"]
[null,"Tiempo de atención - 3 días"]
[]
[null,"OBLIGATORIO",null,"Debe adjuntar VB del ejecutivo de servicio en caso hayan pasado más de 30 días de la anulación realizada por el cliente."]
[]
[null,"IMPORTANTE",null,"En caso póliza haya sido anulada por morosidad debe solicitar la rehabilitación con el área de cobranzas al correo: requerimientoscobranzas@rimac.com.pe"]
[]
[null,"OBSERVACIONES ADICIONALES"]
[]
[]
[]
[null,"DESCUENTO AMI"]
[null,"Tiempo de atención - 3 días"]
[]
[null,"Motivo de Descuento :",null,"Seleccione"]
[]
[null,"OBLIGATORIO",null,"En caso de CORREDORES y de no ser un descuento por campaña se debe adjuntar VB de ejecutivo comercial a cargo."]
[]
[null,"IMPORTANTE",null,"Para descuento contra comisión debe adjuntar VB de gerente corredor."]
[]
[null,"OBSERVACIONES ADICIONALES"]
[]
[]
[]
[null,"CAMBIO DE PLAN en el mismo producto"]
[null,"Tiempo de atención - 5 días"]
[]
[null,"Producto :",null,null,null,null,null,null,null,null,"Nuevo plan :    ","Seleccione plan para Salud Flexible"]
[]
[null,"OBLIGATORIO",null,"Si cambia a un plan con mayor cobertura debe enviar DPS actualizada."]
[null,null,null,"Obligatorio indicar código de plan para Salud Flexible - "]
[]
[null,"IMPORTANTE",null,"Esta operación cambia del plan dentro del mismo producto. Si desea cambiar de producto por favor genere la solicitud como MIGRACIÓN."]
[]
[null,"OBSERVACIONES ADICIONALES"]
[]
[]
[]
[null,"RENOVACIÓN AMI"]
[null,"Tiempo de atención - 3 días"]
[]
[null,"IMPORTANTE",null,"Póliza no renovará si tiene cuotas vencidas o si el corredor se encuentra bloqueado/suspendido en SBS."]
[]
[null,"OBSERVACIONES ADICIONALES"]
[]
[]
[]
[null,"OTROS ENDOSOS"]
[null,"Tiempo de atención - 5 días"]
[]
[null,"Tipo de Endoso :",null,"Seleccione"]
[]
[null,null,null,"Nombres y apellidos",null,null,null,"Tipo Dcto","Nro. de Dcto",null,"Correo Electrónico",null,null,"Dirección"]
[null,"ASEGURADO 01"]
[null,"ASEGURADO 02"]
[null,"ASEGURADO 03"]
[null,"ASEGURADO 04"]
[]
[null,"OBLIGATORIO",null,"En caso de extensión de vigencia por estudios en el extranjero se debe enviar el formato correspondiente y constancia de matrícula/estudios."]
[]
[null,"OBSERVACIONES ADICIONALES"]
[]
[]
[]
[null,"REVISIÓN DE CONTINUIDAD Y EVALUACIÓN DE PREEXISTENCIAS"]
[null,"Tiempo de atención - 5 días"]
[]
[null,"Tipo de Endoso :",null,"Seleccione"]
[]
[null,null,null,"Nombres y apellidos",null,null,null,"Tipo Dcto","Nro. de Dcto",null,"Correo Electrónico",null,null,"Dirección"]
[null,"ASEGURADO 01"]
[null,"ASEGURADO 02"]
[null,"ASEGURADO 03"]
[null,"ASEGURADO 04"]
[]
[null,"IMPORTANTE",null,"Para continuidad si viene de seguro anterior EPS o AMC se debe adjuntar CONSTANCIA DE SEGURO + PLAN DE BENEFICIOS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B208&\" / \"&V204&\" / Póliza : \"&C204&\" - \"&J204&\" / Corredor: \"&C202","v":" /  / Póliza :  -  / Corredor: "}]
[null,null,null,"Para continuidad si viene de seguro anterior EPS o AMC se debe adjuntar CONSTANCIA DE SEGURO + PLAN DE BENEFICIOS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+U255","v":0}]
[null,null,null,"Para continuidad la póliza anterior no debe tener vigencia menor a 1 año y la fecha entre el fin de dicha póliza y el inicio de la nueva vigencia no sea mayor a 30 días."]
[null,null,null,"Para la evaluación de preexistencias es necesario adjuntar el sustento del diagnóstico a evaluar.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U256","v":0}]
[]
[null,"OBSERVACIONES ADICIONALES"]

{"sheet":"Información","index":2,"n_rows":28,"n_cols":14,"rows_kept":28,"cut":false,"hidden":false,"merged":[[12,3,12,5],[17,3,17,5],[10,10,10,12],[10,13,10,15],[26,3,26,5],[19,3,19,5],[10,3,10,5],[11,3,11,5],[18,3,18,5],[11,10,11,12],[11,13,11,15],[13,3,13,5],[14,3,14,5],[15,3,15,5],[16,3,16,5],[27,3,27,5],[20,3,20,5],[21,3,21,5],[22,3,22,5],[23,3,23,5],[24,3,24,5],[25,3,25,5],[8,3,8,5],[8,10,8,12],[8,13,8,15],[9,3,9,5],[9,10,9,12],[9,13,9,15],[1,1,1,16],[3,2,3,5],[3,7,3,8],[3,10,3,15],[5,3,5,5],[5,10,5,12],[5,13,5,15],[6,3,6,5],[6,10,6,12],[6,13,6,15],[7,3,7,5],[7,10,7,12],[7,13,7,15]]}
[]
[null,"Información Importante"]
[]
[null,null,"Lista de productos",null,null,null,null,"Tiempo de atención",null,null,"Contactos importantes"]
[]
[null,null,"CÓDIGO","PRODUCTO",null,null,null,"OPERACIÓN","DÍAS",null,"CONTACTOS",null,null,"CORREO"]
[null,null,4004,"AMI SALUD RED MÉDICA",null,null,null,"Anulación",10,null,"Consultas cobranzas",null,null,"requerimientoscobranzas@rimac.com.pe"]
[null,null,4011,"AMI FULL SALUD",null,null,null,"Migración",10,null,"Constancias / Siniestralidades",null,null,"atencioncorredor@rimac.com.pe"]
[null,null,4012,"AMI SALUD PREFERENCIAL",null,null,null,"Cambio de Contratante",10,null,"Consultas sobre reembolsos",null,null,"consultasreembolsos@rimac.com.pe"]
[null,null,4016,"AMI SALUD RED MÉDICA HOSPITALARIA",null,null,null,"Liberación de Prima",10,null,"Portal corredores AMI",null,null,"david.zuniga@rimac.com.pe"]
[null,null,4038,"AMI SALUD RED PREFERENTE",null,null,null,"Cambio de Plan",10,null,"Soporte TI",null,null,"atencionvirtual@rimac.com.pe"]
[null,null,4095,"AMI SALUD RED PRIVADA",null,null,null,"Otros endosos",10,null,"Actualización de datos",null,null,"verificaciondedatos@rimac.com.pe"]
[null,null,4134,"SALUD FLEXIBLE",null,null,null,"Cambio de Agenciamiento",7]
[null,null,"4007 A","AMI SALUD DE ORO A COMPLETO ",null,null,null,"Inclusión",7]
[null,null,"4007 B","AMI SALUD DE ORO B RED MEDICA/RED",null,null,null,"Exclusión",7]
[null,null,"4007 C","AMI SALUD DE ORO C RED PREFERENTE",null,null,null,"Rehabilitación",7]
[null,null,4049,"AMI SALUD PREFERENCIAL FFVV",null,null,null,"Descuento AMI",7]
[null,null,4050,"AMI SALUD RED MÉDICA FFVV",null,null,null,"Renovación AMI",7]
[null,null,4051,"AMI SALUD RED MED HOSP FFVV"]
[null,null,4052,"AMI FULL SALUD FFVV"]
[null,null,4054,"AMI SALUD RED PREFERENTE FFVV"]
[null,null,4093,"AMI SALUD RED PRIVADA FFVV"]
[null,null,"4053 A","AMI SALUD DE ORO FFVV A "]
[null,null,"4053 B","AMI SALUD DE ORO FFVV B "]
[null,null,"4053 C","AMI SALUD DE ORO FFVV C "]
[null,null,4076,"ONCOLOGICA CORREDORES"]
[null,null,4091,"ONCO. INTEGRAL INDIVIDUAL FFVV"]
[null,null,4020,"CORPORATIVA REHDER"]

{"sheet":"Salud Flexible","index":3,"n_rows":77,"n_cols":9,"rows_kept":77,"cut":false,"hidden":false,"merged":[[1,1,1,13]]}
[]
[null,"Código planes - Salud Flexible"]
[]
[]
[null,null,null,"COMBINACIONES","CÓDIGO PLAN",null,null,"LEYENDA","COBERTURA"]
[null,null,null,"B1",207928,null,null,"B1","Seguro en casa"]
[null,null,null,"B2",208028,null,null,"B2","Seguro en casa y clínica"]
[null,null,null,"B1-A1",207929,null,null,"A1","Chequeo preventivo y vacunas"]
[null,null,null,"B1-A4",207930,null,null,"A2","Centros de Odontología y oftalmología"]
[null,null,null,"B2-A1",207978,null,null,"A3","Hospitalización y maternidad"]
[null,null,null,"B2-A2",207979,null,null,"A4","Sepelio y exoneración de pago"]
[null,null,null,"B2-A4",207981,null,null,"A5","Emergencias y ambulancias"]
[null,null,null,"B2-A5",207982,null,null,"A6","Indemnización por cáncer"]
[null,null,null,"B2-A3",216817]
[null,null,null,"B1-A6",216805]
[null,null,null,"B2-A6",216804]
[null,null,null,"B1-A1.A4",207931]
[null,null,null,"B2-A1.A2",209278]
[null,null,null,"B2-A1.A3",216812]
[null,null,null,"B2-A1.A4",209280]
[null,null,null,"B2-A1.A5",209281]
[null,null,null,"B2-A2.A3",216813]
[null,null,null,"B2-A2.A4",209283]
[null,null,null,"B2-A2.A5",209284]
[null,null,null,"B2-A3.A4",216814]
[null,null,null,"B2-A3.A5",216815]
[null,null,null,"B2-A4.A5",209287]
[null,null,null,"B1-A1.A6",216818]
[null,null,null,"B1-A4.A6",216806]
[null,null,null,"B2-A1.A6",216807]
[null,null,null,"B2-A2.A6",216811]
[null,null,null,"B2-A3.A6",216816]
[null,null,null,"B2-A4.A6",216808]
[null,null,null,"B2-A5.A6",216810]
[null,null,null,"B2-A1.A2.A3",216830]
[null,null,null,"B2-A1.A2.A4",209289]
[null,null,null,"B2-A1.A2.A5",209290]
[null,null,null,"B2-A1.A3.A4",216831]
[null,null,null,"B2-A1.A3.A5",216832]
[null,null,null,"B2-A1.A4.A5",209293]
[null,null,null,"B2-A2.A3.A4",216833]
[null,null,null,"B2-A2.A3.A5",216834]
[null,null,null,"B2-A2.A4.A5",209296]
[null,null,null,"B2-A3.A4.A5",216835]
[null,null,null,"B1-A1.A4.A6",216819]
[null,null,null,"B2-A1.A2.A6",216820]
[null,null,null,"B2-A1.A3.A6",216821]
[null,null,null,"B2-A1.A4.A6",216822]
[null,null,null,"B2-A1.A5.A6",216823]
[null,null,null,"B2-A2.A3.A6",216824]
[null,null,null,"B2-A2.A4.A6",216825]
[null,null,null,"B2-A2.A5.A6",216826]
[null,null,null,"B2-A3.A4.A6",216827]
[null,null,null,"B2-A3.A5.A6",216828]
[null,null,null,"B2-A4.A5.A6",216829]
[null,null,null,"B2-A1.A2.A3.A4",216846]
[null,null,null,"B2-A1.A2.A3.A5",216847]
[null,null,null,"B2-A1.A2.A4.A5",209300]
[null,null,null,"B2-A1.A3.A4.A5",216848]
[null,null,null,"B2-A2.A3.A4.A5",216849]
[null,null,null,"B2-A1.A2.A3.A6",216836]
[null,null,null,"B2-A1.A2.A4.A6",216837]
[null,null,null,"B2-A1.A2.A5.A6",216838]
[null,null,null,"B2-A1.A3.A4.A6",216839]
[null,null,null,"B2-A1.A3.A5.A6",216840]
[null,null,null,"B2-A1.A4.A5.A6",216841]
[null,null,null,"B2-A2.A3.A4.A6",216842]
[null,null,null,"B2-A2.A3.A5.A6",216843]
[null,null,null,"B2-A2.A4.A5.A6",216844]
[null,null,null,"B2-A3.A4.A5.A6",216845]
[null,null,null,"B2-A1.A2.A3.A4.A5",216856]
[null,null,null,"B2-A1.A2.A3.A4.A6",216855]
[null,null,null,"B2-A1.A2.A3.A5.A6",216854]
[null,null,null,"B2-A1.A2.A4.A5.A6",216853]
[null,null,null,"B2-A1.A3.A4.A5.A6",216852]
[null,null,null,"B2-A2.A3.A4.A5.A6",216851]
[null,null,null,"B2-A1.A2.A3.A4.A5.A6",216850]

{"sheet":"reglas","index":4,"n_rows":283,"n_cols":14,"rows_kept":283,"cut":false,"hidden":false,"merged":[]}
["Producto"]
[]
[null,"Seleccione"," ",null,"Seleccione",null,"Seleccione","Seleccione","Seleccione"]
[1,"Multirriesgo",1301,null,"D.N.I.",null,"Modular","Modular","Modular"]
[2,"3D",1505,null,"R.U.C.",null,"Corporativa","Corporativa","Corporativa"]
[{"$f":"+A5+1","v":3},"Deshonestidad",1501,null,"C.E.",null,"Colectiva",{"$f":"IF(#REF!=\"Nueva póliza\",\"\",\"Colectiva\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Póliza Nueva\",\"\",\"Colectiva\")","v":{"$error":"#REF!"}}]
[{"$f":"+A6+1","v":4},"Robo",1101,null,"PASAPORTE"]
[5,"Responsabilidad Civil",1201]
[6,"Domiciliario",1402,null,"Seleccione",null,"Seleccione"]
[7,"Seguro Bancario",1601,null,"Desde inicio de vigencia",null,"Si"]
[8,"Transportes Anual",3003,null,"Otros :",null,"No"]
[9,"Transportes Flotante",3001]
[10,"Transporte Individual",3002,null,"Seleccione"]
[11,"Transporte Individual",3002,null,"Cambio de Compañía",null,"Seleccione"]
[12,"TREC",3301,null,"No puede pagar la póliza",null,"Exclusión"]
[13,"CAR - Construcción",3311,null,"No desea póliza",null,"Inclusión"]
[14,"EAR - Montaje",3321,null,"Otro( Especifique) :",null,"Modificación"]
[15,"Equip. Electrónico",3341,null,null,null,null,null,null,null,null,897,null,{"$f":"L18/8","v":112.125}]
[16,"Rotura de Maquinaria",3331,null,"Seleccione",null,"Seleccione"]
[17,"OCT -Obras Civiles Terminadas",3351,null,"Asegurado",null,"Anulación"]
[18,"Negocio Seguro",1338,null,"Responsable de Pago",null,"Exclusión"]
[null,null,null,null,"Contratante"]
[]
[null,null,null,null,"Seleccione",null,"Seleccione"]
[null,"Seleccione",null,null,"Cláusula",null,"Póliza"]
[null,"Incluir",null,null,"Cobertura",null,"Certificado"]
[null,"Excluir",null,null,"Deducible"]
[null,"Modificar",null,null,"Condición especial (Especifíque)"]
[null,null,null,null,"Varios (especificar en observación)",null,"Seleccione"]
[null,null,null,null,null,null,"Nueva póliza"]
[null,null,null,null,null,null,"Inclusión"]
[null,null,"Seleccione"," ","  "]
[null,null,"Daño Propio",2101,"2101 -",null,"Seleccione"]
[null,"nueva poliza","Brevete",2010,"2010 -",null,"Póliza Nueva"]
[null,"inclusion ","Responsabilidad Civil - TPU",2016,"2016 -",null,"Inclusión"]
[null,"exclusion","Traslados",2014,"2014 -",null,"Nueva póliza TPU - TPI"]
[null,null,"Exhibición de Placas",2015,"2015 -",null,"Inclusión TPU - TPI"]
[null,null,null,null,null,null,"Renovación TPI/TPU"]
[]
[null,null,"Seleccione"," "]
[null,null,"Daño Propio",2101]
[null,null,"Responsabilidad Civil - TPU",2016]
[]
[]
[]
[]
[null,null,"Seleccione"," "]
[null,null,"Atención","Mal servicio de Rimac, proveedores o experiencia"]
[null,null,"Motivo económico","Problemas económicos o cese laboral"]
[null,null,"Precio","No está de acuerdo con el precio."]
[null,null,"Producto","No le satisface el producto o los beneficios"]
[null,null,"Tiene Eps","Anula porque tiene EPS con otra compañía o con Rimac"]
[null,null,"Venta","Insatisfacción en el proceso de la venta, no reconoce la compra"]
[null,null,"Venta del bien asegurado","Venderá o está en proceso de vender el bien"]
[null,null,"Seguro con nuevas condiciones","Anula porque emitirá nueva póliza con otras condiciones"]
[null,null,"Otros","No brinda detalle, entre otros"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Seleccione"]
[null,"Físico"]
[null,"Digital -Correo electrónico"]
[null,"Número de especie valorada"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Seleccione"," ",null,"Seleccione"]
[null,null,"Baja o rechazo de la unidad ante el MTC o ATU","solo aplica para exclusión",null,"Digital"]
[null,null,"Venta de la unidad","solo aplica para exclusión",null,"Físico"]
[null,null," Unidad inoperativa (pérdida total)","solo aplica para exclusión"]
[null,null,"Cambio de Uso","solo aplica para exclusión",null,"Seleccione"]
[null,null,"Otros","solo aplica para exclusión",null,"Nueva póliza individual"]
[null,null,null,null,null,"Inclusión Individual"]
[null,null,null,null,null,"Nueva póliza TPU - TPI"]
[null,null,null,null,null,"Inclusión TPU - TPI"]
[null,null,null,null,null,"Renovación TPI/TPU"]
[]
[]
[]
[null,null,null,null,null,"Seleccione"]
[null,null,null,null,null,"Contado"]
[null,null,null,null,null,"Cupones"]
[]
[]
[null,null,null,null,null,"Seleccione"]
[null,null,null,null,null,"Con devolución"]
[null,null,null,null,null,"Sin devolución"]
[]
[]
[]
[]
[null,null,null,null,null,"Seleccione","Seleccione"]
[null,null,null,null,null,4012," SALUD PREFERENCIAL",4012]
[null,null,null,null,null,4011," FULL SALUD",4011]
[null,null,null,null,null,4004," SALUD RED MÉDICA",4004]
[null,null,null,null,null,4038," SALUD RED PREFERENTE",4038]
[null,null,null,null,null,4007," SALUD DE ORO A ",4007]
[null,null,null,null,null,4007," SALUD DE ORO B ",4007]
[null,null,null,null,null,4007," SALUD DE ORO C ",4007]
[null,null,null,null,null,4016," SALUD RED MED HOSP",4016]
[null,null,null,null,null,4095," SALUD RED PRIVADA",4095]
[null,null,null,null,null,4049," SALUD PREFERENCIAL FFVV",4049]
[null,null,null,null,null,4052," FULL SALUD FFVV",4052]
[null,null,null,null,null,4050," SALUD RED MÉDICA FFVV",4050]
[null,null,null,null,null,4054," SALUD RED PREFERENTE FFVV",4054]
[null,null,null,null,null,4053," SALUD DE ORO FFVV A ",4053]
[null,null,null,null,null,4053," SALUD DE ORO FFVV B ",4053]
[null,null,null,null,null,4053," SALUD DE ORO FFVV C ",4053]
[null,null,null,null,null,4051," SALUD RED MED HOSP FFVV",4051]
[null,null,null,null,null,4093," SALUD RED PRIVADA FFVV",4093]
[null,null,null,null,null,4134," SALUD FLEXIBLE",4134]
[null,null,null,null,null,4104," SALUD RED MEDICA PLAN FAMILIA ",4104]
[]
[]
[]
[null,null,null,null,null,"Seleccione","Seleccione"]
[null,null,null,null,null,1,"RETIRO DE LA EMPRESA"]
[null,null,null,null,null,2,"RETIRO POR LÍMITE DE EDAD"]
[null,null,null,null,null,3,"DECESO"]
[null,null,null,null,null,4,"COSTO DE PLAN"]
[null,null,null,null,null,5,"INSTATISFACCIÓN DEL SERVICIO RIMAC"]
[null,null,null,null,null,6,"INSTATISFACCIÓN DEL SERVICIO PROVEEDOR"]
[null,null,null,null,null,7,"AFILIACIÓN A OTRO SEGURO"]
[null,null,null,null,null,8,"OTROS"]
[null,null,null,null,null,9,"FALTA DE PAGO"]
[null,null,null,null,null,10,"EMPRESA SE RETIRA A OTRA EPS"]
[null,null,null,null,null,11,"FIN DE LATENCIA"]
[null,null,null,null,null,12,"TRASLAPE DE VIGENCIA"]
[]
[null,null,null,null,null,"Seleccione","Seleccione"]
[null,null,null,null,null,1,"DESCUENTO GYR"]
[null,null,null,null,null,2,"DESCUENTO POR GRUPO"]
[null,null,null,null,null,3,"DESCUENTO CONTRA COMISIÓN"]
[null,null,null,null,null,4,"DESCUENTO POR CAMPAÑA"]
[null,null,null,null,null,5,"OTROS MOTIVOS"]
[null,null,null,null,null,"Seleccione"]
[null,null,null,null,null,"4012 - AMI SALUD PREFERENCIAL"]
[null,null,null,null,null,"4011 - AMI FULL SALUD"]
[null,null,null,null,null,"4004 - AMI SALUD RED MÉDICA"]
[null,null,null,null,null,"4038 - AMI SALUD RED PREFERENTE"]
[null,null,null,null,null,"4007 - AMI SALUD DE ORO A - COMPLETO"]
[null,null,null,null,null,"4007 - AMI SALUD DE ORO B - RED / RED MÉDICA"]
[null,null,null,null,null,"4007 - AMI SALUD DE ORO C - RED PREFERENTE"]
[null,null,null,null,null,"4016 - AMI SALUD RED MED HOSP"]
[null,null,null,null,null,"4095 - AMI SALUD RED PRIVADA"]
[null,null,null,null,null,"4134 - AMI SALUD FLEXIBLE"]
[null,null,null,null,null,"4049 - AMI SALUD PREFERENCIAL FFVV"]
[null,null,null,null,null,"4052 - AMI FULL SALUD FFVV"]
[null,null,null,null,null,"4050 - AMI SALUD RED MÉDICA FFVV"]
[null,null,null,null,null,"4054 - AMI SALUD RED PREFERENTE FFVV"]
[null,null,null,null,null,"4053 A - AMI SALUD DE ORO A FFVV / COMPLETA"]
[null,null,null,null,null,"4053 B - AMI SALUD DE ORO A FFVV / RED MÉDICA"]
[null,null,null,null,null,"4053 C - AMI SALUD DE ORO A FFVV / RED PREFERENTE"]
[null,null,null,null,null,"4051 - SALUD RED MED HOSP FFVV"]
[null,null,null,null,null,"4091 - ONCO. INTEGRAL INDIVIDUAL FFVV"]
[null,null,null,null,null,"4076 - ONCOLÓGICA CORREDORES"]
[]
[null,null,null,null,null,"Seleccione",null,null,null,"Seleccione"]
[null,null,null,null,null,"ACTUALIZACIÓN DE DATOS",null,null,null,"REVISIÓN DE CONTINUIDAD"]
[null,null,null,null,null,"AMPLIACIÓN POR ESTUDIOS EN EL EXTRANJERO",null,null,null,"EVALUACIÓN DE PREEXISTENCIAS"]
[null,null,null,null,null,"OTROS"]
[]
[]
[null,null,null,null,null,"Seleccione","Seleccione"]
[null,null,null,null,null,4004,"AMI SALUD RED MÉDICA"]
[null,null,null,null,null,4011,"AMI FULL SALUD"]
[null,null,null,null,null,4012,"AMI SALUD PREFERENCIAL"]
[null,null,null,null,null,4016,"AMI SALUD RED MÉDICA HOSPITALARIA"]
[null,null,null,null,null,4038,"AMI SALUD RED PREFERENTE"]
[null,null,null,null,null,4095,"AMI SALUD RED PRIVADA"]
[null,null,null,null,null,4134,"SALUD FLEXIBLE"]
[null,null,null,null,null,"4007 A","AMI SALUD DE ORO A COMPLETO "]
[null,null,null,null,null,"4007 B","AMI SALUD DE ORO B RED MEDICA/RED"]
[null,null,null,null,null,"4007 C","AMI SALUD DE ORO C RED PREFERENTE"]
[null,null,null,null,null,4049,"AMI SALUD PREFERENCIAL FFVV"]
[null,null,null,null,null,4050,"AMI SALUD RED MÉDICA FFVV"]
[null,null,null,null,null,4051,"AMI SALUD RED MED HOSP FFVV"]
[null,null,null,null,null,4052,"AMI FULL SALUD FFVV"]
[null,null,null,null,null,4054,"AMI SALUD RED PREFERENTE FFVV"]
[null,null,null,null,null,4093,"AMI SALUD RED PRIVADA FFVV"]
[null,null,null,null,null,"4053 A","AMI SALUD DE ORO FFVV A "]
[null,null,null,null,null,"4053 B","AMI SALUD DE ORO FFVV B "]
[null,null,null,null,null,"4053 C","AMI SALUD DE ORO FFVV C "]
[null,null,null,null,null,4076,"ONCOLOGICA CORREDORES"]
[null,null,null,null,null,4091,"ONCO. INTEGRAL INDIVIDUAL FFVV"]
[null,null,null,null,null,4020,"CORPORATIVA REHDER"]
[null,null,null,null,null,4017,"AMI ONCOLOGICO SCOTIABANK"]
[null,null,null,null,null,4018,"ONCOLOGICA RIMAC"]
[null,null,null,null,null,4126,"IEG 12"]
[null,null,null,null,null,7003,"RENTA HOSPITALARIA POR TELEMARKETING"]
[null,null,null,null,null,9106,"ACC. NYJ"]
[null,null,null,null,null,9109,"ACCIDENTES INDIVIDUALES"]
[null,null,null,null,null,4008,"SUPRA"]
[null,null,null,null,null,4028,"CORPORATIVAS"]
[null,null,null,null,null,4063,"CORPORATIVAS SEGUNDA CAPA"]
[null,null,null,null,null,4079,"SINDROME DOWN"]
[null,null,null,null,null,4081,"SINDROME DE DOWN - FFVV"]
[null,null,null,null,null,4039,"INDEMNIZATORIO ENF GRAVES"]
[null,null,null,null,null,4104,"SALUD RED MEDICA PLAN FAMILIA "]
[]
[]
[null,null,null,null,null,"Seleccione plan para Salud Flexible"]
[null,null,null,null,null,207928]
[null,null,null,null,null,208028]
[null,null,null,null,null,207929]
[null,null,null,null,null,207930]
[null,null,null,null,null,207978]
[null,null,null,null,null,207979]
[null,null,null,null,null,207981]
[null,null,null,null,null,207982]
[null,null,null,null,null,216817]
[null,null,null,null,null,216805]
[null,null,null,null,null,216804]
[null,null,null,null,null,207931]
[null,null,null,null,null,209278]
[null,null,null,null,null,216812]
[null,null,null,null,null,209280]
[null,null,null,null,null,209281]
[null,null,null,null,null,216813]
[null,null,null,null,null,209283]
[null,null,null,null,null,209284]
[null,null,null,null,null,216814]
[null,null,null,null,null,216815]
[null,null,null,null,null,209287]
[null,null,null,null,null,216818]
[null,null,null,null,null,216806]
[null,null,null,null,null,216807]
[null,null,null,null,null,216811]
[null,null,null,null,null,216816]
[null,null,null,null,null,216808]
[null,null,null,null,null,216810]
[null,null,null,null,null,216830]
[null,null,null,null,null,209289]
[null,null,null,null,null,209290]
[null,null,null,null,null,216831]
[null,null,null,null,null,216832]
[null,null,null,null,null,209293]
[null,null,null,null,null,216833]
[null,null,null,null,null,216834]
[null,null,null,null,null,209296]
[null,null,null,null,null,216835]
[null,null,null,null,null,216819]
[null,null,null,null,null,216820]
[null,null,null,null,null,216821]
[null,null,null,null,null,216822]
[null,null,null,null,null,216823]
[null,null,null,null,null,216824]
[null,null,null,null,null,216825]
[null,null,null,null,null,216826]
[null,null,null,null,null,216827]
[null,null,null,null,null,216828]
[null,null,null,null,null,216829]
[null,null,null,null,null,216846]
[null,null,null,null,null,216847]
[null,null,null,null,null,209300]
[null,null,null,null,null,216848]
[null,null,null,null,null,216849]
[null,null,null,null,null,216836]
[null,null,null,null,null,216837]
[null,null,null,null,null,216838]
[null,null,null,null,null,216839]
[null,null,null,null,null,216840]
[null,null,null,null,null,216841]
[null,null,null,null,null,216842]
[null,null,null,null,null,216843]
[null,null,null,null,null,216844]
[null,null,null,null,null,216845]
[null,null,null,null,null,216856]
[null,null,null,null,null,216855]
[null,null,null,null,null,216854]
[null,null,null,null,null,216853]
[null,null,null,null,null,216852]
[null,null,null,null,null,216851]
[null,null,null,null,null,216850]