Adding a CCI or ICD10 entry in CFE: Difference between revisions
Ttenbergen (talk | contribs) mNo edit summary |
|||
| Line 10: | Line 10: | ||
=== Generating the *_D_ID === | === Generating the *_D_ID === | ||
It should not let you do an addition to L_ICD10 if there is a duplicate L_ICD10_ID, but the trickier part is to make sure that future entries also won’t break this. The L_ICD10 table uses an auto-incrementing number for this. So, the way to make sure that we won’t have a duplicate in the future is to fudge these when we do a manual addition like this: use a totally unrelated code that we can be reasonably sure won’t be re-used. For example <D_ID>_z22. | It should not let you do an addition to L_ICD10 if there is a duplicate L_ICD10_ID, but the trickier part is to make sure that future entries also won’t break this. The L_ICD10 table uses an auto-incrementing number for this. So, the way to make sure that we won’t have a duplicate in the future is to fudge these when we do a manual addition like this: use a totally unrelated code that we can be reasonably sure won’t be re-used. For example <D_ID>_z22.9add_<incrementing number>. Field size is 30, so make sure whatever you use is not longer than that. | ||
=== Date format === | === Date format === | ||