Question regarding claim table default values

For complex topics that regular users would not be interested in. For power users and database administrators.
Post Reply
freddiexyz
Posts: 2
Joined: Wed Mar 07, 2018 7:10 pm

Question regarding claim table default values

Post by freddiexyz » Wed Mar 07, 2018 7:23 pm

Hi,

I am currently in the process of automating some of our office work and have noticed that there are many unused (for us) columns in the 'claim' table that are marked as not nullable, but also do not have default values.
Would altering the table so that these columns have defaults bork anything internally, or am I safe to go ahead and do this?

Thanks,
Freddie

JoeMontano
Posts: 64
Joined: Thu Aug 20, 2015 11:08 am

Re: Question regarding claim table default values

Post by JoeMontano » Thu Mar 08, 2018 7:05 am

I wouldn't recommend modifying the schema at all. I am curious as to what columns you say are unused though, could you provide a list?
Joe Montaño
Software Engineer
Open Dental Software
Joe@OpenDental.com

freddiexyz
Posts: 2
Joined: Wed Mar 07, 2018 7:10 pm

Re: Question regarding claim table default values

Post by freddiexyz » Fri Mar 09, 2018 6:24 pm

Ok, glad I asked then.


Columns in the claim table that we do not use, do not have defaults, and can't be nulled:
ReferringProv
ClinicNum
AttachedImages
AttachedModels
(All of the ones that start with 'Canada/Canadian')
SpecialProgramCode
UniformBillType
MedType
AdmissionTypeCode
AdmissionSourceCode
PatientStatusCode
CustomTracking
CorrectionType
OrigRefNum
ProvOrderOverride
OrthoTotalM
ShareOfCost
OrderingReferralNum

To determine what's 'unused' I just ran "select * from claim order by claimnum desc limit 5000" and looked for the columns that didn't change, so some of these might be trivial (sorry for the stupid question if that's the case), but I'm guessing these are features we aren't using.

If it makes any difference, we're from New Zealand so we might not be using the claim system the same way as American users are.

Thanks, Freddie

Post Reply