What data is stored in the USM_TRIGGER_DELETE_ALL_TABLE and UJO_SETNGET_PACKAGE

Products

• CA Service Management - Service Desk Manager
• CA Service Desk Manager

Issue/Introduction

What data is stored in the USM_TRIGGER_DELETE_ALL_TABLE and UJO_SETNGET_PACKAGE

Environment

Release : 17.3

Resolution

Regarding the USM_TRIGGER_DELETE_ALL_TABLE: 

This is a trigger associated with the ca_contact table. The triggers do not store data. Here is the definition of this object that might be helpful:

In SQL Server, triggers are database objects, actually, a special kind of stored procedure, which “reacts” to certain actions we make in the database. The main idea behind triggers is that they always perform an action in case some event happens. If we’re talking about DML triggers, these changes shall be changes in our data

Regarding UJO_SETNGET_PACKAGE:

This is a package and does not store any data. Here is the definition of a SQL Package:

Packages are schema objects that group logically related PL/SQL types, variables, and subprograms.

A package will have two mandatory parts:

Package specification
Package body or definition