Patient Comments Export

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