Reports table
A Report is a set of fields that have been configured for the user to be shown somewhere.
Different Medallia clients have different fields in their data set, and also different users within the same organization may have access to different information, and thus the system is customized to deliver the right fields for each report kind.
Table description
DESCRIBE TABLE reports key | name | encoding |
name | Name | TEXT |
kind | Kind | TEXT |
fields | Fields | TEXT |Sample query
SELECT name, kind, fields FROM reports WHERE kind = 'STANDARD_REPORT'Result
name | kind | fields |
Overall | STANDARD_REPORT | br_overal_interaction,br_overall_experience,br_likely_to_recommend,br_likely_to_buy_next_prod |
Account set-up & offerings | STANDARD_REPORT | br_account_setup_overall,br_account_setup_ease,br_account_setup_info,br_investment_variety,br_new_product_info |
Full-service fees & performance | STANDARD_REPORT | br_fee_performance,br_fee_fair,br_fee_mgm_reasonable,br_fee_acc_reasonable,br_investment_performance |
Account statements | STANDARD_REPORT | br_acc_statement,br_acc_statement_acc,br_acc_statement_clarity,br_acc_statement_time,br_acc_statement_useful |
Full service customer service | STANDARD_REPORT | br_customer_serv_overall,br_conven_service_hours,br_ease_reach_rep,br_knowl_serv_rep,br_timely_resolution |
Financial Advisor/Broker | STANDARD_REPORT | br_financial_advisor,br_contact_financial_adv,br_time_financial_adv,br_knowl_financial_adv,br_object_advisor,br_effectitive_strategy |
Mainstreet Financial Image | STANDARD_REPORT | br_is_easy_business,br_makes_feel_valued,br_is_convenient,br_is_innovative,br_is_stable,br_is_quick,br_uses_technology,br_is_friendly,br_assumes_resp,br_gives_back_to_commun,br_is_well_mged,br_is_a_good_bank,br_cares_about_empl,br_is_corp_leader,br_provides_consist_service,br_works_with_bus,br_offers_customized_serv,br_wants_all_bus,br_rewards_loyalty,br_is_flexible,br_is_an_inst_advice,br_has_range_obr_prods,br_is_international_focus |