Enel Brasil

ENEL RJ · bi_brrj_cus · objetos 1-20

Objetos e campos Redshift de ENEL RJ, schema bi_brrj_cus.
Base RCO / Objetos / ENEL RJ / bi_brrj_cus
20 objetos nesta página. Conteúdo gerado diretamente do catálogo estruturado e do arquivo RAG do pacote oficial.
bi_brrj_cus.agg_brrj_agingagrupbi_brrj_cus.agg_brrj_agingdet_parcbi_brrj_cus.agg_brrj_indicadores_cadastrobi_brrj_cus.bt_brrj_act_fechamento_contrato_riobi_brrj_cus.bt_brrj_act_ordem_grandes_clientes_riobi_brrj_cus.bt_brrj_act_ordem_grandes_clientes_rio_bkp20240219bi_brrj_cus.bt_brrj_arquivos_siase_2025bi_brrj_cus.bt_brrj_base_kpi_qualidadebi_brrj_cus.bt_brrj_cad_cli_comp_id_2005__abi_brrj_cus.bt_brrj_contratobi_brrj_cus.bt_brrj_dados_contato_cruzamentobi_brrj_cus.bt_brrj_despersonalizadobi_brrj_cus.bt_brrj_dim_cr_faturabi_brrj_cus.bt_brrj_efatura_gabi_brrj_cus.bt_brrj_efatura_gbbi_brrj_cus.bt_brrj_equipamentobi_brrj_cus.bt_brrj_gd_instalacaobi_brrj_cus.bt_brrj_implantados_mesbi_brrj_cus.bt_brrj_insp_e_fup_perdasbi_brrj_cus.bt_brrj_instalacao
{'physical_metadata': 'confirmed', 'semantic_classification': 'suggested', 'physical_history_measurement': 'pending'}

bi_brrj_cus.agg_brrj_agingagrup

Empresa
ENEL RJ
Tipo
BASE TABLE
Taxonomia
Cobrança, dívida e arrecadação
Prioridade TI
P1
Família de schema
bi_brxx_cus
Replicação
REPLICA_3_EMPRESAS

Tags semânticas: CLIENTE, CONTRATO, FATURAMENTO, COBRANCA, PERDAS, ORDENS, COMUNICACAO, CONTABIL, RISCO, 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 (69)

#CampoTipoNuloConceito sugeridoUso temporal
1empresaintegerSIMOUTRONAO_TEMPORAL
2reftimestamp without time zoneSIMOUTROEVENTO_OU_VIGENCIA
3parceirocharacter varyingSIMCLIENTENAO_TEMPORAL
4conta_contratocharacter varyingSIMCONTRATONAO_TEMPORAL
5contrcoletivocharacter varyingSIMOUTRONAO_TEMPORAL
6doc_fat_coletivocharacter varyingSIMOUTRONAO_TEMPORAL
7contratocharacter varyingSIMCONTRATONAO_TEMPORAL
8clintegerSIMOUTRONAO_TEMPORAL
9ref_fatcharacter varyingSIMOUTRONAO_TEMPORAL
10n_parcelamentocharacter varyingSIMOUTRONAO_TEMPORAL
11dt_vencimentotimestamp without time zoneSIMOUTROEVENTO_OU_VIGENCIA
12diasintegerSIMOUTRONAO_TEMPORAL
13dt_faturamentotimestamp without time zoneSIMFATURAMENTOEVENTO_OU_VIGENCIA
14a_vencernumericSIMOUTRONAO_TEMPORAL
15dias_1_30numericSIMOUTRONAO_TEMPORAL
16dias_31_60numericSIMOUTRONAO_TEMPORAL
17dias_61_90numericSIMOUTRONAO_TEMPORAL
18dias_91_120numericSIMOUTRONAO_TEMPORAL
19dias_121_150numericSIMOUTRONAO_TEMPORAL
20dias_151_180numericSIMOUTRONAO_TEMPORAL
21dias_181_210numericSIMOUTRONAO_TEMPORAL
22dias_211_240numericSIMOUTRONAO_TEMPORAL
23dias_241_270numericSIMOUTRONAO_TEMPORAL
24dias_271_300numericSIMOUTRONAO_TEMPORAL
25dias_301_330numericSIMOUTRONAO_TEMPORAL
26dias_331_360numericSIMOUTRONAO_TEMPORAL
27dias_361_390numericSIMOUTRONAO_TEMPORAL
28dias_391_420numericSIMOUTRONAO_TEMPORAL
29dias_421_450numericSIMOUTRONAO_TEMPORAL
30dias_451_480numericSIMOUTRONAO_TEMPORAL
31dias_481_510numericSIMOUTRONAO_TEMPORAL
32dias_511_540numericSIMOUTRONAO_TEMPORAL
33dias_541_570numericSIMOUTRONAO_TEMPORAL
34dias_571_600numericSIMOUTRONAO_TEMPORAL
35dias_601_630numericSIMOUTRONAO_TEMPORAL
36dias_631_660numericSIMOUTRONAO_TEMPORAL
37dias_661_690numericSIMOUTRONAO_TEMPORAL
38dias_691_720numericSIMOUTRONAO_TEMPORAL
39dias_721_1800numericSIMOUTRONAO_TEMPORAL
40maior_1800_diasnumericSIMOUTRONAO_TEMPORAL
41total_em_aberto_faturanumericSIMFATURAMENTONAO_TEMPORAL
42total_cont_faturanumericSIMFATURAMENTONAO_TEMPORAL
43total_g_terceironumericSIMOUTRONAO_TEMPORAL
44total_g_n_terceironumericSIMOUTRONAO_TEMPORAL
45total_q_imposto_retidonumericSIMCONTABILNAO_TEMPORAL
46total_a_estatisticonumericSIMOUTRONAO_TEMPORAL
47grupocharacter varyingSIMOUTRONAO_TEMPORAL
48segmentocharacter varyingSIMOUTRONAO_TEMPORAL
49desc_classecharacter varyingSIMOUTRONAO_TEMPORAL
50castigocharacter varyingSIMOUTRONAO_TEMPORAL
51xbnrcharacter varyingSIMOUTRONAO_TEMPORAL
52corr_faturaintegerSIMFATURAMENTONAO_TEMPORAL
53tipo_doccharacter varyingSIMOUTRONAO_TEMPORAL
54numero_clientebigintSIMCLIENTENAO_TEMPORAL
55castigo_2character varyingSIMOUTRONAO_TEMPORAL
56classeintegerSIMOUTRONAO_TEMPORAL
57despersonabooleanSIMOUTRONAO_TEMPORAL
58recoveryratebooleanSIMOUTRONAO_TEMPORAL
59tipo_dividacharacter varyingSIMCOBRANCANAO_TEMPORAL
60corte_restritobooleanSIMORDENSNAO_TEMPORAL
61pend_judicialbooleanSIMOUTRONAO_TEMPORAL
62pend_bancariabooleanSIMOUTRONAO_TEMPORAL
63toibooleanSIMPERDASNAO_TEMPORAL
64area_riscobooleanSIMRISCONAO_TEMPORAL
65antigcharacter varyingSIMOUTRONAO_TEMPORAL
66detalhe_dividacharacter varyingSIMCOBRANCANAO_TEMPORAL
67pddbooleanSIMCOBRANCANAO_TEMPORAL
68nomecharacter varyingSIMOUTRONAO_TEMPORAL
69anomes_refcharacter varyingSIMCOMPETENCIA_REFERENCIACOBERTURA_HISTORICA
{'physical_metadata': 'confirmed', 'semantic_classification': 'suggested', 'physical_history_measurement': 'pending'}

bi_brrj_cus.agg_brrj_agingdet_parc

Empresa
ENEL RJ
Tipo
BASE TABLE
Taxonomia
Cobrança, dívida e arrecadação
Prioridade TI
P1
Família de schema
bi_brxx_cus
Replicação
REPLICA_3_EMPRESAS

Tags semânticas: CLIENTE, CONTRATO, FATURAMENTO, COBRANCA, PERDAS, ORDENS, COMUNICACAO, RISCO, TEMPORAL, COMPETENCIA

Temporal: True · Colunas temporais: ref | dt_contrato | referencia | dt_vencimento | 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 (70)

#CampoTipoNuloConceito sugeridoUso temporal
1empresaintegerSIMOUTRONAO_TEMPORAL
2reftimestamp without time zoneSIMOUTROEVENTO_OU_VIGENCIA
3parceirocharacter varyingSIMCLIENTENAO_TEMPORAL
4conta_contratocharacter varyingSIMCONTRATONAO_TEMPORAL
5contr_coletivocharacter varyingSIMOUTRONAO_TEMPORAL
6contratocharacter varyingSIMCONTRATONAO_TEMPORAL
7dt_contratotimestamp without time zoneSIMCONTRATOEVENTO_OU_VIGENCIA
8clcharacter varyingSIMOUTRONAO_TEMPORAL
9referenciacharacter varyingSIMCOMPETENCIA_REFERENCIACOBERTURA_HISTORICA
10nu_documentocharacter varyingSIMOUTRONAO_TEMPORAL
11repetcharacter varyingSIMOUTRONAO_TEMPORAL
12it_doccharacter varyingSIMOUTRONAO_TEMPORAL
13subitemcharacter varyingSIMOUTRONAO_TEMPORAL
14estcharacter varyingSIMOUTRONAO_TEMPORAL
15opercharacter varyingSIMOUTRONAO_TEMPORAL
16subopcharacter varyingSIMOUTRONAO_TEMPORAL
17diasintegerSIMOUTRONAO_TEMPORAL
18dt_vencimentotimestamp without time zoneSIMOUTROEVENTO_OU_VIGENCIA
19a_vencernumericSIMOUTRONAO_TEMPORAL
20aging_1_30_diasnumericSIMCOBRANCANAO_TEMPORAL
21aging_31_60_diasnumericSIMCOBRANCANAO_TEMPORAL
22aging_61_90_diasnumericSIMCOBRANCANAO_TEMPORAL
23aging_91_120_diasnumericSIMCOBRANCANAO_TEMPORAL
24aging_121_150_diasnumericSIMCOBRANCANAO_TEMPORAL
25aging_151_180_diasnumericSIMCOBRANCANAO_TEMPORAL
26aging_181_210_diasnumericSIMCOBRANCANAO_TEMPORAL
27aging_211_240_diasnumericSIMCOBRANCANAO_TEMPORAL
28aging_241_270_diasnumericSIMCOBRANCANAO_TEMPORAL
29aging_271_300_diasnumericSIMCOBRANCANAO_TEMPORAL
30aging_301_330_diasnumericSIMCOBRANCANAO_TEMPORAL
31aging_331_360_diasnumericSIMCOBRANCANAO_TEMPORAL
32aging_361_390_diasnumericSIMCOBRANCANAO_TEMPORAL
33aging_391_420_diasnumericSIMCOBRANCANAO_TEMPORAL
34aging_421_450_diasnumericSIMCOBRANCANAO_TEMPORAL
35aging_451_480_diasnumericSIMCOBRANCANAO_TEMPORAL
36aging_481_510_diasnumericSIMCOBRANCANAO_TEMPORAL
37aging_511_540_diasnumericSIMCOBRANCANAO_TEMPORAL
38aging_541_570_diasnumericSIMCOBRANCANAO_TEMPORAL
39aging_571_600_diasnumericSIMCOBRANCANAO_TEMPORAL
40aging_601_630_diasnumericSIMCOBRANCANAO_TEMPORAL
41aging_631_660_diasnumericSIMCOBRANCANAO_TEMPORAL
42aging_661_690_diasnumericSIMCOBRANCANAO_TEMPORAL
43aging_691_720_diasnumericSIMCOBRANCANAO_TEMPORAL
44aging_721_1800_diasnumericSIMCOBRANCANAO_TEMPORAL
45mais_de_1800_diasnumericSIMOUTRONAO_TEMPORAL
46total_aberto_faturanumericSIMFATURAMENTONAO_TEMPORAL
47num_parcelamentocharacter varyingSIMOUTRONAO_TEMPORAL
48grupocharacter varyingSIMOUTRONAO_TEMPORAL
49segmentocharacter varyingSIMOUTRONAO_TEMPORAL
50desc_classecharacter varyingSIMOUTRONAO_TEMPORAL
51castigocharacter varyingSIMOUTRONAO_TEMPORAL
52xbnrcharacter varyingSIMOUTRONAO_TEMPORAL
53corr_faturaintegerSIMFATURAMENTONAO_TEMPORAL
54tipo_doccharacter varyingSIMOUTRONAO_TEMPORAL
55numero_clientebigintSIMCLIENTENAO_TEMPORAL
56castigo_2character varyingSIMOUTRONAO_TEMPORAL
57classeintegerSIMOUTRONAO_TEMPORAL
58despersonabooleanSIMOUTRONAO_TEMPORAL
59recoveryratebooleanSIMOUTRONAO_TEMPORAL
60tipo_dividacharacter varyingSIMCOBRANCANAO_TEMPORAL
61corte_restritobooleanSIMORDENSNAO_TEMPORAL
62pend_judicialbooleanSIMOUTRONAO_TEMPORAL
63pend_bancariabooleanSIMOUTRONAO_TEMPORAL
64toibooleanSIMPERDASNAO_TEMPORAL
65area_riscobooleanSIMRISCONAO_TEMPORAL
66antigcharacter varyingSIMOUTRONAO_TEMPORAL
67detalhe_dividacharacter varyingSIMCOBRANCANAO_TEMPORAL
68pddbooleanSIMCOBRANCANAO_TEMPORAL
69nomecharacter varyingSIMOUTRONAO_TEMPORAL
70ano_mes_selecaocharacter varyingSIMCOMPETENCIA_REFERENCIACOBERTURA_HISTORICA
{'physical_metadata': 'confirmed', 'semantic_classification': 'suggested', 'physical_history_measurement': 'pending'}

bi_brrj_cus.agg_brrj_indicadores_cadastro

Empresa
ENEL RJ
Tipo
BASE TABLE
Taxonomia
Cliente, instalação e contrato
Prioridade TI
P1
Família de schema
bi_brxx_cus
Replicação
REPLICA_3_EMPRESAS

Tags semânticas: INSTALACAO, CLIENTE, FATURAMENTO, CONTATO, REDE_GEO, COMUNICACAO, TEMPORAL

Temporal: True · Colunas temporais: dia · Status histórico: EXIGE_MIN_MAX_NOS_DADOS

Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA

Campos (19)

#CampoTipoNuloConceito sugeridoUso temporal
1companyid_c_pointofdeliverycharacter varyingSIMINSTALACAONAO_TEMPORAL
2diatimestamp without time zoneSIMOUTROEVENTO_OU_VIGENCIA
3dashcharacter varyingSIMOUTRONAO_TEMPORAL
4literal_municipality__ccharacter varyingSIMREDE_GEONAO_TEMPORAL
5tipo_contacharacter varyingSIMOUTRONAO_TEMPORAL
6segmenttype__ccharacter varyingSIMOUTRONAO_TEMPORAL
7classe_brcharacter varyingSIMOUTRONAO_TEMPORAL
8subclasse_brcharacter varyingSIMOUTRONAO_TEMPORAL
9clientesativosbigintSIMCLIENTENAO_TEMPORAL
10despersonalizadosdouble precisionSIMOUTRONAO_TEMPORAL
11telefonedouble precisionSIMCONTATONAO_TEMPORAL
12celularbigintSIMCONTATONAO_TEMPORAL
13fixobigintSIMOUTRONAO_TEMPORAL
14emailbigintSIMCONTATONAO_TEMPORAL
15suficientesbigintSIMOUTRONAO_TEMPORAL
16cpfbigintSIMOUTRONAO_TEMPORAL
17cnpjbigintSIMOUTRONAO_TEMPORAL
18electrodependant__cbigintSIMOUTRONAO_TEMPORAL
19faturadigitalbigintSIMFATURAMENTONAO_TEMPORAL
{'physical_metadata': 'confirmed', 'semantic_classification': 'suggested', 'physical_history_measurement': 'pending'}

