INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    733,
    '3',
    'Karena Wilson-Plater, PsyD',
    'Fixed',
    NULL,
    '2024-05',
    16,
    0.00,
    0.00,
    35.89,
    '0',
    0.00,
    35.89,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-07-02',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    734,
    '3',
    'Karena Wilson-Plater, PsyD',
    'Fixed',
    NULL,
    '2024-05',
    15,
    0.00,
    0.00,
    30.00,
    '0',
    0.00,
    30.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-07-02',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    735,
    '15',
    'Glenda Bullock-Willis, LCPC',
    'Normal',
    42,
    '2024-05',
    12,
    1757.32,
    8.50,
    149.37,
    '2.00',
    35.15,
    114.23,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2024-07-02',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    736,
    '15',
    'Glenda Bullock-Willis, LCPC',
    'Normal',
    47,
    '2024-05',
    13,
    492.51,
    8.50,
    41.86,
    '1.00',
    4.93,
    36.94,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2024-07-02',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    737,
    '15',
    'Glenda Bullock-Willis, LCPC',
    'Fixed',
    NULL,
    '2024-05',
    16,
    0.00,
    0.00,
    48.64,
    '0',
    0.00,
    48.64,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-07-02',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    738,
    '14',
    'Gillian Blackman-Diarra, LCSW-C',
    'Normal',
    42,
    '2024-05',
    12,
    1995.28,
    8.50,
    169.60,
    '2.00',
    39.91,
    129.69,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2024-07-02',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    739,
    '14',
    'Gillian Blackman-Diarra, LCSW-C',
    'Normal',
    47,
    '2024-05',
    13,
    535.82,
    8.50,
    45.54,
    '1.00',
    5.36,
    40.19,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2024-07-02',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    740,
    '14',
    'Gillian Blackman-Diarra, LCSW-C',
    'Fixed',
    NULL,
    '2024-05',
    16,
    0.00,
    0.00,
    9.75,
    '0',
    0.00,
    9.75,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-07-02',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    741,
    '29',
    'Dalton Johnson, LCPC',
    'Normal',
    NULL,
    '2024-05',
    12,
    7376.60,
    8.50,
    627.01,
    NULL,
    0.00,
    627.01,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-07-02',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    742,
    '29',
    'Dalton Johnson, LCPC',
    'Normal',
    NULL,
    '2024-05',
    13,
    1433.15,
    8.50,
    121.82,
    NULL,
    0.00,
    121.82,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-07-02',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    743,
    '29',
    'Dalton Johnson, LCPC',
    'Fixed',
    NULL,
    '2024-05',
    16,
    0.00,
    0.00,
    59.42,
    '0',
    0.00,
    59.42,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-07-02',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    744,
    '216',
    'Elisa Ndombele-Sisler, Psy.D.',
    'Normal',
    NULL,
    '2024-05',
    12,
    3040.03,
    9.00,
    273.60,
    '0',
    0.00,
    273.60,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-07-02',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    745,
    '216',
    'Elisa Ndombele-Sisler, Psy.D.',
    'Normal',
    NULL,
    '2024-05',
    13,
    996.14,
    9.00,
    89.65,
    NULL,
    0.00,
    89.65,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-07-02',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    746,
    '216',
    'Elisa Ndombele-Sisler, Psy.D.',
    'Fixed',
    NULL,
    '2024-05',
    15,
    0.00,
    0.00,
    30.00,
    '0',
    0.00,
    30.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-07-02',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    747,
    '216',
    'Elisa Ndombele-Sisler, Psy.D.',
    'Fixed',
    NULL,
    '2024-05',
    16,
    0.00,
    0.00,
    64.63,
    '0',
    0.00,
    64.63,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-07-02',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    748,
    '217',
    'Elizabeth Merrill, LCSW',
    'Normal',
    NULL,
    '2024-05',
    12,
    3482.69,
    7.00,
    243.79,
    NULL,
    0.00,
    243.79,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-07-03',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    749,
    '8',
    'Samantha Knox, LPC',
    'Normal',
    NULL,
    '2024-05',
    12,
    13614.02,
    9.00,
    1225.26,
    NULL,
    0.00,
    1225.26,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-07-03',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    750,
    '8',
    'Samantha Knox, LPC',
    'Normal',
    NULL,
    '2024-05',
    13,
    5298.08,
    9.00,
    476.83,
    NULL,
    0.00,
    476.83,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-07-03',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    751,
    '8',
    'Samantha Knox, LPC',
    'Fixed',
    NULL,
    '2024-05',
    15,
    0.00,
    0.00,
    8.00,
    '0',
    0.00,
    8.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-07-03',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    752,
    '4',
    'Onyx Therapy Group',
    'Normal',
    NULL,
    '2024-05',
    12,
    10212.44,
    9.00,
    919.12,
    NULL,
    0.00,
    919.12,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-07-03',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    753,
    '4',
    'Onyx Therapy Group',
    'Normal',
    NULL,
    '2024-05',
    13,
    5190.65,
    9.00,
    467.16,
    NULL,
    0.00,
    467.16,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-07-03',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    754,
    '4',
    'Onyx Therapy Group',
    'Fixed',
    NULL,
    '2024-05',
    15,
    0.00,
    0.00,
    150.00,
    '0',
    0.00,
    150.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-07-03',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    755,
    '10',
    'Yetta Lyle, LCPC',
    'Normal',
    NULL,
    '2024-05',
    12,
    1250.80,
    8.00,
    100.06,
    '0',
    0.00,
    100.06,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-07-03',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    756,
    '10',
    'Yetta Lyle, LCPC',
    'Normal',
    NULL,
    '2024-05',
    13,
    315.00,
    8.00,
    25.20,
    '0',
    0.00,
    25.20,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-07-03',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    757,
    '10',
    'Yetta Lyle, LCPC',
    'Fixed',
    NULL,
    '2024-05',
    15,
    0.00,
    0.00,
    0.00,
    '0',
    0.00,
    0.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-07-03',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    758,
    '37',
    'Caring Hands  Behavioral Health Center',
    'Normal',
    NULL,
    '2024-05',
    19,
    9266.35,
    7.30,
    676.44,
    NULL,
    0.00,
    676.44,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-07-04',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    759,
    '37',
    'Caring Hands  Behavioral Health Center',
    'Normal',
    NULL,
    '2024-05',
    20,
    19902.92,
    7.30,
    1452.91,
    NULL,
    0.00,
    1452.91,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-07-04',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    760,
    '2',
    'Create Your Life, LLC',
    'Normal',
    NULL,
    '2024-05',
    12,
    14439.58,
    8.00,
    1155.17,
    NULL,
    0.00,
    1155.17,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-07-04',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    761,
    '2',
    'Create Your Life, LLC',
    'Normal',
    47,
    '2024-05',
    13,
    2525.94,
    8.00,
    202.08,
    '1.00',
    25.26,
    176.82,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2024-07-04',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    762,
    '2',
    'Create Your Life, LLC',
    'Fixed',
    NULL,
    '2024-05',
    16,
    0.00,
    0.00,
    30.10,
    '0',
    0.00,
    30.10,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-07-04',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    763,
    '2',
    'Create Your Life, LLC',
    'Fixed',
    NULL,
    '2024-05',
    15,
    0.00,
    0.00,
    50.00,
    '0',
    0.00,
    50.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-07-04',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    764,
    '2',
    'Create Your Life, LLC',
    'Fixed',
    NULL,
    '2024-05',
    18,
    0.00,
    0.00,
    10.00,
    '0',
    0.00,
    10.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-07-04',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    765,
    '13',
    'Karen L. Allen, LCSW-C',
    'Normal',
    NULL,
    '2024-05',
    12,
    2858.27,
    8.00,
    228.66,
    '0',
    0.00,
    228.66,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-07-04',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    766,
    '13',
    'Karen L. Allen, LCSW-C',
    'Normal',
    47,
    '2024-05',
    13,
    410.42,
    8.00,
    32.83,
    '1.00',
    4.10,
    28.73,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2024-07-04',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    767,
    '13',
    'Karen L. Allen, LCSW-C',
    'Fixed',
    NULL,
    '2024-05',
    16,
    0.00,
    0.00,
    24.42,
    '0',
    0.00,
    24.42,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-07-04',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    768,
    '13',
    'Karen L. Allen, LCSW-C',
    'Fixed',
    NULL,
    '2024-05',
    15,
    0.00,
    0.00,
    30.00,
    '0',
    0.00,
    30.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-07-04',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    769,
    '36',
    'Sothia Green, PsyD',
    'Normal',
    NULL,
    '2024-05',
    12,
    3983.41,
    5.00,
    199.17,
    '0',
    0.00,
    199.17,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-07-04',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    770,
    '36',
    'Sothia Green, PsyD',
    'Normal',
    NULL,
    '2024-05',
    13,
    135.00,
    5.00,
    6.75,
    NULL,
    0.00,
    6.75,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-07-04',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    771,
    '36',
    'Sothia Green, PsyD',
    'Fixed',
    NULL,
    '2024-05',
    16,
    0.00,
    0.00,
    75.98,
    '0',
    0.00,
    75.98,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-07-04',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    772,
    '19',
    'Nicole Rudd, LCPC',
    'Normal',
    NULL,
    '2024-05',
    12,
    5180.77,
    7.50,
    388.56,
    NULL,
    0.00,
    388.56,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-07-04',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    773,
    '19',
    'Nicole Rudd, LCPC',
    'Normal',
    NULL,
    '2024-05',
    13,
    507.00,
    7.50,
    38.02,
    NULL,
    0.00,
    38.02,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-07-04',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    774,
    '19',
    'Nicole Rudd, LCPC',
    'Fixed',
    NULL,
    '2024-05',
    16,
    0.00,
    0.00,
    0.00,
    '0',
    0.00,
    0.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-07-04',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    775,
    '20',
    'Carla D. Washington, LPC',
    'Normal',
    38,
    '2024-05',
    12,
    16275.25,
    8.50,
    1383.40,
    '3.00',
    488.26,
    895.14,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2024-07-16',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    776,
    '20',
    'Carla D. Washington, LPC',
    'Normal',
    47,
    '2024-05',
    13,
    7080.21,
    8.50,
    601.82,
    '1.00',
    70.80,
    531.02,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2024-07-16',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    777,
    '20',
    'Carla D. Washington, LPC',
    'Fixed',
    NULL,
    '2024-05',
    16,
    0.00,
    0.00,
    452.18,
    '0',
    0.00,
    452.18,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-07-16',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    778,
    '20',
    'Carla D. Washington, LPC',
    'Fixed',
    NULL,
    '2024-05',
    14,
    0.00,
    0.00,
    189.00,
    '0',
    0.00,
    189.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-07-16',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    779,
    '21',
    'Donna Reid Washington, LPC',
    'Fixed',
    NULL,
    '2024-05',
    14,
    0.00,
    0.00,
    189.00,
    '0',
    0.00,
    189.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-07-16',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    780,
    '21',
    'Donna Reid Washington, LPC',
    'Normal',
    38,
    '2024-05',
    12,
    4779.88,
    8.00,
    382.39,
    '3.00',
    143.40,
    238.99,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2024-07-16',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    781,
    '21',
    'Donna Reid Washington, LPC',
    'Normal',
    47,
    '2024-05',
    13,
    1595.00,
    8.00,
    127.60,
    '1.00',
    15.95,
    111.65,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2024-07-16',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    782,
    '21',
    'Donna Reid Washington, LPC',
    'Fixed',
    NULL,
    '2024-05',
    16,
    0.00,
    0.00,
    165.33,
    '0',
    0.00,
    165.33,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-07-16',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    783,
    '5',
    'LaCole Cole, LCPC',
    'Normal',
    NULL,
    '2024-05',
    12,
    18200.79,
    8.50,
    1547.07,
    NULL,
    0.00,
    1547.07,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-07-16',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    784,
    '5',
    'LaCole Cole, LCPC',
    'Normal',
    NULL,
    '2024-05',
    13,
    1498.00,
    8.50,
    127.33,
    NULL,
    0.00,
    127.33,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-07-16',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    785,
    '5',
    'LaCole Cole, LCPC',
    'Fixed',
    NULL,
    '2024-05',
    16,
    0.00,
    0.00,
    26.78,
    '0',
    0.00,
    26.78,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-07-16',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    786,
    '5',
    'LaCole Cole, LCPC',
    'Fixed',
    NULL,
    '2024-05',
    15,
    0.00,
    0.00,
    30.00,
    '0',
    0.00,
    30.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-07-16',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    787,
    '34',
    'Better Days Counseling, LLC',
    'Normal',
    NULL,
    '2024-05',
    12,
    23041.21,
    8.50,
    1958.50,
    NULL,
    0.00,
    1958.50,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-07-16',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    788,
    '34',
    'Better Days Counseling, LLC',
    'Normal',
    47,
    '2024-05',
    13,
    2963.98,
    8.50,
    251.94,
    '1.00',
    29.64,
    222.30,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2024-07-16',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    789,
    '34',
    'Better Days Counseling, LLC',
    'Fixed',
    NULL,
    '2024-05',
    16,
    0.00,
    0.00,
    0.00,
    '0',
    0.00,
    0.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-07-16',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    790,
    '34',
    'Better Days Counseling, LLC',
    'Fixed',
    NULL,
    '2024-05',
    15,
    0.00,
    0.00,
    60.00,
    '0',
    0.00,
    60.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-07-16',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    791,
    '17',
    'Apex - Bharat Vallurapalli, MS, OTR/L',
    'Fixed',
    NULL,
    '2024-06',
    14,
    0.00,
    0.00,
    189.00,
    '0',
    0.00,
    189.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-07-17',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    792,
    '17',
    'Apex - Bharat Vallurapalli, MS, OTR/L',
    'Normal',
    38,
    '2024-06',
    12,
    1529.53,
    8.00,
    122.36,
    '3.00',
    45.89,
    76.48,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2024-07-17',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    793,
    '17',
    'Apex - Bharat Vallurapalli, MS, OTR/L',
    'Normal',
    47,
    '2024-06',
    13,
    1839.70,
    8.00,
    147.18,
    '1.00',
    18.40,
    128.78,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2024-07-17',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    794,
    '17',
    'Apex - Bharat Vallurapalli, MS, OTR/L',
    'Fixed',
    NULL,
    '2024-06',
    16,
    0.00,
    0.00,
    132.34,
    '0',
    0.00,
    132.34,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-07-17',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    795,
    '16',
    'Donna R. Inman, LPC',
    'Normal',
    42,
    '2024-06',
    12,
    1822.86,
    8.50,
    154.94,
    '2.00',
    36.46,
    118.49,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2024-07-17',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    796,
    '16',
    'Donna R. Inman, LPC',
    'Normal',
    NULL,
    '2024-06',
    13,
    655.00,
    8.50,
    55.68,
    NULL,
    0.00,
    55.68,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-07-17',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    797,
    '16',
    'Donna R. Inman, LPC',
    'Fixed',
    NULL,
    '2024-06',
    16,
    0.00,
    0.00,
    0.00,
    '0',
    0.00,
    0.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-07-17',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    798,
    '16',
    'Donna R. Inman, LPC',
    'Fixed',
    NULL,
    '2024-06',
    15,
    0.00,
    0.00,
    15.00,
    '0',
    0.00,
    15.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-07-17',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    799,
    '26',
    'Wanda D. Smith, LCSW-C',
    'Normal',
    NULL,
    '2024-06',
    12,
    549.85,
    8.50,
    46.74,
    '0',
    0.00,
    46.74,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-07-17',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    800,
    '26',
    'Wanda D. Smith, LCSW-C',
    'Normal',
    NULL,
    '2024-06',
    13,
    0.00,
    8.50,
    0.00,
    NULL,
    0.00,
    0.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-07-17',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    801,
    '1',
    'Jacqueline R. Williams, LCSW',
    'Normal',
    NULL,
    '2024-06',
    12,
    13713.86,
    8.00,
    1097.11,
    NULL,
    0.00,
    1097.11,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-07-17',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    802,
    '1',
    'Jacqueline R. Williams, LCSW',
    'Normal',
    47,
    '2024-06',
    13,
    900.00,
    8.00,
    72.00,
    '1.00',
    9.00,
    63.00,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2024-07-17',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    803,
    '1',
    'Jacqueline R. Williams, LCSW',
    'Fixed',
    NULL,
    '2024-06',
    16,
    0.00,
    0.00,
    20.42,
    '0',
    0.00,
    20.42,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-07-17',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    804,
    '1',
    'Jacqueline R. Williams, LCSW',
    'Fixed',
    NULL,
    '2024-06',
    15,
    0.00,
    0.00,
    25.00,
    '0',
    0.00,
    25.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-07-17',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    805,
    '31',
    'The Bridges Wellness Group',
    'Normal',
    NULL,
    '2024-06',
    12,
    9090.02,
    8.50,
    772.65,
    NULL,
    0.00,
    772.65,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-07-17',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    806,
    '31',
    'The Bridges Wellness Group',
    'Normal',
    47,
    '2024-06',
    13,
    873.45,
    8.50,
    74.24,
    '1.00',
    8.73,
    65.51,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2024-07-17',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    807,
    '31',
    'The Bridges Wellness Group',
    'Fixed',
    NULL,
    '2024-06',
    16,
    0.00,
    0.00,
    20.43,
    '0',
    0.00,
    20.43,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-07-17',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    808,
    '31',
    'The Bridges Wellness Group',
    'Fixed',
    NULL,
    '2024-06',
    15,
    0.00,
    0.00,
    70.00,
    '0',
    0.00,
    70.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-07-17',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    809,
    '34',
    'Better Days Counseling, LLC',
    'Normal',
    NULL,
    '2024-06',
    12,
    10491.40,
    8.50,
    891.77,
    NULL,
    0.00,
    891.77,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-07-17',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    810,
    '34',
    'Better Days Counseling, LLC',
    'Normal',
    47,
    '2024-06',
    13,
    3173.31,
    8.50,
    269.73,
    '1.00',
    31.73,
    238.00,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2024-07-17',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    811,
    '34',
    'Better Days Counseling, LLC',
    'Fixed',
    NULL,
    '2024-06',
    16,
    0.00,
    0.00,
    0.00,
    '0',
    0.00,
    0.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-07-17',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    812,
    '34',
    'Better Days Counseling, LLC',
    'Fixed',
    NULL,
    '2024-06',
    15,
    0.00,
    0.00,
    75.00,
    '0',
    0.00,
    75.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-07-17',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    813,
    '24',
    'Winnie Moore, LCPC',
    'Normal',
    38,
    '2024-05',
    12,
    32181.25,
    8.00,
    2574.50,
    '3.00',
    965.44,
    1609.06,
    'NOT INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2024-07-29',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    814,
    '19',
    'Nicole Rudd, LCPC',
    'Normal',
    53,
    '2024-06',
    12,
    14345.55,
    7.50,
    1075.92,
    '1.50',
    215.18,
    860.73,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2024-08-01',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    815,
    '19',
    'Nicole Rudd, LCPC',
    'Normal',
    NULL,
    '2024-06',
    13,
    355.00,
    7.50,
    26.63,
    NULL,
    0.00,
    26.63,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-08-01',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    816,
    '19',
    'Nicole Rudd, LCPC',
    'Fixed',
    NULL,
    '2024-06',
    16,
    0.00,
    0.00,
    0.00,
    '0',
    0.00,
    0.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-08-01',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    818,
    '6',
    'Lenese Stephens, LCPC',
    'Normal',
    NULL,
    '2024-06',
    13,
    9422.06,
    8.50,
    800.88,
    NULL,
    0.00,
    800.88,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-08-01',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    819,
    '6',
    'Lenese Stephens, LCPC',
    'Fixed',
    NULL,
    '2024-06',
    16,
    0.00,
    0.00,
    0.00,
    '0',
    0.00,
    0.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-08-01',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    835,
    '24',
    'Winnie Moore, LCPC',
    'Normal',
    38,
    '2024-06',
    12,
    18255.13,
    8.00,
    1460.41,
    '3.00',
    547.65,
    912.76,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2024-08-01',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    836,
    '24',
    'Winnie Moore, LCPC',
    'Normal',
    47,
    '2024-06',
    13,
    4683.50,
    8.00,
    374.68,
    '1.00',
    46.84,
    327.85,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2024-08-01',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    837,
    '24',
    'Winnie Moore, LCPC',
    'Fixed',
    NULL,
    '2024-06',
    16,
    0.00,
    0.00,
    30.73,
    '0',
    0.00,
    30.73,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-08-01',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    838,
    '24',
    'Winnie Moore, LCPC',
    'Fixed',
    NULL,
    '2024-06',
    15,
    0.00,
    0.00,
    30.00,
    '0',
    0.00,
    30.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-08-01',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    839,
    '12',
    'Joy R. Hart, LCSW-C',
    'Normal',
    38,
    '2024-06',
    12,
    9734.30,
    10.00,
    973.43,
    '3.00',
    292.03,
    681.40,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2024-08-01',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    840,
    '12',
    'Joy R. Hart, LCSW-C',
    'Normal',
    NULL,
    '2024-06',
    13,
    1334.94,
    10.00,
    133.49,
    NULL,
    0.00,
    133.49,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-08-01',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    841,
    '12',
    'Joy R. Hart, LCSW-C',
    'Fixed',
    NULL,
    '2024-06',
    15,
    0.00,
    0.00,
    75.00,
    '0',
    0.00,
    75.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-08-01',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    842,
    '30',
    'Danielle Rogal-Hudespeth, LCPC',
    'Normal',
    38,
    '2024-06',
    12,
    3588.34,
    9.00,
    322.95,
    '3.00',
    107.65,
    215.30,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2024-08-01',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    843,
    '30',
    'Danielle Rogal-Hudespeth, LCPC',
    'Fixed',
    NULL,
    '2024-06',
    15,
    0.00,
    0.00,
    3.00,
    '0',
    0.00,
    3.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-08-01',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    844,
    '7',
    'Nji J. Fru, CNPR',
    'Normal',
    NULL,
    '2024-06',
    12,
    3892.85,
    8.50,
    330.89,
    NULL,
    0.00,
    330.89,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-08-01',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    845,
    '7',
    'Nji J. Fru, CNPR',
    'Normal',
    47,
    '2024-06',
    13,
    500.45,
    8.50,
    42.54,
    '1.00',
    5.00,
    37.53,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2024-08-01',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    846,
    '7',
    'Nji J. Fru, CNPR',
    'Fixed',
    NULL,
    '2024-06',
    16,
    0.00,
    0.00,
    37.52,
    '0',
    0.00,
    37.52,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-08-01',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    847,
    '3',
    'Karena Wilson-Plater, PsyD',
    'Normal',
    NULL,
    '2024-06',
    12,
    550.77,
    8.50,
    46.82,
    NULL,
    0.00,
    46.82,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-08-01',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    848,
    '3',
    'Karena Wilson-Plater, PsyD',
    'Normal',
    NULL,
    '2024-06',
    13,
    895.00,
    8.50,
    76.08,
    NULL,
    0.00,
    76.08,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-08-01',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    849,
    '3',
    'Karena Wilson-Plater, PsyD',
    'Fixed',
    NULL,
    '2024-06',
    16,
    0.00,
    0.00,
    0.00,
    '0',
    0.00,
    0.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-08-01',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    850,
    '3',
    'Karena Wilson-Plater, PsyD',
    'Fixed',
    NULL,
    '2024-06',
    15,
    0.00,
    0.00,
    30.00,
    '0',
    0.00,
    30.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-08-01',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    851,
    '15',
    'Glenda Bullock-Willis, LCPC',
    'Normal',
    NULL,
    '2024-06',
    12,
    937.61,
    8.50,
    79.70,
    NULL,
    0.00,
    79.70,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-08-01',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    852,
    '15',
    'Glenda Bullock-Willis, LCPC',
    'Normal',
    NULL,
    '2024-06',
    13,
    70.00,
    8.50,
    5.95,
    NULL,
    0.00,
    5.95,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-08-01',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    853,
    '15',
    'Glenda Bullock-Willis, LCPC',
    'Fixed',
    NULL,
    '2024-06',
    16,
    0.00,
    0.00,
    19.95,
    '0',
    0.00,
    19.95,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-08-01',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    854,
    '14',
    'Gillian Blackman-Diarra, LCSW-C',
    'Normal',
    42,
    '2024-06',
    12,
    1807.29,
    8.50,
    153.62,
    '2.00',
    36.15,
    117.47,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2024-08-01',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    855,
    '14',
    'Gillian Blackman-Diarra, LCSW-C',
    'Normal',
    47,
    '2024-06',
    13,
    410.00,
    8.50,
    34.85,
    '1.00',
    4.10,
    30.75,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2024-08-01',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    856,
    '14',
    'Gillian Blackman-Diarra, LCSW-C',
    'Fixed',
    NULL,
    '2024-06',
    16,
    0.00,
    0.00,
    5.70,
    '0',
    0.00,
    5.70,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-08-01',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    857,
    '29',
    'Dalton Johnson, LCPC',
    'Normal',
    NULL,
    '2024-06',
    12,
    4362.87,
    8.50,
    370.84,
    NULL,
    0.00,
    370.84,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-08-01',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    858,
    '29',
    'Dalton Johnson, LCPC',
    'Normal',
    NULL,
    '2024-06',
    13,
    568.12,
    8.50,
    48.29,
    NULL,
    0.00,
    48.29,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-08-01',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    859,
    '29',
    'Dalton Johnson, LCPC',
    'Fixed',
    NULL,
    '2024-06',
    16,
    0.00,
    0.00,
    0.00,
    '0',
    0.00,
    0.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-08-01',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    860,
    '216',
    'Elisa Ndombele-Sisler, Psy.D.',
    'Normal',
    NULL,
    '2024-06',
    12,
    14818.89,
    9.00,
    1333.70,
    NULL,
    0.00,
    1333.70,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-08-01',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    861,
    '216',
    'Elisa Ndombele-Sisler, Psy.D.',
    'Normal',
    NULL,
    '2024-06',
    13,
    1650.69,
    9.00,
    148.56,
    NULL,
    0.00,
    148.56,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-08-01',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    862,
    '216',
    'Elisa Ndombele-Sisler, Psy.D.',
    'Fixed',
    NULL,
    '2024-06',
    15,
    0.00,
    0.00,
    30.00,
    '0',
    0.00,
    30.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-08-01',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    863,
    '216',
    'Elisa Ndombele-Sisler, Psy.D.',
    'Fixed',
    NULL,
    '2024-06',
    16,
    0.00,
    0.00,
    0.00,
    '0',
    0.00,
    0.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-08-01',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    864,
    '217',
    'Elizabeth Merrill, LCSW',
    'Normal',
    42,
    '2024-06',
    12,
    4313.75,
    7.00,
    301.96,
    '2.00',
    86.28,
    215.69,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2024-08-01',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    865,
    '4',
    'Onyx Therapy Group',
    'Normal',
    NULL,
    '2024-06',
    12,
    11048.43,
    9.00,
    994.36,
    '0',
    0.00,
    994.36,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-08-01',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    866,
    '4',
    'Onyx Therapy Group',
    'Normal',
    NULL,
    '2024-06',
    13,
    5200.46,
    9.00,
    468.04,
    '0',
    0.00,
    468.04,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-08-01',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    867,
    '4',
    'Onyx Therapy Group',
    'Fixed',
    NULL,
    '2024-06',
    15,
    0.00,
    0.00,
    150.00,
    '0',
    0.00,
    150.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-08-01',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    868,
    '10',
    'Yetta Lyle, LCPC',
    'Normal',
    NULL,
    '2024-06',
    12,
    192.04,
    8.00,
    15.36,
    NULL,
    0.00,
    15.36,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-08-01',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    869,
    '10',
    'Yetta Lyle, LCPC',
    'Normal',
    NULL,
    '2024-06',
    13,
    65.00,
    8.00,
    5.20,
    '0',
    0.00,
    5.20,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-08-01',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    870,
    '10',
    'Yetta Lyle, LCPC',
    'Fixed',
    NULL,
    '2024-06',
    15,
    0.00,
    0.00,
    8.00,
    '0',
    0.00,
    8.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-08-01',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    871,
    '6',
    'Lenese Stephens, LCPC',
    'Normal',
    53,
    '2024-06',
    12,
    44673.36,
    8.50,
    3797.24,
    '1.50',
    670.10,
    3127.14,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2024-08-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    872,
    '6',
    'Lenese Stephens, LCPC',
    'Fixed',
    NULL,
    '2024-06',
    15,
    0.00,
    0.00,
    30.00,
    '0',
    0.00,
    30.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-08-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    873,
    '37',
    'Caring Hands  Behavioral Health Center',
    'Normal',
    NULL,
    '2024-06',
    19,
    7945.58,
    7.30,
    580.03,
    NULL,
    0.00,
    580.03,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-08-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    874,
    '37',
    'Caring Hands  Behavioral Health Center',
    'Normal',
    NULL,
    '2024-06',
    20,
    23016.11,
    7.30,
    1680.18,
    NULL,
    0.00,
    1680.18,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-08-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    875,
    '2',
    'Create Your Life, LLC',
    'Normal',
    NULL,
    '2024-06',
    12,
    14595.36,
    8.00,
    1167.63,
    '0',
    0.00,
    1167.63,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-08-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    876,
    '2',
    'Create Your Life, LLC',
    'Normal',
    47,
    '2024-06',
    13,
    2810.76,
    8.00,
    224.86,
    '1.00',
    28.11,
    196.75,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2024-08-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    877,
    '2',
    'Create Your Life, LLC',
    'Fixed',
    NULL,
    '2024-06',
    16,
    0.00,
    0.00,
    46.18,
    '0',
    0.00,
    46.18,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-08-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    878,
    '2',
    'Create Your Life, LLC',
    'Fixed',
    NULL,
    '2024-06',
    15,
    0.00,
    0.00,
    50.00,
    '0',
    0.00,
    50.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-08-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    879,
    '2',
    'Create Your Life, LLC',
    'Fixed',
    NULL,
    '2024-06',
    18,
    0.00,
    0.00,
    10.00,
    '0',
    0.00,
    10.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-08-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    880,
    '13',
    'Karen L. Allen, LCSW-C',
    'Normal',
    NULL,
    '2024-06',
    12,
    4564.53,
    8.00,
    365.16,
    NULL,
    0.00,
    365.16,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-08-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    881,
    '13',
    'Karen L. Allen, LCSW-C',
    'Normal',
    47,
    '2024-06',
    13,
    325.00,
    8.00,
    26.00,
    '1.00',
    3.25,
    22.75,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2024-08-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    882,
    '13',
    'Karen L. Allen, LCSW-C',
    'Fixed',
    NULL,
    '2024-06',
    16,
    0.00,
    0.00,
    0.00,
    '0',
    0.00,
    0.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-08-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    883,
    '13',
    'Karen L. Allen, LCSW-C',
    'Fixed',
    NULL,
    '2024-06',
    15,
    0.00,
    0.00,
    30.00,
    '0',
    0.00,
    30.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-08-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    884,
    '36',
    'Sothia Green, PsyD',
    'Normal',
    NULL,
    '2024-06',
    12,
    451.77,
    5.00,
    22.59,
    NULL,
    0.00,
    22.59,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-08-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    885,
    '36',
    'Sothia Green, PsyD',
    'Normal',
    NULL,
    '2024-06',
    13,
    0.00,
    5.00,
    0.00,
    NULL,
    0.00,
    0.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-08-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    886,
    '36',
    'Sothia Green, PsyD',
    'Fixed',
    NULL,
    '2024-06',
    16,
    0.00,
    0.00,
    7.60,
    '0',
    0.00,
    7.60,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-08-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    887,
    '20',
    'Carla D. Washington, LPC',
    'Normal',
    38,
    '2024-06',
    12,
    20808.49,
    8.50,
    1768.72,
    '3.00',
    624.25,
    1144.47,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2024-08-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    888,
    '20',
    'Carla D. Washington, LPC',
    'Normal',
    47,
    '2024-06',
    13,
    7311.62,
    8.50,
    621.49,
    '1.00',
    73.12,
    548.37,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2024-08-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    889,
    '20',
    'Carla D. Washington, LPC',
    'Fixed',
    NULL,
    '2024-06',
    16,
    0.00,
    0.00,
    424.37,
    '0',
    0.00,
    424.37,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-08-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    890,
    '20',
    'Carla D. Washington, LPC',
    'Fixed',
    NULL,
    '2024-06',
    14,
    0.00,
    0.00,
    189.00,
    '0',
    0.00,
    189.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-08-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    891,
    '21',
    'Donna Reid Washington, LPC',
    'Fixed',
    NULL,
    '2024-06',
    14,
    0.00,
    0.00,
    189.00,
    '0',
    0.00,
    189.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-08-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    892,
    '21',
    'Donna Reid Washington, LPC',
    'Normal',
    38,
    '2024-06',
    12,
    5242.29,
    8.00,
    419.38,
    '3.00',
    157.27,
    262.11,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2024-08-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    893,
    '21',
    'Donna Reid Washington, LPC',
    'Normal',
    47,
    '2024-06',
    13,
    3317.75,
    8.00,
    265.42,
    '1.00',
    33.18,
    232.24,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2024-08-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    894,
    '21',
    'Donna Reid Washington, LPC',
    'Fixed',
    NULL,
    '2024-06',
    16,
    0.00,
    0.00,
    234.90,
    '0',
    0.00,
    234.90,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-08-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    895,
    '214',
    'For Every Mountain Counseling Services, LLC',
    'Normal',
    47,
    '2024-06',
    13,
    3284.56,
    7.50,
    246.34,
    '1.00',
    32.85,
    213.50,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2024-08-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    896,
    '214',
    'For Every Mountain Counseling Services, LLC',
    'Fixed',
    NULL,
    '2024-06',
    15,
    0.00,
    0.00,
    60.00,
    '0',
    0.00,
    60.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-08-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    897,
    '214',
    'For Every Mountain Counseling Services, LLC',
    'Fixed',
    NULL,
    '2024-06',
    16,
    0.00,
    0.00,
    73.95,
    '0',
    0.00,
    73.95,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-08-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    898,
    '214',
    'For Every Mountain Counseling Services, LLC',
    'Normal',
    NULL,
    '2024-06',
    12,
    25236.53,
    7.50,
    1892.74,
    NULL,
    0.00,
    1892.74,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-08-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    899,
    '5',
    'LaCole Cole, LCPC',
    'Normal',
    NULL,
    '2024-06',
    12,
    15332.27,
    8.50,
    1303.24,
    NULL,
    0.00,
    1303.24,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-08-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    900,
    '5',
    'LaCole Cole, LCPC',
    'Normal',
    NULL,
    '2024-06',
    13,
    405.00,
    8.50,
    34.43,
    NULL,
    0.00,
    34.43,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-08-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    901,
    '5',
    'LaCole Cole, LCPC',
    'Fixed',
    NULL,
    '2024-06',
    16,
    0.00,
    0.00,
    0.00,
    '0',
    0.00,
    0.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-08-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    902,
    '5',
    'LaCole Cole, LCPC',
    'Fixed',
    NULL,
    '2024-06',
    15,
    0.00,
    0.00,
    30.00,
    '0',
    0.00,
    30.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-08-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    903,
    '8',
    'Samantha Knox, LPC',
    'Normal',
    NULL,
    '2024-06',
    12,
    6862.20,
    9.00,
    617.60,
    NULL,
    0.00,
    617.60,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-08-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    904,
    '8',
    'Samantha Knox, LPC',
    'Normal',
    NULL,
    '2024-06',
    13,
    5695.36,
    9.00,
    512.58,
    '0',
    0.00,
    512.58,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-08-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    905,
    '8',
    'Samantha Knox, LPC',
    'Fixed',
    NULL,
    '2024-06',
    15,
    0.00,
    0.00,
    0.00,
    '0',
    0.00,
    0.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-08-06',
    1
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: company_details_table
# ------------------------------------------------------------

INSERT INTO
  `company_details_table` (
    `Id`,
    `CompanyName`,
    `TaxID`,
    `Phone`,
    `Email`,
    `Web`,
    `OwnerName`,
    `OwnerPhone`,
    `EstablishDate`,
    `DateCreated`,
    `Address`,
    `OtherDetails`,
    `DigitalSignature`,
    `Logo`,
    `CreatedBy`,
    `CreatedID`
  )
VALUES
  (
    1,
    'Billing Plus, Inc.',
    '461361749',
    '3012023739',
    'ismith@billing-plus.com',
    'www.billing-plus.com',
    'Irish Smith',
    '3012023739',
    '2006-07-15',
    '1899-11-30',
    '4315 Northview Drive\r\nBowie, MD  20716',
    '',
    NULL,
    NOFORMAT_WRAP(
      "##X'[BLOB]