1223_emr

Tables (50)

addresses

  • id — int(11) — Primary key — NOT NULL
  • line1 — varchar(255)
  • line2 — varchar(255)
  • city — varchar(255)
  • state — varchar(35)
  • zip — varchar(10)
  • plus_four — varchar(4)
  • country — varchar(255)
  • foreign_id — int(11)
  • district — varchar(255) — The county or district of the address

amc_misc_data

  • amc_id — varchar(31) — NOT NULL — Unique and maps to list_options list clinical_rules
  • pid — bigint(20)
  • map_category — varchar(255) — NOT NULL — Maps to an object category (such as prescriptions etc.)
  • map_id — bigint(20) — NOT NULL — Maps to an object id (such as prescription id etc.)
  • date_created — datetime
  • date_completed — datetime
  • soc_provided — datetime

amendments

  • amendment_id — int(11) — Primary key — NOT NULL — Amendment ID
  • amendment_date — date — NOT NULL — Amendement request date
  • amendment_by — varchar(50) — NOT NULL — Amendment requested from
  • amendment_status — varchar(50) — Amendment status accepted/rejected/null
  • pid — bigint(20) — NOT NULL — Patient ID from patient_data
  • amendment_desc — text — Amendment Details
  • created_by — int(11) — NOT NULL — references users.id for session owner
  • modified_by — int(11) — references users.id for session owner
  • created_time — timestamp — created time
  • modified_time — timestamp — modified time

amendments_history

  • amendment_id — int(11) — NOT NULL — Amendment ID
  • amendment_note — text — Amendment requested from
  • amendment_status — varchar(50) — Amendment Request Status
  • created_by — int(11) — NOT NULL — references users.id for session owner
  • created_time — timestamp — created time

api_log

  • id — bigint(20) — Primary key — NOT NULL
  • log_id — int(11) — NOT NULL
  • user_id — bigint(20) — NOT NULL
  • patient_id — bigint(20) — NOT NULL
  • ip_address — varchar(255) — NOT NULL
  • method — varchar(20) — NOT NULL
  • request — varchar(255) — NOT NULL
  • request_url — text
  • request_body — longtext
  • response — longtext
  • created_time — timestamp

api_refresh_token

  • id — bigint(20) — Primary key — NOT NULL
  • user_id — varchar(40)
  • client_id — varchar(80)
  • token — varchar(128) — NOT NULL
  • expiry — datetime
  • revoked — tinyint(1) — NOT NULL — 1=revoked,0=not revoked

api_token

  • id — bigint(20) — Primary key — NOT NULL
  • user_id — varchar(40)
  • token — varchar(128)
  • expiry — datetime
  • client_id — varchar(80)
  • scope — text — json encoded
  • revoked — tinyint(1) — NOT NULL — 1=revoked,0=not revoked
  • context — text — context values that change/govern how access token are used

ar_activity

  • pid — int(11) — Primary key — NOT NULL
  • encounter — int(11) — Primary key — NOT NULL
  • sequence_no — int(10) — Primary key — NOT NULL — Ar_activity sequence_no, incremented in code
  • code_type — varchar(12) — NOT NULL
  • code — varchar(20) — NOT NULL — empty means claim level
  • modifier — varchar(12) — NOT NULL
  • payer_type — int(11) — NOT NULL — 0=pt, 1=ins1, 2=ins2, etc
  • post_time — datetime — NOT NULL
  • post_user — int(11) — NOT NULL — references users.id
  • session_id — int(10) — NOT NULL — references ar_session.session_id
  • memo — varchar(255) — NOT NULL — adjustment reasons go here
  • pay_amount — decimal(12, 2) — NOT NULL — either pay or adj will always be 0
  • adj_amount — decimal(12, 2) — NOT NULL
  • modified_time — datetime — NOT NULL
  • follow_up — char(1) — NOT NULL
  • follow_up_note — text
  • account_code — varchar(15) — NOT NULL
  • reason_code — varchar(255) — Use as needed to show the primary payer adjustment reason code
  • deleted — datetime — NULL if active, otherwise when voided
  • post_date — date — Posting date if specified at payment time
  • payer_claim_number — varchar(30)

