Attachment 13 Customer_Queue Table Data Requirements.txt

This is a data requirements specification document for the South Carolina Department of Motor Vehicles (SCDMV) Customer Management Solution contract opportunity. The document outlines the schema and field specifications for the Customer_Queue table, which is a critical component of the customer appointment and transaction management system. The table structure includes 18 data fields designed to capture comprehensive customer and appointment information, including customer identification data (name components, customer number, business name), vehicle-related information (VIN, license number, registration number, title number, product number), appointment details (service office location, queue flow ticket number, enqueue timestamp), and transaction status tracking (transaction group and appointment status). These fields are defined with specific data types and byte allocations to ensure efficient database storage and retrieval within the SCDMV's customer management platform.

The data requirements establish standardized field definitions and character limitations necessary for the backend system supporting SCDMV's customer queue operations. The specification utilizes Oracle database standards (VARCHAR2, CHAR, DATE, and NUMBER data types) and assigns specific byte allocations for each field to optimize system performance. Fields such as SERVICE_OFFICE_ID and QFLOW_TICKET_NO are limited to 4 bytes as character fields, while customer name fields accommodate up to 30 bytes for last names and 20 bytes for first and middle names. Vehicle and transaction identifiers use numeric formats with varying precision levels to accommodate standard identification schemes. This technical specification serves as the foundation for system design and vendor implementation, ensuring that all customer and appointment data captured through the SCDMV's customer management solution maintains consistency and accessibility across all service office locations.