Additional Tables

This table includes information about aPriori Reporting Database tables that you may find useful even though they are not included in the aPriori Ad Hoc Data Domain.

Table Name	Comments
auth_group	Access control groups
auth_group_attribute	Group attributes created through the admin UI
auth_user	Table that is synced with all users from the operational database
auth_user_to_auth_group	Tracks the groups that a user is part of
child_to_parent	BOM structure
configuration_property	Reporting DB currency code
costed_by_user_base	Original costed by user table
created_by_user_base	Original created by user table
export_event_to_scenario_facts	Links export events to scenario facts
export_history	History of exported events with stats and the login id of the user who ran the export
fx_rate	Table that is synced with foreign exchange rates from the operational database
last_saved_by_user_base	Original last saved by user table
operation_custom_output	Merged into operation facts
operation_facts_base	Original operation facts table
operation_facts_base_ext	Operation facts table (used for custom outputs)
operation_override	Stores override values for operations
operation_setup_option	Stores setup option values for operations
process_custom_output	Merged into process facts
process_facts_base	Original process facts table
process_facts_base_ext	Process facts table (used for custom outputs)
process_override	Stores override values for operations
process_setup_option	Stores setup option values for processes
scenario_facts_base	Original scenario facts table
scenario_facts_base_ext	Temporary file for creating the UDA extensions
scenario_override	Store override values for scenarios
scenario_thumbnail	Images not supported in Ad Hoc Views
user_defined_attribute	Merged into Scenario facts