| rrtcres_id | int(11) | NO | | PRI | auto_increment | |
| rrtcres_cus_id | int(11) | NO | 0 | MUL | | Customer ID # |
| rrtcres_cli_id | int(11) | NO | 0 | MUL | | Client ID # |
| rrtcres_pat_id | int(11) | NO | 0 | | | Patient ID # |
| rrtcres_rad_res_id | int(11) | NO | 0 | MUL | | Radiology Result ID # |
| rrtcres_rrtcm_id | int(11) | NO | 0 | MUL | | Radiology Result Test Code Map ID # |
| rrtcres_lips_id | int(11) | YES | | | | Lab Interfaces Performing Sites ID# |
| rrtcres_seq_num | tinyint(4) | NO | 0 | | | Sequence Number from HL7. Used to keep the results in a specific order. |
| rrtcres_seq_num2 | tinyint(4) | NO | | | | |
| rrtcres_data_value_type | varchar(2) | NO | | | | HL7 Data Type for result segment |
| rrtcres_observ_cs_id | int(11) | NO | 0 | | | Code System ID # |
| rrtcres_observ_code_id | bigint(20) | NO | 0 | | | Result ID Code from Vendor |
| rrtcres_observ_code | varchar(20) | NO | | MUL | | Result Code from Vendor |
| rrtcres_observ_name | varchar(40) | NO | | | | Result Name from Vendor |
| rrtcres_observ_result | varchar(80) | NO | | | | Result Value from vendor |
| rrtcres_observ_unit_id | int(11) | NO | | | | Unit ID #, not guaranteed to be set |
| rrtcres_observ_unit | varchar(40) | NO | | | | Unit as free text |
| rrtcres_observ_range | varchar(60) | NO | | | | Results Range Value# |
| rrtcres_flags | varchar(5) | NO | | | | Warning flags |
| rrtcres_status | char(1) | NO | | | | The Status of the hl7 result - typically F is final. Dependent on vendor. |
| rrtcres_charge_code | varchar(10) | NO | | | | |
| rrtcres_education_provided | char(1) | NO | | | | Track if patient education was given for result value |
| rrtcres_org_id | int(11) | NO | | | | |
| rrtcres_type_code_id | char(11) | NO | | | | |
| rrtcres_modified | timestamp | YES | CURRENT_TIMESTAMP | | on update CURRENT_TIMESTAMP | |
| rrtcres_created | timestamp | YES | CURRENT_TIMESTAMP | | | |