Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
CardioOrder
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| CardioOrderSID | INTEGER | ? | MANDATORY | System-defined. System generated unique id using the "CardioOrder" sequence. |
| PracticeID | INTEGER | ? | MANDATORY | FK - From Practice, Patient, Staff |
| PatientID | INTEGER | ? | OPTIONAL | FK - From Patient |
| StaffID | INTEGER | ? | OPTIONAL | FK - From Staff |
| RefDoctorID | INTEGER | ? | OPTIONAL | FK - From RefDoctor |
| EncounterSID | INTEGER | ? | OPTIONAL | FK - From Encounter |
| PatientOrderSetSID | INTEGER | ? | OPTIONAL | FK - From PatientOrderSet |
| CardioTestType | CHAR(15) | MANDATORY | Cardio Device Test Type - Lookup Code (HeartCentrixTestType) | |
| CardioOrderStatus | CHAR(1) | OPTIONAL | Status of the Cardio Device order. Possible values: (O)rdered, (T)ransmitted, re(S)ulted, (V)oid, (R)eviewed | |
| ExternalOrderID | CHAR(31) | OPTIONAL | Unique ID of Order/Request in Cardio Device | |
| ExternalTestID | CHAR(31) | OPTIONAL | Unique ID of Test Result in Cardio Device | |
| SourcePatLastName | CHAR(20) | OPTIONAL | Patient's last name as reported by the Cardio Device | |
| SourcePatFirstName | CHAR(15) | OPTIONAL | Patient's first name as reported by the Cardio Device | |
| SourcePatSex | CHARACTER(6) | OPTIONAL | Patient's gender code as reported by the Cardio Device (typically 'M', 'F', or 'U') | |
| SourcePatNumber | CHAR(20) | OPTIONAL | Patient's Medical Record Number as reported by the Cardio Device | |
| SourcePatDOB | DATE | OPTIONAL | Patient's Date of Birth as reported by the Cardio Device | |
| TimeStamp | CHARACTER(14) | OPTIONAL | System generated date/time stamp record was last written. | |
| LastUser | INTEGER | ? | OPTIONAL | User ID of user that last wrote the record. |
| CreateStamp | CHARACTER(14) | OPTIONAL | System generated date/time stamp record was created. | |
| CreateUser | INTEGER | ? | OPTIONAL | User ID of user that created the record. |
| SourcePatRace | CHAR(2) | OPTIONAL | Patient's Race as reported by the Cardio Device | |
| SourcePatDrName | CHAR(60) | OPTIONAL | Patient's Provider as reported by the Cardio Device | |
| PerformedStamp | CHARACTER(14) | OPTIONAL | Date/time stamp the test was Performed as returned by the Cardio device. If this date is not returned from the Cardio device it will be set to the date time it was received. | |
| Interpretation | CHAR(28000) | OPTIONAL | Interpretation as returned by the cardio device. | |
| SourceConsultDrID | CHAR(15) | OPTIONAL | Consulting physician ID as used in Cardio Device. | |
| SourceConsultDrName | CHARACTER(30) | OPTIONAL | Consulting physician name as used in the Cardio Device. | |
| SourcePatDrID | CHAR(15) | OPTIONAL | The ID of Patient's provider as reported by the Cardio Device. | |
| DNMatched | LOGICAL | OPTIONAL | Specifies if the CardioOrder as been matched to a patient and a provider. (maintained by db trigger). |
| Parent Table | Join Phrase | When deleting parent record... |
|---|---|---|
| Practice | CardioOrder.PracticeID = Practice.PracticeID | RESTRICT if CardioOrder exists |
| PatientOrderSet | CardioOrder.PatientOrderSetSID = PatientOrderSet.PatientOrderSetSID | SET NULL if CardioOrder exists |
| Encounter | CardioOrder.EncounterSID = Encounter.EncounterSID | SET NULL if CardioOrder exists |
| RefDoctor | CardioOrder.RefDoctorID = RefDoctor.RefDoctorID | SET NULL if CardioOrder exists |
| Staff | CardioOrder.PracticeID = Staff.PracticeID and CardioOrder.StaffID = Staff.StaffID |
RESTRICT if CardioOrder exists |
| Patient | CardioOrder.PracticeID = Patient.PracticeID and CardioOrder.PatientID = Patient.PatientID |
RESTRICT if CardioOrder exists |
| Child Table | Join Phrase | When deleting CardioOrder record... |
|---|---|---|
| CardioOrderComponent | CardioOrderComponent.CardioOrderSID = CardioOrder.CardioOrderSID | CASCADE if CardioOrderComponent exists |
| PatientOrderSetResult | PatientOrderSetResult.CardioOrderSID = CardioOrder.CardioOrderSID | RESTRICT if PatientOrderSetResult exists |
| CardioOrderActivity | CardioOrderActivity.CardioOrderSID = CardioOrder.CardioOrderSID | CASCADE if CardioOrderActivity exists |