text: ARSAG (application group table) 
  name (checks) 
  agid..... (5018) 
  agid_name (HAA) 
  ... 
  
  ARSSEG (segment table) 
  
  agid table_name … 
  5018 HAA1 
  5018 HAA2 
  
  HAA1 (application group data table) 
  
  customer_name account_nbr check_nbr balance doc_name doc_offset doc_length 
  John Smith 123456789 76543 120.78 2FAAA 0 21945 
  John Doe 234567890 98765 987.98 2FAAA 21945 28063 
  Jane Doe 345678901 87654 380.98 2FAAA 50008 28595 
  ......... 10 Million row s 
  
  HAA2 (application group data table) 
  
  customer_name account_nbr check_nbr balance doc_name doc_offset doc_length 
  Jane Brown 456784949 87643 245.78 4FAAA 0 21945 
  John Brown 574630988 34512 876.65 4FAAA 21945 28063 
  Jane Smith 875632091 85094 1380.98 4FAAA 50008 28595 
  ......... 326,098 rows 