OpenPM Export Demographics

OpenPM Export Demographics

How To Run:

You must put a 1 in enter_1_to_run field

Description:

The “Demographics” report is designed for exporting patient demographic data for creation of the OpenPM interface. This report is essential for creating a comprehensive interface for OpenPM, as it includes vital patient information necessary for various medical and administrative purposes.

Report Fields and Descriptions:

1. PatientID: Unique identifier for each patient within the system.
2. Chartno: Placeholder for patient chart number (currently not populated).
3. PCP: Placeholder for Primary Care Provider (currently not populated).
4. Provider: Placeholder for provider information (currently not populated).
5. NewDate: Placeholder for the date of new patient record (currently not populated).
6. Facility: Placeholder for facility information (currently not populated).
7. LastVisit: Placeholder for the date of the last visit (currently not populated).
8. LastName: The patient’s last name.
9. FirstName: The patient’s first name.
10. Middle: The patient’s middle name.
11. Address1: Primary address line 1.
12. Address2: Primary address line 2.
13. City: The city of the patient’s primary address.
14. State: The state of the patient’s primary address.
15. Zip: The zip code of the patient’s primary address.
16. DOB: Date of birth of the patient.
17. HomePhone: The patient’s home phone number.
18. WorkPhone: The patient’s work phone number.
19. CellPhone: The patient’s cell phone number.
20. Email: The patient’s email address.
21. SSN: The patient’s social security number.
22. MaritalStatus: The marital status of the patient.
23. Sex: The gender of the patient.
24. Race: The race of the patient, mapped to specific codes:
    • ‘AI’ for American Indian or Alaska Native
    • ‘AS’ for Asian
    • ‘BL’ for Black or African American
    • ‘PI’ for Native Hawaiian or Other Pacific Islander
    • ‘WH’ for White
    • ‘REFUSED’ for Declined
25. Ethnicity: The ethnicity of the patient, mapped to specific codes:
    • ‘H’ for Hispanic or Latino
    • ‘N’ for Not Hispanic or Latino
    • ‘REFUSED’ for NA
26. DOD: Date of death of the patient, if applicable.
27. Suffix: The suffix of the patient’s name.
28. ReminderPreference: Placeholder for reminder preference (currently not populated).
29. Language: The primary language spoken by the patient.