This table stores the notification schedule information used by Notification Manager to determine which methods to use when a notification request is launched. Each row in this table defines a timeblock for a specific contact, and these timeblocks can either be based upon days of the week (DOW) or a date range.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| tkey | integer | not null | The unique key that represents a notification schedule (timeblock) stored in the Notification Manager database. This key can range from 40001001 to 499999999. |
| tnm | varchar(32) | not null | The name of the timeblock. This field is not unique on a table-wide basis, but the values in this field must be unique on a per-contact basis (tekey). |
| tnm_upcase | varchar(32) | not null | The upper case (UC) name of the timeblock. |
| tfl | integer | not null | The field is used to store the flags associated with this timeblock. |
| tdow | char(7) | not null | This field stores the days of the week (DOW) during which the timeblock is considered to be active. |
| tdow2 | char(7) | not null | This field stores the days of the week (DOW) during which the timeblock is considered to be active. |
| tbegin_dt | integer | not null | This field stores the begin date (in integer format) for this timeblock. |
| tbegin_dt2 | integer | not null | This field stores the begin date (in integer format) for this timeblock. |
| tend_dt | integer | not null | This field stores the end date (in integer format) for this timeblock. |
| tend_dt2 | integer | not null | This field stores the end date (in integer format) for this timeblock. |
| tbegin_tm | integer | not null | This field stores the begin time (in integer format) for this timeblock. |
| tbegin_tm2 | integer | not null | This field stores the begin time (in integer format) for this timeblock. |
| tend_tm | integer | not null | This field stores the end time (in integer format) for this timeblock. |
| tend_tm2 | integer | not null | This field stores the end time (in integer format) for this timeblock. |
| tpriority | integer | not null | The priority value assigned to this timeblock. |
| ttype1 | integer | not null | This field is used to determine the type of method currently assigned to this timeblock. |
| ttype2 | integer | not null | This field is used to determine which set of criteria (DOW or Date range) should be used when Notification Manager calculates the state of the timeblock (active or inactive). |
Product Name: Unicenter Automation Point
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| ap_nm_parameter |