ROIREQUESTLOC - Database Reporting Guide - Foundation 23.1 - Foundation 23.1 - Ready - OnBase - external

Database Reporting Guide

Platform
OnBase
Product
Database Reporting Guide
Release
Foundation 23.1
License

The ROIREQUESTLOC table contains Requestor information.

ROIREQUESTLOC Table Values
Column Name Data Type Data Lenght Description
roilocationnum bigint 8 Unique location number.
roilocationname char 60 Name of location.
requestorname char 60 Requestor’s name.
requestorrelation char 30 Requestor’s relation to the patient.
requestoremail char 80 Requestor’s e-mail address.
billtoaddress1 char 80 First line of billing address.
billtoaddress2 char 80 Second line of billing address.
billtoaddress3 char 255 Third line of billing address (e.g. City, State or Country ZIP Code).
shiptoaddress1 char 80 First line of shipping address.
shiptoaddress2 char 80 Second line of shipping address.
shiptoaddress3 char 255 Third line of shipping address (e.g. City, State or Country ZIP Code).
flags bigint 8

Flags field. Current values are:

0x0001 – Is Require Pre Payment

0x0000 – Is Pre Payment is not required

roicompanyname char 60 Company name for individual locations such as an Insurance Company with multiple locations in different cities/states.
phonenumber char 32 Phone number for location.
faxnum char 30 Fax number for location.
status bigint 8 Identifies whether requester location is (0) active or (1) inactive (Enumeration).

The indexes for ROIREQUESTLOC table are located in DBSpace1.

ROIREQUESTLOC Table Indexes
Index Name Indexed Columns
roirequestloc1 roilocationnum