Data Types and Referential Integrity

SDF files should be processed in the following order to keep referential integrity. (For example; The Patient file must be processed before the LabReport file because the LabReport file may refer to a new patient that is not in the target system until the Patient file is processed.)

1. RecordAuthority
2. Term
3. TermMap
4. Patient
5. PatientIdentifier
6. PatientName
7. PatientAddress
8. PatientContactInfo
9. Caregiver
10. Encounter
11. CaregiverRelationship
12. Organization
13. Location
14. Diagnosis
15. DiagnosisProperty
16. Procedure
17. Order
18. OrderModifier
19. Report
20. ReportCopyToCaregiver
21. LabReport
22. LabObservation
23. LabReportSpecimen
24. LabReportSpecimenProperty
25. LabReportCopyToCaregiver
26. Insurance
27. Referral
28. ReferralProperty
29. ReferralNote
30. ReferralProblem
31. ReferralService
32. ReferralReport
33. Claim
34. ClaimProperty
35. Medication
36. Observation
37. MedicationProfile
38. MedicationAdministration
39. Allergy
40. AllergyReaction
41. ClaimService
42. ClaimServiceProperty
43. ClaimProblem
44. ClaimProcedure
45. ClaimCaregiverRelationship
46. DeviceDataPoint
47. CareTaskRule
48. CareTaskRuleProperty
49. CareTaskGroup
50. CareTaskGroupProperty
51. ValueSet
52. ValueSetMember