File Name
Syntax
CreateEscalationLog( VAL esc_type_ID: INTEGER, VAL reference_ID: STRING, VAL severity: INTEGER, VAL user_ID: STRING, VAL change_category: STRING, VAL reference_id_int: INTEGER, VAL secondary_ref_ID: STRING): integer
Parameters
Integer - indicates the type of escalation log entry being updated or created.
Values can be PROBLEM_ESCALATION or CALL_ESCALATION.
String - unique ID of the call/problem begin escalated
Integer - current severity level of the call/problem
String - logged user
Returns
Return Code from the SQL insert into the Ecalation Log Table
Side Effects
None
Description
This procedure writes an initial (dummy) record to the escalation_log table that indicates to the escalation monitor that this record should be initialized. In the event that a log record exists, it is reset to the initial state if the severity of the problem has changed. Otherwise the user ID is updated if necessary.
Dialog Forms Called
None
File Name
Syntax
DeleteEscalationLog(VAL esc_type_ID: INTEGER, VAL reference_ID: STRING, VAL secondary_ref_ID: STRING): integer
Parameters
Integer - indicates the type of escalation log entry (call, problem, and so on) being removed
String - unique ID of the reference item whose entry is to be removed
Returns
Return Code from the SQL delete from the Ecalation Log Table
Side Effects
None
Description
Used to remove an entry from the escalation log.
Dialog Forms Called
None
File Name
Syntax
DissableEscalationLog(VAL esc_type_ID: INTEGER, VAL reference_ID: STRING, VAL secondary_ref_ID: STRING): integer
Parameters
Integer - indicates the type of escalation log entry (call, problem, and so on) being removed
String - unique ID of the reference item whose entry is to be disabled
String - used by TCM escalations
Returns
Return Code from the SQL update of the Ecalation Log Table
Side Effects
None
Description
Used to set the status of an escalation log entry to disable.
Dialog Forms Called
None
File Name
Syntax
EnableEscalationLog(VAL esc_type_ID: INTEGER, VAL reference_ID: STRING, VAL secondary_ref_ID: STRING): integer
Parameters
Integer - indicates the type of escalation log entry (call, problem, and so on) being removed
String - unique ID of the reference item whose entry is to be disabled
String - used by TCM escalations
Returns
Return Code from the SQL update of the Ecalation Log Table
Side Effects
None
Description
Used to set the status of an escalation log entry to enable when it has previously been disabled.
Dialog Forms Called
None
File Name
Syntax
UpdateEscalationLog
Parameters
None
Returns
None
Side Effects
None
Description
This procedure is called by the escalation monitor to find and update initial escalation log records created by TPM.
Dialog Forms Called
None