Ideal Data Field Set

Preferred Format is comma-separated with values in double quotes. The preferred date, time, phone number syntax is indicated below. We will modify the upload system to suit your data.

1. Patient ID/Unit number
2. *Account ID/Account number
3. *Patient Name
4. *Arrival Date [YYYY-MM-DD]
5. *Arrival Time [HH:MM]
6. *Disposition Type (e.g., home, transfer, observation, inpatient, expired, LWBS, AMA)

7. *Disposition time [HH:MM]
8. *Date of Birth [YYYY-MM-DD]
9. *Gender

10. Zip code
11. Phone Number – Home [(xxx)xxx-xxxx]
12. *Phone Number – Cell [(xxx)xxx-xxxx]
13. *Email Address

14. Triage Chief Complaint
15. ED Primary Diagnosis
16. *Emergency Physician (name or ID any format)
17. *Nurse ID/Name (name or ID in any format)

18. Resident ID/Name (name or ID in any format, if applicable)
19. Midlevel ID/Name (name or ID in any format, if applicable)
20. Other Provider (name or ID in any format, if applicable)
21. *ESI/Triage Level
22. Financial Class
23. Native Language (this will drive surveys in a language other than English)
24. Primary Care Physician (name or ID in any format)
25. ED Section (applies to sections within a specific ED)
26. Opt-out Flag (‘Y’ or ‘1’ to exclude certain patients from being contacted)

    *Essential Items