ROIPRICPOLICYXFACILITY - Database Reporting Guide - English - Foundation 22.1 - OnBase - external - OnBase/Database-Reporting-Guide/English/Foundation-22.1/Database-Reporting-Guide/Database-Tables/ROIPRICPOLICYXFACILITY - 2023-02-01

Database Reporting Guide

Platform
OnBase
Product
Database Reporting Guide
Release
Foundation 22.1
License
ft:locale
en-US

The ROIPRICPOLICYXFACILITY table stores the pricing policies available to each facility.

ROIPRICPOLICYXFACILITY
Column Name Data Type Data Length Description
facilitynum bigint 8 Foreign key to MEDFACILITY.
pricingpolicynum bigint 8 Foreign key to ROIPRICINGPOLICY.
flags bigint 8 Miscellaneous bit flags.

The indexes for ROIPRICPOLICYXFACILITY table are located in DBSpace8.

ROIPRICPOLICYXFACILITY Table Indexes
Index Name Indexed Columns
roipricpolicyxfacility1 facilitynum