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
  (
    1423,
    '19',
    'Nicole Rudd, LCPC',
    'Fixed',
    NULL,
    '2024-11',
    16,
    0.00,
    0.00,
    0.00,
    '0',
    0.00,
    0.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-12-30',
    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
  (
    1424,
    '2',
    'Create Your Life, LLC',
    'Normal',
    NULL,
    '2024-11',
    12,
    9851.47,
    8.00,
    788.12,
    NULL,
    0.00,
    788.12,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-12-30',
    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
  (
    1425,
    '2',
    'Create Your Life, LLC',
    'Normal',
    47,
    '2024-11',
    13,
    2095.19,
    8.00,
    167.62,
    '1.00',
    20.95,
    146.66,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2024-12-30',
    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
  (
    1426,
    '2',
    'Create Your Life, LLC',
    'Fixed',
    NULL,
    '2024-11',
    16,
    0.00,
    0.00,
    275.07,
    '0',
    0.00,
    275.07,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-12-30',
    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
  (
    1427,
    '2',
    'Create Your Life, LLC',
    'Fixed',
    NULL,
    '2024-11',
    15,
    0.00,
    0.00,
    50.00,
    '0',
    0.00,
    50.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-12-30',
    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
  (
    1428,
    '2',
    'Create Your Life, LLC',
    'Fixed',
    NULL,
    '2024-11',
    18,
    0.00,
    0.00,
    10.00,
    '0',
    0.00,
    10.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-12-30',
    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
  (
    1429,
    '13',
    'Karen L. Allen, LCSW-C',
    'Normal',
    NULL,
    '2024-11',
    12,
    2331.44,
    8.00,
    186.52,
    '0',
    0.00,
    186.52,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-12-30',
    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
  (
    1430,
    '13',
    'Karen L. Allen, LCSW-C',
    'Normal',
    47,
    '2024-11',
    13,
    728.42,
    8.00,
    58.27,
    '1.00',
    7.28,
    50.99,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2024-12-30',
    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
  (
    1431,
    '13',
    'Karen L. Allen, LCSW-C',
    'Fixed',
    NULL,
    '2024-11',
    16,
    0.00,
    0.00,
    403.45,
    '0',
    0.00,
    403.45,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-12-30',
    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
  (
    1432,
    '13',
    'Karen L. Allen, LCSW-C',
    'Fixed',
    NULL,
    '2024-11',
    15,
    0.00,
    0.00,
    30.00,
    '0',
    0.00,
    30.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-12-30',
    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
  (
    1433,
    '222',
    'Linda Kalle',
    'Normal',
    NULL,
    '2024-11',
    12,
    1444.43,
    7.50,
    108.33,
    NULL,
    0.00,
    108.33,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-12-30',
    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
  (
    1434,
    '222',
    'Linda Kalle',
    'Normal',
    NULL,
    '2024-11',
    13,
    441.36,
    7.50,
    33.10,
    NULL,
    0.00,
    33.10,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-12-30',
    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
  (
    1435,
    '222',
    'Linda Kalle',
    'Normal',
    NULL,
    '2024-10',
    12,
    817.19,
    7.50,
    61.29,
    '0',
    0.00,
    61.29,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-12-30',
    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
  (
    1436,
    '224',
    'Grace and Mercy Community Services, Inc.',
    'Normal',
    NULL,
    '2024-11',
    19,
    13111.91,
    4.00,
    524.48,
    NULL,
    0.00,
    524.48,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-12-30',
    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
  (
    1437,
    '224',
    'Grace and Mercy Community Services, Inc.',
    'Normal',
    NULL,
    '2024-11',
    20,
    15580.32,
    4.00,
    623.21,
    NULL,
    0.00,
    623.21,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-12-30',
    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
  (
    1438,
    '37',
    'Caring Hands  Behavioral Health Center',
    'Normal',
    NULL,
    '2024-11',
    19,
    17955.53,
    7.30,
    1310.75,
    NULL,
    0.00,
    1310.75,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-12-30',
    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
  (
    1439,
    '37',
    'Caring Hands  Behavioral Health Center',
    'Normal',
    NULL,
    '2024-11',
    20,
    24879.21,
    7.30,
    1816.18,
    NULL,
    0.00,
    1816.18,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-12-30',
    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
  (
    1440,
    '4',
    'Onyx Therapy Group',
    'Normal',
    NULL,
    '2024-11',
    12,
    14669.46,
    9.00,
    1320.25,
    NULL,
    0.00,
    1320.25,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-12-30',
    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
  (
    1441,
    '4',
    'Onyx Therapy Group',
    'Normal',
    47,
    '2024-11',
    13,
    5075.23,
    9.00,
    456.77,
    '1.00',
    50.75,
    406.02,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2024-12-30',
    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
  (
    1442,
    '4',
    'Onyx Therapy Group',
    'Fixed',
    NULL,
    '2024-11',
    15,
    0.00,
    0.00,
    150.00,
    '0',
    0.00,
    150.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-12-30',
    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]