ADHOC_REPORT_DB_VIEW

Product

Civic Platform

Type

System Switch

Description

Use this Standard Choice to control which DB views (data sources) are available in the Report Manager Ad hoc Report Data Sources list for agencies to use in assigning permissions to data sources for Ad hoc Reporting. All agencies have the same DB views in common. This Standard Choice provides each agency with the ability to define available DB views for ad hoc reporting. After the view appears on the Ad Hoc Report Data Sources list, agencies can set permissions to define who can access the data for ad hoc reporting.

If you do not set up this Standard Choice, Civic Platform uses default DB Views.

Standard Choice values can include one or more names DB View from the Accela-hosted database. A list of the DB_Views available for this Standard Choice is available below:

V_ADDRESS

V_AGENCY_INFO

V_APO_ADDRESS_ATTR

V_APO_ADDRESS_DATA

V_APO_OWNER_ATTR

V_APO_OWNER_DATA

V_APO_PARCEL_ATTR

V_APO_PARCEL_DATA

V_ASI_ATTR

V_ASI_DATA

V_ASSET

V_ASSET_TEMPLATE_ATTR

V_ASSET_TEMPLATE_DATA

V_ASSET_USAGE

V_CASHIER_SESSION

V_CFG_WORKFLOW

V_COMMENT_RECORD

V_CONDITION_RECORD

V_CONDITION_RECORD_TPL_ATTR

V_CONDITION_RECORD_TPL_DATA

V_CONFIG_0_DOCTEXT

V_CONFIG_0_DOCUMENT

V_CONFIG_APPSTATUS

V_CONFIG_APPTYPE

V_CONFIG_CHECKLIST

V_CONFIG_CUSTOM_FIELDS

V_CONFIG_CUSTOM_LIST

V_CONFIG_DOCUMENTS

V_CONFIG_EXPIRATION

V_CONFIG_FEES

V_CONFIG_INSP

V_CONFIG_SHARED_DROPDOWN

V_CONFIG_SMARTCHOICE

V_CONFIG_TASK_SPECIFIC

V_CONFIG_WORKFLOW

V_CONTACT

V_CONTACT_ADDRESS

V_EXAM

V_FEE

V_FEE_PAYMENT_HISTORY

V_GUIDESHEET

V_GUIDESHEET_TEMPLATE_ATTR

V_GUIDESHEET_TEMPLATE_DATA

V_HEARING

V_INSPECTION

V_INSPECTION_1ST_LAST

V_LP_TEMPLATE_ATTR

V_LP_TEMPLATE_DATA

V_OWNER

V_PARCEL

V_PARCEL_CONDITION

V_PAYMENT

V_PEOPLE_TEMPLATE_ATTR

V_PEOPLE_TEMPLATE_DATA

V_PROFESSIONAL

V_RECORD

V_RECORD_DATES_STAFF

V_RECORD_LICENSE

V_REF_CONTACT

V_REF_LP_TEMPLATE_ATTR

V_REF_LP_TEMPLATE_DATA

V_REF_PARCEL

V_REF_PARCEL_TEMPLATE_ATTR

V_REF_PARCEL_TEMPLATE_DATA

V_REF_PEOPLE_TEMPLATE_ATTR

V_REF_PEOPLE_TEMPLATE_DATA

V_REF_PROFESSIONAL

V_RELATED_RECORD

V_SET

V_STANDARD_CHOICE

V_STANDARD_CONDITION

V_STATUS_HISTORY

V_STD_CONDITION_TPL_ATTR

V_STD_CONDITION_TPL_DATA

V_TIME_ACCOUNTING

V_TRUST_ACCT

V_TRUST_ACCT_ASSOCIATED

V_TRUST_ACCT_TRANSACTION

V_TSI_ATTR

V_TSI_DATA

V_USER

V_USER_GROUP_FID

V_USER_N_GROUP

V_WORKFLOW

V_WORKFLOW_HISTORY

V_WORKORDER_ASSET