Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
Arc_PublicApiTokenManager Controls the linkage between an API user and the patient for whom the user is authorized. This access control is achieved using ActivationToken (just like One Time Password) and PermanentToken and their status fields. 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
TokenOidBIGINTNOT NULL Token Object ID
Patient_OidINTNOT NULL HPatient Object ID
ActivationTokenvarchar(36)NOT NULL Activation Token
CreatedUserIdINTNOT NULL Object ID of the person that created the row
CreationDateTimedatetimeNOT NULL Activation Token Start Time
ActivationTokenEndTimedatetimeNOT NULL Activation Token End Time
IsProxyUserbitNOT NULL Is Proxy User. Allowable values 0 or 1
PermanentTokenvarchar(36)NOT NULL Permanent Token
PermanentTokenLinkStartTimedatetimeNULL Permanent Token Link Start Time
PermanentTokenLinkEndTimedatetimeNULL Permanent Token Link End Time
TokenStatusvarchar(15)NOT NULL Supports various token status: 'generated/linked/revoked/expired'
SourceSystemvarchar(30)NULL Contains the Application identifier of the system that created the proxy-patient linking. For HL7 => MSH.3; For Soarian initiated => 'SC'. If NULL then defaulted as 'SC'.
LastCngDTimedatetimeNOT NULL UTC time
IsRevokedByJobbitNULL Is Token Revoked By Job ?
LinkTokenFailedCountsmallintNULL Link Token Failed Count. If this exceeds Arc_PLA_HospitalConfig.LinkTokenMaxAttempt, then the token is expired
LinkTokenLastFailureReasonvarchar(512)NULL Reason for failure of last LinkToken attempt
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