|
Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
| ActivityObjectID | bigint | NOT NULL | populated by using getnextoid NOT Identity |
| PapiLoginUserName | varchar(256) | NULL | Portal Login id of the user. Max email address is 256 characters |
| ConsumerApplicationName | varchar(256) | NOT NULL | Portal used - size based on filename max 256 |
| UserIdentityProvider | varchar(256) | NULL | Identity Provider - Maximum Domain Name size is 256 |
| EventDateTime | datetime | NOT NULL | Date and time that the activity occurred down to milliseconds |
| IsProxyUser | bit | NULL | Key of allowable values:0- user is for patient, 1- user is a proxy |
| ParticipantPatientOid | int | NULL | ObjectId for patient whose data was accessed |
| ParticipantPatientPermanentToken | varchar(64) | NULL | GUID(Global Unique Identifier)- Permanent Token - with dashes removed |
| RequestedCategory | varchar(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) |
| SuccessIndicator | varchar(10) | NOT NULL | Allowable Values: Success, Failure |
| EventAction | varchar(15) | NOT NULL | Specifies the different type of actions preformed Create/Read/Update/Delete |
| ActivityResponseTime | int | NOT NULL | Response Time for data source to return data - aligned with duration in DBA_StatsbyService |
| ActivityRecordCount | int | NOT NULL | Count will be a measure of the data returned from data source |
| LastCngDTime | Datetime | NOT NULL | Last change Date Time(UTC) |
| ParticipantPatientRecordId | int | NULL | PatientRecordId for patient whose data was accessed |
| FullUrlWithParams | varchar(512) | NULL | Full Url with parameters will be stored |
| FhirVersion | varchar(15) | NULL | FHIR Version of the request |
| PrimaryParticipantFhirId | varchar(64) | NULL | FHIR patient resource logical-Id that needs to be unique |
| ConsumerApplicationId | varchar(64) | NULL | ID of the client application as received in the OAuth token. |
| UserPersona | varchar(20) | NULL | UserPersona whether its a Patient or Provider or System |
| RequestId | varchar(128) | NOT NULL | Correlation ID for Auditing Purpose |