Table entries represent an instance of a value of a specific property for a specific user. If the current display name is updated, an entry is created in the Wgn3UserPropertyValue table containing the previous value. It is held against a predefined property of 'Previous display name'.
|
Column |
Primary Key |
Datatype |
Length |
Notes |
|---|---|---|---|---|
|
UserIDM Part-key that uniquely identifies a CA DataMinder user. |
Yes |
INTEGER |
4 |
None Foreign key: Wgn3User |
|
UserID Part-key that uniquely identifies a CA DataMinder user. |
Yes |
INTEGER |
4 |
Foreign key: Wgn3User |
|
UserPropIndex Part-key that uniquely identifies the user with an attribute. |
Yes |
INTEGER |
|
Collation sequence, plus permits multiple values for the same property |
|
UserPropValue The actual property value. |
|
VARCHAR |
255 |
The actual value |
|
PropertyID Identifies the property type. |
|
INTEGER |
|
Identifies the type of the property. This value corresponds to the 'WellKnownIndex' in the WgnWellKnownString table. There are also 'special' values which have native ID values: -10 specifies a user's 'Full Name' -30 specifies a BusinessObjects user account that is mapped to this CA DataMinder user account. Foreign key: WgnWellKnownString |
|
DataModified The date at which the property was last modified. |
|
TIMESTAMP |
|
Date of creation or last modification |
|
Copyright © 2014 CA.
All rights reserved.
|
|