Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
EncounterFinding
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'. |
| EncounterSID | INTEGER | ? | MANDATORY | FK - From Encounter |
| 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 | FK - From PatientClinicalSummary |
| 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. | |
| VoidedTMSCatalogSID | INTEGER | ? | OPTIONAL | FK from TMSCatalog. Reference to the voided TMS Catalog record. This field will be null (?) for the current note. |
| CreateDateTimeUTC | DATETIME-TZ | OPTIONAL | This is a denormalized field based off the CreateStamp. This field contains the Date, Time and timezone offset. | |
| OnsetDateTimeUTC | DATETIME-TZ | OPTIONAL | This is a denormalized field based off the Onset. This field contains the Date, Time and timezone offset. If the OnsetTime is null then the OnsetTime will be set to midnight. | |
| TimeStampUTC | DATETIME-TZ | OPTIONAL | This is a denormalized field based off the TimeStamp. This field contains the Date, Time and timezone offset. |
| Parent Table | Join Phrase | When deleting parent record... |
|---|---|---|
| TMSCatalog | EncounterFinding.VoidedTMSCatalogSID = TMSCatalog.CatalogSID | RESTRICT if EncounterFinding exists |
| PatientClinicalSummary | EncounterFinding.ClinicalSummarySID = PatientClinicalSummary.ClinicalSummarySID | SET NULL if EncounterFinding exists |
| EncounterFinding | EncounterFinding.LinkFindingSID = EncounterFinding.EncounterFindingSID | NONE if EncounterFinding exists |
| Encounter | EncounterFinding.EncounterSID = Encounter.EncounterSID | CASCADE if EncounterFinding exists |
| Child Table | Join Phrase | When deleting EncounterFinding record... |
|---|---|---|
| EncounterFindingHistory | EncounterFindingHistory.EncounterFindingSID = EncounterFinding.EncounterFindingSID | CASCADE if EncounterFindingHistory exists |
| PatientClinicalSummary | PatientClinicalSummary.FirstFindingSID = EncounterFinding.EncounterFindingSID | RESTRICT if PatientClinicalSummary exists |
| PatientClinicalSummary | PatientClinicalSummary.CurrentFindingSID = EncounterFinding.EncounterFindingSID | RESTRICT if PatientClinicalSummary exists |
| EncounterFinding | EncounterFinding.LinkFindingSID = EncounterFinding.EncounterFindingSID | NONE if EncounterFinding exists |