|
codigo
|
char(5)
|
|
|
|
|
nombre
|
char(50)
|
|
|
|
|
codcon
|
char(20)
|
|
|
|
|
cedula
|
char(15)
|
|
|
|
|
apel_pater
|
char(15)
|
|
|
|
|
apel_mater
|
char(15)
|
|
|
|
|
nombres
|
char(20)
|
|
|
|
|
razon
|
char(50)
|
|
|
|
|
ruc
|
char(15)
|
|
|
|
|
sexo
|
bit(1)
|
|
|
0
|
|
estado
|
char(10)
|
|
|
|
|
empresa
|
char(35)
|
|
|
|
|
pais
|
char(10)
|
|
|
|
|
ocupacion
|
char(15)
|
|
|
|
|
conyuge
|
char(36)
|
|
|
|
|
cedula_con
|
char(15)
|
|
|
|
|
ciudad
|
char(20)
|
|
|
|
|
zona
|
char(5)
|
|
|
|
|
direcc
|
char(36)
|
|
|
|
|
direcc2
|
char(36)
|
|
|
|
|
telefono
|
char(20)
|
|
|
|
|
fax
|
char(10)
|
|
|
|
|
observ
|
char(60)
|
|
|
|
|
observ2
|
char(60)
|
|
|
|
|
limite
|
double(8,5)
|
|
|
0.00000
|
|
plazo
|
double(8,5)
|
|
|
0.00000
|
|
forma_pago
|
char(12)
|
|
|
|
|
saldo
|
double(8,5)
|
|
|
0.00000
|
|
activo
|
bit(1)
|
|
|
0
|
|
chepro
|
double(8,5)
|
|
|
0.00000
|
|
tipo
|
char(1)
|
|
|
|
|
cargo
|
char(15)
|
|
|
|
|
direcc_emp
|
char(35)
|
|
|
|
|
telefo_emp
|
char(10)
|
|
|
|
|
fecha_insc
|
date
|
|
|
|
|
tarifa
|
double(8,5)
|
|
|
0.00000
|
|
afiliado
|
bit(1)
|
|
|
0
|
|
tarjeta
|
char(10)
|
|
|
|
|
integrado
|
bit(1)
|
|
|
0
|
|
enviado
|
bit(1)
|
|
|
0
|
|
gafsa
|
bit(1)
|
|
|
0
|
|
notinfpro
|
double(8,5)
|
|
|
0.00000
|
|
clinica
|
bit(1)
|
|
|
0
|
|
pordesadi
|
double(8,5)
|
|
|
0.00000
|
|
fecha_ingr
|
date
|
|
|
|
|
circuito
|
double(8,5)
|
|
|
0.00000
|
|
cupo
|
double(8,5)
|
|
|
0.00000
|
|
casa
|
date
|
|
|
|
|
transporte
|
bit(1)
|
|
|
0
|
|
genero
|
char(1)
|
|
|
|
|
fecha_naci
|
date
|
|
|
|
|
nombre_par
|
char(36)
|
|
|
|
|
pariente
|
char(15)
|
|
|
|
|
direcc_par
|
char(36)
|
|
|
|
|
telefo_par
|
char(15)
|
|
|
|
|
iess
|
char(15)
|
|
|
|
|
consultas
|
double(8,5)
|
|
|
0.00000
|
|
emplidjef
|
char(10)
|
|
|
|
|
jefe
|
char(5)
|
|
|
|
|
lide
|
char(5)
|
|
|
|
|
refe
|
char(5)
|
|
|
|
|
des_lide
|
double(8,5)
|
|
|
0.00000
|
|
des_jefe
|
double(8,5)
|
|
|
0.00000
|
|
des_refe
|
double(8,5)
|
|
|
0.00000
|
|
celular
|
char(9)
|
|
|
|
|
email
|
char(245)
|
|
|
|
|
contacto
|
char(36)
|
|
|
|
|
plazo_real
|
double(8,5)
|
|
|
0.00000
|
|
direcc3
|
char(50)
|
|
|
|
|
direcc4
|
char(50)
|
|
|
|
|
direcc5
|
char(50)
|
|
|
|
|
matricula
|
double(8,5)
|
|
|
0.00000
|
|
fecha_nac
|
date
|
|
|
|
|
transp
|
bit(1)
|
|
|
0
|
|
lejano
|
bit(1)
|
|
|
0
|
|
con_vive
|
char(36)
|
|
|
|
|
pad_viajan
|
bit(1)
|
|
|
0
|
|
env_sino
|
bit(1)
|
|
|
0
|
|
opera
|
char(5)
|
|
|
|
|
digitado
|
date
|
|
|
|
|
lugar_nac
|
char(15)
|
|
|
|
|
barrio
|
char(15)
|
|
|
|
|
religion
|
char(15)
|
|
|
|
|
par_vive
|
char(10)
|
|
|
|
|
per_financ
|
char(36)
|
|
|
|
|
cua_tiempo
|
double(8,5)
|
|
|
0.00000
|
|
cuanto
|
double(8,5)
|
|
|
0.00000
|
|
siglas
|
char(15)
|
|
|
|
|
vendedor
|
char(5)
|
|
|
|
|
mens_pen_c
|
char(15)
|
|
|
|
|
mens_tra_c
|
char(15)
|
|
|
|
|
mens_ali_c
|
char(15)
|
|
|
|
|
mens_var_c
|
char(15)
|
|
|
|
|
mens_pen_p
|
double(8,5)
|
|
|
0.00000
|
|
mens_tra_p
|
double(8,5)
|
|
|
0.00000
|
|
mens_ali_p
|
double(8,5)
|
|
|
0.00000
|
|
mens_var_p
|
double(8,5)
|
|
|
0.00000
|
|
mens_pen_d
|
double(8,5)
|
|
|
0.00000
|
|
mens_tra_d
|
double(8,5)
|
|
|
0.00000
|
|
mens_ali_d
|
double(8,5)
|
|
|
0.00000
|
|
mens_var_d
|
double(8,5)
|
|
|
0.00000
|
|
tarc_num
|
double(8,5)
|
|
|
0.00000
|
|
tarc_fec
|
char(6)
|
|
|
|
|
tarc_emi
|
char(15)
|
|
|
|
|
tarc_cod
|
double(8,5)
|
|
|
0.00000
|
|
cecorcli
|
char(60)
|
|
|
|
|
pag1cod
|
char(13)
|
|
|
|
|
pag1por
|
double(8,5)
|
|
|
0.00000
|
|
pag2cod
|
char(13)
|
|
|
|
|
pag2por
|
double(8,5)
|
|
|
0.00000
|
|
ret1_ced
|
char(10)
|
|
|
|
|
ret1_nom
|
char(45)
|
|
|
|
|
ret2_ced
|
char(10)
|
|
|
|
|
ret2_nom
|
char(45)
|
|
|
|
|
ret3_ced
|
char(10)
|
|
|
|
|
ret3_nom
|
char(45)
|
|
|
|
|
ret4_ced
|
char(10)
|
|
|
|
|
ret4_nom
|
char(45)
|
|
|
|
|
ret5_ced
|
char(10)
|
|
|
|
|
ret5_nom
|
char(45)
|
|
|
|