ar_session

  • session_id — int(10) — Primary key — NOT NULL
  • payer_id — int(11) — NOT NULL — 0=pt else references insurance_companies.id
  • user_id — int(11) — NOT NULL — references users.id for session owner
  • closed — tinyint(1) — NOT NULL — 0=no, 1=yes
  • reference — varchar(255) — NOT NULL — check or EOB number
  • check_date — date
  • deposit_date — date
  • pay_total — decimal(12, 2) — NOT NULL
  • created_time — timestamp — NOT NULL
  • modified_time — datetime — NOT NULL
  • global_amount — decimal(12, 2) — NOT NULL
  • payment_type — varchar(50) — NOT NULL
  • description — text
  • adjustment_code — varchar(50) — NOT NULL
  • post_to_date — date — NOT NULL
  • patient_id — bigint(20) — NOT NULL
  • payment_method — varchar(25) — NOT NULL

audit_details

  • id — bigint(20) — Primary key — NOT NULL
  • table_name — varchar(100) — NOT NULL — openemr table name
  • field_name — varchar(100) — NOT NULL — openemr table's field name
  • field_value — longtext — openemr table's field value
  • audit_master_id — bigint(20) — NOT NULL — Id of the audit_master table
  • entry_identification — varchar(255) — NOT NULL — Used when multiple entry occurs from the same table.1 means no multiple entry

audit_master

  • id — bigint(20) — Primary key — NOT NULL
  • pid — bigint(20) — NOT NULL
  • user_id — bigint(20) — NOT NULL — The Id of the user who approves or denies
  • approval_status — tinyint(4) — NOT NULL — 1-Pending,2-Approved,3-Denied,4-Appointment directly updated to calendar table,5-Cancelled appointment
  • comments — text
  • created_time — timestamp — NOT NULL
  • modified_time — datetime — NOT NULL
  • ip_address — varchar(100) — NOT NULL
  • type — tinyint(4) — NOT NULL — 1-new patient,2-existing patient,3-change is only in the document,4-Patient upload,5-random key,10-Appointment
  • is_qrda_document — tinyint(1)
  • is_unstructured_document — tinyint(1)

automatic_notification

  • notification_id — int(5) — Primary key — NOT NULL
  • sms_gateway_type — varchar(255) — NOT NULL
  • provider_name — varchar(100) — NOT NULL
  • message — text
  • email_sender — varchar(100) — NOT NULL
  • email_subject — varchar(100) — NOT NULL
  • type — enum('SMS','Email') — NOT NULL

background_services

  • name — varchar(31) — Primary key — NOT NULL
  • title — varchar(127) — NOT NULL — name for reports
  • active — tinyint(1) — NOT NULL
  • running — tinyint(1) — NOT NULL — True indicates managed service is busy. Skip this interval
  • next_run — timestamp — NOT NULL
  • execute_interval — int(11) — NOT NULL — minimum number of minutes between function calls,0=manual mode
  • function — varchar(127) — NOT NULL — name of background service function
  • require_once — varchar(255) — include file (if necessary)
  • sort_order — int(11) — NOT NULL — lower numbers will be run first

batchcom

  • id — bigint(20) — Primary key — NOT NULL
  • patient_id — bigint(20) — NOT NULL
  • sent_by — bigint(20) — NOT NULL
  • msg_type — varchar(60)
  • msg_subject — varchar(255)
  • msg_text — mediumtext
  • msg_date_sent — datetime

benefit_eligibility

  • response_id — bigint(20) — NOT NULL
  • verification_id — bigint(20) — NOT NULL
  • type — varchar(4)
  • benefit_type — varchar(255)
  • start_date — date
  • end_date — date
  • coverage_level — varchar(255)
  • coverage_type — varchar(512)
  • plan_type — varchar(255)
  • plan_description — varchar(255)
  • coverage_period — varchar(255)
  • amount — decimal(5,2)
  • percent — decimal(3,2)
  • network_ind — varchar(2)
  • message — varchar(512)
  • response_status — enum('A','D')
  • response_create_date — date
  • response_modify_date — date

