| prx_id | int(11) | NO | | PRI | auto_increment | |
| prx_cus_id | int(11) | NO | | MUL | | |
| prx_cli_id | int(11) | NO | | | | |
| prx_pat_id | int(11) | NO | | | | |
| prx_enc_id | int(11) | NO | | MUL | | |
| prx_voided | char(1) | NO | 0 | | | |
| prx_denied | char(1) | NO | 0 | | | |
| prx_deleted | char(1) | NO | 0 | | | |
| prx_rcopia_id | varchar(24) | NO | | | | |
| prx_provider | varchar(64) | NO | | | | |
| prx_provider_npi | varchar(15) | NO | | | | |
| prx_preparer | varchar(64) | NO | | | | |
| prx_drg_id | int(11) | NO | | | | |
| prx_cs_id | int(11) | YES | | | | Code System ID# |
| prx_code | varchar(45) | NO | | | | Code |
| prx_desc | varchar(516) | NO | | | | Prescription Description |
| prx_code_id | int(11) | YES | | | | Code ID# |
| prx_action | varchar(32) | NO | | | | |
| prx_dose | varchar(32) | NO | | | | |
| prx_dose_unit | varchar(32) | NO | | | | |
| prx_route | varchar(32) | NO | | | | |
| prx_dose_timing | varchar(100) | NO | | | | |
| prx_dose_other | varchar(100) | NO | | | | |
| prx_duration | varchar(16) | NO | | | | |
| prx_quantity | varchar(16) | NO | | | | |
| prx_quantity_units | varchar(32) | NO | | | | |
| prx_refills | tinyint(4) | NO | | | | |
| prx_notes | text | NO | | | | |
| prx_substitution_permitted | char(1) | NO | 0 | | | |
| prx_pharmacy_npi | varchar(15) | NO | | | | |
| prx_pharmacy_ncpdpid | varchar(15) | NO | | | | |
| prx_phy_dea | varchar(20) | NO | | | | |
| prx_order_number | varchar(40) | NO | | | | |
| prx_dx1_cs_id | int(11) | NO | 0 | | | |
| prx_dx1_code | varchar(20) | NO | | | | |
| prx_dx1_desc | varchar(256) | NO | | | | |
| prx_dx2_cs_id | int(11) | NO | 0 | | | |
| prx_dx2_code | varchar(20) | NO | | | | |
| prx_dx2_desc | varchar(256) | NO | | | | |
| prx_created_date | varchar(8) | NO | | | | |
| prx_created_dt | datetime | YES | | | | datetime prescription was created |
| prx_completed_date | varchar(8) | NO | | | | |
| prx_completed_dt | datetime | YES | | | | datetime prescription was completed (if ordered) |
| prx_signed_date | varchar(8) | NO | | | | |
| prx_signed_dt | datetime | YES | | | | datetime prescription was signed by provider |
| prx_stop_date | varchar(8) | NO | | | | |
| prx_stop_dt | datetime | YES | | | | datetime medication stops |
| prx_send_method | varchar(11) | NO | | | | |
| prx_not_done_cs_id | int(11) | YES | | | | code system id for not done reason |
| prx_not_done_code | varchar(45) | NO | | | | code for not done reason |
| prx_not_done_desc | varchar(256) | NO | | | | description for not done reason |
| prx_modified | timestamp | YES | CURRENT_TIMESTAMP | | on update CURRENT_TIMESTAMP | |
| prx_created | timestamp | YES | CURRENT_TIMESTAMP | | | |
| prx_reconciled | char(1) | NO | | | | |