How do I interpret the 'attr', 'aspect_attr' and 'common_attr' fields in the 'accounts' table?

Environment:

Staff Accounts, Analytics
Oracle B2C Service

Resolution: 

The 'attr', 'aspect_attr' and 'common_attr' fields use a bitmap to describes the disabled and flag statuses of the account. The attr field is used in versions prior to May 2015. In versions May 2015 and later the flag statuses are stored in two new fields named 'aspect_attr' and 'common_attr.' The 'attr' field is no longer used in these newer versions.

To interpret the value in the 'attr' field, use the items below to sum the values associated to the items until the total is equal to that in the field:

1 - Disabled from Assignment
2 - Disabled from Views/Reports
4 - Account Locked
8 - Force Password Change
16 - Non-Contact Center User
32 - Permanently Disabled
128 - Nothing Selected (alt. Password never expires)
256 - Can Modify Email Signature
512 - Virtual Assistant

To interpret the value in the 'aspect_attr' field, use the items below to sum the values associated to the items until the total is equal to that in the field:

1 - Disabled from Assignment
2 - Disabled from Views/Reports
16 - Non-Contact Center User
512 - Virtual Assistant

To interpret the value in the 'common_attr' field, use the items below to sum the values associated to the items until the total is equal to that in the field:

4 - Account Locked
8 - Force Password Change
32 - Permanently Disabled
128 - Password never expires
256 - Can Modify Email Signature

Here are some example account details using the accounts.attr field:

The attributes for the account shown above are:

Mickey Mouse:
attr = 128 = only "nothing selected"

Donald Duck: 
attr = 384 = 128 + 256 = nothing is selected EXCEPT for "Can Modify Email Signature"

Minnie Mouse: 
attr = 0 = only "Password Expires"

Daisy Duck: 
attr = 257 = 0 + 1 + 256 = "Password Expires", "Disabled from Assignment", and "Can Modify Email Signature"

Cinder Ella: 
attr = 387 = 1 + 2 + 128 + 256 = "Disabled from Assignment", "Disabled from Assignment/Report Filters", and "Can Modify Email Signature"

Snow White: 
attr = 35 = 0 + 1 + 2 + 32 = "Password Expires", "Disabled from Assignment", "Disabled from Assignment/Report Filters", and "Permanently Disabled"

Notes:

You can also create a report with the following columns/filters to quickly determine what attributes are set for an account. Here is an example using accounts.attr::

COLUMNS:
accounts.acct_id
accounts.attr

FILTERS:
accounts.acct_id IN LIST <list of the desired accounts>

NOTE:  These columns in a report will write out (i.e. "Disabled from Assignment") what attributes are associated to the account rather than displaying an integer value (i.e. 1)