The ROIREQUESTITEMS table stores all documents and external items added to a given request.
Column Name | Data Type | Data Length | Description |
---|---|---|---|
roirequestnum | bigint | 8 | Request the item belongs to. |
Itemnum | bigint | 8 | References an OnBase document ID or an External Item ID. |
docrevnmum | bigint | 8 | Document revision to release. |
filetypenum | bigint | 8 | Document rendition to release. |
clerkusernum | bigint | 8 | User adding an item to request. |
dateadded | datetime | 8 | Date/time when the item was added to the request. |
flags | bigint | 8 |
Bit field for item settings. Current values are: flag_bill = 0x0001 // Signifies this item is the request's bill flag_remit = 0x0002 // Signifies this item is the request's remittance flag_patient = 0x0004 // Signifies this item is a patient-level document (MRMS only) flag_rejection_letter = 0x0008 // Signifies this item is the rejection letter for the request |
Chtnum | bigint | 8 | Chart the document belongs to. |
printitemnum | bigint | 8 | Copied document to release. |
printitemname | char | 255 | Item name used for release. |
roiquantity | bigint | 8 | Quantity of an external item in the request. |
seqnum | bigint | 8 | Determines the printing order of documents within a request. |
manuallyentered | bigint | 8 |
Stores information if the document overrides any request type settings. Current values are: 0 – document added automatically with the rest of the chart 1 – document added manually which overrides request type setting |
pagecount | bigint | 8 | Number of pages being released. |
excludedpages | text | 16 |
Page range of pages to exclude in the ROI packet. NOTE: The default value of this field can remain null for existing records |
mpinum | bigint | 8 | Foreign key to MSTRPTINDEX table. |
mrnum | bigint | 8 | Foreign key to MEDREC table. |
The indexes for ROIREQUESTITEMS table are located in DBSpace1.
Index Name | Indexed Columns |
---|---|
roirequestitems1 | roirequestnum |