DEMOG_AUTH_AUDIT
Description:
Audit trail for events related to demographic authentication tokens.

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 EVENT_UTC_DTTM DATETIME (UTC) No
The instant an action was taken on a token.
4 TOKEN VARCHAR No
The token this action happened in relation to.
5 USER_ID VARCHAR No
If applicable, this stores the Hyperspace user ID associated with this action.
6 USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
7 MYPT_ID VARCHAR No
If applicable, this stores the MyChart user ID that performed an action taken on a token.
8 MYC_DEMOG_AUTH_ACTION_C_NAME VARCHAR No
Stores the type of action taken on a token.
May contain organization-specific values: No
Category Entries:
Token Generated
Token Manually Expired
Successful Login
Failed Login Invalid Credentials
Failed Login Invalid Token
Token Cleared
Token Consumed By Web Service
Token Redeemed for Login
Token Consumed for Quick Pay Loading
Token Consumed for Quick Pay Payment Posting