Add Visit Link to Power BI Progress Note Table
In order to accurately report staff productivity, a direct link needs to be supported between the Power BI 'Progress Note' and 'Visit' tables. Such a link would allow the assignment of 'earned' APG units or Customary / Contractual revenue amounts associated with a signed/locked billable Progress Note table entry.
Numerous views already exist in eCR (e.g., Progress Note Summary in Patient Charts, History tabs for various Progress / Session Notes) indicating corresponding billing information (e.g., Visit ID, Billing Date, Procedure Code, etc.) indicating that this relationship is already supported from the Progress Note perspective.
Since a 'Visit' can sometimes be the consolidation of multiple Progress Notes, ideally the corresponding 'Vist # - Line #' attribute is the value that should be added as an attribute to a specific Progress Note.