bi_brrj_cus.bt_brrj_act_fechamento_contrato_rio

Empresa
ENEL RJ
Tipo
BASE TABLE
Taxonomia
Cliente, instalação e contrato
Prioridade TI
P1
Família de schema
bi_brxx_cus
Replicação
REPLICA_3_EMPRESAS

Tags semânticas: CLIENTE, CONTRATO, MEDIDOR, FATURAMENTO, ORDENS, GD, CONTABIL, RISCO, TEMPORAL, ATUALIZACAO

Temporal: True · Colunas temporais: typology_start_date | dte_asset_start_date | dte_asset_end_date | dte_ebill_activation_date | dte_ebill_deactivation_date | dte_row_last_update_date | dte_validity_start_date | dte_last_update_asset · Status histórico: EXIGE_MIN_MAX_NOS_DADOS

Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA

Campos (65)

#CampoTipoNuloConceito sugeridoUso temporal
1pk_asset_idcharacter varyingSIMMEDIDORNAO_TEMPORAL
2pk_contract_idcharacter varyingSIMCONTRATONAO_TEMPORAL
3cdc_pod_idcharacter varyingSIMOUTRONAO_TEMPORAL
4fk_external_asset_idcharacter varyingSIMMEDIDORNAO_TEMPORAL
5fk_local_customer_idcharacter varyingSIMCLIENTENAO_TEMPORAL
6sds_aggregate_cluster_localcharacter varyingSIMOUTRONAO_TEMPORAL
7lds_local_segmentcharacter varyingSIMOUTRONAO_TEMPORAL
8sds_classe_localcharacter varyingSIMOUTRONAO_TEMPORAL
9typology_start_datetimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
10sds_typologycharacter varyingSIMOUTRONAO_TEMPORAL
11sds_asset_status_localcharacter varyingSIMMEDIDORNAO_TEMPORAL
12fk_external_local_customer_idcharacter varyingSIMCLIENTENAO_TEMPORAL
13sds_marketcharacter varyingSIMOUTRONAO_TEMPORAL
14sds_voltage_levelcharacter varyingSIMOUTRONAO_TEMPORAL
15qty_voltagecharacter varyingSIMOUTRONAO_TEMPORAL
16sds_aggregate_clustercharacter varyingSIMOUTRONAO_TEMPORAL
17qty_declared_yearly_consumptionbigintSIMOUTRONAO_TEMPORAL
18sds_origin_marketcharacter varyingSIMOUTRONAO_TEMPORAL
19sds_use_typecharacter varyingSIMOUTRONAO_TEMPORAL
20sds_global_segmentcharacter varyingSIMOUTRONAO_TEMPORAL
21lds_economic_sectorcharacter varyingSIMOUTRONAO_TEMPORAL
22lds_local_economic_sectorcharacter varyingSIMOUTRONAO_TEMPORAL
23sds_contracted_powercharacter varyingSIMCONTRATONAO_TEMPORAL
24qty_contracted_powerdouble precisionSIMCONTRATONAO_TEMPORAL
25sds_contracted_power_peakcharacter varyingSIMCONTRATONAO_TEMPORAL
26sds_meter_classcharacter varyingSIMMEDIDORNAO_TEMPORAL
27mds_companycharacter varyingSIMOUTRONAO_TEMPORAL
28lds_acquisition_channelcharacter varyingSIMOUTRONAO_TEMPORAL
29cdc_counter_serial_numbercharacter varyingSIMOUTRONAO_TEMPORAL
30dte_asset_start_datetimestamp without time zoneSIMMEDIDOREVENTO_OU_VIGENCIA
31dte_asset_end_datetimestamp without time zoneSIMMEDIDOREVENTO_OU_VIGENCIA
32lds_asset_citycharacter varyingSIMMEDIDORNAO_TEMPORAL
33cdc_asset_postal_codecharacter varyingSIMMEDIDORNAO_TEMPORAL
34lds_asset_provincecharacter varyingSIMMEDIDORNAO_TEMPORAL
35lds_asset_regioncharacter varyingSIMMEDIDORNAO_TEMPORAL
36dte_ebill_activation_datetimestamp without time zoneSIMORDENSEVENTO_OU_VIGENCIA
37dte_ebill_deactivation_datetimestamp without time zoneSIMORDENSEVENTO_OU_VIGENCIA
38mds_ebill_deactivation_reasoncharacter varyingSIMORDENSNAO_TEMPORAL
39fln_is_residentbigintSIMOUTRONAO_TEMPORAL
40lds_activation_modecharacter varyingSIMORDENSNAO_TEMPORAL
41mds_termination_modecharacter varyingSIMOUTRONAO_TEMPORAL
42lds_activation_sub_modecharacter varyingSIMORDENSNAO_TEMPORAL
43mds_termination_sub_modecharacter varyingSIMOUTRONAO_TEMPORAL
44fln_fiber_in_bundlebooleanSIMOUTRONAO_TEMPORAL
45fln_bundled_enelxbooleanSIMOUTRONAO_TEMPORAL
46fln_risk_areasbooleanSIMRISCONAO_TEMPORAL
47lds_concession_areacharacter varyingSIMOUTRONAO_TEMPORAL
48lds_distributorcharacter varyingSIMCONTABILNAO_TEMPORAL
49mds_billing_frequencycharacter varyingSIMFATURAMENTONAO_TEMPORAL
50fln_customer_disconnectivitybooleanSIMCLIENTENAO_TEMPORAL
51fln_smart_meterbooleanSIMMEDIDORNAO_TEMPORAL
52fln_automatic_debitbooleanSIMOUTRONAO_TEMPORAL
53dte_row_last_update_datetimestamp without time zoneSIMATUALIZACAO_CARGAATUALIZACAO_FISICA
54dte_validity_start_datetimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
55sds_subclassecharacter varyingSIMOUTRONAO_TEMPORAL
56sds_generation_capabilitycharacter varyingSIMGDNAO_TEMPORAL
57sds_tension_groupcharacter varyingSIMOUTRONAO_TEMPORAL
58sds_tariff_subgroupcharacter varyingSIMOUTRONAO_TEMPORAL
59sds_tariff_modecharacter varyingSIMOUTRONAO_TEMPORAL
60fln_top_largebooleanSIMOUTRONAO_TEMPORAL
61sds_top_large_segmentationcharacter varyingSIMOUTRONAO_TEMPORAL
62qty_average_consumptionnumericSIMOUTRONAO_TEMPORAL
63lds_countrycharacter varyingSIMOUTRONAO_TEMPORAL
64dte_last_update_assettimestamp without time zoneSIMMEDIDORATUALIZACAO_FISICA
65dte_fech_refcharacter varyingSIMOUTRONAO_TEMPORAL
{'physical_metadata': 'confirmed', 'semantic_classification': 'suggested', 'physical_history_measurement': 'pending'}

bi_brrj_cus.bt_brrj_act_ordem_grandes_clientes_rio

Empresa
ENEL RJ
Tipo
BASE TABLE
Taxonomia
Cliente, instalação e contrato
Prioridade TI
P1
Família de schema
bi_brxx_cus
Replicação
REPLICA_3_EMPRESAS

Tags semânticas: INSTALACAO, CONTRATO, MEDIDOR, ORDENS, REDE_GEO, TEMPORAL, ATUALIZACAO

Temporal: True · Colunas temporais: dte_ordem_ingresso_data | dte_estado_ordem_data | dte_visita_data | dte_exec_visita_data | dte_activation_date | dte_sap_validation_date | dte_caso_criacao_data | dte_caso_status_data | dte_insert_lake | dte_last_update | dte_data_fim_regulada · Status histórico: EXIGE_MIN_MAX_NOS_DADOS

Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA

Campos (53)

#CampoTipoNuloConceito sugeridoUso temporal
1pk_ordem_idcharacter varyingSIMORDENSNAO_TEMPORAL
2dte_ordem_ingresso_datatimestamp without time zoneSIMORDENSEVENTO_OU_VIGENCIA
3lds_tipo_ordem_idcharacter varyingSIMORDENSNAO_TEMPORAL
4sds_descricao_tipo_ordemcharacter varyingSIMORDENSNAO_TEMPORAL
5lds_servico_idcharacter varyingSIMORDENSNAO_TEMPORAL
6lds_descricao_servicocharacter varyingSIMORDENSNAO_TEMPORAL
7dte_estado_ordem_datatimestamp without time zoneSIMORDENSEVENTO_OU_VIGENCIA
8lds_estado_idcharacter varyingSIMOUTRONAO_TEMPORAL
9sds_status_ordemcharacter varyingSIMORDENSNAO_TEMPORAL
10sds_status_estado_ordemcharacter varyingSIMORDENSNAO_TEMPORAL
11lds_etapa_idcharacter varyingSIMOUTRONAO_TEMPORAL
12lds_descricao_etapacharacter varyingSIMOUTRONAO_TEMPORAL
13lds_retorno_idcharacter varyingSIMOUTRONAO_TEMPORAL
14lds_descricao_retornocharacter varyingSIMOUTRONAO_TEMPORAL
15dte_visita_datatimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
16dte_exec_visita_datatimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
17qty_seq_idintegerSIMOUTRONAO_TEMPORAL
18cdc_ordem_relacionadacharacter varyingSIMORDENSNAO_TEMPORAL
19fk_nr_orc_gomnetcharacter varyingSIMOUTRONAO_TEMPORAL
20cdc_instalacao_idcharacter varyingSIMINSTALACAONAO_TEMPORAL
21qty_contracted_powerintegerSIMCONTRATONAO_TEMPORAL
22qty_contracted_power_peakintegerSIMCONTRATONAO_TEMPORAL
23sds_razao_socialcharacter varyingSIMOUTRONAO_TEMPORAL
24fk_asset_idcharacter varyingSIMMEDIDORNAO_TEMPORAL
25pk_external_asset_idcharacter varyingSIMMEDIDORNAO_TEMPORAL
26sds_cluster_localcharacter varyingSIMOUTRONAO_TEMPORAL
27lds_segmento_localcharacter varyingSIMOUTRONAO_TEMPORAL
28sds_tipo_tarifacharacter varyingSIMOUTRONAO_TEMPORAL
29qty_temp_max_servicointegerSIMORDENSNAO_TEMPORAL
30sds_ind_tempocharacter varyingSIMOUTRONAO_TEMPORAL
31lds_municipiocharacter varyingSIMREDE_GEONAO_TEMPORAL
32sds_voltage_levelcharacter varyingSIMOUTRONAO_TEMPORAL
33sds_mercadocharacter varyingSIMOUTRONAO_TEMPORAL
34dte_activation_datetimestamp without time zoneSIMORDENSEVENTO_OU_VIGENCIA
35dte_sap_validation_datetimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
36sds_dispersioncharacter varyingSIMOUTRONAO_TEMPORAL
37lds_distribuicao_areacharacter varyingSIMOUTRONAO_TEMPORAL
38fk_caso_idcharacter varyingSIMOUTRONAO_TEMPORAL
39lds_caso_status_localcharacter varyingSIMOUTRONAO_TEMPORAL
40lds_companycharacter varyingSIMOUTRONAO_TEMPORAL
41sds_servico_salesforce_localcharacter varyingSIMORDENSNAO_TEMPORAL
42dte_caso_criacao_datatimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
43dte_caso_status_datatimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
44lds_suspension_cause_localcharacter varyingSIMOUTRONAO_TEMPORAL
45sds_causa_suspensaocharacter varyingSIMOUTRONAO_TEMPORAL
46dte_insert_laketimestamp without time zoneSIMOUTROEVENTO_OU_VIGENCIA
47dte_last_updatetimestamp without time zoneSIMATUALIZACAO_CARGAATUALIZACAO_FISICA
48qty_diasintegerSIMOUTRONAO_TEMPORAL
49dte_data_fim_reguladatimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
50lds_situacaocharacter varyingSIMOUTRONAO_TEMPORAL
51sds_status_prazocharacter varyingSIMOUTRONAO_TEMPORAL
52lds_ind_procedentecharacter varyingSIMOUTRONAO_TEMPORAL
53lds_sucursalcharacter varyingSIMREDE_GEONAO_TEMPORAL
{'physical_metadata': 'confirmed', 'semantic_classification': 'suggested', 'physical_history_measurement': 'pending'}

bi_brrj_cus.bt_brrj_act_ordem_grandes_clientes_rio_bkp20240219

Empresa
ENEL RJ
Tipo
BASE TABLE
Taxonomia
Cliente, instalação e contrato
Prioridade TI
P1
Família de schema
bi_brxx_cus
Replicação
REPLICA_3_EMPRESAS

Tags semânticas: INSTALACAO, CONTRATO, MEDIDOR, ORDENS, REDE_GEO, TEMPORAL

Temporal: True · Colunas temporais: dte_ordem_ingresso_data | dte_estado_ordem_data | dte_visita_data | dte_exec_visita_data | dte_activation_date | dte_sap_validation_date | dte_compliance_deadline_data | dte_final_compliance_data | dte_caso_criacao_data | dte_caso_status_data | dte_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 (49)

