opendental-f5d089 / userodpref

Open Dental Sample Database Data Explorer

Tables Queries

account
accountingautopay
activeinstance
adjustment
alertcategory
alertcategorylink
alertitem
alertread
alertsub
allergy
allergydef
anestheticdata
anestheticrecord
anesthmedsgiven
anesthmedsintake
anesthmedsinventory
anesthmedsinventoryadj
anesthmedsuppliers
anesthscore
anesthvsdata
apikey
apisubscription
appointment
appointmentrule
appointmenttype
apptfield
apptfielddef
apptgeneralmessagesent
apptreminderrule
apptremindersent
apptthankyousent
apptview
apptviewitem
asapcomm
autocode
autocodecond
autocodeitem
autocommexcludedate
automation
automationcondition
autonote
autonotecontrol
benefit
canadiannetwork
carecreditwebresponse
carrier
cdcrec
cdspermission
centralconnection
cert
certemployee
chartview
claim
claimattach
claimcondcodelog
claimform
claimformitem
claimpayment
claimproc
claimsnapshot
claimtracking
claimvalcodelog
clearinghouse
clinic
clinicerx
clinicpref
clockevent
cloudaddress
codesystem
commlog
commoptout
computer
computerpref
confirmationrequest
connectiongroup
conngroupattach
contact
county
covcat
covspan
cpt
creditcard
custrefentry
custreference
cvx
dashboardar
dashboardcell
dashboardlayout
databasemaintenance
dbmlog
definition
deflink
deletedobject
deposit
dictcustom
discountplan
discountplansub
disease
diseasedef
displayfield
displayreport
dispsupply
document
documentmisc
drugmanufacturer
drugunit
dunning
ebill
eclipboardimagecapture
eclipboardimagecapturedef
eclipboardsheetdef
eduresource
ehramendment
ehraptobs
ehrcareplan
ehrlab
ehrlabclinicalinfo
ehrlabimage
ehrlabnote
ehrlabresult
ehrlabresultscopyto
ehrlabspecimen
ehrlabspecimencondition
ehrlabspecimenrejectreason
ehrmeasure
ehrmeasureevent
ehrnotperformed
ehrpatient
ehrprovkey
ehrquarterlykey
ehrsummaryccd
ehrtrigger
electid
emailaddress
emailattach
emailautograph
emailhostingtemplate
emailmessage
emailmessageuid
emailsecure
emailsecureattach
emailtemplate
employee
employer
encounter
entrylog
eobattach
equipment
erxlog
eservicelog
eserviceshortguid
eservicesignal
etrans
etrans835
etrans835attach
etransmessagetext
evaluation
evaluationcriterion
evaluationcriteriondef
evaluationdef
famaging
familyhealth
fee
feesched
feeschedgroup
fhircontactpoint
fhirsubscription
fielddeflink
files
flow
flowaction
flowactiondef
flowdef
flowdeflink
formpat
gradingscale
gradingscaleitem
grouppermission
guardian
hcpcs
hieclinic
hiequeue
histappointment
hl7def
hl7deffield
hl7defmessage
hl7defsegment
hl7msg
hl7procattach
icd10
icd9
imagedraw
imagingdevice
insbluebook
insbluebooklog
insbluebookrule
inseditlog
inseditpatlog
insfilingcode
insfilingcodesubtype
insplan
insplanpreference
inssub
installmentplan
instructor
insverify
insverifyhist
intervention
journalentry
labcase
laboratory
labpanel
labresult
labturnaround
language
languageforeign
letter
lettermerge
lettermergefield
limitedbetafeature
loginattempt
loinc
maparea
medicalorder
medication
medicationpat
medlab
medlabfacattach
medlabfacility
medlabresult
medlabspecimen
mobileappdevice
mobiledatabyte
mount
mountdef
mountitem
mountitemdef
oidexternal
oidinternal
operatory
orionproc
orthocase
orthochart
orthochartrow
orthocharttab
orthocharttablink
orthohardware
orthohardwarespec
orthoplanlink
orthoproclink
orthorx
orthoschedule
patfield
patfielddef
patient
patientlink
patientnote
patientportalinvite
patientrace
patplan
patrestriction
payconnectresponseweb
payment
payortype
payperiod
payplan
payplancharge
payplanlink
paysplit
perioexam
periomeasure
pharmacy
pharmclinic
phonenumber
plannedappt
popup
preference
printer
procapptcolor
procbutton
procbuttonitem
procbuttonquick
proccodenote
procedurecode
procedurelog
procgroupitem
procmultivisit
procnote
proctp
program
programproperty
promotion
promotionlog
provider
providerclinic
providercliniclink
providererx
providerident
question
questiondef
quickpastecat
quickpastenote
reactivation
recall
recalltrigger
recalltype
reconcile
recurringcharge
refattach
referral
referralcliniclink
registrationkey
reminderrule
repeatcharge
replicationserver
reqneeded
reqstudent
requiredfield
requiredfieldcondition
reseller
resellerservice
rxalert
rxdef
rxnorm
rxpat
schedule
scheduledprocess
scheduleop
schoolclass
schoolcourse
screen
screengroup
screenpat
securitylog
securityloghash
sessiontoken
sheet
sheetdef
sheetfield
sheetfielddef
sigbutdef
sigelementdef
sigmessage
signalod
site
smsblockphone
smsfrommobile
smsphone
smstomobile
snomed
sop
stateabbr
statement
statementprod
stmtlink
substitutionlink
supplier
supply
supplyneeded
supplyorder
supplyorderitem
task
taskancestor
taskattachment
taskhist
tasklist
tasknote
tasksubscription
taskunread
terminalactive
timeadjust
timecardrule
toolbutitem
toothgridcell
toothgridcol
toothgriddef
toothinitial
transaction
transactioninvoice
treatplan
treatplanattach
treatplanparam
tsitranslog
ucum
updatehistory
userclinic
usergroup
usergroupattach
userod
userodapptview
userodpref
userquery
userweb
utm
vaccinedef
vaccineobs
vaccinepat
vitalsign
webschedcarrierrule
webschedrecall
wikilistheaderwidth
wikilisthist
wikipage
wikipagehist
xchargetransaction
xwebresponse
zipcode

Log in

Sort Open Dental Sample Database Data Explorer

Filters

Orders

Columns

userodprefnum

usernum

fkey

fkeytype

valuestring

clinicnum

Create Query

Name

Description

Change Request

Title

Description

userodpref

userodprefnum	usernum	fkey	fkeytype	valuestring	clinicnum
1	1	0	3		0
2	3	66	11		0