Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
CLWCorrespondence
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| CLWCorrespondenceSID | INTEGER | ? | MANDATORY | System-generated unique identifier of CLW Correspondence. Generated using the CLWCorrespondence sequence |
| CLWTemplateSID | INTEGER | ? | MANDATORY | FK to CLWTemplate. This is the template that was, or will be used to generate the Correspondence document. |
| PracticeID | INTEGER | ? | MANDATORY | FK |
| StaffID | INTEGER | ? | MANDATORY | FK |
| PatientID | INTEGER | ? | MANDATORY | FK |
| EncounterSID | INTEGER | ? | OPTIONAL | FK to Encounter |
| RefDoctorID | INTEGER | ? | OPTIONAL | FK to RefDoctor This is the 'to provider' for the correspondence. |
| PlanID | INTEGER | ? | OPTIONAL | FK from Plan |
| CompanyID | INTEGER | ? | OPTIONAL | FK to Company |
| SendVia | CHAR(8) | MANDATORY | 'Send To' setting for the recipient. Allowed values must be defined in CLWViaType lookup type. Initial lookup codes will include Print, Fax | |
| SendStatus | CHAR(1) | MANDATORY | System defined. Send status for the correspondence document. Field is supported by the lookup types:[CLWSendStatus]. Values are defined in the LookupCode table for the above lookup types. | |
| CatalogSID | INTEGER | ? | MANDATORY | FK to TMSCatalog |
| 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. |
| DocumentEdited | CHARACTER(1) | OPTIONAL | Allowed values are Y(es) and N(o). The field will be used to keep track of whether the user edited the correspondence document after the data merge. | |
| PatientOrderSetSID | INTEGER | ? | OPTIONAL | FK - PatientOrderSet |
| ServiceCenterID | INTEGER | ? | OPTIONAL | FK to ServiceCenter |
| SendTo | CHARACTER(1) | MANDATORY | The type of recipient of the correspondence. Valid values will be: (I)nsurance, (P)atient, (E)mployer, (R)eferring Provider, and (F)acility. | |
| FHIRType | CHAR(8) | OPTIONAL | FHIR Type of correspondence document.(Lookup type - FHIRType) |
| Parent Table | Join Phrase | When deleting parent record... |
|---|---|---|
| ServiceCenter | CLWCorrespondence.ServiceCenterID = ServiceCenter.ServiceCenterID | RESTRICT if CLWCorrespondence exists |
| PatientOrderSet | CLWCorrespondence.PatientOrderSetSID = PatientOrderSet.PatientOrderSetSID | SET NULL if CLWCorrespondence exists |
| Company | CLWCorrespondence.CompanyID = Company.CompanyID | SET NULL if CLWCorrespondence exists |
| TMSCatalog | CLWCorrespondence.CatalogSID = TMSCatalog.CatalogSID | CASCADE if CLWCorrespondence exists |
| Plan | CLWCorrespondence.PlanID = Plan.PlanID | SET NULL if CLWCorrespondence exists |
| RefDoctor | CLWCorrespondence.RefDoctorID = RefDoctor.RefDoctorID | RESTRICT if CLWCorrespondence exists |
| Encounter | CLWCorrespondence.EncounterSID = Encounter.EncounterSID | SET NULL if CLWCorrespondence exists |
| Patient | CLWCorrespondence.PracticeID = Patient.PracticeID and CLWCorrespondence.PatientID = Patient.PatientID |
RESTRICT if CLWCorrespondence exists |
| Staff | CLWCorrespondence.PracticeID = Staff.PracticeID and CLWCorrespondence.StaffID = Staff.StaffID |
RESTRICT if CLWCorrespondence exists |
| Child Table | Join Phrase | When deleting CLWCorrespondence record... |
|---|