billing

  • id — int(11) — Primary key — NOT NULL
  • date — datetime
  • code_type — varchar(15)
  • code — varchar(20)
  • pid — bigint(20)
  • provider_id — int(11)
  • user — int(11)
  • groupname — varchar(255)
  • authorized — tinyint(1)
  • encounter — int(11)
  • code_text — longtext
  • billed — tinyint(1)
  • activity — tinyint(1)
  • payer_id — int(11)
  • bill_process — tinyint(2) — NOT NULL
  • bill_date — datetime
  • process_date — datetime
  • process_file — varchar(255)
  • modifier — varchar(12)
  • units — int(11)
  • fee — decimal(12, 2)
  • justify — varchar(255)
  • target — varchar(30)
  • x12_partner_id — int(11)
  • ndc_info — varchar(255)
  • notecodes — varchar(25) — NOT NULL
  • external_id — varchar(20)
  • pricelevel — varchar(31)
  • revenue_code — varchar(6) — NOT NULL — Item revenue code
  • chargecat — varchar(31) — Charge category or customer

calendar_external

  • id — int(11) — Primary key — NOT NULL
  • date — date — NOT NULL
  • description — varchar(45) — NOT NULL
  • source — varchar(45)

categories

  • id — int(11) — Primary key — NOT NULL
  • name — varchar(255)
  • value — varchar(255)
  • parent — int(11) — NOT NULL
  • lft — int(11) — NOT NULL
  • rght — int(11) — NOT NULL
  • aco_spec — varchar(63) — NOT NULL
  • codes — varchar(255) — NOT NULL — Category codes for documents stored in this category

categories_seq

  • id — int(11) — Primary key — NOT NULL

categories_to_documents

  • category_id — int(11) — Primary key — NOT NULL
  • document_id — int(11) — Primary key — NOT NULL

ccda

  • id — int(11) — Primary key — NOT NULL
  • uuid — binary(16)
  • pid — bigint(20)
  • encounter — bigint(20)
  • ccda_data — longtext
  • time — varchar(50)
  • status — smallint(6)
  • updated_date — timestamp — NOT NULL
  • user_id — varchar(50)
  • couch_docid — varchar(100)
  • couch_revid — varchar(100)
  • hash — varchar(255)
  • view — tinyint(4) — NOT NULL
  • transfer — tinyint(4) — NOT NULL
  • emr_transfer — tinyint(4) — NOT NULL
  • encrypted — tinyint(4) — NOT NULL — 0->No,1->Yes
  • transaction_id — bigint(20) — fk to transaction referral record

ccda_components

  • ccda_components_id — int(11) — Primary key — NOT NULL
  • ccda_components_field — varchar(100)
  • ccda_components_name — varchar(100)
  • ccda_type — int(11) — NOT NULL — 0=>sections,1=>components

ccda_field_mapping

  • id — int(11) — Primary key — NOT NULL
  • table_id — int(11)
  • ccda_field — varchar(100)

ccda_sections

  • ccda_sections_id — int(11) — Primary key — NOT NULL
  • ccda_components_id — int(11)
  • ccda_sections_field — varchar(100)
  • ccda_sections_name — varchar(100)
  • ccda_sections_req_mapping — tinyint(4) — NOT NULL

ccda_table_mapping

  • id — int(11) — Primary key — NOT NULL
  • ccda_component — varchar(100)
  • ccda_component_section — varchar(100)
  • form_dir — varchar(100)
  • form_type — smallint(6)
  • form_table — varchar(100)
  • user_id — int(11)
  • deleted — tinyint(4) — NOT NULL
  • timestamp — timestamp — NOT NULL

