Lead with Nothing
Medical claims extracts will frequently drop the leading zeros from codes as shown in this dataset. It is important to add leading zeros back to your codes before using crosswalks and code sets.Read more
Occasionally claims extracts will merge from multiple sources and include observations with and without the period.
Read moreIn general, it is good practice to look at all of your date fields with counts (or another unit of measurement like dollars or member months) by year and month.
Read moreA null date can often get converted to 0 as data gets passed back and forth and what was missing becomes an actual date.
Read more