Base RCO / Objetos / ENEL SP / bi_brsp_con
19 objetos nesta página. Conteúdo gerado diretamente do catálogo estruturado e do arquivo RAG do pacote oficial.
bi_brsp_con.bt_mot_03_responsebi_brsp_con.bt_mot_06_responsebi_brsp_con.bt_mot_08_responsebi_brsp_con.bt_mot_09_responsebi_brsp_con.agg_mot_01_contactbi_brsp_con.agg_mot_02_responsebi_brsp_con.agg_mot_03_responsebi_brsp_con.agg_mot_04_responsebi_brsp_con.agg_mot_05_responsebi_brsp_con.agg_mot_06_responsebi_brsp_con.agg_mot_07_responsebi_brsp_con.agg_mot_08_responsebi_brsp_con.agg_mot_09_responsebi_brsp_con.bt_mot_01_responsebi_brsp_con.bt_mot_02_responsebi_brsp_con.bt_mot_02_send_spbi_brsp_con.bt_mot_04_responsebi_brsp_con.bt_mot_05_responsebi_brsp_con.bt_mot_07_response
bi_brsp_con.bt_mot_03_response
Tags semânticas: INSTALACAO, CLIENTE, CONTRATO, FATURAMENTO, COBRANCA, CONTATO, PESQUISA, TEMPORAL, COMPETENCIA
Temporal: True · Colunas temporais: date_payment | date_document | date_release | date_input | answerdate | period | sentdate · Status histórico: EXIGE_MIN_MAX_NOS_DADOS
Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA
Campos (25)
| # | Campo | Tipo | Nulo | Conceito sugerido | Uso temporal |
|---|---|---|---|---|---|
| 1 | date_payment | timestamp without time zone | SIM | COBRANCA | EVENTO_OU_VIGENCIA |
| 2 | date_document | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 3 | date_release | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 4 | invoice_amount | numeric | SIM | FATURAMENTO | NAO_TEMPORAL |
| 5 | channel | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 6 | bank | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 7 | city | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 8 | lot | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 9 | installation | bigint | SIM | INSTALACAO | NAO_TEMPORAL |
| 10 | contract_account | bigint | SIM | CLIENTE | NAO_TEMPORAL |
| 11 | email | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 12 | date_input | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 13 | sentdate | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 14 | answerdate | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 15 | overall_satisfaction | character varying | SIM | PESQUISA | NAO_TEMPORAL |
| 16 | ease_of_payment | character varying | SIM | COBRANCA | NAO_TEMPORAL |
| 17 | payment_methods | character varying | SIM | COBRANCA | NAO_TEMPORAL |
| 18 | expirience_what_can_improve | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 19 | company_id | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 20 | city_sf | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 21 | thanks_page | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 22 | installation_2 | bigint | SIM | INSTALACAO | NAO_TEMPORAL |
| 23 | file | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 24 | company | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 25 | period | integer | SIM | COMPETENCIA_REFERENCIA | COBERTURA_HISTORICA |
bi_brsp_con.bt_mot_06_response
Tags semânticas: INSTALACAO, CLIENTE, FATURAMENTO, CONTATO, PESQUISA, TEMPORAL, COMPETENCIA
Temporal: True · Colunas temporais: date_delivery | date_due | date_emission | sentdate | answerdate | opendate | clickdate | date_input | period · 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 | installation | bigint | SIM | INSTALACAO | NAO_TEMPORAL |
| 2 | type_event | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 3 | date_delivery | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 4 | date_due | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 5 | date_emission | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 6 | value_invoice | numeric | SIM | FATURAMENTO | NAO_TEMPORAL |
| 7 | email | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 8 | customer_key | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 9 | company_id | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 10 | city_sf | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 11 | sentdate | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 12 | answerdate | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 13 | opendate | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 14 | clickdate | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 15 | overall_satisfaction | character varying | SIM | PESQUISA | NAO_TEMPORAL |
| 16 | ease_of_access | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 17 | clear_complete_information | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 18 | value_correct_with_consumption | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 19 | experience_what_can_improve | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 20 | offered_receive_invoice_by_email | character varying | SIM | FATURAMENTO | NAO_TEMPORAL |
| 21 | interested_receiving_invoice_by_email | character varying | SIM | FATURAMENTO | NAO_TEMPORAL |
| 22 | main_reason_keep_paper_invoice | character varying | SIM | FATURAMENTO | NAO_TEMPORAL |
| 23 | invoice_delivered_within_expected_time | character varying | SIM | FATURAMENTO | NAO_TEMPORAL |
| 24 | thanks_page | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 25 | installation_2 | character varying | SIM | INSTALACAO | NAO_TEMPORAL |
| 26 | date_input | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 27 | file | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 28 | company | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 29 | period | integer | SIM | COMPETENCIA_REFERENCIA | COBERTURA_HISTORICA |
| 30 | had_face_to_face_contact_enel_professional | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 31 | satisfied_enel_professional | character varying | SIM | PESQUISA | NAO_TEMPORAL |
| 32 | why_choose_this_note | character varying | SIM | OUTRO | NAO_TEMPORAL |
bi_brsp_con.bt_mot_08_response
Tags semânticas: INSTALACAO, CLIENTE, MEDIDOR, RECLAMACAO, CONTATO, PESQUISA, CONTABIL, TEMPORAL, COMPETENCIA
Temporal: True · Colunas temporais: date_close | date_admission | date_expected_end | sent_date | answer_date | opendate | clickdate | date_input | period · Status histórico: EXIGE_MIN_MAX_NOS_DADOS
Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA
Campos (55)
| # | Campo | Tipo | Nulo | Conceito sugerido | Uso temporal |
|---|---|---|---|---|---|
| 1 | id_claim | character varying | SIM | RECLAMACAO | NAO_TEMPORAL |
| 2 | flag | integer | SIM | OUTRO | NAO_TEMPORAL |
| 3 | sub_id | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 4 | distributor | character varying | SIM | CONTABIL | NAO_TEMPORAL |
| 5 | direction | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 6 | feeder | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 7 | area | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 8 | subject | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 9 | date_close | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 10 | date_admission | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 11 | management | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 12 | department | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 13 | channel | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 14 | code_reason_aneel | character varying | SIM | RECLAMACAO | NAO_TEMPORAL |
| 15 | detail | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 16 | detail_control_cx | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 17 | division | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 18 | level | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 19 | type_voltage | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 20 | status | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 21 | system_origin | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 22 | smartmeter | character varying | SIM | MEDIDOR | NAO_TEMPORAL |
| 23 | customer_number | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 24 | sla_progress | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 25 | prc_term_closed | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 26 | city | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 27 | reason_aneel | character varying | SIM | RECLAMACAO | NAO_TEMPORAL |
| 28 | taxonomy | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 29 | cause | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 30 | detailed_cause | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 31 | origination | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 32 | sla_closed | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 33 | date_expected_end | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 34 | id_from_to | integer | SIM | OUTRO | NAO_TEMPORAL |
| 35 | email | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 36 | installation | bigint | SIM | INSTALACAO | NAO_TEMPORAL |
| 37 | customer_key | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 38 | company_id | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 39 | city_sf | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 40 | sent_date | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 41 | answer_date | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 42 | opendate | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 43 | clickdate | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 44 | overall_satisfaction | character varying | SIM | PESQUISA | NAO_TEMPORAL |
| 45 | received_written_answer | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 46 | answer_was_clear | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 47 | complaint_has_been_properly_analyzed | character varying | SIM | RECLAMACAO | NAO_TEMPORAL |
| 48 | response_deadline_met | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 49 | complaint_what_can_improved | character varying | SIM | RECLAMACAO | NAO_TEMPORAL |
| 50 | thanks_page | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 51 | installation_2 | character varying | SIM | INSTALACAO | NAO_TEMPORAL |
| 52 | date_input | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 53 | file | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 54 | company | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 55 | period | integer | SIM | COMPETENCIA_REFERENCIA | COBERTURA_HISTORICA |
bi_brsp_con.bt_mot_09_response
Tags semânticas: CLIENTE, CONTRATO, CONTATO, PESQUISA, TEMPORAL, COMPETENCIA
Temporal: True · Colunas temporais: ebill_start_date | contract_start_date | sent_date | answer_date | date_input | period · Status histórico: EXIGE_MIN_MAX_NOS_DADOS
Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA
Campos (23)
| # | Campo | Tipo | Nulo | Conceito sugerido | Uso temporal |
|---|---|---|---|---|---|
| 1 | install | bigint | SIM | OUTRO | NAO_TEMPORAL |
| 2 | account_contract | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 3 | ebill_start_date | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 4 | contract_start_date | timestamp without time zone | SIM | CONTRATO | EVENTO_OU_VIGENCIA |
| 5 | emailaddress | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 6 | city | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 7 | customer_key | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 8 | company_id | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 9 | city_sf | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 10 | sent_date | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 11 | answer_date | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 12 | overall_satisfaction | character varying | SIM | PESQUISA | NAO_TEMPORAL |
| 13 | ease_of_register | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 14 | information_was_clear | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 15 | influence_to_optate | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 16 | influence_to_optate_open_text | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 17 | what_can_improve | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 18 | thanks_page | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 19 | install_2 | bigint | SIM | OUTRO | NAO_TEMPORAL |
| 20 | date_input | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 21 | file | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 22 | company | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 23 | period | integer | SIM | COMPETENCIA_REFERENCIA | COBERTURA_HISTORICA |
bi_brsp_con.agg_mot_01_contact
Tags semânticas: ORDENS, PESQUISA, TEMPORAL, COMPETENCIA
Temporal: True · Colunas temporais: date_open | send_date_archive | sentdate | opendate | clickdate | date_response | period · Status histórico: EXIGE_MIN_MAX_NOS_DADOS
Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA
Campos (20)
| # | Campo | Tipo | Nulo | Conceito sugerido | Uso temporal |
|---|---|---|---|---|---|
| 1 | date_open | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 2 | channel | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 3 | cause | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 4 | subcause | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 5 | attendant | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 6 | company | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 7 | send_date_archive | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 8 | sentdate | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 9 | opendate | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 10 | clickdate | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 11 | date_response | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 12 | overall_satisfaction | character varying | SIM | PESQUISA | NAO_TEMPORAL |
| 13 | ease_of_request | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 14 | clear_statements | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 15 | cortez_attendant | character varying | SIM | ORDENS | NAO_TEMPORAL |
| 16 | satisfactory_solution | character varying | SIM | PESQUISA | NAO_TEMPORAL |
| 17 | service_satisfaction | character varying | SIM | ORDENS | NAO_TEMPORAL |
| 18 | funnel_type | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 19 | quantity | integer | SIM | OUTRO | NAO_TEMPORAL |
| 20 | period | integer | SIM | COMPETENCIA_REFERENCIA | COBERTURA_HISTORICA |
bi_brsp_con.agg_mot_02_response
Tags semânticas: ORDENS, CONTATO, PESQUISA, TEMPORAL, COMPETENCIA
Temporal: True · Colunas temporais: date_request | date_conclusion | send_date_archive | sentdate | answerdate | opendate | clickdate | period · Status histórico: EXIGE_MIN_MAX_NOS_DADOS
Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA
Campos (19)
| # | Campo | Tipo | Nulo | Conceito sugerido | Uso temporal |
|---|---|---|---|---|---|
| 1 | date_request | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 2 | date_conclusion | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 3 | service | character varying | SIM | ORDENS | NAO_TEMPORAL |
| 4 | electrician | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 5 | send_date_archive | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 6 | sentdate | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 7 | answerdate | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 8 | opendate | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 9 | clickdate | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 10 | overall_satisfaction | character varying | SIM | PESQUISA | NAO_TEMPORAL |
| 11 | ease_of_request | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 12 | deadline_completed | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 13 | information_was_satisfactory | character varying | SIM | PESQUISA | NAO_TEMPORAL |
| 14 | had_to_contact | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 15 | would_like_receive_communication | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 16 | company | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 17 | funnel_type | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 18 | quantity | integer | SIM | OUTRO | NAO_TEMPORAL |
| 19 | period | integer | SIM | COMPETENCIA_REFERENCIA | COBERTURA_HISTORICA |
bi_brsp_con.agg_mot_03_response
Tags semânticas: FATURAMENTO, COBRANCA, PESQUISA, TEMPORAL, COMPETENCIA
Temporal: True · Colunas temporais: date_payment | date_document | date_release | sentdate | answerdate | period · Status histórico: EXIGE_MIN_MAX_NOS_DADOS
Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA
Campos (14)
| # | Campo | Tipo | Nulo | Conceito sugerido | Uso temporal |
|---|---|---|---|---|---|
| 1 | date_payment | timestamp without time zone | SIM | COBRANCA | EVENTO_OU_VIGENCIA |
| 2 | date_document | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 3 | date_release | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 4 | bank | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 5 | sentdate | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 6 | answerdate | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 7 | overall_satisfaction | character varying | SIM | PESQUISA | NAO_TEMPORAL |
| 8 | ease_of_payment | character varying | SIM | COBRANCA | NAO_TEMPORAL |
| 9 | payment_methods | character varying | SIM | COBRANCA | NAO_TEMPORAL |
| 10 | funnel_type | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 11 | company | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 12 | range_invoice_amount | character varying | SIM | FATURAMENTO | NAO_TEMPORAL |
| 13 | quantity | integer | SIM | OUTRO | NAO_TEMPORAL |
| 14 | period | integer | SIM | COMPETENCIA_REFERENCIA | COBERTURA_HISTORICA |
bi_brsp_con.agg_mot_04_response
Tags semânticas: CONTATO, PESQUISA, TEMPORAL, COMPETENCIA
Temporal: True · Colunas temporais: date_open | date_close | send_date_archive | sentdate | answerdate | opendate | clickdate | period · Status histórico: EXIGE_MIN_MAX_NOS_DADOS
Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA
Campos (22)
| # | Campo | Tipo | Nulo | Conceito sugerido | Uso temporal |
|---|---|---|---|---|---|
| 1 | type_of_research | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 2 | segment | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 3 | date_open | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 4 | date_close | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 5 | reason | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 6 | attendant | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 7 | channel | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 8 | send_date_archive | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 9 | sentdate | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 10 | answerdate | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 11 | opendate | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 12 | clickdate | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 13 | overall_satisfaction | character varying | SIM | PESQUISA | NAO_TEMPORAL |
| 14 | deadline_completed | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 15 | ease_of_request | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 16 | had_to_contact | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 17 | which_channel_warned | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 18 | received_any_communication | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 19 | funnel_type | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 20 | company | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 21 | quantity | integer | SIM | OUTRO | NAO_TEMPORAL |
| 22 | period | integer | SIM | COMPETENCIA_REFERENCIA | COBERTURA_HISTORICA |
bi_brsp_con.agg_mot_05_response
Tags semânticas: ORDENS, PESQUISA, TEMPORAL, COMPETENCIA
Temporal: True · Colunas temporais: date_open | sentdate | answerdate | opendate | clickdate | period · 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 | date_open | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 2 | channel | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 3 | service | character varying | SIM | ORDENS | NAO_TEMPORAL |
| 4 | attendant | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 5 | sentdate | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 6 | answerdate | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 7 | opendate | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 8 | clickdate | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 9 | overall_satisfaction | character varying | SIM | PESQUISA | NAO_TEMPORAL |
| 10 | ease_of_request | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 11 | clear_assertives_information | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 12 | satisfaction_over_channel | character varying | SIM | PESQUISA | NAO_TEMPORAL |
| 13 | experience_what_can_improve | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 14 | funnel_type | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 15 | company | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 16 | quantity | integer | SIM | OUTRO | NAO_TEMPORAL |
| 17 | period | integer | SIM | COMPETENCIA_REFERENCIA | COBERTURA_HISTORICA |
bi_brsp_con.agg_mot_06_response
Tags semânticas: FATURAMENTO, CONTATO, PESQUISA, TEMPORAL, COMPETENCIA
Temporal: True · Colunas temporais: date_delivery | sentdate | answerdate | opendate | clickdate | period · Status histórico: EXIGE_MIN_MAX_NOS_DADOS
Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA
Campos (19)
| # | Campo | Tipo | Nulo | Conceito sugerido | Uso temporal |
|---|---|---|---|---|---|
| 1 | type_event | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 2 | date_delivery | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 3 | sentdate | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 4 | answerdate | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 5 | opendate | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 6 | clickdate | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 7 | overall_satisfaction | character varying | SIM | PESQUISA | NAO_TEMPORAL |
| 8 | ease_of_access | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 9 | clear_complete_information | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 10 | value_correct_with_consumption | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 11 | offered_receive_invoice_by_email | character varying | SIM | FATURAMENTO | NAO_TEMPORAL |
| 12 | interested_receiving_invoice_by_email | character varying | SIM | FATURAMENTO | NAO_TEMPORAL |
| 13 | invoice_delivered_within_expected_time | character varying | SIM | FATURAMENTO | NAO_TEMPORAL |
| 14 | funnel_type | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 15 | company | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 16 | quantity | integer | SIM | OUTRO | NAO_TEMPORAL |
| 17 | period | integer | SIM | COMPETENCIA_REFERENCIA | COBERTURA_HISTORICA |
| 18 | had_face_to_face_contact_enel_professional | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 19 | satisfied_enel_professional | character varying | SIM | PESQUISA | NAO_TEMPORAL |
bi_brsp_con.agg_mot_07_response
Tags semânticas: PESQUISA, TEMPORAL, COMPETENCIA
Temporal: True · Colunas temporais: date_open | sent_date | answer_date | period · Status histórico: EXIGE_MIN_MAX_NOS_DADOS
Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA
Campos (22)
| # | Campo | Tipo | Nulo | Conceito sugerido | Uso temporal |
|---|---|---|---|---|---|
| 1 | date_open | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 2 | channel | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 3 | reason | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 4 | subject | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 5 | sent_date | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 6 | answer_date | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 7 | overall_satisfaction | character varying | SIM | PESQUISA | NAO_TEMPORAL |
| 8 | which_channel_prefer | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 9 | which_channel_prefer_1 | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 10 | which_channel_prefer_2 | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 11 | which_channel_prefer_3 | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 12 | which_channel_prefer_4 | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 13 | which_channel_prefer_5 | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 14 | which_channel_prefer_6 | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 15 | which_channel_prefer_7 | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 16 | which_channel_prefer_8 | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 17 | easy_to_access_channel | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 18 | found_wanted_on_channel | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 19 | funnel_type | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 20 | company | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 21 | quantity | integer | SIM | OUTRO | NAO_TEMPORAL |
| 22 | period | integer | SIM | COMPETENCIA_REFERENCIA | COBERTURA_HISTORICA |
bi_brsp_con.agg_mot_08_response
Tags semânticas: RECLAMACAO, PESQUISA, TEMPORAL, COMPETENCIA
Temporal: True · Colunas temporais: date_close | date_admission | sentdate | answerdate | opendate | clickdate | period · Status histórico: EXIGE_MIN_MAX_NOS_DADOS
Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA
Campos (19)
| # | Campo | Tipo | Nulo | Conceito sugerido | Uso temporal |
|---|---|---|---|---|---|
| 1 | direction | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 2 | department | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 3 | subject | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 4 | origination | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 5 | date_close | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 6 | date_admission | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 7 | sentdate | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 8 | answerdate | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 9 | opendate | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 10 | clickdate | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 11 | overall_satisfaction | character varying | SIM | PESQUISA | NAO_TEMPORAL |
| 12 | received_written_answer | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 13 | answer_was_clear | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 14 | complaint_has_been_properly_analyzed | character varying | SIM | RECLAMACAO | NAO_TEMPORAL |
| 15 | response_deadline_met | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 16 | funnel_type | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 17 | company | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 18 | quantity | integer | SIM | OUTRO | NAO_TEMPORAL |
| 19 | period | integer | SIM | COMPETENCIA_REFERENCIA | COBERTURA_HISTORICA |
bi_brsp_con.agg_mot_09_response
Tags semânticas: CONTRATO, PESQUISA, TEMPORAL, COMPETENCIA
Temporal: True · Colunas temporais: ebill_start_date | contract_start_date | sentdate | answerdate | period · Status histórico: EXIGE_MIN_MAX_NOS_DADOS
Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA
Campos (12)
| # | Campo | Tipo | Nulo | Conceito sugerido | Uso temporal |
|---|---|---|---|---|---|
| 1 | ebill_start_date | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 2 | contract_start_date | timestamp without time zone | SIM | CONTRATO | EVENTO_OU_VIGENCIA |
| 3 | sentdate | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 4 | answerdate | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 5 | overall_satisfaction | character varying | SIM | PESQUISA | NAO_TEMPORAL |
| 6 | ease_of_register | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 7 | information_was_clear | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 8 | influence_to_optate | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 9 | funnel_type | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 10 | company | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 11 | quantity | integer | SIM | OUTRO | NAO_TEMPORAL |
| 12 | period | integer | SIM | COMPETENCIA_REFERENCIA | COBERTURA_HISTORICA |
bi_brsp_con.bt_mot_01_response
Tags semânticas: INSTALACAO, ORDENS, CONTATO, PESQUISA, TEMPORAL, COMPETENCIA
Temporal: True · Colunas temporais: date_open | date_send | date_send_mkt | date_response | period · Status histórico: EXIGE_MIN_MAX_NOS_DADOS
Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA
Campos (23)
| # | Campo | Tipo | Nulo | Conceito sugerido | Uso temporal |
|---|---|---|---|---|---|
| 1 | installation | bigint | SIM | INSTALACAO | NAO_TEMPORAL |
| 2 | email | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 3 | date_open | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 4 | channel | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 5 | reason | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 6 | sub_reason | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 7 | attendant | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 8 | unit_store | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 9 | date_send | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 10 | date_send_mkt | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 11 | date_response | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 12 | overall_satisfaction | character varying | SIM | PESQUISA | NAO_TEMPORAL |
| 13 | service_satisfaction | character varying | SIM | ORDENS | NAO_TEMPORAL |
| 14 | ease_of_request | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 15 | what_can_improve | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 16 | clear_statements | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 17 | cortez_attendant | character varying | SIM | ORDENS | NAO_TEMPORAL |
| 18 | satisfactory_solution | character varying | SIM | PESQUISA | NAO_TEMPORAL |
| 19 | improve_the_experience | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 20 | thanks_page | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 21 | company | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 22 | file | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 23 | period | integer | SIM | COMPETENCIA_REFERENCIA | COBERTURA_HISTORICA |
bi_brsp_con.bt_mot_02_response
Tags semânticas: INSTALACAO, CLIENTE, ORDENS, CONTATO, PESQUISA, TEMPORAL, COMPETENCIA
Temporal: True · Colunas temporais: sentdate | answerdate | date_request | date_conclusion | period · Status histórico: EXIGE_MIN_MAX_NOS_DADOS
Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA
Campos (24)
| # | Campo | Tipo | Nulo | Conceito sugerido | Uso temporal |
|---|---|---|---|---|---|
| 1 | installation | bigint | SIM | INSTALACAO | NAO_TEMPORAL |
| 2 | email | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 3 | service | character varying | SIM | ORDENS | NAO_TEMPORAL |
| 4 | electrician | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 5 | sentdate | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 6 | answerdate | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 7 | overall_satisfaction | character varying | SIM | PESQUISA | NAO_TEMPORAL |
| 8 | ease_of_request | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 9 | ease_what_can_improve | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 10 | deadline_completed | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 11 | information_was_satisfactory | character varying | SIM | PESQUISA | NAO_TEMPORAL |
| 12 | had_to_contact | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 13 | experience_what_can_be_improved | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 14 | would_like_receive_communication | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 15 | thanks_page | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 16 | date_request | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 17 | date_conclusion | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 18 | company | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 19 | company_id | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 20 | customer_key | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 21 | city | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 22 | install_2 | bigint | SIM | OUTRO | NAO_TEMPORAL |
| 23 | file | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 24 | period | integer | SIM | COMPETENCIA_REFERENCIA | COBERTURA_HISTORICA |
bi_brsp_con.bt_mot_02_send_sp
Tags semânticas: INSTALACAO, CLIENTE, ORDENS, CONTATO, PESQUISA, TEMPORAL, COMPETENCIA
Temporal: True · Colunas temporais: sentdate | answerdate | date_request | date_conclusion | period | dte_update · Status histórico: EXIGE_MIN_MAX_NOS_DADOS
Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA
Campos (25)
| # | Campo | Tipo | Nulo | Conceito sugerido | Uso temporal |
|---|---|---|---|---|---|
| 1 | installation | character varying | SIM | INSTALACAO | NAO_TEMPORAL |
| 2 | email | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 3 | service | character varying | SIM | ORDENS | NAO_TEMPORAL |
| 4 | electrician | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 5 | sentdate | character varying | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 6 | answerdate | character varying | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 7 | thanks_page | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 8 | date_request | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 9 | date_conclusion | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 10 | company | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 11 | company_id | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 12 | customer_key | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 13 | city | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 14 | install_2 | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 15 | file | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 16 | period | character varying | SIM | COMPETENCIA_REFERENCIA | COBERTURA_HISTORICA |
| 17 | overall_satisfaction | character varying | SIM | PESQUISA | NAO_TEMPORAL |
| 18 | ease_of_request | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 19 | ease_what_can_improve | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 20 | deadline_completed | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 21 | information_was_satisfactory | character varying | SIM | PESQUISA | NAO_TEMPORAL |
| 22 | had_to_contact | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 23 | experience_what_can_be_improved | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 24 | would_like_receive_communication | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 25 | dte_update | character varying | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
bi_brsp_con.bt_mot_04_response
Tags semânticas: CLIENTE, CONTATO, PESQUISA, TEMPORAL, COMPETENCIA
Temporal: True · Colunas temporais: date_open | date_close | answerdate | period | sentdate · Status histórico: EXIGE_MIN_MAX_NOS_DADOS
Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA
Campos (31)
| # | Campo | Tipo | Nulo | Conceito sugerido | Uso temporal |
|---|---|---|---|---|---|
| 1 | install | bigint | SIM | OUTRO | NAO_TEMPORAL |
| 2 | type_of_research | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 3 | segment | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 4 | email | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 5 | status_supply | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 6 | status | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 7 | channel | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 8 | attendant | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 9 | reason | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 10 | city | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 11 | date_open | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 12 | date_close | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 13 | customer_key | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 14 | company_id | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 15 | city_sf | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 16 | sentdate | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 17 | answerdate | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 18 | overall_satisfaction | character varying | SIM | PESQUISA | NAO_TEMPORAL |
| 19 | deadline_completed | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 20 | ease_of_request | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 21 | difficulty_reporting_power_outages | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 22 | had_to_contact | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 23 | programmed_what_can_improve | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 24 | power_outage_what_can_improve | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 25 | which_channel_warned | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 26 | received_any_communication | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 27 | thanks_page | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 28 | install_2 | bigint | SIM | OUTRO | NAO_TEMPORAL |
| 29 | file | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 30 | company | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 31 | period | integer | SIM | COMPETENCIA_REFERENCIA | COBERTURA_HISTORICA |
bi_brsp_con.bt_mot_05_response
Tags semânticas: INSTALACAO, CLIENTE, ORDENS, CONTATO, PESQUISA, TEMPORAL, COMPETENCIA
Temporal: True · Colunas temporais: date_open | answerdate | opendate | clickdate | date_input | period | sentdate · Status histórico: EXIGE_MIN_MAX_NOS_DADOS
Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA
Campos (24)
| # | Campo | Tipo | Nulo | Conceito sugerido | Uso temporal |
|---|---|---|---|---|---|
| 1 | date_open | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 2 | channel | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 3 | service | character varying | SIM | ORDENS | NAO_TEMPORAL |
| 4 | attendant | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 5 | installation | bigint | SIM | INSTALACAO | NAO_TEMPORAL |
| 6 | email | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 7 | customer_key | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 8 | company_id | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 9 | city_sf | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 10 | sentdate | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 11 | answerdate | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 12 | opendate | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 13 | clickdate | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 14 | overall_satisfaction | character varying | SIM | PESQUISA | NAO_TEMPORAL |
| 15 | ease_of_request | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 16 | clear_assertives_information | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 17 | satisfaction_over_channel | character varying | SIM | PESQUISA | NAO_TEMPORAL |
| 18 | experience_what_can_improve | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 19 | thanks_page | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 20 | installation_2 | character varying | SIM | INSTALACAO | NAO_TEMPORAL |
| 21 | date_input | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 22 | file | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 23 | company | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 24 | period | integer | SIM | COMPETENCIA_REFERENCIA | COBERTURA_HISTORICA |
bi_brsp_con.bt_mot_07_response
Tags semânticas: INSTALACAO, CLIENTE, CONTATO, PESQUISA, TEMPORAL, COMPETENCIA
Temporal: True · Colunas temporais: date_open | answer_date | date_input | period | sent_date · Status histórico: EXIGE_MIN_MAX_NOS_DADOS
Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA
Campos (30)
| # | Campo | Tipo | Nulo | Conceito sugerido | Uso temporal |
|---|---|---|---|---|---|
| 1 | date_open | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 2 | channel | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 3 | reason | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 4 | subject | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 5 | installation | character varying | SIM | INSTALACAO | NAO_TEMPORAL |
| 6 | email | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 7 | customer_key | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 8 | company_id | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 9 | city_sf | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 10 | sent_date | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 11 | answer_date | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 12 | overall_satisfaction | character varying | SIM | PESQUISA | NAO_TEMPORAL |
| 13 | which_channel_prefer | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 14 | which_channel_prefer_1 | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 15 | which_channel_prefer_2 | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 16 | which_channel_prefer_3 | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 17 | which_channel_prefer_4 | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 18 | which_channel_prefer_5 | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 19 | which_channel_prefer_6 | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 20 | which_channel_prefer_7 | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 21 | which_channel_prefer_8 | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 22 | easy_to_access_channel | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 23 | found_wanted_on_channel | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 24 | what_can_improve | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 25 | thanks_page | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 26 | install_2 | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 27 | date_input | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 28 | file | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 29 | company | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 30 | period | integer | SIM | COMPETENCIA_REFERENCIA | COBERTURA_HISTORICA |