chart_tracker

  • ct_pid — int(11) — Primary key — NOT NULL
  • ct_when — datetime — Primary key — NOT NULL
  • ct_userid — bigint(20) — NOT NULL
  • ct_location — varchar(31) — NOT NULL

claims

  • patient_id — bigint(20) — Primary key — NOT NULL
  • encounter_id — int(11) — Primary key — NOT NULL
  • version — int(10) — Primary key — NOT NULL — Claim version, incremented in code
  • payer_id — int(11) — NOT NULL
  • status — tinyint(2) — NOT NULL
  • payer_type — tinyint(4) — NOT NULL
  • bill_process — tinyint(2) — NOT NULL
  • bill_time — datetime
  • process_time — datetime
  • process_file — varchar(255)
  • target — varchar(30)
  • x12_partner_id — int(11) — NOT NULL
  • submitted_claim — text — This claims form claim data

clinical_plans

  • id — varchar(31) — Primary key — NOT NULL — Unique and maps to list_options list clinical_plans
  • pid — bigint(20) — Primary key — NOT NULL — 0 is default for all patients, while > 0 is id from patient_data table
  • normal_flag — tinyint(1) — Normal Activation Flag
  • cqm_flag — tinyint(1) — Clinical Quality Measure flag (unable to customize per patient)
  • cqm_2011_flag — tinyint(1) — 2011 Clinical Quality Measure flag (unable to customize per patient)
  • cqm_2014_flag — tinyint(1) — 2014 Clinical Quality Measure flag (unable to customize per patient)
  • cqm_measure_group — varchar(10) — NOT NULL — Clinical Quality Measure Group Identifier

clinical_plans_rules

  • plan_id — varchar(31) — Primary key — NOT NULL — Unique and maps to list_options list clinical_plans
  • rule_id — varchar(31) — Primary key — NOT NULL — Unique and maps to list_options list clinical_rules

clinical_rules

  • id — varchar(31) — Primary key — NOT NULL — Unique and maps to list_options list clinical_rules
  • pid — bigint(20) — Primary key — NOT NULL — 0 is default for all patients, while > 0 is id from patient_data table
  • active_alert_flag — tinyint(1) — Active Alert Widget Module flag - note not yet utilized
  • passive_alert_flag — tinyint(1) — Passive Alert Widget Module flag
  • cqm_flag — tinyint(1) — Clinical Quality Measure flag (unable to customize per patient)
  • cqm_2011_flag — tinyint(1) — 2011 Clinical Quality Measure flag (unable to customize per patient)
  • cqm_2014_flag — tinyint(1) — 2014 Clinical Quality Measure flag (unable to customize per patient)
  • cqm_nqf_code — varchar(10) — NOT NULL — Clinical Quality Measure NQF identifier
  • cqm_pqri_code — varchar(10) — NOT NULL — Clinical Quality Measure PQRI identifier
  • amc_flag — tinyint(1) — Automated Measure Calculation flag (unable to customize per patient)
  • amc_2011_flag — tinyint(1) — 2011 Automated Measure Calculation flag for (unable to customize per patient)
  • amc_2014_flag — tinyint(1) — 2014 Automated Measure Calculation flag for (unable to customize per patient)
  • amc_2015_flag — tinyint(1) — 2015 Automated Measure Calculation flag for (unable to customize per patient)
  • amc_code — varchar(10) — NOT NULL — Automated Measure Calculation identifier (MU rule)
  • amc_code_2014 — varchar(30) — NOT NULL — Automated Measure Calculation 2014 identifier (MU rule)
  • amc_code_2015 — varchar(30) — NOT NULL — Automated Measure Calculation 2014 identifier (MU rule)
  • amc_2014_stage1_flag — tinyint(1) — 2014 Stage 1 - Automated Measure Calculation flag for (unable to customize per patient)
  • amc_2014_stage2_flag — tinyint(1) — 2014 Stage 2 - Automated Measure Calculation flag for (unable to customize per patient)
  • patient_reminder_flag — tinyint(1) — Clinical Reminder Module flag
  • bibliographic_citation — varchar(255) — NOT NULL
  • developer — varchar(255) — NOT NULL — Clinical Rule Developer
  • funding_source — varchar(255) — NOT NULL — Clinical Rule Funding Source
  • release_version — varchar(255) — NOT NULL — Clinical Rule Release Version
  • web_reference — varchar(255) — NOT NULL — Clinical Rule Web Reference
  • linked_referential_cds — varchar(50) — NOT NULL
  • access_control — varchar(255) — NOT NULL — ACO link for access control
  • patient_dob_usage — text — Description of how patient DOB is used by this rule
  • patient_ethnicity_usage — text — Description of how patient ethnicity is used by this rule
  • patient_health_status_usage — text — Description of how patient health status assessments are used by this rule
  • patient_gender_identity_usage — text — Description of how patient gender identity information is used by this rule
  • patient_language_usage — text — Description of how patient language information is used by this rule
  • patient_race_usage — text — Description of how patient race information is used by this rule
  • patient_sex_usage — text — Description of how patient birth sex information is used by this rule
  • patient_sexual_orientation_usage — text — Description of how patient sexual orientation is used by this rule
  • patient_sodh_usage — text — Description of how patient social determinants of health are used by this rule

