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 |