Tables Tables
NameDescription
CDS.AppliedRecommendationDispositionAudit of the disposition returned for a recommendation
CDS.DispositionReasonAvailable types of reasons when supressing/ignoring a recommendation
CDS.DispositionSourcevarious available source of appliedrecommendationSource
CDS.DispositionTypevarious types of allowed dispositions
CDS.PatientDataused in track last submit date time for a patient
CDS.Recommendationtable of active recommendations
CDS.RecommendationAssertiontable of assertions associated to recommendation
CDS.RecommendationAssertionHistorytable of assertions associated to recommendation history
CDS.RecommendationDispositionApplicationlog of recommendations that had a dispositionapplied to the provider
CDS.RecommendationHistoryrecommendations that are no longer active
CDS.RecommendationPartyParties associated with the recommendation that detail the sponsor, author and source of the recommendation.  Source is used to track where the logic for the rule was derived
CDS.RecommendationPartyHistoryParties associated with the recommendation history that detail the sponsor, author and source of the recommendation.  Source is used to track where the logic for the rule was derived
CDS.RecommendationReferenceReferences associated with the recommendation where additional information can be found on the recommendation
CDS.RecommendationReferenceHistoryReferences associated with the recommendationHistory where additional information can be found on the recommendation
CDS.RecommendationSourceindentifies the rule(s) and participant(s) that triggered the recommendation
CDS.RecommendationSourceHistoryindentifies the rule(s) and participant(s) that triggered the recommendation.  Child of recommendations in the history table
CDS.RecommendationTypeDispositiontracks dispositions associated to an assertion
CDS.Rolerole types for recommendationReferences
CDS.RuleDispositiontracks dispositions that are associated to a rule
CDS.Severityavailable severity codes for recommendations
CDS.Statusvarious available statuses of recommendations
dbo.ABN_Intermediate_Status_DEMedical Necessity Edits
dbo.Access_GroupThis is a list of all the security classifications in the application. A security application is just a name that you associate multiple security codes with. For example a classification called "Nurse" may have security coes for "Chart-Edit", "Chart-View", "Chart-Print" and "Can Prescribe". Users are allowed to create there own security classifications.
dbo.Act_AllergyAllergy Activity
dbo.Act_AnnotationActivity level annotation
dbo.Act_GoalActivity level table for patient Goals. Derived from the Act_HDr_Goal table for every activity of the Goal
dbo.Act_Hdr_AllergyAllergy Activity Header
dbo.Act_Hdr_GoalActivity Header Level table for Goals
dbo.Act_Hdr_HMPActivity header table for order reminders
dbo.Act_Hdr_MedAdminActivity header table for medication administration. Replaced by Order_Activity_Header
dbo.Act_Hdr_OtherActivity Header table for Findings and Immunizations.
dbo.Act_Hdr_ResultActivity header table for Results
dbo.Act_Hdr_VitalsActivity header table for Vitals. Replaced by Act_Hdr_Other.
dbo.Act_HMPActivity table for Order Reminders
dbo.Act_MedAdminActivity table for medication Administration. Replaced by Order_Activity
dbo.Act_NoteActivity table for note. Used for Audit Notes.
dbo.Act_OtherActivity table for Findings and Immunizations.
dbo.Act_ResultActivity Level table for Results
dbo.Act_Result_ExtensionAdditional activity level versioned properties for Results
dbo.Act_VitalsActivity table for vitals. Replaced by Act_Other
dbo.Activity_Type_DEActivity Types
dbo.Additional_InformationAdditional Information Questions instance data
dbo.Additional_Information_DEAdditional Information Questions Dictionary
dbo.Admin_Disposition_DEDictionary holding the codes / descriptions used to describe the Disposition Administration i.e (Administered, Pending, No Show etc.)
dbo.Agency_DEAgency related names as Entryname and its corresponding Entrycode. Users allowed to Add/Update agency details
dbo.Alert_Type_DEAlert Type dictionary
dbo.Allergen_DENon-Medication allergens
dbo.Allergen_Reaction_DEAllergen Reactions
dbo.AllergyAllergy Instance
dbo.Allergy_Category_DEAllergy Categories
dbo.Allergy_ReactionsExtension to the Allergy table for storing part of instance data such as severity items. In future, the reaction data too will be moved to this table.
dbo.Allergy_Status_DEAllergy Status
dbo.ALLSCRIP_SIGstructured informative group  / Full textual description  indicating all instructions which can be prescribed to a patient.
dbo.ALLSCRIPTS_LATIN_SIGMaster table which holds the Dosage Frequency units which is used for prescription
dbo.Ambulatory_Status_DEUnused Ambulatory Status Dictionary
dbo.Annotate_ProblemProblem annotations
dbo.Answer_Data_Type_DEData types supported to answer a clinical question as a part of additional information for an orderable item
dbo.Answer_DEAnswers for the clinical questions. The answers could be put into a picklist which then could be used as the possible answers for a clinical question.
dbo.Answer_Persistence_DEDictionary holding the codes / descriptions used to describe the Persistence Answer i.e (From Previous Answer for Encounter, From Previous Answer for Patient, From Previous Answer for Provider etc.)
dbo.API_RegistrationStatus_DEFHIR API Registration Status
dbo.Application_DEApplication List. This is no longer used.
dbo.Appoint_SegmentSegments of an Appointment
dbo.AppointmentPatient Appointments, Past, Present and Future.
dbo.Appointment_AddressAppointment address details. This table is a child table to appoinment table
dbo.Appointment_Status_DEAppointment Status. Ie "Arrived", "Pending", "Cancelled" etc..) This dictionary is managed by Allscripts and enforced.
dbo.Appointment_Type_DEAppointment Types
dbo.Appt_Type_Category_DEAppointment Type Category Dictionary
dbo.Arrival_Mode_DEArrival Modes. Used in Visit
dbo.Associated_Provider_RolesRoles a provider plays in a patients care. Used to define a Patient Care Team.
dbo.Attachment_Status_DEAttachment statuses for attachments with referral orders.
dbo.Audit_ChartView_DiscInfoAudit of Chart view disclosures and Download Chart
dbo.AUDIT_LOGAudit Log of user and system actions.
dbo.Benefit_Category_DEBenefit Category Dictionary
dbo.Billing_Area_DEBilling Areas
dbo.Billing_Location_DEBilling Locations
dbo.Billing_Type_Override_DEBilling override options (e.g. Self Pay)
dbo.Body_Site_DEBody Site dictionary
dbo.Bureau_DEBureau related names as Entryname and its corresponding Entrycode. Users allowed to Add/Update bureau details
dbo.Business_EntityBusiness Entities. these include organizations, employers, and payers.
dbo.CancerRegistryDataCancer Registry data
dbo.Care_Plan_DEUnused Dictionary of Care Plans
dbo.Case_Registry_DetailsCase registry details
Note: SubmittingFor value for either problem/order/result will be stored in RegistryHeader table
Note: ReportConfidentiality value will be stored in RegisterHeader table
dbo.Case_Status_DEWorkers Comp Case Statuses
dbo.CaseRegistry_Details_SubmittingForCase registry to clinical item linkage
dbo.CDS_Role_DeRoles defined by CDS to be mapped to Occupations to support subscribing users to Infobutton and CDS Recommendations by role
dbo.CDSClientRequestLogCalls made to CDS from Touchworks with all the information sent to CDS and response received from CDS
dbo.CDT_Import_DEList of Clinical Document Target Import types used for determining actions used on documents being brought into the sytems
dbo.CDT_Type_DEClinical Document Target types. Used in sending of CEDs.
dbo.CED_EndpointsCED Messaging connected systems
dbo.ChargePatient Charge Data
dbo.Charge_ABNCharge Advanced Beneficiary Nofification
dbo.Charge_ABN_StatusCharge Advanced Beneficiary Nofification Status
dbo.Charge_Code_DECharge Code Dictionary
dbo.Charge_DiagnosisCharge Diagnosis
dbo.Charge_Diagnosis_Detailprimary and secondary (ICD9 and ICD10) charge diagnosis codes
dbo.Charge_GroupingCharge Grouping. Not Used.
dbo.Charge_ModifierCharge Modifiers
dbo.Charge_Report_Cat_DEUnused dictionary
dbo.Charge_StatusCharge edits
dbo.Charge_Status_DECharge Statuses
dbo.Charge_Type_DECharge Types
dbo.Chart_Alert_DEChart Alert dictionary
dbo.Chart_Location_DEChart Location (for the paper chart).
dbo.Clinical_Document_Target_DEDictionary of desitinations for CEDs. Ex (Immunization Regsitry, ACDM, etc)
dbo.Clinical_Item_Type_DEclinical item types (Problem, Medication, Allergy, Immunization, Finding, Order, Result, Goal)
dbo.Clinical_Priority_DEClinical Priority dictionary
dbo.Clinical_Relation_DETypes of family members. Used for family problem history dropdowns and checkbox in the ACI.
dbo.Clinical_Severity_DEClinical Severity terms (Ex. Emergency, Elective, Fair, Critical, etc)
dbo.CMSSpecialtyCode_DeCMS standard specialty codes
dbo.Code_Type_DEDictionary holding the codes / descriptions used to describe the Code Types associated to Med/Immunizations and Problems (CPT, LOINC, ICD etc.)
dbo.Communication_Method_DEMethods of communications for Rx orders. i.e Print Rx, Send to Retail, Dispense Rx
dbo.Community_Status_DEStatuses of the Communities used in data sharing/messaging
dbo.Compliance_Code_DECompliance Code dictionary
dbo.Cost_Center_DEUnused dictionary
dbo.Counseling_Evaluation_DEEvaluations of counseling (Needs reinforcement, Verbalized an understanding, etc)
dbo.Counseling_Handout_DECounseling Handouts
dbo.Counseling_Method_DEMethod used for counseling
dbo.Courtesy_Code_DEUnused dictionary
dbo.CPT4_Modifier_DEThe CPT4 Modifier dictionary contains modifiers valid for E/M coding and procedures.
dbo.CPT4Procedure_DEUnused CPT4 Procedure dictionary
dbo.Credential_DECredential Dictionary (M.D., MA, etc.)
dbo.CVX_DECVX codes for type of vaccine product used.
dbo.Date_Format_DEDictionary holding the codes / descriptions used to describe the Date Formats used in the UI. (i.e Fuzzy date, Past Exact Date, Exact Date and Time etc.)
dbo.Deferral_Reason_DEDictionary of selections indicating why a treatment or order would be deferred
dbo.Department_DEList of Departments. Used in scheduling
dbo.Direct_Message_Type_DEDirect Message Types
dbo.Directives_DEAdvanced Directives dictionary
dbo.Discharge_Disposition_DEDischarge Disposition values
dbo.Discount_Type_DEDiscount Type dictionary.
dbo.Disposition_Type_DEUnused Disposition Type dictionary
dbo.Division_DEDivision dictionary
dbo.Do_Not_Release_DECode associated to Orderables as to whether they can be released or Not. Also whether the User can override the Do Not Release.
dbo.DocumentA versioned storage for various kinds of documents (clinical notes, reminders, etc.)
dbo.Document_AnnotationStores annotations (text comments) made to Documents
dbo.Document_Label_DEDocument Labels
dbo.Document_RFR_Mapper"Reason for Referral" associated with a document.
dbo.Document_Security_CodeApplies "opt-in" security to the associated document, thereby limiting access to only users explicitly granted access
dbo.Document_Type_deClassifications for grouping documents by similar content and workflows
dbo.Document_XDSClinical Exchange Document mapping
dbo.DocumentInformationDocument Information
dbo.DocumentLabelLabel for documents
dbo.DOCWORKS_SignatureSignatures applied to Documents
dbo.DSM_Axis_DEDSM (Diagnostic and Statistic Manual of Mental Disorders) Axis
dbo.ECR_Determine_Reportability_DEDetermination of Reportability data present in the ECR Response
dbo.ECR_Document_MappingECR Request and Response Document IDs
dbo.ECR_Inbound_MessageContext of each of the Response from the PHR Connect Service to TW. The PHRConnect Service treats each Response by PHR Connect to TW as one operation and identifies it a GUID called MessageOperationID. MessageOperationID is used for tracking and troubleshooting the TW and PHRConnect interactions.
dbo.ECR_Inbound_Message_DetailsEach reportability response received from the PHRConnect.
dbo.ECR_Processing_Reason_DEECR processing reason code
dbo.ECR_Processing_Status_DEECR processing status code
dbo.ECR_Reportability_Priority_DEECR reportability priority codes
dbo.ECR_Reportability_Response_DetailsIndividual data elements present in the eCR Reportability Response XML
dbo.EducationPatient Education details (versioned table)
dbo.Education_FactorPatient Education factors such as readiness to learn or barriers to learning.
dbo.Education_HeaderPatient Education Header level table
dbo.Education_SessionEducation Session details. (versioned table)
dbo.Education_Session_HeaderEducation Session header table
dbo.Education_Type_DEEducation Types
dbo.EducationSession_Education_MapperTable to link Education Sessions to Patient Education
dbo.EmployerEmployers
dbo.Employer_Contact_Type_DEEmployer contact types
dbo.Employment_Status_DEEmployment Status dictionary
dbo.Employment_Type_DEEmployment Type related names as Entryname and its corresponding Entrycode. Users allowed to Add/Update Employment Type details
dbo.EncounterEncounter. An encounter is an interaction between a patient and a provider. Encounter is the main level of aggregation for clinical documentation.
dbo.Encounter_AuditEncounter form audit
dbo.Encounter_CarePlanThis holds the data about the Care Guide associated to an Encounter
dbo.Encounter_CaseLinking of a case to an encounter
dbo.Encounter_DiagnosisEncounter Diagnosis
dbo.Encounter_Diagnosis_Detailprimary and secondary ICD9 and ICD10 diagnosis codes for an encounter
dbo.Encounter_DischargeDispositionSyndromic surveillance - Discharge disposition values
dbo.Encounter_EmployerOccupational Medicine Employer information for the encounter
dbo.Encounter_Employer_ContactEmployer Contacts for an Occupational Medicine Encounter
dbo.Encounter_InsuranceRegistration Level insurance at the time of the encounter.
dbo.Encounter_ItemChildLinks Clinical Item events with and Encounter
dbo.Encounter_ItemChild_VerbLinks individual actions for a clinical item to and encounter
dbo.Encounter_OtherDate and Time the encounter or any linked clinical data was last updated.
dbo.Encounter_Service_PackageOccupational Medicine Service Package  linked to an encounter
dbo.Encounter_StatusStatus of an Encounter. This is optional but can be set from the banner.
dbo.Encounter_Status_DEEncounter Statuses
dbo.Encounter_Type_DEEncounter Types
dbo.Encounter_Workers_CompWorkers Comp information for the encounter
dbo.EncounterPortalInstructionPatient portal opt-in instructions that have been provided to patient for every encounter.
dbo.ePA_Response_AttachmentsSome of the ePA response messages come with an attachment and a link for which is displayed in the med detail dialog. This table holds that attachment information.
dbo.ePA_TransactionePA (Electronic Prior Authorization) transactions including requests and responses between ESI and  Touchworks transactions, requests and responses between ESI and Touchworks
dbo.ePA_Transaction_AnswersAnswers for the ePA response questions.
dbo.ePA_Transaction_AttachmentsWe can attach a document as additional information for the questions asked by ESI, table is used for saving that information.
dbo.ePA_Transaction_QuestionsQuestions that have come as part of ESI response. This is a child table.
dbo.ePA_Transaction_Questions_HeaderHeader table for the questions received from ESI.
dbo.Evaluated_Immunization_HistoryEvaluated Immunization History data received from registry
dbo.Expected_Action_DEValues used in the Expected Action dropdown in the medication details window.
dbo.Facility_DEFacility. Used in Patient Tracking Board
dbo.FDAMedicalDevicesMedical devices Master
dbo.FHIR_Security_LabelFHIR Security Labels
dbo.FHIR_SubscriberRelationship_DEFHIR Subscriber Relationship Standard Codes
dbo.Financial_Auth_Status_DEFinancial Authorization Statuses. These can be seen in the clinical item detail windows for meds, orders, immunizations etc..
dbo.FindingVital Signs/ Findings
dbo.Finding_Reference_RangeMinimum and Maximum values related to  Findings.
dbo.Finding_Reference_Range_TextTextual representation of finding range.
dbo.Finding_Status_DEFinding Statuses
dbo.Finding_TextTextual representation of the findings value and performing comments of a finding.
dbo.FMH_Order_DetailLinks Achieve Order ID to TW Order ID. Value in PlanItemID is used to retrieve order details to be submitted during sp call FileResult_CMS or when submitting an achieve error task (IDX_Task)
dbo.Form_DEUnused dictionary
dbo.Form_Of_Medication_DEDictionary holding the different forms in which a Medication can exist  (i.e Wafer, Syrup, Powder, Ointment etc.)
dbo.Form_Set_DEUnused dictionary
dbo.Frequency_Units_DEDictionary of frequencies used in prescribing
dbo.Gender_Identity_DEGender Identity values
dbo.Gender_Identity_Standard_DEGender Identity standard codes
dbo.General_Appropriateness_DERadiology Order Appropriateness values
dbo.GoalThis is the version level table for goals in the application. There will be a record added to this table everytime a goal is created/modified.
dbo.HCS_Registry_DetailsHCS (Health Care Survey) registry details
dbo.HealthConcernHealth Concern instance
dbo.HealthConcern_ClinicalItem_LinkLinked Clinical items for the Health Concern
dbo.HealthConcern_HeaderHealth Concern Header
dbo.HealthConcern_ImpressionHealth Concern Impression
dbo.HealthConcern_Status_DEHealth Concern statuses
dbo.HealthStatus_DEHealth Status Dictionary
dbo.HMPHealth Order Reminder child/detail table  (see also Item_HMP)
dbo.HMP_Freq_Unit_DEFrequency Units Dictionary (Simple Dictionary)
dbo.ICD10_Diagnosis_DEICD10 diagnosis codes
dbo.ICD9_Diagnosis_DEICD9 Diaganosis
dbo.IDX_Document_Type_DETypes of documents. This is not a true dictionary.
dbo.IDX_Suprt_Task_Action_DESupport Task Actions Dictionary
dbo.IDX_TaskTasks. These can be created for users or teams. They can be for a patient or not for a patient
dbo.IDX_Task_Action_DETask Actions Dictionary
dbo.IDX_Task_ExtensionTask Extension
dbo.IDX_Task_LinkLinked tasks. You can have a task create another task ie. a Notifiy task, when it completes.
dbo.IDX_Task_Status_DETask Statuses
dbo.IDX_Task_Texttask comments
dbo.IDX_UserAny "User" or "User/Provider" in the system
dbo.Ignore_Reason_DEReason Codes used when Ignoring Medication Alerts. (Ex. Benefit out weighs risk in this patient, No reasonable alternatives for the patient etc.)
dbo.ImmunizationVersioned table of patient immunizations.
dbo.Immunization_ForecastImmunization Forecast data received from registry
dbo.Inbound_DocumentInbound documents coming from an external source. Currently, this will only hold referrals coming from non-Allscripts sources.
dbo.Inbound_SubmissionSetSubmission sets coming from an external source. Currently, this will only hold referrals coming from non-Allscripts sources.
dbo.InboundOrder_Interface_Auth_DEAuthorization entries which will be verified before filing Inbound Order
dbo.Industry_DEIndustry list
dbo.InfoButtonLogLog information related to Infobutton activity performed by a provider.
dbo.Injury_InformationSpecial Billing Details
dbo.Injury_Type_DEInjury Type (Special Billing) Dictionary
dbo.Instruction_Variable_DECodes / replacement text used during Variable replacement in Text Strings. Example in the QO_Class_Instruction_Lang.FirstString when it is put in the Plan_Item.FirstString (i.e {dur1}, {temp1}, {count1} etc.)
dbo.Instruction_Variable_Type_DECodes / descriptions used to describe the different Types of Instruction Variables (Blood Pressure, Duration, Temperature etc.). Relates to the Instruction_Variable_DE records.
dbo.Insurance_Class_DEInsurance
dbo.Intervention_ActionTakenCapture events (or) action taken on various intervention types (AUC, CareGuide, POCR and Normative GrowthChart)
dbo.Intervention_ActionTaken_MapperRelated Items for the Intervention on which the actions were taken
dbo.Intervention_FeedbackDecision Support Intervention (DSI) Feedback
dbo.Intervention_Feedback_MapperItems linked to Decision Support Intervention (DSI) Feedback
dbo.Intervention_Type_DEIntervention Types
dbo.ISO_Language_DEISO languages
dbo.Item_AllergyAllergy Item Parent
dbo.Item_AnnotationItem level Annotation
dbo.Item_Entry_Type_DEContains entries that trigger alerts (such as Drug-Drug alerts). Entries in this enforced dictionary include: Medication Change, Allergy, and Medication Renewal.
dbo.Item_FindingThis is an item level table for findings. Findings are defined as anything under the Clinical Findings category in the OID such as vital signs. For every finding on a patient's chart there will only be 1 entry in this table as it's an item level table.
dbo.Item_GoalItem Level table for Goals
dbo.Item_HMPThis is the parent Table to the HMP detail records
dbo.Item_ImmunizationItem Level table for Immunizations
dbo.Item_MedicationItem Level table for Medications.
dbo.Item_PlanItem level table for non-medication orders.
dbo.Item_ResultItem level table for Results.
dbo.Item_SiteAssociates a Site to an Order Item. Although not FK the SiteDE points to the Site_DE.ID. Also the ItemID is not FK to the associated Order table but does point to the ID of the table. i.e ItemType = Immunization will then point the ItemID to the Item_Immunization.ID
dbo.Item_Status_DEItem Status Codes asociated with Medications, Allergies, Immunizations, Problems. The ID in this table is FK in Unverified_Item. (Ex. Added, EIE, Veriified, Duplicateetc.)
dbo.JardogsTaskAttachmentStores mapping for Touchworks task, FMH Task , and the attachment ID that TW passes into the FMH Attachment viewer API to display patient's attachment to provider within TW
dbo.Job_Title_DEJob Titles
dbo.Label_Type_DELabel Type definitions referenced in the OCD_Item, Order_Defaults, OrderPluralCache,Plan_Item, QO_Classification_DE, WPOrder tables
dbo.Language_DELanguage Dictionary
dbo.Laterality_Qualifier_DEDictionary for laterality. Such as left , right, unilateral etc..
dbo.Location_DEScheduling Location
dbo.Location_Type_DEDictionary holding the codes / descriptions used to describe the Types of Locations
dbo.Management_Effective_DEDictionary holding the codes / descriptions used to describe the Problem Management Effectiveness (Good Progress, Fair Control, Mildly exacerbated etc.)
dbo.Mandatory_Level_DEDictionary holding the codes / descriptions used to describe the Requiredness of Additional Information Fields (Not required, Required before execution, Required before saving etc.)
dbo.Marital_Status_DEDictionary holding Marital Statuses. i.e Married, Single, Widowed, Divorced etc.
dbo.Medical_Necessity_LogMedical Necessity Checking log
dbo.MedicalDeviceMedical device instance
dbo.MedicalDevice_HeaderMedical device Header table
dbo.MedicalDevice_Status_DEMedical device statuses
dbo.Medicare_Type_Of_Service_DEDifferent type of services provided. Not used.
dbo.MedicationMedication details
dbo.Medication_AlertDUR alerts displayed for prescriptions
dbo.Medication_Allergy_DEMedication Allergy Dictionaries
dbo.Medication_DEMedications
dbo.Medication_Fill_HistoryHistory of medication fulfillments from a pharmacy.
dbo.Medication_MedOfferThis table links a specific Medication record to a Medication Offer from dbo.MedOffer
dbo.Medispan_Symptom_DEMedispan Symptoms. This table is not part of Delta Upload. Its Stand alone table  where data is inserted via Scripts
dbo.MedOfferMedication Offer information received from the DXC service
dbo.MedOffer_Distribution_Type_DEMedication Offer Distribution types
dbo.MedOffer_ImageeCoupon images in binary format that are tied to Medication Offer records
dbo.MedOffer_Output_Method_DEOutput methods (print, send electronically, etc) for medication offer eCoupons, for use in UI combo boxes
dbo.MedOffer_Type_DETypes of coupon offers.
dbo.MedOfferDistributionThis table logs individual distribution events for dbo.Medication_MedOffer records
dbo.MRISafety_DEMRI Safety values
dbo.MVX_DEManufacturers of Vaccines (MVX)
dbo.NAW_ChargeListCharges associated with a Note
dbo.No_Immunization_Reason_DEHL7 Standard reasons an immunization was not given
dbo.Note_Activity_TextLegacy (v3) audit note content
dbo.Note_Correspondence_LetterMaps the Original Document to the Referral Document and its respective NoteLetterID (1,2,3)
dbo.Note_Section_DEDictionary of Activity types (Sections) available for a v2 Note Template
dbo.Note_Template_Versionv2 Note template definitions
dbo.Note_Type_DEv2 Note type  (e.g. 'Message' or 'Unformatted')
dbo.Note_Visibility_DE"Dictionary holding the codes / descriptions used to describe the Note Visibility i.e (Finalization,
Inital Signing, Saving etc.)"
dbo.NoteForm_Amendment_ActivationTracks the beginning of a v11 Note amendment cycle
dbo.NoteForm_NAW_Auditv11 Note Audit log
dbo.NoteForm_NAW_InstanceChild of Instance_Header.  (This is where each version of the note body is stored)    
dbo.NoteForm_NAW_Instance_HeaderThe Parent (Header) of the Child (Detail) which contains the saved V11 note
dbo.Noteform_NAW_Instance_Header_Security_CodeRestricts user access to an instance of a v11 note
dbo.NoteForm_NAW_Instance_Output_MapAssociates a v11 note instance to multiple output documents and the template that generated them
dbo.NoteForm_Section_DEThe possible sections (e.g, HPI, physical exam) into which a noteform should be placed when brought into the NAW. Generally this will track with the noteform type.  A form is assigned to one section.
dbo.NoteformNAWCEDClinical exchange extract
dbo.OccMed_Employer_DEOccupational Medicine Employers
dbo.Occupation_DE"Dictionary holding the codes / descriptions used to describe the Staff Occupations i.e (Admin Assistant,
Anesthesiologist, Nurse Practitioner etc.)"
dbo.OCD_GuidelineGuidelines for Orderable Concepts and Allscripts delivered Care Guides
dbo.OCD_HeaderOrderable Concept Dictionary Item header
dbo.OCD_InstructionOrderable Concept instruction header
dbo.OCD_Instruction_LangOrderable Concept instruction
dbo.OCD_ItemOrderable Concept Dictionary Item
dbo.OCD_VersionOrderable Concept Dictionary Version
dbo.OnHold_Status_DEDictionary holding the codes / descriptions used to describe the On Hold Statuses for an order i.e (Waiting for Activation, ABN Status Required, LMRP Needed for Performing Location etc.)
dbo.Operand_DESimple dictionary for operands used in calculating Patient Goals
dbo.Order_ABN_StatusMedical Necessity status for an Order
dbo.Order_ActivityActivity level table for Orders (Medication and Non-Medication orders)
dbo.Order_Activity_HeaderActivity Header table for Medication and Non-Medication orders
dbo.Order_Appt_Status_DESupported statuses of the need for an appointment for an orderable item (Appointment Needed, Appoitment Scheduled, etc.)
dbo.Order_Document_MapperTable for linking documents to orders.
dbo.Order_Guidelines_DetailOrder guidelines details for Imaging and Diagnostic orders.
dbo.Order_Item_ChargeCharges for orders
dbo.Order_Item_Charge_ModifierCPT4 modifiers in separate rows/records, when Charge codes with 0-5 Modifier are selected after commit of order edit workflow
dbo.Order_Item_CommonGeneral Order Instance Data
dbo.Order_Priority_DEOrder Priority values.
dbo.Order_Reason_DEDeprecated Referral and Follow-up order reason dictionary.
dbo.Order_Referral_MapperMaps Referrals to Orders
dbo.Order_Referral_Message_MapperMaps each version of a referral order to referral messages
dbo.Order_Result_MapperMaps the Result(s) to the Order at the header level.
dbo.Order_Result_ReviewThis table holds the reviewed status of the Order / Result. When an edit happens the Status is set to U
dbo.Order_Source_DEType of methods with which an Order can be recorded in the system
dbo.Order_Status_DEOrder Statuses
dbo.Order_Status_Reason_DEReasons to state why an order is in a particular state. For instance  hold for specimen collection where order is in hold status and the reason for hold being to collect the specimen.
dbo.Ordering_Authority_DEOrdering Authority Levels
dbo.Org_Sharing_DEOrganization Sharing Pool. Organizations in the same sharing pool share patient charts.
dbo.OrganizationOrganization.
dbo.Patient_AlertPatient Alert details from Patient Query
dbo.Patient_Alert_DeferralDeferred Patient Alert from Patient Query
dbo.Patient_Care_Team_DEPatient care team entries
dbo.Patient_Caseworkers comp case information
dbo.Patient_Chart_AlertChart Alerts displayed in the patient banner
dbo.Patient_Communication_DEPatient Communicaiton dictionary
dbo.Patient_CommunityPatient Community Membership
dbo.Patient_Community_AuditAudit record of changes ot the Patient_Community table
dbo.Patient_ConsentPatient consents
dbo.Patient_Consent_DEPatient Consent types
dbo.Patient_ContactPatient's Contact demographic data (Emergency, Guarantor)
dbo.Patient_CorrespondencePatient correspondence data
dbo.Patient_Deceased_AuditDeceased patients
dbo.Patient_DirectivesAdvance Directives associated with the Patient
dbo.Patient_EducationPatient Education details.
dbo.Patient_Education_ProvidedAudit of when patient education was provided
dbo.Patient_Family_UnitFamily unit information for the patient (employee)
dbo.Patient_Family_Unit_MemberFamily unit member information
dbo.Patient_ImmRegistry_LogImmunization Registry requests per patient
dbo.Patient_ImmRegistry_Sent_LogAudit data sent to Immunization Registries
dbo.Patient_IorgTable linking Patients to Organizations.
dbo.Patient_Iorg_HistoryHistory of changes to the Patient_Iorg table
dbo.Patient_ListPatient List definitions.
dbo.Patient_List_EntryPatients on a Patient List
dbo.Patient_List_MembershipLinkage of Queries to patient lists.
dbo.Patient_LocationCurrent Location for a patient. Set from the banner.
dbo.Patient_Location_DEPatient Locations
dbo.Patient_MasterChartTable to provide a master patient index external identifier for the patient. This must be unique per organization pool and only one per patient.
dbo.Patient_MemberPatient Specific Demographic Information
dbo.Patient_Occupation_DEPatient Occupations
dbo.Patient_Occupation_IndustryThis table is used in Cancer Registry Report to store Patient's working history. It stores Patient's Occupation, Industry , start date and end date. This is displayed in the patient profile
dbo.Patient_Past_DiagnosisTable containing Patient Past Diagnosis data
dbo.Patient_PBMPatient Rx Benefit plan information
dbo.Patient_Pharmacy_DefDefau;t pharmacies for a patient. This table gets populated when assigning pharmacies to a patient in the Patient Profile screen in TouchWorks. You can have up to 4 retail pharmacies and 4 mail_order. Once you exceed this limit the app will still add the new entry but it will remove the oldest one
dbo.Patient_SecGroupTable containing the Security / Access Group associations for Patients
dbo.Patient_WLPPatient Wellpoint Document data
dbo.Patient_Worklist_Order_ReviewTable containing a listing of Orders that need to be Reviewed by a user
dbo.PatientAccessLogAudit of patients brought into context.
dbo.PatientAPIRegistrationStatusFHIR API Registration Status of Patients
dbo.PatientCautionText for the FYI button in the patient banner
dbo.PatientCommunicationportal/communication preferences (migrated from person_other)
dbo.PatientCommunication_AuditAudit of changes to the PatientCommunication table
dbo.PatientCommunication_UpdatesPatients with manual communication updates
dbo.PatientOrderStatusReasonsThis is a worklist table to help keep tract of what items require some worklist action.
dbo.PatientPortalUserActivityAudit of how patients are accessing data on the portal and FIHR activity.
dbo.PatientPortalUserActivityDetailAn extension of PatientPortalUserActivity  table. Use to store relevant items extracted with a CCDA document (Activity Type - K).
dbo.Payment_Typology_DEPayment Topology Codes
dbo.PBM_DERx Benefit plan providers
dbo.PBM_Override_Reason_DEPBM Override Reasons
dbo.PBM_Problem_ListProblem List of a patient  as available from PBM
dbo.PersonTable of primary demopraphics. A person can have one or more roles including patient, user, or provider.
dbo.Person_AddressPostal Address for a person
dbo.Person_Address_HistoryAddress History for a person
dbo.Person_AliasesAliases for the Person
dbo.Person_Multi_DictionaryPatient attributes , which have multiple entries. View vPersonMultiDictionary  will return a unique row per Person
dbo.Person_OtherAdditional demographic information for the Patient, User and providers
dbo.Person_PhoneThis table contains the various telephone numbers associated to Patient, Provider and Users
dbo.Person_PictureThis table contains a Patient Picture
dbo.Person_RaceRaces for a person (implemented for patients).
dbo.Person_TribalAffiliationTribal Affiliations for a patient
dbo.Person_XIDThis table is a cross reference between external PM systems and Our Person table
dbo.Pharmacy_DEPharmacy Dictionary
dbo.PhysicalManifestation_DE Definition of how documents can be stored. IE pdf, rtf, noteform… It's used so that code accessing different documents will know how to open them.
dbo.PicklistA subset of a dictionary. Picklists are used as a valid set of choices for a field.
dbo.PIXEntriesPatient Identifier Cross Referencing (PIX) Entries. A PIX Feed is used to generate an ADT type message. Only used for clients with PIX Feed’s.
dbo.Place_of_Injury_DEUnused Place Of Injury dictionary
dbo.Place_of_Service_DEUnused Place of Service dictionary
dbo.Plan_ItemVersioned Detail table for non-medication orders.
dbo.Plan_Item_Instruction_VariableMapping between the Plan_Item and the Instruction_Variable_DE tables for the variable value replacement in the FirstString value. FirstString based on the Item_Plan.QOClassificationDE -> QO_Classification_DE.QOClassInstructionID
dbo.Plan_Item_OrderOrder Comminication and Identifier properties
dbo.PMP_Historydocumentation for Prescription Monitoring Program (PMP) Registry consultation
dbo.PMP_Reason_DEPrescription Monitoring Program (PMP) registry consult/lack of consult reasons
dbo.Portal_Registration_Status_DEPortal registration statuses
dbo.Post_DEJob posts
dbo.Preferred_Pronoun_DEList of preferred Pronouns for gender
dbo.Preferred_Pronoun_Standard_DEStandard Preferred Pronoun LOINC Codes
dbo.PrescribeAction_DE Valid methods of communicating the prescription. IE "Call" or "Dispense".
dbo.PrescriptionLogContains the Log of patient Prescriptions and the related provider and prescription information
dbo.Primary_InsuranceCurrent Registration Insurance for the patient
dbo.PRN_DEPRN (As Needed) reasons
dbo.ProblemProblem Instance
dbo.Problem_ActivityLinkage of problems to other clinical items.
dbo.Problem_Category_DEProblem Category Dictionary (Simple Dictionary)
dbo.Problem_ClinicalRelation_MapMapping Table between Problem and the clinical relation (Clinical_Relation_DE) for family history problems
dbo.Problem_DEProblem Dictionary
dbo.Problem_EM_Complexity_DEProblem complexity values which matches the ama verbiage better
dbo.Problem_EncounterProblems associated to an Encounter (usually assessments)
dbo.Problem_HeaderProblem Instance Header
dbo.Problem_ICDCodeTable to Link ICD codes to Problems.
dbo.Problem_ImpressionNew table created to store Impressions added for each Patient's problem. This is Encounter specific. Impressions are added on the problem details screen.
dbo.Problem_Link_AlertProblem Linkage Alerts
dbo.Problem_Status_DEProblem Statuses
dbo.Problem_TransitionProblem Transition from one problem to another
dbo.Problem_Type_DEProblem Type Dictionary (Simple Dictionary)
dbo.Product_Line_DEUnused dictionary
dbo.Program_DEUnused dictionary
dbo.ProviderProvider. Changes to the provider account can be made in TWAdmin->TWUserAdmin, via SSMT, or via a FileProvider interface. A "Provider" only account will just have a record in the dbo.Person and dbo.Provider table. If it's a "user/provider" account then it will also have a record in the dbo.IDX_User table.
dbo.Provider_Type_DEDictionary holding the Provider Types. This table is referenced by the Provider table with a FK relationship to the ProviderTypeDE
dbo.QO_Class_InstructionThis table contains instructions that pertain to orders. It gets populated via the CareGuide installer.
dbo.QO_Class_Instruction_LangOrderable Item Instructions. Used for instruction orders.
dbo.QO_Classification_DENon-Medication Orderable Items
dbo.QO_DEResultable items that could be used for a non-med order
dbo.QO_InstructionNo Longer Used.
dbo.QO_Mod_DEModifiers for orderable items
dbo.QueryPatient Query. This data is created in conjunction with the creation of Patient Access List scripts. The number at the end of the Query Name represents the ID in the Patient_List. The Query is also associated to Patient Alerts (Patient_Alert and Patient_Alert_Deferral). No Longer Used.
dbo.Race_DEDictionary holding Race classifications i.e Hispanic, White, Chinese etc.
dbo.RCD_HeaderResultable Concept header
dbo.RCD_ItemResultable Concept Item
dbo.Reaction_Severity_DESeverity values that can be associated to the Reactions.
dbo.Reconciled_Listdata related to the reconciliation of Medication and Allergy Orders including the User ID for the reconciling User
dbo.Reconciled_List_ItemData relating the Reconciled_List to the associated individual Orders
dbo.Recording_Format_DERecording format for dictations
dbo.Reference_Range_TextResult Reference Ranges
dbo.Referral_AttachmentAttachments for the Referral Requests and Referral Responses
dbo.Referral_DocumentReferral documents from both requests and responses
dbo.Referral_HeaderHeader level table to store referral Request and Response for each Referral Order
dbo.Referral_MessageRequest and Response information for all the Referral Messages
dbo.Referral_Org_DetailsReferral organization name and NPI details
dbo.Referral_Type_DEReferral types
dbo.Referring_Provider_DEReferring Providers
dbo.Registry_Refusal_Reason_DERegistry refusal reasons
dbo.Registry_Region_DERegistry Dictionary
dbo.RegistryHeaderHeader table for Registry value sets for Cancer Registry and Health Care Survey
dbo.Regulatory_Loinc_DERegulatory Loinc Dictionary table of special LOINC Codes different than regular LOINC Codes
dbo.Relationship_DERelationships (Father, Mother, etc.)
dbo.Religion_DEReligion dictionary
dbo.Remove_Reason_DERemove Reason dictionary. Used with tasks.
dbo.Req_Perf_Location_DERequested Preforming Locations
dbo.RequisitionRequisition information related to  lab orders.
dbo.Requisition_Status_DEStatuses for order requisitions
dbo.Resource_DESchedulable resource. This can be a provider or something else such as exam room 1. Entries are generated for scheduleable providers.
dbo.ResultVersioned detail table for Results
dbo.Result_Communication_DEResult Communication Methods
dbo.Result_External_StorageLinks Image results to their external storage system
dbo.Result_Flag_DEResult ABNORMALITY flag values.
dbo.Result_Status_DEResult Statuses
dbo.Result_TextLong textual results along with result item performing location comments.
dbo.Route_Of_Admin_DERoute of Administration dictionary (Oral, Nasal, External, etc.).
dbo.RX_Authority_DEPrescribeing Authority dictionary.
dbo.Rx_Dispense_TransactionTransaction sent to Inventory Mgmt System when a Medication/Immunization is dispensed
dbo.ScheduleData associated with the schedules for Scheduled Orders.
dbo.Schedule_DatesList of Scheduled dates associated with a Scheduled Order
dbo.Schedule_HeaderHeader records for Scheduled Orders
dbo.Security_Code_DEList of Security Codes
dbo.SensitiveHealth_ManualPatients those who are manually flagged as Potentially sensitive health patients
dbo.Service_DEServices. Not currently used.
dbo.Service_Location_DEStandard HealthCare Service Location entries provided by CDC. "Requested Performing location" and "Where performed" dictionaries are mapped to these values. When the Cancer Registry report is sent to Registry, CDW (AAP) team uses this mapping to send standard values of "Requested Performing location" and "Where performed".
dbo.Service_Package_CommentOccupational Medicine Service Package Comments
dbo.Service_Package_Comment_AcknowledgementsOccupational Medicine Service Package Note Acknowledgements
dbo.Service_Package_ComponentOccupational Medicine Service Package Component (Orderable Item).
dbo.Service_Transaction_Type_DEService transaction type dictionary
dbo.Services_Transaction_RequestRequest data for PDMP, PPT+, eCoupon
dbo.Services_Transaction_ResponseKey To the Services_Transaction_Response table
dbo.Sex_DEGender
dbo.Sexual_Orientation_DESexual Orientation values
dbo.Sexual_Orientation_Standard_DEStandard Codes for Sexual Orientation
dbo.Signature_Authority_DESignature Authority Dictionary
dbo.Signature_Purpose_DESignature Purpose Dictionary
dbo.Site_DEThe Site dictionary is a generic dictionary that is used to identify clinics where providers practice within a larger organization.        
dbo.Site_Location_DEPotential locations a patient could be. This is seen in the dropdown on the patient banner so users can update the patient's location
dbo.Source_DESource dictionary (Spine, Sweat, Plasma, etc.)
dbo.Specialty_DESpecialty dictionary. (Family Medicine, Dermatology, etc.)
dbo.SpecimenSpecimen
dbo.Specimen_Temperature_DESpecimen Temperature (Ambient, Frozen, Refrigerated)
dbo.Specimen_Type_DESpecimen Type (Blood, Urine, etc.)
dbo.SubOrder_Type_DESub Order Type dictionary
dbo.Syndromic_Registry_Region_DESymdromic registries
dbo.Task_Priority_DETask Priority  Dictionary
dbo.Task_Read_DetailTask read information for an user and task combination.
dbo.Team_DETeams associated to Tasks
dbo.Telephone_Type_DETelephone Type (Mobile, Work, Evening, Day etc.)
dbo.Time_ZoneList of Time Zones
dbo.Tooth_Surface_Code_DEDictionary holding the codes / descriptions used to describe the different Tooth Surfaces i.e (Mesial, Facial, Lingial etc.)
dbo.Tribal_Affiliation_DEDictionary of Tribal Affiliations
dbo.UAIEncounterChartItemmimics encounter_chart_item for work done in TW Mobile during a session.
dbo.Unfinished_CallUnfinished call information
dbo.Unit_Code_DEUnits dictionary (Once, Pound, Millimeter, etc.)
dbo.Unverified_ItemUnverified clinical items
dbo.Unverified_Item_Type_DETypes of Unverified Items (Active Allergy, Active Problem, etc.)
dbo.UnverifiedItem_AllergyUnverfied Allergy
dbo.UnverifiedItem_ImmunizationImmunizations imported via external sources
dbo.UnverifiedItem_MedicationMedications imported via External sources.
dbo.UnverifiedItem_ProblemUnverified Probem
dbo.Vaccine_Category_DEVaccine Category Definitions
dbo.Vaccine_Manufacturer_DEVaccine Manufacturer Definitions
dbo.Vendor_DEVendors
dbo.Vendor_ItemMedcin Findings patient data
dbo.Vendor_Item_ExtensionExtension type/value tied to the Vendor_Item table
dbo.VIP_Type_DEVIP (very Important Person) Types associated to a person i.e Celebrity, Clergy etc.
dbo.VisitVisit. A visit is the parent of an encounter.
dbo.Visit_AttendingProviderTable to contain multiple Attending Providers associated to the Visit
dbo.Visit_ConsultingProviderTable to contain multiple Consulting Providers associated to the Visit
dbo.Visit_DetailTable containing dates and providers associated with the Visit
dbo.Visit_InsuranceInsurance data asociated with the Patient for the Visit.
dbo.Visit_Status_DEVisit Status i.e Admitted, Canceled, Discharged etc.
dbo.Visit_Type_DEVisit Types associated to a Patient Visit i.e Inpatient, Office Outpatient etc.
dbo.When_To_Charge_DEWhen To Charge codes associated to Order Charges i.e Never, On Order, When Resulted etc.
dbo.Where_Performed_DEWhere Performed dictionary. These are for orders.
dbo.Workflow_Type_DEWorkflow Type dictionary. Used in the document interface (Electronic Signature, Electronic Verification, Non Electronic)