clinical_rules_log

  • id — bigint(20) — Primary key — NOT NULL
  • date — datetime
  • pid — bigint(20) — NOT NULL
  • uid — bigint(20) — NOT NULL
  • category — varchar(255) — NOT NULL — An example category is clinical_reminder_widget
  • value — text
  • new_value — text
  • facility_id — int(11) — facility where the rule was executed, 0 if unknown

code_types

  • ct_key — varchar(15) — Primary key — NOT NULL — short alphanumeric name
  • ct_id — int(11) — NOT NULL — numeric identifier
  • ct_seq — int(11) — NOT NULL — sort order
  • ct_mod — int(11) — NOT NULL — length of modifier field
  • ct_just — varchar(15) — NOT NULL — ct_key of justify type, if any
  • ct_mask — varchar(9) — NOT NULL — formatting mask for code values
  • ct_fee — tinyint(1) — NOT NULL — 1 if fees are used
  • ct_rel — tinyint(1) — NOT NULL — 1 if can relate to other code types
  • ct_nofs — tinyint(1) — NOT NULL — 1 if to be hidden in the fee sheet
  • ct_diag — tinyint(1) — NOT NULL — 1 if this is a diagnosis type
  • ct_active — tinyint(1) — NOT NULL — 1 if this is active
  • ct_label — varchar(31) — NOT NULL — label of this code type
  • ct_external — tinyint(1) — NOT NULL — 0 if stored codes in codes tables, 1 or greater if codes stored in external tables
  • ct_claim — tinyint(1) — NOT NULL — 1 if this is used in claims
  • ct_proc — tinyint(1) — NOT NULL — 1 if this is a procedure type
  • ct_term — tinyint(1) — NOT NULL — 1 if this is a clinical term
  • ct_problem — tinyint(1) — NOT NULL — 1 if this code type is used as a medical problem
  • ct_drug — tinyint(1) — NOT NULL — 1 if this code type is used as a medication

codes

  • id — int(11) — Primary key — NOT NULL
  • code_text — text
  • code_text_short — text
  • code — varchar(25) — NOT NULL
  • code_type — smallint(6)
  • modifier — varchar(12) — NOT NULL
  • units — int(11)
  • fee — decimal(12, 2)
  • superbill — varchar(31) — NOT NULL
  • related_code — varchar(255) — NOT NULL
  • taxrates — varchar(255) — NOT NULL
  • cyp_factor — float — NOT NULL — quantity representing a years supply
  • active — tinyint(1) — 0 = inactive, 1 = active
  • reportable — tinyint(1) — 0 = non-reportable, 1 = reportable
  • financial_reporting — tinyint(1) — 0 = negative, 1 = considered important code in financial reporting
  • revenue_code — varchar(6) — NOT NULL — Item revenue code

