Last Updated: 9/24/2025 12:09:38 PM
Intergy Version: 22.00.00.00
ClinicalLookupCode
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| ClinicalLookupType | CHARACTER(20) | MANDATORY | FK - From ClinicalLookupType | |
| ClinicalLookupCode | CHARACTER(15) | MANDATORY | Clinical Lookup code as specified | |
| Order | INTEGER | 0 | MANDATORY | This number determines the order in which the codes are displayed in the search dialog. These numbers are set when the user orders the list. |
| Description | CHARACTER(60) | MANDATORY | Description of the code. User entered. | |
| RecordStatus | CHARACTER(1) | MANDATORY | Record status is (A)ctive or (I)nactive and may only be set for lookup codes that are for user definable lookup types. Inactive codes ill not show up in lookup code searches. RecordStatus is defined in the LookupCode table for the lookup type 'RecordStatus'. Codes for lookup type 'RecordStatus' are not user definable. | |
| 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. |
| ResultFlag | CHAR(1) | Set_To_Empty_String | OPTIONAL | This field is used to define medically normal status (result) of current Clincal lookup code. Allowed values must be defined in the MedcinFindingResult lookup type. |
| LOINCCode | CHAR(30) | OPTIONAL | This field is used to tie the Clinical lookup code to a LOINC code. | |
| DefaultValue | DECIMAL(10,4) | ? | OPTIONAL | This field is used to define the default value of the Clinical lookup code. |
| Parent Table | Join Phrase | When deleting parent record... |
|---|
| Child Table | Join Phrase | When deleting ClinicalLookupCode record... |
|---|---|---|
| EncounterFinding | EncounterFinding.ClinicalLookupType = ClinicalLookupCode.ClinicalLookupType and EncounterFinding.ClinicalLookupCode = ClinicalLookupCode.ClinicalLookupCode |
RESTRICT if EncounterFinding exists |
| EncounterFindingHistory | EncounterFindingHistory.ClinicalLookupType = ClinicalLookupCode.ClinicalLookupType and EncounterFindingHistory.ClinicalLookupCode = ClinicalLookupCode.ClinicalLookupCode |
RESTRICT if EncounterFindingHistory exists |