Previous Topic: usp_web_form TableNext Topic: usp_window_type Table

Data Element Dictionary › usp_window Table

usp_window Table

Contains information on the blackout and maintenance window.

Column

Type

Remarks

id

INTEGER

UNIQUE

NOT_NULL KEY

sym

INTEGER

UNIQUE

Name of window

window_type

INTEGER

REQUIRED

References usp_window_type and specifies blackout or maintenance.

start_date

LOCAL_TIME

REQUIRED

Start date of first recurrence

end_date

LOCAL_TIME

REQUIRED

End date of first recurrence

final_end_date

LOCAL_TIME

REQUIRED

End date of last recurrence

timezone

STRING 30

Timezone

icon

STRING 100

URL to icon

recurs

INTEGER

Specifies the following:

  • 0—None
  • 1—Daily
  • 2—Weekly
  • 3—Monthly
  • 4—Annually

recurrence_interval

INTEGER

Days, weeks, months, or years

sunday

INTEGER

Restricts daily or weekly recurrence

monday

INTEGER

Restricts daily or weekly recurrence

tuesday

INTEGER

Restricts daily or weekly recurrence

wednesday

INTEGER

Restricts daily or weekly recurrence

thursday

INTEGER

Restricts daily or weekly recurrence

friday

INTEGER

Restricts daily or weekly recurrence

saturday

INTEGER

Restricts daily or weekly recurrence

occurrence

INTEGER

Restricts monthly or yearly recurrence

  • 1—First
  • 2—Second
  • 3—Third
  • 4—Fourth
  • 5—Last

description

STRING 400

Text of window

legend

STRING 100

Legend on the Change Calendar

color

STRING 100

Web color of text

bgcolor

STRING 100

Web background color

style

STRING 100

Text style (italic, bold or normal)

last_mod_dt

LOCAL_TIME

Indicates the timestamp of when this record was last modified.

last_mod_by

UUID

Specifies the UUID of the contact who last modified this record.

del

INTEGER

 

tenant

UUID

References the ca_tenant table.

The significance of recurrence_interval, occurrence, and the weekday attributes (sunday, monday, and so on) depend on the value of recurs:

1 (daily)

Specifies the days on which the event recurs.

If the recurrence_interval is greater than one, the weekday attributes are ignored, and the event recurs at the interval you specified. Occurrence is ignored.

2 (weekly)

Specifies the number of weeks between recurrences, and the weekday attributes specify the days within the week the window recurs. Occurrence is ignored.

3 (monthly)

Specifies the number of months between occurrences.

If the occurrence is zero, the recurrence is always on the day of the month of the start_date. If the occurrence is non-zero, it specifies that recurrence occurs in the first, second, third, fourth, or last week of the month on the weekday of the start_date (which will be the only non-zero weekday attribute).

4 (yearly)

Specifies the number of years between occurrences.

If the occurrence is zero, the recurrence is always on the date of the start_date. If the occurrence is non-zero, it specifies that recurrence occurs in the first, second, third, fourth, or last week of the month on the weekday of the start_date (which will be the only non-zero weekday attribute).