Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
EncounterFindingHistory
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| EncounterFindingSID | INTEGER | ? | MANDATORY | Flag which designates whether the finding should be included in the Orders window. Allowed values are 'Y' and 'N'. |
| HistoryCount | INTEGER | 0 | MANDATORY | This is a programmatically generated sequence that keeps tracks of the number of updates made to an encounter finding. |
| EncounterSID | INTEGER | ? | MANDATORY | System generated unique id using Encounter sequence. |
| OrdersRelated | CHARACTER(1) | No_Value__N_ | MANDATORY | Flag which designates whether the finding should be included in the Orders window. Allowed values must be defined in the EncounterFindingOrdersRelated lookup type. Default value is 'N'. |
| FindingType | CHARACTER(8) | MANDATORY | System defined. Classification of finding type. Allowed values must be defined in this lookup. Field is supported by the lookup types:[CiteType]. Values are defined in the LookupCode table for the above lookup types. | |
| ExternalUnique | CHARACTER(200) | OPTIONAL | Unique identifier of finding source. In the case of cited findings, this would be the unique identifier of the origin of the citing (e.g. PersonAllergy - PersonID | AllergyCode). | |
| MedcinID | INTEGER | ? | MANDATORY | Medcin ID that uniquely identifies the finding. Note - may be derived by MedicinFinding table but does not have to exist in that table. |
| Memo | CHARACTER(28000) | OPTIONAL | Free text associated with the finding. | |
| ROSFlag | CHARACTER(1) | OPTIONAL | Flag indicating whether a symptom finding was entered as Review of Systems. | |
| Duration | CHARACTER(20) | OPTIONAL | Code representing the duration of the condition represented by the finding. | |
| Episode | CHARACTER(30) | OPTIONAL | Code representing the frequency or interval of the condition represented by the finding. | |
| Modifier | CHARACTER(2) | OPTIONAL | System defined. Code representing the Medcin modifier applied to the finding. Allowed values must be defined in this lookup. Field is supported by the lookup types:[MedcinModifier]. Values are defined in the LookupCode table for the above lookup types. | |
| OnSet | CHARACTER(14) | OPTIONAL | A "fuzzy" timestamp representing the onset of the condition represented by the finding. "Fuzzy" means the timestamp precision is variable. The onset may be of the form yyyy or yyyyMM or yyyyMMdd, etc. | |
| Prefix | CHARACTER(2) | OPTIONAL | System defined. Code representing the Medcin prefix applied to the finding. Allowed values must be defined in this lookup. Field is supported by the lookup types:[MedcinPrefix]. Values are defined in the LookupCode table for the above lookup types. | |
| LinkQualifier | CHARACTER(2) | OPTIONAL | Code representing the link type used when linking two findings. | |
| NormalRangeHigh | DECIMAL(10,2) | OPTIONAL | The high end of the normal range of values for the finding. The normal range accounts for the age and gender of the patient. | |
| NormalRangeLow | DECIMAL(10,2) | OPTIONAL | The low end of the normal range of values for the finding. The normal range accounts for the age and gender of the patient. | |
| ResultFlag | CHARACTER(1) | OPTIONAL | System defined. Code representing the medical result of the finding. Allowed values must be defined in this lookup. Field is supported by the lookup types:[MedcinResult]. Values are defined in the LookupCode table for the above lookup types. | |
| EncounterFindingStatus | CHARACTER(1) | OPTIONAL | System defined. Code representing the status applied to the finding. Allowed values must be defined in this lookup. Field is supported by the lookup types:[MedcinStatus]. Values are defined in the LookupCode table for the above lookup types. | |
| Unit | CHARACTER(16) | OPTIONAL | ||
| FindingValue | CHARACTER(20) | OPTIONAL | The value applied to the finding. | |
| LinkFindingSID | INTEGER | ? | OPTIONAL | System-assigned unique identifier of an encounter finding. Generated by the EncounterFinding sequence. |
| ClinicalSummarySID | INTEGER | ? | OPTIONAL | System-generated unique identifier of the patient clinical summary. Generated using the ClinicalSummary sequence. |
| RecordStatus | CHARACTER(1) | Record_Status_Active | MANDATORY | Codes for lookup type 'RecordStatus' are not user definable. Valid codes are (A)ctive and (I)nactive. |
| FindingSource | CHAR(500) | OPTIONAL | ||
| 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. |
| ClinicalNarrativeSectionSID | INTEGER | ? | OPTIONAL | System-generated unique identifier of narrative section. Generated by the ClinicalNarrative sequence. |
| DefaultMemo | CHARACTER(28000) | OPTIONAL | The default free text associated with this finding. This is used by Encounter Note to keep track of the original value of the free text as defined within the Encounter Note Form. | |
| TranscribedText | CHAR(28000) | OPTIONAL | The text returned by Medcin's transcribe function. The transcribe function returns the phrase or sentence description for a finding. | |
| MedcinProcedureCode | CHARACTER(6) | OPTIONAL | Medcin supplied Procedure Code. Note: May not exist in Intergy Procedure Code. | |
| MedcinDiagnosisCode | CHAR(8) | OPTIONAL | Medcin supplied Diagnosis Code. Note: May not exist in Intergy Diagnosis Code. | |
| ProcedureModifier | CHAR(2) | OPTIONAL | The procedure modifier associated with this finding. | |
| UpdatedUser | INTEGER | ? | OPTIONAL | User set. User ID of the user who last updated the Encounter Finding. |
| UpdatedStamp | CHARACTER(14) | OPTIONAL | User Set. Timestamp when the Encounter Finding was last updated. | |
| ClinicalLookupType | CHARACTER(20) | OPTIONAL | FK - From ClinicalLookupCode | |
| ClinicalLookupCode | CHARACTER(15) | OPTIONAL | FK - From ClinicalLookupCode | |
| OverrideDescription | CHAR(300) | Set_To_Empty_String | OPTIONAL | Users' override value of the description of a Finding. |
| ActiveAssessment | LOGICAL | Logical_False | MANDATORY | Applies only to findings in the Assessment narrative section, or the user-modified equivalent. A true value indicates that the assessment is active at the time of the visit. This impacts the calculation of the E&M code. |
| ChronicAssessment | LOGICAL | Logical_False | MANDATORY | Applies only to findings in the Assessment narrative section, or the user-modified equivalent. A true value indicates that the assessment is a chronic problem (e.g. diabetes). This impacts the calculation of the the E&M code. |
| AdditionalWorkupAssessment | LOGICAL | Logical_False | MANDATORY | Applies only to findings in the Assessment narrative section, or the user-modified equivalent. A true value indicates that additional workup is planned. This impacts the calculation of E&M code. |
| NewProblemAssessment | LOGICAL | Logical_False | MANDATORY | Applies only to findings in the Assessment narrative section, or the user-modified equivalent. A true value indicates that the problem is new to the provider of record on the encounter. This impacts the calculation of the E&M code. |
| MedcinDiagnosisCodeICD10 | CHAR(10) | Set_To_Empty_String | OPTIONAL | Medcin supplied ICD10 Diagnosis Code. Note: May not exist in Intergy Diagnosis Code. |
| ReplacementPhrase | CHAR(60) | Set_To_Empty_String | OPTIONAL | The replacement text for an encounter finding. |
| LOINCCode | CHAR(30) | OPTIONAL | LOINC Code. | |
| SNOMEDCode | CHAR(30) | OPTIONAL | SNOMED Code. |
| Parent Table | Join Phrase | When deleting parent record... |
|---|---|---|
| PatientClinicalSummary | EncounterFindingHistory.ClinicalSummarySID = PatientClinicalSummary.ClinicalSummarySID | SET NULL if EncounterFindingHistory exists |
| Encounter | EncounterFindingHistory.EncounterSID = Encounter.EncounterSID | CASCADE if EncounterFindingHistory exists |
| EncounterFinding | EncounterFindingHistory.EncounterFindingSID = EncounterFinding.EncounterFindingSID | CASCADE if EncounterFindingHistory exists |
| EncounterFindingHistory | EncounterFindingHistory.LinkFindingSID = EncounterFindingHistory.EncounterFindingSID and EncounterFindingHistory.HistoryCount = EncounterFindingHistory.HistoryCount |
NONE if EncounterFindingHistory exists |
| Child Table | Join Phrase | When deleting EncounterFindingHistory record... |
|---|---|---|
| EncounterFindingHistory | EncounterFindingHistory.LinkFindingSID = EncounterFindingHistory.EncounterFindingSID and EncounterFindingHistory.HistoryCount = EncounterFindingHistory.HistoryCount |
NONE if EncounterFindingHistory exists |