Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
ImportEncFinding
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| ImportEncFindingSID | INTEGER | ? | MANDATORY | System-assigned unique identifier of an encounter finding. Generated by the EncFinding sequence. |
| ImportEncFindingSetSID | INTEGER | ? | MANDATORY | FK - From ImportEncFindingSet |
| ImportFindingStatus | CHAR(8) | OPTIONAL | Defines the Status of a Encounter Finding to be imported. Defined by the Lookup Code ImpFindingStatus | |
| 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. |
| Prefix | CHAR(2) | OPTIONAL | Code representing the Medcin prefix applied to the finding. Allowed values must be defined in the MedcinPrefix lookup type. | |
| FindingType | CHAR(8) | OPTIONAL | System defined. Classification of finding type. For future use. 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. | |
| TranscribedText | CHAR(28000) | OPTIONAL | The text returned by Medcin's transcribe function. The transcribe function returns the phrase or sentence description for a finding - For future use. | |
| Memo | CHAR(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 | CHAR(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 | CHAR(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. | |
| 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. | |
| Unit | CHAR(16) | OPTIONAL | ||
| FindingValue | CHAR(20) | OPTIONAL | ||
| 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. | |
| RecordStatus | CHARACTER(1) | Record_Status_Active | MANDATORY | Codes for lookup type 'RecordStatus' are not user definable. Valid codes are (A)ctive and (I)nactive. |
| UpdatedUser | INTEGER | 0 | OPTIONAL | User set. User ID of the user who last updated the Import Encounter Finding. |
| UpdatedStamp | CHARACTER(14) | OPTIONAL | User Set. Timestamp when the Import Encounter Finding was last updated. | |
| 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 | FK - from ClinicalNarrativeSection - For future use. |
| Parent Table | Join Phrase | When deleting parent record... |
|---|---|---|
| ImportEncFindingSet | ImportEncFinding.ImportEncFindingSetSID = ImportEncFindingSet.ImportEncFindingSetSID | CASCADE if ImportEncFinding exists |
| Child Table | Join Phrase | When deleting ImportEncFinding record... |
|---|