Database input validation standards

Hi,

I am managing a large database that is used for processing of medical information. I would like to ask for your opinion about input data validation standards. Does something like that exist?

Do we need to create validation standard for each column/field and then apply that validation before transfer?

Or is there a best practices document that has all that logic described?

Thank you