PAT_MYC_STAT_HX

Description: |
This table keeps an audit trail of web-based chart system status changes made to a patient. This table can be used to determine when, who, and how a status was changed for a patient account. Every time the status is modified, a new row is added to this table.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
PAT_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | PAT_ID | VARCHAR | No |
The unique ID of the patient record for this row. This column is frequently used to link to the PATIENT table.
2 | LINE | INTEGER | No |
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 | MYC_STAT_HX_C_NAME | VARCHAR | No |
The activation status category number for the patient.
May contain organization-specific values: No
Category Entries:
No Status
Activated
Inactivated
Pending Activation
Non Standard MyChart Status
Patient Declined
Activation Code Generated, but Disabled
4 | MYC_STAT_HX_EMP_ID | VARCHAR | No |
The unique ID of the employee that has changed status.
5 | MYC_STAT_HX_EMP_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
6 | MYC_STAT_HX_CMT | VARCHAR | No |
Item to store comments for status changes
7 | MYC_STAT_HX_MTHD_C_NAME | VARCHAR | No |
The method of the status change for patients. This can be used to determine how or why the status was changed. For example, this could be used to find the method of activation code generation that is most successful for patient signup.
May contain organization-specific values: Yes
Category Entries:
MyChart Administration Activity
MyChart Patient Utilities (text)
Launch MyChart Signup
SmartText
E-mailed Activation Code (Success)
Kiosk
EpicWeb Utilities
Web Service
Patient Deceased
Extension Web Service
Failed Login or Signup Attempts
EPT Deactivated
MyChart Signup (Web Site)
Patient Merge/Unmerge (DEPRECATED)
Patient Merge
Proxy Access Activity (Enable Non-Patient)
Procedure Order
Patient Declined Duration Expired
Proxy Only With No Proxies
E-mailed Activation Code (Failure)
Proxy Access Activity (Non-Patient Activation Code Generated)
Proxy Access Activity (Disable Non-Patient)
Proxy Access Activity (Enable for Proxy)
Auto Activated via Federated Login System
Prelude/Cadence Popup
Open Scheduling
Status Display Extension
MyChart Signup (Bedside)
Billing Correspondence
Self-Signup (Success)
Self-Signup (Failure)
Proxy MyChart Activated (Enable for Proxy)
Instant Activation
Patient Declined Terms and Conditions
After Visit Summary
Batch Job
Patient Checked for MyChart Eligibility
Happy Together
Registration (Non-Patient Activation Code Generated)
Auto Activated via Newborn Admission Extension
Auto Instant Activation
System Correction
Unverified Proxy Video Visit
Instant Activation On The Fly Code Generation
Demographic Authentication
Kanta Document Generation
Demographic Authentication (eCheck-In for All)
User Deactivated Own Account
Print Activation Instructions (Dialog Launched)
Print Activation Instructions (User Cancelled)
Fast Pass SMS
PGO Data Request
Rescheduling SMS
Proxy MyChart Instant Activated (Enable for Proxy)
Patient Marked as Suspicious
Instant Activation via Secure Link Authentication
Activation via MyChart Central
Instant Activation Via Bedside TV
Auto Activated Proxy via New Dependent Extension
Patient Unmerge
Security Alert
Bulk Deactivation
8 | DEPARTMENT_ID_EXTERNAL_NAME | VARCHAR | No |
The external name of the department record. This is often used in patient correspondence such as reminder letters.
9 | WORKSTATION_ID_WORKSTATION_NAME | VARCHAR | No |
This is the internal workstation name.
10 | MYC_PROXY_ACTIVATION_YN | VARCHAR | No |
Flag indicating whether an activation status is due to a proxy or not.
May contain organization-specific values: No
Category Entries:
No
Yes
11 | MYC_STAT_DEACT_RSN_C_NAME | NUMERIC | No |
Track the deactivation reason for MyChart patients.
May contain organization-specific values: No
Category Entries:
Patient Requested
Stale/Inactive Account
Terms & Conditions Violation
Account Compromised By Bad Actor
Administrative Error
Inappropriate Use By Family/Friends
Court Orders
Risk of Family Violence
Proxy Only With No Remaining Proxies
Patient Merge
Patient Unmerge
Patient Marked as Suspicious
Failed Login Attempts
Security Alert
Patient Deceased
Too Many Failed Confirmation Attempts
Failed Password Reset Attempts
WPR Record Deletion
Patient Declined Terms and Conditions
Patient Requested (Self-Deactivation)
NPP Account Replaced by Patient Account
Other