common.billing_reports

Field Type Null Default Key Extra Comment
br_id int(11) NO PRI auto_increment
br_cus_id int(11) NO 0 MUL
br_cli_id int(11) NO 0
br_name text NO
br_key varchar(100) NO
br_pdf_limit int(11) YES 10000
br_desc text NO
br_perm varchar(256) NO
br_cat varchar(120) NO
br_type varchar(120) NO
br_repcon_id int(11) YES
br_complexity_factor int(11) YES 1
br_has_related_pay_adj_support char(1) NO Indicates report supports including all payments and adjustments that apply to any charges included in the report
br_has_closed_period_fil char(1) NO Indicates report supports Closed Period parameter
br_has_revc_fil char(1) NO Indicates report supports Revenue Center filter
br_has_date_type_fil char(1) NO Indicates report supports Date Type parameter
br_has_ic_fil char(1) NO Indicates report supports filtering by location
br_has_spl_fil char(1) NO Indicates report supports filtering by location
br_has_loc_fil char(1) NO Indicates report supports filtering by location
br_has_rsc_fil char(1) NO Indicates report supports filtering by resource
br_has_sfs_fil char(1) NO Indicates report supports filtering by sliding fee scale
br_has_ec_fil char(1) NO Indicates report supports filtering by encounter classes
br_has_cset_fil char(1) NO Indicates report supports Coding Set filter
br_has_grouping char(1) NO Indicates report supports grouping by BR concepts
br_has_usr_fil char(1) NO Indicates report supports filtering by user
br_has_subtotal char(1) NO Indicates report supports subtotal option
br_has_bp_fil char(1) NO Has Billing Provider Filter
br_is_myrna_report tinyint(1) YES 0 Used to indicate if report should show in Myrna.
br_disabled tinyint(1) NO 0 Report should not be user accessible
br_modified timestamp YES CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
br_created timestamp YES CURRENT_TIMESTAMP

References

Local Column References
br_id
TableColumn
_1.configured_reportsconfrp_br_id
_1.reports_queuerq_br_id
_1188.configured_reportsconfrp_br_id
_1188.reports_queuerq_br_id
_1218.configured_reportsconfrp_br_id
_1218.reports_queuerq_br_id
_1548.configured_reportsconfrp_br_id
_1548.reports_queuerq_br_id
_435.configured_reportsconfrp_br_id
_435.reports_queuerq_br_id
_436.configured_reportsconfrp_br_id
_436.reports_queuerq_br_id
_436_archive_testing.configured_reportsconfrp_br_id
_436_archive_testing.reports_queuerq_br_id
_437.configured_reportsconfrp_br_id
_437.reports_queuerq_br_id
_8.configured_reportsconfrp_br_id
_8.reports_queuerq_br_id
_81.configured_reportsconfrp_br_id
_81.reports_queuerq_br_id
_999.configured_reportsconfrp_br_id
_999.reports_queuerq_br_id
common.billing_reports_filters_mapbrfm_br_id
common.configured_myrna_reportsconfmrp_br_id
common.reports_queue_ordersrqo_br_id
br_key
TableColumn
_1.reports_queuerq_br_key
_1188.reports_queuerq_br_key
_1218.reports_queuerq_br_key
_1548.reports_queuerq_br_key
_435.reports_queuerq_br_key
_436.reports_queuerq_br_key
_436_archive_testing.reports_queuerq_br_key
_437.reports_queuerq_br_key
_8.reports_queuerq_br_key
_81.reports_queuerq_br_key
_999.reports_queuerq_br_key
common.billing_reports_grouping_conceptsbrgc_br_key
common.reports_queue_ordersrqo_br_key