Parameter | Affects Data in Table(s) - Records are DELETED | Affects Data in Table(s) - References are set to NULL | Comments | Standard Value jtel Installations* | Comments / Affects |
---|
Acd.AcdEventsConfServer.Statistics.ConfStatsPartA.MaxAgeDays | JTELWeb.ConfStatsPartAAcdEvents JTELWeb.ConfStatsPartB | This affects the availability of uncompressed historical data on conferences and their participants, and affects the availability of historical reports based on this data. | ConfServer.Statistics.ConfStatsPartI.MaxAgeDays | JTELWeb.ConfStatsPartI | This affects the availability of uncompressed historical data on conference invitations, and affects the availability of historical reports based on this data. | AcdEventsHistory | 214 | ACD events such as callbacks, voice mails or chat sessions, and their associated history. |
ACD.Whatsapp.Resources.MaxAgeDays |
| 5 | Attachments to whatsapp messages. After this period of time, the attachment will be deleted from the system. Note: this does not affect the availability of the rest of the chat session. |
ConfServer.Conference.RecordingPINs.MaxAgeDays | JTELWeb.ConferenceRecordingPINs | 7 | Conference recording PINs used to listen to the recording of a conference will become invalid after this period of time. |
ConfServer.Statistics.ConfStatsPartA.MaxAgeDays | JTELWeb.ConfStatsPartA JTELWeb.ConfStatsPartB | 762 | Uncompressed historical data on conferences and their participants | Portal.Routing.CounterDetailStatistics.MaxAgeDays | JTELWeb.CounterDetailStatistics | This affects the availability of detail counter statistics for IVR applications, and affects the availability of the counters shown when a routing application's counters are accessed via the web application. | Portal.Statistics.AcdStatisticsChatTransactionCodes.MaxAgeDays | JTELStats.AcdStatisticsChatTransactionCodes | This affects the availability of uncompressed historical data on transaction codes for chat sessions, and affects the availability of historical reports based on this data. |
PortalConfServer.Statistics.AcdStatisticsLoginConfStatsPartI.MaxAgeDaysJTELStats | JTELWeb.AcdStatisticsLogin JTELStats.AcdStatisticsLogin2ConfStatsPartI | 762 | Uncompressed This affects the availability of uncompressed historical data on agent login / logout activityconference invitations, and affects the availability of historical reports based on this data. |
Portal.Statistics8Server.AcdStatisticsPartCLogfiles.MaxAgeDays |
| 7 | Detail log files for calls made to the system. Only files are deleted after this grace period. |
Portal.ACD.Statistics.JTELStats2.CompressedA15 | JTELStats.AcdStatisticsPartC | This affects the availability of uncompressed historical data on chat sessions, and affects the availability of historical reports based on this data. | Portal.Statistics.AcdStatisticsPartD.MaxAgeDays | JTELStats.AcdStatisticsPartDCompressedA15 JTELStats.custom_CompressedA15 | 214 | Compressed historical data in 15 minute time intervals regarding service numbers and calls processedThis affects the availability of uncompressed historical data on dynamic priority group handling, and affects the availability of historical reports based on this data. |
Portal.ACD.Statistics.JTELStats2.AcdStatisticsTransactionCodesCompressedADay.MaxAgeDays | JTELStats.AcdStatisticsTransactionCodesCompressedADay JTELStats.custom_CompressedADay | 762 | Compressed historical data in day intervals regarding service numbers and calls processedThis affects the availability of uncompressed historical data on transaction codes for calls, and affects the availability of historical reports based on this data. |
Portal.ACD.Statistics.CallHistoryPartAJTELStats2.CompressedU15.MaxAgeDaysJTELLog | JTELStats.CallHistoryPartA | This affects the visibility of calls in the Call Log or Call Analyser Log. | CompressedU15 JTELStats.custom_CompressedU15 | 14 | Compressed historical data in 15 minute time intervals regarding user login / logout activity | Portal.Statistics.StatisticsClick2DialNoPortal.MaxAgeDays | JTELStats.StatisticsClick2DialNoPortal | This affects the availability of CDRs for click to dial (no portal) requests made to the system, and affects the availability of historical reports based on this data. |
Portal.ACD.Statistics.StatisticsDiallerCampaignsJTELStats2.CompressedUA15.MaxAgeDays | JTELStats.StatisticsDiallerCampaignsCompressedUDay JTELStats.custom_CompressedUDay | 214 | Compressed historical data in day intervals regarding user login / logout activityThis affects the availability of compressed historical data on dialler campaigns for calls made and results, and affects the availability of historical reports based on this data. |
Portal.ACD.Statistics.StatisticsPartAJTELStats2.CompressedUADay.MaxAgeDaysJTELLog.CallHistoryPartA | JTELStats.AcdStatisticsPartBCompressedUA15 JTELStats.StatisticsPartA JTELStats.StatisticsPartB JTELStats.StatisticsPartO JTELStats.StatisticsPartIVRJTELWeb.DiallerContactsHistory | JTELStats.AcdStatisticsTransactionCodes JTELStats.ConfStatsPartB | Because the StatisticsPartA table is referenced for each incoming and outgoing call, deletion of records in this table causes all data, which is dependent on these records, to be deleted or NULLed at the same time. This affects the availability of uncompressed historical data regarding calls to and from the system, including all referenced records in the tables noted, and affects the availability of historical reports based on this data. | Portal.Statistics.StatisticsPartIVR.MaxAgeDays | JTELStats.StatisticsPartIVR | This affects the availability of uncompressed historical data on IVR statistics markers used in IVR applications, and affects the availability of historical reports based on this data. | Portal.Statistics.StatisticsPartK.MaxAgeDays | JTELStats.StatisticsPartK | This affects the availability of uncompressed historical data on incoming e-mails received using a workflow connector script (ruby script, not an E-Mail connector), and affects the availability of historical reports based on this data. | Portal.Statistics.StatisticsPartR.MaxAgeDays | JTELStats.StatisticsPartR1 JTELStats.StatisticsPartR2 | This affects the availability of uncompressed historical data on recording transport statistics (sending automatically as a result of saving recordings in the IVR, for example to FTP or to E-Mail), and affects the availability of historical reports based on this data. | custom_CompressedUA15 | 762 | Compressed historical data in 15 minute time intervals regarding user call performance data, and affects the availability of historical reports based on this data. |
Portal.ACD.Statistics.JTELStats2.CompressedUDay.MaxAgeDays | JTELStats.CompressedUADay JTELStats.custom_CompressedUADay | 762 | Compressed historical data in day intervals regarding user call performance data, and affects the availability of historical reports based on this data. |
Portal.Alerts.MaxAge Portal.Alerts.MaxAgeDays | JTELWeb.Alerts | 31 | Alerts produced by the system. |
Portal.BadLogins.MaxAgeDays | JTELWeb.BadLogins | 31 | Bad login attempts. |
Portal.ContactsHistory.MaxAgeDays | JTELWeb.ContactsHistory | 762 | History for contacts in the JTELWeb.Contacts table. |
Portal.Daemon.SMTP.Archive.MaxAge |
| 7 | History files for SMTP processes. Only files are affected here. |
Portal.EventSpool.MaxAgeDays | JTELWeb.EventSpool | 214 | Maximum age of Event Spool records. |
Portal.FTPLogs.MaxAgeDays | JTELWeb.FTPLogs | 7 | Maximum age of FTP logs. |
Portal.Logging.DataManipulationLog.MaxAgeDays | JTELWeb.DataManipulationLog | 214 | Maximum age of data manipulation logs. |
Portal.Recordings.MaxAge | JTELWeb.Recordings | 7 | Maximum age of recording data and files (affects also recordings made in the IVR). |
Portal.Routing.CounterDetailStatistics.MaxAgeDays | JTELWeb.CounterDetailStatistics | 214 | Detail counter statistics for IVR applications, and affects the availability of the counters shown when a routing application's counters are accessed via the web application. |
Portal.Sessions.MaxAgeDays | JTELWeb.Sessions JTELWeb.SubSessions | 214 | Logged web sessions and subsessions (impersonations). |
Portal.Statistics.AcdStatisticsEventTransactionCodes.MaxAgeDays | JTELWeb.AcdStatisticsEventTransactionCodes | 762 | The age of event transaction codes (non call transaction codes for chats, voice mails, callbacks etc.). |
Portal.Statistics.AcdStatisticsLogin.MaxAgeDays | JTELStats.AcdStatisticsLogin JTELStats.AcdStatisticsLogin2 | 214 | Uncompressed historical data on agent | Portal.Statistics.StatisticsPartT.MaxAgeDays | JTELStats.StatisticsPartT JTELStats.StatisticsPartTI | This affects the availability of uncompressed historical data on PBX CDRs, and affects the availability of historical reports based on this data. | Portal.Statistics.StatisticsPartZ.MaxAgeDays | JTELStats.StatisticsPartZ | This affects the availability of uncompressed historical data on calls which could not be processed by any service number (and hence were rejected by the system), and affects the availability of historical reports based on this data. | Portal.ACD.Statistics.JTELStats2.CompressedA15.MaxAgeDays | JTELStats.CompressedA15 JTELStats.custom_CompressedA15 | This affects the availability of compressed historical data in 15 minute time intervals regarding service numbers and calls processed, and affects the availability of historical reports based on this data. | Portal.ACD.Statistics.JTELStats2.CompressedADay.MaxAgeDays | JTELStats.CompressedADay JTELStats.custom_CompressedADay | This affects the availability of compressed historical data in day intervals regarding service numbers and calls processed, and affects the availability of historical reports based on this data. | Portal.ACD.Statistics.JTELStats2.CompressedU15.MaxAgeDays | JTELStats.CompressedU15 JTELStats.custom_CompressedU15 | This affects the availability of compressed historical data in 15 minute time intervals regarding user login / logout activity, and affects the availability of historical reports based on this data. | Portal.ACD.Statistics.JTELStats2.CompressedUDay.MaxAgeDays | JTELStats.CompressedUDay JTELStats.custom_CompressedUDay | This affects the availability of compressed historical data in day intervals regarding user login / logout activity, and affects the availability of historical reports based on this data. |
Portal.ACD.Statistics.JTELStats2AcdStatisticsPartC.CompressedUA15.MaxAgeDaysMaxAgeDays | JTELStats.CompressedUA15 JTELStats.custom_CompressedUA15AcdStatisticsPartC | 762 | Uncompressed historical data on chat sessionsThis affects the availability of compressed historical data in 15 minute time intervals regarding user call performance data, and affects the availability of historical reports based on this data. |
Portal | .ACD.Statistics. | JTELStats2.CompressedUADayAcdStatisticsPartD.MaxAgeDays | JTELStats. | CompressedUADay
JTELStats.custom_CompressedUADayAcdStatisticsPartD | 762 | Uncompressed historical data on dynamic priority group handling, and | This affects the availability of | compressed historical reports based on this data. |
Portal.Statistics.AcdStatisticsTransactionCodes.MaxAgeDays | JTELStats.AcdStatisticsTransactionCodes | 762 | Uncompressed historical data on transaction codes for calls | data in day intervals regarding user call performance data, and affects the availability of historical reports based on this data. |