patient_access_onsite


If there is patient data for this table the file for this export will be found in the extracted zip folder location under the filename of patient_access_onsite.csv

If there are non-patient data column elements that are not part of the designated record set they will be marked in the Comment's column for that data element

Description

Holds patient portal onsite credentials, username information and login meta information

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
pid BIGINT 19 √ NULL
patient_data.pid Defined in XML R

The internal patient identifier
portal_username VARCHAR 100 √ NULL
portal_pwd VARCHAR 255 √ NULL

Hash of the patient password. Empty for export.
portal_pwd_status TINYINT 3 √ 1

0=>Password Created Through Demographics by The provider or staff. Patient Should Change it at first time it.1=>Pwd updated or created by patient itself
portal_login_username VARCHAR 100 √ NULL

User entered username
portal_onetime VARCHAR 255 √ NULL

One time login key. Empty for export.
date_created DATETIME 19 current_timestamp()
portal_fail_counter BIGINT 19 √ 0

Per-portal-account failure counter. Independent of ip_login_fail_counter so a valid login on account A cannot clear an in-progress brute force against account B.
portal_last_fail DATETIME 19 √ NULL

Timestamp of the last portal login failure for this account. Used for time-based counter reset.

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
pid Must be unique Asc pid

Relationships

Close relationships within degrees of separation