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()

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