This table maintains a catalog of recipients and recipient
lists.
Table 1. Recipient/list table (ARSDFUOT)
Column Name |
Data Type |
Description |
UOT_RECIPIENT |
VARCHAR(60) |
Recipient or recipient list name |
UOT_IS_LIST |
INTEGER |
Name is a recipient list |
UOT_HDR1 |
VARCHAR(60) |
Header line 1 |
UOT_HDR2 |
VARCHAR(60) |
Header line 2 |
UOT_HDR3 |
VARCHAR(60) |
Header line 3 |
UOT_HDR4 |
VARCHAR(60) |
Header line 4 |
UOT_HDR5 |
VARCHAR(60) |
Header line 5 |
UOT_HDR6 |
VARCHAR(60) |
Header line 6 |
UOT_HDR7 |
VARCHAR(60) |
Header line 7 |
UOT_HDR8 |
VARCHAR(60) |
Header line 8 |
UOT_BANNER |
CHAR(1) |
Banner |
UOT_ACCOUNT |
VARCHAR(60) |
Account |
UOT_ADDRESS1 |
VARCHAR(60) |
Address line 1 |
UOT_ADDRESS2 |
VARCHAR(60) |
Address line 2 |
UOT_ADDRESS3 |
VARCHAR(60) |
Address line 3 |
UOT_ADDRESS4 |
VARCHAR(60) |
Address line 4 |
UOT_BUILDING |
VARCHAR(60) |
Building |
UOT_DEPT |
VARCHAR(60) |
Department |
UOT_NAME |
VARCHAR(60) |
Name of recipient |
UOT_ROOM |
VARCHAR(60) |
Room |
UOT_TITLE |
VARCHAR(60) |
Title of recipient |
UOT_EMAIL |
VARCHAR(254) |
Email address of recipient |
UOT_DESC |
VARCHAR(120) |
Description |
UOT_UPD_USERID |
VARCHAR(128) |
Last user to update the recipient or recipient
list |
UOT_UPD_DATE |
BIGINT |
Date and time recipient or recipient list
was last updated |
Table 2. Indexes for recipient/list table (ARSDFUOT)
Index name |
Columns in index |
Type of index |
ARSDFUOT_IDX1 |
UOT_RECIPIENT |
unique index |