ODF recipient/list table (ARSDFUOT)

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