#CampoTipoNuloConceito sugeridoUso temporal
1pk_ordem_idcharacter varyingSIMORDENSNAO_TEMPORAL
2dte_ordem_ingresso_datatimestamp without time zoneSIMORDENSEVENTO_OU_VIGENCIA
3lds_tipo_ordem_idcharacter varyingSIMORDENSNAO_TEMPORAL
4sds_descricao_tipo_ordemcharacter varyingSIMORDENSNAO_TEMPORAL
5lds_servico_idcharacter varyingSIMORDENSNAO_TEMPORAL
6lds_descricao_servicocharacter varyingSIMORDENSNAO_TEMPORAL
7dte_estado_ordem_datatimestamp without time zoneSIMORDENSEVENTO_OU_VIGENCIA
8lds_estado_idcharacter varyingSIMOUTRONAO_TEMPORAL
9sds_status_ordemcharacter varyingSIMORDENSNAO_TEMPORAL
10sds_status_estado_ordemcharacter varyingSIMORDENSNAO_TEMPORAL
11lds_etapa_idcharacter varyingSIMOUTRONAO_TEMPORAL
12lds_descricao_etapacharacter varyingSIMOUTRONAO_TEMPORAL
13lds_retorno_idcharacter varyingSIMOUTRONAO_TEMPORAL
14lds_descricao_retornocharacter varyingSIMOUTRONAO_TEMPORAL
15dte_visita_datatimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
16dte_exec_visita_datatimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
17qty_seq_idintegerSIMOUTRONAO_TEMPORAL
18cdc_ordem_relacionadacharacter varyingSIMORDENSNAO_TEMPORAL
19fk_nr_orc_gomnetcharacter varyingSIMOUTRONAO_TEMPORAL
20cdc_instalacao_idcharacter varyingSIMINSTALACAONAO_TEMPORAL
21qty_contracted_powerintegerSIMCONTRATONAO_TEMPORAL
22qty_contracted_power_peakintegerSIMCONTRATONAO_TEMPORAL
23sds_razao_socialcharacter varyingSIMOUTRONAO_TEMPORAL
24fk_asset_idcharacter varyingSIMMEDIDORNAO_TEMPORAL
25pk_external_asset_idcharacter varyingSIMMEDIDORNAO_TEMPORAL
26sds_cluster_localcharacter varyingSIMOUTRONAO_TEMPORAL
27lds_segmento_localcharacter varyingSIMOUTRONAO_TEMPORAL
28sds_tipo_tarifacharacter varyingSIMOUTRONAO_TEMPORAL
29qty_temp_max_servicointegerSIMORDENSNAO_TEMPORAL
30sds_ind_tempocharacter varyingSIMOUTRONAO_TEMPORAL
31lds_municipiocharacter varyingSIMREDE_GEONAO_TEMPORAL
32sds_voltage_levelcharacter varyingSIMOUTRONAO_TEMPORAL
33sds_mercadocharacter varyingSIMOUTRONAO_TEMPORAL
34dte_activation_datetimestamp without time zoneSIMORDENSEVENTO_OU_VIGENCIA
35dte_sap_validation_datetimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
36sds_dispersioncharacter varyingSIMOUTRONAO_TEMPORAL
37lds_distribuicao_areacharacter varyingSIMOUTRONAO_TEMPORAL
38fk_caso_idcharacter varyingSIMOUTRONAO_TEMPORAL
39lds_caso_status_localcharacter varyingSIMOUTRONAO_TEMPORAL
40dte_compliance_deadline_datatimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
41dte_final_compliance_datatimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
42lds_compliance_localcharacter varyingSIMOUTRONAO_TEMPORAL
43lds_companycharacter varyingSIMOUTRONAO_TEMPORAL
44sds_servico_salesforce_localcharacter varyingSIMORDENSNAO_TEMPORAL
45dte_caso_criacao_datatimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
46dte_caso_status_datatimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
47lds_suspension_cause_localcharacter varyingSIMOUTRONAO_TEMPORAL
48lds_suspension_causecharacter varyingSIMOUTRONAO_TEMPORAL
49dte_insert_laketimestamp without time zoneSIMOUTROEVENTO_OU_VIGENCIA
{'physical_metadata': 'confirmed', 'semantic_classification': 'suggested', 'physical_history_measurement': 'pending'}

bi_brrj_cus.bt_brrj_arquivos_siase_2025

Empresa
ENEL RJ
Tipo
BASE TABLE
Taxonomia
Faturamento e consumo
Prioridade TI
P1
Família de schema
bi_brxx_cus
Replicação
REPLICA_3_EMPRESAS

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: EXIGE_MIN_MAX_NOS_DADOS

Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA

Campos (131)

#CampoTipoNuloConceito sugeridoUso temporal
1tipofaturamentocharacter varyingSIMFATURAMENTONAO_TEMPORAL
2descricaoclassecharacter varyingSIMOUTRONAO_TEMPORAL
3descricaosubclassecharacter varyingSIMOUTRONAO_TEMPORAL
4opcaocompraencharacter varyingSIMOUTRONAO_TEMPORAL
5codigosubgrupotarifariocharacter varyingSIMOUTRONAO_TEMPORAL
6modalidadetarifariacharacter varyingSIMOUTRONAO_TEMPORAL
7tipoconsfatcharacter varyingSIMOUTRONAO_TEMPORAL
8dataemissaofaturacharacter varyingSIMFATURAMENTOEVENTO_OU_VIGENCIA
9datavencimentocharacter varyingSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
10dataleituraatualcharacter varyingSIMLEITURAEVENTO_OU_VIGENCIA
11dataleituraanteriorcharacter varyingSIMLEITURAEVENTO_OU_VIGENCIA
12dataligacaouccharacter varyingSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
13dataencerramentocontratocharacter varyingSIMCONTRATOEVENTO_OU_VIGENCIA
14dataconcbentarifariocharacter varyingSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
15datarevisaocadastralcharacter varyingSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
16dataatualizacaomultifamiliarcharacter varyingSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
17mesreferenciacharacter varyingSIMCOMPETENCIA_REFERENCIACOBERTURA_HISTORICA
18codusuariocharacter varyingSIMINSTALACAONAO_TEMPORAL
19nomeclientecharacter varyingSIMCLIENTENAO_TEMPORAL
20tipopessoacharacter varyingSIMOUTRONAO_TEMPORAL
21numcpfcnpjcharacter varyingSIMOUTRONAO_TEMPORAL
22numranicharacter varyingSIMOUTRONAO_TEMPORAL
23enderecocharacter varyingSIMOUTRONAO_TEMPORAL
24numcepcharacter varyingSIMREDE_GEONAO_TEMPORAL
25localizacaouccharacter varyingSIMOUTRONAO_TEMPORAL
26codigoibgecharacter varyingSIMREDE_GEONAO_TEMPORAL
27codigofaturacharacter varyingSIMFATURAMENTONAO_TEMPORAL
28codigocnaecharacter varyingSIMOUTRONAO_TEMPORAL
29numnischaracter varyingSIMSOCIALNAO_TEMPORAL
30codigofamiliacharacter varyingSIMOUTRONAO_TEMPORAL
31cooperadocharacter varyingSIMOUTRONAO_TEMPORAL
32numnbcharacter varyingSIMOUTRONAO_TEMPORAL
33codmedidorcharacter varyingSIMMEDIDORNAO_TEMPORAL
34demativacontratpontacharacter varyingSIMOUTRONAO_TEMPORAL
35demativacontratforapontacharacter varyingSIMOUTRONAO_TEMPORAL
36demativacontratnaoseaplicacharacter varyingSIMOUTRONAO_TEMPORAL
37demativafatpontacharacter varyingSIMOUTRONAO_TEMPORAL
38demativafatforapontacharacter varyingSIMOUTRONAO_TEMPORAL
39demativafatnaoseaplicacharacter varyingSIMOUTRONAO_TEMPORAL
40consativofattepontacharacter varyingSIMOUTRONAO_TEMPORAL
41consativofatteforapontacharacter varyingSIMOUTRONAO_TEMPORAL
42consativofatteintermcharacter varyingSIMOUTRONAO_TEMPORAL
43consativofattenaoseaplicacharacter varyingSIMOUTRONAO_TEMPORAL
44consativofattepontarescharacter varyingSIMOUTRONAO_TEMPORAL
45consativofatteforapontarescharacter varyingSIMOUTRONAO_TEMPORAL
46consativofattenaoseaplicarescharacter varyingSIMOUTRONAO_TEMPORAL
47consativofattusdpontacharacter varyingSIMOUTRONAO_TEMPORAL
48consativofattusdforapontacharacter varyingSIMOUTRONAO_TEMPORAL
49consativofattusdintermcharacter varyingSIMOUTRONAO_TEMPORAL
50consativofattusdnaoseaplicacharacter varyingSIMOUTRONAO_TEMPORAL
51consativofattusdpontarescharacter varyingSIMOUTRONAO_TEMPORAL
52consativofattusdforapontarescharacter varyingSIMOUTRONAO_TEMPORAL
53consativofattusdnaoseaplicarescharacter varyingSIMOUTRONAO_TEMPORAL
54modalidadegdcharacter varyingSIMGDNAO_TEMPORAL
55saldoanteriorcreditoscharacter varyingSIMCOBRANCANAO_TEMPORAL
56totalcredexpciclofatcharacter varyingSIMREDE_GEONAO_TEMPORAL
57saldoatualizadocreditoscharacter varyingSIMCOBRANCAEVENTO_OU_VIGENCIA
58creditosutilizadoscharacter varyingSIMCOBRANCANAO_TEMPORAL
59multacharacter varyingSIMOUTRONAO_TEMPORAL
60juroscharacter varyingSIMOUTRONAO_TEMPORAL
61encargosconexaocharacter varyingSIMOUTRONAO_TEMPORAL
62valorcompensacaocharacter varyingSIMGDNAO_TEMPORAL
63multaencerramentocharacter varyingSIMOUTRONAO_TEMPORAL
64servicoscobraveischaracter varyingSIMORDENSNAO_TEMPORAL
65valortotalfaturacharacter varyingSIMFATURAMENTONAO_TEMPORAL
66icmscharacter varyingSIMCONTABILNAO_TEMPORAL
67pischaracter varyingSIMCONTABILNAO_TEMPORAL
68cofinscharacter varyingSIMCONTABILNAO_TEMPORAL
69basecalculoicmscharacter varyingSIMCONTABILNAO_TEMPORAL
70basecalculopiscofinscharacter varyingSIMCONTABILNAO_TEMPORAL
71cipcharacter varyingSIMOUTRONAO_TEMPORAL
72demativaregpontacharacter varyingSIMOUTRONAO_TEMPORAL
73demativaregforapontacharacter varyingSIMOUTRONAO_TEMPORAL
74demativaregnaoseaplicacharacter varyingSIMOUTRONAO_TEMPORAL
75demativaultpontacharacter varyingSIMOUTRONAO_TEMPORAL
76demativaultforapontacharacter varyingSIMOUTRONAO_TEMPORAL
77demativaultnaoseaplicacharacter varyingSIMOUTRONAO_TEMPORAL
78demativacomppontacharacter varyingSIMOUTRONAO_TEMPORAL
79demativacompforapontacharacter varyingSIMOUTRONAO_TEMPORAL
80demativacompnaoseaplicacharacter varyingSIMOUTRONAO_TEMPORAL
81rcpontacharacter varyingSIMOUTRONAO_TEMPORAL
82rcforapontacharacter varyingSIMOUTRONAO_TEMPORAL
83rcnaoseaplicacharacter varyingSIMOUTRONAO_TEMPORAL
84consativomedtepontacharacter varyingSIMOUTRONAO_TEMPORAL
85consativomedteforapontacharacter varyingSIMOUTRONAO_TEMPORAL
86consativomedteintermcharacter varyingSIMOUTRONAO_TEMPORAL
87consativomedtenaoseaplicacharacter varyingSIMOUTRONAO_TEMPORAL
88consativomedtepontarescharacter varyingSIMOUTRONAO_TEMPORAL
89consativomedteforapontarescharacter varyingSIMOUTRONAO_TEMPORAL
90consativomedtenaoseaplicarescharacter varyingSIMOUTRONAO_TEMPORAL
91enelativainjpontacharacter varyingSIMOUTRONAO_TEMPORAL
92enelativainjforapontacharacter varyingSIMOUTRONAO_TEMPORAL
93enelativainjintermediariocharacter varyingSIMOUTRONAO_TEMPORAL
94enelativainjreservadocharacter varyingSIMOUTRONAO_TEMPORAL
95enelativainjnaoseaplicacharacter varyingSIMOUTRONAO_TEMPORAL
96subscarficharacter varyingSIMOUTRONAO_TEMPORAL
97subsgerficharacter varyingSIMOUTRONAO_TEMPORAL
98subsdistcharacter varyingSIMOUTRONAO_TEMPORAL
99subsaguaesgotocharacter varyingSIMOUTRONAO_TEMPORAL
100subsruralcharacter varyingSIMCOMUNICACAONAO_TEMPORAL
101subsirrigacaocharacter varyingSIMOUTRONAO_TEMPORAL
102subsbaixarendacharacter varyingSIMSOCIALNAO_TEMPORAL
103receitatusdkwpontacharacter varyingSIMOUTRONAO_TEMPORAL
104receitatusdkwforapontacharacter varyingSIMOUTRONAO_TEMPORAL
105receitatusdkwnaoseaplicacharacter varyingSIMOUTRONAO_TEMPORAL
106receitatusdmwhpontacharacter varyingSIMOUTRONAO_TEMPORAL
107receitatusdmwhforapontacharacter varyingSIMOUTRONAO_TEMPORAL
108receitatusdmwhnaoseaplicacharacter varyingSIMOUTRONAO_TEMPORAL
109receitatusdmwhintermediariocharacter varyingSIMOUTRONAO_TEMPORAL
110receitatusdmwhpontarescharacter varyingSIMOUTRONAO_TEMPORAL
111receitatusdmwhforapontarescharacter varyingSIMOUTRONAO_TEMPORAL
112receitatusdmwhnaoseaplicarescharacter varyingSIMOUTRONAO_TEMPORAL
113receitatepontacharacter varyingSIMOUTRONAO_TEMPORAL
114receitateforapontacharacter varyingSIMOUTRONAO_TEMPORAL
115receitatenaoseaplicacharacter varyingSIMOUTRONAO_TEMPORAL
116receitateintermediariocharacter varyingSIMOUTRONAO_TEMPORAL
117receitatepontarescharacter varyingSIMOUTRONAO_TEMPORAL
118receitateforapontarescharacter varyingSIMOUTRONAO_TEMPORAL
119receitatenaoseaplicarescharacter varyingSIMOUTRONAO_TEMPORAL
120receitabandeirascharacter varyingSIMOUTRONAO_TEMPORAL
121receitaultdemativacharacter varyingSIMOUTRONAO_TEMPORAL
122erecharacter varyingSIMOUTRONAO_TEMPORAL
123drecharacter varyingSIMOUTRONAO_TEMPORAL
124consreativopontacharacter varyingSIMOUTRONAO_TEMPORAL
125consreativoforapontacharacter varyingSIMOUTRONAO_TEMPORAL
126consreativointermediariocharacter varyingSIMOUTRONAO_TEMPORAL
127consreativonaoseaplicacharacter varyingSIMOUTRONAO_TEMPORAL
128demreativapontacharacter varyingSIMOUTRONAO_TEMPORAL
129demreativaforapontacharacter varyingSIMOUTRONAO_TEMPORAL
130demreativanaoseaplicacharacter varyingSIMOUTRONAO_TEMPORAL
131arquivo_nomecharacter varyingSIMOUTRONAO_TEMPORAL
{'physical_metadata': 'confirmed', 'semantic_classification': 'suggested', 'physical_history_measurement': 'pending'}

bi_brrj_cus.bt_brrj_base_kpi_qualidade

Empresa
ENEL RJ
Tipo
BASE TABLE
Taxonomia
Qualidade de dados e cadastro
Prioridade TI
P1
Família de schema
bi_brxx_cus
Replicação
REPLICA_3_EMPRESAS

Tags semânticas: INSTALACAO, CLIENTE, CONTRATO, MEDIDOR, CONTATO, REDE_GEO, TEMPORAL, ATUALIZACAO, COMPETENCIA

Temporal: True · Colunas temporais: dt_nascimento | dt_processamento_yyyymm · Status histórico: EXIGE_MIN_MAX_NOS_DADOS

Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA

Campos (51)

