Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ProxyUserOid | BIGINT | NOT NULL | Proxy User Object ID |
Patient_Oid | INT | NOT NULL | HPatient Object ID |
Token_Oid | BIGINT | NULL | Token Object ID |
ProxyFirstName | varchar(30) | NOT NULL | First name of the proxy user |
ProxyLastName | varchar(60) | NOT NULL | Last name of the proxy user |
SecretAlias | varchar(20) | NOT NULL | Secret Alias |
ProxyEmailAddress | varchar(256) | NULL | Email Address of the proxy |
EmailType | varchar(15) | NULL | allowable values are direct or commercial |
Relation | varchar(200) | NOT NULL | Relationship between the patient and the proxy |
CreatedUserId | INT | NOT NULL | Object ID of the person that created the row |
CreationDateTime | datetime | NOT NULL | Creation Date Time |
LastCngDTime | datetime | NOT NULL | UTC time |
IsRevokeOnAttainingMajorAge | bit | NOT NULL | When the patient hits a specific age, the rights to access this patient will be revoked. Allowable values : 0 - False, 1 - True. |
AgeofMajorityOverride | int | NULL | This value overrides the Arc_PLA_HospitalConfig Table preference. NULL indicates to use the preference |
ReasonForRevokeOverride | varchar(512) | NULL | Why proxy's access to this minor patient should not be automatically revoked when the patient attains age of majority? |
PatientRecordId | INT | NOT NULL | PatientRecordId in the HPatient table. It is used for 2-key validation to ensure the data is fetched for the correct patient. |