DEMOG_AUTH_INFO

Description: |
Demographic authentication tokens associated with specific patients. Active tokens allow users to login to MyChart without a normal account through unique URLs.

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 | TOKEN | VARCHAR | No |
The unique token associating a demographic authentication URL with a patient.
4 | GENERATION_DATE | DATETIME | No |
The date a specific token was created.
5 | EXPIRATION_UTC_DTTM | DATETIME (UTC) | No |
The instant a specific token will expire.
6 | ASSOCIATED_MYPT_ID | VARCHAR | No |
Stores the MyChart account ID intended to log in with a specific token.
7 | FAILED_LOGIN_CNT | INTEGER | No |
Stores the count of failed consecutive logins for a specific token. If this exceeds the max allowed failed logins, the token will no longer be valid.
8 | DEMOG_AUTH_WKFLW_C_NAME | VARCHAR | No |
Stores the type of workflow a specific token was created for.
May contain organization-specific values: No
Category Entries:
eCheck-In
Scheduling Ticket Without Account
Appt Cancel Without Account
Quick Pay
Billing Details
Auto Pay
Bill Pay
Scheduling Ticket
Financial Assistance
Communication Preferences for Guarantors
Billing Customer Service
Prepayment
Communication Preferences for Patients
E-Sign Documents
Appointment Details and Updates Without Account
Appointment Details and Updates
Estimate Details
Guest eCheck-In
Locationless Self Arrival
Guest Self Arrival
Video Visit
Research Recruitment
Visits List
Requested Records
Messaging
Unverified Proxy Video Visit
Self-Triage
Questionnaires
Non-Proxy Patient Choice
After Visit Summary
Manage Payment Methods
Letters
Add Payment Method
Change PCP
Change Address
Add Dependent
Terminate Dependent
Patient Choice
Password Reset
Aura Account Linking
Coverage Change Requests
Manage Dependents
Payer-to-Payer Consent
QR Code Arrival
Guest QR Code Arrival