McDewey

Type: string [50] (Unique) Validation: ^[a-zA-Z 0-9._-]{1,50}$ Remarks: A unique name for Customer 2.3.88.4 pkid (FI-28269) Type: guid (Unique, Indexed, Not Modifiable) Default Value: newid() Migration Source: Generated Remarks: Unique ID to identify a record. Uniqueness: No multicolumn uniqueness constraints 2.3.89 customuserattributedata (TI-545) Description: Stores data to be syncronized to respective Custom Field Attribute. Each Recor supported TypeCustomUserAttributes Fields: 2.3.89.1 fkenduser (FI-10012) Type: guid (Indexed, Cascade Delete, Not Modifiable) Remarks: Key Reference to the User to whom the data in the Value colu 2.3.89.2 pkid (FI-10010) Type: guid (Unique, Indexed, Not Modifiable) Default Value: newid() Remarks: Unique ID to identify a record. 2.3.89.3 tkcustomuserattribute (FI-10011) Type: enum (Not Modifiable) Remarks: This field is to map one of the 5 available custom field to the 2.3.89.4 value (FI-10013) Type: string [255] (Null OK) Remarks: Data retrieved from LDAP for the specified Custom Attribute Uniqueness: tkcustomuserattribute + fkenduser is unique. (MFI-203) 2.3.90 customuserattributename (TI-544) Description: Records in this table contain Configurable friendly names to all the Custom Fie TypeCustomUserAttributes Fields: 2.3.90.1 customfieldattributename (FI-10008) Type: string [256] (Unique) Validation: ^[a-zA-Z 0-9]{1,64}$ Remarks: CustomFieldAttributeName field stores the name of the attrib 2.3.90.2 pkid (FI-10007)