Name | Description |
---|---|
CDS.AppliedRecommendationDisposition | Audit of the disposition returned for a recommendation |
CDS.DispositionReason | Available types of reasons when supressing/ignoring a recommendation |
CDS.DispositionSource | various available source of appliedrecommendationSource |
CDS.DispositionType | various types of allowed dispositions |
CDS.PatientData | used in track last submit date time for a patient |
CDS.Recommendation | table of active recommendations |
CDS.RecommendationAssertion | table of assertions associated to recommendation |
CDS.RecommendationAssertionHistory | table of assertions associated to recommendation history |
CDS.RecommendationDispositionApplication | log of recommendations that had a dispositionapplied to the provider |
CDS.RecommendationHistory | recommendations that are no longer active |
CDS.RecommendationParty | Parties 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.RecommendationPartyHistory | Parties 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.RecommendationReference | References associated with the recommendation where additional information can be found on the recommendation |
CDS.RecommendationReferenceHistory | References associated with the recommendationHistory where additional information can be found on the recommendation |
CDS.RecommendationSource | indentifies the rule(s) and participant(s) that triggered the recommendation |
CDS.RecommendationSourceHistory | indentifies the rule(s) and participant(s) that triggered the recommendation. Child of recommendations in the history table |
CDS.RecommendationTypeDisposition | tracks dispositions associated to an assertion |
CDS.Role | role types for recommendationReferences |
CDS.RuleDisposition | tracks dispositions that are associated to a rule |
CDS.Severity | available severity codes for recommendations |
CDS.Status | various available statuses of recommendations |
dbo.ABN_Intermediate_Status_DE | Medical Necessity Edits |
dbo.Access_Group | This 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_Allergy | Allergy Activity |
dbo.Act_Annotation | Activity level annotation |
dbo.Act_Goal | Activity level table for patient Goals. Derived from the Act_HDr_Goal table for every activity of the Goal |
dbo.Act_Hdr_Allergy | Allergy Activity Header |
dbo.Act_Hdr_Goal | Activity Header Level table for Goals |
dbo.Act_Hdr_HMP | Activity header table for order reminders |
dbo.Act_Hdr_MedAdmin | Activity header table for medication administration. Replaced by Order_Activity_Header |
dbo.Act_Hdr_Other | Activity Header table for Findings and Immunizations. |
dbo.Act_Hdr_Result | Activity header table for Results |
dbo.Act_Hdr_Vitals | Activity header table for Vitals. Replaced by Act_Hdr_Other. |
dbo.Act_HMP | Activity table for Order Reminders |
dbo.Act_MedAdmin | Activity table for medication Administration. Replaced by Order_Activity |
dbo.Act_Note | Activity table for note. Used for Audit Notes. |
dbo.Act_Other | Activity table for Findings and Immunizations. |
dbo.Act_Result | Activity Level table for Results |
dbo.Act_Result_Extension | Additional activity level versioned properties for Results |
dbo.Act_Vitals | Activity table for vitals. Replaced by Act_Other |
dbo.Activity_Type_DE | Activity Types |
dbo.Additional_Information | Additional Information Questions instance data |
dbo.Additional_Information_DE | Additional Information Questions Dictionary |
dbo.Admin_Disposition_DE | Dictionary holding the codes / descriptions used to describe the Disposition Administration i.e (Administered, Pending, No Show etc.) |
dbo.Agency_DE | Agency related names as Entryname and its corresponding Entrycode. Users allowed to Add/Update agency details |
dbo.Alert_Type_DE | Alert Type dictionary |
dbo.Allergen_DE | Non-Medication allergens |
dbo.Allergen_Reaction_DE | Allergen Reactions |
dbo.Allergy | Allergy Instance |
dbo.Allergy_Category_DE | Allergy Categories |
dbo.Allergy_Reactions | Extension 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_DE | Allergy Status |
dbo.ALLSCRIP_SIG | structured informative group / Full textual description indicating all instructions which can be prescribed to a patient. |
dbo.ALLSCRIPTS_LATIN_SIG | Master table which holds the Dosage Frequency units which is used for prescription |
dbo.Ambulatory_Status_DE | Unused Ambulatory Status Dictionary |
dbo.Annotate_Problem | Problem annotations |
dbo.Answer_Data_Type_DE | Data types supported to answer a clinical question as a part of additional information for an orderable item |
dbo.Answer_DE | Answers 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_DE | Dictionary 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_DE | FHIR API Registration Status |
dbo.Application_DE | Application List. This is no longer used. |
dbo.Appoint_Segment | Segments of an Appointment |
dbo.Appointment | Patient Appointments, Past, Present and Future. |
dbo.Appointment_Address | Appointment address details. This table is a child table to appoinment table |
dbo.Appointment_Status_DE | Appointment Status. Ie "Arrived", "Pending", "Cancelled" etc..) This dictionary is managed by Allscripts and enforced. |
dbo.Appointment_Type_DE | Appointment Types |
dbo.Appt_Type_Category_DE | Appointment Type Category Dictionary |
dbo.Arrival_Mode_DE | Arrival Modes. Used in Visit |
dbo.Associated_Provider_Roles | Roles a provider plays in a patients care. Used to define a Patient Care Team. |
dbo.Attachment_Status_DE | Attachment statuses for attachments with referral orders. |
dbo.Audit_ChartView_DiscInfo | Audit of Chart view disclosures and Download Chart |
dbo.AUDIT_LOG | Audit Log of user and system actions. |
dbo.Benefit_Category_DE | Benefit Category Dictionary |
dbo.Billing_Area_DE | Billing Areas |
dbo.Billing_Location_DE | Billing Locations |
dbo.Billing_Type_Override_DE | Billing override options (e.g. Self Pay) |
dbo.Body_Site_DE | Body Site dictionary |
dbo.Bureau_DE | Bureau related names as Entryname and its corresponding Entrycode. Users allowed to Add/Update bureau details |
dbo.Business_Entity | Business Entities. these include organizations, employers, and payers. |
dbo.CancerRegistryData | Cancer Registry data |
dbo.Care_Plan_DE | Unused Dictionary of Care Plans |
dbo.Case_Registry_Details | Case 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_DE | Workers Comp Case Statuses |
dbo.CaseRegistry_Details_SubmittingFor | Case registry to clinical item linkage |
dbo.CDS_Role_De | Roles defined by CDS to be mapped to Occupations to support subscribing users to Infobutton and CDS Recommendations by role |
dbo.CDSClientRequestLog | Calls made to CDS from Touchworks with all the information sent to CDS and response received from CDS |
dbo.CDT_Import_DE | List of Clinical Document Target Import types used for determining actions used on documents being brought into the sytems |
dbo.CDT_Type_DE | Clinical Document Target types. Used in sending of CEDs. |
dbo.CED_Endpoints | CED Messaging connected systems |
dbo.Charge | Patient Charge Data |
dbo.Charge_ABN | Charge Advanced Beneficiary Nofification |
dbo.Charge_ABN_Status | Charge Advanced Beneficiary Nofification Status |
dbo.Charge_Code_DE | Charge Code Dictionary |
dbo.Charge_Diagnosis | Charge Diagnosis |
dbo.Charge_Diagnosis_Detail | primary and secondary (ICD9 and ICD10) charge diagnosis codes |
dbo.Charge_Grouping | Charge Grouping. Not Used. |
dbo.Charge_Modifier | Charge Modifiers |
dbo.Charge_Report_Cat_DE | Unused dictionary |
dbo.Charge_Status | Charge edits |
dbo.Charge_Status_DE | Charge Statuses |
dbo.Charge_Type_DE | Charge Types |
dbo.Chart_Alert_DE | Chart Alert dictionary |
dbo.Chart_Location_DE | Chart Location (for the paper chart). |
dbo.Clinical_Document_Target_DE | Dictionary of desitinations for CEDs. Ex (Immunization Regsitry, ACDM, etc) |
dbo.Clinical_Item_Type_DE | clinical item types (Problem, Medication, Allergy, Immunization, Finding, Order, Result, Goal) |
dbo.Clinical_Priority_DE | Clinical Priority dictionary |
dbo.Clinical_Relation_DE | Types of family members. Used for family problem history dropdowns and checkbox in the ACI. |
dbo.Clinical_Severity_DE | Clinical Severity terms (Ex. Emergency, Elective, Fair, Critical, etc) |
dbo.CMSSpecialtyCode_De | CMS standard specialty codes |
dbo.Code_Type_DE | Dictionary holding the codes / descriptions used to describe the Code Types associated to Med/Immunizations and Problems (CPT, LOINC, ICD etc.) |
dbo.Communication_Method_DE | Methods of communications for Rx orders. i.e Print Rx, Send to Retail, Dispense Rx |
dbo.Community_Status_DE | Statuses of the Communities used in data sharing/messaging |
dbo.Compliance_Code_DE | Compliance Code dictionary |
dbo.Cost_Center_DE | Unused dictionary |
dbo.Counseling_Evaluation_DE | Evaluations of counseling (Needs reinforcement, Verbalized an understanding, etc) |
dbo.Counseling_Handout_DE | Counseling Handouts |
dbo.Counseling_Method_DE | Method used for counseling |
dbo.Courtesy_Code_DE | Unused dictionary |
dbo.CPT4_Modifier_DE | The CPT4 Modifier dictionary contains modifiers valid for E/M coding and procedures. |
dbo.CPT4Procedure_DE | Unused CPT4 Procedure dictionary |
dbo.Credential_DE | Credential Dictionary (M.D., MA, etc.) |
dbo.CVX_DE | CVX codes for type of vaccine product used. |
dbo.Date_Format_DE | Dictionary 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_DE | Dictionary of selections indicating why a treatment or order would be deferred |
dbo.Department_DE | List of Departments. Used in scheduling |
dbo.Direct_Message_Type_DE | Direct Message Types |
dbo.Directives_DE | Advanced Directives dictionary |
dbo.Discharge_Disposition_DE | Discharge Disposition values |
dbo.Discount_Type_DE | Discount Type dictionary. |
dbo.Disposition_Type_DE | Unused Disposition Type dictionary |
dbo.Division_DE | Division dictionary |
dbo.Do_Not_Release_DE | Code associated to Orderables as to whether they can be released or Not. Also whether the User can override the Do Not Release. |
dbo.Document | A versioned storage for various kinds of documents (clinical notes, reminders, etc.) |
dbo.Document_Annotation | Stores annotations (text comments) made to Documents |
dbo.Document_Label_DE | Document Labels |
dbo.Document_RFR_Mapper | "Reason for Referral" associated with a document. |
dbo.Document_Security_Code | Applies "opt-in" security to the associated document, thereby limiting access to only users explicitly granted access |
dbo.Document_Type_de | Classifications for grouping documents by similar content and workflows |
dbo.Document_XDS | Clinical Exchange Document mapping |
dbo.DocumentInformation | Document Information |
dbo.DocumentLabel | Label for documents |
dbo.DOCWORKS_Signature | Signatures applied to Documents |
dbo.DSM_Axis_DE | DSM (Diagnostic and Statistic Manual of Mental Disorders) Axis |
dbo.ECR_Determine_Reportability_DE | Determination of Reportability data present in the ECR Response |
dbo.ECR_Document_Mapping | ECR Request and Response Document IDs |
dbo.ECR_Inbound_Message | Context 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_Details | Each reportability response received from the PHRConnect. |
dbo.ECR_Processing_Reason_DE | ECR processing reason code |
dbo.ECR_Processing_Status_DE | ECR processing status code |
dbo.ECR_Reportability_Priority_DE | ECR reportability priority codes |
dbo.ECR_Reportability_Response_Details | Individual data elements present in the eCR Reportability Response XML |
dbo.Education | Patient Education details (versioned table) |
dbo.Education_Factor | Patient Education factors such as readiness to learn or barriers to learning. |
dbo.Education_Header | Patient Education Header level table |
dbo.Education_Session | Education Session details. (versioned table) |
dbo.Education_Session_Header | Education Session header table |
dbo.Education_Type_DE | Education Types |
dbo.EducationSession_Education_Mapper | Table to link Education Sessions to Patient Education |
dbo.Employer | Employers |
dbo.Employer_Contact_Type_DE | Employer contact types |
dbo.Employment_Status_DE | Employment Status dictionary |
dbo.Employment_Type_DE | Employment Type related names as Entryname and its corresponding Entrycode. Users allowed to Add/Update Employment Type details |
dbo.Encounter | Encounter. An encounter is an interaction between a patient and a provider. Encounter is the main level of aggregation for clinical documentation. |
dbo.Encounter_Audit | Encounter form audit |
dbo.Encounter_CarePlan | This holds the data about the Care Guide associated to an Encounter |
dbo.Encounter_Case | Linking of a case to an encounter |
dbo.Encounter_Diagnosis | Encounter Diagnosis |
dbo.Encounter_Diagnosis_Detail | primary and secondary ICD9 and ICD10 diagnosis codes for an encounter |
dbo.Encounter_DischargeDisposition | Syndromic surveillance - Discharge disposition values |
dbo.Encounter_Employer | Occupational Medicine Employer information for the encounter |
dbo.Encounter_Employer_Contact | Employer Contacts for an Occupational Medicine Encounter |
dbo.Encounter_Insurance | Registration Level insurance at the time of the encounter. |
dbo.Encounter_ItemChild | Links Clinical Item events with and Encounter |
dbo.Encounter_ItemChild_Verb | Links individual actions for a clinical item to and encounter |
dbo.Encounter_Other | Date and Time the encounter or any linked clinical data was last updated. |
dbo.Encounter_Service_Package | Occupational Medicine Service Package linked to an encounter |
dbo.Encounter_Status | Status of an Encounter. This is optional but can be set from the banner. |
dbo.Encounter_Status_DE | Encounter Statuses |
dbo.Encounter_Type_DE | Encounter Types |
dbo.Encounter_Workers_Comp | Workers Comp information for the encounter |
dbo.EncounterPortalInstruction | Patient portal opt-in instructions that have been provided to patient for every encounter. |
dbo.ePA_Response_Attachments | Some 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_Transaction | ePA (Electronic Prior Authorization) transactions including requests and responses between ESI and Touchworks transactions, requests and responses between ESI and Touchworks |
dbo.ePA_Transaction_Answers | Answers for the ePA response questions. |
dbo.ePA_Transaction_Attachments | We can attach a document as additional information for the questions asked by ESI, table is used for saving that information. |
dbo.ePA_Transaction_Questions | Questions that have come as part of ESI response. This is a child table. |
dbo.ePA_Transaction_Questions_Header | Header table for the questions received from ESI. |
dbo.Evaluated_Immunization_History | Evaluated Immunization History data received from registry |
dbo.Expected_Action_DE | Values used in the Expected Action dropdown in the medication details window. |
dbo.Facility_DE | Facility. Used in Patient Tracking Board |
dbo.FDAMedicalDevices | Medical devices Master |
dbo.FHIR_Security_Label | FHIR Security Labels |
dbo.FHIR_SubscriberRelationship_DE | FHIR Subscriber Relationship Standard Codes |
dbo.Financial_Auth_Status_DE | Financial Authorization Statuses. These can be seen in the clinical item detail windows for meds, orders, immunizations etc.. |
dbo.Finding | Vital Signs/ Findings |
dbo.Finding_Reference_Range | Minimum and Maximum values related to Findings. |
dbo.Finding_Reference_Range_Text | Textual representation of finding range. |
dbo.Finding_Status_DE | Finding Statuses |
dbo.Finding_Text | Textual representation of the findings value and performing comments of a finding. |
dbo.FMH_Order_Detail | Links 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_DE | Unused dictionary |
dbo.Form_Of_Medication_DE | Dictionary holding the different forms in which a Medication can exist (i.e Wafer, Syrup, Powder, Ointment etc.) |
dbo.Form_Set_DE | Unused dictionary |
dbo.Frequency_Units_DE | Dictionary of frequencies used in prescribing |
dbo.Gender_Identity_DE | Gender Identity values |
dbo.Gender_Identity_Standard_DE | Gender Identity standard codes |
dbo.General_Appropriateness_DE | Radiology Order Appropriateness values |
dbo.Goal | This 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_Details | HCS (Health Care Survey) registry details |
dbo.HealthConcern | Health Concern instance |
dbo.HealthConcern_ClinicalItem_Link | Linked Clinical items for the Health Concern |
dbo.HealthConcern_Header | Health Concern Header |
dbo.HealthConcern_Impression | Health Concern Impression |
dbo.HealthConcern_Status_DE | Health Concern statuses |
dbo.HealthStatus_DE | Health Status Dictionary |
dbo.HMP | Health Order Reminder child/detail table (see also Item_HMP) |
dbo.HMP_Freq_Unit_DE | Frequency Units Dictionary (Simple Dictionary) |
dbo.ICD10_Diagnosis_DE | ICD10 diagnosis codes |
dbo.ICD9_Diagnosis_DE | ICD9 Diaganosis |
dbo.IDX_Document_Type_DE | Types of documents. This is not a true dictionary. |
dbo.IDX_Suprt_Task_Action_DE | Support Task Actions Dictionary |
dbo.IDX_Task | Tasks. These can be created for users or teams. They can be for a patient or not for a patient |
dbo.IDX_Task_Action_DE | Task Actions Dictionary |
dbo.IDX_Task_Extension | Task Extension |
dbo.IDX_Task_Link | Linked tasks. You can have a task create another task ie. a Notifiy task, when it completes. |
dbo.IDX_Task_Status_DE | Task Statuses |
dbo.IDX_Task_Text | task comments |
dbo.IDX_User | Any "User" or "User/Provider" in the system |
dbo.Ignore_Reason_DE | Reason Codes used when Ignoring Medication Alerts. (Ex. Benefit out weighs risk in this patient, No reasonable alternatives for the patient etc.) |
dbo.Immunization | Versioned table of patient immunizations. |
dbo.Immunization_Forecast | Immunization Forecast data received from registry |
dbo.Inbound_Document | Inbound documents coming from an external source. Currently, this will only hold referrals coming from non-Allscripts sources. |
dbo.Inbound_SubmissionSet | Submission sets coming from an external source. Currently, this will only hold referrals coming from non-Allscripts sources. |
dbo.InboundOrder_Interface_Auth_DE | Authorization entries which will be verified before filing Inbound Order |
dbo.Industry_DE | Industry list |
dbo.InfoButtonLog | Log information related to Infobutton activity performed by a provider. |
dbo.Injury_Information | Special Billing Details |
dbo.Injury_Type_DE | Injury Type (Special Billing) Dictionary |
dbo.Instruction_Variable_DE | Codes / 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_DE | Codes / 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_DE | Insurance |
dbo.Intervention_ActionTaken | Capture events (or) action taken on various intervention types (AUC, CareGuide, POCR and Normative GrowthChart) |
dbo.Intervention_ActionTaken_Mapper | Related Items for the Intervention on which the actions were taken |
dbo.Intervention_Feedback | Decision Support Intervention (DSI) Feedback |
dbo.Intervention_Feedback_Mapper | Items linked to Decision Support Intervention (DSI) Feedback |
dbo.Intervention_Type_DE | Intervention Types |
dbo.ISO_Language_DE | ISO languages |
dbo.Item_Allergy | Allergy Item Parent |
dbo.Item_Annotation | Item level Annotation |
dbo.Item_Entry_Type_DE | Contains entries that trigger alerts (such as Drug-Drug alerts). Entries in this enforced dictionary include: Medication Change, Allergy, and Medication Renewal. |
dbo.Item_Finding | This 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_Goal | Item Level table for Goals |
dbo.Item_HMP | This is the parent Table to the HMP detail records |
dbo.Item_Immunization | Item Level table for Immunizations |
dbo.Item_Medication | Item Level table for Medications. |
dbo.Item_Plan | Item level table for non-medication orders. |
dbo.Item_Result | Item level table for Results. |
dbo.Item_Site | Associates 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_DE | Item Status Codes asociated with Medications, Allergies, Immunizations, Problems. The ID in this table is FK in Unverified_Item. (Ex. Added, EIE, Veriified, Duplicateetc.) |
dbo.JardogsTaskAttachment | Stores 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_DE | Job Titles |
dbo.Label_Type_DE | Label Type definitions referenced in the OCD_Item, Order_Defaults, OrderPluralCache,Plan_Item, QO_Classification_DE, WPOrder tables |
dbo.Language_DE | Language Dictionary |
dbo.Laterality_Qualifier_DE | Dictionary for laterality. Such as left , right, unilateral etc.. |
dbo.Location_DE | Scheduling Location |
dbo.Location_Type_DE | Dictionary holding the codes / descriptions used to describe the Types of Locations |
dbo.Management_Effective_DE | Dictionary holding the codes / descriptions used to describe the Problem Management Effectiveness (Good Progress, Fair Control, Mildly exacerbated etc.) |
dbo.Mandatory_Level_DE | Dictionary 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_DE | Dictionary holding Marital Statuses. i.e Married, Single, Widowed, Divorced etc. |
dbo.Medical_Necessity_Log | Medical Necessity Checking log |
dbo.MedicalDevice | Medical device instance |
dbo.MedicalDevice_Header | Medical device Header table |
dbo.MedicalDevice_Status_DE | Medical device statuses |
dbo.Medicare_Type_Of_Service_DE | Different type of services provided. Not used. |
dbo.Medication | Medication details |
dbo.Medication_Alert | DUR alerts displayed for prescriptions |
dbo.Medication_Allergy_DE | Medication Allergy Dictionaries |
dbo.Medication_DE | Medications |
dbo.Medication_Fill_History | History of medication fulfillments from a pharmacy. |
dbo.Medication_MedOffer | This table links a specific Medication record to a Medication Offer from dbo.MedOffer |
dbo.Medispan_Symptom_DE | Medispan Symptoms. This table is not part of Delta Upload. Its Stand alone table where data is inserted via Scripts |
dbo.MedOffer | Medication Offer information received from the DXC service |
dbo.MedOffer_Distribution_Type_DE | Medication Offer Distribution types |
dbo.MedOffer_Image | eCoupon images in binary format that are tied to Medication Offer records |
dbo.MedOffer_Output_Method_DE | Output methods (print, send electronically, etc) for medication offer eCoupons, for use in UI combo boxes |
dbo.MedOffer_Type_DE | Types of coupon offers. |
dbo.MedOfferDistribution | This table logs individual distribution events for dbo.Medication_MedOffer records |
dbo.MRISafety_DE | MRI Safety values |
dbo.MVX_DE | Manufacturers of Vaccines (MVX) |
dbo.NAW_ChargeList | Charges associated with a Note |
dbo.No_Immunization_Reason_DE | HL7 Standard reasons an immunization was not given |
dbo.Note_Activity_Text | Legacy (v3) audit note content |
dbo.Note_Correspondence_Letter | Maps the Original Document to the Referral Document and its respective NoteLetterID (1,2,3) |
dbo.Note_Section_DE | Dictionary of Activity types (Sections) available for a v2 Note Template |
dbo.Note_Template_Version | v2 Note template definitions |
dbo.Note_Type_DE | v2 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_Activation | Tracks the beginning of a v11 Note amendment cycle |
dbo.NoteForm_NAW_Audit | v11 Note Audit log |
dbo.NoteForm_NAW_Instance | Child of Instance_Header. (This is where each version of the note body is stored) |
dbo.NoteForm_NAW_Instance_Header | The Parent (Header) of the Child (Detail) which contains the saved V11 note |
dbo.Noteform_NAW_Instance_Header_Security_Code | Restricts user access to an instance of a v11 note |
dbo.NoteForm_NAW_Instance_Output_Map | Associates a v11 note instance to multiple output documents and the template that generated them |
dbo.NoteForm_Section_DE | The 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.NoteformNAWCED | Clinical exchange extract |
dbo.OccMed_Employer_DE | Occupational 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_Guideline | Guidelines for Orderable Concepts and Allscripts delivered Care Guides |
dbo.OCD_Header | Orderable Concept Dictionary Item header |
dbo.OCD_Instruction | Orderable Concept instruction header |
dbo.OCD_Instruction_Lang | Orderable Concept instruction |
dbo.OCD_Item | Orderable Concept Dictionary Item |
dbo.OCD_Version | Orderable Concept Dictionary Version |
dbo.OnHold_Status_DE | Dictionary 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_DE | Simple dictionary for operands used in calculating Patient Goals |
dbo.Order_ABN_Status | Medical Necessity status for an Order |
dbo.Order_Activity | Activity level table for Orders (Medication and Non-Medication orders) |
dbo.Order_Activity_Header | Activity Header table for Medication and Non-Medication orders |
dbo.Order_Appt_Status_DE | Supported statuses of the need for an appointment for an orderable item (Appointment Needed, Appoitment Scheduled, etc.) |
dbo.Order_Document_Mapper | Table for linking documents to orders. |
dbo.Order_Guidelines_Detail | Order guidelines details for Imaging and Diagnostic orders. |
dbo.Order_Item_Charge | Charges for orders |
dbo.Order_Item_Charge_Modifier | CPT4 modifiers in separate rows/records, when Charge codes with 0-5 Modifier are selected after commit of order edit workflow |
dbo.Order_Item_Common | General Order Instance Data |
dbo.Order_Priority_DE | Order Priority values. |
dbo.Order_Reason_DE | Deprecated Referral and Follow-up order reason dictionary. |
dbo.Order_Referral_Mapper | Maps Referrals to Orders |
dbo.Order_Referral_Message_Mapper | Maps each version of a referral order to referral messages |
dbo.Order_Result_Mapper | Maps the Result(s) to the Order at the header level. |
dbo.Order_Result_Review | This table holds the reviewed status of the Order / Result. When an edit happens the Status is set to U |
dbo.Order_Source_DE | Type of methods with which an Order can be recorded in the system |
dbo.Order_Status_DE | Order Statuses |
dbo.Order_Status_Reason_DE | Reasons 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_DE | Ordering Authority Levels |
dbo.Org_Sharing_DE | Organization Sharing Pool. Organizations in the same sharing pool share patient charts. |
dbo.Organization | Organization. |
dbo.Patient_Alert | Patient Alert details from Patient Query |
dbo.Patient_Alert_Deferral | Deferred Patient Alert from Patient Query |
dbo.Patient_Care_Team_DE | Patient care team entries |
dbo.Patient_Case | workers comp case information |
dbo.Patient_Chart_Alert | Chart Alerts displayed in the patient banner |
dbo.Patient_Communication_DE | Patient Communicaiton dictionary |
dbo.Patient_Community | Patient Community Membership |
dbo.Patient_Community_Audit | Audit record of changes ot the Patient_Community table |
dbo.Patient_Consent | Patient consents |
dbo.Patient_Consent_DE | Patient Consent types |
dbo.Patient_Contact | Patient's Contact demographic data (Emergency, Guarantor) |
dbo.Patient_Correspondence | Patient correspondence data |
dbo.Patient_Deceased_Audit | Deceased patients |
dbo.Patient_Directives | Advance Directives associated with the Patient |
dbo.Patient_Education | Patient Education details. |
dbo.Patient_Education_Provided | Audit of when patient education was provided |
dbo.Patient_Family_Unit | Family unit information for the patient (employee) |
dbo.Patient_Family_Unit_Member | Family unit member information |
dbo.Patient_ImmRegistry_Log | Immunization Registry requests per patient |
dbo.Patient_ImmRegistry_Sent_Log | Audit data sent to Immunization Registries |
dbo.Patient_Iorg | Table linking Patients to Organizations. |
dbo.Patient_Iorg_History | History of changes to the Patient_Iorg table |
dbo.Patient_List | Patient List definitions. |
dbo.Patient_List_Entry | Patients on a Patient List |
dbo.Patient_List_Membership | Linkage of Queries to patient lists. |
dbo.Patient_Location | Current Location for a patient. Set from the banner. |
dbo.Patient_Location_DE | Patient Locations |
dbo.Patient_MasterChart | Table 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_Member | Patient Specific Demographic Information |
dbo.Patient_Occupation_DE | Patient Occupations |
dbo.Patient_Occupation_Industry | This 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_Diagnosis | Table containing Patient Past Diagnosis data |
dbo.Patient_PBM | Patient Rx Benefit plan information |
dbo.Patient_Pharmacy_Def | Defau;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_SecGroup | Table containing the Security / Access Group associations for Patients |
dbo.Patient_WLP | Patient Wellpoint Document data |
dbo.Patient_Worklist_Order_Review | Table containing a listing of Orders that need to be Reviewed by a user |
dbo.PatientAccessLog | Audit of patients brought into context. |
dbo.PatientAPIRegistrationStatus | FHIR API Registration Status of Patients |
dbo.PatientCaution | Text for the FYI button in the patient banner |
dbo.PatientCommunication | portal/communication preferences (migrated from person_other) |
dbo.PatientCommunication_Audit | Audit of changes to the PatientCommunication table |
dbo.PatientCommunication_Updates | Patients with manual communication updates |
dbo.PatientOrderStatusReasons | This is a worklist table to help keep tract of what items require some worklist action. |
dbo.PatientPortalUserActivity | Audit of how patients are accessing data on the portal and FIHR activity. |
dbo.PatientPortalUserActivityDetail | An extension of PatientPortalUserActivity table. Use to store relevant items extracted with a CCDA document (Activity Type - K). |
dbo.Payment_Typology_DE | Payment Topology Codes |
dbo.PBM_DE | Rx Benefit plan providers |
dbo.PBM_Override_Reason_DE | PBM Override Reasons |
dbo.PBM_Problem_List | Problem List of a patient as available from PBM |
dbo.Person | Table of primary demopraphics. A person can have one or more roles including patient, user, or provider. |
dbo.Person_Address | Postal Address for a person |
dbo.Person_Address_History | Address History for a person |
dbo.Person_Aliases | Aliases for the Person |
dbo.Person_Multi_Dictionary | Patient attributes , which have multiple entries. View vPersonMultiDictionary will return a unique row per Person |
dbo.Person_Other | Additional demographic information for the Patient, User and providers |
dbo.Person_Phone | This table contains the various telephone numbers associated to Patient, Provider and Users |
dbo.Person_Picture | This table contains a Patient Picture |
dbo.Person_Race | Races for a person (implemented for patients). |
dbo.Person_TribalAffiliation | Tribal Affiliations for a patient |
dbo.Person_XID | This table is a cross reference between external PM systems and Our Person table |
dbo.Pharmacy_DE | Pharmacy 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.Picklist | A subset of a dictionary. Picklists are used as a valid set of choices for a field. |
dbo.PIXEntries | Patient 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_DE | Unused Place Of Injury dictionary |
dbo.Place_of_Service_DE | Unused Place of Service dictionary |
dbo.Plan_Item | Versioned Detail table for non-medication orders. |
dbo.Plan_Item_Instruction_Variable | Mapping 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_Order | Order Comminication and Identifier properties |
dbo.PMP_History | documentation for Prescription Monitoring Program (PMP) Registry consultation |
dbo.PMP_Reason_DE | Prescription Monitoring Program (PMP) registry consult/lack of consult reasons |
dbo.Portal_Registration_Status_DE | Portal registration statuses |
dbo.Post_DE | Job posts |
dbo.Preferred_Pronoun_DE | List of preferred Pronouns for gender |
dbo.Preferred_Pronoun_Standard_DE | Standard Preferred Pronoun LOINC Codes |
dbo.PrescribeAction_DE | Valid methods of communicating the prescription. IE "Call" or "Dispense". |
dbo.PrescriptionLog | Contains the Log of patient Prescriptions and the related provider and prescription information |
dbo.Primary_Insurance | Current Registration Insurance for the patient |
dbo.PRN_DE | PRN (As Needed) reasons |
dbo.Problem | Problem Instance |
dbo.Problem_Activity | Linkage of problems to other clinical items. |
dbo.Problem_Category_DE | Problem Category Dictionary (Simple Dictionary) |
dbo.Problem_ClinicalRelation_Map | Mapping Table between Problem and the clinical relation (Clinical_Relation_DE) for family history problems |
dbo.Problem_DE | Problem Dictionary |
dbo.Problem_EM_Complexity_DE | Problem complexity values which matches the ama verbiage better |
dbo.Problem_Encounter | Problems associated to an Encounter (usually assessments) |
dbo.Problem_Header | Problem Instance Header |
dbo.Problem_ICDCode | Table to Link ICD codes to Problems. |
dbo.Problem_Impression | New 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_Alert | Problem Linkage Alerts |
dbo.Problem_Status_DE | Problem Statuses |
dbo.Problem_Transition | Problem Transition from one problem to another |
dbo.Problem_Type_DE | Problem Type Dictionary (Simple Dictionary) |
dbo.Product_Line_DE | Unused dictionary |
dbo.Program_DE | Unused dictionary |
dbo.Provider | Provider. 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_DE | Dictionary holding the Provider Types. This table is referenced by the Provider table with a FK relationship to the ProviderTypeDE |
dbo.QO_Class_Instruction | This table contains instructions that pertain to orders. It gets populated via the CareGuide installer. |
dbo.QO_Class_Instruction_Lang | Orderable Item Instructions. Used for instruction orders. |
dbo.QO_Classification_DE | Non-Medication Orderable Items |
dbo.QO_DE | Resultable items that could be used for a non-med order |
dbo.QO_Instruction | No Longer Used. |
dbo.QO_Mod_DE | Modifiers for orderable items |
dbo.Query | Patient 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_DE | Dictionary holding Race classifications i.e Hispanic, White, Chinese etc. |
dbo.RCD_Header | Resultable Concept header |
dbo.RCD_Item | Resultable Concept Item |
dbo.Reaction_Severity_DE | Severity values that can be associated to the Reactions. |
dbo.Reconciled_List | data related to the reconciliation of Medication and Allergy Orders including the User ID for the reconciling User |
dbo.Reconciled_List_Item | Data relating the Reconciled_List to the associated individual Orders |
dbo.Recording_Format_DE | Recording format for dictations |
dbo.Reference_Range_Text | Result Reference Ranges |
dbo.Referral_Attachment | Attachments for the Referral Requests and Referral Responses |
dbo.Referral_Document | Referral documents from both requests and responses |
dbo.Referral_Header | Header level table to store referral Request and Response for each Referral Order |
dbo.Referral_Message | Request and Response information for all the Referral Messages |
dbo.Referral_Org_Details | Referral organization name and NPI details |
dbo.Referral_Type_DE | Referral types |
dbo.Referring_Provider_DE | Referring Providers |
dbo.Registry_Refusal_Reason_DE | Registry refusal reasons |
dbo.Registry_Region_DE | Registry Dictionary |
dbo.RegistryHeader | Header table for Registry value sets for Cancer Registry and Health Care Survey |
dbo.Regulatory_Loinc_DE | Regulatory Loinc Dictionary table of special LOINC Codes different than regular LOINC Codes |
dbo.Relationship_DE | Relationships (Father, Mother, etc.) |
dbo.Religion_DE | Religion dictionary |
dbo.Remove_Reason_DE | Remove Reason dictionary. Used with tasks. |
dbo.Req_Perf_Location_DE | Requested Preforming Locations |
dbo.Requisition | Requisition information related to lab orders. |
dbo.Requisition_Status_DE | Statuses for order requisitions |
dbo.Resource_DE | Schedulable resource. This can be a provider or something else such as exam room 1. Entries are generated for scheduleable providers. |
dbo.Result | Versioned detail table for Results |
dbo.Result_Communication_DE | Result Communication Methods |
dbo.Result_External_Storage | Links Image results to their external storage system |
dbo.Result_Flag_DE | Result ABNORMALITY flag values. |
dbo.Result_Status_DE | Result Statuses |
dbo.Result_Text | Long textual results along with result item performing location comments. |
dbo.Route_Of_Admin_DE | Route of Administration dictionary (Oral, Nasal, External, etc.). |
dbo.RX_Authority_DE | Prescribeing Authority dictionary. |
dbo.Rx_Dispense_Transaction | Transaction sent to Inventory Mgmt System when a Medication/Immunization is dispensed |
dbo.Schedule | Data associated with the schedules for Scheduled Orders. |
dbo.Schedule_Dates | List of Scheduled dates associated with a Scheduled Order |
dbo.Schedule_Header | Header records for Scheduled Orders |
dbo.Security_Code_DE | List of Security Codes |
dbo.SensitiveHealth_Manual | Patients those who are manually flagged as Potentially sensitive health patients |
dbo.Service_DE | Services. Not currently used. |
dbo.Service_Location_DE | Standard 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_Comment | Occupational Medicine Service Package Comments |
dbo.Service_Package_Comment_Acknowledgements | Occupational Medicine Service Package Note Acknowledgements |
dbo.Service_Package_Component | Occupational Medicine Service Package Component (Orderable Item). |
dbo.Service_Transaction_Type_DE | Service transaction type dictionary |
dbo.Services_Transaction_Request | Request data for PDMP, PPT+, eCoupon |
dbo.Services_Transaction_Response | Key To the Services_Transaction_Response table |
dbo.Sex_DE | Gender |
dbo.Sexual_Orientation_DE | Sexual Orientation values |
dbo.Sexual_Orientation_Standard_DE | Standard Codes for Sexual Orientation |
dbo.Signature_Authority_DE | Signature Authority Dictionary |
dbo.Signature_Purpose_DE | Signature Purpose Dictionary |
dbo.Site_DE | The Site dictionary is a generic dictionary that is used to identify clinics where providers practice within a larger organization. |
dbo.Site_Location_DE | Potential 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_DE | Source dictionary (Spine, Sweat, Plasma, etc.) |
dbo.Specialty_DE | Specialty dictionary. (Family Medicine, Dermatology, etc.) |
dbo.Specimen | Specimen |
dbo.Specimen_Temperature_DE | Specimen Temperature (Ambient, Frozen, Refrigerated) |
dbo.Specimen_Type_DE | Specimen Type (Blood, Urine, etc.) |
dbo.SubOrder_Type_DE | Sub Order Type dictionary |
dbo.Syndromic_Registry_Region_DE | Symdromic registries |
dbo.Task_Priority_DE | Task Priority Dictionary |
dbo.Task_Read_Detail | Task read information for an user and task combination. |
dbo.Team_DE | Teams associated to Tasks |
dbo.Telephone_Type_DE | Telephone Type (Mobile, Work, Evening, Day etc.) |
dbo.Time_Zone | List of Time Zones |
dbo.Tooth_Surface_Code_DE | Dictionary holding the codes / descriptions used to describe the different Tooth Surfaces i.e (Mesial, Facial, Lingial etc.) |
dbo.Tribal_Affiliation_DE | Dictionary of Tribal Affiliations |
dbo.UAIEncounterChartItem | mimics encounter_chart_item for work done in TW Mobile during a session. |
dbo.Unfinished_Call | Unfinished call information |
dbo.Unit_Code_DE | Units dictionary (Once, Pound, Millimeter, etc.) |
dbo.Unverified_Item | Unverified clinical items |
dbo.Unverified_Item_Type_DE | Types of Unverified Items (Active Allergy, Active Problem, etc.) |
dbo.UnverifiedItem_Allergy | Unverfied Allergy |
dbo.UnverifiedItem_Immunization | Immunizations imported via external sources |
dbo.UnverifiedItem_Medication | Medications imported via External sources. |
dbo.UnverifiedItem_Problem | Unverified Probem |
dbo.Vaccine_Category_DE | Vaccine Category Definitions |
dbo.Vaccine_Manufacturer_DE | Vaccine Manufacturer Definitions |
dbo.Vendor_DE | Vendors |
dbo.Vendor_Item | Medcin Findings patient data |
dbo.Vendor_Item_Extension | Extension type/value tied to the Vendor_Item table |
dbo.VIP_Type_DE | VIP (very Important Person) Types associated to a person i.e Celebrity, Clergy etc. |
dbo.Visit | Visit. A visit is the parent of an encounter. |
dbo.Visit_AttendingProvider | Table to contain multiple Attending Providers associated to the Visit |
dbo.Visit_ConsultingProvider | Table to contain multiple Consulting Providers associated to the Visit |
dbo.Visit_Detail | Table containing dates and providers associated with the Visit |
dbo.Visit_Insurance | Insurance data asociated with the Patient for the Visit. |
dbo.Visit_Status_DE | Visit Status i.e Admitted, Canceled, Discharged etc. |
dbo.Visit_Type_DE | Visit Types associated to a Patient Visit i.e Inpatient, Office Outpatient etc. |
dbo.When_To_Charge_DE | When To Charge codes associated to Order Charges i.e Never, On Order, When Resulted etc. |
dbo.Where_Performed_DE | Where Performed dictionary. These are for orders. |
dbo.Workflow_Type_DE | Workflow Type dictionary. Used in the document interface (Electronic Signature, Electronic Verification, Non Electronic) |