#CampoTipoNuloConceito sugeridoUso temporal
1seqidbigintSIMOUTRONAO_TEMPORAL
2distribuidoracharacter varyingSIMOUTRONAO_TEMPORAL
3instalacaocharacter varyingSIMINSTALACAONAO_TEMPORAL
4assetidcharacter varyingSIMMEDIDORNAO_TEMPORAL
5conta_contratocharacter varyingSIMCONTRATONAO_TEMPORAL
6parceirocharacter varyingSIMCLIENTENAO_TEMPORAL
7nomecharacter varyingSIMOUTRONAO_TEMPORAL
8nome_maecharacter varyingSIMOUTRONAO_TEMPORAL
9dt_nascimentotimestamp without time zoneSIMOUTROEVENTO_OU_VIGENCIA
10cpfcharacter varyingSIMOUTRONAO_TEMPORAL
11cpf_ncharacter varyingSIMOUTRONAO_TEMPORAL
12cnpjcharacter varyingSIMOUTRONAO_TEMPORAL
13cnpj_ncharacter varyingSIMOUTRONAO_TEMPORAL
14inscricao_estadualcharacter varyingSIMOUTRONAO_TEMPORAL
15isentocharacter varyingSIMOUTRONAO_TEMPORAL
16emailcharacter varyingSIMCONTATONAO_TEMPORAL
17email_ncharacter varyingSIMCONTATONAO_TEMPORAL
18tel_celularcharacter varyingSIMCONTATONAO_TEMPORAL
19tel_celular_ncharacter varyingSIMCONTATONAO_TEMPORAL
20tel_fixocharacter varyingSIMOUTRONAO_TEMPORAL
21tel_fixo_ncharacter varyingSIMOUTRONAO_TEMPORAL
22logradourocharacter varyingSIMOUTRONAO_TEMPORAL
23logradouro_altcharacter varyingSIMOUTRONAO_TEMPORAL
24numerocharacter varyingSIMOUTRONAO_TEMPORAL
25numero_altcharacter varyingSIMOUTRONAO_TEMPORAL
26complementocharacter varyingSIMOUTRONAO_TEMPORAL
27complemento_altcharacter varyingSIMOUTRONAO_TEMPORAL
28bairrocharacter varyingSIMOUTRONAO_TEMPORAL
29bairro_altcharacter varyingSIMOUTRONAO_TEMPORAL
30municipiocharacter varyingSIMREDE_GEONAO_TEMPORAL
31municipio_ncharacter varyingSIMREDE_GEONAO_TEMPORAL
32municipio_altcharacter varyingSIMREDE_GEONAO_TEMPORAL
33municipio_alt_ncharacter varyingSIMREDE_GEONAO_TEMPORAL
34ufcharacter varyingSIMOUTRONAO_TEMPORAL
35uf_altcharacter varyingSIMOUTRONAO_TEMPORAL
36cepcharacter varyingSIMREDE_GEONAO_TEMPORAL
37cep_obscharacter varyingSIMREDE_GEONAO_TEMPORAL
38cep_ncharacter varyingSIMREDE_GEONAO_TEMPORAL
39cep_altcharacter varyingSIMREDE_GEONAO_TEMPORAL
40cep_alt_obscharacter varyingSIMREDE_GEONAO_TEMPORAL
41cep_alt_ncharacter varyingSIMREDE_GEONAO_TEMPORAL
42cnaecharacter varyingSIMOUTRONAO_TEMPORAL
43cnae_ncharacter varyingSIMOUTRONAO_TEMPORAL
44subclasse_codigocharacter varyingSIMOUTRONAO_TEMPORAL
45classe_ncharacter varyingSIMOUTRONAO_TEMPORAL
46subclasse_ncharacter varyingSIMOUTRONAO_TEMPORAL
47grupocharacter varyingSIMOUTRONAO_TEMPORAL
48entrega_altbooleanSIMOUTRONAO_TEMPORAL
49delivery_type__ccharacter varyingSIMOUTRONAO_TEMPORAL
50dt_processamentocharacter varyingSIMATUALIZACAO_CARGAATUALIZACAO_FISICA
51dt_processamento_yyyymmcharacter varyingSIMATUALIZACAO_CARGAATUALIZACAO_FISICA
{'physical_metadata': 'confirmed', 'semantic_classification': 'suggested', 'physical_history_measurement': 'pending'}

bi_brrj_cus.bt_brrj_cad_cli_comp_id_2005__a

Empresa
ENEL RJ
Tipo
BASE TABLE
Taxonomia
Outros / transversal
Prioridade TI
P1
Família de schema
bi_brxx_cus
Replicação
REPLICA_3_EMPRESAS

Tags semânticas: INSTALACAO, CLIENTE, MEDIDOR, FATURAMENTO, ORDENS, GD, CONTATO, REDE_GEO, COMUNICACAO, CONTABIL, TEMPORAL

Temporal: True · Colunas temporais: createddate_pointofdelivery | lastmodifieddate_pointofdelivery | cutoffdate__c | createddate_asset | lastmodifieddate_asset | installdate | createddate_account | lastmodifieddate_account | lastactivitydate | birthdate__c · Status histórico: EXIGE_MIN_MAX_NOS_DADOS

Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA

Campos (91)

#CampoTipoNuloConceito sugeridoUso temporal
1pointofdeliverynumber__ccharacter varyingSIMINSTALACAONAO_TEMPORAL
2dvnumberpointofdelivery__ccharacter varyingSIMINSTALACAONAO_TEMPORAL
3id_pointofdeliverycharacter varyingSIMINSTALACAONAO_TEMPORAL
4createddate_pointofdeliverytimestamp without time zoneSIMINSTALACAOEVENTO_OU_VIGENCIA
5lastmodifieddate_pointofdeliverytimestamp without time zoneSIMINSTALACAOEVENTO_OU_VIGENCIA
6companyid__c_pointofdeliverycharacter varyingSIMINSTALACAONAO_TEMPORAL
7billing_type__ccharacter varyingSIMFATURAMENTONAO_TEMPORAL
8connectionstatus__ccharacter varyingSIMOUTRONAO_TEMPORAL
9connectiontype__ccharacter varyingSIMOUTRONAO_TEMPORAL
10cutoffdate__ctimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
11electrodependant__ccharacter varyingSIMOUTRONAO_TEMPORAL
12pointofdeliverystatus__ccharacter varyingSIMINSTALACAONAO_TEMPORAL
13rate__ccharacter varyingSIMOUTRONAO_TEMPORAL
14route__ccharacter varyingSIMOUTRONAO_TEMPORAL
15segmenttype__ccharacter varyingSIMOUTRONAO_TEMPORAL
16servicetype__ccharacter varyingSIMORDENSNAO_TEMPORAL
17company__c_pointofdeliverycharacter varyingSIMINSTALACAONAO_TEMPORAL
18country__c_pointofdeliverycharacter varyingSIMINSTALACAONAO_TEMPORAL
19vip_customer_indicator__cdouble precisionSIMCLIENTENAO_TEMPORAL
20cnt_free_client__cdouble precisionSIMOUTRONAO_TEMPORAL
21cnt_white_rate__cdouble precisionSIMOUTRONAO_TEMPORAL
22distributionaddress__ccharacter varyingSIMCONTABILNAO_TEMPORAL
23notificationcontact__ccharacter varyingSIMCONTATONAO_TEMPORAL
24cnt_lowincometype__cbooleanSIMOUTRONAO_TEMPORAL
25zone__ccharacter varyingSIMOUTRONAO_TEMPORAL
26blacklist__cbooleanSIMOUTRONAO_TEMPORAL
27cnt_isgd__ccharacter varyingSIMGDNAO_TEMPORAL
28municipality__ccharacter varyingSIMREDE_GEONAO_TEMPORAL
29network_type__ccharacter varyingSIMREDE_GEONAO_TEMPORAL
30detailaddress__ccharacter varyingSIMOUTRONAO_TEMPORAL
31id_assetcharacter varyingSIMMEDIDORNAO_TEMPORAL
32contactidcharacter varyingSIMCONTATONAO_TEMPORAL
33accountidcharacter varyingSIMCLIENTENAO_TEMPORAL
34accountrollupidcharacter varyingSIMCLIENTENAO_TEMPORAL
35createddate_assettimestamp without time zoneSIMMEDIDOREVENTO_OU_VIGENCIA
36lastmodifieddate_assettimestamp without time zoneSIMMEDIDOREVENTO_OU_VIGENCIA
37name_assetcharacter varyingSIMMEDIDORNAO_TEMPORAL
38installdatetimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
39status_assetcharacter varyingSIMMEDIDORNAO_TEMPORAL
40description_assetcharacter varyingSIMMEDIDORNAO_TEMPORAL
41type__c_assetcharacter varyingSIMMEDIDORNAO_TEMPORAL
42company__c_assetcharacter varyingSIMMEDIDORNAO_TEMPORAL
43externalid__c_assetcharacter varyingSIMMEDIDORNAO_TEMPORAL
44ne__status__c_assetcharacter varyingSIMMEDIDORNAO_TEMPORAL
45id_accountcharacter varyingSIMCLIENTENAO_TEMPORAL
46name_accountcharacter varyingSIMCLIENTENAO_TEMPORAL
47phonecharacter varyingSIMOUTRONAO_TEMPORAL
48accountnumbercharacter varyingSIMCLIENTENAO_TEMPORAL
49createddate_accounttimestamp without time zoneSIMCLIENTEEVENTO_OU_VIGENCIA
50lastmodifieddate_accounttimestamp without time zoneSIMCLIENTEEVENTO_OU_VIGENCIA
51lastactivitydatetimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
52additionalphone__ccharacter varyingSIMOUTRONAO_TEMPORAL
53birthdate__ctimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
54businessname__ccharacter varyingSIMOUTRONAO_TEMPORAL
55companyid__c_accountcharacter varyingSIMCLIENTENAO_TEMPORAL
56identitynumber__ccharacter varyingSIMOUTRONAO_TEMPORAL
57identitytype__ccharacter varyingSIMOUTRONAO_TEMPORAL
58mainphone__ccharacter varyingSIMOUTRONAO_TEMPORAL
59primaryemail__ccharacter varyingSIMCONTATONAO_TEMPORAL
60secondaryemail__ccharacter varyingSIMCONTATONAO_TEMPORAL
61secondaryphone__ccharacter varyingSIMOUTRONAO_TEMPORAL
62company__c_accountcharacter varyingSIMCLIENTENAO_TEMPORAL
63externalid__c_accountcharacter varyingSIMCLIENTENAO_TEMPORAL
64ne__status__c_accountcharacter varyingSIMCLIENTENAO_TEMPORAL
65countryb2b__ccharacter varyingSIMOUTRONAO_TEMPORAL
66accountclientnumber__ccharacter varyingSIMCLIENTENAO_TEMPORAL
67phonetype__ccharacter varyingSIMOUTRONAO_TEMPORAL
68pais__ccharacter varyingSIMOUTRONAO_TEMPORAL
69tertiary_email__ccharacter varyingSIMCONTATONAO_TEMPORAL
70executive__ccharacter varyingSIMOUTRONAO_TEMPORAL
71cnt_responsible_name__ccharacter varyingSIMOUTRONAO_TEMPORAL
72cnt_resp_id_type__ccharacter varyingSIMOUTRONAO_TEMPORAL
73cnt_resp_id_number__ccharacter varyingSIMOUTRONAO_TEMPORAL
74cnt_responsible_phone__ccharacter varyingSIMOUTRONAO_TEMPORAL
75cnt_responsible_email__ccharacter varyingSIMCONTATONAO_TEMPORAL
76cnt_responsible_charge__ccharacter varyingSIMOUTRONAO_TEMPORAL
77cnt_numorgcntr__ccharacter varyingSIMOUTRONAO_TEMPORAL
78cnt_fantasy_name__ccharacter varyingSIMOUTRONAO_TEMPORAL
79recordtypeidcharacter varyingSIMOUTRONAO_TEMPORAL
80cnt_mothers_full_name__ccharacter varyingSIMOUTRONAO_TEMPORAL
81cnt_id_type_2__ccharacter varyingSIMOUTRONAO_TEMPORAL
82cnt_id_num_2__ccharacter varyingSIMOUTRONAO_TEMPORAL
83cnt_state_inscription__ccharacter varyingSIMOUTRONAO_TEMPORAL
84cnt_state_inscription_exemption__ccharacter varyingSIMOUTRONAO_TEMPORAL
85cnt_municipality_inscription__ccharacter varyingSIMREDE_GEONAO_TEMPORAL
86cnt_is_postal_address__ccharacter varyingSIMOUTRONAO_TEMPORAL
87acceptenelcommunication__ccharacter varyingSIMREDE_GEONAO_TEMPORAL
88cnt_customerchannel__ccharacter varyingSIMCLIENTENAO_TEMPORAL
89feedernumber__ccharacter varyingSIMOUTRONAO_TEMPORAL
90transformername__ccharacter varyingSIMOUTRONAO_TEMPORAL
91transformernumber__ccharacter varyingSIMOUTRONAO_TEMPORAL
{'physical_metadata': 'confirmed', 'semantic_classification': 'suggested', 'physical_history_measurement': 'pending'}

bi_brrj_cus.bt_brrj_contrato

Empresa
ENEL RJ
Tipo
BASE TABLE
Taxonomia
Cliente, instalação e contrato
Prioridade TI
P1
Família de schema
bi_brxx_cus
Replicação
REPLICA_3_EMPRESAS

Tags semânticas: INSTALACAO, CONTRATO, FATURAMENTO, COMUNICACAO, TEMPORAL

Temporal: True · Colunas temporais: data_ligacao | data_criacao | data_modificacao | data_desligamento · Status histórico: EXIGE_MIN_MAX_NOS_DADOS

Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA

Campos (30)

#CampoTipoNuloConceito sugeridoUso temporal
1contratobigintSIMCONTRATONAO_TEMPORAL
2instalacaobigintSIMINSTALACAONAO_TEMPORAL
3conta_contratobigintSIMCONTRATONAO_TEMPORAL
4data_ligacaotimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
5data_desligamentotimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
6empresacharacter varyingSIMOUTRONAO_TEMPORAL
7empresa_textocharacter varyingSIMOUTRONAO_TEMPORAL
8carac_det_ctascharacter varyingSIMOUTRONAO_TEMPORAL
9carac_det_ctas_textocharacter varyingSIMOUTRONAO_TEMPORAL
10contrato_conjuntocharacter varyingSIMCONTRATONAO_TEMPORAL
11contrato_conjunto_textocharacter varyingSIMCONTRATONAO_TEMPORAL
12domicilio_fiscalcharacter varyingSIMOUTRONAO_TEMPORAL
13domicilio_fiscal_textocharacter varyingSIMOUTRONAO_TEMPORAL
14exclusao_calculocharacter varyingSIMOUTRONAO_TEMPORAL
15exclusao_calculo_textocharacter varyingSIMOUTRONAO_TEMPORAL
16divisaocharacter varyingSIMOUTRONAO_TEMPORAL
17divisao_textocharacter varyingSIMOUTRONAO_TEMPORAL
18classe_contratocharacter varyingSIMCONTRATONAO_TEMPORAL
19classe_contrato_textocharacter varyingSIMCONTRATONAO_TEMPORAL
20procedimento_advertenciacharacter varyingSIMOUTRONAO_TEMPORAL
21procedimento_advertencia_textocharacter varyingSIMOUTRONAO_TEMPORAL
22motivo_bloqueio_advcharacter varyingSIMOUTRONAO_TEMPORAL
23motivo_bloqueio_adv_textocharacter varyingSIMOUTRONAO_TEMPORAL
24motivo_bloqueio_calculocharacter varyingSIMOUTRONAO_TEMPORAL
25motivo_bloqueio_calculo_textocharacter varyingSIMOUTRONAO_TEMPORAL
26fatura_osbcharacter varyingSIMFATURAMENTONAO_TEMPORAL
27data_criacaotimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
28nome_criacaocharacter varyingSIMOUTRONAO_TEMPORAL
29data_modificacaotimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
30nome_modificacaocharacter varyingSIMOUTRONAO_TEMPORAL
{'physical_metadata': 'confirmed', 'semantic_classification': 'suggested', 'physical_history_measurement': 'pending'}

