Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
CardioComponent
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| CardioComponentSID | INTEGER | ? | MANDATORY | System-defined. System generated unique id using the "CardioOrder" sequence. |
| CardioTestType | CHAR(15) | MANDATORY | System defined. Field is supported by the lookup types:[HeartCentrixTestType]. Values are defined in the LookupCode table for the above lookup types. | |
| ComponentCode | CHAR(40) | OPTIONAL | System set component code as specified by HeartCentrix documentation. | |
| Description | CHARACTER(60) | OPTIONAL | System set component description | |
| RecordStatus | CHARACTER(1) | MANDATORY | User selected record status for the service center. RecordStatus is defined in the LookupCode table for the lookup type 'RecordStatus'. Codes for lookup type 'RecordStatus' are not user definable. Valid codes are (A)ctive and (I)nactive. | |
| 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. |
| Parent Table | Join Phrase | When deleting parent record... |
|---|
| Child Table | Join Phrase | When deleting CardioComponent record... |
|---|---|---|
| CardioOrderComponent | CardioOrderComponent.CardioComponentSID = CardioComponent.CardioComponentSID | RESTRICT if CardioOrderComponent exists |