Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
Arc_PublicApiProxyUserRepository Maintains information about the proxies or authorized representatives defined for the patient. This information can be viewed on Soarian Clinicals UI through the "API Access Management" screen on the Visit taskcard.
Column Name Column Datatype Column Null Option Column Comment
ProxyUserOidBIGINTNOT NULL Proxy User Object ID
Patient_OidINTNOT NULL HPatient Object ID
Token_OidBIGINTNULL Token Object ID
ProxyFirstNamevarchar(30)NOT NULL First name of the proxy user
ProxyLastNamevarchar(60)NOT NULL Last name of the proxy user
SecretAliasvarchar(20)NOT NULL Secret Alias
ProxyEmailAddressvarchar(256)NULL Email Address of the proxy
EmailTypevarchar(15)NULL allowable values are direct or commercial
Relationvarchar(200)NOT NULL Relationship between the patient and the proxy
CreatedUserIdINTNOT NULL Object ID of the person that created the row
CreationDateTimedatetimeNOT NULL Creation Date Time
LastCngDTimedatetimeNOT NULL UTC time
IsRevokeOnAttainingMajorAgebitNOT NULL When the patient hits a specific age, the rights to access this patient will be revoked. Allowable values : 0 - False, 1 - True.
AgeofMajorityOverrideintNULL This value overrides the Arc_PLA_HospitalConfig Table preference. NULL indicates to use the preference
ReasonForRevokeOverridevarchar(512)NULL Why proxy's access to this minor patient should not be automatically revoked when the patient attains age of majority?
PatientRecordIdINTNOT NULL PatientRecordId in the HPatient table. It is used for 2-key validation to ensure the data is fetched for the correct patient.

Return to Table-Index

  Soarian Clinicals Schema Documentation  
Copyright © 2023, Oracle and/or its affiliates