Routines for esclog.kb


CreateEscalationLog

File Name

esclog.kb

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


DeleteEscalationLog

File Name

esclog.kb

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


DissableEscalationLog

File Name

esclog.kb

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


EnableEscalationLog

File Name

esclog.kb

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


UpdateEscalationLog

File Name

esclog.kb

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