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
Bill Pay Payment Posted in Session
Auto Pay Set Up in Session
Quick Pay Payment Posted in Session
Prepayment Posted in Session
Payment Method Added in Session