Versions Compared

Old Version 4

changes.mady.by.user Brian Dixon

Saved on

compared with

New Version 5

changes.mady.by.user Frank Zerillo

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

As call records age, they are less and less useful, especially when some data has errors and cannot be recovered for Billing. Based on a Tenant setting ("CALL AGING"), the Call records will be archived on a routine basis by the system. No user interaction is needed for this. If the Tenant "CALL AGING" value is set to 0 or blank, then the default value of 90 days will be used.

Criteria

  • Call records are archived according to these rules:
    1. Call Date/Time is not NULL (if no Call Date/Time has been determined for a Call record, it will never be archived)
    2. Call's Last Modified Date is older than Tenants "CALL AGING" value (default 90 days)
    3. Call has been billed (Usage Status = "BILLED") or has unbillable data (Usage Status is "UNBILLABLE", "DUPLICATE", or "UNRECOVERABLE_ERROR")'s Created Date is older than Tenants "CALL AGING" value. The Created Date is the date the Call was created or imported into the system. This value is not visible on the Call Details grid, so it can make it diffucult to verify that the archive process is working correctly. You might see calls that have a Call Date/Time that are somewhat older than the "CALL AGING" value. This is especially true for vendor file calls, which usually get imported several weeks after the calls were actually made.
    4. Call has been Billed or is in an Error Status. If the Status is Raw (waiting to be Rated) or Rated (waiting to be Billed), then the call cannot be Archived.
  • Calls are archived according to the 2-digit year and 2-digit month of the Call Date/Time:
    1. Table CALL_DETAILS_1505 would contain records for Call Date/Time in May 2015.
    2. If the Call Date/Time is invalid, then the Call will get Archived to the CALL_DETAILS_9999 table.

NOTE: We realize this would introduce possible issues at the turn of the next century, but we have to account for the table, index, and foreign key names fitting within specific length restrictions. We hope to have our grandchildren address this issue before the year 2099.

  • Archived data can be viewed using the Call Details Grid. This is available from the Admin section, or from individual Services and AuthCodes. The interface changes for viewing archived data are discussed below.

...