The Patient Comments Data Export extracts data related to the patient comment/alert records. Below you will find a detailed definition of possible inputs and outputs.
Data Location: Setup > Patient > Comments
Inputs
- None
Outputs
- last_name: Patient last name
- first_name: Patient first name
- middle_name: Patient middle name
- nick_name: Patient nick name
- suffix: Patient suffix
- chart_number: Unique ID for patient (foreign key for patient)
- type: Type of comment (i.e. User, System, Claim, etc...)
- user_name: Name of user that created the comment
- date_time: Date/Time the comment was created
- alert: Indicator if the comment is an alert (Yes or No)
- effective_date: If the comment is an alert, the effective start date of the alert
- expiration_date: If the comment is an alert, the expiration date of the alert
- alert_type_emr: If the comment is an alert, indicates that the alert will appear in the EMR
- alert_type_scheduler: If the comment is an alert, indicates that the alert will appear in the iScheduler
- alert_type_comments: If the comment is an alert, indicates that the alert will appear in the Claim/Comments
- alert_type_cancelled: If the comment is an alert, indicates that the alert will appear in the iScheduler if the appointment is cancelled
- alert_type_checked_in: If the comment is an alert, indicates that the alert will appear in the iScheduler if the appointment is checked-in
- alert_type_checked_out: If the comment is an alert, indicates that the alert will appear in the iScheduler if the appointment is checked-out
- alert_type_confirmed: If the comment is an alert, indicates that the alert will appear in the iScheduler if the appointment is confirmed
- alert_type_no_show: If the comment is an alert, indicates that the alert will appear in the iScheduler if the appointment is marked as a no-show
- alert_type_scheduled: If the comment is an alert, indicates that the alert will appear in the iScheduler if the appointment is scheduled
- comment: Comment text
