Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
Arc_PublicApiActivityLog Maintains the audit trail of the FHIR-API access.
Column Name Column Datatype Column Null Option Column Comment
ActivityObjectIDbigintNOT NULL populated by using getnextoid NOT Identity
PapiLoginUserNamevarchar(256)NULL Portal Login id of the user. Max email address is 256 characters
ConsumerApplicationNamevarchar(256)NOT NULL Portal used - size based on filename max 256
UserIdentityProvidervarchar(256)NULL Identity Provider - Maximum Domain Name size is 256
EventDateTimedatetimeNOT NULL Date and time that the activity occurred down to milliseconds
IsProxyUserbitNULL Key of allowable values:0- user is for patient, 1- user is a proxy
ParticipantPatientOidintNULL ObjectId for patient whose data was accessed
ParticipantPatientPermanentTokenvarchar(64)NULL GUID(Global Unique Identifier)- Permanent Token - with dashes removed
RequestedCategoryvarchar(64)NOT NULL FHIR(Fast Healthcare Interoperability Resources) Resource that was invoked. Values
Condition(DSTU2,R4)
DiagnosticReport(DSTU2,R4)
AllergyIntolerance(DSTU2,R4)
Patient(DSTU2,R4)
DocumentReference(DSTU2,R4)
Immunization(DSTU2,R4)
Observation(DSTU2,R4)
Procedure(DSTU2,R4)
CarePlan(DSTU2,R4)
Device(DSTU2,R4)
MedicationStatement(DSTU2)
Conformance(DSTU2)
Encounter(R4)
Practitioner(R4)
Goal(R4)
MedicationRequest(R4)
Organization(R4)
CareTeam(R4)
Provenance(R4)
Practitioner List(R4)
List(R4)
Location(R4)
PractitionerRole(R4)
RelatedPerson(R4)
SuccessIndicatorvarchar(10)NOT NULL Allowable Values: Success, Failure
EventActionvarchar(15)NOT NULL Specifies the different type of actions preformed Create/Read/Update/Delete
ActivityResponseTimeintNOT NULL Response Time for data source to return data - aligned with duration in DBA_StatsbyService
ActivityRecordCountintNOT NULL Count will be a measure of the data returned from data source
LastCngDTimeDatetimeNOT NULL Last change Date Time(UTC)
ParticipantPatientRecordIdintNULL PatientRecordId for patient whose data was accessed
FullUrlWithParamsvarchar(512)NULL Full Url with parameters will be stored
FhirVersionvarchar(15)NULL FHIR Version of the request
PrimaryParticipantFhirIdvarchar(64)NULL FHIR patient resource logical-Id that needs to be unique
ConsumerApplicationIdvarchar(64)NULL ID of the client application as received in the OAuth token.
UserPersonavarchar(20)NULL UserPersona whether its a Patient or Provider or System
RequestIdvarchar(128)NOT NULL Correlation ID for Auditing Purpose

Return to Table-Index

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