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 Messaging Unverified Proxy Video Visit