bi_brrj_cus.bt_brrj_dados_contato_cruzamento

Empresa
ENEL RJ
Tipo
BASE TABLE
Taxonomia
Contato, consentimento e canais
Prioridade TI
P1
Família de schema
bi_brxx_cus
Replicação
REPLICA_3_EMPRESAS

Tags semânticas: INSTALACAO, CLIENTE, CONTRATO, MEDIDOR, CONTATO, TEMPORAL

Temporal: True · Colunas temporais: dataprocess · Status histórico: EXIGE_MIN_MAX_NOS_DADOS

Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA

Campos (10)

#CampoTipoNuloConceito sugeridoUso temporal
1instalacaocharacter varyingSIMINSTALACAONAO_TEMPORAL
2conta_contratocharacter varyingSIMCONTRATONAO_TEMPORAL
3asset_idcharacter varyingSIMMEDIDORNAO_TEMPORAL
4account_idcharacter varyingSIMCLIENTENAO_TEMPORAL
5cnpjcharacter varyingSIMOUTRONAO_TEMPORAL
6cpfcharacter varyingSIMOUTRONAO_TEMPORAL
7tel_fixocharacter varyingSIMOUTRONAO_TEMPORAL
8tel_celularcharacter varyingSIMCONTATONAO_TEMPORAL
9emailcharacter varyingSIMCONTATONAO_TEMPORAL
10dataprocesstimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
{'physical_metadata': 'confirmed', 'semantic_classification': 'suggested', 'physical_history_measurement': 'pending'}

bi_brrj_cus.bt_brrj_despersonalizado

Empresa
ENEL RJ
Tipo
BASE TABLE
Taxonomia
Outros / transversal
Prioridade TI
P1
Família de schema
bi_brxx_cus
Replicação
REPLICA_3_EMPRESAS

Tags semânticas: INSTALACAO, CLIENTE, CONTRATO, MEDIDOR, FATURAMENTO, ORDENS, GD, CONTATO, QUALIDADE, REDE_GEO, SOCIAL, COMUNICACAO, CONTABIL, TEMPORAL

Temporal: True · Colunas temporais: createddate_pointofdelivery | cutoffdate__c | createddate_asset | lastmodifieddate_asset | installdate | createddate_account | lastmodifieddate_account | lastactivitydate | birthdate__c | createddate_billing_profile | cnt_due_date__c | suscriptiondate__c | startdate_contract | activateddate_contract | createddate_contract | lastmodifieddate_contract | enddate_contract | mainphone__c_datamodif | secondaryphone__c_datamodif | additionalphone__c_datamodif | carga_kw_br · Status histórico: EXIGE_MIN_MAX_NOS_DADOS

Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA

Campos (181)

#CampoTipoNuloConceito sugeridoUso temporal
1pointofdeliverynumber__ccharacter varyingSIMINSTALACAONAO_TEMPORAL
2dvnumberpointofdelivery__ccharacter varyingSIMINSTALACAONAO_TEMPORAL
3id_pointofdeliverycharacter varyingSIMINSTALACAONAO_TEMPORAL
4createddate_pointofdeliverytimestamp without time zoneSIMINSTALACAOEVENTO_OU_VIGENCIA
5companyid__c_pointofdeliverycharacter varyingSIMINSTALACAONAO_TEMPORAL
6billing_type__ccharacter varyingSIMFATURAMENTONAO_TEMPORAL
7connectionstatus__ccharacter varyingSIMOUTRONAO_TEMPORAL
8connectiontype__ccharacter varyingSIMOUTRONAO_TEMPORAL
9cutoffdate__ctimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
10electrodependant__ccharacter varyingSIMOUTRONAO_TEMPORAL
11pointofdeliverystatus__ccharacter varyingSIMINSTALACAONAO_TEMPORAL
12rate__ccharacter varyingSIMOUTRONAO_TEMPORAL
13route__ccharacter varyingSIMOUTRONAO_TEMPORAL
14segmenttype__ccharacter varyingSIMOUTRONAO_TEMPORAL
15servicetype__ccharacter varyingSIMORDENSNAO_TEMPORAL
16company__c_pointofdeliverycharacter varyingSIMINSTALACAONAO_TEMPORAL
17vip_customer_indicator__cdouble precisionSIMCLIENTENAO_TEMPORAL
18cnt_free_client__cdouble precisionSIMOUTRONAO_TEMPORAL
19cnt_white_rate__cdouble precisionSIMOUTRONAO_TEMPORAL
20distributionaddress__ccharacter varyingSIMCONTABILNAO_TEMPORAL
21notificationcontact__ccharacter varyingSIMCONTATONAO_TEMPORAL
22cnt_lowincometype__cbooleanSIMOUTRONAO_TEMPORAL
23zone__ccharacter varyingSIMOUTRONAO_TEMPORAL
24blacklist__cbooleanSIMOUTRONAO_TEMPORAL
25cnt_isgd__ccharacter varyingSIMGDNAO_TEMPORAL
26municipality__ccharacter varyingSIMREDE_GEONAO_TEMPORAL
27network_type__ccharacter varyingSIMREDE_GEONAO_TEMPORAL
28detailaddress__ccharacter varyingSIMOUTRONAO_TEMPORAL
29feedernumber__ccharacter varyingSIMOUTRONAO_TEMPORAL
30transformername__ccharacter varyingSIMOUTRONAO_TEMPORAL
31transformernumber__ccharacter varyingSIMOUTRONAO_TEMPORAL
32id_assetcharacter varyingSIMMEDIDORNAO_TEMPORAL
33contactidcharacter varyingSIMCONTATONAO_TEMPORAL
34accountidcharacter varyingSIMCLIENTENAO_TEMPORAL
35accountrollupidcharacter varyingSIMCLIENTENAO_TEMPORAL
36createddate_assettimestamp without time zoneSIMMEDIDOREVENTO_OU_VIGENCIA
37lastmodifieddate_assettimestamp without time zoneSIMMEDIDOREVENTO_OU_VIGENCIA
38name_assetcharacter varyingSIMMEDIDORNAO_TEMPORAL
39installdatetimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
40status_assetcharacter varyingSIMMEDIDORNAO_TEMPORAL
41description_assetcharacter varyingSIMMEDIDORNAO_TEMPORAL
42type__c_assetcharacter varyingSIMMEDIDORNAO_TEMPORAL
43company__c_assetcharacter varyingSIMMEDIDORNAO_TEMPORAL
44externalid__c_assetcharacter varyingSIMMEDIDORNAO_TEMPORAL
45ne__status__c_assetcharacter varyingSIMMEDIDORNAO_TEMPORAL
46id_accountcharacter varyingSIMCLIENTENAO_TEMPORAL
47name_accountcharacter varyingSIMCLIENTENAO_TEMPORAL
48accountnumbercharacter varyingSIMCLIENTENAO_TEMPORAL
49tipo_contacharacter varyingSIMOUTRONAO_TEMPORAL
50createddate_accounttimestamp without time zoneSIMCLIENTEEVENTO_OU_VIGENCIA
51lastmodifieddate_accounttimestamp without time zoneSIMCLIENTEEVENTO_OU_VIGENCIA
52lastactivitydatetimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
53additionalphone__ccharacter varyingSIMOUTRONAO_TEMPORAL
54birthdate__ctimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
55businessname__ccharacter varyingSIMOUTRONAO_TEMPORAL
56companyid__c_accountcharacter varyingSIMCLIENTENAO_TEMPORAL
57company__c_accountcharacter varyingSIMCLIENTENAO_TEMPORAL
58externalid__c_accountcharacter varyingSIMCLIENTENAO_TEMPORAL
59ne__status__c_accountcharacter varyingSIMCLIENTENAO_TEMPORAL
60countryb2b__ccharacter varyingSIMOUTRONAO_TEMPORAL
61accountclientnumber__ccharacter varyingSIMCLIENTENAO_TEMPORAL
62pais__ccharacter varyingSIMOUTRONAO_TEMPORAL
63executive__ccharacter varyingSIMOUTRONAO_TEMPORAL
64cnt_responsible_name__ccharacter varyingSIMOUTRONAO_TEMPORAL
65cnt_resp_id_type__ccharacter varyingSIMOUTRONAO_TEMPORAL
66cnt_resp_id_number__ccharacter varyingSIMOUTRONAO_TEMPORAL
67cnt_responsible_phone__ccharacter varyingSIMOUTRONAO_TEMPORAL
68cnt_responsible_email__ccharacter varyingSIMCONTATONAO_TEMPORAL
69cnt_responsible_charge__ccharacter varyingSIMOUTRONAO_TEMPORAL
70cnt_numorgcntr__ccharacter varyingSIMOUTRONAO_TEMPORAL
71cnt_fantasy_name__ccharacter varyingSIMOUTRONAO_TEMPORAL
72recordtypeidcharacter varyingSIMOUTRONAO_TEMPORAL
73cnt_mothers_full_name__ccharacter varyingSIMOUTRONAO_TEMPORAL
74cnt_id_type_2__ccharacter varyingSIMOUTRONAO_TEMPORAL
75cnt_id_num_2__ccharacter varyingSIMOUTRONAO_TEMPORAL
76cnt_state_inscription__ccharacter varyingSIMOUTRONAO_TEMPORAL
77cnt_state_inscription_exemption__ccharacter varyingSIMOUTRONAO_TEMPORAL
78cnt_municipality_inscription__ccharacter varyingSIMREDE_GEONAO_TEMPORAL
79cnt_is_postal_address__ccharacter varyingSIMOUTRONAO_TEMPORAL
80acceptenelcommunication__ccharacter varyingSIMREDE_GEONAO_TEMPORAL
81cnt_customerchannel__ccharacter varyingSIMCLIENTENAO_TEMPORAL
82id_contract__c_contract_linecharacter varyingSIMCONTRATONAO_TEMPORAL
83id_billing_profile__c_contract_linecharacter varyingSIMCONTRATONAO_TEMPORAL
84id_asset__c_contract_linecharacter varyingSIMCONTRATONAO_TEMPORAL
85pointofdelivery__ccharacter varyingSIMINSTALACAONAO_TEMPORAL
86accountcontract__ccharacter varyingSIMCLIENTENAO_TEMPORAL
87currentaccount__cdouble precisionSIMCLIENTENAO_TEMPORAL
88createddate_billing_profiletimestamp without time zoneSIMFATURAMENTOEVENTO_OU_VIGENCIA
89name_billing_profilecharacter varyingSIMFATURAMENTONAO_TEMPORAL
90edeenrolment__cdouble precisionSIMOUTRONAO_TEMPORAL
91delivery_type__ccharacter varyingSIMOUTRONAO_TEMPORAL
92cnt_due_date__ccharacter varyingSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
93edesuscmassive__cbooleanSIMOUTRONAO_TEMPORAL
94publiccharge__cbooleanSIMOUTRONAO_TEMPORAL
95lowamount__cbooleanSIMOUTRONAO_TEMPORAL
96type__c_billing_profilecharacter varyingSIMFATURAMENTONAO_TEMPORAL
97suscriptiondate__ctimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
98id_contractcharacter varyingSIMCONTRATONAO_TEMPORAL
99startdate_contracttimestamp without time zoneSIMCONTRATOEVENTO_OU_VIGENCIA
100activateddate_contracttimestamp without time zoneSIMCONTRATOEVENTO_OU_VIGENCIA
101createddate_contracttimestamp without time zoneSIMCONTRATOEVENTO_OU_VIGENCIA
102lastmodifieddate_contracttimestamp without time zoneSIMCONTRATOEVENTO_OU_VIGENCIA
103enddate_contracttimestamp without time zoneSIMCONTRATOEVENTO_OU_VIGENCIA
104status_contractcharacter varyingSIMCONTRATONAO_TEMPORAL
105description_contractcharacter varyingSIMCONTRATONAO_TEMPORAL
106statuscod_contractcharacter varyingSIMCONTRATONAO_TEMPORAL
107contractnumber_contractcharacter varyingSIMCONTRATONAO_TEMPORAL
108contract_type__c_contractcharacter varyingSIMCONTRATONAO_TEMPORAL
109cnt_economical_activity__c_contractcharacter varyingSIMCONTRATONAO_TEMPORAL
110coordinatex__ccharacter varyingSIMOUTRONAO_TEMPORAL
111coordinatey__ccharacter varyingSIMOUTRONAO_TEMPORAL
112id_adresscharacter varyingSIMOUTRONAO_TEMPORAL
113literal_municipality__ccharacter varyingSIMREDE_GEONAO_TEMPORAL
114literal_region__ccharacter varyingSIMOUTRONAO_TEMPORAL
115literal_street_type__ccharacter varyingSIMOUTRONAO_TEMPORAL
116neighbourhood__ccharacter varyingSIMOUTRONAO_TEMPORAL
117postal_code__ccharacter varyingSIMOUTRONAO_TEMPORAL
118street__ccharacter varyingSIMOUTRONAO_TEMPORAL
119idstreetcharacter varyingSIMOUTRONAO_TEMPORAL
120identitytype__ccharacter varyingSIMOUTRONAO_TEMPORAL
121clienteativodouble precisionSIMCLIENTENAO_TEMPORAL
122despersonalizadodouble precisionSIMOUTRONAO_TEMPORAL
123celularcharacter varyingSIMCONTATONAO_TEMPORAL
124fixocharacter varyingSIMOUTRONAO_TEMPORAL
125com_telefonedouble precisionSIMCONTATONAO_TEMPORAL
126emailcharacter varyingSIMCONTATONAO_TEMPORAL
127mainphone__ccharacter varyingSIMOUTRONAO_TEMPORAL
128secondaryphone__ccharacter varyingSIMOUTRONAO_TEMPORAL
129primaryemail__ccharacter varyingSIMCONTATONAO_TEMPORAL
130secondaryemail__ccharacter varyingSIMCONTATONAO_TEMPORAL
131identitynumber__ccharacter varyingSIMOUTRONAO_TEMPORAL
132primaryemail__c_validacaodouble precisionSIMCONTATONAO_TEMPORAL
133secondaryemail__c_dominiocharacter varyingSIMCONTATONAO_TEMPORAL
134secondaryemail__c_validacaodouble precisionSIMCONTATONAO_TEMPORAL
135identitynumber__c_validacaodouble precisionSIMQUALIDADENAO_TEMPORAL
136mainphone__c_tipotelefonecharacter varyingSIMCONTATONAO_TEMPORAL
137secondaryphone__c_tipotelefonecharacter varyingSIMCONTATONAO_TEMPORAL
138additionalphone__c_tipotelefonecharacter varyingSIMCONTATONAO_TEMPORAL
139mainphone__c_datamodiftimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
140mainphone__c_usuariomodif_character varyingSIMOUTRONAO_TEMPORAL
141mainphone__c_usuario_modif_character varyingSIMOUTRONAO_TEMPORAL
142mainphone__c_brusuariocharacter varyingSIMOUTRONAO_TEMPORAL
143mainphone__c_cargousuariocharacter varyingSIMOUTRONAO_TEMPORAL
144mainphone__c_areausuariocharacter varyingSIMOUTRONAO_TEMPORAL
145secondaryphone__c_datamodiftimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
146secondaryphone__c_usuariomodif_character varyingSIMOUTRONAO_TEMPORAL
147secondaryphone__c_usuario_modif_character varyingSIMOUTRONAO_TEMPORAL
148secondaryphone__c_brusuariocharacter varyingSIMOUTRONAO_TEMPORAL
149secondaryphone__c_cargousuariocharacter varyingSIMOUTRONAO_TEMPORAL
150secondaryphone__c_areausuariocharacter varyingSIMOUTRONAO_TEMPORAL
151additionalphone__c_datamodiftimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
152additionalphone__c_usuariomodifcharacter varyingSIMOUTRONAO_TEMPORAL
153additionalphone__c_usuario_modif_character varyingSIMOUTRONAO_TEMPORAL
154additionalphone__c_brusuariocharacter varyingSIMOUTRONAO_TEMPORAL
155additionalphone__c_cargousuariocharacter varyingSIMOUTRONAO_TEMPORAL
156additionalphone__c_areausuariocharacter varyingSIMOUTRONAO_TEMPORAL
157mainphone__c_validacaodouble precisionSIMQUALIDADENAO_TEMPORAL
158secondaryphone__c_validacaodouble precisionSIMQUALIDADENAO_TEMPORAL
159additionalphone__c_validacaodouble precisionSIMQUALIDADENAO_TEMPORAL
160cpnj_validodouble precisionSIMOUTRONAO_TEMPORAL
161cpf_validodouble precisionSIMOUTRONAO_TEMPORAL
162classe_brcharacter varyingSIMOUTRONAO_TEMPORAL
163subclasse_brcharacter varyingSIMOUTRONAO_TEMPORAL
164categoria_de_tarifa_brcharacter varyingSIMOUTRONAO_TEMPORAL
165carga_kw_brcharacter varyingSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
166nivel_de_tensao_brcharacter varyingSIMOUTRONAO_TEMPORAL
167parceirocharacter varyingSIMCLIENTENAO_TEMPORAL
168conta_contratocharacter varyingSIMCONTRATONAO_TEMPORAL
169mov_incharacter varyingSIMOUTRONAO_TEMPORAL
170mov_outcharacter varyingSIMOUTRONAO_TEMPORAL
171setor_industrialcharacter varyingSIMOUTRONAO_TEMPORAL
172zona_temperaturacharacter varyingSIMCOMUNICACAONAO_TEMPORAL
173categoria_tarifacharacter varyingSIMOUTRONAO_TEMPORAL
174instalacaobigintSIMINSTALACAONAO_TEMPORAL
175local_consumocharacter varyingSIMFATURAMENTONAO_TEMPORAL
176ruacharacter varyingSIMOUTRONAO_TEMPORAL
177estado_clientecharacter varyingSIMCLIENTENAO_TEMPORAL
178classe_synergiacharacter varyingSIMOUTRONAO_TEMPORAL
179subclasse_synergiacharacter varyingSIMOUTRONAO_TEMPORAL
180estado_suministrocharacter varyingSIMSOCIALNAO_TEMPORAL
181dica_localizacaocharacter varyingSIMOUTRONAO_TEMPORAL
{'physical_metadata': 'confirmed', 'semantic_classification': 'suggested', 'physical_history_measurement': 'pending'}

