Column Descriptions
| Column Name
| Column Type
| Description |
| USERS_ID
| BIGINT NOT NULL
| Foreign key relationship to the USERS table for this registered user.
|
| PHOTO
| VARCHAR(254)
| A location for the photograph of the user.
|
| DESCRIPTION
| VARCHAR(4000)
| Description of the user.
|
| DISPLAYNAME
| VARCHAR(128)
| Display name of the entry. This is a name used in displaying an entry in a one line summary list.
|
| PREFERREDCOMM
| CHAR(2)
| Preferred method of communication by phone. Valid values are as follows:
P1 - primary phone number
P2 - secondary or alternate phone number
|
| PREFERREDDELIVERY
| VARCHAR(1000)
| Preferred delivery method.
|
| PREFERREDMEASURE
| CHAR(15)
| Reserved for IBM internal use.
|
| FIELD1
| VARCHAR(254)
| Customizable.
|
| TAXPAYERID
| VARCHAR(254)
| A string used to identify the user for taxation purpose. Addition of this column triggered by Taxware integration, but presumably this column is useful even outside of Taxware.
|
| FIELD2
| VARCHAR(254)
| Customizable.
|
| OPTCOUNTER
| SMALLINT
| Reserved for IBM internal use.
|