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