ap_nm_entity

This table is used to store the information used to describe the contacts (entities) that can be notified using Notification Manager.

Column Name Column Datatype Column Null Option Column Comment
ekey integer not null The primary key for this table. This key can range from 100001000 to 199999999. Each contact stored in this table will be assigned a unique entity key (ekey) when the contact is created.
enm varchar(32) not null The name of this contact as known by Notification Manager. Each contact name stored in this table must be unique (ignoring case). For example, "John Smith" will be treated the same as "john smith", so these two entries cannot coexist at the same time in this table.
enm_upcase varchar(32) not null The upper case (uc) value of the contact name (ename). The values contained in this field must be unique and must match the corresponding value stored in the ename column (excluding case).
efl integer not null This column contains the flags used to define characteristics about the contact.
egroup integer not null This column is used to define whether the associated contact record refers to an individual (value = 0) or a group (value = 1).
etimezone integer not null This column is reserved for future use.
epassword integer not null The encrypted value of the numeric password associated with this contact. The unencrypted value of this password is used to confirm the user's identity on either a voice notification or when using the voice call-in feature.
eescalate_to integer not null The entity key (ekey) of the escalation contact assigned to this entity. If Notification Manager fails to notify this contact, Notification Manager will attempt to notify the assigned escalation contact.
eavailability char(1) not null The availability status of this contact. A contact may mark themselves unavailable for notification to handle vacations, leaves of absence, etc. If a contact is marked as unavailable, no direct methods currently assigned to this contact will be used during the notification attempt.

Y = The contact is currently available to be notified.

N = The contact is currently unavailable for notification requests.

eavailability_desc varchar(512) not null The notification availability description field. This field can be populated when the individual marks themself as unavailable for notification. This reason for unavailability will then be displayed on the Send a Notification web page of the Notification Website when the unavailable contact is selected for notification.

Product Name: Unicenter Automation Point

Table Type: Table

Relationships:

Primary Key Related Table Related Column
  ap_nm_auth_call
ap_nm_schedule
ap_nm_schedule
ap_nm_parameter
ap_nm_notify_item
ap_nm_login
 


Copyright © 2006 CA. All rights reserved.