Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
TMSCatalog
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| CatalogSID | INTEGER | ? | MANDATORY | System generated document identifier. The identifier value is obtained from the DOCUMENT sequence. |
| PracticeID | INTEGER | ? | MANDATORY | FK |
| ManagerUserID | INTEGER | ? | MANDATORY | FK |
| PerformingProviderID | INTEGER | ? | OPTIONAL | FK |
| SupervisingProviderID | INTEGER | ? | OPTIONAL | FK |
| PatientID | INTEGER | ? | MANDATORY | FK |
| EncounterSID | INTEGER | ? | OPTIONAL | FK |
| CatalogStatus | CHARACTER(10) | MANDATORY | System defined. Current state of cataloged document. Field is supported by the lookup types:[TMSCompletedStatus]. Values are defined in the LookupCode table for the above lookup types. | |
| CatalogType | CHARACTER(10) | MANDATORY | Type of cataloged document. "TRANS" -transcription , "OMDOC" - Omnidoc , "ENCNOTE" - Note , "MARKER" - Dictation Marker , "CORSPND" - Correspondence , "OBFORM" - OB Form and "RESULT" - Result | |
| Description | CHARACTER(60) | MANDATORY | Name assigned to the document. | |
| ViewAccessLevel | INTEGER | 0 | MANDATORY | Access level to view a catalog entry. |
| EditAccessLevel | INTEGER | 0 | MANDATORY | Access level to Edit a catalog entry. |
| ReferenceDate | DATE | MANDATORY | Reference date for the document. | |
| DeleteAccessLevel | INTEGER | 0 | MANDATORY | Access level to delete a catalog entry. |
| Priority | INTEGER | 0 | MANDATORY | Priority of the document request. |
| Archived | CHARACTER(1) | MANDATORY | Indicates if the transcription record is to be Archived on Approval Possible values: (Y)es, (N)o | |
| 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. |
| FileName | CHARACTER(30) | MANDATORY | Document file name. | |
| Directory | CHARACTER(10) | OPTIONAL | Directory name where file name is stored. Supported by lookup type TMSDirectory. | |
| SentToUser | INTEGER | ? | OPTIONAL | FK |
| StatusDate | DATE | OPTIONAL | Date the catalog status changed. | |
| ArchiveDirectory | CHARACTER(10) | OPTIONAL | Archive directory for document. Supported by lookup type TMSArchiveDirectory. | |
| NumPages | INTEGER | 0 | OPTIONAL | System determined number of pages in word document. |
| NumParagraphs | INTEGER | 0 | OPTIONAL | System determined number of paragraphs in word document. |
| NumLines | INTEGER | 0 | OPTIONAL | System determined number of lines in word document. |
| NumWords | INTEGER | 0 | OPTIONAL | System determined number of words in word document. |
| NumCharacters | INTEGER | 0 | OPTIONAL | System determined number of non-space characters in word document. |
| NumCharactersSpaces | INTEGER | 0 | OPTIONAL | System determined number of characters (including spaces) in word document. |
| TotalEditingTime | INTEGER | 0 | OPTIONAL | System determined time in minutes that user has been editing document (as determined by MS Word). |
| OrigTransDate | DATE | OPTIONAL | Date Transcription was originally written. This field is never modified once set. | |
| OrigTranscriptionist | INTEGER | ? | OPTIONAL | FK from MMUser - Original user who transcribed document. This field is never modified once set. |
| PrimaryRISStudySID | INTEGER | ? | OPTIONAL | FK - Indicates RIS Study that derived transcription. |
| ApproveProcessed | CHARACTER(1) | No_Value__N_ | OPTIONAL | System entered. Indicates whether the system has processed the approval. Y = System has processed post approval logic N = System has not processed post approval logic Note - Post approval logic is documented by the following flags: AppendApproveLineProcessed HL7QueueProcessed DDSQueueProcessed All flags must be Y for this flag to be Y. This field is for index purposes. |
| ApproveProcessFailedStamp | CHARACTER(14) | OPTIONAL | Indicates the last time that the DDS attempted to process the approval process but failed | |
| AppendApproveLineProcessed | CHARACTER(1) | No_Value__N_ | OPTIONAL | System entered. Indicates whether the append approve logic successfully completed. Y = Append approve logic was successful. N = Append approve logic was not run or was not successful. Note that Y value indicates that logic was processed and not that the document has the append approve line. |
| HL7QueueProcessed | CHARACTER(1) | No_Value__N_ | OPTIONAL | System entered. Indicates whether the HL7 Outbound report logic successfully completed. Y = logic was successful. N = logic was not run or was not successful. Note that Y value indicates that logic was processed and not that the document has been submitted to HL7. |
| DDSQueueProcessed | CHARACTER(1) | No_Value__N_ | OPTIONAL | System entered. Indicates whether the Document delivery processing logic successfully completed. Y = logic was successful. N = logic was not run or was not successful. Note that Y value indicates that logic was processed and not that the document has been submitted to DDS. |
| DeliveryPriority | INTEGER | Number_Two | OPTIONAL | HL7 Document Delivery Proirity - 1 is HIGH priority, 2 is NORMAL priority, 3 is LOW priority |
| HL7RemoteRecipientList | CHARACTER(20) | OPTIONAL | Comma separated list of HL7 Remote codes to override normal HL7 delivery preferences when utilizing demand HL7 Outbound Report Utility | |
| HL7RemoteRecipientMethod | CHARACTER(1) | OPTIONAL | Codified values are: (F)ilter, and (O)verride See design 1803. | |
| DDSProcessorInstanceSID | INTEGER | ? | OPTIONAL | FK - From DDSProcessorInstance |
| DNPatLastName | CHAR(35) | OPTIONAL | Denormalized for performance reasons from the Person table. Do not write to this field. The person write triggers will keep field up-to-date. | |
| DNPatFirstName | CHAR(35) | OPTIONAL | Denormalized for performance reasons from the Person table. Do not write to this field. The person write triggers will keep field up-to-date. | |
| DNPatMiddleName | CHAR(35) | OPTIONAL | Denormalized for performance reasons from the Person table. Do not write to this field. The person write triggers will keep field up-to-date. | |
| DNStaffCode | CHARACTER(6) | OPTIONAL | Denormalized for performance reasons from the Staff table. Do not write to this field. The Staff write triggers will keep field up-to-date. | |
| DictationExists | LOGICAL | OPTIONAL | YES/NO - Indicates that a TMSCatalogDictationBlob Records exists. | |
| DNManagerLogon | CHAR(16) | OPTIONAL | Denormalized for performance reasons from the MMUser table. Do not write to this field. The MMUser write triggers will keep field up-to-date.. | |
| FHIRType | CHAR(8) | OPTIONAL | Type of FHIR document. Lookup type - FHIRType | |
| IsDiagnosticReport | LOGICAL | OPTIONAL | Denotes if this record represents a record that is considered a Diagnostic Report | |
| DiagnosticReportType | CHAR(10) | OPTIONAL | Denotes what type of a Diagnostic Report this record represents. Possible values come from lookuptype FHIRDiagnosticReportCategory | |
| NarrativeTextExtentCount | INTEGER | ? | OPTIONAL | Total Number of Extents in the TMSNarrativeText record set |
| Parent Table | Join Phrase | When deleting parent record... |
|---|---|---|
| RISStudy | TMSCatalog.PrimaryRISStudySID = RISStudy.RISStudySID | SET NULL if TMSCatalog exists |
| MMUser | TMSCatalog.OrigTranscriptionist = MMUser.MMUserSID | SET NULL if TMSCatalog exists |
| Patient | TMSCatalog.PracticeID = Patient.PracticeID and TMSCatalog.PatientID = Patient.PatientID |
RESTRICT if TMSCatalog exists |
| Encounter | TMSCatalog.EncounterSID = Encounter.EncounterSID | NONE if TMSCatalog exists |
| Staff | TMSCatalog.PracticeID = Staff.PracticeID and TMSCatalog.PerformingProviderID = Staff.StaffID |
NONE if TMSCatalog exists |
| Staff | TMSCatalog.PracticeID = Staff.PracticeID and TMSCatalog.SupervisingProviderID = Staff.StaffID |
RESTRICT if TMSCatalog exists |
| Child Table | Join Phrase | When deleting TMSCatalog record... |
|---|---|---|
| EncounterFinding | EncounterFinding.VoidedTMSCatalogSID = TMSCatalog.CatalogSID | RESTRICT if EncounterFinding exists |
| PatientOrderSetResult | PatientOrderSetResult.CatalogSID = TMSCatalog.CatalogSID | RESTRICT if PatientOrderSetResult exists |
| OBPregnancy | OBPregnancy.TMSCatalogSID = TMSCatalog.CatalogSID | SET NULL if OBPregnancy exists |
| CLWCorrespondence | CLWCorrespondence.CatalogSID = TMSCatalog.CatalogSID | CASCADE if CLWCorrespondence exists |
| Encounter | Encounter.EncounterNoteCatalogSID = TMSCatalog.CatalogSID | SET NULL if Encounter exists |
| TMSCatalogBlob | TMSCatalogBlob.CatalogSID = TMSCatalog.CatalogSID | CASCADE if TMSCatalogBlob exists |
| TMSActivity | TMSActivity.CatalogSID = TMSCatalog.CatalogSID | CASCADE if TMSActivity exists |