Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
MMUser
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| MMUserSID | INTEGER | ? | MANDATORY | System generated user id using the security sequence. |
| Logon | CHAR(80) | MANDATORY | Logon name given to each user. User entered | |
| Name | CHARACTER(40) | OPTIONAL | Name of user. User entered. | |
| UserType | CHARACTER(1) | MANDATORY | User type codes are defined in the LookupCode table for the lookup type 'UserType'. Codes for the lookup type 'UserType' are not user definable. Acceptable codes are (L)ocal, (M)ulti Practice. | |
| Class | CHARACTER(8) | OPTIONAL | User class codes are defined in the LookupCode table for the lookup type 'UserClass'. Codes for the lookup type 'UserClass' are user definable. | |
| Password | CHAR(40) | OPTIONAL | Password (system encrypted). User entered. | |
| PasswordSetDate | DATE | OPTIONAL | This date is set programmatically whenever the user changes their password. | |
| ForcePasswordChange | LOGICAL | Logical_False | OPTIONAL | This code is set programmatically when the password expires or by the user to indicate the user must change their password. Change password status codes are defined in the LookupCode table for the lookup type 'Confirmation'. Codes for the lookup type 'Confirmation' are not user definable. Acceptable values are (Y)es and (N)o. |
| AllowPasswordChange | LOGICAL | Logical_False | OPTIONAL | User enters password allowed change code. Password allowed change codes are defined in the LookupCode table for the lookup type 'Confirmation'. Codes for the lookup type 'Confirmation' are not user definable. Acceptable values are (Y)es and (N)o. |
| Administrator | LOGICAL | Logical_False | MANDATORY | Indicates if user is a system level administrator, (Y)es or (N)o. Default is (N)o. User entered. |
| RecordStatus | CHARACTER(1) | Record_Status_Active | MANDATORY | Record status indicates status of the user. Valid values are (A)ctive or (I)nactive, (R)emoved. |
| TimeStamp | CHARACTER(14) | OPTIONAL | System generated date/time stamp record was last written. | |
| LastUser | INTEGER | ? | OPTIONAL | User ID of user that last wrote the record. |
| CreateStamp | CHARACTER(14) | OPTIONAL | System generated date/time stamp record was created. | |
| CreateUser | INTEGER | ? | OPTIONAL | User ID of user that created the record. |
| PhoneNumber | CHARACTER(20) | OPTIONAL | User's work phone number. User entered. | |
| PhoneExtension | CHARACTER(6) | OPTIONAL | User's extension to the phone number. User entered. | |
| CHAR(254) | OPTIONAL | User's email address. | ||
| DeletedAccount | LOGICAL | Logical_False | OPTIONAL | Indicates if the user has been deleted from the system. |
| AllowCBO | LOGICAL | Logical_False | OPTIONAL | User entered - Indicates whether user is CBO User. |
| LockoutEndTimeStamp | CHARACTER(14) | OPTIONAL | System defined - Indicates date and time of last account lockout (due to failed logon attempt). | |
| LastLogonStamp | CHARACTER(14) | OPTIONAL | System set - Indicates last successful logon for user. | |
| UpgradeNotification | CHARACTER(1) | OPTIONAL | User definable - If set to 'Y' then this user should receive notifications about upgrades. If set to 'N' then this user should not receive any notifications about upgrades. Note - System Administrators will always be informed of upgrade notifications regardless of how this flag is set. | |
| WinUsername | CHARACTER(30) | OPTIONAL | The fully dns-qualified or flat domain-credentialed windows username. | |
| AutoLogon | CHARACTER(1) | OPTIONAL | Whether to automatically log a user onto Intergy. | |
| AllowAdminPHI | LOGICAL | Logical_True | MANDATORY | Is the user able to view PHI (protected health information) in the Practice and System Administration? When no, the user will be barred from some windows that contain PHI, such as File Archive Maintenance. Does not affect the Intergy desktop. |
| LastName | CHAR(20) | Set_To_Empty_String | MANDATORY | User entered last name of the user. |
| FirstName | CHAR(15) | Set_To_Empty_String | MANDATORY | User entered first name of the user. |
| MiddleName | CHAR(15) | Set_To_Empty_String | OPTIONAL | User entered middle name of the user. |
| NameSuffix | CHAR(20) | Set_To_Empty_String | OPTIONAL | User entered name suffix (e.g. Jr., M.D., etc.) of the user. |
| TelehealthRefreshToken | CHARACTER(32000) | ? | OPTIONAL | Token for SSO in Telehealth |
| GISRefreshToken | CHARACTER(100) | OPTIONAL | Token for getting Access Token from GIS to access Smart on FHIR apps. |
| Parent Table | Join Phrase | When deleting parent record... |
|---|
| Child Table | Join Phrase | When deleting MMUser record... |
|---|---|---|
| Encounter | Encounter.ProblemReconciliationUser = MMUser.MMUserSID | NONE if Encounter exists |
| Encounter | Encounter.AllergyReconciliationUser = MMUser.MMUserSID | NONE if Encounter exists |
| Eligibility | Eligibility.RequestUserSID = MMUser.MMUserSID | RESTRICT if Eligibility exists |
| Encounter | Encounter.MedicationReconciliationUser = MMUser.MMUserSID | NONE if Encounter exists |
| PolicyMember | PolicyMember.BackImageScanUserID = MMUser.MMUserSID | SET NULL if PolicyMember exists |
| PolicyMember | PolicyMember.FrontImageScanUserID = MMUser.MMUserSID | SET NULL if PolicyMember exists |
| PatientOrderSet | PatientOrderSet.RequestTaskUser = MMUser.MMUserSID | RESTRICT if PatientOrderSet exists |
| PatientOrderSet | PatientOrderSet.SendToUser = MMUser.MMUserSID | RESTRICT if PatientOrderSet exists |
| RefDoctor | RefDoctor.MarketingRepUserID = MMUser.MMUserSID | RESTRICT if RefDoctor exists |
| TMSCatalog | TMSCatalog.OrigTranscriptionist = MMUser.MMUserSID | SET NULL if TMSCatalog exists |
| Provider | Provider.MMUserSID = MMUser.MMUserSID | RESTRICT if Provider exists |