The ROIREQUESTLOC table contains Requestor information.
| 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.
| Index Name | Indexed Columns |
|---|---|
| roirequestloc1 | roilocationnum |