Exhibit D - OneODA CRM Licensing Oracle Tables_posted.xlsx

This document is a technical specification exhibit for the State of Oregon's Request for Quote (RFQ) for One ODA Core CRM & Licensing system, detailing the Oracle database table inventory and storage requirements. The exhibit provides a comprehensive listing of 823 database tables across three schemas (LCPS, ODA, and ODAWB) that comprise the OneODA CRM licensing system. The tables range significantly in size and complexity, with the largest tables including T_LOG_MODIFICATION (127.2 MB with 4,748,412 rows), T_TRAN_LOG (48.13 MB with 1,428,720 rows), and T_FEE_COMPONENT (42.85 MB with 1,262,552 rows). The total database footprint documented in this exhibit spans approximately 26.8 GB across 216.6 million rows, representing the existing data infrastructure that must be maintained, migrated, or replaced through the contracted solution.

This technical exhibit serves as a critical reference document for evaluating system capacity, performance, and migration requirements for potential vendors responding to the RFQ. The data distribution reveals that certain tables store particularly large objects, including binary large object (BLOB) fields and PDF content tables such as LSM_PRODUCT_LABEL (101.1 GB), CPO_PDF (1.730 GB), COURSE_PDF (10.95 GB), and ONLINE_PPR_LABEL (2.158 GB), which collectively represent the majority of the database's storage burden. The inclusion of this detailed table-level inventory indicates that vendors must demonstrate the capacity to handle complex data structures, maintain historical transaction logs, support multiple licensing program types, and ensure system performance across the substantial existing data volume while accommodating ongoing operational requirements for Oregon's Department of Agriculture's licensing and permitting operations.