HP ALM Database Reference
td.ALERT Table

Description

Information for managing automatic alerts and user-defined follow-ups.

Remarks

Alerts are automatically generated using the data in the RULES Table, while follow-ups are user-defined reminders that are set by the user.

Columns

 Column NameDescriptionDatatypeLengthAllow NullsDefault
Primary Key AT_IDThe record ID.int4  
 AT_USERThe owner of the alert or follow-up.varchar60 
 AT_ENTITY_TYPEThe name of the table containing the entity to which the alert applies.varchar50 
 AT_KEY1The ID of the entity in the table specified by AT_ENTITY_TYPE.int4 
 AT_KEY2For backward compatibility. Field may be removed in future version.int4 
 AT_KEY3For backward compatibility. Field may be removed in future version.int4 
 AT_DESCRIPTIONThe description of the alert.varchar16 
 AT_DATEEither the date and time the alert was sent or the date the follow-up is configured to be sent.datetime4 
 AT_SENT_BY_EMAILIndicates whether the follow-up was emailed. Y or N.varchar1 
 AT_ALERT_TYPEThe type of alert created.
0 for automatic alert.
1 for Follow-up.

int4 
 AT_ALERT_STATUSIndicates whether the alert has been read.
1 if read.
0 if still unread.
int4 

See Also