Base RCO / Objetos / ENEL CE / bi_brce_cus
20 objetos nesta página. Conteúdo gerado diretamente do catálogo estruturado e do arquivo RAG do pacote oficial.
bi_brce_cus.bt_brce_siase_archive_202410_v3bi_brce_cus.bt_brce_siase_archive_202411_v3bi_brce_cus.bt_brce_siase_archive_202412_v3bi_brce_cus.bt_brce_tbl_dq_kpi_qualidade_histbi_brce_cus.bt_brce_vm_mega_basebi_brce_cus.bt_global_gbs_inspection_wo_brasil_cearabi_brce_cus.bt_brce_accountbi_brce_cus.bt_brce_act_servico_gomnet_tempos_medios_cearabi_brce_cus.bt_brce_act_servico_gomnet_universalizacao_cearabi_brce_cus.bt_brce_auditoria_agingbi_brce_cus.bt_brce_clientes_breakdownbi_brce_cus.bt_brce_clientes_vitais_essenciaisbi_brce_cus.bt_brce_conta_contratobi_brce_cus.bt_brce_debts__cbi_brce_cus.bt_brce_dim_cr_clientebi_brce_cus.bt_brce_dna_dividabi_brce_cus.bt_brce_dna_geralbi_brce_cus.bt_brce_fatura_ede_coletivabi_brce_cus.bt_brce_ordem_cluster_preditbi_brce_cus.bt_brce_ren1000
bi_brce_cus.bt_brce_siase_archive_202410_v3
Tags semânticas: INSTALACAO, CLIENTE, CONTRATO, MEDIDOR, LEITURA, FATURAMENTO, COBRANCA, ORDENS, GD, REDE_GEO, SOCIAL, COMUNICACAO, CONTABIL, TEMPORAL, COMPETENCIA
Temporal: True · Colunas temporais: dataemissaofatura | datavencimento | dataleituraatual | dataleituraanterior | dataligacaouc | dataencerramentocontrato | dataconcbentarifario | datarevisaocadastral | dataatualizacaomultifamiliar | mesreferencia | saldoatualizadocreditos · Status histórico: PERIODO_NOMINAL_IDENTIFICADO
Cobertura nominal: 202410 a 202410 · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA
Campos (130)
| # | Campo | Tipo | Nulo | Conceito sugerido | Uso temporal |
|---|---|---|---|---|---|
| 1 | tipofaturamento | character varying | SIM | FATURAMENTO | NAO_TEMPORAL |
| 2 | descricaoclasse | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 3 | descricaosubclasse | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 4 | opcaocompraen | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 5 | codigosubgrupotarifario | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 6 | modalidadetarifaria | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 7 | tipoconsfat | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 8 | dataemissaofatura | character varying | SIM | FATURAMENTO | EVENTO_OU_VIGENCIA |
| 9 | datavencimento | character varying | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 10 | dataleituraatual | character varying | SIM | LEITURA | EVENTO_OU_VIGENCIA |
| 11 | dataleituraanterior | character varying | SIM | LEITURA | EVENTO_OU_VIGENCIA |
| 12 | dataligacaouc | character varying | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 13 | dataencerramentocontrato | character varying | SIM | CONTRATO | EVENTO_OU_VIGENCIA |
| 14 | dataconcbentarifario | character varying | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 15 | datarevisaocadastral | character varying | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 16 | dataatualizacaomultifamiliar | character varying | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 17 | mesreferencia | character varying | SIM | COMPETENCIA_REFERENCIA | COBERTURA_HISTORICA |
| 18 | codusuario | character varying | SIM | INSTALACAO | NAO_TEMPORAL |
| 19 | nomecliente | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 20 | tipopessoa | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 21 | numcpfcnpj | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 22 | numrani | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 23 | endereco | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 24 | numcep | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 25 | localizacaouc | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 26 | codigoibge | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 27 | codigofatura | character varying | SIM | FATURAMENTO | NAO_TEMPORAL |
| 28 | codigocnae | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 29 | numnis | character varying | SIM | SOCIAL | NAO_TEMPORAL |
| 30 | codigofamilia | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 31 | cooperado | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 32 | numnb | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 33 | codmedidor | character varying | SIM | MEDIDOR | NAO_TEMPORAL |
| 34 | demativacontratponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 35 | demativacontratforaponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 36 | demativacontratnaoseaplica | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 37 | demativafatponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 38 | demativafatforaponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 39 | demativafatnaoseaplica | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 40 | consativofatteponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 41 | consativofatteforaponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 42 | consativofatteinterm | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 43 | consativofattenaoseaplica | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 44 | consativofattepontares | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 45 | consativofatteforapontares | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 46 | consativofattenaoseaplicares | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 47 | consativofattusdponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 48 | consativofattusdforaponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 49 | consativofattusdinterm | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 50 | consativofattusdnaoseaplica | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 51 | consativofattusdpontares | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 52 | consativofattusdforapontares | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 53 | consativofattusdnaoseaplicares | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 54 | modalidadegd | character varying | SIM | GD | NAO_TEMPORAL |
| 55 | saldoanteriorcreditos | character varying | SIM | COBRANCA | NAO_TEMPORAL |
| 56 | totalcredexpciclofat | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 57 | saldoatualizadocreditos | character varying | SIM | COBRANCA | EVENTO_OU_VIGENCIA |
| 58 | creditosutilizados | character varying | SIM | COBRANCA | NAO_TEMPORAL |
| 59 | multa | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 60 | juros | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 61 | encargosconexao | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 62 | valorcompensacao | character varying | SIM | GD | NAO_TEMPORAL |
| 63 | multaencerramento | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 64 | servicoscobraveis | character varying | SIM | ORDENS | NAO_TEMPORAL |
| 65 | valortotalfatura | character varying | SIM | FATURAMENTO | NAO_TEMPORAL |
| 66 | icms | character varying | SIM | CONTABIL | NAO_TEMPORAL |
| 67 | pis | character varying | SIM | CONTABIL | NAO_TEMPORAL |
| 68 | cofins | character varying | SIM | CONTABIL | NAO_TEMPORAL |
| 69 | basecalculoicms | character varying | SIM | CONTABIL | NAO_TEMPORAL |
| 70 | basecalculopiscofins | character varying | SIM | CONTABIL | NAO_TEMPORAL |
| 71 | cip | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 72 | demativaregponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 73 | demativaregforaponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 74 | demativaregnaoseaplica | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 75 | demativaultponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 76 | demativaultforaponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 77 | demativaultnaoseaplica | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 78 | demativacompponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 79 | demativacompforaponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 80 | demativacompnaoseaplica | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 81 | rcponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 82 | rcforaponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 83 | rcnaoseaplica | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 84 | consativomedteponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 85 | consativomedteforaponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 86 | consativomedteinterm | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 87 | consativomedtenaoseaplica | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 88 | consativomedtepontares | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 89 | consativomedteforapontares | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 90 | consativomedtenaoseaplicares | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 91 | enelativainjponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 92 | enelativainjforaponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 93 | enelativainjintermediario | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 94 | enelativainjreservado | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 95 | enelativainjnaoseaplica | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 96 | subscarfi | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 97 | subsgerfi | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 98 | subsdist | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 99 | subsaguaesgoto | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 100 | subsrural | character varying | SIM | COMUNICACAO | NAO_TEMPORAL |
| 101 | subsirrigacao | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 102 | subsbaixarenda | character varying | SIM | SOCIAL | NAO_TEMPORAL |
| 103 | receitatusdkwponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 104 | receitatusdkwforaponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 105 | receitatusdkwnaoseaplica | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 106 | receitatusdmwhponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 107 | receitatusdmwhforaponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 108 | receitatusdmwhnaoseaplica | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 109 | receitatusdmwhintermediario | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 110 | receitatusdmwhpontares | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 111 | receitatusdmwhforapontares | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 112 | receitatusdmwhnaoseaplicares | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 113 | receitateponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 114 | receitateforaponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 115 | receitatenaoseaplica | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 116 | receitateintermediario | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 117 | receitatepontares | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 118 | receitateforapontares | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 119 | receitatenaoseaplicares | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 120 | receitabandeiras | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 121 | receitaultdemativa | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 122 | ere | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 123 | dre | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 124 | consreativoponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 125 | consreativoforaponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 126 | consreativointermediario | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 127 | consreativonaoseaplica | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 128 | demreativaponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 129 | demreativaforaponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 130 | demreativanaoseaplica | character varying | SIM | OUTRO | NAO_TEMPORAL |
bi_brce_cus.bt_brce_siase_archive_202411_v3
Tags semânticas: INSTALACAO, CLIENTE, CONTRATO, MEDIDOR, LEITURA, FATURAMENTO, COBRANCA, ORDENS, GD, REDE_GEO, SOCIAL, COMUNICACAO, CONTABIL, TEMPORAL, COMPETENCIA
Temporal: True · Colunas temporais: dataemissaofatura | datavencimento | dataleituraatual | dataleituraanterior | dataligacaouc | dataencerramentocontrato | dataconcbentarifario | datarevisaocadastral | dataatualizacaomultifamiliar | mesreferencia | saldoatualizadocreditos · Status histórico: PERIODO_NOMINAL_IDENTIFICADO
Cobertura nominal: 202411 a 202411 · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA
Campos (130)
| # | Campo | Tipo | Nulo | Conceito sugerido | Uso temporal |
|---|---|---|---|---|---|
| 1 | tipofaturamento | character varying | SIM | FATURAMENTO | NAO_TEMPORAL |
| 2 | descricaoclasse | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 3 | descricaosubclasse | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 4 | opcaocompraen | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 5 | codigosubgrupotarifario | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 6 | modalidadetarifaria | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 7 | tipoconsfat | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 8 | dataemissaofatura | character varying | SIM | FATURAMENTO | EVENTO_OU_VIGENCIA |
| 9 | datavencimento | character varying | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 10 | dataleituraatual | character varying | SIM | LEITURA | EVENTO_OU_VIGENCIA |
| 11 | dataleituraanterior | character varying | SIM | LEITURA | EVENTO_OU_VIGENCIA |
| 12 | dataligacaouc | character varying | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 13 | dataencerramentocontrato | character varying | SIM | CONTRATO | EVENTO_OU_VIGENCIA |
| 14 | dataconcbentarifario | character varying | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 15 | datarevisaocadastral | character varying | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 16 | dataatualizacaomultifamiliar | character varying | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 17 | mesreferencia | character varying | SIM | COMPETENCIA_REFERENCIA | COBERTURA_HISTORICA |
| 18 | codusuario | character varying | SIM | INSTALACAO | NAO_TEMPORAL |
| 19 | nomecliente | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 20 | tipopessoa | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 21 | numcpfcnpj | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 22 | numrani | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 23 | endereco | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 24 | numcep | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 25 | localizacaouc | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 26 | codigoibge | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 27 | codigofatura | character varying | SIM | FATURAMENTO | NAO_TEMPORAL |
| 28 | codigocnae | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 29 | numnis | character varying | SIM | SOCIAL | NAO_TEMPORAL |
| 30 | codigofamilia | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 31 | cooperado | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 32 | numnb | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 33 | codmedidor | character varying | SIM | MEDIDOR | NAO_TEMPORAL |
| 34 | demativacontratponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 35 | demativacontratforaponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 36 | demativacontratnaoseaplica | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 37 | demativafatponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 38 | demativafatforaponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 39 | demativafatnaoseaplica | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 40 | consativofatteponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 41 | consativofatteforaponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 42 | consativofatteinterm | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 43 | consativofattenaoseaplica | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 44 | consativofattepontares | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 45 | consativofatteforapontares | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 46 | consativofattenaoseaplicares | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 47 | consativofattusdponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 48 | consativofattusdforaponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 49 | consativofattusdinterm | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 50 | consativofattusdnaoseaplica | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 51 | consativofattusdpontares | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 52 | consativofattusdforapontares | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 53 | consativofattusdnaoseaplicares | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 54 | modalidadegd | character varying | SIM | GD | NAO_TEMPORAL |
| 55 | saldoanteriorcreditos | character varying | SIM | COBRANCA | NAO_TEMPORAL |
| 56 | totalcredexpciclofat | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 57 | saldoatualizadocreditos | character varying | SIM | COBRANCA | EVENTO_OU_VIGENCIA |
| 58 | creditosutilizados | character varying | SIM | COBRANCA | NAO_TEMPORAL |
| 59 | multa | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 60 | juros | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 61 | encargosconexao | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 62 | valorcompensacao | character varying | SIM | GD | NAO_TEMPORAL |
| 63 | multaencerramento | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 64 | servicoscobraveis | character varying | SIM | ORDENS | NAO_TEMPORAL |
| 65 | valortotalfatura | character varying | SIM | FATURAMENTO | NAO_TEMPORAL |
| 66 | icms | character varying | SIM | CONTABIL | NAO_TEMPORAL |
| 67 | pis | character varying | SIM | CONTABIL | NAO_TEMPORAL |
| 68 | cofins | character varying | SIM | CONTABIL | NAO_TEMPORAL |
| 69 | basecalculoicms | character varying | SIM | CONTABIL | NAO_TEMPORAL |
| 70 | basecalculopiscofins | character varying | SIM | CONTABIL | NAO_TEMPORAL |
| 71 | cip | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 72 | demativaregponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 73 | demativaregforaponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 74 | demativaregnaoseaplica | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 75 | demativaultponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 76 | demativaultforaponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 77 | demativaultnaoseaplica | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 78 | demativacompponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 79 | demativacompforaponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 80 | demativacompnaoseaplica | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 81 | rcponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 82 | rcforaponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 83 | rcnaoseaplica | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 84 | consativomedteponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 85 | consativomedteforaponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 86 | consativomedteinterm | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 87 | consativomedtenaoseaplica | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 88 | consativomedtepontares | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 89 | consativomedteforapontares | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 90 | consativomedtenaoseaplicares | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 91 | enelativainjponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 92 | enelativainjforaponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 93 | enelativainjintermediario | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 94 | enelativainjreservado | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 95 | enelativainjnaoseaplica | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 96 | subscarfi | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 97 | subsgerfi | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 98 | subsdist | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 99 | subsaguaesgoto | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 100 | subsrural | character varying | SIM | COMUNICACAO | NAO_TEMPORAL |
| 101 | subsirrigacao | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 102 | subsbaixarenda | character varying | SIM | SOCIAL | NAO_TEMPORAL |
| 103 | receitatusdkwponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 104 | receitatusdkwforaponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 105 | receitatusdkwnaoseaplica | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 106 | receitatusdmwhponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 107 | receitatusdmwhforaponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 108 | receitatusdmwhnaoseaplica | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 109 | receitatusdmwhintermediario | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 110 | receitatusdmwhpontares | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 111 | receitatusdmwhforapontares | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 112 | receitatusdmwhnaoseaplicares | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 113 | receitateponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 114 | receitateforaponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 115 | receitatenaoseaplica | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 116 | receitateintermediario | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 117 | receitatepontares | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 118 | receitateforapontares | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 119 | receitatenaoseaplicares | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 120 | receitabandeiras | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 121 | receitaultdemativa | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 122 | ere | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 123 | dre | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 124 | consreativoponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 125 | consreativoforaponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 126 | consreativointermediario | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 127 | consreativonaoseaplica | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 128 | demreativaponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 129 | demreativaforaponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 130 | demreativanaoseaplica | character varying | SIM | OUTRO | NAO_TEMPORAL |
bi_brce_cus.bt_brce_siase_archive_202412_v3
Tags semânticas: INSTALACAO, CLIENTE, CONTRATO, MEDIDOR, LEITURA, FATURAMENTO, COBRANCA, ORDENS, GD, REDE_GEO, SOCIAL, COMUNICACAO, CONTABIL, TEMPORAL, COMPETENCIA
Temporal: True · Colunas temporais: dataemissaofatura | datavencimento | dataleituraatual | dataleituraanterior | dataligacaouc | dataencerramentocontrato | dataconcbentarifario | datarevisaocadastral | dataatualizacaomultifamiliar | mesreferencia | saldoatualizadocreditos · Status histórico: PERIODO_NOMINAL_IDENTIFICADO
Cobertura nominal: 202412 a 202412 · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA
Campos (130)
| # | Campo | Tipo | Nulo | Conceito sugerido | Uso temporal |
|---|---|---|---|---|---|
| 1 | tipofaturamento | character varying | SIM | FATURAMENTO | NAO_TEMPORAL |
| 2 | descricaoclasse | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 3 | descricaosubclasse | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 4 | opcaocompraen | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 5 | codigosubgrupotarifario | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 6 | modalidadetarifaria | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 7 | tipoconsfat | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 8 | dataemissaofatura | character varying | SIM | FATURAMENTO | EVENTO_OU_VIGENCIA |
| 9 | datavencimento | character varying | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 10 | dataleituraatual | character varying | SIM | LEITURA | EVENTO_OU_VIGENCIA |
| 11 | dataleituraanterior | character varying | SIM | LEITURA | EVENTO_OU_VIGENCIA |
| 12 | dataligacaouc | character varying | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 13 | dataencerramentocontrato | character varying | SIM | CONTRATO | EVENTO_OU_VIGENCIA |
| 14 | dataconcbentarifario | character varying | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 15 | datarevisaocadastral | character varying | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 16 | dataatualizacaomultifamiliar | character varying | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 17 | mesreferencia | character varying | SIM | COMPETENCIA_REFERENCIA | COBERTURA_HISTORICA |
| 18 | codusuario | character varying | SIM | INSTALACAO | NAO_TEMPORAL |
| 19 | nomecliente | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 20 | tipopessoa | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 21 | numcpfcnpj | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 22 | numrani | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 23 | endereco | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 24 | numcep | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 25 | localizacaouc | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 26 | codigoibge | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 27 | codigofatura | character varying | SIM | FATURAMENTO | NAO_TEMPORAL |
| 28 | codigocnae | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 29 | numnis | character varying | SIM | SOCIAL | NAO_TEMPORAL |
| 30 | codigofamilia | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 31 | cooperado | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 32 | numnb | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 33 | codmedidor | character varying | SIM | MEDIDOR | NAO_TEMPORAL |
| 34 | demativacontratponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 35 | demativacontratforaponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 36 | demativacontratnaoseaplica | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 37 | demativafatponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 38 | demativafatforaponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 39 | demativafatnaoseaplica | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 40 | consativofatteponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 41 | consativofatteforaponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 42 | consativofatteinterm | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 43 | consativofattenaoseaplica | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 44 | consativofattepontares | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 45 | consativofatteforapontares | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 46 | consativofattenaoseaplicares | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 47 | consativofattusdponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 48 | consativofattusdforaponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 49 | consativofattusdinterm | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 50 | consativofattusdnaoseaplica | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 51 | consativofattusdpontares | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 52 | consativofattusdforapontares | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 53 | consativofattusdnaoseaplicares | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 54 | modalidadegd | character varying | SIM | GD | NAO_TEMPORAL |
| 55 | saldoanteriorcreditos | character varying | SIM | COBRANCA | NAO_TEMPORAL |
| 56 | totalcredexpciclofat | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 57 | saldoatualizadocreditos | character varying | SIM | COBRANCA | EVENTO_OU_VIGENCIA |
| 58 | creditosutilizados | character varying | SIM | COBRANCA | NAO_TEMPORAL |
| 59 | multa | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 60 | juros | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 61 | encargosconexao | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 62 | valorcompensacao | character varying | SIM | GD | NAO_TEMPORAL |
| 63 | multaencerramento | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 64 | servicoscobraveis | character varying | SIM | ORDENS | NAO_TEMPORAL |
| 65 | valortotalfatura | character varying | SIM | FATURAMENTO | NAO_TEMPORAL |
| 66 | icms | character varying | SIM | CONTABIL | NAO_TEMPORAL |
| 67 | pis | character varying | SIM | CONTABIL | NAO_TEMPORAL |
| 68 | cofins | character varying | SIM | CONTABIL | NAO_TEMPORAL |
| 69 | basecalculoicms | character varying | SIM | CONTABIL | NAO_TEMPORAL |
| 70 | basecalculopiscofins | character varying | SIM | CONTABIL | NAO_TEMPORAL |
| 71 | cip | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 72 | demativaregponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 73 | demativaregforaponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 74 | demativaregnaoseaplica | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 75 | demativaultponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 76 | demativaultforaponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 77 | demativaultnaoseaplica | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 78 | demativacompponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 79 | demativacompforaponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 80 | demativacompnaoseaplica | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 81 | rcponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 82 | rcforaponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 83 | rcnaoseaplica | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 84 | consativomedteponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 85 | consativomedteforaponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 86 | consativomedteinterm | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 87 | consativomedtenaoseaplica | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 88 | consativomedtepontares | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 89 | consativomedteforapontares | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 90 | consativomedtenaoseaplicares | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 91 | enelativainjponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 92 | enelativainjforaponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 93 | enelativainjintermediario | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 94 | enelativainjreservado | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 95 | enelativainjnaoseaplica | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 96 | subscarfi | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 97 | subsgerfi | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 98 | subsdist | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 99 | subsaguaesgoto | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 100 | subsrural | character varying | SIM | COMUNICACAO | NAO_TEMPORAL |
| 101 | subsirrigacao | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 102 | subsbaixarenda | character varying | SIM | SOCIAL | NAO_TEMPORAL |
| 103 | receitatusdkwponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 104 | receitatusdkwforaponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 105 | receitatusdkwnaoseaplica | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 106 | receitatusdmwhponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 107 | receitatusdmwhforaponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 108 | receitatusdmwhnaoseaplica | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 109 | receitatusdmwhintermediario | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 110 | receitatusdmwhpontares | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 111 | receitatusdmwhforapontares | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 112 | receitatusdmwhnaoseaplicares | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 113 | receitateponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 114 | receitateforaponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 115 | receitatenaoseaplica | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 116 | receitateintermediario | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 117 | receitatepontares | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 118 | receitateforapontares | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 119 | receitatenaoseaplicares | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 120 | receitabandeiras | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 121 | receitaultdemativa | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 122 | ere | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 123 | dre | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 124 | consreativoponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 125 | consreativoforaponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 126 | consreativointermediario | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 127 | consreativonaoseaplica | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 128 | demreativaponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 129 | demreativaforaponta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 130 | demreativanaoseaplica | character varying | SIM | OUTRO | NAO_TEMPORAL |
bi_brce_cus.bt_brce_tbl_dq_kpi_qualidade_hist
Tags semânticas: INSTALACAO, CLIENTE, CONTRATO, MEDIDOR, CONTATO, REDE_GEO, TEMPORAL, ATUALIZACAO
Temporal: True · Colunas temporais: dt_processamento · Status histórico: EXIGE_MIN_MAX_NOS_DADOS
Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA
Campos (49)
| # | Campo | Tipo | Nulo | Conceito sugerido | Uso temporal |
|---|---|---|---|---|---|
| 1 | distribuidora | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 2 | instalacao | character varying | SIM | INSTALACAO | NAO_TEMPORAL |
| 3 | assetid | character varying | SIM | MEDIDOR | NAO_TEMPORAL |
| 4 | conta_contrato | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 5 | parceiro | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 6 | nome | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 7 | nome_mae | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 8 | dt_nascimento | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 9 | cpf | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 10 | cnpj | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 11 | inscricao_estadual | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 12 | isento | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 13 | email | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 14 | tel_celular | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 15 | tel_fixo | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 16 | logradouro | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 17 | numero | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 18 | complemento | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 19 | bairro | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 20 | municipio | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 21 | uf | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 22 | cep | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 23 | cnae | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 24 | codigo_classe | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 25 | classe_n | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 26 | subclasse_n | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 27 | grupo | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 28 | dt_processamento | date | SIM | ATUALIZACAO_CARGA | ATUALIZACAO_FISICA |
| 29 | seqid | bigint | SIM | OUTRO | NAO_TEMPORAL |
| 30 | cpf_n | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 31 | cnpj_n | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 32 | cep_n | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 33 | municipio_n | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 34 | cep_obs | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 35 | entrega_alt | boolean | SIM | OUTRO | NAO_TEMPORAL |
| 36 | logradouro_alt | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 37 | numero_alt | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 38 | complemento_alt | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 39 | bairro_alt | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 40 | municipio_alt | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 41 | uf_alt | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 42 | cep_alt | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 43 | municipio_alt_n | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 44 | cep_alt_n | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 45 | cep_alt_obs | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 46 | cnae_n | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 47 | email_n | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 48 | tel_celular_n | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 49 | tel_fixo_n | character varying | SIM | OUTRO | NAO_TEMPORAL |
bi_brce_cus.bt_brce_vm_mega_base
Tags semânticas: CLIENTE, MEDIDOR, FATURAMENTO, PERDAS, ORDENS, GD, REDE_GEO, COMUNICACAO, TEMPORAL, ATUALIZACAO, COMPETENCIA
Temporal: True · Colunas temporais: data_geracao_inspecao | data_execucao_inspecao | data_encerramento_inspecao | toi_levantamento_carga | data_execucao_normalizacao | data_encerramento_normalizacao | data_entrada_laboratorio | data_execucao_laudo | data_calculo_toi | data_cancelamento_toi | data_inicio_cobranca_toi | data_fim_cobranca_toi | periodo_cobranca | data_etl | data_ingesta | data_faturamento_toi · Status histórico: EXIGE_MIN_MAX_NOS_DADOS
Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA
Campos (81)
| # | Campo | Tipo | Nulo | Conceito sugerido | Uso temporal |
|---|---|---|---|---|---|
| 1 | cliente_id | integer | SIM | CLIENTE | NAO_TEMPORAL |
| 2 | nivel_tensao | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 3 | grupo | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 4 | tipo_medicao | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 5 | classe | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 6 | subclasse | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 7 | estado | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 8 | municipio_ibge | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 9 | municipio | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 10 | regional | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 11 | unid_operacional | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 12 | inspecao_id | bigint | SIM | PERDAS | NAO_TEMPORAL |
| 13 | tipo_inspecao | character varying | SIM | PERDAS | NAO_TEMPORAL |
| 14 | medidor_inspecionado_id | integer | SIM | MEDIDOR | NAO_TEMPORAL |
| 15 | medidor_inspecionado_marca | character varying | SIM | MEDIDOR | NAO_TEMPORAL |
| 16 | medidor_inspecionado_modelo | character varying | SIM | MEDIDOR | NAO_TEMPORAL |
| 17 | medidor_inspecionado_desc | character varying | SIM | MEDIDOR | NAO_TEMPORAL |
| 18 | tipo_lig_medidor | character varying | SIM | MEDIDOR | NAO_TEMPORAL |
| 19 | tipo_medidor | character varying | SIM | MEDIDOR | NAO_TEMPORAL |
| 20 | inspecao_origem_id | character varying | SIM | PERDAS | NAO_TEMPORAL |
| 21 | inspecao_origem_desc | character varying | SIM | PERDAS | NAO_TEMPORAL |
| 22 | inspecao_tipo_policy | character varying | SIM | PERDAS | NAO_TEMPORAL |
| 23 | status_inspecao | character varying | SIM | PERDAS | NAO_TEMPORAL |
| 24 | status_inspecao_desc | character varying | SIM | PERDAS | NAO_TEMPORAL |
| 25 | equipe_inspecao_desc | character varying | SIM | PERDAS | NAO_TEMPORAL |
| 26 | equipe_inspecao_id | character varying | SIM | PERDAS | NAO_TEMPORAL |
| 27 | empresa_inspecao | character varying | SIM | PERDAS | NAO_TEMPORAL |
| 28 | data_geracao_inspecao | character varying | SIM | PERDAS | EVENTO_OU_VIGENCIA |
| 29 | data_execucao_inspecao | character varying | SIM | PERDAS | EVENTO_OU_VIGENCIA |
| 30 | data_encerramento_inspecao | character varying | SIM | PERDAS | EVENTO_OU_VIGENCIA |
| 31 | inspecao_acompanhada | integer | SIM | PERDAS | NAO_TEMPORAL |
| 32 | inspecao_assertiva | integer | SIM | PERDAS | NAO_TEMPORAL |
| 33 | irregularidade_medicao | integer | SIM | PERDAS | NAO_TEMPORAL |
| 34 | tp | integer | SIM | OUTRO | NAO_TEMPORAL |
| 35 | toi_id | integer | SIM | PERDAS | NAO_TEMPORAL |
| 36 | toi_assinado | integer | SIM | PERDAS | NAO_TEMPORAL |
| 37 | toi_levantamento_carga | integer | SIM | PERDAS | EVENTO_OU_VIGENCIA |
| 38 | tipo_servico_inspecao | character varying | SIM | PERDAS | NAO_TEMPORAL |
| 39 | obs_inspecao | character varying | SIM | PERDAS | NAO_TEMPORAL |
| 40 | status_normalizacao | character varying | SIM | PERDAS | NAO_TEMPORAL |
| 41 | equipe_normalizacao_desc | character varying | SIM | PERDAS | NAO_TEMPORAL |
| 42 | equipe_normalizacao_id | character varying | SIM | PERDAS | NAO_TEMPORAL |
| 43 | empresa_normalizacao_id | character varying | SIM | PERDAS | NAO_TEMPORAL |
| 44 | data_execucao_normalizacao | character varying | SIM | PERDAS | EVENTO_OU_VIGENCIA |
| 45 | data_encerramento_normalizacao | character varying | SIM | PERDAS | EVENTO_OU_VIGENCIA |
| 46 | tipo_servico_normalizacao | character varying | SIM | PERDAS | NAO_TEMPORAL |
| 47 | medidor_substituido | integer | SIM | MEDIDOR | NAO_TEMPORAL |
| 48 | ligacao_direta | integer | SIM | OUTRO | NAO_TEMPORAL |
| 49 | troca_de_caixa | integer | SIM | OUTRO | NAO_TEMPORAL |
| 50 | troca_de_ramal | integer | SIM | OUTRO | NAO_TEMPORAL |
| 51 | laudo_id | integer | SIM | PERDAS | NAO_TEMPORAL |
| 52 | data_entrada_laboratorio | character varying | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 53 | data_execucao_laudo | character varying | SIM | PERDAS | EVENTO_OU_VIGENCIA |
| 54 | resultado_laudo | character varying | SIM | PERDAS | NAO_TEMPORAL |
| 55 | tipo_irregularidade_laudo | character varying | SIM | PERDAS | NAO_TEMPORAL |
| 56 | erro_medicao | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 57 | analista_laudo | character varying | SIM | PERDAS | NAO_TEMPORAL |
| 58 | observacoes_laudo | character varying | SIM | PERDAS | NAO_TEMPORAL |
| 59 | status_toi_id | character varying | SIM | PERDAS | NAO_TEMPORAL |
| 60 | status_toi_desc | character varying | SIM | PERDAS | NAO_TEMPORAL |
| 61 | tpe | integer | SIM | OUTRO | NAO_TEMPORAL |
| 62 | data_faturamento_toi | character varying | SIM | FATURAMENTO | EVENTO_OU_VIGENCIA |
| 63 | tipo_irregularidade_toi | character varying | SIM | PERDAS | NAO_TEMPORAL |
| 64 | data_calculo_toi | character varying | SIM | PERDAS | EVENTO_OU_VIGENCIA |
| 65 | criterio_calculo_id | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 66 | criterio_calculo_desc | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 67 | data_cancelamento_toi | character varying | SIM | PERDAS | EVENTO_OU_VIGENCIA |
| 68 | cancelamento_toi | character varying | SIM | PERDAS | NAO_TEMPORAL |
| 69 | motivo_cancelamento_toi | character varying | SIM | PERDAS | NAO_TEMPORAL |
| 70 | data_inicio_cobranca_toi | character varying | SIM | PERDAS | EVENTO_OU_VIGENCIA |
| 71 | data_fim_cobranca_toi | character varying | SIM | PERDAS | EVENTO_OU_VIGENCIA |
| 72 | periodo_cobranca | double precision | SIM | COMPETENCIA_REFERENCIA | COBERTURA_HISTORICA |
| 73 | cnr_energia_faturado | double precision | SIM | FATURAMENTO | NAO_TEMPORAL |
| 74 | cnr_energia_reais | integer | SIM | PERDAS | NAO_TEMPORAL |
| 75 | cnr_total_fatura | integer | SIM | FATURAMENTO | NAO_TEMPORAL |
| 76 | cnr_energia_cancelado | double precision | SIM | PERDAS | NAO_TEMPORAL |
| 77 | cnr_cancelado_reais | integer | SIM | PERDAS | NAO_TEMPORAL |
| 78 | cnr_total_fatura_cancelado | integer | SIM | FATURAMENTO | NAO_TEMPORAL |
| 79 | analista_toi | character varying | SIM | PERDAS | NAO_TEMPORAL |
| 80 | data_etl | character varying | SIM | ATUALIZACAO_CARGA | ATUALIZACAO_FISICA |
| 81 | data_ingesta | character varying | SIM | ATUALIZACAO_CARGA | ATUALIZACAO_FISICA |
bi_brce_cus.bt_global_gbs_inspection_wo_brasil_ceara
Tags semânticas: FATURAMENTO, PERDAS, ORDENS, TEMPORAL, COMPETENCIA
Temporal: True · Colunas temporais: periodo · Status histórico: EXIGE_MIN_MAX_NOS_DADOS
Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA
Campos (5)
| # | Campo | Tipo | Nulo | Conceito sugerido | Uso temporal |
|---|---|---|---|---|---|
| 1 | inspection_work_order_id | character varying | SIM | PERDAS | NAO_TEMPORAL |
| 2 | energy_billed | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 3 | energy_invoiced | character varying | SIM | FATURAMENTO | NAO_TEMPORAL |
| 4 | spid | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 5 | periodo | integer | SIM | COMPETENCIA_REFERENCIA | COBERTURA_HISTORICA |
bi_brce_cus.bt_brce_account
Tags semânticas: CLIENTE, FATURAMENTO, RECLAMACAO, ORDENS, GD, CONTATO, REDE_GEO, SOCIAL, COMUNICACAO, CONTABIL, TEMPORAL
Temporal: True · Colunas temporais: createddate | createdbyid | lastmodifieddate | lastmodifiedbyid | systemmodstamp | lastactivitydate | birthdate__c | activation_date__c | ne__slaexpirationdate__c | administratorduedate__c | committeduedate__c | deactivation_date__c | registrationdate__c | regulationdate__c | wbc_etrm__pbs_data_hora_integracao_com_wbc__c | allows_the_use_of_data__c | leadassigneddate__c | leadgenerationdate__c · Status histórico: EXIGE_MIN_MAX_NOS_DADOS
Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA
Campos (198)
| # | Campo | Tipo | Nulo | Conceito sugerido | Uso temporal |
|---|---|---|---|---|---|
| 1 | id | character varying | NÃO | OUTRO | NAO_TEMPORAL |
| 2 | isdeleted | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 3 | masterrecordid | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 4 | name | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 5 | type | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 6 | recordtypeid | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 7 | parentid | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 8 | billingstreet | character varying | SIM | FATURAMENTO | NAO_TEMPORAL |
| 9 | billingcity | character varying | SIM | FATURAMENTO | NAO_TEMPORAL |
| 10 | billingstate | character varying | SIM | FATURAMENTO | NAO_TEMPORAL |
| 11 | billingpostalcode | character varying | SIM | FATURAMENTO | NAO_TEMPORAL |
| 12 | billingcountry | character varying | SIM | FATURAMENTO | NAO_TEMPORAL |
| 13 | billinglatitude | double precision | SIM | FATURAMENTO | NAO_TEMPORAL |
| 14 | billinglongitude | double precision | SIM | FATURAMENTO | NAO_TEMPORAL |
| 15 | billinggeocodeaccuracy | character varying | SIM | FATURAMENTO | NAO_TEMPORAL |
| 16 | shippingstreet | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 17 | shippingcity | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 18 | shippingstate | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 19 | shippingpostalcode | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 20 | shippingcountry | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 21 | shippinglatitude | double precision | SIM | REDE_GEO | NAO_TEMPORAL |
| 22 | shippinglongitude | double precision | SIM | REDE_GEO | NAO_TEMPORAL |
| 23 | shippinggeocodeaccuracy | character varying | SIM | COMUNICACAO | NAO_TEMPORAL |
| 24 | phone | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 25 | fax | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 26 | accountnumber | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 27 | website | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 28 | sic | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 29 | industry | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 30 | annualrevenue | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 31 | numberofemployees | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 32 | ownership | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 33 | tickersymbol | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 34 | description | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 35 | rating | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 36 | site | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 37 | currencyisocode | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 38 | ownerid | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 39 | createddate | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 40 | createdbyid | character varying | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 41 | lastmodifieddate | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 42 | lastmodifiedbyid | character varying | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 43 | systemmodstamp | timestamp without time zone | SIM | OUTRO | EVENTO_OU_VIGENCIA |
| 44 | lastactivitydate | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 45 | jigsaw | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 46 | jigsawcompanyid | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 47 | accountsource | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 48 | sicdesc | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 49 | accountcode__c | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 50 | account__c | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 51 | additionalphone__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 52 | address__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 53 | birthdate__c | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 54 | businessname__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 55 | companycategory__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 56 | companyid__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 57 | executive__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 58 | fatherslastname__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 59 | identitynumber__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 60 | identitytype__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 61 | mainphone__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 62 | motherslastname__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 63 | primaryemail__c | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 64 | secondaryemail__c | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 65 | secondaryphone__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 66 | sector__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 67 | usertypecompany__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 68 | company__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 69 | country__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 70 | externalid__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 71 | activation_date__c | timestamp without time zone | SIM | ORDENS | EVENTO_OU_VIGENCIA |
| 72 | indice__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 73 | ia_extension__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 74 | ismigrated__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 75 | ne__active__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 76 | ne__customerpriority__c | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 77 | ne__customer_number__c | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 78 | ne__e_mail__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 79 | ne__fiscal_code__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 80 | ne__localization__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 81 | ne__name__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 82 | ne__numberoflocations__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 83 | ne__slaexpirationdate__c | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 84 | ne__slaserialnumber__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 85 | ne__sla__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 86 | ne__status__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 87 | ne__sub_sector__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 88 | ne__surname__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 89 | ne__type__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 90 | ne__upsellopportunity__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 91 | ne__vat__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 92 | administratoraddress__c | character varying | SIM | SOCIAL | NAO_TEMPORAL |
| 93 | administratorduedate__c | timestamp without time zone | SIM | SOCIAL | EVENTO_OU_VIGENCIA |
| 94 | administratoremail__c | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 95 | administratormobilephone__c | character varying | SIM | SOCIAL | NAO_TEMPORAL |
| 96 | administratorphone__c | character varying | SIM | SOCIAL | NAO_TEMPORAL |
| 97 | administratorrut__c | character varying | SIM | SOCIAL | NAO_TEMPORAL |
| 98 | administratororbusinessname__c | character varying | SIM | SOCIAL | NAO_TEMPORAL |
| 99 | aplicantname__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 100 | authorisescut__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 101 | committeduedate__c | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 102 | committeeletter__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 103 | committeemembers__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 104 | condominiumdeed__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 105 | condominiumrut__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 106 | condominiumstatus__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 107 | condominiumtype__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 108 | corporate__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 109 | createcase__c | double precision | SIM | RECLAMACAO | NAO_TEMPORAL |
| 110 | deactivation_date__c | timestamp without time zone | SIM | ORDENS | EVENTO_OU_VIGENCIA |
| 111 | detailaddress__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 112 | foldernumber__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 113 | economicactivity__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 114 | hasregulationofcoownership__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 115 | iscondominium__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 116 | iscorporate__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 117 | meetingminutesattached__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 118 | modificationform__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 119 | numberofdepartments__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 120 | numberofhouses__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 121 | numberoflocals__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 122 | numberofpointsofdeliveryassociated__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 123 | operationalcenter__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 124 | persontype__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 125 | registrationdate__c | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 126 | regulationdate__c | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 127 | regulationofcoownership__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 128 | residenceusertype__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 129 | signatures__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 130 | signingregistration__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 131 | underlaw19537__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 132 | accountsec__c | double precision | SIM | CLIENTE | NAO_TEMPORAL |
| 133 | agent_type__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 134 | nickname__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 135 | sub_portoflio__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 136 | business_portfolio__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 137 | wbc_etrm__pbs_codigo_cidade_wbc__c | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 138 | wbc_etrm__pbs_codigo_empresa_wbc__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 139 | wbc_etrm__pbs_codigo_endereco_wbc__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 140 | wbc_etrm__pbs_data_hora_integracao_com_wbc__c | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 141 | wbc_etrm__pbs_integrado_wbc__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 142 | wbc_etrm__pbs_rating__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 143 | allows_the_use_of_data__c | double precision | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 144 | ggcc__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 145 | razonsocial__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 146 | billingaddress__c | character varying | SIM | FATURAMENTO | NAO_TEMPORAL |
| 147 | businessnameb2b__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 148 | commercialaddress__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 149 | countryb2b__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 150 | localdistributor__c | character varying | SIM | CONTABIL | NAO_TEMPORAL |
| 151 | rut__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 152 | rubro__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 153 | statusaccount__c | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 154 | numberrelateddeliverypoints__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 155 | accountclientnumber__c | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 156 | accountsector__c | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 157 | account_type__c | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 158 | electrodependentid__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 159 | favchannelcontact__c | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 160 | phonetype__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 161 | tertiaryemail__c | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 162 | uniqueidentifier__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 163 | direccindefacturacion__c | character varying | SIM | FATURAMENTO | NAO_TEMPORAL |
| 164 | direccioncomercial__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 165 | distribuidoralocal__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 166 | estadocuenta__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 167 | nowishtogivemail__c | double precision | SIM | CONTATO | NAO_TEMPORAL |
| 168 | pais__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 169 | partnerchlvisibility__c | double precision | SIM | CLIENTE | NAO_TEMPORAL |
| 170 | tertiary_email__c | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 171 | leadassigneddate__c | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 172 | lead_channel__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 173 | leadgenerationdate__c | timestamp without time zone | SIM | GD | EVENTO_OU_VIGENCIA |
| 174 | pec_account__c | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 175 | accountlocation__c | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 176 | fiscal_identification__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 177 | cnt_is_postal_address__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 178 | acceptenelcommunication__c | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 179 | cnt_customerchannel__c | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 180 | cnt_mothers_full_name__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 181 | cnt_id_type_2__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 182 | cnt_id_num_2__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 183 | cnt_state_inscription__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 184 | cnt_state_inscription_exemption__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 185 | cnt_municipality_inscription__c | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 186 | cnt_responsible_name__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 187 | cnt_resp_id_type__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 188 | cnt_resp_id_number__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 189 | cnt_responsible_phone__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 190 | cnt_responsible_email__c | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 191 | cnt_responsible_charge__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 192 | cnt_numorgcntr__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 193 | cnt_fantasy_name__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 194 | spousedocument__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 195 | spousename__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 196 | cnt_primary_cell_phone__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 197 | economic_activity__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 198 | ri__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
bi_brce_cus.bt_brce_act_servico_gomnet_tempos_medios_ceara
Tags semânticas: CLIENTE, FATURAMENTO, RECLAMACAO, ORDENS, REDE_GEO, COMUNICACAO, TEMPORAL, ATUALIZACAO, COMPETENCIA
Temporal: True · Colunas temporais: data_de_solicitacao | data_os_ligacao_nova | data_envio_a_gom | data_inicio_ult_pendencia | data_fim_ult_pendencia | data_receb_da_gom | data_liberacao_tecnica | data_impressao_carta | data_receb_carta | data_digit_receb_carta | data_autorizacao | data_faturamento | data_modif_valor | data_validade | data_devolucao_empreiteira | data_de_despacho | data_envio_comercial | primeiro_envio_aprovacao | ultimo_envio_aprovacao | aprovacao_projeto | data_etl | dt_insert_lake | dias_periodo_tot_aprov · Status histórico: EXIGE_MIN_MAX_NOS_DADOS
Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA
Campos (56)
| # | Campo | Tipo | Nulo | Conceito sugerido | Uso temporal |
|---|---|---|---|---|---|
| 1 | ceco | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 2 | solicitacao | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 3 | data_de_solicitacao | character varying | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 4 | estado_os | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 5 | os_ligacao_nova | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 6 | data_os_ligacao_nova | character varying | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 7 | nome_cliente | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 8 | endereco_cliente | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 9 | municipio_cliente | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 10 | estudo_tecnico | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 11 | proj_investimento | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 12 | valor_orcam | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 13 | valor_a_pagar | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 14 | nr_de_ucs | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 15 | nivel_de_tensao | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 16 | data_envio_a_gom | character varying | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 17 | qde_pendencia | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 18 | data_inicio_ult_pendencia | character varying | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 19 | data_fim_ult_pendencia | character varying | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 20 | ult_codigo_de_retorno | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 21 | tempo_total_pendencias | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 22 | data_receb_da_gom | character varying | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 23 | tempo_receb_da_gom | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 24 | data_liberacao_tecnica | character varying | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 25 | tempo_assoc_liberacao | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 26 | tempo_tecnica | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 27 | data_impressao_carta | character varying | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 28 | tempo_imp_liber | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 29 | data_receb_carta | character varying | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 30 | data_digit_receb_carta | character varying | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 31 | data_autorizacao | character varying | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 32 | tempo_comercial | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 33 | tempo_atendimento | character varying | SIM | RECLAMACAO | NAO_TEMPORAL |
| 34 | data_faturamento | character varying | SIM | FATURAMENTO | EVENTO_OU_VIGENCIA |
| 35 | tempo_faturamento | character varying | SIM | FATURAMENTO | NAO_TEMPORAL |
| 36 | data_modif_valor | character varying | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 37 | data_validade | character varying | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 38 | data_devolucao_empreiteira | character varying | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 39 | data_de_despacho | character varying | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 40 | projeto_de_investimento | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 41 | descricao_do_projeto | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 42 | data_envio_comercial | character varying | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 43 | empreiteira | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 44 | projetista | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 45 | inspetor | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 46 | tipo_servico_synergia | character varying | SIM | ORDENS | NAO_TEMPORAL |
| 47 | protocolo_de_lic_ambiental | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 48 | valor_do_licenciamento | numeric | SIM | OUTRO | NAO_TEMPORAL |
| 49 | observacao_do_licenciamento | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 50 | primeiro_envio_aprovacao | timestamp without time zone | SIM | OUTRO | EVENTO_OU_VIGENCIA |
| 51 | ultimo_envio_aprovacao | timestamp without time zone | SIM | OUTRO | EVENTO_OU_VIGENCIA |
| 52 | aprovacao_projeto | timestamp without time zone | SIM | OUTRO | EVENTO_OU_VIGENCIA |
| 53 | dias_periodo_tot_aprov | bigint | SIM | COMPETENCIA_REFERENCIA | COBERTURA_HISTORICA |
| 54 | estado | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 55 | data_etl | timestamp without time zone | SIM | ATUALIZACAO_CARGA | ATUALIZACAO_FISICA |
| 56 | dt_insert_lake | timestamp without time zone | SIM | OUTRO | EVENTO_OU_VIGENCIA |
bi_brce_cus.bt_brce_act_servico_gomnet_universalizacao_ceara
Tags semânticas: INSTALACAO, CLIENTE, CONTRATO, REDE_GEO, TEMPORAL, ATUALIZACAO
Temporal: True · Colunas temporais: une_slns_fecha_emision_solic | une_val_fecha_elab_presupuesto | une_pas_fecha_envio_comercial | une_pas_fecha_aceptacion | une_trab_fecha_ini_ejecu_real | une_trab_fecha_fin_ejecu_real | une_rco_fecha_emision | une_slns_fecha_receb_carta | une_epep_fecha_liberacion | une_trab_fecha_solicitud_trab | une_trab_fecha_energizacion | une_data_modif | une_orden_fecha_liberacion | une_data_pdl | une_data_despacho | une_data_energizacao | une_data_ativacao | une_data_instalacao | une_data_implantacao | une_data_ult_fiscaliz | une_data_ult_valid | une_data_unitizacao | une_data_vistoria | une_data_conclusao | une_dtcancel | data_etl | dt_insert_lake · Status histórico: EXIGE_MIN_MAX_NOS_DADOS
Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA
Campos (115)
| # | Campo | Tipo | Nulo | Conceito sugerido | Uso temporal |
|---|---|---|---|---|---|
| 1 | une_dep_codigo_unidad | integer | SIM | OUTRO | NAO_TEMPORAL |
| 2 | une_slns_codigo | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 3 | une_proy_codigo | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 4 | une_trab_codigo | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 5 | une_val_codigo | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 6 | une_slns_fecha_emision_solic | timestamp without time zone | SIM | OUTRO | EVENTO_OU_VIGENCIA |
| 7 | une_prsi_cod_descri | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 8 | une_val_fecha_elab_presupuesto | timestamp without time zone | SIM | OUTRO | EVENTO_OU_VIGENCIA |
| 9 | une_pas_fecha_envio_comercial | timestamp without time zone | SIM | OUTRO | EVENTO_OU_VIGENCIA |
| 10 | une_pas_fecha_aceptacion | timestamp without time zone | SIM | REDE_GEO | EVENTO_OU_VIGENCIA |
| 11 | une_trab_fecha_ini_ejecu_real | timestamp without time zone | SIM | OUTRO | EVENTO_OU_VIGENCIA |
| 12 | une_trab_fecha_fin_ejecu_real | timestamp without time zone | SIM | OUTRO | EVENTO_OU_VIGENCIA |
| 13 | une_rco_fecha_emision | timestamp without time zone | SIM | OUTRO | EVENTO_OU_VIGENCIA |
| 14 | une_mu_nom | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 15 | une_slns_localizacion_obra | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 16 | une_psie_nombre | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 17 | une_slns_nombre_pers_cliente | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 18 | une_slns_fecha_receb_carta | timestamp without time zone | SIM | OUTRO | EVENTO_OU_VIGENCIA |
| 19 | une_epep_fecha_liberacion | timestamp without time zone | SIM | OUTRO | EVENTO_OU_VIGENCIA |
| 20 | une_trab_fecha_solicitud_trab | timestamp without time zone | SIM | OUTRO | EVENTO_OU_VIGENCIA |
| 21 | une_trab_estado_descri | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 22 | une_peps | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 23 | une_trab_fecha_energizacion | timestamp without time zone | SIM | OUTRO | EVENTO_OU_VIGENCIA |
| 24 | une_val_material | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 25 | une_val_maoobra | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 26 | une_val_engsuperv | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 27 | une_val_transporte | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 28 | une_val_admgeral | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 29 | une_val_total | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 30 | une_val_exttrimt | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 31 | une_val_extbimt | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 32 | une_val_extmonomt | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 33 | une_val_exttotmt | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 34 | une_val_exttribt | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 35 | une_val_extbibt | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 36 | une_val_extmonobt | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 37 | une_val_exttotbt | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 38 | une_val_extconjmono | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 39 | une_val_extconjtri | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 40 | une_val_exttotmtbt | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 41 | une_val_numtrafos | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 42 | une_val_potkva | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 43 | une_val_numpostes | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 44 | une_val_numuc | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 45 | une_importetotal | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 46 | une_vrapagar | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 47 | une_enc_descripcion | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 48 | une_tecnicoresponsavel | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 49 | une_val_materialsalvado | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 50 | une_percentconclusao | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 51 | une_val_totmatodi | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 52 | une_val_totmaoobraodi | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 53 | une_val_totengenhariaodi | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 54 | une_val_tottransporteodi | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 55 | une_val_totadmodi | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 56 | une_val_totodi | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 57 | une_val_totmatodd | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 58 | une_val_totmaoobraodd | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 59 | une_val_totengenhariaodd | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 60 | une_val_tottransporteodd | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 61 | une_val_totadmodd | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 62 | une_val_totodd | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 63 | une_val_totmatods | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 64 | une_val_totmaoobraods | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 65 | une_val_totengenhariaods | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 66 | une_val_tottransporteods | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 67 | une_val_totadmods | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 68 | une_val_totods | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 69 | une_val_totmatodr | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 70 | une_val_totmaoobraodr | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 71 | une_val_totengenhariaodr | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 72 | une_val_tottransporteodr | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 73 | une_val_totadmodr | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 74 | une_val_totodr | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 75 | une_val_totmatodm | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 76 | une_val_totmaoobraodm | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 77 | une_val_totengenhariaodm | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 78 | une_val_tottransporteodm | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 79 | une_val_totadmodm | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 80 | une_val_totodm | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 81 | une_val_numluminarias | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 82 | une_val_linha_viva | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 83 | une_val_projeto | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 84 | une_val_fiscalizacao | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 85 | une_data_modif | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 86 | une_pep_indefinido | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 87 | une_tempo_pendencia_obra | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 88 | une_uc_importetotal | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 89 | une_ordens | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 90 | une_orden_fecha_liberacion | timestamp without time zone | SIM | OUTRO | EVENTO_OU_VIGENCIA |
| 91 | une_numero_pdl | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 92 | une_data_pdl | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 93 | une_data_despacho | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 94 | une_data_energizacao | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 95 | une_data_ativacao | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 96 | une_data_instalacao | timestamp without time zone | SIM | INSTALACAO | EVENTO_OU_VIGENCIA |
| 97 | une_data_implantacao | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 98 | une_data_ult_fiscaliz | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 99 | une_data_ult_valid | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 100 | une_data_unitizacao | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 101 | une_data_vistoria | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 102 | une_protocolo_lic_ambiental | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 103 | une_valor_licenciamento | numeric | SIM | OUTRO | NAO_TEMPORAL |
| 104 | une_obs_licenciamento | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 105 | une_data_conclusao | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 106 | une_latitude | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 107 | une_longitude | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 108 | une_prazo_execucao | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 109 | une_zona | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 110 | une_contrato | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 111 | une_dtcancel | timestamp without time zone | SIM | OUTRO | EVENTO_OU_VIGENCIA |
| 112 | une_prot_avt | numeric | SIM | OUTRO | NAO_TEMPORAL |
| 113 | une_ano_avt | numeric | SIM | OUTRO | NAO_TEMPORAL |
| 114 | data_etl | timestamp without time zone | SIM | ATUALIZACAO_CARGA | ATUALIZACAO_FISICA |
| 115 | dt_insert_lake | timestamp without time zone | SIM | OUTRO | EVENTO_OU_VIGENCIA |
bi_brce_cus.bt_brce_auditoria_aging
Tags semânticas: CLIENTE, CONTRATO, FATURAMENTO, COBRANCA, COMUNICACAO, CONTABIL, TEMPORAL, COMPETENCIA
Temporal: True · Colunas temporais: ref | dt_vencimento | dt_faturamento | anomes_ref · Status histórico: EXIGE_MIN_MAX_NOS_DADOS
Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA
Campos (49)
| # | Campo | Tipo | Nulo | Conceito sugerido | Uso temporal |
|---|---|---|---|---|---|
| 1 | ref | timestamp without time zone | SIM | OUTRO | EVENTO_OU_VIGENCIA |
| 2 | parceiro | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 3 | conta_contrato | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 4 | contrcoletivo | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 5 | doc_fat_coletivo | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 6 | contrato | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 7 | cl | integer | SIM | OUTRO | NAO_TEMPORAL |
| 8 | ref_fat | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 9 | n_parcelamento | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 10 | dt_vencimento | timestamp without time zone | SIM | OUTRO | EVENTO_OU_VIGENCIA |
| 11 | dias | integer | SIM | OUTRO | NAO_TEMPORAL |
| 12 | dt_faturamento | timestamp without time zone | SIM | FATURAMENTO | EVENTO_OU_VIGENCIA |
| 13 | a_vencer | numeric | SIM | OUTRO | NAO_TEMPORAL |
| 14 | aging_1_30_dias | numeric | SIM | COBRANCA | NAO_TEMPORAL |
| 15 | aging_31_60_dias | numeric | SIM | COBRANCA | NAO_TEMPORAL |
| 16 | aging_61_90_dias | numeric | SIM | COBRANCA | NAO_TEMPORAL |
| 17 | aging_91_120_dias | numeric | SIM | COBRANCA | NAO_TEMPORAL |
| 18 | aging_121_150_dias | numeric | SIM | COBRANCA | NAO_TEMPORAL |
| 19 | aging_151_180_dias | numeric | SIM | COBRANCA | NAO_TEMPORAL |
| 20 | aging_181_210_dias | numeric | SIM | COBRANCA | NAO_TEMPORAL |
| 21 | aging_211_240_dias | numeric | SIM | COBRANCA | NAO_TEMPORAL |
| 22 | aging_241_270_dias | numeric | SIM | COBRANCA | NAO_TEMPORAL |
| 23 | aging_271_300_dias | numeric | SIM | COBRANCA | NAO_TEMPORAL |
| 24 | aging_301_330_dias | numeric | SIM | COBRANCA | NAO_TEMPORAL |
| 25 | aging_331_360_dias | numeric | SIM | COBRANCA | NAO_TEMPORAL |
| 26 | aging_361_390_dias | numeric | SIM | COBRANCA | NAO_TEMPORAL |
| 27 | aging_391_420_dias | numeric | SIM | COBRANCA | NAO_TEMPORAL |
| 28 | aging_421_450_dias | numeric | SIM | COBRANCA | NAO_TEMPORAL |
| 29 | aging_451_480_dias | numeric | SIM | COBRANCA | NAO_TEMPORAL |
| 30 | aging_481_510_dias | numeric | SIM | COBRANCA | NAO_TEMPORAL |
| 31 | aging_511_540_dias | numeric | SIM | COBRANCA | NAO_TEMPORAL |
| 32 | aging_541_570_dias | numeric | SIM | COBRANCA | NAO_TEMPORAL |
| 33 | aging_571_600_dias | numeric | SIM | COBRANCA | NAO_TEMPORAL |
| 34 | aging_601_630_dias | numeric | SIM | COBRANCA | NAO_TEMPORAL |
| 35 | aging_631_660_dias | numeric | SIM | COBRANCA | NAO_TEMPORAL |
| 36 | aging_661_690_dias | numeric | SIM | COBRANCA | NAO_TEMPORAL |
| 37 | aging_691_720_dias | numeric | SIM | COBRANCA | NAO_TEMPORAL |
| 38 | aging_721_1800_dias | numeric | SIM | COBRANCA | NAO_TEMPORAL |
| 39 | maior_1800_dias | numeric | SIM | OUTRO | NAO_TEMPORAL |
| 40 | total_em_aberto_fatura | numeric | SIM | FATURAMENTO | NAO_TEMPORAL |
| 41 | total_cont_fatura | numeric | SIM | FATURAMENTO | NAO_TEMPORAL |
| 42 | total_g_terceiro | numeric | SIM | OUTRO | NAO_TEMPORAL |
| 43 | total_g_n_terceiro | numeric | SIM | OUTRO | NAO_TEMPORAL |
| 44 | total_q_imposto_retido | numeric | SIM | CONTABIL | NAO_TEMPORAL |
| 45 | total_a_estatistico | numeric | SIM | OUTRO | NAO_TEMPORAL |
| 46 | grupo | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 47 | total_geral | numeric | SIM | OUTRO | NAO_TEMPORAL |
| 48 | total_geral_s_pqv | numeric | SIM | OUTRO | NAO_TEMPORAL |
| 49 | anomes_ref | character varying | SIM | COMPETENCIA_REFERENCIA | COBERTURA_HISTORICA |
bi_brce_cus.bt_brce_clientes_breakdown
Tags semânticas: CLIENTE, CONTRATO, FATURAMENTO, COBRANCA, COMUNICACAO
Temporal: False · Colunas temporais: · Status histórico: EXIGE_MIN_MAX_NOS_DADOS
Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA
Campos (8)
| # | Campo | Tipo | Nulo | Conceito sugerido | Uso temporal |
|---|---|---|---|---|---|
| 1 | conta_contrato | bigint | SIM | CONTRATO | NAO_TEMPORAL |
| 2 | parceiro | bigint | SIM | CLIENTE | NAO_TEMPORAL |
| 3 | forma_pagamento | character varying | SIM | COBRANCA | NAO_TEMPORAL |
| 4 | fatura_coletiva | character varying | SIM | FATURAMENTO | NAO_TEMPORAL |
| 5 | codigo_domicilio | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 6 | classe_conta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 7 | grupo | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 8 | carac_det_ctas | character varying | SIM | OUTRO | NAO_TEMPORAL |
bi_brce_cus.bt_brce_clientes_vitais_essenciais
Tags semânticas: INSTALACAO, CLIENTE, CONTRATO, CONTATO, REDE_GEO, TEMPORAL, ATUALIZACAO
Temporal: True · Colunas temporais: inicio_contrato | fim_contrato | data_carga · Status histórico: EXIGE_MIN_MAX_NOS_DADOS
Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA
Campos (15)
| # | Campo | Tipo | Nulo | Conceito sugerido | Uso temporal |
|---|---|---|---|---|---|
| 1 | instalacao | character varying | SIM | INSTALACAO | NAO_TEMPORAL |
| 2 | conta_contrato | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 3 | contrato | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 4 | parceiro | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 5 | inicio_contrato | timestamp without time zone | SIM | CONTRATO | EVENTO_OU_VIGENCIA |
| 6 | fim_contrato | timestamp without time zone | SIM | CONTRATO | EVENTO_OU_VIGENCIA |
| 7 | nome | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 8 | municipio | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 9 | bairro | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 10 | celular | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 11 | email | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 12 | tipo | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 13 | descricao | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 14 | data_carga | timestamp without time zone | SIM | ATUALIZACAO_CARGA | ATUALIZACAO_FISICA |
| 15 | classificacao | character varying | SIM | OUTRO | NAO_TEMPORAL |
bi_brce_cus.bt_brce_conta_contrato
Tags semânticas: CLIENTE, CONTRATO, FATURAMENTO, COBRANCA, COMUNICACAO, TEMPORAL
Temporal: True · Colunas temporais: data_criacao | data_modificacao · Status histórico: EXIGE_MIN_MAX_NOS_DADOS
Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA
Campos (33)
| # | Campo | Tipo | Nulo | Conceito sugerido | Uso temporal |
|---|---|---|---|---|---|
| 1 | conta_contrato | bigint | SIM | CONTRATO | NAO_TEMPORAL |
| 2 | parceiro | bigint | SIM | CLIENTE | NAO_TEMPORAL |
| 3 | forma_pagamanto | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 4 | forma_pagamanto_texto | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 5 | procedimento_advertencia | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 6 | procedimento_advertencia_texto | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 7 | motivo_bloqueio_adv | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 8 | motivo_bloqueio_adv_texto | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 9 | grupo_mrp | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 10 | grupo_mrp_texto | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 11 | numero_endereco | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 12 | codigo_domicilio | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 13 | domicilio_texto | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 14 | classe_conta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 15 | classe_conta_texto | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 16 | grupo | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 17 | grupo_texto | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 18 | fatura_coletiva | character varying | SIM | FATURAMENTO | NAO_TEMPORAL |
| 19 | condicao_pagamento | character varying | SIM | COBRANCA | NAO_TEMPORAL |
| 20 | condicao_pagamento_texto | character varying | SIM | COBRANCA | NAO_TEMPORAL |
| 21 | carac_det_ctas | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 22 | carac_det_ctas_texto | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 23 | conta_divergente | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 24 | conta_divergente_texto | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 25 | info_energia | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 26 | impressao_coletiva | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 27 | impressao_coletiva_texto | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 28 | flag_postal | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 29 | data_criacao | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 30 | nome_criacao | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 31 | data_modificacao | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 32 | nome_modificacao | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 33 | estrategia | character varying | SIM | OUTRO | NAO_TEMPORAL |
bi_brce_cus.bt_brce_debts__c
Tags semânticas: INSTALACAO, CLIENTE, COBRANCA, ORDENS, CONTATO, REDE_GEO, COMUNICACAO, TEMPORAL
Temporal: True · Colunas temporais: createddate | createdbyid | lastmodifieddate | lastmodifiedbyid | systemmodstamp | lastactivitydate | expirationdate__c | processdate__c · Status histórico: EXIGE_MIN_MAX_NOS_DADOS
Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA
Campos (39)
| # | Campo | Tipo | Nulo | Conceito sugerido | Uso temporal |
|---|---|---|---|---|---|
| 1 | id | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 2 | ownerid | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 3 | isdeleted | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 4 | name | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 5 | currencyisocode | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 6 | recordtypeid | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 7 | createddate | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 8 | createdbyid | character varying | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 9 | lastmodifieddate | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 10 | lastmodifiedbyid | character varying | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 11 | systemmodstamp | timestamp without time zone | SIM | OUTRO | EVENTO_OU_VIGENCIA |
| 12 | lastactivitydate | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 13 | accountnumber__c | double precision | SIM | CLIENTE | NAO_TEMPORAL |
| 14 | actualdebt__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 15 | contactidentification__c | double precision | SIM | CONTATO | NAO_TEMPORAL |
| 16 | ensurancetype__c | character varying | SIM | COMUNICACAO | NAO_TEMPORAL |
| 17 | expirationdate__c | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 18 | previousdebt__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 19 | processdate__c | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 20 | quoteamount__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 21 | serviceid__c | character varying | SIM | ORDENS | NAO_TEMPORAL |
| 22 | status__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 23 | type__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 24 | accountid__c | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 25 | contactid__c | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 26 | debtantiquity__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 27 | energydebt__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 28 | energyagreementfeedebt__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 29 | externalid__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 30 | financingagreementfeedebt__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 31 | financingfeedebt__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 32 | minpayment__c | double precision | SIM | COBRANCA | NAO_TEMPORAL |
| 33 | pointofdeliverynumber__c | character varying | SIM | INSTALACAO | NAO_TEMPORAL |
| 34 | previousbalanceproductsservices__c | character varying | SIM | ORDENS | NAO_TEMPORAL |
| 35 | previousenergybalance__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 36 | previousfinancingbalance__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 37 | productsservicesdebt__c | character varying | SIM | ORDENS | NAO_TEMPORAL |
| 38 | thirdpartydebt__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 39 | totaldebt__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
bi_brce_cus.bt_brce_dim_cr_cliente
Tags semânticas: INSTALACAO, CLIENTE, CONTRATO, COBRANCA, REDE_GEO, TEMPORAL, COMPETENCIA
Temporal: True · Colunas temporais: ano_mes_selecao · Status histórico: EXIGE_MIN_MAX_NOS_DADOS
Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA
Campos (32)
| # | Campo | Tipo | Nulo | Conceito sugerido | Uso temporal |
|---|---|---|---|---|---|
| 1 | empresa | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 2 | parceiro | bigint | SIM | CLIENTE | NAO_TEMPORAL |
| 3 | conta_contrato | bigint | SIM | CONTRATO | NAO_TEMPORAL |
| 4 | conta_contrato_old | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 5 | conta_contrato_coletiva | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 6 | forma_pagamento | character varying | SIM | COBRANCA | NAO_TEMPORAL |
| 7 | nome | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 8 | tipo_doc | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 9 | classe | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 10 | classe_agrup | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 11 | desc_subclasse | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 12 | grupo | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 13 | desc_classe | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 14 | segmento | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 15 | cod_municipio | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 16 | desc_municipio | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 17 | dna_divida | character varying | SIM | COBRANCA | NAO_TEMPORAL |
| 18 | cluster | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 19 | end_instalacao | character varying | SIM | INSTALACAO | NAO_TEMPORAL |
| 20 | endereco_instalacao | character varying | SIM | INSTALACAO | NAO_TEMPORAL |
| 21 | cidade | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 22 | estado | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 23 | estado_fornecimento_descricao | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 24 | centralizador | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 25 | nome_centralizador | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 26 | oc | bigint | SIM | OUTRO | NAO_TEMPORAL |
| 27 | desc_oc | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 28 | nome_executivo | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 29 | despersonalizado | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 30 | vital | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 31 | origem | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 32 | ano_mes_selecao | character varying | SIM | COMPETENCIA_REFERENCIA | COBERTURA_HISTORICA |
bi_brce_cus.bt_brce_dna_divida
Tags semânticas: CLIENTE, COBRANCA, TEMPORAL, COMPETENCIA
Temporal: True · Colunas temporais: ref | anomes_ref · Status histórico: EXIGE_MIN_MAX_NOS_DADOS
Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA
Campos (9)
| # | Campo | Tipo | Nulo | Conceito sugerido | Uso temporal |
|---|---|---|---|---|---|
| 1 | empresa | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 2 | ref | timestamp without time zone | SIM | OUTRO | EVENTO_OU_VIGENCIA |
| 3 | numero_cliente | bigint | SIM | CLIENTE | NAO_TEMPORAL |
| 4 | segmento | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 5 | estado_cliente | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 6 | valor_devido | numeric | SIM | OUTRO | NAO_TEMPORAL |
| 7 | dna_divida | character varying | SIM | COBRANCA | NAO_TEMPORAL |
| 8 | cluster | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 9 | anomes_ref | character varying | SIM | COMPETENCIA_REFERENCIA | COBERTURA_HISTORICA |
bi_brce_cus.bt_brce_dna_geral
Tags semânticas: CLIENTE, COBRANCA, TEMPORAL, COMPETENCIA
Temporal: True · Colunas temporais: data_transicao | dt_ref | anomes_ref · Status histórico: EXIGE_MIN_MAX_NOS_DADOS
Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA
Campos (17)
| # | Campo | Tipo | Nulo | Conceito sugerido | Uso temporal |
|---|---|---|---|---|---|
| 1 | dt_ref | timestamp without time zone | SIM | OUTRO | EVENTO_OU_VIGENCIA |
| 2 | nu_cliente | bigint | SIM | CLIENTE | NAO_TEMPORAL |
| 3 | estado_cliente | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 4 | classificacao_cliente | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 5 | dna_atual | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 6 | dna_mais_comum | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 7 | pct_dna_mais_comum | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 8 | data_transicao | character varying | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 9 | tipo_transicao | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 10 | valor_pago | numeric | SIM | OUTRO | NAO_TEMPORAL |
| 11 | dna_pagamento | character varying | SIM | COBRANCA | NAO_TEMPORAL |
| 12 | cluster_pag | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 13 | valor_devido | numeric | SIM | OUTRO | NAO_TEMPORAL |
| 14 | dna_div | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 15 | dna_divida_ | character varying | SIM | COBRANCA | NAO_TEMPORAL |
| 16 | cluster_div | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 17 | anomes_ref | character varying | SIM | COMPETENCIA_REFERENCIA | COBERTURA_HISTORICA |
bi_brce_cus.bt_brce_fatura_ede_coletiva
Tags semânticas: CLIENTE, CONTRATO, FATURAMENTO, CONTATO, TEMPORAL, COMPETENCIA
Temporal: True · Colunas temporais: load_date | hora_load_date | data_envio | hora_data_envio | referencia · Status histórico: EXIGE_MIN_MAX_NOS_DADOS
Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA
Campos (16)
| # | Campo | Tipo | Nulo | Conceito sugerido | Uso temporal |
|---|---|---|---|---|---|
| 1 | contractaccount | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 2 | controller | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 3 | invoiceaccess__c | character varying | SIM | FATURAMENTO | NAO_TEMPORAL |
| 4 | load_date | character varying | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 5 | hora_load_date | character varying | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 6 | print_doc | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 7 | email | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 8 | nome_da_conta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 9 | data_envio | character varying | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 10 | hora_data_envio | character varying | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 11 | status | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 12 | bounce_subcategory | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 13 | processo | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 14 | jobid | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 15 | dia | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 16 | referencia | bigint | SIM | COMPETENCIA_REFERENCIA | COBERTURA_HISTORICA |
bi_brce_cus.bt_brce_ordem_cluster_predit
Tags semânticas: CLIENTE, RECLAMACAO, ORDENS, CONTATO, REDE_GEO, COMUNICACAO, TEMPORAL, ATUALIZACAO, COMPETENCIA
Temporal: True · Colunas temporais: anomes | data_abertura | data_fim_regulada | data_visita | data_execucao_visita | data_estado | last_update · Status histórico: EXIGE_MIN_MAX_NOS_DADOS
Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA
Campos (60)
| # | Campo | Tipo | Nulo | Conceito sugerido | Uso temporal |
|---|---|---|---|---|---|
| 1 | distribuidora | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 2 | grupo | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 3 | cluster_cliente | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 4 | anomes | character varying | SIM | COMPETENCIA_REFERENCIA | COBERTURA_HISTORICA |
| 5 | numero_ordem | character varying | SIM | ORDENS | NAO_TEMPORAL |
| 6 | numero_ordem_relac | character varying | SIM | ORDENS | NAO_TEMPORAL |
| 7 | cluster_ordem | character varying | SIM | ORDENS | NAO_TEMPORAL |
| 8 | numero_cliente | bigint | SIM | CLIENTE | NAO_TEMPORAL |
| 9 | numero_caso | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 10 | motivo | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 11 | tipo_caso | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 12 | tipo_ordem | character varying | SIM | ORDENS | NAO_TEMPORAL |
| 13 | cod_servico | character varying | SIM | ORDENS | NAO_TEMPORAL |
| 14 | des_servico | character varying | SIM | ORDENS | NAO_TEMPORAL |
| 15 | cod_etapa | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 16 | descricao_etapa | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 17 | cod_retorno | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 18 | descricao_retorno | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 19 | area_responsavel | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 20 | responsavel | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 21 | negocio | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 22 | regulada | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 23 | estado_ordem | character varying | SIM | ORDENS | NAO_TEMPORAL |
| 24 | status_ordem | character varying | SIM | ORDENS | NAO_TEMPORAL |
| 25 | data_abertura | character varying | SIM | COMUNICACAO | EVENTO_OU_VIGENCIA |
| 26 | data_fim_regulada | character varying | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 27 | controle_prazo | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 28 | data_visita | character varying | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 29 | data_execucao_visita | character varying | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 30 | status_prazo | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 31 | farol_prazo | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 32 | data_estado | character varying | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 33 | rol_ingresso | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 34 | rol_visita | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 35 | acao_retorno | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 36 | efeito_tempo_descricao | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 37 | municipio | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 38 | ind_serv_executado | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 39 | ind_encerra_ordem | character varying | SIM | ORDENS | NAO_TEMPORAL |
| 40 | ind_def_tec_client | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 41 | ind_def_tec_empres | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 42 | ind_pendencia | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 43 | ind_efeito_tempo | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 44 | ind_movimenta_med | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 45 | ind_procedente | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 46 | rec_iguais | integer | SIM | OUTRO | NAO_TEMPORAL |
| 47 | rec_diversas | integer | SIM | OUTRO | NAO_TEMPORAL |
| 48 | inf_repetidas | integer | SIM | OUTRO | NAO_TEMPORAL |
| 49 | ouvidoria | integer | SIM | RECLAMACAO | NAO_TEMPORAL |
| 50 | judicial | integer | SIM | OUTRO | NAO_TEMPORAL |
| 51 | aneel | integer | SIM | RECLAMACAO | NAO_TEMPORAL |
| 52 | peso_rec_iguais | integer | SIM | OUTRO | NAO_TEMPORAL |
| 53 | peso_rec_diversas | integer | SIM | OUTRO | NAO_TEMPORAL |
| 54 | peso_inf_repetidas | integer | SIM | OUTRO | NAO_TEMPORAL |
| 55 | peso_ouvidoria | integer | SIM | RECLAMACAO | NAO_TEMPORAL |
| 56 | peso_judicial | integer | SIM | OUTRO | NAO_TEMPORAL |
| 57 | peso_aneel | integer | SIM | RECLAMACAO | NAO_TEMPORAL |
| 58 | nota_f | integer | SIM | OUTRO | NAO_TEMPORAL |
| 59 | last_update | character varying | SIM | ATUALIZACAO_CARGA | ATUALIZACAO_FISICA |
| 60 | qtd_recontatos | bigint | SIM | CONTATO | NAO_TEMPORAL |
bi_brce_cus.bt_brce_ren1000
Tags semânticas: CLIENTE, RECLAMACAO, ORDENS, GD, COMUNICACAO, TEMPORAL, COMPETENCIA
Temporal: True · Colunas temporais: data_abertura | data_encerramento | ano_mes_compensacao · Status histórico: EXIGE_MIN_MAX_NOS_DADOS
Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA
Campos (18)
| # | Campo | Tipo | Nulo | Conceito sugerido | Uso temporal |
|---|---|---|---|---|---|
| 1 | flag_origem | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 2 | protocolo | bigint | SIM | OUTRO | NAO_TEMPORAL |
| 3 | protocolo_visita | bigint | SIM | OUTRO | NAO_TEMPORAL |
| 4 | numero_cliente | bigint | SIM | CLIENTE | NAO_TEMPORAL |
| 5 | numero_ordem | character varying | SIM | ORDENS | NAO_TEMPORAL |
| 6 | data_abertura | character varying | SIM | COMUNICACAO | EVENTO_OU_VIGENCIA |
| 7 | data_encerramento | character varying | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 8 | tempo_total_atendimento_os | double precision | SIM | RECLAMACAO | NAO_TEMPORAL |
| 9 | prazo_regulamentar | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 10 | classificacao_aneel | character varying | SIM | RECLAMACAO | NAO_TEMPORAL |
| 11 | submotivo | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 12 | canal_origem | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 13 | procedencia_do_caso | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 14 | indice_procedencia_ordem_servico | character varying | SIM | ORDENS | NAO_TEMPORAL |
| 15 | providencias_adotadas | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 16 | compensacao | numeric | SIM | GD | NAO_TEMPORAL |
| 17 | ano_mes_compensacao | character varying | SIM | GD | COBERTURA_HISTORICA |
| 18 | demais_informacoes | character varying | SIM | OUTRO | NAO_TEMPORAL |