Data Model Diagrams

Lease – Historical

------------------------                             ----------------------------
|   rls Lease          |            lse_s            |   rps Historical Lease   |
|======================|^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^|==========================|
|   por_s: portfolio   |                             |   lse_s: lease           |
|   com_s: company     |                             ----------------------------
|   reg_s: region      |                                          |
|   off_s: office      |                                          |
|   lse_s: lease       |                                          |        ----------------------------------------------
------------------------                                          | lse_s  |   rpsp Historical Lease Payment Schedule   |
           |                                                      +------->|============================================|
           |                -------------------------------       |        |   lse_s: lease                             |
           |                |   rtx Monthly Transaction   |       |        |   unique_l: record #                       |
           |                |=============================|       |        ----------------------------------------------
           |                |   por_s: portfolio          |       |
           | p/c/r/o/lse_s  |   com_s: company            |       |
           +--------------->|   reg_s: region             |       |        ----------------------------
           |                |   off_s: office             |       | lse_s  |   rcs Historical Asset   |
           |                |   lse_s: lease              |       +------->|==========================|
           |                |   d_run_s: run date         |                |   lse_s: lease           |
           |                |   t_run_s: run time         |                |   unit_s: asset          |
           |                -------------------------------                ----------------------------
           |
           |
           |                ------------------------------
           |                |   rht Historical Payment   |
           | lse_s          |============================|
           +--------------->|   lse_s: lease             |
           |                |   d_run_s: run date        |
           |                |   t_run_s: run time        |
           |                ------------------------------
           |                  
           |
          IBLs              -------------------------------------            ---------------------------------------
           |                |   rph Payment History             |            |   rpha Payment History Assessment   |
           |                |===================================|            |=====================================|
           |                |   lse_s: lease                    |            |   lse_s: lease                      |
           | lse_s          |   pmt_num_s: payment number       |     *      |   pmt_num_s: payment number         |
           +--------------->|   ymd_rev_s: reversal date        |----------->|   ymd_rev_s: reversal date          |
                            |   d_pmt_run_s: payment run date   |            |   d_pmt_run_s: payment run date     |
                            |   t_pmt_run: payment run time     |            |   t_pmt_run: payment run time       |
                            -------------------------------------            |   unique_l: record #                |
                                                                             ---------------------------------------

* = lse_s, pmt_num_s, ymd_rev_s, d_pmt_run_s, t_pmt_run
IBLs = Interest Bearing Loans