jasona.work (11/30/2012)
If our devs had used the patient ID value as the identity, it would have been a (10,10) seed. The way the current billing application handles patient IDs is increments of 10, then if it's a family practice, family members get added using the base +1. So wife (primary policy holder) might be patid 1270, the husband (on the wifes policy) would be 1271, and the three kids would be 1272-1274.Luckily, we've never run into anyone who would use all 10 values...
Having just been through a similar nightmare...
<Irony=ON>
WHHHHAAAATTTT??? They didn't see the painfully obvious advantages of storing such unpredictable data as full elemental XML with multiple hierarchical levels that would handle things correctly ad spontaneously even if one of the children decided to have a sex change or wanted to become the father of his mother's children thereby becoming the brother of his own children?
Even if they messed up there, they really could have benefitted from EDI here.
<Irony=OFF>
Can't.... hold.... it... in.... GAAAAHHHH!!!! SPOM!!! ROFLMAO!!! :-):-D:-P:hehe:
--Jeff Moden
Change is inevitable... Change for the better is not.