Standard Extract ER Diagram
We have put together a diagram to show how the tables with 'TYPE': Standard Extract can be joined. Using this diagram, cross over with a composite key from WebPT EMR to WebPT Billing tables.
Note: These concepts are not limited to one specific ‘TYPE’ or ‘SOURCE’. However, different ‘TYPE’ tables, although the same ‘SOURCE’ can have different models, such as SVW_BILLING_CHARGE and SVW_REVFLOW_D_CHARGE, and this should be considered.