Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
Arc_PublicApiUser Maintains the FHIR-Api user identity details for the Patient persona. Entry in this table is created when an API user is linked to a patient through Patient Linking workflow.
Column Name Column Datatype Column Null Option Column Comment
PapiUserOidBIGINTNOT NULL API user Object ID
PapiLoginUserNamevarchar(256)NOT NULL Login User name
CreationDateTimedatetimeNOT NULL Creation Date Time
LastAccessDateTimedatetimeNOT NULL Last Access Date Time
PapiUserIdentityProviderURIvarchar(256)NULL IdentityProvider URI(from the oAuth token)
PapiUserIdentityProviderGUIDvarchar(36)NOT NULL unique Identifier for the User Identity provider
PapiUserFederatedPrincipalAliasvarchar(256)NOT NULL Identifier for the portal user and the Identity provider.(From oAuth token and from HL7 fields PID.3.1 for patient user and NK1.33.1 for proxy user). FPA e.g.: "URN:CERNER:IDENTITY-FEDERATION:REALM:49F17659-891C-42C9-AE26-D6AE7826F62D:PRINCIPAL:38509e38-2d69-4109-ab24-08ca19ea4a65". Format => URN:CERNER:IDENTITY-FEDERATION:REALM::PRINCIPAL:
LastCngDTimedatetimeNOT NULL UTC time

Return to Table-Index

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