Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| userFieldValID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each field value record |
||||
| fkUserID | int | 4 | √ | null |
|
|
User reference - Links to the user account (AccessUser.UserID) |
||||
| fkUserFieldID | int | 4 | √ | null |
|
|
User field reference - Links to the custom field definition (UserFields.userFieldID) |
||||
| userFieldValue | varchar | 50 | √ | null |
|
|
Field value - The actual value entered for the custom field |
||||
| UserFieldDateValueStart | datetime | 16,3 | √ | null |
|
|
Start date value - Start date for date range field values |
||||
| UserFieldDateValueEnd | datetime | 16,3 | √ | null |
|
|
End date value - End date for date range field values |
||||
| UserFieldStatus | varchar | 30 | √ | null |
|
|
Field status - Status of the user field value (Active, Inactive, Pending, etc.) |
||||
| UserFieldValueComment | varchar | 500 | √ | null |
|
|
Value comments - Additional comments about the field value |
||||
| EnteredBy | int | 4 | √ | null |
|
|
Entered by user - UserID of the person who entered the value |
||||
| DateCreated | datetime | 16,3 | √ | null |
|
|
Creation date - Date when the field value was created |
||||
| userFieldValueComments | Unknown | 0 | null |
|
|
Value comments - Additional comments about the field value |
|||||
| userFieldValueDate | Unknown | 0 | null |
|
|
Value date - Date when the value was entered or last updated |
|||||
| userFieldValueDateEntered | Unknown | 0 | null |
|
|
Entry date - Date and time when the value was entered |
|||||
| userFieldValueDateUpdated | Unknown | 0 | null |
|
|
Update date - Date and time when the value was last updated |
|||||
| userFieldValueDocComments | Unknown | 0 | null |
|
|
Document comments - Comments about the supporting documentation |
|||||
| userFieldValueDocDateEntered | Unknown | 0 | null |
|
|
Document entry date - Date when the documentation was uploaded |
|||||
| userFieldValueDocDateUpdated | Unknown | 0 | null |
|
|
Document update date - Date when the documentation was last updated |
|||||
| userFieldValueDocEnteredBy | Unknown | 0 | null |
|
|
Document entered by - UserID of the person who uploaded the documentation |
|||||
| userFieldValueDocExpDate | Unknown | 0 | null |
|
|
Document expiration - Expiration date for supporting documentation |
|||||
| userFieldValueDocID | Unknown | 0 | null |
|
|
Document reference - Links to supporting documentation for the field value |
|||||
| userFieldValueDocStatus | Unknown | 0 | null |
|
|
Document status - Status of the supporting documentation |
|||||
| userFieldValueDocUpdatedBy | Unknown | 0 | null |
|
|
Document updated by - UserID of the person who last updated the documentation |
|||||
| userFieldValueEnteredBy | Unknown | 0 | null |
|
|
Entered by user - UserID of the person who entered the value |
|||||
| UserFieldValueExempt | int | 4 | √ | null |
|
|
Exemption flag - Indicates if the user is exempted from this field requirement |
||||
| userFieldValueExemptBy | Unknown | 0 | null |
|
|
Exempted by user - UserID of the person who granted the exemption |
|||||
| userFieldValueExemptDate | Unknown | 0 | null |
|
|
Exemption date - Date when the exemption was granted |
|||||
| userFieldValueExemptReason | Unknown | 0 | null |
|
|
Exemption reason - Reason for exempting the user from this field requirement |
|||||
| userFieldValueExpDate | Unknown | 0 | null |
|
|
Expiration date - Date when the field value expires (for time-sensitive data) |
|||||
| userFieldValueStatus | Unknown | 0 | null |
|
|
Value status - Status of the field value (Active, Expired, Pending, etc.) |
|||||
| userFieldValueUpdatedBy | Unknown | 0 | null |
|
|
Updated by user - UserID of the person who last updated the value |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK__UserFieldValues__754E3E91 | Primary key | Asc | userFieldValID |
Relationships
Close relationships within degrees of separation
