ComplianceUserStatus Table

ComplianceUserStatus is a static table listing status values for end-user.

Table 1. Database columns for ComplianceUserStatus table

Database Column

Details

ComplianceUserStatusID

Type: integer. Key. Generated ID

A unique identifier for each ComplianceUserStatus. Possible values and the corresponding default strings are:

  • 1 = Active
  • 2 = Inactive
  • 3 = Retired
  • 4 = On leave
  • 5 = Pending (perhaps for an employee just starting with the company).
ResourceName

Type: text (max 256 characters). Key

The unique name of the localizable resource string representing an end-user status. Foreign key to the ComplianceResourceString table.

DefaultValue

Type: text (max 100 characters)

The text to display if the status resource string has no translation.

IsUserActive

Type: boolean. Key

If this field is set to False, any end-user with this status will not consume licenses or be recorded as the last-logged-on or calculated end-user of a computer. This end-user will also not appear in many lists of end-users.