codes_history

  • log_id — bigint(20) — Primary key — NOT NULL
  • date — datetime
  • code — varchar(25)
  • modifier — varchar(12)
  • active — tinyint(1)
  • diagnosis_reporting — tinyint(1)
  • financial_reporting — tinyint(1)
  • category — varchar(255)
  • code_type_name — varchar(255)
  • code_text — text
  • code_text_short — text
  • prices — text
  • action_type — varchar(25)
  • update_by — varchar(255)

contact

  • id — bigint(20) — Primary key — NOT NULL
  • foreign_table_name — varchar(255) — NOT NULL
  • foreign_id — bigint(20) — NOT NULL

contact_address

  • id — bigint(20) — Primary key — NOT NULL
  • contact_id — bigint(20) — NOT NULL
  • address_id — bigint(20) — NOT NULL
  • priority — int(11)
  • type — varchar(255) — FK to list_options.option_id for list_id address-types
  • use — varchar(255) — FK to list_options.option_id for list_id address-uses
  • notes — tinytext
  • status — char(1) — A=active,I=inactive
  • is_primary — char(1) — Y=yes,N=no
  • created_date — datetime — NOT NULL
  • period_start — datetime — Date the address became active
  • period_end — datetime — Date the address became deactivated
  • inactivated_reason — varchar(45) — Values: Moved, Mail Returned, etc

customlists

  • cl_list_slno — int(10) — Primary key — NOT NULL
  • cl_list_id — int(10) — NOT NULL — ID OF THE lIST FOR NEW TAKE SELECT MAX(cl_list_id)+1
  • cl_list_item_id — int(10) — ID OF THE lIST FOR NEW TAKE SELECT MAX(cl_list_item_id)+1
  • cl_list_type — int(10) — NOT NULL — 0=>List Name 1=>list items 2=>Context 3=>Template 4=>Sentence 5=> SavedTemplate 6=>CustomButton
  • cl_list_item_short — varchar(10)
  • cl_list_item_long — text
  • cl_list_item_level — int(11) — Flow level for List Designation
  • cl_order — int(11)
  • cl_deleted — tinyint(1)
  • cl_creator — int(11)

dated_reminders

  • dr_id — int(11) — Primary key — NOT NULL
  • dr_from_ID — int(11) — NOT NULL
  • dr_message_text — varchar(160) — NOT NULL
  • dr_message_sent_date — datetime — NOT NULL
  • dr_message_due_date — date — NOT NULL
  • pid — bigint(20) — NOT NULL
  • message_priority — tinyint(1) — NOT NULL
  • message_processed — tinyint(1) — NOT NULL
  • processed_date — timestamp
  • dr_processed_by — int(11) — NOT NULL

dated_reminders_link

  • dr_link_id — int(11) — Primary key — NOT NULL
  • dr_id — int(11) — NOT NULL
  • to_id — int(11) — NOT NULL

direct_message_log

  • id — bigint(20) — Primary key — NOT NULL
  • msg_type — char(1) — NOT NULL — S=sent,R=received
  • msg_id — varchar(127) — NOT NULL
  • sender — varchar(255) — NOT NULL
  • recipient — varchar(255) — NOT NULL
  • create_ts — timestamp — NOT NULL
  • status — char(1) — NOT NULL — Q=queued,D=dispatched,R=received,F=failed
  • status_info — varchar(511)
  • status_ts — timestamp
  • patient_id — bigint(20)
  • user_id — bigint(20)

document_template_profiles

  • id — bigint(21) — Primary key — NOT NULL
  • template_id — bigint(21) — NOT NULL
  • profile — varchar(64) — NOT NULL
  • template_name — varchar(255) — NOT NULL
  • category — varchar(64) — NOT NULL
  • provider — int(11)
  • modified_date — datetime — NOT NULL
  • member_of — varchar(64) — NOT NULL
  • active — tinyint(1) — NOT NULL
  • recurring — tinyint(1) — NOT NULL
  • event_trigger — varchar(31) — NOT NULL
  • period — int(4) — NOT NULL
  • notify_trigger — varchar(31) — NOT NULL
  • notify_period — int(4) — NOT NULL

