SiteID 
Definition  Identifies the unique distributed database ID where the row was inserted. Distributed databases are no longer supported so this column is deprecated. 

RepFlags 
Definition  Indicates the action in a distributed database environment. Distributed databases are no longer supported so this column is deprecated. 

Build 
Definition  Identifies the build number and patch level of the software that inserted/updated this row. The format is the Build number followed by 3 digits for the patch level which is typically 000. The build number is tied to specific versions of the software, e.g. Sunrise 15.3 is Build 5021, Sunrise 16.3 is Build 5503. 

TouchedBy 
Definition  Information about the user that last updated the row. This will typically be the UserID (IDCode from CV3User table) and may be prefixed with an environment identifier followed by an underscore, e.g. b96d2bf5_jongmore. 

TouchedWhen 
Definition  The date and time that the row was last updated and will be based on the Enterprise time zone. 

CreatedBy 
Definition  Information about the user that created the row. This will typically be the UserID (IDCode from CV3User table) and may be prefixed with an environment identifier followed by an underscore, e.g. b96d2bf5_jongmore. 

CreatedWhen 
Definition  The date and time that the row was created and will be based on the Enterprise time zone. 

Active 
Definition  Denotes whether the row is active or not, 0 means the row has been soft deleted or deactivated. 

GUID 
Definition  Unique primary key value. 

BirthDayNum 
Definition  PHI: Not used. The day of birth. 

BirthMonthNum 
Definition  PHI: Not used. The month of birth. 

BirthYearNum 
Definition  PHI: Not used. The year of birth. 

DeceasedDtm 
Definition  PHI: Not used The deceased date. 

DisplayName 
Definition  PHI: The LastName, FirstName MiddleName. 

FirstName 
Definition  PHI: The first name. 

LastName 
Definition  PHI: The last name. 

MiddleName 
Definition  PHI: The middle name. 

Title 
Definition  PHI: Not used. The title. 

ReligionCode 
Definition  PHI: Not used. The religion. 

LanguageCode 
Definition  PHI: not used The language. 

GenderCode 
Definition  PHI: Not used. The gender. 

RaceCode 
Definition  PHI: Not used. The race. 

MaritalStatusCode 
Definition  PHI: Not used. The marital status. 

OccupationCode 
Definition  PHI: The occupation. 

IDCode 
Definition  The system logon ID. 

OrderRoleType 
Definition  The type of ordering role this user will have when entering orders. From OrderRoleType dictionary 

EffectiveDtm 
Definition  The user effective date. 

ExpiryDtm 
Definition  The user expiration date. Individual expiration dates must precede the security group assignment expiration date 

PasswordExpInterval 
Definition  Not used. The number of days a password is active. Zero indicates the user password will never expire 

OrgUnitGUID 
Definition  The link to the organizational unit. 

IsFirstLogon 
Definition  Not used. Indicates the first logon. 1 = True; 0 = False 

LastPswdChng 
Definition  Not used. Indicates the date of the last password change. 

PWAccess 
Definition  Not used. The system encrypted password. 

IsSecurityOfficer 
Definition  Indicates security officer status. 1 = True; 0 = False 

CreateDBAccount 
Definition  Indicates that an account is created in the database. 1 = True; 0 = False 

EmailAddress 
Definition  PHI: The email address. 100 character maximum 

Initials 
Definition  The initials. 

Locked 
Definition  Not used. Indicates whether or not the user's account is locked. 

LockedWhen 
Definition  Not used. The time when the account was locked. 

FailCount 
Definition  Not used. The number of sequential failed attempts from the fail start time. 

FailStart 
Definition  Not used. The time of the first failed attempt since the last successful logon. 

MSrepl_tran_version 
Definition  Optimistic lock identifier. 

IsSHMActive 
Definition  Specifies whether this user is active in Secure Health Messaging. 

UserType 
Definition  An enumerated type with the following list of possible values: 1 = [SXA User],2 = [Care Provider],3 = [Client], 

FSSUserID 
Definition  Contains an HSS user ID that is mapped to CV3User account 

FSSUserDomain 
Definition  PHI: Contains an HSS domain information assigned an HSS user account that is mapped to CV3User account 

IsSyncFSSUserNames 
Definition  Indicates if First Name, Last Name and Middle Name should be sync up with FSS account 

UMPStatus 
Definition  0 indicates the user has not been migrated to UMP(User Management Portal).
1 indicates the user has been migrated to UMP.
Note: At present we only required 0 and 1 status but in future we may required more 

MSReplrowguid 
Definition  Unique GUID used to support merge replication. 

AllscriptsID 
Definition  Shield service user's AllscriptsID