bi_brrj_cus.bt_brrj_dim_cr_fatura

Empresa
ENEL RJ
Tipo
BASE TABLE
Taxonomia
Faturamento e consumo
Prioridade TI
P1
Família de schema
bi_brxx_cus
Replicação
REPLICA_3_EMPRESAS

Tags semânticas: CLIENTE, CONTRATO, FATURAMENTO, COBRANCA, PERDAS, COMUNICACAO, TEMPORAL, COMPETENCIA

Temporal: True · Colunas temporais: ref | dt_faturamento | dt_vencimento | 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 (24)

#CampoTipoNuloConceito sugeridoUso temporal
1empresacharacter varyingSIMOUTRONAO_TEMPORAL
2reftimestamp without time zoneSIMOUTROEVENTO_OU_VIGENCIA
3numero_clientebigintSIMCLIENTENAO_TEMPORAL
4no_nota_fiscalcharacter varyingSIMOUTRONAO_TEMPORAL
5corr_faturaintegerSIMFATURAMENTONAO_TEMPORAL
6tipo_doccharacter varyingSIMOUTRONAO_TEMPORAL
7contrcoletivocharacter varyingSIMOUTRONAO_TEMPORAL
8doc_fat_coletivocharacter varyingSIMOUTRONAO_TEMPORAL
9contratocharacter varyingSIMCONTRATONAO_TEMPORAL
10ref_fatcharacter varyingSIMOUTRONAO_TEMPORAL
11dt_faturamentotimestamp without time zoneSIMFATURAMENTOEVENTO_OU_VIGENCIA
12dt_vencimentotimestamp without time zoneSIMOUTROEVENTO_OU_VIGENCIA
13pend_judicialcharacter varyingSIMOUTRONAO_TEMPORAL
14pend_bancariacharacter varyingSIMOUTRONAO_TEMPORAL
15toicharacter varyingSIMPERDASNAO_TEMPORAL
16pddcharacter varyingSIMCOBRANCANAO_TEMPORAL
17castigocharacter varyingSIMOUTRONAO_TEMPORAL
18total_faturanumericSIMFATURAMENTONAO_TEMPORAL
19cota_parcelamentonumericSIMOUTRONAO_TEMPORAL
20total_toinumericSIMPERDASNAO_TEMPORAL
21total_terceirosnumericSIMOUTRONAO_TEMPORAL
22detalhe_dividaintegerSIMCOBRANCANAO_TEMPORAL
23antigintegerSIMOUTRONAO_TEMPORAL
24ano_mes_selecaocharacter varyingSIMCOMPETENCIA_REFERENCIACOBERTURA_HISTORICA
{'physical_metadata': 'confirmed', 'semantic_classification': 'suggested', 'physical_history_measurement': 'pending'}

bi_brrj_cus.bt_brrj_efatura_ga

Empresa
ENEL RJ
Tipo
BASE TABLE
Taxonomia
Faturamento e consumo
Prioridade TI
P1
Família de schema
bi_brxx_cus
Replicação
REPLICA_3_EMPRESAS

Tags semânticas: INSTALACAO, CLIENTE, CONTRATO, LEITURA, FATURAMENTO, CONTATO, REDE_GEO, SOCIAL, COMUNICACAO, TEMPORAL, COMPETENCIA

Temporal: True · Colunas temporais: data_de_abertura | data_do_clique | data_de_vencimento | data_de_emissao | referencia_da_fatura | data_contato_atualizado | data_disparo | referencia · Status histórico: EXIGE_MIN_MAX_NOS_DADOS

Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA

Campos (34)

#CampoTipoNuloConceito sugeridoUso temporal
1grupo_de_tensaocharacter varyingSIMOUTRONAO_TEMPORAL
2conta_contratocharacter varyingSIMCONTRATONAO_TEMPORAL
3instalacaocharacter varyingSIMINSTALACAONAO_TEMPORAL
4nome_do_clientecharacter varyingSIMCLIENTENAO_TEMPORAL
5enderecocharacter varyingSIMOUTRONAO_TEMPORAL
6municipiocharacter varyingSIMREDE_GEONAO_TEMPORAL
7enviadocharacter varyingSIMOUTRONAO_TEMPORAL
8aberturacharacter varyingSIMCOMUNICACAONAO_TEMPORAL
9data_de_aberturacharacter varyingSIMCOMUNICACAOEVENTO_OU_VIGENCIA
10nome_do_executivo_da_contacharacter varyingSIMOUTRONAO_TEMPORAL
11cliquecharacter varyingSIMOUTRONAO_TEMPORAL
12data_do_cliquecharacter varyingSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
13bounce_categoriacharacter varyingSIMOUTRONAO_TEMPORAL
14bounce_subcategoriacharacter varyingSIMOUTRONAO_TEMPORAL
15contactidcharacter varyingSIMCONTATONAO_TEMPORAL
16data_de_vencimentocharacter varyingSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
17data_de_emissaocharacter varyingSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
18valor_da_faturacharacter varyingSIMFATURAMENTONAO_TEMPORAL
19numero_da_faturacharacter varyingSIMFATURAMENTONAO_TEMPORAL
20url_da_faturacharacter varyingSIMFATURAMENTONAO_TEMPORAL
21referencia_da_faturacharacter varyingSIMFATURAMENTOCOBERTURA_HISTORICA
22emailcharacter varyingSIMCONTATONAO_TEMPORAL
23bp_idcharacter varyingSIMOUTRONAO_TEMPORAL
24invoice_idcharacter varyingSIMFATURAMENTONAO_TEMPORAL
25pointofdelivery_idcharacter varyingSIMINSTALACAONAO_TEMPORAL
26bpc_idcharacter varyingSIMSOCIALNAO_TEMPORAL
27data_contato_atualizadocharacter varyingSIMCONTATOEVENTO_OU_VIGENCIA
28data_disparocharacter varyingSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
29lotecharacter varyingSIMOUTRONAO_TEMPORAL
30unidadeleituracharacter varyingSIMLEITURANAO_TEMPORAL
31bounces_3mesescharacter varyingSIMOUTRONAO_TEMPORAL
32status_mccharacter varyingSIMOUTRONAO_TEMPORAL
33status_emailcharacter varyingSIMCONTATONAO_TEMPORAL
34referenciabigintSIMCOMPETENCIA_REFERENCIACOBERTURA_HISTORICA
{'physical_metadata': 'confirmed', 'semantic_classification': 'suggested', 'physical_history_measurement': 'pending'}

bi_brrj_cus.bt_brrj_efatura_gb

Empresa
ENEL RJ
Tipo
BASE TABLE
Taxonomia
Faturamento e consumo
Prioridade TI
P1
Família de schema
bi_brxx_cus
Replicação
REPLICA_3_EMPRESAS

Tags semânticas: INSTALACAO, CLIENTE, CONTRATO, LEITURA, FATURAMENTO, CONTATO, REDE_GEO, SOCIAL, COMUNICACAO, TEMPORAL, COMPETENCIA

Temporal: True · Colunas temporais: data_de_abertura | data_do_clique | data_de_vencimento | data_de_emissao | referencia_da_fatura | data_contato_atualizado | data_disparo | referencia · Status histórico: EXIGE_MIN_MAX_NOS_DADOS

Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA

Campos (34)

#CampoTipoNuloConceito sugeridoUso temporal
1grupo_de_tensaocharacter varyingSIMOUTRONAO_TEMPORAL
2conta_contratocharacter varyingSIMCONTRATONAO_TEMPORAL
3instalacaocharacter varyingSIMINSTALACAONAO_TEMPORAL
4nome_do_clientecharacter varyingSIMCLIENTENAO_TEMPORAL
5enderecocharacter varyingSIMOUTRONAO_TEMPORAL
6municipiocharacter varyingSIMREDE_GEONAO_TEMPORAL
7enviadocharacter varyingSIMOUTRONAO_TEMPORAL
8aberturacharacter varyingSIMCOMUNICACAONAO_TEMPORAL
9data_de_aberturacharacter varyingSIMCOMUNICACAOEVENTO_OU_VIGENCIA
10nome_do_executivo_da_contacharacter varyingSIMOUTRONAO_TEMPORAL
11cliquecharacter varyingSIMOUTRONAO_TEMPORAL
12data_do_cliquecharacter varyingSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
13bounce_categoriacharacter varyingSIMOUTRONAO_TEMPORAL
14bounce_subcategoriacharacter varyingSIMOUTRONAO_TEMPORAL
15contactidcharacter varyingSIMCONTATONAO_TEMPORAL
16data_de_vencimentocharacter varyingSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
17data_de_emissaocharacter varyingSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
18valor_da_faturacharacter varyingSIMFATURAMENTONAO_TEMPORAL
19numero_da_faturacharacter varyingSIMFATURAMENTONAO_TEMPORAL
20url_da_faturacharacter varyingSIMFATURAMENTONAO_TEMPORAL
21referencia_da_faturacharacter varyingSIMFATURAMENTOCOBERTURA_HISTORICA
22emailcharacter varyingSIMCONTATONAO_TEMPORAL
23bp_idcharacter varyingSIMOUTRONAO_TEMPORAL
24invoice_idcharacter varyingSIMFATURAMENTONAO_TEMPORAL
25pointofdelivery_idcharacter varyingSIMINSTALACAONAO_TEMPORAL
26bpc_idcharacter varyingSIMSOCIALNAO_TEMPORAL
27data_contato_atualizadocharacter varyingSIMCONTATOEVENTO_OU_VIGENCIA
28data_disparocharacter varyingSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
29lotecharacter varyingSIMOUTRONAO_TEMPORAL
30unidadeleituracharacter varyingSIMLEITURANAO_TEMPORAL
31bounces_3mesescharacter varyingSIMOUTRONAO_TEMPORAL
32status_mccharacter varyingSIMOUTRONAO_TEMPORAL
33status_emailcharacter varyingSIMCONTATONAO_TEMPORAL
34referenciabigintSIMCOMPETENCIA_REFERENCIACOBERTURA_HISTORICA
{'physical_metadata': 'confirmed', 'semantic_classification': 'suggested', 'physical_history_measurement': 'pending'}

bi_brrj_cus.bt_brrj_equipamento

Empresa
ENEL RJ
Tipo
BASE TABLE
Taxonomia
Outros / transversal
Prioridade TI
P1
Família de schema
bi_brxx_cus
Replicação
REPLICA_3_EMPRESAS

Tags semânticas: INSTALACAO, MEDIDOR, TEMPORAL

Temporal: True · Colunas temporais: validade_de_etdz | validade_de_egerr | validade_de_easts | validade_ate_etdz | validade_ate_egerr | validade_ate_easts | data_criacao_etdz | data_modificacao_etdz | data_criacao_egerr | data_modificacao_egerr | data_criacao_easts | data_modificacao_easts · Status histórico: EXIGE_MIN_MAX_NOS_DADOS

Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA

Campos (48)

