Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
PatientPrescriptionHistoryOID | int | NOT NULL | Primary key. PatientPrescriptionHistory Object ID |
PatientOID | int | NOT NULL | References to HPatient table Object ID column |
PatientVisitOID | int | NOT NULL | References to HPatientVisit table Object ID column |
XMLDocStorageOID | int | NOT NULL | foreign key for XMLDocStorage table XMLDocStorageOid column |
FormularyStatus | varchar(40) | NULL | Prescription Plan Formulary Status. Allowable values: OnFormulary, Preferred,NonFormulary,Not Reimbursable,Unknown. |
PreferenceLevel | varchar(2) | NULL | Prescription Plan coverage level. Allowable values: from 0 to 99 or U(Unknown). |
PrescriptionMethod | varchar(20) | NOT NULL | Prescription Method like ePrescribe or print or fax. Allowable values ePrescribe, Print or Fax. |
PatientEligibilityInfoOID | int | NULL | References to PatientEligibilityInfo table Object ID column |
PatientPharmacyOID | int | NULL | References to PatientPharmacy table Object ID column |
PrescriptionStatus | smallint | NOT NULL | Status of prescription sent to HDX(Healthcare Data Exchange) , SureScripts and Pharmacy. |
HDXTransactionID | int | NULL | HDX(Healthcare Data Exchange) assigned transaction ID used to check Prescription status |
HDXToSoarianTransactionId | varchar(20) | NULL | Request id from Soarian to HDX(Healthcare Data Exchange) |
FailureCode | varchar(20) | NULL | Failure code from HDX(Healthcare Data Exchange) and Surescript for failed transaction |
NCPDPData | varchar(max) | NULL | Prescription transaction formatted data sent to HDX(Healthcare Data Exchange) |
UserOID | int | NOT NULL | References to HSUser table Object ID column |
UserName | varchar(12) | NOT NULL | User Name |
StaffOID | int | NOT NULL | References to HStaff table Object ID column |
StaffName | varchar(187) | NOT NULL | HStaff Name |
Coverage_QDT | smallint | NULL | Prescription Coverage Quantity Limits(Allowable values 0 and 1. 1:Segment Present and 0:Absent) |
Coverage_RRT | smallint | NULL | Prescription Coverage Resource Link Drug Specific(Allowable values 0 and 1. 1:Segment Present and 0:Absent) |
Coverage_RDT | smallint | NULL | Prescription Coverage Resource Link Summary(Allowable values 0 and 1. 1:Segment Present and 0:Absent) |
Coverage_MDT | smallint | NULL | Prescription Coverage Step Medications(Allowable values 0 and 1. 1:Segment Present and 0:Absent) |
Coverage_GDT | smallint | NULL | Prescription Coverage Gender Limits(Allowable values 0 and 1. 1:Segment Present and 0:Absent) |
Coverage_TDT | smallint | NULL | Prescription Coverage Coverage Messages(Allowable values 0 and 1. 1:Segment Present and 0:Absent) |
Coverage_GDA | smallint | NULL | Prescription Coverage Age limits(Allowable values 0 and 1. 1:Segment Present and 0:Absent) |
Coverage_DDT | smallint | NULL | Prescription Coverage StepMeds, Exclusions and Medical Necessity header(Allowable values 0 and 1. 1:Segment Present and 0:Absent) |
DAW | smallint | NOT NULL | Dispense as written(Allowable values 0 and 1. 1:Yes and 0:No) |
CreateDTime | datetime | NOT NULL | Created Date Time(wall clock) |
LastResponseStatusCheckDateTime | datetime | NULL | Date/time when the last status check call to HDX was made for this ePrescription. Null on initial population of row. |
ElapsedTimeOfCallToHDX | int | NULL | Elapsed time it took for the call to the send Rx or the check status service; whichever was called. |
LastCngDTime | datetime | NOT NULL | Last change Date Time(UTC) |
MessageID | varchar(35) | NULL | Message ID used in NCPDP(National Council for Prescription Drug Programs) ePrescription message |
PrescriberOrderNumber | varchar(35) | NULL | prescriber order number of ePrescription |
PrescriptionSignatureOID | bigint | NULL | reference oid for NCPDP response message's signature signed by private key |
PharmacyRole | varchar(6) | NULL | Type of Pharmacy(Allowable value: MAIL, RETAIL) |
Quantity | varchar(300) | NULL | Prescription quantity |
Refills | varchar(300) | NULL | Refills quantity |
DispensingUnitFmtCode | varchar(10) | NULL | NCPDP(National Council for Prescription Drug Programs) FMT(Federal Medication Terminologies) code, for NCPDP transaction |
DispensingUnitFmtDesc | varchar(50) | NULL | NCPDP(National Council for Prescription Drug Programs) FMT(Federal Medication Terminologies) code description |
MrcMedicationOid | bigint | NULL | Foreign key to MrcMedication table |
EarliestFillDate | smalldatetime | NULL | Earliest Fill Date for prescription |
IsPrescriberOrderNumberActive | tinyint | NULL | Status of prescriber order number(0 inactive; 1 active) |
PONDeactivatedSystemDateTime | datetime | NULL | Wall clock date time when prescriber order number was deactivated |
PONDeactivatedNcpdpOutboundMessageOid | bigint | NULL | NcpdpOutboundMessageOid of the outbound message that deactivated the PON(Prescriber Order Number). |
| | | Null if the ePrescription was simply removed with no cancel message. |
PONDeactivatedUserOid | int | NULL | User OID of user who deactivated the PON(Prescriber Order Number) |
TransmittedDataFormat | varchar(3) | NULL | NCPDP data format('xml', 'edi' [edifact]) |
TransmittedViaApiVersion | varchar(10) | NULL | which HDX(Healthcare Data Exchange) API was used to transmit the NEWRX('MU2' = sendPrescriptionService, 'MU3' - outboundMessage for edifact prescriptions, 'HDX2017' - outboundMessage for XML prescriptions) |
DaysSupply | smallint | NULL | Days Supply for a medication(e.g. '1') |