document_templates

  • id — bigint(21) — Primary key — NOT NULL
  • pid — bigint(20)
  • provider — int(11)
  • encounter — int(11)
  • modified_date — datetime — NOT NULL
  • profile — varchar(63) — NOT NULL
  • category — varchar(63) — NOT NULL
  • location — varchar(255)
  • template_name — varchar(255)
  • status — varchar(31)
  • send_date — datetime — NOT NULL
  • end_date — datetime
  • size — int(11) — NOT NULL
  • template_content — mediumblob
  • mime — varchar(31)

documents

  • id — int(11) — Primary key — NOT NULL
  • uuid — binary(16)
  • type — enum('file_url', 'blob', 'web_url')
  • size — int(11)
  • date — datetime
  • date_expires — datetime
  • url — varchar(255)
  • thumb_url — varchar(255)
  • mimetype — varchar(255)
  • pages — int(11)
  • owner — int(11)
  • revision — timestamp — NOT NULL
  • foreign_id — bigint(20)
  • docdate — date
  • hash — varchar(255)
  • list_id — bigint(20) — NOT NULL
  • name — varchar(255)
  • drive_uuid — binary(16)
  • couch_docid — varchar(100)
  • couch_revid — varchar(100)
  • storagemethod — tinyint(4) — NOT NULL — 0->Harddisk,1->CouchDB
  • path_depth — tinyint(4) — Depth of path to use in url to find document. Not applicable for CouchDB.
  • imported — tinyint(4) — Parsing status for CCR/CCD/CCDA importing
  • encounter_id — bigint(20) — NOT NULL — Encounter id if tagged
  • encounter_check — tinyint(1) — NOT NULL — If encounter is created while tagging
  • audit_master_approval_status — tinyint(4) — NOT NULL — approval_status from audit_master table
  • audit_master_id — int(11)
  • documentationOf — varchar(255)
  • encrypted — tinyint(4) — NOT NULL — 0->No,1->Yes
  • document_data — mediumtext
  • deleted — tinyint(1) — NOT NULL
  • foreign_reference_id — bigint(20)
  • foreign_reference_table — varchar(40)

documents_legal_categories

  • dlc_id — int(10) — Primary key — NOT NULL
  • dlc_category_type — int(10) — NOT NULL — 1 category 2 subcategory
  • dlc_category_name — varchar(45) — NOT NULL
  • dlc_category_parent — int(10)

documents_legal_detail

  • dld_id — int(10) — Primary key — NOT NULL
  • dld_pid — int(10)
  • dld_facility — int(10)
  • dld_provider — int(10)
  • dld_encounter — int(10)
  • dld_master_docid — int(10) — NOT NULL
  • dld_signed — smallint(5) — NOT NULL — 0-Not Signed or Cannot Sign(Layout),1-Signed,2-Ready to sign,3-Denied(Pat Regi),4-Patient Upload,10-Save(Layout)
  • dld_signed_time — timestamp — NOT NULL
  • dld_filepath — varchar(75)
  • dld_filename — varchar(45) — NOT NULL
  • dld_signing_person — varchar(50) — NOT NULL
  • dld_sign_level — int(11) — NOT NULL — Sign flow level
  • dld_content — varchar(50) — NOT NULL — Layout sign position
  • dld_file_for_pdf_generation — blob — NOT NULL — The filled details in the fdf file is stored here.Patient Registration Screen
  • dld_denial_reason — longtext
  • dld_moved — tinyint(4) — NOT NULL
  • dld_patient_comments — text — Patient comments stored here