#CampoTipoNuloConceito sugeridoUso temporal
1cod_equipamentobigintSIMMEDIDORNAO_TEMPORAL
2registradorintegerSIMOUTRONAO_TEMPORAL
3instalacaobigintSIMINSTALACAONAO_TEMPORAL
4validade_de_etdztimestamp without time zoneSIMOUTROEVENTO_OU_VIGENCIA
5validade_de_egerrtimestamp without time zoneSIMOUTROEVENTO_OU_VIGENCIA
6validade_de_eaststimestamp without time zoneSIMOUTROEVENTO_OU_VIGENCIA
7validade_ate_etdztimestamp without time zoneSIMOUTROEVENTO_OU_VIGENCIA
8validade_ate_egerrtimestamp without time zoneSIMOUTROEVENTO_OU_VIGENCIA
9validade_ate_eaststimestamp without time zoneSIMOUTROEVENTO_OU_VIGENCIA
10num_registradorbigintSIMOUTRONAO_TEMPORAL
11num_equipamentobigintSIMMEDIDORNAO_TEMPORAL
12num_seriecharacter varyingSIMOUTRONAO_TEMPORAL
13tipo_setorcharacter varyingSIMOUTRONAO_TEMPORAL
14tipo_setor_textocharacter varyingSIMOUTRONAO_TEMPORAL
15ind_registradorcharacter varyingSIMOUTRONAO_TEMPORAL
16ind_registrador_textocharacter varyingSIMOUTRONAO_TEMPORAL
17cod_ind_registradorcharacter varyingSIMOUTRONAO_TEMPORAL
18tipo_registradorcharacter varyingSIMOUTRONAO_TEMPORAL
19tipo_registrador_textocharacter varyingSIMOUTRONAO_TEMPORAL
20conf_antes_virgula_registradorintegerSIMOUTRONAO_TEMPORAL
21conf_depois_virgula_registradorintegerSIMOUTRONAO_TEMPORAL
22tipo_registrador_2character varyingSIMOUTRONAO_TEMPORAL
23tipo_registrador_2_textocharacter varyingSIMOUTRONAO_TEMPORAL
24tipo_energiacharacter varyingSIMOUTRONAO_TEMPORAL
25tipo_energia_textocharacter varyingSIMOUTRONAO_TEMPORAL
26unidade_medidacharacter varyingSIMOUTRONAO_TEMPORAL
27unidade_medida_textocharacter varyingSIMOUTRONAO_TEMPORAL
28fator_registradornumericSIMOUTRONAO_TEMPORAL
29grupo_registradorcharacter varyingSIMOUTRONAO_TEMPORAL
30num_materialcharacter varyingSIMOUTRONAO_TEMPORAL
31tipo_equipamentocharacter varyingSIMMEDIDORNAO_TEMPORAL
32num_serie_fabricantecharacter varyingSIMOUTRONAO_TEMPORAL
33fabricante_imobilizadocharacter varyingSIMOUTRONAO_TEMPORAL
34flag_relevante_calccharacter varyingSIMOUTRONAO_TEMPORAL
35tipo_tarifacharacter varyingSIMOUTRONAO_TEMPORAL
36tipo_tarifa_textocharacter varyingSIMOUTRONAO_TEMPORAL
37data_criacao_etdztimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
38nome_criacao_etdzcharacter varyingSIMOUTRONAO_TEMPORAL
39data_modificacao_etdztimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
40nome_modificacao_etdzcharacter varyingSIMOUTRONAO_TEMPORAL
41data_criacao_egerrtimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
42nome_criacao_egerrcharacter varyingSIMOUTRONAO_TEMPORAL
43data_modificacao_egerrtimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
44nome_modificacao_egerrcharacter varyingSIMOUTRONAO_TEMPORAL
45data_criacao_eaststimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
46nome_criacao_eastscharacter varyingSIMOUTRONAO_TEMPORAL
47data_modificacao_eaststimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
48nome_modificacao_eastscharacter varyingSIMOUTRONAO_TEMPORAL
{'physical_metadata': 'confirmed', 'semantic_classification': 'suggested', 'physical_history_measurement': 'pending'}

bi_brrj_cus.bt_brrj_gd_instalacao

Empresa
ENEL RJ
Tipo
BASE TABLE
Taxonomia
Cliente, instalação e contrato
Prioridade TI
P1
Família de schema
bi_brxx_cus
Replicação
REPLICA_3_EMPRESAS

Tags semânticas: INSTALACAO, PERDAS, TEMPORAL

Temporal: True · Colunas temporais: data_do_protocolo | data_ligacao_uc | data_projeto_inicio | data_projeto_encerramento | data_direito_adquirido | data_perda_do_direito_adquirido | data_regra_de_transicao | data_irregularidade | data_processamento · Status histórico: EXIGE_MIN_MAX_NOS_DADOS

Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA

Campos (15)

#CampoTipoNuloConceito sugeridoUso temporal
1instalacaocharacter varyingSIMINSTALACAONAO_TEMPORAL
2data_do_protocolotimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
3data_ligacao_uctimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
4tipo_de_projetocharacter varyingSIMOUTRONAO_TEMPORAL
5data_projeto_iniciotimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
6data_projeto_encerramentotimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
7flag_direito_adquiridocharacter varyingSIMOUTRONAO_TEMPORAL
8data_direito_adquiridotimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
9flag_perda_do_direito_adquiridocharacter varyingSIMPERDASNAO_TEMPORAL
10data_perda_do_direito_adquiridotimestamp without time zoneSIMPERDASEVENTO_OU_VIGENCIA
11flag_regra_de_transicaocharacter varyingSIMOUTRONAO_TEMPORAL
12data_regra_de_transicaotimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
13flag_irregularidadecharacter varyingSIMPERDASNAO_TEMPORAL
14data_irregularidadetimestamp without time zoneSIMPERDASEVENTO_OU_VIGENCIA
15data_processamentotimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
{'physical_metadata': 'confirmed', 'semantic_classification': 'suggested', 'physical_history_measurement': 'pending'}

bi_brrj_cus.bt_brrj_implantados_mes

Empresa
ENEL RJ
Tipo
BASE TABLE
Taxonomia
Outros / transversal
Prioridade TI
P1
Família de schema
bi_brxx_cus
Replicação
REPLICA_3_EMPRESAS

Tags semânticas: INSTALACAO, CLIENTE, CONTRATO, MEDIDOR, FATURAMENTO, ORDENS, GD, CONTATO, QUALIDADE, REDE_GEO, SOCIAL, COMUNICACAO, CONTABIL, TEMPORAL

Temporal: True · Colunas temporais: createddate_pointofdelivery | cutoffdate__c | createddate_asset | lastmodifieddate_asset | installdate | createddate_account | lastmodifieddate_account | lastactivitydate | birthdate__c | createddate_billing_profile | cnt_due_date__c | suscriptiondate__c | startdate_contract | activateddate_contract | createddate_contract | lastmodifieddate_contract | enddate_contract | mainphone__c_datamodif | secondaryphone__c_datamodif | additionalphone__c_datamodif | carga_kw_br · Status histórico: EXIGE_MIN_MAX_NOS_DADOS

Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA

Campos (181)

#CampoTipoNuloConceito sugeridoUso temporal
1pointofdeliverynumber__ccharacter varyingSIMINSTALACAONAO_TEMPORAL
2dvnumberpointofdelivery__ccharacter varyingSIMINSTALACAONAO_TEMPORAL
3id_pointofdeliverycharacter varyingSIMINSTALACAONAO_TEMPORAL
4createddate_pointofdeliverytimestamp without time zoneSIMINSTALACAOEVENTO_OU_VIGENCIA
5companyid__c_pointofdeliverycharacter varyingSIMINSTALACAONAO_TEMPORAL
6billing_type__ccharacter varyingSIMFATURAMENTONAO_TEMPORAL
7connectionstatus__ccharacter varyingSIMOUTRONAO_TEMPORAL
8connectiontype__ccharacter varyingSIMOUTRONAO_TEMPORAL
9cutoffdate__ctimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
10electrodependant__ccharacter varyingSIMOUTRONAO_TEMPORAL
11pointofdeliverystatus__ccharacter varyingSIMINSTALACAONAO_TEMPORAL
12rate__ccharacter varyingSIMOUTRONAO_TEMPORAL
13route__ccharacter varyingSIMOUTRONAO_TEMPORAL
14segmenttype__ccharacter varyingSIMOUTRONAO_TEMPORAL
15servicetype__ccharacter varyingSIMORDENSNAO_TEMPORAL
16company__c_pointofdeliverycharacter varyingSIMINSTALACAONAO_TEMPORAL
17vip_customer_indicator__cdouble precisionSIMCLIENTENAO_TEMPORAL
18cnt_free_client__cdouble precisionSIMOUTRONAO_TEMPORAL
19cnt_white_rate__cdouble precisionSIMOUTRONAO_TEMPORAL
20distributionaddress__ccharacter varyingSIMCONTABILNAO_TEMPORAL
21notificationcontact__ccharacter varyingSIMCONTATONAO_TEMPORAL
22cnt_lowincometype__cbooleanSIMOUTRONAO_TEMPORAL
23zone__ccharacter varyingSIMOUTRONAO_TEMPORAL
24blacklist__cbooleanSIMOUTRONAO_TEMPORAL
25cnt_isgd__ccharacter varyingSIMGDNAO_TEMPORAL
26municipality__ccharacter varyingSIMREDE_GEONAO_TEMPORAL
27network_type__ccharacter varyingSIMREDE_GEONAO_TEMPORAL
28detailaddress__ccharacter varyingSIMOUTRONAO_TEMPORAL
29feedernumber__ccharacter varyingSIMOUTRONAO_TEMPORAL
30transformername__ccharacter varyingSIMOUTRONAO_TEMPORAL
31transformernumber__ccharacter varyingSIMOUTRONAO_TEMPORAL
32id_assetcharacter varyingSIMMEDIDORNAO_TEMPORAL
33contactidcharacter varyingSIMCONTATONAO_TEMPORAL
34accountidcharacter varyingSIMCLIENTENAO_TEMPORAL
35accountrollupidcharacter varyingSIMCLIENTENAO_TEMPORAL
36createddate_assettimestamp without time zoneSIMMEDIDOREVENTO_OU_VIGENCIA
37lastmodifieddate_assettimestamp without time zoneSIMMEDIDOREVENTO_OU_VIGENCIA
38name_assetcharacter varyingSIMMEDIDORNAO_TEMPORAL
39installdatetimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
40status_assetcharacter varyingSIMMEDIDORNAO_TEMPORAL
41description_assetcharacter varyingSIMMEDIDORNAO_TEMPORAL
42type__c_assetcharacter varyingSIMMEDIDORNAO_TEMPORAL
43company__c_assetcharacter varyingSIMMEDIDORNAO_TEMPORAL
44externalid__c_assetcharacter varyingSIMMEDIDORNAO_TEMPORAL
45ne__status__c_assetcharacter varyingSIMMEDIDORNAO_TEMPORAL
46id_accountcharacter varyingSIMCLIENTENAO_TEMPORAL
47name_accountcharacter varyingSIMCLIENTENAO_TEMPORAL
48accountnumbercharacter varyingSIMCLIENTENAO_TEMPORAL
49tipo_contacharacter varyingSIMOUTRONAO_TEMPORAL
50createddate_accounttimestamp without time zoneSIMCLIENTEEVENTO_OU_VIGENCIA
51lastmodifieddate_accounttimestamp without time zoneSIMCLIENTEEVENTO_OU_VIGENCIA
52lastactivitydatetimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
53additionalphone__ccharacter varyingSIMOUTRONAO_TEMPORAL
54birthdate__ctimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
55businessname__ccharacter varyingSIMOUTRONAO_TEMPORAL
56companyid__c_accountcharacter varyingSIMCLIENTENAO_TEMPORAL
57company__c_accountcharacter varyingSIMCLIENTENAO_TEMPORAL
58externalid__c_accountcharacter varyingSIMCLIENTENAO_TEMPORAL
59ne__status__c_accountcharacter varyingSIMCLIENTENAO_TEMPORAL
60countryb2b__ccharacter varyingSIMOUTRONAO_TEMPORAL
61accountclientnumber__ccharacter varyingSIMCLIENTENAO_TEMPORAL
62pais__ccharacter varyingSIMOUTRONAO_TEMPORAL
63executive__ccharacter varyingSIMOUTRONAO_TEMPORAL
64cnt_responsible_name__ccharacter varyingSIMOUTRONAO_TEMPORAL
65cnt_resp_id_type__ccharacter varyingSIMOUTRONAO_TEMPORAL
66cnt_resp_id_number__ccharacter varyingSIMOUTRONAO_TEMPORAL
67cnt_responsible_phone__ccharacter varyingSIMOUTRONAO_TEMPORAL
68cnt_responsible_email__ccharacter varyingSIMCONTATONAO_TEMPORAL
69cnt_responsible_charge__ccharacter varyingSIMOUTRONAO_TEMPORAL
70cnt_numorgcntr__ccharacter varyingSIMOUTRONAO_TEMPORAL
71cnt_fantasy_name__ccharacter varyingSIMOUTRONAO_TEMPORAL
72recordtypeidcharacter varyingSIMOUTRONAO_TEMPORAL
73cnt_mothers_full_name__ccharacter varyingSIMOUTRONAO_TEMPORAL
74cnt_id_type_2__ccharacter varyingSIMOUTRONAO_TEMPORAL
75cnt_id_num_2__ccharacter varyingSIMOUTRONAO_TEMPORAL
76cnt_state_inscription__ccharacter varyingSIMOUTRONAO_TEMPORAL
77cnt_state_inscription_exemption__ccharacter varyingSIMOUTRONAO_TEMPORAL
78cnt_municipality_inscription__ccharacter varyingSIMREDE_GEONAO_TEMPORAL
79cnt_is_postal_address__ccharacter varyingSIMOUTRONAO_TEMPORAL
80acceptenelcommunication__ccharacter varyingSIMREDE_GEONAO_TEMPORAL
81cnt_customerchannel__ccharacter varyingSIMCLIENTENAO_TEMPORAL
82id_contract__c_contract_linecharacter varyingSIMCONTRATONAO_TEMPORAL
83id_billing_profile__c_contract_linecharacter varyingSIMCONTRATONAO_TEMPORAL
84id_asset__c_contract_linecharacter varyingSIMCONTRATONAO_TEMPORAL
85pointofdelivery__ccharacter varyingSIMINSTALACAONAO_TEMPORAL
86accountcontract__ccharacter varyingSIMCLIENTENAO_TEMPORAL
87currentaccount__cdouble precisionSIMCLIENTENAO_TEMPORAL
88createddate_billing_profiletimestamp without time zoneSIMFATURAMENTOEVENTO_OU_VIGENCIA
89name_billing_profilecharacter varyingSIMFATURAMENTONAO_TEMPORAL
90edeenrolment__cdouble precisionSIMOUTRONAO_TEMPORAL
91delivery_type__ccharacter varyingSIMOUTRONAO_TEMPORAL
92cnt_due_date__ccharacter varyingSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
93edesuscmassive__cbooleanSIMOUTRONAO_TEMPORAL
94publiccharge__cbooleanSIMOUTRONAO_TEMPORAL
95lowamount__cbooleanSIMOUTRONAO_TEMPORAL
96type__c_billing_profilecharacter varyingSIMFATURAMENTONAO_TEMPORAL
97suscriptiondate__ctimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
98id_contractcharacter varyingSIMCONTRATONAO_TEMPORAL
99startdate_contracttimestamp without time zoneSIMCONTRATOEVENTO_OU_VIGENCIA
100activateddate_contracttimestamp without time zoneSIMCONTRATOEVENTO_OU_VIGENCIA
101createddate_contracttimestamp without time zoneSIMCONTRATOEVENTO_OU_VIGENCIA
102lastmodifieddate_contracttimestamp without time zoneSIMCONTRATOEVENTO_OU_VIGENCIA
103enddate_contracttimestamp without time zoneSIMCONTRATOEVENTO_OU_VIGENCIA
104status_contractcharacter varyingSIMCONTRATONAO_TEMPORAL
105description_contractcharacter varyingSIMCONTRATONAO_TEMPORAL
106statuscod_contractcharacter varyingSIMCONTRATONAO_TEMPORAL
107contractnumber_contractcharacter varyingSIMCONTRATONAO_TEMPORAL
108contract_type__c_contractcharacter varyingSIMCONTRATONAO_TEMPORAL
109cnt_economical_activity__c_contractcharacter varyingSIMCONTRATONAO_TEMPORAL
110coordinatex__ccharacter varyingSIMOUTRONAO_TEMPORAL
111coordinatey__ccharacter varyingSIMOUTRONAO_TEMPORAL
112id_adresscharacter varyingSIMOUTRONAO_TEMPORAL
113literal_municipality__ccharacter varyingSIMREDE_GEONAO_TEMPORAL
114literal_region__ccharacter varyingSIMOUTRONAO_TEMPORAL
115literal_street_type__ccharacter varyingSIMOUTRONAO_TEMPORAL
116neighbourhood__ccharacter varyingSIMOUTRONAO_TEMPORAL
117postal_code__ccharacter varyingSIMOUTRONAO_TEMPORAL
118street__ccharacter varyingSIMOUTRONAO_TEMPORAL
119idstreetcharacter varyingSIMOUTRONAO_TEMPORAL
120identitytype__ccharacter varyingSIMOUTRONAO_TEMPORAL
121clienteativodouble precisionSIMCLIENTENAO_TEMPORAL
122despersonalizadodouble precisionSIMOUTRONAO_TEMPORAL
123celularcharacter varyingSIMCONTATONAO_TEMPORAL
124fixocharacter varyingSIMOUTRONAO_TEMPORAL
125com_telefonedouble precisionSIMCONTATONAO_TEMPORAL
126emailcharacter varyingSIMCONTATONAO_TEMPORAL
127mainphone__ccharacter varyingSIMOUTRONAO_TEMPORAL
128secondaryphone__ccharacter varyingSIMOUTRONAO_TEMPORAL
129primaryemail__ccharacter varyingSIMCONTATONAO_TEMPORAL
130secondaryemail__ccharacter varyingSIMCONTATONAO_TEMPORAL
131identitynumber__ccharacter varyingSIMOUTRONAO_TEMPORAL
132primaryemail__c_validacaodouble precisionSIMCONTATONAO_TEMPORAL
133secondaryemail__c_dominiocharacter varyingSIMCONTATONAO_TEMPORAL
134secondaryemail__c_validacaodouble precisionSIMCONTATONAO_TEMPORAL
135identitynumber__c_validacaodouble precisionSIMQUALIDADENAO_TEMPORAL
136mainphone__c_tipotelefonecharacter varyingSIMCONTATONAO_TEMPORAL
137secondaryphone__c_tipotelefonecharacter varyingSIMCONTATONAO_TEMPORAL
138additionalphone__c_tipotelefonecharacter varyingSIMCONTATONAO_TEMPORAL
139mainphone__c_datamodiftimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
140mainphone__c_usuariomodif_character varyingSIMOUTRONAO_TEMPORAL
141mainphone__c_usuario_modif_character varyingSIMOUTRONAO_TEMPORAL
142mainphone__c_brusuariocharacter varyingSIMOUTRONAO_TEMPORAL
143mainphone__c_cargousuariocharacter varyingSIMOUTRONAO_TEMPORAL
144mainphone__c_areausuariocharacter varyingSIMOUTRONAO_TEMPORAL
145secondaryphone__c_datamodiftimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
146secondaryphone__c_usuariomodif_character varyingSIMOUTRONAO_TEMPORAL
147secondaryphone__c_usuario_modif_character varyingSIMOUTRONAO_TEMPORAL
148secondaryphone__c_brusuariocharacter varyingSIMOUTRONAO_TEMPORAL
149secondaryphone__c_cargousuariocharacter varyingSIMOUTRONAO_TEMPORAL
150secondaryphone__c_areausuariocharacter varyingSIMOUTRONAO_TEMPORAL
151additionalphone__c_datamodiftimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
152additionalphone__c_usuariomodifcharacter varyingSIMOUTRONAO_TEMPORAL
153additionalphone__c_usuario_modif_character varyingSIMOUTRONAO_TEMPORAL
154additionalphone__c_brusuariocharacter varyingSIMOUTRONAO_TEMPORAL
155additionalphone__c_cargousuariocharacter varyingSIMOUTRONAO_TEMPORAL
156additionalphone__c_areausuariocharacter varyingSIMOUTRONAO_TEMPORAL
157mainphone__c_validacaodouble precisionSIMQUALIDADENAO_TEMPORAL
158secondaryphone__c_validacaodouble precisionSIMQUALIDADENAO_TEMPORAL
159additionalphone__c_validacaodouble precisionSIMQUALIDADENAO_TEMPORAL
160cpnj_validodouble precisionSIMOUTRONAO_TEMPORAL
161cpf_validodouble precisionSIMOUTRONAO_TEMPORAL
162classe_brcharacter varyingSIMOUTRONAO_TEMPORAL
163subclasse_brcharacter varyingSIMOUTRONAO_TEMPORAL
164categoria_de_tarifa_brcharacter varyingSIMOUTRONAO_TEMPORAL
165carga_kw_brcharacter varyingSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
166nivel_de_tensao_brcharacter varyingSIMOUTRONAO_TEMPORAL
167parceirocharacter varyingSIMCLIENTENAO_TEMPORAL
168conta_contratocharacter varyingSIMCONTRATONAO_TEMPORAL
169mov_incharacter varyingSIMOUTRONAO_TEMPORAL
170mov_outcharacter varyingSIMOUTRONAO_TEMPORAL
171setor_industrialcharacter varyingSIMOUTRONAO_TEMPORAL
172zona_temperaturacharacter varyingSIMCOMUNICACAONAO_TEMPORAL
173categoria_tarifacharacter varyingSIMOUTRONAO_TEMPORAL
174instalacaobigintSIMINSTALACAONAO_TEMPORAL
175local_consumocharacter varyingSIMFATURAMENTONAO_TEMPORAL
176ruacharacter varyingSIMOUTRONAO_TEMPORAL
177estado_clientecharacter varyingSIMCLIENTENAO_TEMPORAL
178classe_synergiacharacter varyingSIMOUTRONAO_TEMPORAL
179subclasse_synergiacharacter varyingSIMOUTRONAO_TEMPORAL
180estado_suministrocharacter varyingSIMSOCIALNAO_TEMPORAL
181dica_localizacaocharacter varyingSIMOUTRONAO_TEMPORAL
{'physical_metadata': 'confirmed', 'semantic_classification': 'suggested', 'physical_history_measurement': 'pending'}

