Data Model Diagrams

Broker

Broker – Broker Detail

---------------------
|   rbk Broker      |
|===================|
|   brk_s: broker   |
---------------------
          | brk_s
          |
          |
          |                 ----------------------------------
          |          brk_s  |   vrcx_brk Broker Short Name   |
          +-----------------|================================|
          |                 |   brk_s: broker                |
          |                 ----------------------------------
          |
          |
          |                 ---------------------
          |          brk_s  |   rls Lease       |
          +---------------->|===================|
          |                 |   lse_s: lease    |
          |                 |   brk_s: broker   |
          |                 ---------------------
          |
          |
          |                 -----------------------------------------
          |    client_id_s  |   vrtp_rcr Recurring Charge Payable   |
          +---------------->|=======================================|
          |                 |   por_s: portfolio                    |
          |                 |   client_id_s: broker                 |
          |                 -----------------------------------------
          |
          |
          |                 ------------------------------------------
          |    client_id_s  |   vrtr_rcr Recurring Charge Released   |
          +---------------->|========================================|
                            |   por_s: portfolio                     |
                            |   client_id_s: broker                  |
                            ------------------------------------------

When joining to the vrtp_rcr or vrtr_rcr, the portfolio (vrtp_rcr.por_s or vrtr_rcr.por_s) must be specified in the join to prevent a search of the entire table.