documents_legal_master

  • dlm_document_id — int(10) — Primary key — NOT NULL
  • dlm_category — int(10)
  • dlm_subcategory — int(10)
  • dlm_document_name — varchar(75) — NOT NULL
  • dlm_filepath — varchar(75) — NOT NULL
  • dlm_facility — int(10)
  • dlm_provider — int(10)
  • dlm_sign_height — double — NOT NULL
  • dlm_sign_width — double — NOT NULL
  • dlm_filename — varchar(45) — NOT NULL
  • dlm_effective_date — datetime — NOT NULL
  • dlm_version — int(10) — NOT NULL
  • content — varchar(255) — NOT NULL
  • dlm_savedsign — varchar(255) — 0-Yes 1-No
  • dlm_review — varchar(255) — 0-Yes 1-No
  • dlm_upload_type — tinyint(4) — 0-Provider Uploaded,1-Patient Uploaded

drug_inventory

  • inventory_id — int(11) — Primary key — NOT NULL
  • drug_id — int(11) — NOT NULL
  • lot_number — varchar(20)
  • expiration — date
  • manufacturer — varchar(255)
  • on_hand — int(11) — NOT NULL
  • warehouse_id — varchar(31) — NOT NULL
  • vendor_id — bigint(20) — NOT NULL
  • last_notify — date
  • destroy_date — date
  • destroy_method — varchar(255)
  • destroy_witness — varchar(255)
  • destroy_notes — varchar(255)

drug_sales

  • sale_id — int(11) — Primary key — NOT NULL
  • drug_id — int(11) — NOT NULL
  • inventory_id — int(11) — NOT NULL
  • prescription_id — int(11) — NOT NULL
  • pid — bigint(20) — NOT NULL
  • encounter — int(11) — NOT NULL
  • user — varchar(255)
  • sale_date — date — NOT NULL
  • quantity — int(11) — NOT NULL
  • fee — decimal(12, 2) — NOT NULL
  • billed — tinyint(1) — NOT NULL — indicates if the sale is posted to accounting
  • xfer_inventory_id — int(11) — NOT NULL
  • distributor_id — bigint(20) — NOT NULL — references users.id
  • notes — varchar(255) — NOT NULL
  • bill_date — datetime
  • pricelevel — varchar(31)
  • selector — varchar(255) — references drug_templates.selector
  • trans_type — tinyint(4) — NOT NULL — 1=sale, 2=purchase, 3=return, 4=transfer, 5=adjustment
  • chargecat — varchar(31)

drug_templates

  • drug_id — int(11) — Primary key — NOT NULL
  • selector — varchar(255) — Primary key — NOT NULL
  • dosage — varchar(10)
  • period — int(11) — NOT NULL
  • quantity — int(11) — NOT NULL
  • refills — int(11) — NOT NULL
  • taxrates — varchar(255)
  • pkgqty — float — NOT NULL — Number of product items per template item

drugs

  • drug_id — int(11) — Primary key — NOT NULL
  • uuid — binary(16)
  • name — varchar(255) — NOT NULL
  • ndc_number — varchar(20) — NOT NULL
  • on_order — int(11) — NOT NULL
  • reorder_point — float — NOT NULL
  • max_level — float — NOT NULL
  • last_notify — date
  • reactions — text
  • form — varchar(31) — NOT NULL
  • size — varchar(25) — NOT NULL
  • unit — varchar(31) — NOT NULL
  • route — varchar(31) — NOT NULL
  • substitute — int(11) — NOT NULL
  • related_code — varchar(255) — NOT NULL — may reference a related codes.code
  • cyp_factor — float — NOT NULL — quantity representing a years supply
  • active — tinyint(1) — 0 = inactive, 1 = active
  • allow_combining — tinyint(1) — NOT NULL — 1 = allow filling an order from multiple lots
  • allow_multiple — tinyint(1) — NOT NULL — 1 = allow multiple lots at one warehouse
  • drug_code — varchar(25)
  • consumable — tinyint(1) — NOT NULL — 1 = will not show on the fee sheet
  • dispensable — tinyint(1) — NOT NULL — 0 = pharmacy elsewhere, 1 = dispensed here
  • date_created — datetime — NOT NULL
  • last_updated — datetime — NOT NULL