Preferences

This table provides information about each preference found in Open Dental. There are over 1,000 entries in this table, so it is recommended to use CTRL-F and to use keywords to quickly find the preference you are looking for.

Name UI Text Summary
(This information comes from our internal C# documentation. Some of it may be confusing or outdated.)		 Details
NotApplicable ONLY USED FOR PREF-BOUND UI ELEMENTS or as temporary in memory place holder. Never in the DB.
AccountingCashIncomeAccount Show Payment Tracking column in the Edit Claim/Payment windows
AccountingCashPaymentType The default cash payment type used to determine the CashSumTotal for deposit slips.
AccountingDepositAccounts
AccountingIncomeAccount
AccountingInvoiceAttachmentsSaveInDatabase Save accounting invoice attachments in database Boolean, true by defualt. When true, accounting invoice attachments are saved in the database. otherwise, attachments are saved to the originating folder on the local computer only
AccountingLockDate
AccountingSoftware Enum:AccountingSoftware 0=OpenDental, 1=QuickBooks, 2=QuickBooksOnline
AccountAllowFutureDebits Allow future dated patient payments Boolean, false by default to preserve old functionality. Allows users to make future dated patient payments when turned on.
AccountShowCompletedPaymentPlans Defaulted to off, determines whether completed payment plans are visible in the account module.
AccountShowPaymentNums Show payment numbers in Account Module in the payment description, useful for foreign offices
AccountShowQuestionnaire Deprecated in Version 20.4.0. It used to show questionnaire button in account module toolbar. Feature had been obsolete for over 10 years and could only be accessed by users that had this preference turned on prior to its removal from the Show Features window.
AccountShowTrojanExpressCollect DEPRECATED - Use Trojan ProgramLink instead.
ADAComplianceDateTime
ADAdescriptionsReset Boolean.
AddFamilyInheritsEmail Boolean, true by default. When set to true and a new family member is added, the new patient's email will be autofilled with the guarantor's email.
AddressVerifyWithUSPS Boolean. 1 by default. When enabled, addresses entered in formPatientEdit and addresses on patient forms imported using sheet and eform import will be verified with the USPS Addresses V3 API before saving.
AdjustmentBlockNegativeExceedingPatPortion Negative Adjustments ENUM:EnumAdjustmentBlockOrWarn When a user tries to make a negative adjustment that exceeds a remaining patient portion. 0 = Warn, 1 = Block, 2 = Allow. when adjustment amount exceed remaining patient portion
AdjustmentsForceAttachToProc Deprecated in version 17.4.40. When set to true, the user will not be able to save a new adjustment without first attaching a procedure to it.
AdjustmentsOffsetEachOther Boolean, true by default. When true, unattached pos/neg adjustments will counteract each other when running explicit linking logic. This will not happen in the payplan production selection window regardless of this setting; negative adjustments will not show.
ADPCompanyCode Enum:ADPCompanyCode Used to generate the export file from FormTimeCardManage. Set in FormTimeCardSetup.
ADPRunIID String, used to generate the ADP Run export file from FormTimeCardManage. Set in FormTimeCardSetup.
AgingBeginDateTime DateTime the currently running aging started Usually blank Stored as DateTime, but cleared when aging finishes. Used only in OpenDentalService for automatic aging. The DateTime will be used as a flag to signal other connections that aging calculations have started and prevents another connection from running simultaneously. In order to run aging, this will have to be cleared, either by the connection that set the flag when aging finishes, or by the user overriding the lock and manually clearing this pref.
AgingCalculatedMonthlyInsteadOfDaily DEPRECATED. Will always be false.
AgingCalculateOnBatchClaimReceipt Aging calculated on receipt of batch claim payments If true, aging will be calculated when receiving bulk checks for all families that bulk check applies to. Also applies to ERAs Determines whether aging is run after entering a Batch Insurance Payment or Processing an ERA. Only updates family balances of patients associated to the insurance payments. Useful for keeping patient balances current if entering claim payments after generating the billing list.
AgingIsEnterprise DEPRECATED. Will always be true for aging to use the intermediate table famaging for calculating aging.
AgingNegativeAdjsByAdjDate DEPRECATED. Use AgingProcLifo instead.
AgingProcLifo Transactions attached to a procedure offset each other before aging YN_DEFAULT_TRUE, 0-unknown,1-yes,2-no. For job 14902 - "Aging of AR change: LIFO negative adjustments to (within) attached procedure and positive adjustments." 3 state checkbox. When indeterminate (filled), it behaves as checked. Recommended is checked. Adjustment and payment plan credits attached to a procedure are summed by date. If the sum of the attached charges and credits results in a credit, the credit is applied to the balance of the procedure's aging category. Any remaining credit is aged normally. This is a LIFO strategy.
AgingReportShowAgePatPayplanPayments Aging Report Show Age Pat Payplan Payments This pref is hidden, so no UI to enable this feature. If this is true, there will be a checkbox in the aging report window to age patient payments to payment plans. Aging patient payments to payment plans will only work if the completed amounts on the payment plans are 0. Otherwise the payments and the completed amounts will essentially double the amounts of the payment plans in the aging calculation. This is only for a specific customer, so no UI, defaults to false, only able to enable this via query. If enabled, a checkbox is added to the <a href="https://opendental.com/autoLogin.aspx?token=d83JWerd&redirect=r.htm?reportcustomaging" target="_blank">Custom Aging Report</a> window to age patient payments to Payment Plans.
AgingServiceTimeDue Automated aging run time, Leave blank to disable Stored as DateTime, but only the time is used. This is the time of day during which aging will be calculated by the aging service. Aging will run during a one hour block of time starting with the time set. If AgingBeginDateTime is not blank, aging will not be calculated. If AgingCalculatedMonthlyInsteadOfDaily is true, aging will not be calculated. This will be blank if disabled.
AlertCheckFrequencySeconds Check alert interval in seconds How often to check for new alerts in Open Dental. Defaults to 180 (3 minutes). Leave blank to disable.
AlertInactiveMinutes Disable alert interval after this many minutes of user inactivity After this many minutes of inactivity, alerts will stop processing. Defaults to the same value as SignalInactiveMinutes. Leave this blank to disable
AllergiesIndicateNone FK to allergydef.AllergyDefNum
AllowEmailCCReceipt Boolean defaults to true. If true, allows a user to email CC receipt otherwise not allowed.
AllowedFeeSchedsAutomate Enum:AllowedFeeSchedsAutomate. 0 by default. 0=None, 1=LegacyBlueBook. 2=BlueBook.
AllowFutureInsPayments Allow future dated insurance payments Boolean defauts to false. If true, users can enter insurance payments that are for a future date.
AllowPrepayProvider Boolean, false by default to preserve old functionality. Allows users to attach providers to prepayments while EnforceFully is on.
AllowProcAdjFromClaim Bool. Allows adjustments from FormClaimEdit. 0 by default.
AllowSettingProcsComplete Allow setting procedures complete not usually recommended, it's better to only set appointments complete
ApiPaymentType DefNum for the default PaymentType for ODApi payments.
AppointmentBubblesDisabled
AppointmentBubblesNoteLength Appointment bubble max note length in characters, 0 for no limit
AppointmentClinicTimeReset Reset calendar to today on clinic select.
AppointmentSearchBehavior Search Behavior Enum:SearchBehaviorCriteria 0=ProviderTime means based only on provider availability from the schedule., 1=ProviderTimeOperatory means based on provider schedule availability as well as the availabilty of their operatory (dynamic or directly assigned). This will prevent overlap of appointments. ProviderTime: searches availability using only the provider time bar at the very left.<br/><br/> ProviderTimeOperatory: searches availability using both the provider time bar and space in the provider's operatories. This will prevent overlap of appointments.
AppointmentTimeArrivedTrigger Time Arrived trigger Select the confirmed status that will trigger an automatic time entry in the Time Arrived field on the <a href="https://opendental.com/autoLogin.aspx?token=d83JWerd&redirect=r.htm?aptedit" target="_blank">Edit Appointment</a>, and add the patient to the <a href="https://opendental.com/autoLogin.aspx?token=d83JWerd&redirect=r.htm?waitingroom" target="_blank">Waiting Room</a>. Customize options in Definitions,<br/>Appt Confirmed (see <a href="https://opendental.com/autoLogin.aspx?token=d83JWerd&redirect=r.htm?confirmationstatus" target="_blank">Confirmation Status</a>).";
AppointmentTimeDismissedTrigger
AppointmentTimeIncrement The number of minutes that the appointment schedule is broken up into. E.g. "10" represents 10 minute increments.
AppointmentTimeIsLocked Appointment time locked by default Set to true if appointment times are locked by default. If this is not set, and you are moving an appt or planned appt, the TimeLocked box should not get altered.
AppointmentTimeLineColor Appointment time line color Used to set the color of the time indicator line in the appt module. Stored as an int. horizontal line that indicates current time
AppointmentTimeSeatedTrigger
AppointmentTypeShowPrompt Controls whether or not creating new appointments prompt to select an appointment type.
AppointmentTypeShowWarning Controls whether or not a warning will be displayed when selecting an appointment type would detach procedures from an appointment..
AppointmentWithoutProcsDefaultLength Appointment without procedures default length Integer in minutes. If empty, it uses 30. The default length of an appointment that is created without attaching any procedures. Enforced to be at least 5.
ApptAllowEmptyComplete Allow setting appointments without procedures complete Boolean defauts to true. If true, users can set appointments without procedures complete.
ApptAllowFutureComplete Allow setting future appointments complete Boolean defauts to false. If true, users can set future appointments complete.
ApptAutoRefreshRange Number of days out to automatically refresh Appointments Module Int. Defaults to 4. Number of days out to automatically refresh appointment module. -1 will get all appointments. -1 for all, only for large offices experiencing slowness
ApptBubbleDelay
ApptArrivalAutoEnabled True if the office has actived Arrivals in the UI.
ApptArrivalUseDefaults Boolean. Defaults to false. Only used for the clinicpref table, not the preference table. When true, this clinic will use the Appointment Arrival rules for ClinicNum 0.
ApptConfirmAutoEnabled True if the office has actived eConfirmations in the UI.
ApptConfirmAutoSignedUp True if HQ has confirmed that this office is signed up for eConfirmations.
ApptConfirmByodEnabled Comma delimited list of FK to definition.DefNum. Every appointment with a confirmed status in this list will enable the Send BYOD link button in the kiosk manager.
ApptConfirmEnableForClinicZero Bool; Only if using clinics, when true causes automation to skip appointments not assigned to a clinic.
ApptConfirmExcludeArrivalResponse Comma delimited list of FK to definition.DefNum. Every appointment with a confirmed status that is in this list will be excluded from sending Arrival Response SMS and being marked Arrived.
ApptConfirmExcludeArrivalSend Comma delimited list of FK to definition.DefNum. Every appointment with a confirmed status that is in this list will be excluded from sending Arrival SMS.
ApptConfirmExcludeEclipboard Comma delimited list of FK to definition.DefNum. Every appointment confirmed status that is in this list will not trigger an appointments confirmation status to change when checking in a patient through eClipboard.
ApptConfirmExcludeEConfirm Comma delimited list of FK to definition.DefNum. Every appointment with a confirmed status that is in this list will be excluded from EConfirmation RSVP updates. Prevents overwriting manual Confirmation status.
ApptConfirmExcludeERemind Comma delimited list of FK to definition.DefNum. Every appointment with a confirmed status that is in this list will be excluded from EReminders.
ApptConfirmExcludeESend Comma delimited list of FK to definition.DefNum. Every appointment with a confirmed status that is in this list will be excluded from sending an EConfirmation. Prevents overwriting manual Confirmation status.
ApptConfirmExcludeEThankYou Comma delimited list of FK to definition.DefNum. Every appointment with a confirmed status that is in this list will be excluded from EThankYous.
ApptConfirmExcludeGeneralMessage Comma delimited list of FK to definition.DefNum. Every appointment with a confirmed status that is in this list will be excluded from general messages.
ApptConfirmExcludeNewPatThankYou Comma delimited list of FK to definition.DefNum. Every appointment with a confirmed status that is in this list will be excluded from new patient EThankYous.
ApptConfirmUseDefaults Boolean. Defaults to false. Only used for the clinicpref table, not the preference table. When true, this clinic will use the Appointment Confirmation rules for ClinicNum 0.
ApptEConfirm2ClickConfirmation Boolean. True by default. If true, clicking the confirm URL will bring up the Confirmation Portal where the patient can select a confirmation option. If false, clicking the confirm URL in the message will confirm the appt (1-click confirmation).
ApptEConfirmStatusSent FK to definition.DefNum. If using automated confirmations, appointment set to this status when confirmation is sent.
ApptEConfirmStatusAccepted FK to definition.DefNum. If using automated confirmations, appointment set to this status when confirmation is confirmed.
ApptEConfirmStatusDeclined FK to definition.DefNum. If using automated confirmations, Anything that is not "Accepted" or "Sent".
ApptEConfirmStatusSendFailed FK to definition.DefNum. If using automated confirmations, when failed by HQ for some reason.
ApptExclamationShowForUnsentIns
ApptFontSize Appointment font size Float. Default 8. Valid between 1 and 40. Also applies to operatory headers. default is 8; decimals allowed; in addition to Zoom
ApptGeneralMessageAutoEnabled True if the office has actived Appointment General Messages in the UI.
ApptGeneralMessageUseDefaults Boolean. Defaults to false. Only used for the clinicpref table, not the preference table. When true, this clinic will use the Appointment General Message rules for ClinicNum 0.
ApptMirrorSecondary Boolean, off by default. This pref is the default for Appointment.IsMirrored for new appointments. IsMirrored causes a shadow appointment to show in the secondary provider's operatory. This will only set IsMirrored for new appointments that have two providers. The mirroring effect can be set to hide or show using ApptView.ShowMirroredAppts.
ApptModuleAdjustmentsInProd Add daily adjustments to net production Boolean defaults to 0. If true, adds the adjustment total to the net production in appointment module. adjustments, discount plan adjustments, and TP procedure discounts will be included
ApptModuleDefaultToWeek Boolean defaults to 0, when true appt module will default to week view
ApptModuleProductionUsesOps Appointments Module production uses operatories Bool; 0 by default. When false, calculates net and gross production by provider bars in each appointment view. When true, calulates net and gross production by appointments in the apppointment view. uses operatories showing instead of provider bars at left
ApptModuleProviderPrompt Enum: EnumApptProvPrompt. Determines the provider change behavior when moving or scheduling appointments.
ApptModuleShowOrthoChartItem Show Ortho Chart in appointment options Boolean defaults to 1 if there is relevant ortho chart info, when true appt menu will have an ortho chart item. Show 'Go to Ortho Chart' option in the appointment right-click menu.
ApptModuleRefreshesEveryMinute Refresh every 60 seconds Each workstation can go dormant after a few minutes of inactivity due to pref SignalInactiveMinutes. This pref allows appointment signals to continue to be processed anyway so that dorman computers will still display up-to-date appointments. Default is true. Yes, this even happens when not inactive, resulting in an extra check to signalod. But this doesn't actually cause appointment refresh to happen more often because only one check will cause a refresh. keeps waiting room times refreshed
ApptModuleUses2019Overhaul Deprecated
ApptNewPatientThankYouEnabled Boolean. True if automated new patient thank yous are enabled for the entire DB. See ApptReminderRules for setup details. Permissions are still checked here at HQ so manually overriding this value will only make the program behave annoyingly, but won't break anything.
ApptNewPatientThankYouUseDefaults Boolean. Defaults to false. Only used for the clinicpref table, not the preference table. When true, this clinic will use the New Patient Thank You rules for ClinicNum 0.
ApptNewPatientThankYouWebSheetDefID Comma delimited string of WebSheetDefIDs. Defaults to 0, holds WebSheetDefIDs that are used for URL generation.
ApptPreventChangesToCompleted Prevent changes to completed appointments with completed procedures Boolean. False by default. If true, prevents from making changes (breaking, deleting, sending to unscheduled, changing status) to completed appointments. The completed appointment MUST have completed procedures attached. If false, does nothing.
ApptPrintColumnsPerPage Integer
ApptPrintFontSize Float
ApptPrintIsLandscape Bool; True by default.
ApptPrintTimeStart Stored as DateTime. Currently the date portion is not used but might be used in future versions.
ApptPrintTimeStop Stored as DateTime. Currently the date portion is not used but might be used in future versions.
ApptProvbarWidth Width of provider time bar on left of each appointment Int. Width of prov bar on individual appts, not the bars on left of screen. Was historically 8. In version 19.3, default was changed to 11 to allow text in provbar. Valid between 0 and 20. in pixels; enter 0 to remove; does not affect bars to the left of the operatories
ApptProvbarShowOnOps True by default. Shows provider bars at the left of the operatory if the provider is scheduled for that time. This was historically always true, but was then broken between about 2020 and 2025. So when fixing it in 2025, we made it a pref in case someone got used to it being broken and wants to turn it off.
ApptRemindAutoEnabled True if automated appointment reminders are enabled for the entire DB. See ApptReminderRules for setup details. Permissions are still checked here at HQ so manually overriding this value will only make the program behave annoyingly, but won't break anything.
ApptReminderDayInterval DEPRECATED. See ApptReminderRule table instead.
ApptReminderDayMessage DEPRECATED. See ApptReminderRule table instead.
ApptReminderEmailMessage DEPRECATED. See ApptReminderRule table instead.
ApptReminderHourInterval DEPRECATED. See ApptReminderRule table instead.
ApptReminderHourMessage DEPRECATED. See ApptReminderRule table instead.
ApptReminderPremedTemplate Used as the value of the [Premed] tag in eReminders.
ApptReminderSendAll DEPRECATED. See ApptReminderRule table instead.
ApptReminderSendOrder DEPRECATED. See ApptReminderRule table instead.
ApptReminderUseDefaults Boolean. Defaults to false. Only used for the clinicpref table, not the preference table. When true, this clinic will use the Appointment Reminder rules for ClinicNum 0.
ApptSchedEnforceSpecialty Enforce clinic specialties Enum:ApptSchedEnforceSpecialty Allow by default. 0=Allow, 1=Warn, 2=Block. Determines behavior when an appointment is scheduled in an operatory assigned to a clinic for a patient with a specialty that does not exist in the list of that clinic's specialties.. when the patient's specialty does not match the clinic's
ApptsAllowOverlap Appointments allow overlap Boolean. When true allows appointments to overlap in the same operatory.
ApptsRequireProc Appointments require procedures Bool; True by default. When true, new appointments require at least one procedure to be attached.
ApptsCheckFrequency DEPRECATED. Use InsChecksFrequency instead.
ApptPrintColorBehavior Enum. Defaults to 0. 0=all colors seen in the Appt Module, 1=less color and without solid shading, 2=shades of gray and without solid shading.
ApptSecondaryProviderConsiderOpOnly Force op's hygiene provider as secondary provider Bool; False by default. When true, the secondary provider used when scheduling an appointment will use the Operatory's secondary provider no matter what. Checked: The hygienist of the operatory is always assigned as the hygienist on the appointment, even if none.<br/><br/>Unchecked: The hygienist of the operatory is assigned as the hygienist unless it is none. In that case, the patient's secondary provider is assigned.
ApptThankYouAutoEnabled True if automated appointment thank yous are enabled for the entire DB. See ApptReminderRules for setup details. Permissions are still checked here at HQ so manually overriding this value will only make the program behave annoyingly, but won't break anything.
ApptThankYouCalendarTitle Used as the value of the SUMMARY field in a .ics file for Appointment Thank You, Reminders, and eConfirmation auto replies [AddToCalendar] tag.
ApptThankYouUseDefaults Boolean. Defaults to false. Only used for the clinicpref table, not the preference table. When true, this clinic will use the Appointment Thank You rules for ClinicNum 0.
ApptUseSecProvTimeIfEmpty False by default. If true, appointments with a primary and secondary provider that have no time set for either provider will instead have full time show for the secondary provider.
ApptWeekViewStartDay 0 for Sunday, 1 for Monday. No other days supported. Sunday is now the default. Used to be Monday. No use supporting other days.
ArchiveDate Date, MinDate by default. The Date that was set within the "Archive entries on or before:" field within the Archive tab of the Backup window when the archive process was last ran successfully.
ArchiveDoBackupFirst In FormBackup the remove old data tab, if true make a backup when the user runs remove old data.
ArchiveKey String of random alpha-numeric characters that represents a synced key between an OD database and its specific archive database.
ArchivePassHash Obfuscated password for the database user that will be used when directly connecting to the archive server. Not actually the hash.
ArchiveServerName The name of the server where the archive database should be located.
ArchiveServerURI DEPRECATED. Archiving with Middle Tier connection never fully implemented. Here was the original intent behind the preference: URI to a Middle Tier web service that is connected to the database where archives should be made.
ArchiveUserName The user name for the database user that will be used when directly connecting to the archive server.
ArManagerBillingTypes Default billing types selected when loading the Unsent Tab of the Accounts Receivable Manager.
ArManagerExcludeBadAddresses Default state for the exclude if bad address (no zipcode) checkbox when loading the Unsent Tab of the Accounts Receivable Manager.
ArManagerExcludeIfUnsentProcs Default state for the exclude if unsent procs checkbox when loading the Unsent Tab of the Accounts Receivable Manager.
ArManagerExcludeInsPending Default state for the exclude if pending ins checkbox when loading the Unsent Tab of the Accounts Receivable Manager.
ArManagerLastTransTypes Default transaction types selected when loading the Sent Tab of the Accounts Receivable Manager - Sent tab.
ArManagerSentAgeOfAccount Default account age when loading the Sent Tab of the Accounts Receivable Manager.
ArManagerSentDaysSinceLastPay Default number of days since the last payment when loading the Sent Tab of the Accounts Receivable Manager.
ArManagerSentMinBal Default minimum balances when loading the Sent Tab of the Accounts Receivable Manager.
ArManagerUnsentAgeOfAccount Default account age when loading the Unsent Tab of the Accounts Receivable Manager.
ArManagerUnsentDaysSinceLastPay Default number of days since the last payment when loading the Unsent Tab of the Accounts Receivable Manager.
ArManagerUnsentMinBal Default minimum balances when loading the Unsent Tab of the Accounts Receivable Manager.
ArManagerExcludedExcludeBadAddresses Default state for the exclude if bad address (no zipcode) checkbox when loading the Excluded Tab of the Accounts Receivable Manager.
ArManagerExcludedExcludeIfUnsentProcs Default state for the exclude if unsent procs checkbox when loading the Excluded Tab of the Accounts Receivable Manager.
ArManagerExcludedExcludeInsPending Default state for the exclude if pending ins checkbox when loading the Excluded Tab of the Accounts Receivable Manager.
ArManagerExcludedDaysSinceLastPay Default number of days since the last payment when loading the Excluded Tab of the Accounts Receivable Manager.
ArManagerExcludedMinBal Default minimum balances when loading the Excluded Tab of the Accounts Receivable Manager.
ArManagerExcludedAgeOfAccount Default account age when loading the Excluded Tab of the Accounts Receivable Manager.
AsapPromptEnabled If true, user is prompted if they would like to text ASAP list to offer the time slot created when breaking/unscheduling an appt. True by default.
ASAPTextTemplate The template that is used when manually texting patients on the ASAP list.
AsteriskConferenceApplication Missing in general. Only used by OD HQ. The application the Asterisk server uses for conference rooms. Value can be either 'Meetme' or 'ConfBridge'.
AsteriskHighVolumeMode Missing in general. Used by OD HQ only. Used to keep track of whether or not the call center is experiencing high call/blue task volume.
AsteriskServerHeartbeat Only used by OD HQ. This is a strange preference because it isn't used in the typical cache fashion. HQ directly queries this preference very often in order to see if the PhoneTrackingServer has gone down.
AsteriskServerIp Used by OD HQ. Not added to db convert script. Used to store the IP address of the asterisk phone server for the phone comms and voice mails.
AtoZfolderNotRequired Deprecated, but must remain here to avoid breaking updates.
AtoZfolderUsed Enum - Enumerations.DataStorageType. Normally 1 (AtoZ). This used to be called AtoZfolderNotRequired, but that name was confusing.
AuditTrailEntriesDisplayed The number of audit trail entries that are displayed in the grid.
AuditTrailUseReportingServer Boolean - Allows the audit trail to run on the report server. Defaults to true if reporting server is in use, otherwise false
AutoCommNumClinicsParallel No UI for this pref. The number of clinics to run in parallel for AutoComm (eConfirms, eReminders, WebSchedRecall, etc.). If set to 0, then the number of threads to use will be the number of cores on the machine. Defaults to 0.
AutoCommUnder18SendToGuarantor Boolean - Send AutoComms to the guarantor for patients under the age of 18.
AutoImportFolder Default folder for auto import in images module.
AutomaticCommunicationTimeStart Used to determine the runtime of the threads that do automatic communication in the listener. Stored as a DateTime.
AutomaticCommunicationTimeEnd Used to determine the runtime of the threads that do automatic communication in the listener. Stored as a DateTime.
AutomaticSummaryOfCareWebmail Boolean. Defaults to same value as ShowFeatureEhr. Used to determine whether automatic summary of care webmails are sent.
AutoMsgingUseDefaultPref Only used for the clinicpref table, not the preference table.
AutoResetTPEntryStatus
AutoSplitLogic Enum - AutoSplitPreference. Deprecated. Defaults to Adjustments (1). Used to choose order to apply unattached credits to adjustments in account module.
BackupIndexesDisabled Bool. True by default. When true, indexes are disabled for all tables when creating automatic backups. When disabled, the database will still need the indexes to be re-enabled. This is done on OD startup in Shared.EnableIndexesIfNeeded.
BackupExcludeImageFolder
BackupFromPath
BackupReminderLastDateRun
BackupRestoreAtoZToPath
BackupRestoreFromPath
BackupRestoreToPath
BackupToPath
BadDebtAdjustmentTypes Current Bad Debt adj types:
BalancesDontSubtractIns Balances don't subtract insurance estimates Boolean. False by default. When false, the Balance due in the Account module and statements will include estimated insurance payments. When true, the Balance due in the Account module and statements will exclude estimated insurance payments. When enabled, total balances in the Account Module and Statements do not consider insurance estimates. The Balances Due area in the Account Module displays Balance (bold red), Ins Pending, After Ins, and Pat Est Bal. Claim line items in the Account include Estimated Payment Pending and Est Patient Portion. <br/><br/> When disabled, total balances in the Account Module and Statements consider insurance estimates. The Balances Due area in the Account Module displays Total, Ins Est, =Est Bal (bold red), and Pat Est Bal. Claim line items in the Account exclude Estimated Payment Pending and Est Patient Portion.
BankAddress
BankRouting
BetterDiagnosticsEnabled Indicates whether or not a clinic has Better Diagnostics enabled. Will be a preference for clinic 0, otherwise a clinicpref.
BillingAgeOfAccount
BillingChargeAdjustmentType Billing charge adj type
BillingChargeAmount
BillingChargeLastRun
BillingChargeOrFinanceIsDefault Value is a string, either Billing or Finance.
BillingDaysExcludeInsPending Int, 0 by default. Claims where insurance has been pending for this many days or fewer will be ignored when processing Billing. Value of 0 means any claim where insurance is pending will be ignored, no matter how old. This will be 0 if BillingExcludeInsPending is set to false.
BillingDefaultsInvoiceNote
BillingDefaultsIntermingle
BillingDefaultsLastDays
BillingDefaultsModesToText The statement modes that will also receive a text message. Stored as a comma-separated list of integers where each item is the integer value of the StatementMode enum.
BillingDefaultsNote General Message (in addition to any dunning messages and appointment messages). Allows the variable [InstallmentPlanTerms].
BillingDefaultsSinglePatient Boolean, false by default. Indicates if billing statements default to single patients(true) or guarantors(false).
BillingDefaultsSmsTemplate The template used for SMS text notifications for statements.
BillingElectBatchMax Max number of statements per batch Value is an integer, identifying the max number of statements that can be sent per batch. Default of 0, which indicates no limit. This preference is used for both printed statements and electronic ones. It was decided to not rename the pref. 0 for no limit
BillingElectClientAcctNumber Deprecated. Use ebill.ClientAcctNumber instead.
BillingElectCreatePDF Boolean, true by default. Indicates if electronic billing should generate a PDF document.
BillingElectCreditCardChoices
BillingElectIncludeAdjustDescript Boolean, true by default. If 1, prepend 'Adjust' to the Adjustment Type when building the electronic statement XML.
BillingElectIncludeClinicNums Boolean, false by default. Used to output ClinicNum as "LocationID" for POS electronic billing, output to file mode.
BillingElectPassword Deprecated. Use ebill.ElectPassword instead.
BillingElectSaveHistory No UI, can only be manually enabled by a programmer. Only used for debugging electronic statements, because it will bloat the OpenDentImages folder. Originally created to help with the "missing brackets bug" for EHG billing.
BillingElectStmtOutputPathClaimX Output path for ClaimX EStatments.
BillingElectStmtOutputPathEds Output path for EDS EStatments.
BillingElectStmtOutputPathPos Output path for POS EStatments.
BillingElectStmtUploadURL URL that EStatments are uploaded to for Dental X Change. Previously hardcoded in version 16.2.18 and below.
BillingElectUserName Deprecated. Use ebill.ElectUserName instead.
BillingElectVendorId
BillingElectVendorPMSCode
BillingEmailBodyText
BillingEmailIncludeAutograph
BillingEmailSubject
BillingExcludeBadAddresses
BillingExcludeIfUnsentProcs
BillingExcludeInactive
BillingExcludeInsPending
BillingExcludeLessThan
BillingExcludeNegative
BillingIgnoreInPerson
BillingIncludeChanged
BillingUseBillingCycleDay Used with repeat charges to apply repeat charges to patient accounts on billing cycle date.
BillingSelectBillingTypes String. Comma-delimited list of definition.DefNums for Billing Types. An empty string denotes selecting all Billing Types.
BillingSelectInsFilingCodes String. Comma-delimited list of insfilingcode.InsFilingCodeNums. An empty string denotes Unspecified. -1 in the list denotes selecting all Insurance Filing Codes.
BillingShowSendProgress Deprecated. Boolean. Defaults to true. Determines if the billing window shows progress when sending statements.
BillingShowTransSinceBalZero Show all transactions since zero balance Boolean. Allows option to show activity on statements since the last $0 balance on the account (or family). The 'Show all transactions since zero or negative balance' option is checked by default in <a href="https://opendental.com/autoLogin.aspx?token=d83JWerd&redirect=r.htm?billing" target="_blank">Billing Options</a> and when using More Options for single a <a href="https://opendental.com/autoLogin.aspx?token=d83JWerd&redirect=r.htm?statementwindow" target="_blank">Statement</a>.
BillingUseElectronic 0=no,1=EHG,2=POS(xml file),3=ClaimX(xml file),4=EDS(xml file)
BirthdayPostcardMsg
BirthdayPromotionsEnabled Boolean. Defaults to false. Used for the clinicpref table, in addition to the preference table. When true, this practice or clinic is enabled to send Birthday Promotions.
BirthdayPromotionsUseDefaults Boolean. Defaults to true. Only used for the clinicpref table, not the preference table. When true, this clinic will use the Birthday Promotion rules for ClinicNum 0.
BlurModuleOnLoad Boolean. Defaults to false. If true, the screen get a blurred unclickable overlay while loading a new module to prevent inappropriated clicking. Requested by NADG for their slow computers.
BrandingUseDefaults Boolean. True by default. Only used for the clinicpref table, not the preference table. When true, clinic will use the Branding for ClinicNum 0
BrokenAppointmentAdjustmentType Broken appt default adj type FK to definition.DefNum. The adjustment type that will be used on the adjustment that is automatically created when an appointment is broken.
BrokenApptProcedure Broken appointment procedure type Enumeration of type "BrokenApptProcedure". Missed by default when D9986 is present. This preference determines how broken appointments are handeld. None: Do not prompt user to add any procedure. If grayed out, the database does not have a D9986 or D9987 procedure code (example: foreign user). Procedure codes must already exist to use this preference.</br></br>Missed: User will be prompted to add completed procedure D9986 (missed appointment).</br></br>Cancelled: User will be prompted to add completed procedure D9987 (cancelled appointment).</br></br>Both: Give user the option to add a completed D9986 or D9987.
BrokenApptCommLogNotAdjustment Deprecated. Boolean. 0 by default. When true, makes a commlog, otherwise makes an adjustment.
BrokenApptCommLog Make broken appointment commlog Deprecated. Boolean. 0 by default. When true, makes a commlog, otherwise makes an adjustment.
BrokenApptAdjustment Make broken appointment adjustment Boolean. 0 by default. When true, makes an adjustment when an appointment is broken.
BrokenApptRequiredOnMove Force users to break scheduled appointments before rescheduling Boolean. 0 by default. Require user to break scheduled appt before moving to a new day, the pinboard, the unscheduled list or deleting. even if Broken appointment procedure type is set to "None"
BytesPerSmsHeader
BytesPerSmsMessagePart
CareCreditBatchProcessDateTime DateTime. Updated by HQ. Determines what time to process CareCredit batch quickscreen transactions.
CareCreditBatchPullbackDateTime DateTime. Updated by HQ. Determines what time to run CareCredit batch quickscreen pullbacks.
CanadaCreatePpoLabEst Boolean. True by default. When true, Canadian PPO insurance plans create estimates for labs (default behavior for category percentage plans).
CanadaODAMemberNumber For Ontario Dental Association fee schedules.
CanadaODAMemberPass For Ontario Dental Association fee schedules.
CentralManagerSecurityLock Boolean. 0 by default. If enabled, only CEMT can edit certain security settings. Currently only used for global lock date.
CentralManagerPassHash This is the hash of the password that is needed to open the Central Manager tool.
CentralManagerPassSalt This is the salt that is prepended to the password when hashing. It provides an extra layer of security.
CentralManagerSyncCode Sync code for CEMT Blank by default. Contains a key for the CEMT. Each CEMT database contains a unique sync code. Syncing from the CEMT will skip any databases without the correct sync code. Indicates the Sync Code of the Central Enterprise Management Tool (CEMT) database this database is associated with. All database connections which are affected by a CEMT sync have a code listed here. If the code is cleared, CEMT users can sync from any database, but this is not recommended.
CentralManagerUseDynamicMode Connections initiated from within CEMT will use dynamic mode, allowing connection to db of mismatched version.
CentralManagerIsAutoLogon Connections initiated from within CEMT will automatically log on the CEMT user.
ChatServerCompName When using a distinct chat server, stores the server name.
ChatServerDbName When using a distinct chat server, stores the database name.
ChatServerMySqlPassHash When using a distinct chat server, stores the hashed mysql password.
ChatServerMySqlUser When using a distinct chat server, stores the mysql username.
ChartQuickAddHideAmalgam Deprecated.
ChartAddProcNoRefreshGrid Deprecated. If set to true (1), then after adding a proc, a row will be added to datatable instead of rebuilding entire datatable by making queries to the database. This preference was never fully implemented and should not be used. We may revisit some day.
ChartNonPatientWarn Non-Patient warning Preference to warn users when they have a nonpatient selected. when opened from the Chart Module
ChartOrthoTabAutomaticCheckboxes If true, then checkboxes for Tooth Chart Ortho Mode and Show Ortho Grids will get automatically checked and unchecked
ChildDaycare Used by internal daycare only. True if this is the Daycare database.
ClaimAttachExportPath Claim attachment export path
ClaimCheckForMedicalEOB Prompt user to attach Medical EOB to primary dental claims If true, prompt user to attach Medical EOB if a medical claim exists which shares at least one procedure with the dental claim, and it has no claimattach associated with it. Primary dental claims must have the medical insurance selected as Other Coverage in the <a href="https://opendental.com/autoLogin.aspx?token=d83JWerd&redirect=r.htm?claimedit" target="_blank">Edit Claim</a> window.
ClaimEditRequireNoMissingData Require claims to have no missing data If true, we will require claims to not have any missing data before they can be created. B61996 - When creating a claim rather than sending, missing info for the following will not be enforced: multi-visit groups and certain institutional claim type information (UB04). Prevents claims from being created if there is missing data.
ClaimEditShowPatResponsibility If true, we will display the Patient Repsonsibility in the claim edit and claim payment windows.
ClaimFinalizeWarning If true, users receives a warning when a received claim payment isn't finalized.
ClaimEditShowPayTracking If true, we will include the Pay Tracking column in the claim edit and claim payment windows.
ClaimIdPrefix Claim Identification Prefix Default value of "[PatNum]/". Allows customization of ClaimIdentifier prefix format. Default is [PatNum]/. This prefix is followed by an auto-generated claim number. Useful for internal tracking of claims.
ClaimFormTreatDentSaysSigOnFile
ClaimMedProvTreatmentAsOrdering When true, the default ordering provider on medical eclaim procedures will be set to the procedure treating provider.
ClaimMedReceivedPromptForPrimaryClaim Prompt for primary claims Boolean, true by default. When true, checks for "Unsent" or "Hold Until Pri Received" primary dental claims and prompts user to choose action on those claims. When checked, upon receiving a medical claim, system will look for "Unsent" or "Hold Until Pri Received" primary dental claims and prompt user to choose action on those claims.
ClaimMedReceivedForcePrimaryStatus Remove 'Do Nothing' for primary claims with 'Hold Until Pri Received' or 'Unsent' Boolean, false by default. Receiving a medical claim will make primary dental claims with ClaimStatus 'Hold Until Pri Received' or 'Unsent' display a popup of actions for those primary claims. When true, this preference will remove the 'Do Nothing' option from that popup so the user has to change the status to 'Waiting to Send' or send the primary claim. Recieving a medical claim will make primary dental claims with ClaimStatus 'Hold Until Pri Received' or 'Unsent' display a popup of actions for those primary claims. When checked, this preference will remove the 'Do Nothing' option from that popup so the user has to change the status to 'Waiting to Send' or send the primary claim.
ClaimMedTypeIsInstWhenInsPlanIsMedical
ClaimCobInsPaidBehavior Send Paid By Other Insurance At Enum:EclaimCobInsPaidBehavior. Defaults to "ClaimLevel". For X12 version 5010 eclaims. Claim Level means just the total for the claim, Procedure Level means the amount for each procedure
ClaimPayByTotalSplitsAuto True when using line item accounting.
ClaimPaymentBatchOnly Finalize claim payments in Batch Insurance window only Boolean, 0 by default. When true, only Batch Insurance in Manage Module can be used to finalize payments. otherwise, users can also finalize payments from the <a href="https://opendental.com/autoLogin.aspx?token=d83JWerd&redirect=r.htm?claimedit" target="_blank"> Edit Claim</a> window.
ClaimPaymentNoShowZeroDate Show $0 claim payments in Batch Ins for number days Int. Valid values are >=0. Use -1 to disable. Used to be a date. Now represents a rolling date, thus the name is a bit off. We decided to keep the name the same instead of deprecating and creating a new pref, because user never sees the pref name and to avoid bloat. Number of days (default 1) to subtract from the current date when deciding which NO PAYMENT claims and $0 claimprocs to consider when using the This Claim Only button from the Edit Claim window or when creating a batch payment from Manage module. Used for filtering Outstanding Claims from FormClaimPayBatch list, and when finalizing from Edit Claim window. Blank field hides $0 claim payments from the Outstanding Claims area of the <a href="https://opendental.com/autoLogin.aspx?token=d83JWerd&redirect=r.htm?claimpaymentbatch" target="_blank">Batch Insurance Payment</a> window. When a number of days is entered, $0 claims show until the entered number of days has passed.
ClaimPaymentPickStatementType When true, does not select the first option as the default payment type. Payment type must be selected before clicking OK
ClaimPrintProcChartedDesc Use the description for the charted procedure code on printed claims When true, procedurecode overrides will send the override's description to insurance instead of the original procedurecode's description. useful when charting custom procedures, otherwise uses base procedure code description
ClaimPrimaryReceivedRecalcSecondary
ClaimPrimaryRecievedForceSecondaryStatus
ClaimProcAllowCreditsGreaterThanProcFee Enum:ClaimProcCreditsGreaterThanProcFee. Allow by default. 0=Allow, 1=Warn, 2=Block. This preference either allows, warns or blocks the user from entering an insurance payment on the Enter Payment screen if (for a procedure) the sum of the Ins Pay + Writeoff + any attached adjustments + and attached patient payments > Procedure Fee
ClaimProcsAllowedToBackdate Allow estimates to be created for backdated completed procedures Boolean, 0 by default. When true, allows claimprocs to be created for backdated completed procedures. Not recommended. Determines whether or not insurance estimates are created when a procedure is entered with a previous date (earlier than today) and an entry status of Complete. Typically only used by those who regularly enter completed procedures for previous dates.<br/><br/>To prevent accidental activation, a password prompt will display when enabling this option. The password is abracadabra.
ClaimProcsNotBilledToInsAutoGroup For the Procedures Not Billed to Insurance report. If true, when creating new claims from the report window, will group procedures by clinic and site. If false, will block user from creating claims if the selected procedures for a specific patient have different clinis or different sites. Default value is true to encourage automation.
ClaimReportComputerName Blank by default. Computer name to receive reports from automatically.
ClaimReportReceivedByService Receive Reports by Service Boolean, 0 by default. When true, Open Dental Service will receive claim reports instead of the specified computer spawning a thread in FormOpenDental. Determines the method used to receive clearinghouse reports. When enabled, reports are received using the <a href="https://opendental.com/autoLogin.aspx?token=d83JWerd&redirect=r.htm?opendentalservice" target="_blank">Open Dental Service</a>. When disabled, reports are received using the computer specified in <a href="https://opendental.com/autoLogin.aspx?token=d83JWerd&redirect=r.htm?clearinghouses" target="_blank">Clearinghouse Setup</a>. This method is recommended for remote app users.
ClaimReportReceiveInterval minutes (5 to 60) Report receive interval. In minutes. 30 by default. If the ClaimReportReceiveLastDateTime preference is set, then this value will be 0. Set a time interval, in minutes, to check for and download new clearinghouse reports. Allows values between 5 and 60. 30 is the default.
ClaimReportReceiveLastDateTime Stores last time the reports were ran.
ClaimReportReceiveTime Time to retrieve claim reports. Stored as a DateTime even though we only care about the time. If theClaimReportReceiveInterval preference is set, then this value will be an empty string. Set a specific time to check for and download new clearinghouse reports.
ClaimsSendWindowValidatesOnLoad Boolean. 0 by default. If enabled, the Send Claims window will automatically validate e-claims upon loading the window. Validating all claims on load was old behavior that was significantly slowing down the loading of the send claims window. Several offices complained that we took away the validation until they attempt sending the claim.
ClaimSnapshotEnabled Claim Snapshot Enabled Boolean. 0 by default. If enabled, snapshots of claimprocs are created when claims are created. If checked, snapshots of <a href="https://opendental.com/autoLogin.aspx?token=d83JWerd&redirect=r.htm?claimprocedure" target="_blank">Claim Procedures ( claimprocs )</a> are created when a claim is created. See <a href="https://opendental.com/autoLogin.aspx?token=d83JWerd&redirect=r.htm?claimsnapshot" target="_blank">Claim Snapshot</a>.
ClaimSnapshotRunTime Service Run Time DateTime where the time is the only useful part. Stores the time of day that the OpenDentalService should create a claimsnapshot. Only visible if 'Claim Snapshot Enabled' is checked. Determines time of day OpenDentalService should create Claim Snapshot.
ClaimSnapshotTriggerType Snapshot Trigger Enumeration of type "ClaimSnapshotTrigger". ClaimCreate by default. This preference determines how ClaimSnapshots get created. Stored as the enumeration.ToString(). Not available to most users to change. In the rare case that a customer needs it, there are instructions in UserControlFamilyGeneral for how to set it. Only visible if 'Claim Snapshot Enabled' is checked. Determines when a Claim Snapshot is created. <br/><br/> Claim Created: By default the snapshot is created at the time the claim is created.<br/><br/> Service - Specific Time: Snapshots are generated by a service at the Service Run Time set below.<br/><br/> Insurance Payment Received: Snapshot is created when the Insurance payment is received.
PriClaimAllowSetToHoldUntilPriReceived Boolean. 1 by default. While a claim is being created, claim status "Hold Until Pri Received" doesn't make sense if user is creating a primary claim already. However this has been allowed for a long time now so we want users who want to block this ability have to go in and switch this preference off themselves.
ClaimTrackingRequiresError When set to true, adding a claim tracking status to a claim requires an error.
ClaimTrackingStatusExcludesNone Bool determines if 'None' will show as an option in the custom tracking form. Defaults to false,'None' will show as an option.
ClaimUpdateFeeForSecondary
ClaimZeroDollarProcBehavior Creating claims with $0 procedures Enumeration of type "ClaimZeroDollarProcBehavior". Defaults to 0 (Allow). Determines if $0 procedures can be attached to claims.
ClaimsValidateACN
ClearinghouseDefaultDent
ClearinghouseDefaultEligibility FK to clearinghouse.ClearingHouseNum. Allows a different clearinghouse to be used for checking eligibility. Defaults to the current dental (or medical) clearinghouse which preserves old behavior.
ClearinghouseDefaultMed
ClinicAllowPatientsAtHeadquarters Boolean. 0 by default. If enabled, new patients can be added with an usassigned clinic.
ClinicListIsAlphabetical Boolean. 0 by default. If enabled, lists clinics in alphabetical order.
ClinicTrackLast Track Last Clinic By String, "Workstation"(default), "User", "None". See FormMisc. Determines how recently viewed clinics should be tracked. For Clinics only. Affects which clinic is selected in the Main Menu, Clinics when a user logs on to a workstation.<br/><br/>None: Select the user's default clinic.<br/><br/>Workstation: Select the clinic last selected on the workstation, if the user has access to it. If not, select the user's default clinic.<br/><br/>User: Select the clinic that was active the last time the user logged off.
ClockEventAllowBreak Allow paid 30 minute breaks Boolean. 1 by default. If enabled, displays 'Break' and 'Lunch' buttons in Manage Module, if disabled, changes 'Lunch' button text to 'Break' and disables/hides true 'Break' button. Effectively, enabling this preference means on-the-clock-breaks are allowed, and disabling the preference means on-the-clock-breaks are not allowed. Checked: Count up to 30 minutes of break time as paid. Enables View Breaks button from the Manage Module and Breaks radio button in Time Card. Allows clock-out status of Lunch for unpaid breaks.<br/><br/>Unchecked: All break time is considered unpaid. Disables Lunch clock-out status, View Breaks button, and Breaks radio button.<br/><br/>All employees should be clocked out and time card adjustments made prior to changing this preference. Changing this preference does not affect historical time card breaks.
CloneCreateSuperFamily Boolean. 0 by default. When set to true, all new clones will be put into their own family (guarantor as themselves) and then a super family will be created if one does not exist or the new clone will be associated to the master clone's super family. When set to false, all new clones blindly inherit their master's guarantor and super family settings.
CloudPasswordNeedsReset YN enum. Defaults to Unknown. Indicates whether the office needs to reset their Cloud password. For non-Cloud offices, this will be Unknown. Once they switch to Cloud, they will be prompted until they change the password, and this will be set to No.
CloudAlertWithinLimit When a number of sessions of Open Dental Cloud is within the maximum minus this number an Alert will be created.
CloudAllowedIpAddresses Deprecated. Use the table 'cloudaddress' instead.
CloudApiServiceUrl String used by OD Cloud Load Balanced Environments to store the private IP address of the cloud data VM for use with API calls. If altered a restart is required as this value is set to a static variable on startup. Defaults to: 127.0.0.1
CloudSessionLimitCap Hidden preference. Used to prevent customers from increasing their session limit past what a server is capable of.
CloudSessionLimit Hidden preference. Used to prevent customers from increasing their session limit past what a server is capable of.
CloudIsAppStream Hidden preference. False for cloud users using Thinfinity. Controls how Open Dental communicates with the ODCloudClient. Set to False to use the original HTTP system with Thinfinity. If altered a restart is required as this value is set to a static variable on startup
CloudFileWatcherDirectory Deprecated for now. Hidden preference. The directory used for standard cloud client communication. If altered a restart is required as this value is set to a static variable on startup
CloudFileWatcherDirectoryAPI Deprecated for now. Hidden preference. The directory used for API communication. If altered a restart is required as this value is set to a static variable on startup.
ColorTheme 0=standard, 1=alternate icons on ModuleBar and a few on Main Toolbar. This no longer affects any colors.
CommLogAutoSave Commlogs auto save Boolean. False by default. When true, causes CommLogs to auto-save on a timer. every ten seconds
ConfirmEmailMessage
ConfirmEmailFamMessage
ConfirmEmailSubject
ConfirmGroupByFamily Boolean. False by default. When true, causes families to be grouped together for the purpose of confirmations.
ConfirmPostcardMessage
ConfirmPostcardFamMessage
ConfirmStatusEmailed FK to definition.DefNum. Initially 0.
ConfirmStatusTextMessaged FK to definition.DefNum.
ConfirmTextMessage The message that goes out to patients when doing a batch confirmation.
ConfirmTextFamMessage
ConnGroupCEMT Selected connection group within the CEMT.
ConnectionSettingsHQ Missing in general. HQ Only. JSON serialized dictionary of the default connection settings for several databases. Key = ConnectionNames enum, Value = CentralConnection object. These default connection settings can be overridden by SiteLinks.
CoPay_FeeSchedule_BlankLikeZero Copay fee schedules treat blank entries as zero Set how blank entries in copay fee schedules are handled.<br/><br/>Checked: Blank entries are treated as 0.<br/>Example: UCR =$200, Contracted = $150, Write-off = 50, Copay = blank,<br/>Percentage = %100, Patient Portion = $0<br/><br/>Unchecked: Blank entries are treated as 100% copay.<br/>Example: UCR =$200, Contracted = $150, Write-off = 50, Copay = blank,<br/> Percentage = %100, Patient Portion = $150.
CorruptedDatabase Boolean. Typically set to true when an update is in progress and will be set to false when finished. Otherwise true means that the database is in a corrupt state.
CQMDefaultEncounterCodeValue This is the default encounter code used for automatically generating encounters when specific actions are performed in Open Dental. The code is displayed/set in FormEhrSettings. We will set it and give the user a list of 9 suggested codes to use such that the encounters generated will cause the pateint to be considered part of the initial patient population in the 9 clinical quality measures tracked by OD. CQMDefaultEncounterCodeSystem will identify the code system this code is from and the code value will be a FK to that code system.
CQMDefaultEncounterCodeSystem
CropDelta
CustListenerConnectionRequestTimeoutMS Used by OD HQ. Not added to db convert script. Allowable timeout for Negotiator to establish a connection with Listener. Different than SocketTimeoutMS and TransmissionTimeoutMS. Specifies the allowable timeout for Patient Portal Negotiator to establish a connection with Listener. Negotiator will only wait this long to get an acknowledgement that the Listener is available for a transmission before timing out. Initially 10000
CustListenerHeartbeatFrequencyMinutes Used by OD HQ. Not added to db convert script. Will be passed to OpenDentalEConnector when service initialized. Specifies the time (in minutes) between each time that the listener service will upload it's current heartbeat to HQ. Initially 360
CustListenerPort Used by OpenDentalEConnector. String specifies which port the OpenDentalWebService should look for on the customer's server in order to create a socket connection. Initially 25255
CustListenerSocketTimeoutMS Used by OD HQ. Not added to db convert script. Will be passed to OpenDentalEConnector when service initialized. Specifies the read/write socket timeout. Initially 3000
CustListenerTransmissionTimeoutMS Used by OD HQ. Not added to db convert script. Specifies the entire wait time alloted for a transmission initiated by the patient portal. Negotiator will only wait this long for a valid response back from Listener before timing out. Initially 30000
CustomersHQDatabase Used by OD HQ. The name of the database that all workstations will use when taking/owning triage tasks.
CustomersHQMySqlPassHash Used by OD HQ. The MySQL password hash that all workstations will use when taking/owning triage tasks.
CustomersHQMySqlUser Used by OD HQ. The MySQL user that all workstations will use when taking/owning triage tasks.
CustomersHQServer Used by OD HQ. The name of the server that all workstations will use when taking/owning triage tasks.
CustomizedForPracticeWeb
DatabaseConvertedForMySql41
DatabaseGlobalVariablesDontSet Disable setting SQL global variables (Used for hosted databases) Boolean, false by default. When enabled, sql mode and replication status will not be changed. Used for Cloud Hosted Databases. Used for third-party hosted servers. Determines if certain services are skipped. If checked it disables setting SQL global variables. Allows third-party hosted databases to set their own SQL modes and skip over running replication.
DatabaseIntegritiesWhiteList String. Stores the obfuscated DatabaseIntegrites whitelist from the last successful call to HQ.
DatabaseMaintenanceDisableOptimize DBM Disable Optimize bool. Set to false by default. If true, the optimize database maintenance tool will be disabled. If checked, the Optimize Database tool will be disabled. See <a href="https://opendental.com/autoLogin.aspx?token=d83JWerd&redirect=r.htm?databasemaintenance" target="_blank">Database Maintenance</a>
DatabaseMaintenanceSkipCheckTable bool. Set to false by default. If true, database maintenance will skip table checks.
DatabaseMode Deprecated. Was never used. Uses . Defaults to 'Normal'.
DataBaseVersion Example: 25.2.7.0
DateDepositsStarted
DateLastAging
DefaultCCProcs
DefaultClaimForm
DefaultImageImportFolder Default folder for import in images module.
DefaultProcedurePlaceService
DefaultUserGroup Long. 0 by default. Used to assign a user group to a new user that is added by a user who does not have the SecurityAdmin user permission.
DevAutoApproveDevice Boolean. Set to false by default. When set to true, it will no longer be necessary to manually approve devices.
DirectX11ToothChartUseIfAvail Bool. Default true 1. Applies to all computers.
DiscountPlanExamCodes Comma delimited list of procedure codes that represent Exam codes. D Code. Defaults to empty string.
DiscountPlanXrayCodes Comma delimited list of procedure codes that represent X-Ray codes. D Code. Defaults to empty string.
DiscountPlanProphyCodes Comma delimited list of procedure codes that represent Prophylaxis codes. D Code. Defaults to empty string.
DiscountPlanFluorideCodes Comma delimited list of procedure codes that represent Fluoride codes. D Code. Defaults to empty string.
DiscountPlanPerioCodes Comma delimited list of procedure codes that represent Perio codes. D Code. Defaults to empty string.
DiscountPlanLimitedCodes Comma delimited list of procedure codes that represent Limited Exam codes. D Code. Defaults to empty string.
DiscountPlanPACodes Comma delimited list of procedure codes that represent PA codes. D Code. Defaults to empty string.
DisplayRenamedPatFields Boolean. Set to true by default. When true, patient fields that do not have a matching patient field def will display at the bottom of the patient fields with gray text.
DistributorKey Boolean. Set to 1 to indicate that this database holds customers instead of patients. Used by OD HQ. Used for showing extra phone numbers, showing some extra buttons for tools that only we use, behavior of checkboxes in repeating charge window, etc. But phone panel visibility is based on DockPhonePanelShow.
DockPhonePanelShow If this is true, then PrefC.IsODHQ will return true.
DocPath The AtoZ folder path.
DoLimitTaskSignals There is no UI for user to change this. Used by OD HQ. Determines if Task refreshes only update locally. True is local only, false is every workstation.
DomainLoginEnabled Boolean. Determine whether or not to allow users to bypass OpenDentalLogin using ActiveDirectory. Default is false.
DomainLoginForSigBoxes If using domain login, enabling this preference allows switching user using domain credentials in FormProcEdit, FormSheetFillEdit, FrmGroupNote
DomainLoginPath Specifies the path to use when ActiveDirectory or Domain Logins are enabled. Example1: LDAP://DC=maindental, Example2: LDAP://DC=opendental,DC=od. These domains translate to the login formats: maindental\{userName} and {userName}@opendental.od respectfully.
DomainObjectGuid The ObjectGuid of the Active Directory domain object. Set in the Global Security Settings "Domain Path" textbox. Example: 634dd257-3301-48e2-b6d3-9b83daae6bd2.
DoseSpotDateLastAccessCheck The date this customer last checked with HQ to determine which provider have access to eRx.
DxIcdVersion Use ICD-10 Diagnosis Codes The ICD Diagnosis Code version primarily used by the practice. Value of '9' for ICD-9, and '10' for ICD-10. uncheck for ICD-9
DynamicPayPlanLastDateTime For payment plans (formerly known as dynamic payment plans). This only gets updated when charges are issued for payment plans through the background service. It uses this date time to allow it to run exactly once per day. Charges can be manually run for a single payment plan at any time, but that won't affect this pref.
DynamicPayPlanPrepaymentUnearnedType Dynamic payment plan unearned type FK to definition.DefNum Identifies a specific hidden PaySplitUnearnedType to allow unearned money to stay attached to dynamic payment plans (hides this money from the income transfer system). Hides prepayments from income transfer system. Only PaySplit unearned types marked as Do Not Show on Account are listed here.
DynamicPayPlanRunTime Defaults to 9AM. The time the user has specified that they would like the service to run on each day.
DynamicPayPlanStartDateTime The date and time that the service started running today. Will be blank if not currently running.
EasyBasicModules
EasyHideAdvancedIns Depricated.
EasyHideCapitation
EasyHideClinical
EasyHideDentalSchools
EasyHideHospitals
EasyHideInsurance
EasyHideMedicaid
EasyHidePrinters
EasyHidePublicHealth
EasyHideRepeatCharges
EasyNoClinics
EConfirmExcludeDaysUseHQ
EConfirmExcludeDays
EclaimsSeparateTreatProv On e-claims, send treating provider info for each separate procedure
EclaimsSubscIDUsesPatID Use Optional Patient ID "PatID" in place of SubscriberID if this preference is checked. Both 4010 and 5010. Disabled by default for backward compatibility.
EClipboardAllowPaymentOnCheckin Boolean, false by default. When enabled, the patient will be able to make payments and view past statements during checkin.
EClipboardAllowSelfCheckIn Boolean, true by default. Basically enables eClipboard/self-check in. If this is true users can self-check in using the offices set up devices.
EClipboardAllowSelfPortraitOnCheckIn
EClipboardAppendByodToArrivalResponseSms Deprecated. Boolean, false by default. When true, appends an 'eClipboard Check-In Link' (BYOD) to eService Arrival Responses (patient texted 'A' for "I'm here"). Link will allow patient to log into eClipboard to fill out check in Sheets.
EClipboardByodSmsTemplate Deprecated. String. When EClipboardEnableByodSms is true, this template will be used for sending 'eClipboard Check-In Links'.
EClipboardClinicalValidationFrequency Determines how often eClipboard will ask clinicians to reverify using a PIN or BioAuth. -1 Indicates security checks are disabled. This has been made into a global (non-clinic) pref, per Nathan/Sean/Sam.
EClipboardCreateMissingFormsOnCheckIn Boolean, true by default. If this is true, when the patient status is changed to the waiting room status, we will check if there are any forms defined in the office eClipboard settings that the patient is due to fill out and attach those forms to the patient.
EClipboardDoTwoFactorAuth Boolean, false by default. If this is true, when the patient views a sheet, we will text a code to them for 2FA before loading the sheet to add extra security before displaying PHI.
EClipboardEnableByodSms Deprecated. Boolean, false by default. When true, allows user to 'Send eClipboard Check-In Links' (BYOD) via SMS. Link will allow patient to log into eClipboard to fill out check in Sheets.
EClipboardHasMultiPageCheckIn Defaults to false. When true, displays check-in questions on separate pages rather than all on the same page. Only used on eClipboard 24 and earlier.
EClipboardImageCaptureDefs Deprecated. As of 22.1, we store defs in own table, EClipboardImageCaptureDef. Comma deliminated list of DefNums related to DefCat.EClipboardImageCapture
EClipboardMessageComplete Plain text, this is the message we want to show users after they have used the self check-in feature. The default message reads: "You have successfully checked in. Please return this device to the front desk."
EClipboardMessageCompleteWeb Plain text, this is the message we want to show users after they have used the self check-in feature or when finished filling out eforms requested by the office for eClipboard 25 web. The default message reads: "You have successfully submitted the requested information. Thank you."
EClipboardPopupKioskOnCheckIn Boolean, false by default. If this is true, when the front desk manually changes patient status to the waiting room status, this will cause the kiosk manager to automatically pop-up so that the office staff can decide if they want to send the patient to kiosk or eClipboard mode.
EClipboardPresentAvailableFormsOnCheckIn Boolean, true by default. If this is true and the office is using self check-in, if the patient has any "kiosk" forms on their account, we will display those forms on their device for them to fill out.
EClipboardUseDefaults Boolean. Note that this is actually ONLY a clinic pref, as it is meaningless for the default clinic and practices without clinics. Indicates whether or not we should remove a clinics other EClipboard related clinic preferences.
EClipboardClinicsSignedUp The ClinicNums that are signed up for eClipboard. Checked and set periodically by the eConnector. In a comma-delimited list. An empty string indicates no clinics are signed up. If they are not using clinics and are signed up, then this will be 0. But 0 can't otherwise be part of the list.
EClipboardShowPerioGraphical Boolean, default true. When this pref is true, after a perio chart is closed on eClipboard, it will generate and bring up a PDF of the graphical perio chart to display to the patient.
EClipboardWebEmailMessageTemplate Default email message template for eClipboard web emails, stored as a JSON-formatted string. Template property contains the email message template, while the EmailType property corresponds to EmailType enum where 0 is regular, 1 is HTML, and 2 is raw HTML. Available tags are defined in TagReplacer.cs.
EClipboardWebSubjectTemplate Default email subject template for eClipboard web emails. Available tags are defined in TagReplacer.cs.
EClipboardWebTextMessageTemplate Default sms message template for eClipboard web texts. Available tags are defined in TagReplacer.cs.
EClipClinicalAutoLogin Boolean, false by default. When this pref is true, if a clinical QR code is scanned, it will automatically log the current user into eClipboard Clinical. Otherwise it will ask the current user to sign in on the Clinical device.
EConnectorEnabled Deprecated. Boolean, false by default. Will be set to true when the update server successfully upgrades the CustListener service to the eConnector service. This only needs to happen once. This will automatically happen after upgrading past v15.4. If automatically upgrading the CustListener service to the eConnector service fails, they can click Install in eService Setup. NEVER programmatically set this preference back to false.
EConnectorCleanupLoggerIntervalDays Office can set to have the EConnector logger clean itself up every number of days. A value of 0 disables this cleanup. Default value is 0
EConnectorSmsNotificationFrequency long, Indicates, in seconds, how frequently the eConnector will update its Sms Messages cache and insert an SmsNotifications signal.
EConnectorStatistics A JSON string of disparate pieces of information regarding the eConnector.
EFormImportAllergiesAsOther If true, allergies will be imported as "Other". If false, allergies will be imported as true allergies. Default is false.
EFormImportProblemsAsOther If true, problems will be imported as "Other". If false, problems will be imported as true problems. Default is false.
EformsSpaceBelowEachField This is the global default space below each eForm field. It can be overridden for each form using EForm.SpaceBelowEachField and for each field using EFormField.SpaceBelow. Initial value is 20. Can be between 0 and 100.
EformsSpaceToRightEachField This is the global default space to the right of each eForm field. It can be overridden for each form using EForm.SpaceToRightEachField and for each field using EFormField.SpaceToRight. Initial value is 10. Can be between 0 and 100.
EHREmailFromAddress
EHREmailPassword
EHREmailPOPserver
EHREmailPort
EhrRxAlertHighSeverity
ElectronicRxClinicUseSelected Boolean, false by default. When this is set and using eRx it will utilize the currently selected clinic instead of the patient's default clinic.
EHREmailToAddress This pref is hidden, so no practical way for user to turn this on. Only used for ehr testing.
ElectronicRxDateStartedUsing131 Date when user upgraded to 13.1.14 and started using NewCrop Guids on Rxs.
EmailAlertMaxConsecutiveFails No UI for this pref. Number of failed consecutive email send attempts from the eConnector before an alert is shown.
EmailDefaultAddressNum FK to EmailAddress.EmailAddressNum. It is not required that a default be set.
EmailDefaultSendPlatform Enum EmailPlatform stored as string. Determines if the default email sender will be Insecure(standard email), Secure(EmailHosting), or Direct(Secure WebMail). Even though there are more options, only these three are currently supported. While EmailPlatform is a Flags enum, this preference should only be set to single value. Used in ClinicPref table.
EmailDisclaimerIsOn Bool which indicates, where applicable, all emails being sent should have the EmailDisclaimerTemplate appended to the end of the EmailBody.
EmailDisclaimerTemplate String provides template for any email correspondence methods participating in Email Disclaimer. Must include [PostalAddress] tag.
EmailHostingAlias The alias used for email hosting/mass emails.
EmailHostingEndpoint The endpoint used for email hosting/mass emails.
EmailHostingSignatureHtml The signature appended to all mass email/secure email notification emails.
EmailHostingSignaturePlainText The signature appended to all mass email/secure email notification emails.
EmailHostingUseNoReply Default setting in Mass Email Send and EmailMessageEdit windows for whether or not to use the "noreply" default email address when sending mass email or secure email.
EmailInboxComputerName Deprecated. Not used anywhere. Email messages are retreived from Open Dental Service.
EmailInboxCheckInterval Time interval in minutes describing how often to automatically check the email inbox for new messages. Default is 5 minutes.
EmailMasterTemplate String that contains the HTML shell for emails.
EmailNotifyAddressNum FK to EmailAddress.EmailAddressNum. Used for webmail notifications (Patient Portal).
EmailPassword Deprecated. Use emailaddress.EmailPassword instead.
EmailPort Deprecated. Use emailaddress.ServerPort instead.
EmailSecureAlert Boolean. When true, AlertItem rows will be upserted to alert clincis that a new secure email is downloaded.
EmailSecureDefaultClinic Long. The clinic used for Secure Email by clinic 0.
EmailSecureDownloadInterval Indicates, in minutes, how frequently the eConnector should call the EmailHosting API to download received emails.
EmailSecureDownloadTimeoutSeconds Indicates, in seconds, how long to before timeout when downloading a batch of secure email.
EmailSecureStatus Enum. Flags MassEmailStatus. Defaults to None. Used for the clinicpref table. When activated and enabled, this practice or clinic is enabled to send secure emails.
EmailSenderAddress Deprecated. Use emailaddress.SenderAddress instead.
EmailSendExternalManagerTimeoutMs Milliseconds that the eConnector will wait for a response to an email request when using the external process to send emails.
EmailSendExternalTimeoutMs Milliseconds the external process that sends emails, if enabled, will try to send and email before timing out. A timeout will trigger the eConnector to restart the external process, and retry sending the email, for up to 4 minutes.
EmailSMTPserver Deprecated. Use emailaddress.SMTPserver instead.
EmailStatementsSecure PrefValue is of type EmailPlatform, stored as string. Clinic based pref which determines which email platform should be used to send statements during billing.
EmailUsername Deprecated. Use emailaddress.EmailUsername instead.
EmailUseSSL Deprecated. Use emailaddress.UseSSL instead.
EhrEmergencyNow Boolean. 0 means false and means it is not an EHR Emergency, and emergency access to the family module is not granted.
EhrProvKeyGeneratorPath There is no UI for this. It's only used by OD HQ.
EnableAnesthMod
EnableEmailAddressAutoComplete Enable email address auto-complete Enables the auto-complete feature when filling out email addresses in the Email Edit window. In the <a href="https://opendental.com/autoLogin.aspx?token=d83JWerd&redirect=r.htm?emailmessage" target="_blank">Email Message Edit</a> window, suggestions, based on historical emails sent, appear when typing an email address.
EnableXConnect DEPRECATED - Previously enabled the DentalXChange XConnect claim processing for the ClaimConnect clearinghouse on a global basis instead of per clinic. We now use the EnableXConnect clearinghouse db column instead.
EnforceMedicaidIDLength Warns the user if the Medicaid ID is not the proper number of digits for that state.
EnterpriseAllowRefreshWhileTyping Allow Refresh While Typing in Select Patient Window Enables refresh while typing in patient select. True by default. Determines whether the Refresh While Typing checkbox in the <a href="https://opendental.com/autoLogin.aspx?token=d83JWerd&redirect=r.htm?patientselect" target="_blank">Select Patient</a> window can be used.
EnterpriseApptList Enterprise Appointment Lists Applies to these 7 windows: Recall, Confirmation, Planned Appt Tracker, Unsched, ASAP, Ins Verification, Text Messaging. If this preference is turned on , then the "All Clinics" option is hidden, preventing user from clicking on that option and overloading the server. Setting to reduce unnecessary server traffic. If enabled, some windows will not automatically load information while 'Headquarters' is the active Clinic, 'All' option will not be available in Clinic selection boxes, and server load will be reduced.
EnterpriseCommlogOmitDefaults Boolean, false by default. When true, creating commlogs will not have default values preloaded for Type, Mode_, or SentOrReceived fields.
EnterpriseExactMatchPhone # of digits Boolean, false by default. When true search patients only by exact phone number match of x digits. Number of digits from EnterpriseExactMatchPhoneNumDigits pref. Enter a number to determine when to run the exact match if 'Only match patients by exact phone number' is enabled. 10 is the default.
EnterpriseExactMatchPhone Only match patients by exact phone number Boolean, false by default. When true search patients only by exact phone number match of x digits. Number of digits from EnterpriseExactMatchPhoneNumDigits pref. Only used when the 'Store patient phone numbers in a separate table for patient search' preference is also enabled. Useful to speed up the patient search for large databases.
EnterpriseExactMatchPhoneNumDigits # of digits Number of digits in phone number for exact match setting in enterprise setup. Enter a number to determine when to run the exact match if 'Only match patients by exact phone number' is enabled. 10 is the default.
EnterpriseHygProcUsePriProvFee Boolean, false by default. When true, hygiene procedures will use the primary provider's PPO fee rather than the hygienist's.
EnterpriseManualRefreshMainTaskLists Boolean, false by default. When true, manual refreshes are enabled for enterprise.
EnterpriseNoneApptViewDefaultDisabled Boolean, false by default. When true the Appointment 'None' View will not be selected by default when there is at least one existing Appointment view. False preserves current behavior - ie: Appointment 'None' View displays on first load of a clinic for a brand new user in a clinic.
EraAchPaymentType definition.DefNum of category InsurancePaymentType. Zero by default. Used for claimpayments made from ERA ACH payments.
EraAllowTotalPayments ERA allow total payments Boolean, true by default. When true, blocks user from entering ERA payments using By Total payments. otherwise, must be allocated to procedures
EraAutomationBehavior ERA Automation Enum:EraAutomationMode. 1 by default. 0=UseGlobal(not used in the preference table), 1=ReviewAll, 2=SemiAutomatic. Determines if ERAs are processed automatically or manually.<br><br>Review All: All ERAs must be processed manually.<br><br>Semi-automatic: ERAs can be processed with a single click of the Auto Process button on the ERA window. This will receive the claims associated with the ERA and finalize the payment. They can also be processed manually, if needed.<br><br>Fully-automatic: ERAs will be automatically processed when imported, receiving the claims associated with the ERA, and finalizing the payment. If an ERA does not get automatically processed while being imported for any reason, the user can still attempt to process them by clicking the Auto Process button on the ERA window, or process them manually.<br><br>Note: This preference can also be set on a Carrier level. See <a href="https://opendental.com/autoLogin.aspx?token=d83JWerd&redirect=r.htm?carriers" target="_blank">Carriers</a>.
EraAutoPostWriteOff Auto-processing posts write-offs on non-primary claims Enum:EnumEraAutoPostWriteOff. 0 by default. Controls when write-offs will be posted during ERA auto‑processing. 0=PriFromERA (Posts write-offs if the ERA primary indicator is marked), 1=Always (Always posts write-offs), 2=PriFromPlan (Posts write-offs when the insurance plan is marked as primary). Primary from ERA - Write-offs are posted if the ERA primary indicator is marked. Always - Write-offs are always posted, regardless of if the claim is primary, secondary etc. Primary From Plan - Write-offs are posted when the insurance plan is marked as primary.
EraAutoProcessSplitByCarcCodes Auto split ERAs with CARC denial codes listed above Boolean, false by default. When set to true, during auto-processing, if the payment information on an ERA includes any of the codes listed in the preference EraNoAutoProcessCarcCodes for a claim or any of its procedures, the system will split the ClaimProc with the matching Claim Adjustment Reason Codes (CARCs) into a new claim that will not be auto-processed. This allows the original claim to continue auto-processing by applying payment to the remaining ClaimProcs. During auto-processing, if the payment information on an ERA includes any of the Claim Adjustment Reason Codes (CARCs) listed above for a claim or any of its procedures, the system will split the claim's procedures with the matching CARCs into a new claim that will not be auto-processed. This will allow the original claim to continue auto-processing by applying payment to the remaining procedures on the claim.
EraChkPaymentType definition.DefNum of category InsurancePaymentType. Zero by default. Used for claimpayments made from ERA CHK payments.
EraDefaultPaymentType definition.DefNum of category InsurancePaymentType. Zero by default. Used for claimpayments made from ERA payments of types other than ACH, CHK, and FWT. Will also be used for ACH, CHK, and FWT payments if their corresponding preferences aren't set (EraAchPaymentType, EraChkPaymentType, EraFwtPaymentType). If those preferences and this preference aren't set, we look for an InsurancePaymentType definition with the name "EFT" for ACH, "Check" for CHK, and "Wired" for FWT. The claimpayment type is set to zero (undefined) if a match is not found.
EraFwtPaymentType definition.DefNum of category InsurancePaymentType. Zero by default. Used for claimpayments made from ERA FWT payments.
EraPrintOneClaimPerPage Boolean, false by default. When true then there will be 1 page per each claim paid for an ERA header and ERA claim paid on printouts.
EraIncludeWOPercCoPay Boolean, true by default. When true, the ERA 'Verify and Enter Payment' window will post WriteOffs for procedures covered by category percentage or medicaid/flat copay insurance plans. When false, WriteOffs will not be posted for these insurance plan types.
EraNoAutoProcessCarcCodes Don't auto-process claims w/ these CARCs A comma-delimited list of Claim Adjustment Reason Codes (CARCs). Defaults to "97,16,252,242,50,251,B7,226,250", a list provided by NADG. If the payment information on an ERA applies any of the codes in this list to a claim or any of the claim's procedures, ERA auto-processing will not process the claim. There is a caveat to this. If for some reason insurance paid on a claim's procedure and has a CARC code that matches one in this list, ERA auto-processing will continue to process the claim (NADG has encountered this in the real world). Claims assigned these codes often need to be resubmitted with additional documentation, and automatically receiving them with no payment forces users to detach the claim from the check and change the status for the claim and each ClaimProc before resubmitting. Claims and claim procedures with these Claim Adjustment Reason Codes (CARCs) must be manually processed. However, if a procedure gets paid by insurance, then the CARC is ignored. The default CARCs are: 97,16,252,242,50,251,B7,226,250.
EraRefreshOnLoad ERA 835s window refresh data on load Boolean, true by default. When true loads database data for ERAs when loading the ERA 835s window. Enterprise only for now. Determines if ERAs are pre-loaded or if the user must manually refresh data to populate results. When checked, the ERAs window will refresh data automatically. For larger offices concerned about speed, we recommend leaving this unchecked.
EraShowControlIdFilter Boolean, false by default. When true FormEtrans835 allows the user to filter by Control ID and shows the value in a grid column. Otherwise Control ID UI is not visable and can not be used.
EraShowPreAuthClaims If true, the checkbox in the ERA Auto Process Report window will be checked for Show PreAuth ERAs
EraShowStatusAndClinic ERA 835s window show status and clinic information Boolean, true by default. When true FormEtrans835s allows the user to filter by status and clinic and shows the values in a grid column. Otherwise Status and Clinic UI is not visible and can not be used. This makes FormEtrans835s load ERAs faster for large databases. Determines the filter options in the <a href="https://opendental.com/autoLogin.aspx?token=d83JWerd&redirect=r.htm?claimsera835" target="_blank">ERAs</a> window. When enabled, Clinics and Status filters and 'Automatable Carriers Only' checkbox are available in addition to standard filter options. When disabled, these options are hidden, a 'Finalized Only' checkbox is shown, and the ERAs list cannot be sorted by Status or Clinic.
EraShowZeroPaymentClaims If true, the checkbox in the ERA Auto Process Report window will be checked for Show $0 Payment ERAs.
EraStrictClaimMatching ERA 835s use strict claim date matching Boolean, false by default. When true, will use a list of dates instead of a date range when matching claims in Claims.GetClaimFromX12. Determines how dates are matched for ERA processing. If checked, ERA matching will be based on a list of dates. Otherwise, it is based upon a date range. For larger offices concerned about speed, we recommend having this checked.
EserviceLogUploadTimeNext Locally stored DateTime for previous next time, mirrors EServiceAccount column at HQ.
EServiceListenerEnabled Boolean, true by default. Determines whether the econnector is able to accept intranet requests.
ExportPath Claim attachment export path
FamilyBalancerChangedSinceNumDays Int. Number of days before day of runtime to use as the 'ChangedSinceDate' for running automated family balancer.
FamilyBalancerChangedSinceUseLastDayRun Boolean, false by default. When true, uses pref FamilyBalancerLastDayRun as the 'ChangedSinceDate' and when false, uses pref FamilyBalancerChangedSinceNumDays.
FamilyBalancerDateLastRun DateTime. Timestamps the last time the automated family balancer was run.
FamilyBalancerDeleteAllTransfers Boolean, false by default. When true, running automated family balancer will delete all transfers, regardless of date, if they have PayType=0 and Amt=0.
FamilyBalancerEnabled Boolean, false by default. When true, allows automated family balancer to run from OpenDentalService.
FamilyBalancerTimeRun Stored as a DateTime, only TimeOfDay is used to determine when family balancer should run.
FamilyBalancerUseFIFO Boolean, true by default. When true, runs automated family balancer using FIFO. When false, runs as rigorous.
FamPhiAccess Allows guarantor access to all family health information in the patient portal. Default is 1.
FeesUseCache Deprecated.
FinanceChargeAdjustmentType Finance charge adj type
FinanceChargeAPR
FinanceChargeAtLeast
FinanceChargeLastRun
FinanceChargeOnlyIfOver
FixedBenefitBlankLikeZero Fixed benefit fee schedules treat blank entries as zero Boolean. When true, blank fees in a Fixed Benefit type schedule will be treated as a $0 insurance coverage (patient owes the full amount of the PPO fee). When false, blank fees in a Fixed Benefit type schedule will not be treated as $0 insurance coverage(insurance is estimated at the full amount of the PPO fee). Set how blank entries in fixed benefit fee schedules are handled.<br/><br/> Checked: Blank entries are treated as 0.<br/>Example: UCR =$200, PPO Fee = $150, Write-off = 50, Fixed = blank,<br/> Percentage = %100, Patient Portion = $150<br/><br/>Unchecked: Blank entries are treated as 100% the PPO fee.<br/>Example: UCR =$200, PPO Fee = $150, Write-off = 50, Fixed = blank,<br/> Percentage = %100, Patient Portion = $0
FormClickDelay Click delay after opening Appt Edit Double defaults to 0. Prevents clicks from happening in a window. Currently used in ApptEdit to prevent procedures from being attached or detached for delay amount in tenths of a second. Will always be stored in en-US format. or a triple click could accidentally cause a procedure to be added
FuchsListSelectionColor Deprecated.
FuchsOptionsOn Deprecated.
FutureTransDatesAllowed Allow future dated transactions Bool defaults to 0. When false, future dates transactions are not allowed. including patient payments, insurance payments, adjustments, and procedures.
GenericEClaimsForm
GitLabToken Stores an access token for authenticating with the GitLab API.
GlobalUpdateWriteOffLastClinicCompleted Used to store the ClinicNum of the last clinic the global update writeoff tool completed before being paused or interrupted. Only stored if an unrestricted user runs the update for all clinics. When starting the tool again for an unrestricted user and all clinics the tool will pick up on the next clinic (ordered by primary key).
GsmCharSet
GsmExtendedCharSet String. Gsm chars worth 14 bits each
HasVerboseLogging A comma delimited list of computer names. If a computer name is in the list then it has verbose logging on.
HelpKey Encrypted. Has no UI to change it, but status can be viewed in FormSupportStatus. Used to validate whether customer is on support and should have access to Help, Sparks3D, Imaging, etc. See the OpenDentalHelp project.
HL7FolderOut
HL7FolderIn
HQTriageCoordinator Deprecated. Use SiteLink.EmployeeNum instead. Used by HQ. Projected onto wall displayed on top of FormMapHQ
HQVideoToken Only used at Open Dental HQ. Not added with script.
ICD9DefaultForNewProcs procedurelog.DiagnosticCode will be set to this for new procedures and complete procedures if this field was blank when set complete. This can be an ICD-9 or an ICD-10. In future versions, could be another an ICD-11, ICD-12, etc.
ImageCategoryDefault Default Image Category FK to Definition.DefNum. If 0, then it follows old behavior where it uses the top category. for new images when no category selected
ImageCategoryDefault Default Image Category for video capture FK to Definition.DefNum. If 0, then it follows old behavior where it uses the top category. unless a mount is showing
ImagesModuleTreeIsCollapsed (Deprecated) 3-state prefernce used in the image module, state definitions are: 0 = Expand the document tree each time the Images module is visited. 1 = Document tree collapses when patient changes. 2 = Document tree folders persistent expand/collapse per user.
ImagesModuleUsesOld2020 Use old Imaging module interface, pre 2020 Use the old Images module, prior to the 2020 overhaul. Required for Suni capture. False by default. The only interface for changing this is by enabling/disabling Suni. This might be used for certain troubleshooting, but only in a test environment, never for fixing customer issues. not recommended
ImageWindowingMax
ImageWindowingMin
ImagingDefaultScaleValue Scale, pixels per unit Only for documents (images), not mounts. MountDefs have their own place for defaults. Scale, decimal places, and units, separated by spaces. Example: "123.4 0 mm". The first two are required; units is optional. Converted into an ImageDraw of type ScaleValue in a lazy manner. Not created unless needed. for new single images, does not apply to mounts
ImagingOrderDescending Sort images within each category in Imaging module by date created (descending). False by default.
ImeCompositionCompatibility Text boxes use foreign language Input Method Editor (IME) composition Boolean. False by default. When enabled a fix is enabled within ODTextBox (RichTextBox) for foreign users that use a different language input methodology that requires the composition of symbols in order to display their language correctly. E.g. the Korean symbol 'ì—­' (dur) will not display correctly inside ODTextBoxes without this set to true. Determines composition if users are typing in a foreign language that uses an IME keyboard (e.g., Korean, Arabic). Spell Check is disabled when this preference is enabled.
IncomeTransfersMadeUponClaimReceived YN_DEFAULT_FALSE. When enabled (1-Yes), income transfers are automatically made upon receiving a claim. The income transfers are to reallocate patient payments associated to insurance production that has been overpaid to underpaid production on the same claim. Any income transfers made on behalf of this preference will ONLY move money between production associated to the same claim. Money will be transferred to unearned in the event that the entire claim has been overpaid. The default behavior is (0-Unknown) which will defer to the RigorousAccounting preference which will ONLY run when it is set to 0=Fully Enforced. Income transfers will NOT be automatically created when this preference is disabled (2-No).
IncomeTransfersTreatNegativeProductionAsIncome Income transfers treat negative production as income Boolean. True by default. When true, negative production can be transferred to unearned as income via paysplits. When false, income transfers will not be allowed when negative production needs to be allocated. See <a href="https://opendental.com/autoLogin.aspx?token=d83JWerd&redirect=r.htm?incometransfermanager" target="_blank">Income Transfer Manager.</a> Not recommended for offices that pay providers based on collections. If using the FIFO button (rare), then this will also reallocate overpayments.
Ins834DropExistingPatPlans Boolean. False by default. When true, when importing 834s, all patient plans that are not in the 834 will be replaced for the patient.
Ins834ImportPath
Ins834IsEmployerCreate Boolean. True by default. Sets the checkbox for 834 preview that automatically creates employers when importing.
Ins834IsPatientCreate
InsAutoReceiveNoAssign Auto receive claims with no assignment of benefits Boolean. True by default. Automatically marks sent claims and their ClaimProcs Received with $0 payments for insurance subscriptions that don't assign benefits (InsSub.AssignBen is false). Only applies to claims with no payments entered and no received claim procedures.
InsBatchVerifyCheckAnnualMax Boolean. False by default. Controls automated InsVerify behavior. Determines if annual max is checked.
InsBatchVerifyCheckDeductible Boolean. False by default. Controls automated InsVerify behavior. Determines if deductible is checked.
InsBatchVerifyCreateAdjustments Boolean. False by default. Controls automated InsVerify behavior. Determines if adjustments can be created.
InsBatchVerifyChangeInsHist Boolean. False by default. Controls automated InsVerify behavior. Determines if ins history can be changed.
InsBatchVerifyChangeEffectiveDates Boolean. False by default. Controls automated InsVerify behavior. Determines if ins effective dates can be changed.
InsBenBWCodes Comma delimited list of procedure codes that represent bitewing codes. Defaults to D codes for all users.
InsBenExamCodes Comma delimited list of procedure codes that represent exam codes. Defaults to D codes for all users.
InsBenPanoCodes Comma delimited list of procedure codes that represent pano codes. Defaults to D codes for all users.
InsBenCancerScreeningCodes Comma delimited list of procedure codes that represent cancer screening codes. Defaults to D codes for all users.
InsBenProphyCodes Comma delimited list of procedure codes that represent prophy codes. Defaults to D codes for all users.
InsBenFlourideCodes Comma delimited list of procedure codes that represent fluoride codes. Defaults to D codes for all users.
InsBenSealantCodes Comma delimited list of procedure codes that represent sealant codes. Defaults to D codes for all users.
InsBenCrownCodes Comma delimited list of procedure codes that represent crown codes. Defaults to D codes for all users.
InsBenSRPCodes Comma delimited list of procedure codes that represent SRP codes. Defaults to D codes for all users.
InsBenFullDebridementCodes Comma delimited list of procedure codes that represent full debridement codes. Defaults to D codes for all users.
InsBenPerioMaintCodes Comma delimited list of procedure codes that represent perio maint codes. Defaults to D codes for all users.
InsBenDenturesCodes Comma delimited list of procedure codes that represent dentures codes. Defaults to D codes for all users.
InsBenImplantCodes Comma delimited list of procedure codes that represent implant codes. Defaults to D codes for all users.
InsBillingProv 0=Default practice provider, -1=Treating Provider. Otherwise, FK to provider.ProvNum.
InsBlueBookAllowedFeeMethod Enum:InsBlueBookAllowedFeeMethod. 2 by default. 0=Median, 1=Average, 2=MostRecent. The method used by the Blue Book feature for generating estimates.
InsBlueBookAnonShareEnable Enum:InsBlueBookAnonShareEnable 0 by default. 0=Off, 1=OffNoPrompt, 2=On When on, insurance payment data will be anonymously shared with Open Dental for the purpose of making improvements to the Blue Book feature.
InsBlueBookUsePlanNumOverride Bool. True by default. When true, allows insplan.PlanNum to be used in FormInsBlueBookRule hierarchy.
InsBlueBookUcrFeePercent Int. 80 by default. The percentage of the provider fee that will be used as the Allowed amount when the Blue Book provider rule is making an estimate. The 'UCR' term is outdated and misleading. It really means Standard Provider Fee.
InsDefaultCobRule Coordination of Benefits (COB) rule see <a href="https://opendental.com/autoLogin.aspx?token=d83JWerd&redirect=r.htm?cob" target="_blank">Coordination of Benefits</a>
InsDefaultPPOpercent Default new insurance plans to PPO Percentage plan type otherwise, default to 'Category Percentage'
InsDefaultShowUCRonClaims Sets insplan.ClaimsUseUCR to true, which means the provider/office standard fee will show.
InsDefaultAssignBen True if assigning benefits to provider, false if assigning benefits to patients. There is also a Clinic level override.
InsEstRecalcReceived Boolean. False by default. When true, insurance estimates will be recalculated on ClaimProcs even when marked as Received. When false, ClaimProcs marked as Received will not recalculate insurance estimates.
InsHistBWCodes Bitewing Code A procedure code (D code) that represents the default Bitewing code used for insurance prior dates of service. This must be set in order to add a BW InsHist procedure for a patient. The Default Code determines the code used in Insurance History for that category. Code Group shows the available procedure codes that can be used as the Default Code for each category. <br><br> The Default Codes are initially set to: <br><br>-Bitewing: D0272 <br>-Pano/FMX: D0210 <br>-Exam: D0120 <br>-Prophylaxis: D1110 <br>-Full Debridement: D4355 <br>-Perio Maintenance: D4910 <br>-Perio Scaling Code: D4341
InsHistDebridementCodes A procedure code (D code) that represents the default Debridement code used for insurance prior dates of service. This must be set in order to add a Debridement InsHist procedure for a patient. The "s" on the end of this pref is just badly named.
InsHistExamCodes
InsHistPanoCodes A procedure code (D code) that represents the default FMX/Pano code used for insurance prior dates of service. This must be set in order to add a FMX/Pano InsHist procedure for a patient. The "s" on the end of this pref is just badly named.
InsHistPerioMaintCodes A procedure code (D code) that represents the default Perio Maint. code used for insurance prior dates of service. This must be set in order to add a Perio Maint. InsHist procedure for a patient. The "s" on the end of this pref is just badly named.
InsHistPerioLLCodes Only used in API. Everything else uses InsHistPerioScalingCodes combined with quadrant.
InsHistPerioLRCodes Only used in API. Everything else uses InsHistPerioScalingCodes combined with quadrant.
InsHistPerioScalingCode A procedure code (D code) that represents the default Perio Scaling code used for insurance prior dates of service. We combined all four quadrants into using this pref except in API. This must be set in order to add a Perio Scaling InsHist procedure for a patient.
InsHistPerioULCodes Only used in API. Everything else uses InsHistPerioScalingCodes combined with quadrant.
InsHistPerioURCodes Only used in API. Everything else uses InsHistPerioScalingCodes combined with quadrant.
InsHistProphyCodes A procedure code (D code) that represents the default Prophy code used for insurance prior dates of service. This must be set in order to add a Prophy InsHist procedure for a patient. The "s" on the end of this pref is just badly named.
InsOutOfNetworkBlankLikeZero False by default. When true, blank entries in out-of-network fee schedules are treated as zero, resulting in a zero insurance estimate. The default false behavior would cause a blank entry to use the procedure fee for the estimate. Users could go through and enter zeros for those procedure fee schedules, but that's a lot of work.
InsPayNoInitialPrimaryMoreThanProc Prevents users from creating initial primary insurance payments where the sum of the payment and write-off exceed the adjusted procedure fee.
InsPayNoWriteoffMoreThanProc Boolean. True by default. When enabled, disallow writeoffs amount greater than procedure fee.
InsPlanConverstion_7_5_17_AutoMergeYN 0=unknown, user did not make a selection. 1=Yes, 2=No.
InsPlanMergeInProgress String. Empty by default. When not empty, merging InsPlans will be disabled since InsPlans are merging on another machine
InsPlanUseUcrFeeForExclusions Ins plans with exclusions use UCR fee (zero out write-offs) Boolean. False by default. If an insurance plan has an exclusion (example, ins won't pay for a crown), then that procedure would normally show the ins fee schedule amount (example $700). Setting this pref to true will cause the office UCR fee to be used for that procedure instead (example $900). Can be overriden by insurance plan. For in-network insurance plans where certain procedures are allowed to be billed using the UCR fee rather than the negotiated rate. <br/><br/> Exclusions are defined using an Other Benefits Exclusions type, or by setting any benefit set to a 0% coverage level.
InsPlanExclusionsMarkDoNotBillIns Ins plans with exclusions mark as Do Not Bill Ins Boolean. False by default. When true, insurance plans with exclusions are marked as Do Not Bill Ins. only used when "exclusions use UCR fee" above is checked
InsPlansZeroWriteOffsOnAnnualMax Ins plans zero out write-offs when annual max is met can be overridden by plan; also see <a href='https://www.opendental.com/resources/UnitTestsDocumentation.xml#InsPlans_ComputeEstimates_ZeroWriteoffOverAnnualMaxGlobalLevel' target='_blank'>Unit Tests</a> 115-117
InsPlansZeroWriteOffsOnFreqOrAging Ins plans zero out write-offs when frequencies or age limits are met can be overridden by plan; also see <a href='https://www.opendental.com/resources/UnitTestsDocumentation.xml#InsPlans_ComputeEstimates_ZeroWriteoffOverFrequencyGlobalLevel' target='_blank'>Unit Tests</a> 118-123
InsPpoAlwaysUseUcrFee Use UCR fee for billed fee even if PPO fee is higher Boolean. False by default. When enabled, procedure fees will always use the UCR fee.
InsPPOsecWriteoffs Calculate secondary insurance PPO write-offs 0 by default. If false, secondary PPO writeoffs will always be zero (normal). At least one customer wants to see secondary writeoffs. not recommended
InsChecksFrequency Enable Insurance Frequency Checking Boolean, false by default. When true, treatment plan module and appointment scheduling checks for frequency conflicts. Used when calculating insurance estimates. Also determines if the <i>Estimates as of</i> area is displayed in the Treatment Plan Module.
InsurancePlansShared
InsVerifyAppointmentScheduledDays 7 by default. Determines the maximum number of days before displaying an insurance plan that needs to be verified.
InsVerifyAppointmentScheduledDaysMin 0 by default. Determines the minimum number of days before displaying an insurance plan that needs to be verified.
InsVerifyAppointmentScheduledDaysMedicaid
InsVerifyAppointmentScheduledDaysMedicaidMin
InsVerifyBenefitEligibilityDays 90 by default. Number of days before requiring insurance plans to be verified.
InsVerifyBenefitEligibilityDaysMedicaid
InsVerifyDaysFromPastDueAppt 1 by default. Number of days that a past appointment will show in the "Past Due" insurance verification grid.
InsVerifyDaysFromPastDueApptMedicaid
InsVerifyDefaultToCurrentUser Boolean, false by default. When true, defaults a filter to the current user instead of All when opening the InsVerifyList.
InsVerifyExcludePatientClones Boolean, false by default. When true, excludes patient clones from the Insurance Verification List.
InsVerifyExcludePatVerify Boolean, false by default. When true, excludes patient plans associated to insurance plans that are marked "Do Not Verify" from the Insurance Verification List.
InsVerifyFutureDateBenefitYear Boolean, false by default. When true, if an appointment is after the benefit renewal month for the insurance plan, make that InsPlan be reverified and postdate the insverify.DateLastVerified.
InsVerifyFutureDatePatEnrollmentYear Boolean, false by default. When true, if an appointment is after the benefit renewal month for the insurance plan, make that PatPlan be reverified and postdate the insverify.DateLastVerified.
InsVerifyMedicaidFilingCodes
InsVerifyPatientEnrollmentDays 30 by default. Number of days before requiring patient plans to be verified.
InsVerifyPatientEnrollmentDaysMedicaid
InsWriteoffDescript Writeoff description displayed in the Account Module and on statements. If blank, the default is "Writeoff". We are using "Writeoff" since "PPO Discount" was only used for a brief time in 15.3 while it was Beta and no customer requested it
IntermingleFamilyDefault
IntrospectionItems Missing in general. JSON serialized dictionary of K=IntrospectionEntity, V=string that contains testing values meant for overriding release mode values. Should only be present in testing databases. The presence of this preference means the program will be put into "Testing Mode" which is specifically designed for pointing 3rd party bridges and web references to "development" or "testing" URLs. The value of each entity can be treated as "Tag" and does not have to be confined to being a simple string (e.g. can be a serialized object stored as a string). Never directly ask the cache for this preference. Instead, use the Introspection class within the Misc folder of the OpenDentBusiness project in order to access it.
InvoicePaymentsGridShowNetProd Invoice payments grid shows write-offs Preference to show writeoffs in the StatementInvoicePayment grid.
IsAlertRadiologyProcsEnabled OpenDentalService alerts for scheduled non-CPOE radiology procedures True if there is a row in the ehrprovkey table. The OpenDentalService will check this preference and if it is false it will not query the procedurelog table for scheduled non-CPOE radiology procs. When the first row is inserted into the ehrprovkey table, or if there is an existing row when the db is updated, this will be set to true. Otherwise false. Users can manually turn this pref on or off. See <a href="https://opendental.com/autoLogin.aspx?token=d83JWerd&redirect=r.htm?ehrcpoeradapprove" target="_blank">EHR Radiology Order List</a>
IsODTouchEnabled Indicates whether or not a clinic has ODTouch enabled. Will be a preference for clinic 0, otherwise a clinicpref.
ItransImportFields Enum. Flags ItransNCpl.ItransUpdateFields: identifies what carrier fields to update when impotring carriers for ITRANS 2.0.
JobManagerDefaultEmail
JobManagerDefaultBillingMsg
LabelPatientDefaultSheetDefNum
LanguageAndRegion Used to determine how many windows are displayed throughout the program, translation, charting, and other features. Version 15.4.1
LanguagesIndicateNone Initially set to Declined to Specify. Indicates which language from the LanguagesUsedByPatients preference is the language that indicates the patient declined to specify. Text must exactly match a language in the list of available languages. Can be blank if the user deletes the language from the list of available languages.
LanguagesUsedByPatients Comma-delimited list of three-letter language names and custom language names. Example spa for Spanish or fra for French. The custom language names are the full string name and are not necessarily supported by Microsoft. An example value might be "Declined to Specify,spa,fra,Tahitian".
LateChargeAdjustmentType Late charge adj type A long. The DefNum of the Adjustment Type that is used to create late charges.
LateChargeDateRangeStart An integer number of days ago that a statement must be sent on or after to have a late charge applied to it.
LateChargeDateRangeEnd An integer number of days ago that a statement must be sent on or before to have a late charge applied to it.
LateChargeExcludeAccountNoTil A bool. Default setting for excluding guarantors that have not signed a truth in lending agreement from having late charges applied to their family's statements on FormLateCharges.
LateChargeExcludeBalancesLessThan A double. Default setting for excluding accounts below a certain balance from having late charges applied to its statements on FormLateCharges.
LateChargeExcludeExistingLateCharges A bool. Determines whether or not a late charge can be assessed for existing late charge adjustments.
LateChargeLastRunDate A date. The last date that the Late Charge tool was run on FormLateCharges.
LateChargeMax A double. The default maximum late charge that can be applied to a statement on FormLateCharges.
LateChargeMin A double. The default minimum late charge that can be applied to a statement on FormLateCharges.
LateChargePercent An integer. The default percentage of a statement's balance to charge as a late fee on FormLateCharges.
LateChargeDefaultBillingTypes A comma delimited list of DefNums. The default billing types that accounts must have for late charges to be applied to statements on the them on FormLateCharges.
LetterMergePath
LicenseAgreementAccepted A bool. Determines if the License Agreement signature has been logged at HQ. False when it needs to be sent.
LocalTimeOverridesServerTime Boolean. Only used to override server time in the following places: Time Cards.
MainWindowTitle
MassEmailStatus Enum. Flags MassEmailStatus. Defaults to None. Used for the clinicpref table. When activated and enabled, this practice or clinic is enabled to send mass emails.
MassEmailGuid String. The Guid for a clinic's mass email account. Plain text.
MassEmailSecret String. The secret for a clinic's mass email account. Equivalent to an API key or password. Plain text.
MassEmailSignedUp Boolean determining whether a clinic is allowed to use the MassEmail feature re-introduced in job P49014
AdvertisingPostCardGuid String. The guid for a clinic's Advertising - Postcards account.
MeaningfulUseTwo 0=Meaningful Use Stage 1, 1=Meaningful Use Stage 2, 2=Meaningful Use Modified Stage 2. Global, affects all providers. Changes the MU grid that is seen for individual patients and for summary reports.
MedDefaultStopDays Medication Order default days until stop date Number of days after medication order start date until stop date. Used when automatically inserting a medication order when creating a new Rx. Default value is 7 days. If set to 0 days, the automatic stop date will not be entered. 0 for no automatic stop date
MedicalFeeUsedForNewProcs Use medical fee for new procedures New procs will use the fee amount tied to the medical code instead of the ADA code. when cross-coding
MedicationsIndicateNone FK to medication.MedicationNum
MedLabReconcileDone If MedLabReconcileDone=="0", a one time reconciliation of the MedLab HL7 messages is needed. The reconcile will reprocess the original HL7 messages for any MedLabs with PatNum=0 in order to create the embedded PDF files from the base64 text in the ZEF segments. The old method of waiting to extract these files until the message is manually attached to a patient was very slow using the middle tier. The new method is to create the PDF files and save them in the image folder in a subdirectory called "MedLabEmbeddedFiles" if a pat is not located from the details in the PID segment of the message. Attaching the MedLabs to a patient is now just a matter of moving the files to the patient's image folder. All files will now be extracted and stored, either in a pat's folder or in the "MedLabEmbeddedFiles" folder, by the HL7 service.
MiddleTierSerializeNew In 2025, we built a new custom serializer for the MT. We are gradually implementing it. If there are any bugs, the user can uncheck a box in the Prefs Enterprise General section to change it back to the old behavior. If we ever finish the transition and let it stabilize for a while, we could deprecate this pref. One complication to fully implementing this is that different versions might need to talk to each other during an update, so that part might never get changed to use this new serialization.
MiddleTierCacheFees Deprecated. Always false.
MobileAutoUnlockCode
MobileSyncDateTimeLastRun
MobileSynchNewTables79Done Used one time after the conversion to 7.9 for initial synch of the provider table.
MobileSynchNewTables112Done Used one time after the conversion to 11.2 for re-synch of the patient records because a)2 columns BalTotal and InsEst have been added to the patientm table. b) the table documentm has been added
MobileSynchNewTables121Done Used one time after the conversion to 12.1 for the recallm table being added and for upload of the practice Title.
MobileSyncIntervalMinutes
MobileSyncServerURL
MobileSyncWorkstationName
MobileExcludeApptsBeforeDate
MobileUserName
MobileWebClinicsSignedUp
MsgToPayMenuOptionShow Bool. True by default. When true, the Send Message-to-Pay option in the Account Module's Payment dropdown will be shown.
MsgToPaySendThreadFrequency Int. Adjusts RunInterval of MsgToPay in seconds.
MySqlVersion The major and minor version of the current MySQL connection. Gets updated on startup when a new version is detected.
NetProdDetailUseSnapshotToday True by default. Will use the claimsnapshot table for calculating production in the Net Production Detail report if the date range is today's date only.
NewCropAccountId There is no UI for user to change this. Format, if OD customer, is PatNum-(RandomString)(CheckSum). Example: 1234-W6c43. Format for resellers is up to them.
NewCropDateLastAccessCheck The date this customer last checked with HQ to determine which provider have access to eRx.
NewCropIsLegacy DEPRECATED. True for customers who were using NewCrop before version 15.4. True if NewCropAccountId was not blank when upgraded.
NewCropIsLexiData Controls which NewCrop database to use. If false, then the customer uses the First Data Bank (FDB) database, otherwise the customer uses the LexiData database. Connecting to LexiData saves NewCrop some money on the new accounts. Additionally, the RxNorms which come back from the prescription refresh in the Chart are more complete for the LexiData database than for the FDB database.
NewCropName There is no UI for user to change this. For distributors, this is part of the credentials. OD credentials are not stored here, but are hard-coded.
NewCropPartnerName There is no UI for user to change this. For distributors, this is part of the credentials. OD credentials are not stored here, but are hard-coded.
NewCropPassword There is no UI for user to change this. For distributors, this is part of the credentials. OD credentials are not stored here, but are hard-coded.
NewPatThankYouTypedSignatureDisable Boolean. Used for the clinicpref table when clinics are enabled, otherwise used by preference table. False by default so that typed sigs are allowed. When true adds a query parameter to the URL used to retrieve webforms for New Patient Thank Yous that will prevent patients from typing signatures in signature boxes.
NistTimeServerUrl URL of the time server to use for EHR time synchronization. Only used for EHR. Example nist-time-server.eoni.com
NotesProviderSignatureOnly Boolean. False by default. Set true if notes can only be signed by providers. For sheets, this is handled instead at the sheetfield level with IsSigProvRestricted.
OCRClinicsSignedUp Comma delimited list of ClinicNums signed up for OCR scanning. Gets updated from HQ via the nightly sync
ODMobileCacheDurationHours Duration the eConnector will maintain in memory cache of SmsToMobile and SmsFromMobile messages before purging older messages. Stored as hours.
ODTouchDeviceLimit Used for the clinicpref table when clinics are enabled, otherwise used by preference table. Specifies the ODTouch device limit for a given clinic (i.e. the count of devices included with an ODTouch signup). Any devices over this limit are considered surplus and subject to additional charge(s).
OmhNy This is only true for New York Office of Mental Health.
OnlinePaymentsMarkAsProcessed Mark online payments as processed Mark online payments as processed when an eClipboard/patient portal payment is auto-split. otherwise review manually
OpenDentalHelpCaptureFormName Missing in general: When clicking the "?" button with this preference present, the name of the Form (in the code) is placed in the user's clipboard. This helps the documentation team create a document of new forms and their associated manual page.
OpenDentalServiceComputerName Records the name of the computer running OpenDentalService.
OpenDentalServiceHeartbeat Records a heartbeat for OpenDentalService. If the heartbeat is older than 6 minutes, an alert will notify the user.
OpenDentalVendor
OracleInsertId
OrthoAutoProcCodeNum Default Ortho Auto Proc User-defined automatic ortho claim procedure. D8670.auto by default. Can be overridden at the insplan level. Required if using the <a href="https://opendental.com/autoLogin.aspx?token=d83JWerd&redirect=r.htm?orthoautoclaim" target="_blank">Ortho Auto Claims</a> tool. Click [...] to change. This is generally D8670.auto, but any procedure code can be used. <br/> If using a code longer than 5 characters (e.g., D8670.auto), only the first 5 characters (e.g., D8670) are included on claims. Using a procedure code with ".auto" is optional, but doing so is useful to track codes used on auto-generated claims. <br/> The Default Ortho Auto Proc cannot be a banding procedure. This prevents supplemental payments from being applied to the original claim.
OrthoBandingCodes Banding Codes User-defined comma separated string of procedure codes (D codes) that can be attached to ortho cases as banding procedures Codes associated to procedures for placement date of orthodontic appliances.
OrthoCaseInfoInOrthoChart Show Auto Ortho information in the Ortho Chart When turned on, ortho case information is shown in the ortho chart. see <a href="https://opendental.com/autoLogin.aspx?token=d83JWerd&redirect=r.htm?orthoauto" target="_blank">Auto Ortho</a>
OrthoChartLoggingOn This gets turned on to track down bugs in the ortho chart. Saves info to OrthoChartLog table.
OrthoClaimMarkAsOrtho Mark claims as Ortho if they have Ortho procedures Determines whether claims with ortho procedures on them will automatically be marked as Ortho claims. The 'Is Ortho' checkbox in the <a href="https://opendental.com/autoLogin.aspx?token=d83JWerd&redirect=r.htm?claimtabgeneral" target="_blank">Edit Claim - General Tab</a> is automatically checked when a claim or preauthorization includes a procedure in the Orthodonics <a href="https://opendental.com/autoLogin.aspx?token=d83JWerd&redirect=r.htm?inscatssetup" target="_blank">Insurance Category</a>.
OrthoClaimUseDatePlacement When true, ortho claims' "OrthoDate" will be automatically set to the patient's first ortho procedure when created.
OrthoDebondCodes Debond Codes User-defined comma separated string of procedure codes (D codes) that can be attached to ortho cases as debond procedures Codes associated to procedures for removal of orthodontic appliances.
OrthoDebondProcCompletedSetsMonthsTreat Completing Debond procedure overrides months treatment Defines for when a Debond code is completed, if the date from the completed procedure will overwrite the months treatment for the patient. This will also cap the Total Tx Time and Months in Treatment fields for the Auto Ortho Grid to not go above Tx Months Total. When a Debond procedure is set complete, the Tx Months Total is updated and Months in Treatment and Months Rem stop calculating.
OrthoDefaultMonthsTreat Default months treatment Byte, 24 by default. The default number of months ortho treatments last. Overridden by patientnote.OrthoMonthsTreat. Set a default total treatment amount, in months, that shows on the Auto Ortho tab (Tx Months Total). If a patient's insurance plan is set to an ortho claim type of Initial Plus Periodic (Edit Insurance Plan - Ortho tab), this amount is used to determine the end date for generating periodic orthodontic claims using <a href="https://opendental.com/autoLogin.aspx?token=d83JWerd&redirect=r.htm?orthoautoclaim" target="_blank">Ortho Auto Claims</a>.
OrthoEnabled Show Auto Ortho in Account Module There is no global pref to turn on and off all ortho features. This pref was hijacked to show Auto Ortho in Account module. see <a href="https://opendental.com/autoLogin.aspx?token=d83JWerd&redirect=r.htm?orthoauto" target="_blank">Auto Ortho</a><br/>
OrthoInsPayConsolidated Consolidate Ortho Insurance Payments Boolean. When true, blocks the user from entering payments on claims created by the Auto Ortho Tool. When using the Ortho Auto Claims tool, payments must be made on the original ortho claim. Payments cannot be added to claims made using the Ortho Auto Claims tool.
OrthoPlacementProcsList Ortho Placement Procedures Comma delimited list of procedure code CodeNum's, not D codes. These procedures are used as flags in order to determine the Patients' DatePlacement. DatePlacement is the ProcDate of the first completed procedure that is associated to any of the procedure codes in this list. Define which procedures can be considered as the initial orthodontic procedure to calculate the Date Start for <a href="https://opendental.com/autoLogin.aspx?token=d83JWerd&redirect=r.htm?orthoauto" target="_blank">Auto Ortho</a>. If the 'Use the first ortho procedure date as the Date of Placement' preference is enabled this also affects 'Date of Placement' on claims. <br/> If no procedures are defined, Open Dental attempts to use the first procedure within the code span D8000-D8999 as the initial orthodontic procedure.
OrthoShowInChart Show ortho button and tab in Chart module. The button was previously visible to everyone and had no pref.
OrthoVisitCodes Visit Codes User-defined comma separated string of procedure codes (D Codes) that can be attached to ortho cases as visit procedures Codes associated to procedures for periodic maintenance visits.
OutstandingInsReportDateFilterTab Enum:RpOutstandingIns.DateFilterTab. Defaults to DaysOld. Determines which date filter tab to default load in Outstanding Insurance Report.
PasswordsMustBeStrong Passwords must be strong Requires a password to be added when creating a new user. Passwords must be 8 or greater characters and contain at least one number, one uppercase letter, and one lowercase letter.
PasswordsStrongIncludeSpecial Strong passwords require special character Boolean. False by default. When true strong passwords require a special character (Non letter or digit). If the 'Passwords must be strong' preference is enabled, passwords must also contain at least one special character (e.g., #, $, !).
PasswordsWeakChangeToStrong Force password change if not strong Boolean. False by default. When true and PasswordsMustBeStrong is also true users without strong passwords will be prompted to change their password at next login. If the 'Passwords must be strong' preference is enabled, users are required to change their password when logging on if the current password does not meet the requirements.
PatientAllSuperFamilySync Allow syncing patient information to all super family members show "Same for entire super family" checkbox in Edit Patient Information window
PatientCommunicationDateFormat The way that dates should be formatted when communicating with patients. Defaults to "d" which is equivalent to .ToShortDateString(). User editable. Whatever value is in this preference is intended to be passed to DateTime.ToString(). Used in eReminders, eConfirms, manual confirmations, ASAP list texting, and other places.
PatientCommunicationTimeFormat
ERoutingUseHQDefaults
PatientFormsShowConsent
PatientMaintainedOnUserChange Bool, false by default. Global pref. When true, the current patient and module will be maintained when switching OD users.
PatientPhoneUsePhonenumberTable Store patient phone numbers in a separate table for patient search Bool, false by default. If set to true, the patient table phone number values will be synced to the phonenumber table, and stored in the PhoneNumberDigits column with non-digit chars stripped out. The select patient query will use the phonenumber table when searching for a pat by phone number. strips out non-digit characters, useful to speed up the search in large databases
PatientPortalInviteEnabled Boolean. Defaults to false. Used for the clinicpref table, in addition to the preference table. When true, this practice or clinic is enabled to send Patient Portal Invites.
PatientPortalInviteUseDefaults Boolean. Defaults to false. Only used for the clinicpref table, not the preference table. When true, this clinic will use the Patient Portal Invite rules for ClinicNum 0.
PatientPortalNotifyBody Free-form 'Body' text of the notification sent by this practice when a new secure EmailMessage is sent to patient.
PatientPortalNotifySubject Free-form 'Subject' text of the notification sent by this practice when a new secure EmailMessage is sent to patient.
PatientPortalSignedUp Boolean. Defaults to false. True if the office is signed up for patient portal. Currently only set in AutoCommPatientPortalInvites.
PatientPortalURL
PatientSelectFilterRestrictedClinics Boolean. Defaults to false. When false: User can see patients not in their list of restricted clinics when they select clinics="All" in FromPatientSelect.cs. When true: Clinics="All" list in FormPatientSelect.cs will only show patients who have had an appointment at user's unrestricted clinics or are assigned to one of the user's list of unrestricted clinics.
PatientSelectSearchMinChars The number of characters entered into the search fields before filling the grid. 1 by default. The minimum allowed value is 1, maximum allowed is 10. The minimum number of characters entered into a textbox in the patient select window before triggering a search and fill grid. With every textbox text changed event, compares the textbox text length to this pref and if the length is less than this pref a timer is started with interval equal to PatientSelectSearchPauseMs. If the length is >= this pref, the search and fill grid is triggered without waiting. This is 1 to 10 characters. We recommend to try starting with 3.
PatientSelectSearchPauseMs Wait time in milliseconds after a character is entered before grid is filled. 1 by default. The minimum allowed value is 1, maximum allowed is 10,000. The number of milliseconds to wait after the last character is entered into a textbox in the patient select window before triggering a search and fill grid. Only waits this long if the textbox text length is < PatientSelectSearchMinChars. Must be between 1 to 10000 milliseconds. We recommend to try starting with 1500.
PatientSelectSearchWithEmptyParams Search and fill grid with all empty search fields Represents a bool with a third state for 'unset'. Use Yes, No, Unknown enum. If No, don't automatically search and fill the grid of the select patient window when all of the textboxes are blank. If a patient was initially set on load and the user clears the search fields, the previous search results will remain in the grid. The grid will be refilled when data is entered. Three-state checkbox. When indeterminate (filled) it behaves as enabled. Opening the Select Patient window populates the grid before any search fields are entered. Disable to reduce server load by requiring users to click 'Search' before populating the grid if no search terms have been entered.
PatientSelectShowInactive Show Inactive patients by default Boolean. True by default. When true, automatically 'shows inactive patients' in the patient selection window.
PatientSelectUseFNameForPreferred
PatientSelectUsesSearchButton New computers default to ‘Refresh while typing’ in Select Patient window Boolean. This is the default for new computers, otherwise it uses the computerpref PatSelectSearchMode.
PatientSelectWindowShowGetAll Boolean. False by default. When true, mask patient date of birth in ChartModule, FamilyModule, PatientSelect, PatientEdit
PatientDOBMasked
PatientSSNMasked Boolean. True by default. When true, mask patient social security numbers in FamilyModule, PatientSelect, PatientEdit.
PatInitBillingTypeFromPriInsPlan Adding new primary insurance plan to patient sets billing type Boolean. False by default. When true and assigning new primary insurance, the associated patients billing type will be inherited from insPlan.BillingType but changing an existing insurance plan's billing type will not change the patient's billing type
PaymentPortalSubDomain The subdomain for the payment portal that is the first part of the customer's URL. Example: payportal portion of https://payportal.patientviewer.com/?cid=ABC123XYZ.
PaymentsPromptForAutoSplit Deprecated. PaySplitManager enum. 1 by default. 0=DoNotUse, 1=Prompt, 2=Force
PaymentsPromptForPayType Payments prompt for Payment Type 0 by default.1=Prompt users to select payment type when creating new Payments. Determines whether or not a Payment Type is automatically selected when entering a patient payment. If unchecked, the first Payment Type in the list will be selected by default.
PaymentsTransferPatientIncomeOnly Deprecated. Bool, false by default. When true, limit income transfers to the amount of associated patient payments.
PaymentClinicSetting Default Clinic for patient payments PayClinicSetting enum. 0 by default. 0=SelectedClinic, 1=PatientDefaultClinic, 2=SelectedExceptHQ Determines the default clinic for patient <a href="https://opendental.com/autoLogin.aspx?token=d83JWerd&redirect=r.htm?payment" target="_blank">Payment</a> There are three options. <br/><br/> Selected Clinic: Use the clinic selected in the Main Menu under Clinics.<br/><br/> Patient Default Clinic: Use the patient's default clinic set in <a href="https://opendental.com/autoLogin.aspx?token=d83JWerd&redirect=r.htm?patientedit" target="_blank">Edit Patient Information</a>. If the patient's clinic is Unassigned, the default clinic is None.<br/><br/> Selected Except HQ: Use the clinic selected in the Main Menu, unless it is Headquarters. In that case, use the patient's clinic.
PaymentClinicSetting Patient Payments Use PayClinicSetting enum. 0 by default. 0=SelectedClinic, 1=PatientDefaultClinic, 2=SelectedExceptHQ Determines the default clinic for patient <a href="https://opendental.com/autoLogin.aspx?token=d83JWerd&redirect=r.htm?payment" target="_blank">Payment</a>. There are three options. <br/><br/> Selected Clinic: Use the clinic selected in the Main Menu under Clinics.<br/><br/> Patient Default Clinic: Use the patient's default clinic set in <a href="https://opendental.com/autoLogin.aspx?token=d83JWerd&redirect=r.htm?patientedit" target="_blank">Edit Patient Information</a>. If the patient's clinic is Unassigned, the default clinic is None.<br/><br/> Selected Except HQ: Use the clinic selected in the Main Menu, unless it is Headquarters. In that case, use the patient's clinic.
PaymentsCompletedDisableMerchantButtons Boolean, true by default. When true, merchant buttons are disabled for an already complete cc payment entry.
PaymentWindowDefaultHideSplits When true, the payment window does not show paysplits by default.
PayPeriodIntervalSetting Int. Represents PayPeriodInterval enum (Weekly, Bi-Weekly, Monthly).
PayPeriodPayAfterNumberOfDays Int. If set, represents the number of days after the pay period the pay day is.
PayPeriodPayDateBeforeWeekend Boolean. True by default. If true, pay days will fall before weekends. If false, pay days will fall after weekends.
PayPeriodPayDateExcludesWeekends Boolean. True by default. Pay Day cannot fall on weekend if true.
PayPeriodPayDay Int. If set to 0, it's disabled, but any other number represents a day of the week. 1:Sunday, 2:Monday etc...
PayPlanAdjType Payment Plan adj type Long. Stores the defnum of the neg adjustment type chosen to use for pay plan adjustments default.
PayPlanHideDueNow Pay Plan charge logic bool. Set to false by default. If true, the "Due Now" column will be hidden from pay plans grid in acct module. Determines how charges and credits for Patient Payment Plans show in the patient account ledger and whether they affect balances, aging, and reports. This logic does not apply to insurance payment plans and will continue to use the old logic: <br><br><FONT COLOR='RED'>Do Not Age (Legacy):</FONT> Payment plan debits (amounts due) and payments only show within the payment plan and will not affect balance or aging. <br>-Payment plan debits are totaled in the Payment Plans grid under Due Now. <br>-Payment plan payments do not show in the ledger but in the payment plan. Double-clicking the plan row is the only way to view payment plan payments. <br>-One payment plan credit (PayPln) will show as a single line item in the patient account ledger, thus reducing the total account balance by the amount. The credit amount is based on the Tx Completed Amt set in the payment plan. <br>-Other payment plan credits, debits, and payments do not show in the ledger nor do they affect balances or aging. <br>-The total A/R in the Aging of A/R report will not include payment plan due amounts. <br>-Only changes to the Tx Completed Amount affect aging and production and income reports. <br>-Payment plan amounts are not included on the Receivables Breakdown Report. <br><FONT COLOR='RED'>Age Credits and Debits (Default):</FONT> Payment plan debits, credits, and payments will show as line items in patient account ledger and affect balances and aging. <br>When the patient is in the same family as the payment plan guarantor, the behavior is as follows. <br>-Payment plan amounts due (PayPln: Debit) and credits (PayPln: Credit) show as line items in the patient account ledger. <br>-Payment plan payments show in the account ledger. <br>-Payment plan due amounts are included the patient's balance. <br>-Payment plan amounts due and payments are considered when calculating aging. <br>-Payment plan credits and debits are included on the Receivables Breakdown report. <br>-Changes made to historical payment plan charges will affect historical information (e.g. Aging of A/R, Production and Income reports). <br>When the patient is in a different family than the payment plan guarantor, the behavior is as follows. <br>-Payment plan amounts due (PayPln: Debit) show as line items in the guarantor's account ledger. <br>-Payment plan credits (PayPln: Credit) show as line items in the patient's account ledger. <br>-Payment plan payments show in the guarantor's account ledger. <br>-Payment plan due amounts are included in the guarantor's balance. <br><FONT COLOR='RED'>Age Credits Only:</FONT> Patients are credited for payment plans when the credit comes due, but debits all exist separately from the account ledger. <br>-Each payment plan credit line item will show in the account ledger, sorted by Tx Credit date. <br>-Payment plan amounts due only show in the Payment Plan grid. They do not show in the account ledger. <br>-Payment plan amounts due will not be considered when calculating balances and aging. <br>-Payment plan credits and debits will not be included on the Receivables Breakdown report. <br>-Changes made to historical payment plan credits will affect historical information (e.g. Aging of A/R, Production and Income reports). <br><FONT COLOR='RED'>No Charges to Account (Rarely Used):</FONT> Patients are not credited for payment plans so the account balance is aged normally. <br>-Payment plan amounts due only show in the Payment Plan grid. They do not show in the account ledger. <br>-Payments to payment plans show in ledger and payment plan. <br>-Payment plan amounts will not be included on the Receivables Breakdown report. <br><br>See <a href="https://opendental.com/autoLogin.aspx?token=d83JWerd&redirect=r.htm?paymentplanpatientfaq" target="_blank">Payment Plan Q and A</a> for additional details.
PayPlanRequireLockForAPR Require full lock to save a Payment Plan if there is an APR entered Boolean. True by default. If false, allows the payment plan window to not require the full lock box to be checked before saving. Disabling this preference allows all Terms of a saved Payment Plan to change even when an APR has been entered.
PayPlansBillInAdvanceDays Days in advance to bill payment plan amounts due When doing billing or printing statements, this is the number of days in advance to consider pay plan charges. Cannot be used with Dynamic Payment Plans. Usually 10 or 15, causes statements to be triggered to print. Only used with Old Payment Plans.
PayPlanItemDateShowProc
PayPlansIncludeInGlobalLock Boolean. True by default. If true, payment plans are included the global lock, preventing edits.
PayPlansExcludePastActivity Boolean. False by default. If true, payment plan window will exclude past activity in the amortization grid by default.
PayPlansUseSheets Pay Plans use Sheets for printing See Setup, Sheets
PayPlansVersion Pay Plan charge logic The Payment Plan version that the customer is using. Derives from PayPlanVersions enum. Valid values are 1, 2, 3 or 4. 1 is legacy(Do Not Age) 2 is the default(Age Credits and Debits). Determines how charges and credits for <a href="https://opendental.com/autoLogin.aspx?token=d83JWerd&redirect=r.htm?paymentplanpatient" target="_blank">Patient Payment Plans</a> show in the patient account ledger and whether they affect balances, aging, and reports.<br/><br/> Do Not Age (Legacy): Payment plan debits (amounts due) and payments only show within the payment plan and do not affect balance or aging. Payment plan debits are totaled in the Payment Plans grid under Due Now. Payment plan payments do not show in the ledger but in the payment plan. Double-clicking the plan row is the only way to view payment plan payments. One payment plan credit (PayPln) shows as a single line item in the patient account grid, reducing the total account balance by the amount. The credit amount is based on the Tx Completed Amt set in the payment plan. Other payment plan credits, debits, and payments do not show in the account grid nor do they affect balances or aging. The total A/R in the Aging of A/R report does not include payment plan due amounts. Only changes to the Tx Completed Amount affect aging and production and income reports. Payment plan amounts are not included on the <a href="https://opendental.com/autoLogin.aspx?token=d83JWerd&redirect=r.htm?reportreceivablesbreakdown" target="_blank">Receivables Breakdown Report</a>. <br/><br/> Age Credits and Debits (Default): Payment plan debits, credits, and payments show as line items in patient account grid and affect balances and aging. Payment plan amounts due (PayPln: Debit) and credits (PayPln: Credit) show as line items in the patient account grid. Payment plan payments show in the account grid. Payment plan due amounts are included the patient's balance. Payment plan amounts due and payments are considered when calculating aging. Payment plan credits and debits are included on the Receivables Breakdown report. Changes made to historical payment plan charges affect historical information (e.g.. Aging of A/R, Production and Income reports).<br/><br/> Age Credits Only: Patients are credited for payment plans when the credit comes due, but debits all exist separately from the account ledger. Each payment plan credit line item shows in the account grid, sorted by Tx Credit date. Payment plan debits only show in the Payment Plan grid. They do not show in the account grid. Payment plan amounts due are not considered when calculating balances and aging. Payment plan credits and debits are not included on the Receivables Breakdown report. Changes made to historical payment plan credits affect historical information (e.g., Aging of A/R, Production and Income reports).<br/><br/> No Charges to Account (Rarely Used): Payment plans have no affect on account balance. Payments to payment plans show in ledger and payment plan. Payment plan amount is not removed from aging. Payment plan amounts are not included on the Receivables Breakdown report.
PayPlanSaveSignedToPdf False by default. If true, when a PayPlan is signed from eClipboard a PDF will be generated and saved.
PayPlanTermsAndConditions
PaymentPortalMsgToPayEmailMessageTemplate Default email message template for Message-to-Pay emails. Not used by BillingL.
PaymentPortalMsgToPaySubjectTemplate Default email subject template for Message-to-Pay emails.
PaymentPortalMsgToPayTextMessageTemplate Default sms message template for Message-to-Pay texts.
PaymentPortalReceiptEmailBodyTemplate Default email body template for receipt emails.
PaymentPortalReceiptEmailSubjectTemplate Default email subject template for receipt emails.
PayTypeMessageToPay Long. FK to def.DefNum, in category PaymentType. Default payment type for payments made through the payment portal where the user arrived via a Message-To-Pay url. If 0, continues to use whatever payment method was default.
PdfLaunchWindow PDF files always launch in a separate window False by default. If true, PDF files will not preview with a single click. They will open with double-click. This might help with RDP. can help with Remote Desktop
PearlDateTimeLastUsed The last date and time an image was sent to Pearl. Used to report to HQ once per day which clinics are using Pearl. Used for the clinicpref table when clinics are enabled, otherwise used by preference table.
PerioColorCAL
PerioColorFurcations
PerioColorFurcationsRed
PerioColorGM
PerioColorMGJ
PerioColorProbing
PerioColorProbingRed
PerioDefaultProbeDepths Contains perio exam measurement values for every tooth. Must be exactly 192 digits or empty (if no default has been set yet).
PerioRecessionInsteadOfGM True by default. If true, the term "Gingival Margin" will be replaced with the term "Recession" within the Perio Chart in most cases. But we will still leave it as Gingival Margin if any GMs are positive.
PerioRedAttGing
PerioRedCAL
PerioRedFurc
PerioRedGing
PerioRedMGJ
PerioRedMob
PerioRedProb
PerioSkipMissingTeeth Enabled by default. When a new perio exam is created, will always mark all missing teeth as skipped.
PerioTreatImplantsAsNotMissing Enabled by default. When a tooth with an implant procedure completed will not be skipped on perio exams
PerVisitInsAmountProcCode Defines the procedure code to use for insplan.PerVisitInsAmount. Empty string by default. The Procedure code is usually set for 100% coverage. When an appt is scheduled or set complete, a new proc gets created with this code.
PerVisitPatAmountProcCode Patient copay procedure code Defines the procedure code to use for insplan.PerVisitPatAmount. Empty string by default. The Procedure code is usually set to default to "Do Not Bill to Ins". When an appt is scheduled or set complete, a new proc gets created with this code. Amounts are entered in the 'Edit Insurance Plan' window. The patient procedure code is usually set to default to "Do Not Bill to Ins", while the Insurance procedure code is set for 100% coverage. When an appointment is scheduled or set complete, one or two new procedures get created with these codes.
PlannedApptDaysFuture Can be any int. Defaults to 0.
PlannedApptDaysPast Can be any int. Defaults to 365.
PlannedApptTreatedAsRegularAppt
PracticeAddress
PracticeAddress2
PracticeBankNumber
PracticeBillingAddress
PracticeBillingAddress2
PracticeBillingCity
PracticeBillingPhone
PracticeBillingST
PracticeBillingZip
PracticeCity
PracticeDefaultBillType
PracticeDefaultProv
PracticeFax In USA and Canada, enforced to be exactly 10 digits or blank.
PracticeIsMedicalOnly This preference is used to hide/change certain OD features, like hiding the tooth chart and changing 'dentist' to 'provider'.
PracticePayToAddress
PracticePayToAddress2
PracticePayToCity
PracticePayToPhone
PracticePayToST
PracticePayToZip
PracticePhone In USA and Canada, enforced to be exactly 10 digits or blank.
PracticeST
PracticeTitle
PracticeZip
RamqMachineID Canada Quebec clearinghouse RAMQ "Machine ID". RAMQ can only support up to 100,000 of these IDs. Therefore, these must be office database level IDs, not per computer.
RamqMachinePassword Canada Quebec clearinghouse RAMQ "Machine Password". The password which accompanies RamqMachineID.
RamqMachinePasswordDate Canada Quebec clearinghouse RAMQ date RamqMachinePassword was acquired. Must be renewed every 90 days.
ShowPreferedReferrals Boolean. False by default. If true, checks "Preferred only" in FormReferralSelect.
PortalWebEmailTemplateType Enum:EmailType 0=Regular 1=Html 2=RawHtml. Used to determine format for email for patient portal web mail messages.
PopupsDisableTimeSpan String of TimeSpan format: days.HH:mm:ss. Empty string by default. Only used in FormPopupEdit. The value is added to the current date in order to suggest a DateTime for Date Disabled. Empty string means no automatic disabling.
PregnancyDefaultCodeValue This is the default pregnancy code used for diagnosing pregnancy from FormVitalSignEdit2014 and is displayed/set in FormEhrSettings. When the check box for BMI and BP not taken due to pregnancy Dx is selected, this code value will be inserted into the diseasedef table in the column identified by the PregnancyDefaultCodeSystem (i.e. diseasedef.SnomedCode, diseasedef.ICD9Code). It will then be a FK in the diseasedef table to the associated code system table.
PregnancyDefaultCodeSystem
PrePayAllowedForTpProcs YN_DEFAULT_FALSE. Indicates whether prepayments are allowed on TP procedures.
PrepaymentUnearnedType Dynamic payment plan unearned type FK to definition.DefNum Identifies a specific hidden PaySplitUnearnedType to allow unearned money to stay attached to dynamic payment plans (hides this money from the income transfer system). Hides prepayments from income transfer system. Only PaySplit unearned types marked as Do Not Show on Account are listed here.
PrintStatementsAlphabetically Prints statements alphabetically by patients last name then first name within the billing window. If false, it will print each clinic together and then within each clinic, it will be alphabetized.
PriProvDefaultToSelectProv Pri Prov defaults to 'Select Provider' in Patient Edit and Add Family windows In Patient Edit and Add Family windows, the Primary Provider defaults to 'Select Provider' instead of the practice provider. require user to select a provider
ProblemsIndicateNone FK to diseasedef.DiseaseDefNum
ProblemListIsAlpabetical Deprecated. Also spelled wrong.
ProcCodeListSortOrder Determines default sort order of Proc Codes list when accessed from Lists -> Procedure Codes. Enum:ProcCodeListSort, 0 by default.
ProcCodeListShowHidden In FormProcCodes, this is the default for the ShowHidden checkbox.
ProcEditRequireAutoCodes Require use of suggested auto codes Users must use suggested auto codes for a procedure. otherwise, a user is allowed to chart the mismatched code
ProcFeeUpdatePrompt Procedure fee update behavior Determines if and how we want to update a procedures ProcFee when changing providers. 0 - No prompt, don't change fee (default), 1 - No prompt, always change fee, 2 - Prompt - When patient portion changes, 3 - Prompt - Always When changing the provider on a procedure, set the behavior for updating the procedure fee, if different. Fees are not updated on completed procedures if the date is earlier than today.
ProcLockingIsAllowed Procedure locking is allowed see<a href="https://opendental.com/autoLogin.aspx?token=d83JWerd&redirect=r.htm?procedurelocking" target="_blank"> Procedure Lock</a>
ProcNoteConcurrencyMerge Bool. Still used in mobile app, but deprecated and ignored for OD Proper because we use FrmProcNoteMerge to always show conflicts. This pref will be deprecated for mobile when they add a window to show the second user their merged note. For mobile, defaults to false. Handles the concurrency situation where two different users save procedure notes and the first note gets overwritten by the second. It merges the two notes together. This was a pref that was originally added as a paid feature by a customer.
ProcNoteSigsBlockedAutoNoteIncomplete Boolean, false by default. When true, users will be blocked from adding a signature to a procedure note or group note if there are incomplete autonotes. They will also be blocked from skipping/removing autonote prompts.
ProcPromptForAutoNote Procedures Prompt For Auto Note True by default. Allows for substituting AutoNote text for [[text]] segments in a procedure's default note. If there is an Auto Note on the default Completed Note or TP'd Note for the procedure code, users are automatically prompted to fill out the Auto Note when opening the procedure.
ProcProvChangesClaimProcWithClaim Changing treating provider updates Claim Proc provider If this is on, the claimproc's provider will inherit the provider on the procedure. If this is off AND the claimproc is attached to a claim, then the claimproc's provider and the procedure's provider are saved separately. Most users will keep this on so their providers stay in sync. Pref created for customers who manually change claimproc Prov so they can have income attributed for specific prov for financial reasons. Leave this checked to prevent provider mismatches. See <a href="https://opendental.com/autoLogin.aspx?token=d83JWerd&redirect=r.htm?claimprocedureprovider" target="_blank">Claimproc Provider</a>.<br><br>Claim procedures not attached to a claim (e.g. for insurance estimates) always inherit the procedure provider.
ProcessSigsIntervalInSecs Process signal interval in seconds. Leave blank to disable autorefresh Frequency at which signals are processed. Also used by HQ to determine triage label refresh frequency. Leave blank to disable autorefresh. The interval, in seconds, that Open Dental will automatically refresh the Appointments Module, task lists, and text notifications. This is usually every 6 to 20 seconds. Leave blank to disable auto refresh.
ProcGroupNoteDoesAggregate If true, when a group note is created by right clicking on one or multiple procedures, then any existing notes from those procedures will be aggregated together with carriage returns.
ProgramAdditionalFeatures DEPRECATED DateTime. Next date that the advertising programming properties will automatically check.
ProgramLinksDisabledForWeb Hidden preference, no UI to edit this list, but it is present in all databases. Comma delimited list of ProgramNames for programlinks that are disabled in Web mode for various reasons. This can also contain string names for other disabled bridges, for example NewCrop. We can manually edit this list.
ProgramVersionLastUpdated Deprecated. Use updatehistory table instead. Stored the DateTime of when the ProgramVersion preference last changed.
ProgramVersion Deprecated. Use updatehistory table instead. Stored the DateTime of when the ProgramVersion preference last changed.
PromptForSecondaryClaim Boolean, true by default. When true, checks for "Unsent" or "Hold for Primary" secondary claims and automates the claim's status.
ProviderIncomeTransferShows
ProviderPayrollAllowToday Bool. Defaults to true. When true, allow the Provider Payroll report to select Today's date in the date range.
PublicHealthScreeningSheet Was never used. Was supposed to indicate FK to sheet.Sheet_DEF_Num, so not even named correctly. Must be an exam sheet. Only makes sense if PublicHealthScreeningUsePat is true.
PublicHealthScreeningUsePat Was never used. Always 0. Boolean. Work for attaching to patients stopped 11/30/2012, there is currently no access to change the value of this preference. When in this mode, screenings will be attached to actual PatNums rather than just freeform text names.
QuickBooksClassRefs Comma-delimited list of strings. Each entry represents a QuickBooks "class" which is used to separate deposits (typically by clinics). Empty by default.
QuickBooksClassRefsEnabled Boolean, off by default. Some users have clinics enabled but do not want QuickBooks to itemize their accounts. Class Refs are a way for QuickBooks to itemize if set up correctly.
QuickBooksCompanyFile
QuickBooksDepositAccounts Comma-delimited list of strings. Each entry represents a QuickBooks deposit account.
QuickBooksIncomeAccount Comma-delimited list of strings. Each entry represents a QuickBooks income account.
RadiologyDateStartedUsing154 Date when user upgraded to or past 15.4.1 and started using ADA procedures to count CPOE radiology orders for EHR.
RandomPrimaryKeys Boolean. True if random primary keys have been turned on. There is no interface to change this preference because as of 17.2, all users of replication must use primary key offset instead of random primary keys. Causes all CRUD classes to look for an unused random PK before inserting instead of leaving it up to auto incrementing.
ReactivationContactInterval Integer. Indicated by number of days between contact attempts.
ReactivationCountContactMax long. -1=infinite, 0=zero; if stored as -1, displays as "".
ReactivationDaysPast Defaults to 1095. -1 indicates min for all dates
ReactivationEmailFamMsg
ReactivationEmailMessage
ReactivationEmailSubject
ReactivationGroupByFamily Boolean. False by default.
ReactivationPostcardFamMsg
ReactivationPostcardMessage
ReactivationPostcardsPerSheet Integer. 3 by default.
ReactivationStatusEmailed FK to definition.DefNum. Uses the existing RecallUnschedStatus DefCat.
ReactivationStatusEmailedTexted FK to definition.DefNum. Uses the existing RecallUnschedStatus DefCat.
ReactivationStatusMailed FK to definition.DefNum. Uses the existing RecallUnschedStatus DefCat.
ReactivationStatusTexted FK to definition.DefNum. Uses the existing RecallUnschedStatus DefCat.
ReadOnlyServerCompName Use Separate Read-Only Server When using a distinct read only server, stores the server name. Note: Open Dental Cloud users cannot change Read-Only Server Setup.<br><br>If you would like to run certain database processes (read queries and cache refreshes) on a different server and database, enter settings here.<br><br>If your main connection is Middle Tier, then the decision to use Direct Connection or Middle Tier for your Read-Only server will happen on your Middle Tier server. The results will still come in through your main Middle Tier connection.<br><br>This is useful for larger offices that may experience slowness or that want to avoid the possibility of heavy queries locking up the database.<br><br>See <a href="https://opendental.com/autoLogin.aspx?token=d83JWerd&redirect=r.htm?../site/troubleshootingslowness" target="_blank">Troubleshooting Slowness</a> for additional information on processes that utilize Read-Only Server Setup.
ReadOnlyServerDbName When using a distinct read only server, stores the database name.
ReadOnlyServerSslCa String which stores SSL certificate for SkySQL.
ReadOnlyServerMySqlUser When using a distinct read only server, stores the mysql username.
ReadOnlyServerMySqlPassHash When using a distinct read only server, stores the hashed mysql password.
ReadOnlyServerURI URI When using a distinct read only server over middle tier, stores the uri. The currently logged in user's credentials will be used when accessing the Middle Tier database.
RecallAdjustDown
RecallAdjustRight
RecallAgeAdult Defaults to 12 for new customers. The number in this field is considered adult. Only used when automatically adding procedures to a new recall appointment.
RecallCardsShowReturnAdd
RecallDaysFuture -1 indicates min for all dates
RecallDaysPast -1 indicates min for all dates
RecallEmailFamMsg
RecallEmailFamMsg2
RecallEmailFamMsg3
RecallEmailMessage
RecallEmailMessage2
RecallEmailMessage3
RecallEmailSubject
RecallEmailSubject2
RecallEmailSubject3
RecallExcludeIfAnyFutureAppt
RecallGroupByFamily Boolean.
RecallMaxNumberAutoReminders long. -1=infinite, 0=zero; if stored as -1, displays as ""
RecallMaxNumberReminders long. -1=infinite, 0=zero; if stored as -1, displays as "".
RecallPostcardFamMsg
RecallPostcardFamMsg2
RecallPostcardFamMsg3
RecallPostcardMessage
RecallPostcardMessage2
RecallPostcardMessage3
RecallPostcardsPerSheet
RecallShowIfDaysFirstReminder Integer, 15 by default - Days since the first reminder was sent out before we try to send another one out. A value of -1 means disabled and a value of 0 is show all for the recall list. WebSchedRecalls will be prevented from sending if the value is not set to an integer greater than 0.
RecallShowIfDaysSecondReminder Integer, 30 by default - Days since the second reminder (or more) was sent out before we try to send another one out. A value of -1 means disabled and a value of 0 is show all for the recall list. WebSchedRecalls will be prevented from sending if the value is not set to an integer greater than 0.
RecallStatusEmailed
RecallStatusEmailedTexted
RecallStatusMailed
RecallStatusTexted
RecallTypeSpecialChildProphy Used if younger than 12 on the recall date.
RecallTypeSpecialPerio
RecallTypeSpecialProphy
RecallTypesShowingInList Comma-delimited list. FK to recalltype.RecallTypeNum.
RecallUseEmailIfHasEmailAddress If false, then it will only use email in the recall list if email is the preferred recall method.
RecurringChargeFailedEmailTemplateBody Contains the email body text for automatic emails sent when recurring charges have failed.
RecurringChargeFailedEmailTemplateSubject Contains the email subject text for automatic emails sent when recurring charges have failed.
RecurringChargeFailedEmailTemplateType Enum:EmailType 0=Regular 1=Html 2=RawHtml. Determines email format for emails sent when recurring charges have failed.
RecurringChargeFailedListAutoSendEmail Boolean, false by default. When true, sends patient an automatic email when a recurring charge fails from FormCreditRecurringCharges.
RecurringChargeFailedServiceAutoSendEmail Boolean, false by default. When true, sends patient an automatic email when a recurring charge fails from OD Service.
RecurringChargesAllowedWhenNoPatBal Allow recurring charges to run even if no family balance present Boolean, true by default. Allows recurring charges even when the Patient balance is 0 or less on the account. Determines whether or not the 'Run charge even if no family balance present' checkbox is an available option in the Credit Card Edit window.
RecurringChargesAutomatedLastDateTime The last time automated recurring charges was run.
RecurringChargesAutomatedEnabled Recurring charges run automatically Bool, false by default. If true, then OpenDentalService will run recurring charges on a set schedule.
RecurringChargesAutomatedTime Recurring charges run time Stored as a DateTime, but only the time portion is used. This time will be when recurring charges are automatically run. This should be set to run after Repeating charges run time and Pay Plan run time.
RecurringChargesBeginDateTime Stored as DateTime, but cleared when recurring charges tool finishes. The DateTime will be used as a flag to signal other connections that recurring charges have started and prevents OpenDentalService from running repeating charges.
RecurringChargesInactivateDeclinedCards Automatically inactivate declined cards Boolean, true by default. Automatically deactivates recurring charge when a credit card is declined so that office does not waste money running them again. recommend checked
RecurringChargesPayTypeCC Stored as a long, defaults to 0. Default recurring payment charge type. When the value is 0, it will use the program property payment type. Does not apply to ACH payments.
RecurringChargesShowInactive Recurring charges show inactive charges by default Defaults to false. Set the default state of checkShowInactive in FormCreditRecurringCharges.
RecurringChargesUsePriProv Recurring charges use primary provider instead of FIFO Bool, 0 by default. When true, recurring charges will use the primary provider of the patient when creating paysplits. When false, the provider that the family is most in debt to will be used. only used when the Allocations setting for Paysplits is set to 'Manual'
RecurringChargesUseTransDate Recurring charges use transaction date Bool, 0 by default. When true, uses the transaction date for the recurring charge payment date. When false, the recurring charge date will be used as the recurring charge payment date. otherwise, use the date the charge is scheduled to process
RedirectShortURLsFromHQ Comma delimited list of redirect short urls that need to be excluded when users are sending out email communications to patients. Typically looks like this: 1dent1.com,2park7.com,2th111.com. OD HQ supplies and maintains this list. Each of these URLs is part of a patient-specific link, so we don't want anyone accidentally pasting these into another patient comm.
RefundAdjustmentType FK to definition.DefNum, defaults to 0. Determines the adjustment type to be used for refund adjustments by default.
RegistrationKey 16 char alphanumeric, generated by OD at time of sale. Applies to single office.
RegistrationKeyIsDisabled Boolean set to true by OD staff in rare situations. For example, issued a replacement key, so old key disabled. Not disabled when someone goes off support. We use pref.HelpKey for that.
RegistrationNumberClaim
RenaissanceLastBatchNumber
RepeatingChargesAutomated Repeating charges run time Bool, false by default. When true, the repeating charges tool will run automatically on a daily basis. this should be set to run before Recurring charges
RepeatingChargesAutomatedTime Time, 08:00 am by default. Defines the time of day that the repeating charges tool will run if set to run automatically.
RepeatingChargesBeginDateTime Stored as DateTime, but cleared when repeating charges tool finishes. The DateTime will be used as a flag to signal other connections that repeating charges have started and prevents another connection from running simultaneously. In order to run repeating charges, this will have to be cleared, either by the connection that set the flag when repeating charges finishes or by an update query.
RepeatingChargesLastDateTime DateTime, the last date and time repeating charges was run.
RepeatingChargesRunAging Bool, true by default. When true, the repeating charges tool will run aging after posting charges.
ReplaceExistingBlockout Bool, 0 by default. When on, the user will be prompted to overwrite existing blockouts when making a new blockout that overlaps the existing ones.
ReplicationFailureAtServer_id If replication has failed, this indicates the server_id. No computer will be able to connect to this single server until this flag is cleared.
ReplicationUserQueryServer The PK of the replication server that is flagged as the "report server". If using replication, "create table" or "drop table" commands can only be executed within the user query window when connected to this server.
ReplicationWriteReadDelayEnabled Replication Write Read Delay Boolean, false by default. When enabled, causes an artificial delay between writing to and reading from the database in certain window: so far just Claim Edit and Enter Payment. This is to allow enough time for database replication so that the read doesn't return stale data. When enabled, causes an artificial delay between writing to and reading from the database in the Claim Edit and Enter Payment windows. This allows enough time for database replication to avoid returning stale data.
ReplicationWriteReadDelayMS Integer, 5 by default. When Replication write/read delay is enabled, dictates the number of milliseconds the program will sleep prior to reading recent changes back out from the database.
ReportFolderName
ReportingServerCompName When using a distinct reporting server, stores the server name.
ReportingServerDbName When using a distinct reporting server, stores the database name.
ReportingServerMySqlUser When using a distinct reporting server, stores the mysql username.
ReportingServerMySqlPassHash When using a distinct reporting server, stores the hashed mysql password.
ReportingServerSslCa Used for connecting to Maria DB SkySQL.
ReportingServerURI When using a distinct reporting server over middle tier, stores the uri.
ReportPandIhasClinicBreakdown Boolean, on by default.
ReportPandIhasClinicInfo Boolean, off by default.
ReportPandIschedProdSubtractsWO
ReportsDoShowHiddenTPPrepayments Boolean, false by default. Used to allow a user to display hidden treatment planned prepayments in the payment report.
ReportsIncompleteProcsExcludeCodes Comma delimited list of procedure codes (D codes) that will be excluded from the Incomplete Procedure Notes report.
ReportsIncompleteProcsNoNotes Bool. False by defualt, used to filter incomplete procedures by having no note in the Incomplete Procedures Report.
ReportsIncompleteProcsUnsigned Bool. False by defualt, used to filter incomplete procedures by having a note that is unsigned in the Incomplete Procedures Report.
ReportsPPOwriteoffDefaultToProcDate Tri-state enumeration. 0 by default. Determines which date is used when calculating certain reports. 0=Insurance payment date. 1=Procedure Date. 2=Claim Date/Payment Date.
ReportsWrapColumns Bool. False by defualt, used to wrap columns when printing a custom report.
ReportsShowHistory Bool. False by defualt, used to determine whether the reports progress bar will show a history or not.
ReportsShowPatNum
RequiredFieldColor
RigorousAccounting Paysplits Allocation Tri-state enumeration. 1 by default. 0=Fully Enforced. 1=Auto-split but don't enforce rigorous accounting. 2=Don't auto-split and don't enforce. Determines whether or not users are forced to allocate patient payments to procedures and unearned income. Also sets Paysplits setting in <a href="https://opendental.com/autoLogin.aspx?token=d83JWerd&redirect=r.htm?allocationssetup" target="_blank">Allocations Setup</a>.<br/><br/> Rigorous: Open Dental automatically suggests payment splits (paysplits) allocated to procedures, procedure treating provider, default clinic, and default unearned income types. Users can modify suggested paysplits, but are required to allocate to production (procedures or adjustments) or an unearned income type. Pay Plan Credits are also required to be attached to procedures.<br/><br/> Auto-Split Only: Open Dental automatically suggest paysplits allocated to procedure treating provider, default clinic, and default unearned income types, but user can modify splits or choose to remove allocations to procedures or unearned income types.<br/><br/> Manual: Paysplits must be manually created and may optionally be allocated to production or unearned income. If no paysplits are added, a single, unallocated paysplit is automatically created when the payment is posted to the account. The provider assigned to the paysplit defaults to the patients' primary provider and the Clinic is determined by 'Default Clinic for patient payments', found in Account - Payments, which may differ from the Clinic and provider of outstanding charges.
RigorousAdjustments Adjustments Allocation Tri-state enumeration. 1 by default. 0=Fully Enforced. 1=Auto-link but don't enforce. 2=Don't auto-link and don't enforce. Determines whether clinic and provider of adjustments match clinic and provider of attached procedures. Also determines whether attaching adjustments to procedures is required or optional. Setting only applys when creating new adjustments or editing existing adjustments. Also sets Adjustments setting in Allocation Setup. Attaching adjustments through the Procedure Edit Window always assigns the procedure clinic and provider to the adjustment. <br/><br/> Rigorous: Attaching procedures to adjustments is required. Clinic and provider assigned are the same as procedure. Users with the Setup security permission may edit the adjustment to assign a different clinic and provider than the attached procedure.<br/><br/> Link Only: Clinic and provider assigned are the same as procedure. Users may edit the adjustment to assign a different clinic and provider than the attached procedure.<br/><br/> Manual: The patient's default clinic and provider are assigned to the adjustment. Users may edit the adjustment to assign to the same clinic and provider as the procedure.
RxHasProc Defaults to false. When true, will require procedure code to be attached to controlled prescriptions.
RxHideProvsWithoutDEA Defaults to false. When true will remove providers with no DEA number from list of providers to pick from when printing Rx sheets.
RxSendNewToQueue Deprecated. Was never meant for production. WebsApps uses this pref specifically for testing.
SalesTaxAdjustmentType Sales Tax adj type FK to definition.DefNum. Represents default adjustment types for sales tax adjustments.
SalesTaxDefaultProvider Sales Tax default provider FK to provider.ProvNum. 0 by default. Determines the global default provider to use when calculating sales tax. for sales tax adjustments and procedures
SalesTaxDoAutomate Automate Sales Tax Boolean. False by default. Determines whether sales tax is automatically applied. as procedures are completed, if the Procedure Code is marked 'Auto Tax', then add sales tax
SalesTaxPercentage Sales Tax percentage
SalesTaxProcCode Procedure Code string for the procedure we want to represent Sales Tax.
SameForFamilyCheckboxesUnchecked In Patient Edit window, no more smart checking for the 5 Same for Entire Family checkboxes and the Same for Entire Super Family checkbox. Just always unchecked. User can still check.
SaveDXCAttachments Boolean. 1 by default. Allows users to choose if they want to save a copy of any attachments they send to DXC.
SaveDXCSOAPAsXML Boolean. 0 by default. Allows users to choose if they want to save a copy of any attachments they send to DXC.
SaveEDSAttachments Boolean. 1 by default. Allows users to choose if they want to save a copy of any attachments they send to EDS.
ScannerCompression
ScannerResolution
ScannerSuppressDialog
ScheduleProvEmpSelectAll Set to 1 by default. Selects all providers/employees when loading schedules.
ScheduleProvUnassigned
ScreeningsUseSheets Boolean. Off by default so that users will have to opt into utilizing the screening with sheets feature. Screening with sheets is extremely customized for Dental3 (D3)
SecurityBadgesRequirePassword Default true. When logging in with a badge, require a password. If false, then swiping the badge gets you directly in without further action. This is lower security, but some offices might like it.
SecurityGroupForInstructors UserGroupNum for Instructors. Set only for dental schools in dental school setup.
SecurityGroupForStudents UserGroupNum for Students. Set only for dental schools in dental school setup.
SecurityLockDate Aka Global Lock Date.
SecurityLockDays Set to 0 to always grant permission. 1 means only today.
SecurityLockIncludesAdmin Lock includes administrators Global Lock limitation applies to users with the Security Admin permission. See <a href="https://opendental.com/autoLogin.aspx?token=d83JWerd&redirect=r.htm?securitylockdates" target="_blank">Security Lock Dates.</a>
SecurityLogOffAfterMinutes Set to 0 to disable auto logoff.
SecurityLogOffAllowUserOverride Boolean. False by default. Allows users to set their own automatic logoff times.
SecurityLogOffWithWindows
SendEmailsInDiffProcess Indicates if emails should be sent from a different process when sending through the eConnector. Stored using the YN enum. 0 is unknown, 1 is yes, and 2 is no.
SendUnhandledExceptionsToHQ Automatically submit unhandled exceptions Bool. True by default. When enabled and user is on support and on the most recent stable or on any beta version a BugSubmissions will be reported to HQ. Unhandled Exception errors will automatically be sent to Open Dental headquarters. This is done in the background securely and no PHI is sent. Errors are only sent for offices on the latest stable version or using any beta version.<br/><br/>
ServicesHqDoNotConnect HQ only. If true, then nobody should connect to the serviceshq database.
ServicesHqDatabase HQ only. Database name for the serviceshq database.
ServicesHqServer HQ only. Server name for the serviceshq database.
ServicesHqMySqlUser HQ only. MySQL user for the serviceshq database.
ServicesHqMySqpPasswordObf HQ only. Obfuscated password for the serviceshq database.
SheetsDefaultChartModule FK to sheetdef.SheetDefNum. The default chart module layout sheetdef.
SheetsDefaultConsent The DefNum for the default sheet def to use for Consent sheets
SheetsDefaultDepositSlip The DefNum for the default sheet def to use for DepositSlip sheets
SheetsDefaultExamSheet The DefNum for the default sheet def to use for ExamSheet sheets
SheetsDefaultInvoice The DefNum for the default sheet def to use for Invoice statement sheets
SheetsDefaultLabSlip The DefNum for the default sheet def to use for LapSlip sheets
SheetsDefaultLabelAppointment The DefNum for the default sheet def to use for LabelAppointment sheets
SheetsDefaultLabelCarrier The DefNum for the default sheet def to use for LabelCarrier sheets
SheetsDefaultLabelPatient The DefNum for the default sheet def to use for LabelPatient sheets
SheetsDefaultLabelReferral The DefNum for the default sheet def to use for LabelReferral sheets
SheetsDefaultLimited The DefNum for the default sheet def to use for Limited statement sheets
SheetsDefaultMedicalHistory The DefNum for the default sheet def to use for MedicalHistory sheets
SheetsDefaultMedLabResults The DefNum for the default sheet def to use for MedLabResults sheets
SheetsDefaultPatientForm The DefNum for the default sheet def to use for PatientForm sheets
SheetsDefaultPatientLetter The DefNum for the default sheet def to use for PatientLetter sheets
SheetsDefaultPaymentPlan The DefNum for the default sheet def to use for PaymentPlan sheets
SheetsDefaultReceipt The DefNum for the default sheet def to use for Receipt statement sheets
SheetsDefaultReferralLetter The DefNum for the default sheet def to use for ReferralLetter sheets
SheetsDefaultReferralSlip The DefNum for the default sheet def to use for ReferralSlip sheets
SheetsDefaultRoutingSlip The DefNum for the default sheet def to use for RoutingSlip sheets
SheetsDefaultRx The DefNum for the default sheet def to use for Rx sheets
SheetsDefaultRxInstruction The DefNum for the default sheet def to use for RxInstruction sheets
SheetsDefaultRxMulti The DefNum for the default sheet def to use for RxMulti sheets
SheetsDefaultScreening The DefNum for the default sheet def to use for Screening sheets
SheetsDefaultStatement The DefNum for the default sheet def to use for Statement sheets
SheetsDefaultTreatmentPlan The DefNum for the default sheet def to use for TreatmentPlan sheets
ShortCodeApptReminderTypes Deprecated. Set to 0 by default. ClinicPref, indicates which ApptReminderTypes should use Short Codes.
ShortCodeOptInClinicTitle
ShortCodeOptInOnApptComplete Used for SMS, not just short codes. Set to true by default. No longer used on appt complete, but instead only used to show an opt-in prompt when changing texting settings in FormPatientEdit.
ShortCodeOptInOnApptCompleteOffScript Set by HQ. Script occurs when office turns off the SMS opt in prompt for a clinic/practice. Informs the user that by turning the prompt off, they agree to still have the opt in conversation with the patient and patients with Unknown status will be set to Yes.
ShortCodeOptInScript A script for the dentist to read to a patient for opting in to receive appointment reminders via SMS.
ShortCodeOptedOutScript A script for the dentist to read to a patient who has previously opted out of receiving apptointment reminders via SMS.
ShowAccountFamilyCommEntries Show family commlog entries by default
ShowAllocateUnearnedPaymentPrompt Set to 1 by default. Prompts user to allocate unearned income after creating a claim.
ShowAutoDeposit Insurance payments create auto deposit Set to 0 by default. Preference that controls if the auto deposit group box shows or not in FormClaimPayEdit.cs when <a href="https://opendental.com/autoLogin.aspx?token=d83JWerd&redirect=r.htm?claimpayfinalize" target="_blank">Finalizing an Insurance Payment</a>, automatically create deposits.
ShowFeatureEhr
ShowFeatureEnterprise Set to 0 by default. Controls if the Enterprise Setup Window will be available.
ShowFeatureGoogleMaps Set to 1 by default. Shows a button in Edit Patient Information that lets users launch Google Maps.
ShowFeatureLateCharges Set to 0 by default. When 0, the Late Charges tool is hidden, and the Billing/Finance Charges tool is accessable. When 1 the Late Charges tool is accessable, and the Billing/Finance Charges tool is hidden.
ShowFeatureMedicalInsurance
ShowFeaturePatientClone Patient Clone Set to 1 to enable the Synch Clone button in the Family module which allows users to create and synch clones of patients. Turn on <a href="https://opendental.com/autoLogin.aspx?token=d83JWerd&redirect=r.htm?patientclone" target="_blank">Patient Clones</a>
ShowFeatureReactivations Set to 1 to enable the Reactivations tab in the Recall list.
ShowFeatureSuperfamilies Super Families Turn on <a href="https://opendental.com/autoLogin.aspx?token=d83JWerd&redirect=r.htm?superfamily" target="_blank">Super Family</a> feature.
ShowFeeSchedGroups Show Fee Schedule Groups Set to 0 by default. For enterprise users. When enabled users can setup Fee Schedule Groups so that whenever a Fee Schedule in a clinic is edited it will automatically update that fee schedule for the other clinics in that group. See <a href="https://opendental.com/autoLogin.aspx?token=d83JWerd&redirect=r.htm?feeschedulegroups" target="_blank">Fee Schedule Groups</a>
ShowIDinTitleBar Show ID in title bar 0=None, 1=PatNum, 2=ChartNumber, 3=Birthdate None: No ID is displayed. <br/><br/>PatNum: Patient Number automatically assigned in Edit Patient Information.<br/><br/>ChartNumber: Usually blank. Alternative and supplemental to PatNum. Can be alphanumeric. Usually set during conversion or when bridging to imaging software. <br/><br/>Birthdate: Patient's date of birth.
ShowIncomeTransferManager
ShowPlannedAppointmentPrompt Prompt for Planned Appointment Boolean. True by default. If true then the user might be prompted to create a planned appointment when leaving the Chart Module. when leaving the Chart Module and a patient has procedures that were treatment planned today
ShowPreferredPronounsForPats Boolean. True by default. If true then users are able to show pronouns that do not necessarily match gender.
ShowProgressNotesInsteadofCommLog
ShowProviderPayrollReport Deprecated. Was used to hide the provider payroll report before users had the ability to remove it from the production and income listbox.
ShowUrgFinNoteInProgressNotes
SignatureAllowDigital If enabled, allow users to digitally sign procedures, proc notes, etc. ESign/DigitallySign means clicking to sign instead of using a stylus to write out a signature. Sigboxes can be restricted to only be signed by providers using Pref.NotesProviderSignatureOnly or SheetFieldDef.IsSigProvRestricted. In those cases, the E button for digitally signing won't be visible unless a provider is signed in. Defaults to true. Does not apply to sheets at all. Sheets have a separate setting in SheetFieldDef.CanElectronicallySign for more control.
SignalInactiveMinutes Disable signal interval after this many minutes of user inactivity Used to stop signals after a period of inactivity. A value of 0 disables this feature. Default value of 0 to maintain backward compatibility. Once mouse or keyboard is detected on an inactive workstation, it quickly and elegantly catches up with the signals that happened in the interim. Yes, it might still need to process hundreds of thousands of signals, but it can do so very quickly because it consolidates dupicates. More importantly, it only sets data objects to null to signal that they need to be loaded the next time they are needed. So it's a lazy load approach that is blazing fast. While it's inactive, it does continue to process critical signals such as shut down. It can also continue to process appointment signals based on the value in ApptModuleRefreshesEveryMinute. Leave blank to disable. This setting is designed to limit the load on database from idle users. Enter the minutes of workstation inactivity that will cause Open Dental to stop sending automatic signals to refresh information. To continue to update the Appointments Module on an idle workstation, enable the preference, ‘Refresh every 60 seconds’.
SignalLastClearedDate Only used on startup. The date in which stale signalods were removed.
SmsContractDate Blank if not signed. Date signed. For practice level contract, if using clinics see Clinic.SmsContractDate. Record of signing also kept at HQ.
SmsContractName (Deprecated) Blank if not signed. Name signed. For practice level contract, if using clinics see Clinic.SmsContractName. Record of signing also kept at HQ.
SmsMonthlyLimit Always stored in US dollars. This is the desired limit for SMS outbound messages per month.
SoftwareName Name of this Software. Defaults to 'Open Dental Software'.
SolidBlockouts
SpellCheckIsEnabled
StatementAccountsUseChartNumber
StatementAutoSendEmail Enum: StatementAutoSendMode, Yes=0, No=1, Prompt=2. Used to determine whether or not to automatically send/prompt an email when a statement is generated.
StatementAutoSendSMS Enum: StatementAutoSendMode, Yes=0, No=1, Prompt=2. Used to determine whether or not to automatically send/prompt a text when a statement is generated.
StatementsCalcDueDate Days to calculate due date usually 10 or 15, leave blank to show "Due on Receipt"
StatementShowCreditCard Deprecated. Not used anywhere. This preference was only used with non-sheet statements.
StatementShowNotes Show payment notes.
StatementShowAdjNotes
StatementShowProcBreakdown Show procedure breakdown Show payment breakdown on Statements. Will not show on Invoices. shows in the Description column as patient portion, insurance paid, write-off, adjustment, etc.
StatementShowReturnAddress
StatementSummaryShowInsInfo Deprecated. Not used anywhere.
StatementsUseSheets Deprecated. Not used anywhere. All statements now use sheets.
StopWebCamSnapshot Used by OD HQ. Indicates whether WebCamOD applications should be sending their images to the server or not.
StoreCCnumbers Deprecated. We no longer allow storing of credit card numbers.
StoreCCtokens Automatically store credit card tokens for use with XCharge, PayConnect, PaySimple, and EdgeExpress.
SubscriberAllowChangeAlways
SuperFamSortStrategy Super family sorting strategy Determines the order of super family names as they appear in the Family Module.<br/>.<br/>NameAsc: Sort by last names in ascending alphabetical order (A-Z).<br/><br/>NameDesc: Sort by last names in descending alphabetical order (Z-A).<br/><br/>PatNumAsc: Sort by patient numbers in ascending order. The patient with the lowest number will be first, followed by patients with higher numbers.<br/><br/>PatNumDesc: Sort by patient numbers in descending order. The patient with the highest number will be first, followed by patients with lower numbers.
SuperFamNewPatAddIns
SupplementalBackupEnabled Defaults to true, unless BackupReminderLastDateRun is disabled (more than a decade into the future). When true, supplemental backups will be executed from the eConnector and copied to HQ as a last resort recovery solution.
SupplementalBackupDateLastComplete Defaults to MinVal (0001-01-01 00:00:00). Last date and time supplemental backup was successful.
SupplementalBackupNetworkPath Blank by default. Designed to be set to a network path (UNC) to another computer on the network. A local copy of the supplemental backup file will be placed here as a secondary measure for last resort recovery. A copy of the supplemental backup will be placed here before uploading to HQ. This way customers with databases larger than 1GB can make use of our backup system.
SupplementalBackupUploadMaxByteCount Deprecated. Moved to the supplementalbackups database. Used by OD HQ. Never added to db convert script. The maximum number of bytes allowed per backup upload respectively.
SupplementalBackupUploadTimeoutSeconds Deprecated. Moved to the supplementalbackups database. Used by OD HQ. Never added to db convert script. The timeout in seconds of a backup upload from the time the upload begins.
TaskAncestorsAllSetInVersion55
TaskAttachmentCategory Stores the image category that task attachment documents will be saved to. If 0, user will be unable to add or edit task attachments, just view existing attachments. 0 by default
TaskCategoryShow Boolean. False by default. When True, shows task.Category as a category combo in the Task Edit window and adds a "Category" column in the main tasklist grid for all task lists.
TaskListAlwaysShowsAtBottom
TasksCheckOnStartup Deprecated. Not used anywhere. Previously used for the popup window to show how many new tasks for cur user after login.
TasksForApptAllowMultiple Boolean. True by default. If false, prevents users from attaching multiple tasks to an appointment.
TasksGlobalFilterType Determines how Tasks will be filtered from root node positions in UserControlTasks, i.e. when viewing a tab without having selected a TaskList.
TasksNewTrackedByUser If true use task.Status to determine if task is new. Otherwise use task.IsUnread.
TasksShowOpenTickets
TaskSortApptDateTime Boolean. 0 by default. Sets appointment task lists to use special logic to sort by AptDateTime.
TasksUseRepeating Boolean. Defaults to false to hide repeating tasks feature if no repeating tasks are in use when updating to 16.3.
TempFolderDateFirstCleaned Keeps track of date of one-time cleanup of temp files. Prevents continued annoying cleanups after the first month.
TerminalClosePassword
TextMsgOkStatusTreatAsNo If true, treat Yes-No-Unknown status of Unknown as if it were a No.
TextOptOutSendNotification If true, then this prompts the office to send an opt out notification text to the patient when changing a patient's 'Text OK' status from 'Yes' (not from unknown) to 'No'. Default is false to not prompt or send any text.
TextingDefaultClinicNum
TextPaymentLinkAppointmentBalance String. Template for sending a payment text for appointment balance.
TextPaymentLinkAccountBalance String. Template for sending a payment text for account balance.
ThankYouTitleUseDefault Boolean, default is false. Only used by the clinicpref table. If true, the practice level ApptThankYouCalendarTitle will be displayed.
ThemeSetByUser Deprecated.
TimeCardADPExportIncludesName
TimeCardOvertimeFirstDayOfWeek 0=Sun,1=Mon...6=Sat
TimecardSecurityEnabled
TimeCardShowSeconds Boolean. 0 by default. When enabled, FormTimeCard and FormTimeCardMange display H:mm:ss instead of HH:mm
TimeCardsMakesAdjustmentsForOverBreaks
TimeCardsUseDecimalInsteadOfColon bool
TimecardUsersCantEditPastPayPeriods Users can not edit their own time card for past pay periods.
TimecardUsersDontEditOwnCard
TitleBarClinicUseAbbr Use clinic abbreviation in main title bar (clinics must be turned on) Boolean, false by default. When enabled, main title of FormOpenDental uses clinic abbr instead of description Enable <a href="https://opendental.com/autoLogin.aspx?token=d83JWerd&redirect=r.htm?clinics" target="_blank">Clinics</a> in <a href="https://opendental.com/autoLogin.aspx?token=d83JWerd&redirect=r.htm?showfeatures" target="_blank">Show Features</a>.
TitleBarShowSite Show Site (public health must also be turned on) see <a href="https://opendental.com/autoLogin.aspx?token=d83JWerd&redirect=r.htm?publichealth" target="_blank">Public Health</a>
TitleBarShowSpecialty Show patient specialty in main title bar and Account, Select Patient area. Boolean. 0 by default. When enabled, Main title bar and Account module patient select grid will display the Patient's specialty.
ToothChartExternalProcess Tooth Chart uses external process to generate on the eConnector.Stores a YN enum.
ToothChartMoveMenuToRight Deprecated. Not used anywhere.
TpPrePayIsNonRefundable Prepayments for TP procedures are non-refundable. When appointment is broken that has one of these payments, payment will go to the broken appointment procedure instead of remaining on the TP procedures.
TpUnearnedType FK to definition.DefNum. The default unearned type that will be used for prepayments attached to tp procedures.
TransworldDateTimeLastUpdated The date and time when the OpenDentalService last sent update messages for account debits and credits.
TransworldServiceSendFrequency Determines how often account activity is sent to Transworld. Default is once per day at the time of day set in the TransworldServiceTimeDue pref. User can adjust this to be more or less frequent.
TransworldServiceTimeDue The time of day for the OpenDentalService to update Transoworld (TSI) with all payments and other debits and credits for families where the guarantor has been sent to TSI for collection.
TransworldPaidInFullBillingType FK to definition.DefNum. Billing type the OpenDentalService will change guarantors to once an account is paid in full.
TreatFinderProcsAllGeneral Boolean, true by default. When enabled, all procedures considered in the treatment finder report will count towards general benefits.
TreatmentPlanNote
TreatPlanDiscountAdjustmentType Procedure discount adj type when a procedure with a <a href="https://opendental.com/autoLogin.aspx?token=d83JWerd&redirect=r.htm?treatmentplandiscounts" target="_blank">Discount </a> attached is set complete<br/> set in <a href="https://opendental.com/autoLogin.aspx?token=d83JWerd&redirect=r.htm?definitionsadjtypes" target="_blank">Definitions: Adj Types</a>
TreatPlanDiscountPercent Set to 0 to clear out previous discounts.
TreatPlanItemized Show itemized fees only when printing
TreatPlanPriorityForDeclined
TreatPlanPromptSave When saving Treatment Plans, prompt for name change True by default. Prompt user with name suggestion when saving a treatment plan. otherwise, it uses a default name
TreatPlanSaveSignedToPdf When a TP is signed a PDF will be generated and saved. If disabled, TPs will be redrawn with current data (pre 15.4 behavior).
TreatPlanShowCompleted
TreatPlanShowGraphics No longer used
TreatPlanShowIns
TreatPlanSortByTooth This preference merely defines what FormOpenDental.IsTreatPlanSortByTooth is on startup. When true, procedures in the treatment plan module sort by priority, date, toothnum, surface, then PK. When false, does not sort by toothnum or surface. True by default to preserve old behavior.
TreatPlanUseSheets Deprecated. All new TPs use sheets as of 17.1. Old Printing for classic sheets is handled by ContrTreat.cs bool DoPrintUsingSheets.
TriageCalls Used by OD HQ. Not added to db convert script. Number of calls in triage.
TriageCallsWarning Used by OD HQ. Not added to db convert script. Number of calls in triage before yellow alert.
TriageRedCalls Used by OD HQ. Not added to db convert script. Number of red calls in triage.
TriageRedTime Used by OD HQ. Not added to db convert script. Minutes behind on red calls.
TriageTime Used by OD HQ. Not added to db convert script. Minutes behind on calls for red alert.
TriageTimeWarning Used by OD HQ. Not added to db convert script. Minutes behind on calls for yellow alert.
TrojanExpressCollectBillingType DEPRECATED. Moved to the Trojan Express Collect program link properties.
TrojanExpressCollectPassword DEPRECATED. Moved to the Trojan Express Collect program link properties.
TrojanExpressCollectPath DEPRECATED. Moved to the Trojan Express Collect program link properties.
TrojanExpressCollectPreviousFileNumber DEPRECATED. Moved to the Trojan Express Collect program link properties.
UnschedDaysFuture Can be any int. Defaults to 0.
UnschedDaysPast Can be any int. Defaults to 365.
UnscheduledListNoRecalls Do not allow recall appointments on the Unscheduled List Bool, true by default, prevents recall appointments from being sent to the Unscheduled List.
UpdateAlterLargeTablesDirectly Hidden preference, no UI to enable this and is missing in most databases. Use GetStringNoCache() to get the value of this preference. If this preference exists and is set to 1, altering large tables will not use the large table helper method of creating a copy of the table structure, altering the empty copy, and then inserting all of the rows from the original table. Instead, the alter table method will be run directly on the large table.
UpdateCode
UpdateInProgressOnComputerName
UpdateMultipleDatabases Described in the Update Setup window and in the manual. Can contain multiple db names separated by commas. Should not include current db name.
UpdateServerAddress
UpdateShowMsiButtons
UpdateDateTime The next update date and time, set in FormUpdateSetup. When this is set in the future, the main form's title bar will count down to the set time.
UpdateStreamLinePassword Use GetStringNoCache() to get the value of this preference.
UpdateWebProxyAddress
UpdateWebProxyPassword
UpdateWebProxyUserName
UpdateWebsitePath
UpdateWindowShowsClassicView
UseAlternateOpenFileDialogWindow Hidden preference, no UI to enable this feature, but is present in all databases. Boolean. Set to true to make file selection windows use the flag ".ShowHelp=true;". Added as attemped fix to stop lockups when importing images.
UseBillingAddressOnClaims
UseInternationalToothNumbers Enum:ToothNumberingNomenclature 0=Universal(American), 1=FDI, 2=Haderup, 3=Palmer
UseProviderColorsInChart Use provider color in chart Boolean. 0 by default. When enabled, chart module procedures that are complete will use the provider's color as row's background color background color in grid for completed procedures
UserNameManualEntry Boolean. 0 by default. When enabled, users must enter their user name manually at the log on window.
UserQueryDefaultRaw Boolean, 0 by default. When enabled, the User Query window will load with the 'Raw' format radio button pre-selected. Otherwise it will load with the 'Human-readable' format radio button pre-selected. This also determines how new userquery.DefaultFormatRaw will be set.
VideoImageCategoryDefault Default Image Category for video capture FK to DefNum of image category used when capturing a video image. unless a mount is showing
VoiceMailArchivePath Used by OD HQ. Not added to db convert script. The path where voice mails will be archived.
VoicemailCalls Used by OD HQ. Not added to db convert script. Number of voicemails that will make the alert color change.
VoiceMailCreatePath Used by OD HQ. Not added to db convert script. The path where voice mails will be saved when they are entered in the database.
VoiceMailDeleteAfterDays Used by OD HQ. Not added to db convert script. Delete the voice mail if it is older than this many days. Set to empty string to never delete voice mails.
VoiceMailMonitorHeartBeat Used by OD HQ. Not added to db convert script. The last time that the voice mail monitoring thread started its monitoring.
VoiceMailOriginationPath Used by OD HQ. Not added to db convert script. The paths where the phone tracking server looks for newly created voice mails. This preference stores a JSON-serialized list of VoiceMailPath objects that hold paths for each computer that runs the Phone Tracking Server (PTS) application.
VoiceMailSMB2Enabled Used by OD HQ. Not added to db convert script. Boolean. True if we are using SMB2 and false if we are using SMB1.
VoiceMailSMB2Password Used by OD HQ. Not added to db convert script. The password in plain text that our required to access files via SMB2.
VoiceMailSMB2UserName Used by OD HQ. Not added to db convert script. The user name in plain text that our required to access files via SMB2.
VoicemailTime Used by OD HQ. Not added to db convert script. How many minutes we can be behind on voicemails before alert color changes.
WaitingRoomAlertColor
WaitingRoomAlertTime Waiting room alert time 0 to disable. When enabled, sets rows to alert color based on wait time. in minutes, 0 to disable
WaitingRoomFilterByView Boolean. 0 by default. When enabled, the waiting room will filter itself by the selected appointment view. 0, normal filtering, will show all patients waiting for the entire practice (or entire clinic when using clinics).
WebAppClinicGuid The clinic GUID for the clinic in question, stored as ClinicPref. Stored at HQ in EserviceClinic.ClinicGuid. All clinics (including 0) will have a ClinicGuid. Used for idenitification when creating the specific clinic URL. Example: ABC123XYZ portion of https://payportal.patientviewer.com/?cid=ABC123XYZ.
WebAppDomain The web domain for web apps that is the second part of the customer's URL. Example: patientviewer.com portion of https://payportal.patientviewer.com/?cid=ABC123XYZ.
WebCamFrequencyMS DEPRECATED. Used by OD HQ. Not added to db convert script. No UI to change this value. Determines how often in milliseconds that WebCamOD should capture and send a picture to the phone table. If this value is manually changed, all Web Cams need to be restarted for the change to take effect.
WebFormsAutoFillNameAndBirthdate Boolean. 1 by default. Determines whether or not the checkbox in FormWebFormSetup is checked by default.
WebFormsDownloadAlertFrequency Hidden preference, no UI to enable this feature, but is present in all databases. Used to determine the frequency of WebFormRetrieveThread.
WebFormsDownloadAutomcatically 0 to disable. 1 by default. When enabled, web forms will be downloaded automatically, including web forms that don't match any patients.
WebHostSynchServerURL Only used for sheet synch. See Mobile... for URL for mobile synch.
WebSchedAggregatedTextMessage The template that will be used for Web Sched automation when a reminder for multiple recalls is sent to the same phone number.
WebSchedAggregatedEmailBody The template that will be used for Web Sched automation when a reminder for multiple recalls is sent to the same email.
WebSchedAggregatedEmailSubject The template that will be used for Web Sched automation when a reminder for multiple recalls is sent to the same email.
WebSchedAsapEmailSubj The subject line used for Web Sched ASAP emails.
WebSchedAsapEmailTemplate The template used for Web Sched ASAP email bodies.
WebSchedAsapEmailTemplateType Enum:EmailType 0=Regular 1=Html 2=RawHtml. Used to determine format for email for web sched asap messages
WebSchedExistingPatDoAuthEmail Require existing patient to respond to 2-step verification email before creating new appointment.
WebSchedExistingPatDoAuthText Require existing patient to respond to 2-step verification text before creating new appointment.
WebSchedExistingPatRecallName Allows a user to customize the default WebSched Recall display name in WSEP.
WebSchedAsapEnabled Boolean. 0 by default. True when Web Sched ASAP service is enabled. The eConnector keeps this preference current with OD HQ, calling our web service to verify status.
WebSchedAsapTextLimit The maximum number of texts allowed to be sent to a patient in a day. Blank means no limit.
WebSchedAsapTextTemplate The template used for Web Sched ASAP texts.
WebSchedAutomaticSendSetting Stored as an int value from the WebSchedAutomaticSend enum.
WebSchedAutomaticSendTextSetting Stored as an int value from the WebSchedAutomaticSendText enum.
WebSchedExistingPatConfirmStatus DefNum for the ApptConfirm status type that will automatically be assigned to Web Sched existing patient appointments.
WebSchedExistingPatDoubleBooking Int, 0 indicates we do not do anything beyond appointment rules in Web Sched Existing Pat to block double-booking. 1 indicates we do not allow double booking at all. This preference can be enhanced in the future to be an enum.
WebSchedExistingPatIgnoreBlockoutTypes Comma delimited list. Empty by default. Stores the defnums to blockouts to ignore in Web Sched Existing Pat web app.
WebSchedExistingPatMessage String. Is not empty by default. Stores the message that will show up on the Web Sched Existing Pat web application.
WebSchedExistingPatAllowDisabledRecalls Boolean, false by default. If true, patients will be able to schedule disabled recalls for Web Sched Existing Pat.
WebSchedExistingPatAllowProvSelection Boolean, false by default. If true, patients will be able to select their provider for Web Sched Existing Pat.
WebSchedExistingPatRequestInsurance Boolean, false by default. Used to enforce an insurance carrier selection for existing patients prior to scheduling a WebSched appt.
WebSchedExistingPatSearchAfterDays Integer. Represents the number of days into the future we will go before searching for available time slots. Empty will start looking for available time slots today.
WebSchedExistingPatWebFormsURL String, the webforms url that should be launched after an existing patient signs up using web sched.
WebSchedManualSendTriggered Long, 0 by default. eConnector will parse this pref to send manual recalls.
WebSchedMessage
WebSchedMessageText
WebSchedMessage2
WebSchedMessageText2
WebSchedMessage3
WebSchedMessageText3
WebSchedTextsPerBatch The number of text messages or emails sent automatically per batch. Currently one batch runs every 10 minutes. The pref is being used for both types of messages but a name change was deemed unnecessary per job 60116.
WebSchedNewPatAllowChildren Determines whether or not the birthdate of the Web Sched New Patient gets validated for being 18 years or older.
WebSchedNewPatAllowProvSelection Boolean, false by default. If true, patients will be able to select their provider for Web Sched New Pat.
WebSchedNewPatApptDoubleBooking Int, 0 indicates we do not do anything beyond appointment rules in Web Sched New Pat to block double-booking. 1 indicates we do not allow double booking at all. This preference can be enhanced in the future to be an enum.
WebSchedNewPatApptEnabled Deprecated as of 17.1, use signup portal. Boolean. 0 by default. True when the New Patient Appointment version of Web Sched is enabled. Loosely keeps track of service status, calling our web service to verify active service is still required.
WebSchedNewPatApptForcePhoneFormatting Boolean. Defaults to true. Determines whether or not the phone number field is forced to be formatted (currently only US format XXX-XXX-XXXX)
WebSchedNewPatApptIgnoreBlockoutTypes Comma delimited list. Empty by default. Stores the defnums to blockouts to ignore in Web Sched Recall web app.
WebSchedNewPatApptMessage String. Is not empty by default. Stores the message that will show up on the Web Sched New Pat web application.
WebSchedNewPatApptProcs Deprecated in v18.1.1 - Utilize appointment types instead. Comma delimited list of procedures that should be put onto the new patient appointment.
WebSchedNewPatApptTimePattern Deprecated in v18.1.1 - Utilize appointment types instead. The time pattern that will be used to determine the length of the new patient appointment. This time pattern is stored as /'s and X's that each represent an amount of time dictated by the current AppointmentTimeIncrement pref. This functionality matches the recall system, not the appointment system (which always stores /'s and X's as 5 mins).
WebSchedNewPatApptSearchAfterDays Integer. Represents the number of days into the future we will go before searching for available time slots. Empty will start looking for available time slots today.
WebSchedNewPatConfirmStatus DefNum for the ApptConfirm status type that will automatically be assigned to Web Sched new patient appointments.
WebSchedNewPatDoAuthEmail Require new patient to respond to 2-step verification email before creating new appointment.
WebSchedNewPatDoAuthText Require new patient to respond to 2-step verification text message before creating new appointment.
WebSchedNewPatRequestInsurance Boolean, false by default. Used to enforce an insurance carrier selection for new patients prior to scheduling a WebSched appt.
WebSchedNewPatVerifyInfo Deprecated in 21.1 - Boolean, default is true. Used to verify important user information, such as if they are a new patient and how old they are.
WebSchedNewPatWebFormsURL String, the webforms url that should be launched after a new patient signs up using web sched.
WebSchedProviderRule Enum: WebSchedProviderRules 0=FirstAvailable, 1=PrimaryProvider, 2=SecondaryProvider, 3=LastSeenHygienist
WebSchedRecallDoubleBooking Int, 0 indicates we do not do anything beyond appointment rules in Web Sched Recall to block double-booking. 1 indicates we do not allow double booking at all. This preference can be enhanced in the future to be an enum.
WebSchedRecallAllowProvSelection Boolean, true by default. If true, patients will be able to select their provider for Web Sched Recall.
WebSchedRecallApptSearchAfterDays Integer. Represents the number of days into the future we will go before searching for available time slots. Empty will start looking for available time slots today.
WebSchedRecallApptSearchMaximumMonths An integer number of months 1-24 representing how far out we will initially search for appointment openings when scheduling WebSched Recall.
WebSchedRecallConfirmStatus DefNum for the ApptConfirm status type that will automatically be assigned to Web Sched Recall appointments.
WebSchedRecallDoUseSecureEmail Boolean, false by default. If true, Web Sched Recall messages will be sent using secure email instead of regular email.
WebSchedRecallEmailTemplateType Enum:EmailType 0=Regular 1=Html 2=RawHtml. Used to determine format for email for web sched recall messages
WebSchedRecallEmailTemplateType2 Enum:EmailType 0=Regular 1=Html 2=RawHtml. Used to determine format for email for web sched recall messages
WebSchedRecallEmailTemplateType3 Enum:EmailType 0=Regular 1=Html 2=RawHtml. Used to determine format for email for web sched recall messages
WebSchedRecallEmailTemplateTypeAgg Enum:EmailType 0=Regular 1=Html 2=RawHtml. Used to determine format for email for web sched recall messages
WebSchedRecallIgnoreBlockoutTypes Comma delimited list. Empty by default. Stores the defnums to blockouts to ignore in Web Sched Recall web app.
WebSchedSendThreadFrequency In seconds, how often the eConnector thread runs that sends Web Sched notifications. This preference can be updated from OD HQ.
WebSchedSendASAPThreadFrequency In seconds, how often the eConnector thread runs that sends Web Sched ASAP messages.
WebSchedService Boolean. 0 by default. True when Web Sched service is enabled. The eConnector keeps this preference current with OD HQ, calling our web service to verify active service is still required.
WebSchedSubject
WebSchedSubject2
WebSchedSubject3
WebSchedVerifyASAPEmailBody String. The e-mail template used for Web Sched verifications to ASAP patients.
WebSchedVerifyASAPEmailSubj String. The e-mail subject used for Web Sched verifications to ASAP patients.
WebSchedVerifyAsapEmailTemplateType Enum:EmailType 0=Regular 1=Html 2=RawHtml. Used to determine format for email for web sched notify asap messages
WebSchedVerifyASAPText String. The text template used for Web Sched verifications to ASAP patients.
WebSchedVerifyASAPType Enum. The communication type for Web Sched verifications to ASAP patients. 0: None, 1: Text, 2: E-mail, 3: Text and E-mail
WebSchedVerifyExistingPatEmailBody String. The e-mail template used for Web Sched verifications to Existing Pat patients.
WebSchedVerifyExistingPatEmailSubj String. The e-mail subject used for Web Sched verifications to Existing Pat patients.
WebSchedVerifyExistingPatEmailTemplateType Enum:EmailType 0=Regular 1=Html 2=RawHtml. Used to determine format for email for web sched notify Existing Pat messages
WebSchedVerifyExistingPatText String. The text template used for Web Sched verifications to Existing Pat patients.
WebSchedVerifyExistingPatType Enum. The communication type for Web Sched verifications to Existing Pat patients. 0: None, 1: Text, 2: E-mail, 3: Text and E-mail
WebSchedVerifyNewPatEmailBody String. The e-mail template used for Web Sched verifications to new patients.
WebSchedVerifyNewPatEmailSubj String. The e-mail subject used for Web Sched verifications to new patients.
WebSchedVerifyNewPatEmailTemplateType Enum:EmailType 0=Regular 1=Html 2=RawHtml. Used to determine format for email for web sched notify new pat messages
WebSchedVerifyNewPatText String. The text template used for Web Sched verifications to new patients.
WebSchedVerifyNewPatType Enum. The communication type for Web Sched verifications to new patients. 0: None, 1: Text, 2: E-mail, 3: Text and E-mail
WebSchedVerifyRecallEmailBody String. The e-mail template used for Web Sched verifications to recalls.
WebSchedVerifyRecallEmailSubj String. The e-mail subject used for Web Sched verifications to recalls.
WebSchedVerifyRecallEmailTemplateType Enum:EmailType 0=Regular 1=Html 2=RawHtml. Used to determine format for email for web sched notify recall messages
WebSchedVerifyRecallText String. The text template used for Web Sched verifications to recalls.
WebSchedVerifyRecallType Enum. The communication type for Web Sched verifications to recalls. 0: None, 1: Text, 2: E-mail, 3: Text and E-mail
WebServiceHQServerURL
WebServiceServerName Update Server: Update Server: Version updates can only be performed from this computer, and the eConnector can only be installed on this computer. This is the name of the Update Server machine. Version updates can only be performed from this computer, and the eConnector can only be installed on this computer. For Middle Tier, this identifies which computer is running the middle tier. If the server name exceeds 15 characters, users may receive an error when attempting check for updates or install services. If the server name exceeds 15 characters, only type the first 15 characters.
WebServiceServerNameCanBeBlank Allow WebServiceServerName to be blank so that updates can be performed from any computer. eConnector will not work.
WikiDetectLinks If enabled, allows users to right click on ODTextboxes or ODGrids to populate the context menu with any detected wiki links.
WikiCreatePageFromLink If enabled, allows users to create new wiki pages when following links from textboxes and grids. (Disable to prevent proliferation of misspelled wiki pages.)
WordProcessorPath
WSEPSubDomain The subdomain for the web sched existing patient portal that is the first part of the customer's URL. Example: "wsep" would be in this pref field for the following URL: https://wsep.patientviewer.com/?cid=ABC123XYZ.
XRayExposureLevel