bi_brrj_cus.bt_brrj_insp_e_fup_perdas

Empresa
ENEL RJ
Tipo
BASE TABLE
Taxonomia
Perdas, inspeção, TOI e CNR
Prioridade TI
P1
Família de schema
bi_brxx_cus
Replicação
REPLICA_3_EMPRESAS

Tags semânticas: CLIENTE, MEDIDOR, FATURAMENTO, PERDAS, REDE_GEO, COMUNICACAO, TEMPORAL, ATUALIZACAO, COMPETENCIA

Temporal: True · Colunas temporais: data_normalizacao | referencia_normalizacao | referencia_fatura_anterior | referencia_fatura_atual | data_etl | data_ingesta | referencia_follow_up · Status histórico: EXIGE_MIN_MAX_NOS_DADOS

Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA

Campos (40)

#CampoTipoNuloConceito sugeridoUso temporal
1cliente_idintegerSIMCLIENTENAO_TEMPORAL
2codigo_podintegerSIMOUTRONAO_TEMPORAL
3nivel_tensaocharacter varyingSIMOUTRONAO_TEMPORAL
4grupocharacter varyingSIMOUTRONAO_TEMPORAL
5loteintegerSIMOUTRONAO_TEMPORAL
6tipo_medicaocharacter varyingSIMOUTRONAO_TEMPORAL
7classecharacter varyingSIMOUTRONAO_TEMPORAL
8subclassecharacter varyingSIMOUTRONAO_TEMPORAL
9estadocharacter varyingSIMOUTRONAO_TEMPORAL
10municipio_ibgebigintSIMREDE_GEONAO_TEMPORAL
11municipiocharacter varyingSIMREDE_GEONAO_TEMPORAL
12regionalcharacter varyingSIMREDE_GEONAO_TEMPORAL
13unid_operacionalcharacter varyingSIMOUTRONAO_TEMPORAL
14sucursalcharacter varyingSIMREDE_GEONAO_TEMPORAL
15normalizacao_idcharacter varyingSIMPERDASNAO_TEMPORAL
16medidor_inspecionado_idcharacter varyingSIMMEDIDORNAO_TEMPORAL
17tipo_medidorcharacter varyingSIMMEDIDORNAO_TEMPORAL
18inspecao_origem_idcharacter varyingSIMPERDASNAO_TEMPORAL
19inspecao_origem_desccharacter varyingSIMPERDASNAO_TEMPORAL
20inspecao_tipo_policycharacter varyingSIMPERDASNAO_TEMPORAL
21data_normalizacaocharacter varyingSIMPERDASEVENTO_OU_VIGENCIA
22equipe_normalizacao_desccharacter varyingSIMPERDASNAO_TEMPORAL
23equipe_normalizacao_idcharacter varyingSIMPERDASNAO_TEMPORAL
24referencia_normalizacaointegerSIMPERDASCOBERTURA_HISTORICA
25referencia_follow_upintegerSIMCOMPETENCIA_REFERENCIACOBERTURA_HISTORICA
26origem_fupcharacter varyingSIMOUTRONAO_TEMPORAL
27projetocharacter varyingSIMOUTRONAO_TEMPORAL
28statuscharacter varyingSIMOUTRONAO_TEMPORAL
29referencia_fatura_anteriorcharacter varyingSIMFATURAMENTOCOBERTURA_HISTORICA
30referencia_fatura_atualintegerSIMFATURAMENTOCOBERTURA_HISTORICA
31energia_total_anteriordouble precisionSIMOUTRONAO_TEMPORAL
32energia_total_atualdouble precisionSIMOUTRONAO_TEMPORAL
33calculo_finaldouble precisionSIMOUTRONAO_TEMPORAL
34data_etlcharacter varyingSIMATUALIZACAO_CARGAATUALIZACAO_FISICA
35tipo_de_ligacaocharacter varyingSIMOUTRONAO_TEMPORAL
36subclustercharacter varyingSIMOUTRONAO_TEMPORAL
37consumo_artbigintSIMFATURAMENTONAO_TEMPORAL
38cluster_de_inspecoescharacter varyingSIMPERDASNAO_TEMPORAL
39ind_gdcharacter varyingSIMOUTRONAO_TEMPORAL
40data_ingestacharacter varyingSIMATUALIZACAO_CARGAATUALIZACAO_FISICA
{'physical_metadata': 'confirmed', 'semantic_classification': 'suggested', 'physical_history_measurement': 'pending'}

bi_brrj_cus.bt_brrj_instalacao

Empresa
ENEL RJ
Tipo
BASE TABLE
Taxonomia
Cliente, instalação e contrato
Prioridade TI
P1
Família de schema
bi_brxx_cus
Replicação
REPLICA_3_EMPRESAS

Tags semânticas: INSTALACAO, CONTRATO, LEITURA, FATURAMENTO, REDE_GEO, COMUNICACAO, CONTABIL, TEMPORAL

Temporal: True · Colunas temporais: validade_de | data_criacao_eanl | data_modificacao_eanl | data_criacao_evbs | data_modificacao_evbs | data_criacao_iflot | data_modificacao_iflot | validade_ate · Status histórico: EXIGE_MIN_MAX_NOS_DADOS

Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA

Campos (57)

#CampoTipoNuloConceito sugeridoUso temporal
1instalacaobigintSIMINSTALACAONAO_TEMPORAL
2validade_detimestamp without time zoneSIMOUTROEVENTO_OU_VIGENCIA
3validade_atetimestamp without time zoneSIMOUTROEVENTO_OU_VIGENCIA
4setor_atividadecharacter varyingSIMOUTRONAO_TEMPORAL
5setor_atividade_textocharacter varyingSIMOUTRONAO_TEMPORAL
6nivel_tensaocharacter varyingSIMOUTRONAO_TEMPORAL
7nivel_tensao_textocharacter varyingSIMOUTRONAO_TEMPORAL
8tipo_instalacaocharacter varyingSIMINSTALACAONAO_TEMPORAL
9tipo_instalacao_textocharacter varyingSIMINSTALACAONAO_TEMPORAL
10motivo_garantiacharacter varyingSIMOUTRONAO_TEMPORAL
11motivo_garantia_textocharacter varyingSIMOUTRONAO_TEMPORAL
12categoria_tarifacharacter varyingSIMOUTRONAO_TEMPORAL
13categoria_tarifa_textocharacter varyingSIMOUTRONAO_TEMPORAL
14sistema_setorialcharacter varyingSIMOUTRONAO_TEMPORAL
15sistema_setorial_textocharacter varyingSIMOUTRONAO_TEMPORAL
16setor_industrialcharacter varyingSIMOUTRONAO_TEMPORAL
17setor_industrial_textocharacter varyingSIMOUTRONAO_TEMPORAL
18classe_calculocharacter varyingSIMOUTRONAO_TEMPORAL
19classe_calculo_textocharacter varyingSIMOUTRONAO_TEMPORAL
20subclassecharacter varyingSIMOUTRONAO_TEMPORAL
21subclasse_textocharacter varyingSIMOUTRONAO_TEMPORAL
22segmentocharacter varyingSIMOUTRONAO_TEMPORAL
23contrato_concessaocharacter varyingSIMCONTRATONAO_TEMPORAL
24unidade_leituracharacter varyingSIMLEITURANAO_TEMPORAL
25lotecharacter varyingSIMOUTRONAO_TEMPORAL
26grupocharacter varyingSIMOUTRONAO_TEMPORAL
27local_consumocharacter varyingSIMFATURAMENTONAO_TEMPORAL
28objeto_ligacaocharacter varyingSIMOUTRONAO_TEMPORAL
29local_classe_contabilcharacter varyingSIMCONTABILNAO_TEMPORAL
30enderecocharacter varyingSIMOUTRONAO_TEMPORAL
31paischaracter varyingSIMOUTRONAO_TEMPORAL
32regiaocharacter varyingSIMOUTRONAO_TEMPORAL
33cidadecharacter varyingSIMREDE_GEONAO_TEMPORAL
34bairrocharacter varyingSIMOUTRONAO_TEMPORAL
35codigo_postalcharacter varyingSIMOUTRONAO_TEMPORAL
36ruacharacter varyingSIMOUTRONAO_TEMPORAL
37numerocharacter varyingSIMOUTRONAO_TEMPORAL
38complemento_01character varyingSIMOUTRONAO_TEMPORAL
39complemento_02character varyingSIMOUTRONAO_TEMPORAL
40numero_local_instalacaocharacter varyingSIMINSTALACAONAO_TEMPORAL
41complemento_03character varyingSIMOUTRONAO_TEMPORAL
42complemento_04character varyingSIMOUTRONAO_TEMPORAL
43complemento_05character varyingSIMOUTRONAO_TEMPORAL
44domicilio_fiscalcharacter varyingSIMOUTRONAO_TEMPORAL
45domicilio_fiscal_textocharacter varyingSIMOUTRONAO_TEMPORAL
46data_criacao_eanltimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
47nome_criacao_eanlcharacter varyingSIMOUTRONAO_TEMPORAL
48data_modificacao_eanltimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
49nome_modificacao_eanlcharacter varyingSIMOUTRONAO_TEMPORAL
50data_criacao_evbstimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
51nome_criacao_evbscharacter varyingSIMOUTRONAO_TEMPORAL
52data_modificacao_evbstimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
53nome_modificacao_evbscharacter varyingSIMOUTRONAO_TEMPORAL
54data_criacao_iflottimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
55nome_criacao_iflotcharacter varyingSIMOUTRONAO_TEMPORAL
56data_modificacao_iflottimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
57nome_modificacao_iflotcharacter varyingSIMOUTRONAO_TEMPORAL