DOCS_RCVD_FHIR_DOC_INFO
Description:
This table stores metadata about FHIR resources received from outside sources.

Primary Key
Column Name Ordinal Position
DOCUMENT_ID 1
CONTACT_DATE_REAL 2
LINE 3

Column Information
Name Type Discontinued?
1 DOCUMENT_ID NUMERIC No
The unique identifier (.1 item) for the document record.
2 CONTACT_DATE_REAL FLOAT No
A unique contact date in decimal format. The integer portion of the number indicates the date of contact. The digits after the decimal distinguish different contacts on the same date and are unique for each contact on that date. For example, .00 is the first/only contact, .01 is the second contact, etc.
3 LINE INTEGER No
The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
4 CONTACT_DATE DATETIME No
The date of this contact in calendar format.
5 FHIR_DOCUMENT_RESOURCE_TYPE_C_NAME VARCHAR No
The resource type category ID for this FHIR resource
May contain organization-specific values: No
Category Entries:
Patient
Practitioner
Substance
Condition
AdverseReaction
AllergyIntolerance
MedicationPrescription
Medication
Observation
ValueSet
OperationOutcome
Conformance
FamilyHistory
FamilyMemberHistory
DocumentReference
Binary
MedicationOrder
Goal
CarePlan
Procedure
MedicationStatement
List
DiagnosticOrder
ProcedureRequest
Immunization
Device
DiagnosticReport
Slot
Schedule
PractitionerRole
Location
Bundle
CodeSystem
DomainResource
Parameters
Resource
StructureDefinition
OperationDefinition
Appointment
AppointmentResponse
AuditEvent
CapabilityStatement
ConceptMap
ImagingStudy
MedicationRequest
MessageHeader
Organization
Provenance
Questionnaire
QuestionnaireResponse
SearchParameter
Subscription
Account
ActivityDefinition
CareTeam
Claim
ClaimResponse
Communication
CommunicationRequest
Composition
Coverage
DocumentManifest
EligibilityRequest
EligibilityResponse
Encounter
Endpoint
EpisodeOfCare
ExpansionProfile
ExplanationOfBenefit
GuidanceResponse
HealthcareService
Library
Measure
MeasureReport
MedicationAdministration
MedicationDispense
NutritionOrder
PaymentNotice
PaymentReconciliation
Person
PlanDefinition
ProcessRequest
ProcessResponse
RelatedPerson
RequestGroup
Specimen
StructureMap
Task
TestScript
Basic
BodySite
CompartmentDefinition
Consent
Contract
DataElement
DetectedIssue
DeviceComponent
DeviceMetric
Flag
Group
ImagingManifest
ImmunizationRecommendation
ImplementationGuide
Media
NamingSystem
ReferralRequest
RiskAssessment
Sequence
SupplyDelivery
SupplyRequest
VisionPrescription
AdverseEvent
ChargeItem
ClinicalImpression
DeviceRequest
DeviceUseStatement
EnrollmentRequest
EnrollmentResponse
GraphDefinition
Linkage
MessageDefinition
ResearchStudy
ResearchSubject
ServiceDefinition
TestReport
EventDefinition
CriteriaReview
ReviewCollection
ServiceRequest
QuestionnaireSeries
BodyStructure
Labor and Delivery
Invoice
InsurancePlan
OrganizationAffiliation
CovidVaccineBundle
CovidResultBundle
6 FHIR_DOCUMENT_RESOURCE_IDENT VARCHAR No
The resource ID for this FHIR resource received from the source organization
7 FHIR_DOCUMENT_FILE_NAME VARCHAR No
The file name for this FHIR resource on the BLOB server
8 FHIR_DOCUMENT_SUB_RESOURCE_C_NAME VARCHAR No
The sub resource type for this FHIR resource
May contain organization-specific values: No
Category Entries:
Labs
Vital Signs
Core Characteristics
Lines, Drains, Airways
Social History
Problems
Encounter Diagnosis
Provider Photo
Health Concerns
Clinical Notes
Longitudinal CarePlan
Encounter
Genomics
Orders
Surgeries
Signed Medication Order
Unsigned Medication Order
Patient-Reported Surgical History
Substance History
Midmark
Outpatient CarePlan
Care Plan Problem
Inpatient CarePlan
Patient List
Patients With Questionnaires Due List
Document Information
Dental CarePlan
Oncology
Dental Visit
Community Resource ServiceRequest
Questionnaires Due
Care Plan Goal
Medication List
Immunization Questionnaires
Patient Entered Questionnaires
Oncology Plan Day
Dental Procedure
Order Template Medication
Order Template Procedure
Anticoagulation CarePlan
Patient
Unsigned Procedure Order
Anticoagulation Goal
Results
Tooth
Periodontal
Inpatient Pathway
Allergies
Immunization
Dental Finding
Care Gap
Measure Report
Pathway Step
Problem List
Organ
Assessment
Longitudinal CareTeam
Episode CareTeam
Patient FYI
Infection
Community Resource Task
Episode Checklist Task
OASIS
HIS
Homecare Assessment
Activities of Daily Living
Handoff
BMT Pre Transplant Plan
BMT Plan Day
Mapping Definitions
Grouper
Home Care
Home Care Order
Home Health Plan of Care
Family History
Referral
SmartData Elements
Hospital Problem
Home Care Problem
Home Care Goal
Document
Code Status
Generated CDAs
Labor and Delivery
Care Advice
Customer Relationship Management
IRF-PAI
Minimum Data Set
External CDAs
Code Status Questionnaire
Medical History
Fertility
Cataract Plan
Newborn Delivery
Transaction
Patient Education
Nursing Intervention
Practitioner Role
Network and Ratings Practitioner Role
Network and Ratings Location Role
Community Resource Communication
Bereaved
Birth History
Durable Medical Equipment
Care Path
Clinical References
Isolation
Reason For Visit
Implants
External Devices
Study Finding
Surgical Questionnaires
Obstetrics and Gynecology
Pregnancy Plans
Scheduled Surgeries
Appointments
Radiology Results
Correspondences
Picklist
Verified Orders
Employer Group
Cancer Stage
Non Patient Document Information
Premium Billing
Family Situation
Glucose
Restricting Intervention
Prior Auth
Research
Non Patient Customer Relationship Management
Patient Match
Claim
External Non-Provider
Facility Structure
External Radiotherapy Summary
Look-Alikes
Insurance Plan Logo
Radiotherapy Volume
Proxy
Friends and Family
Member Match
Fill Status
Assessments
Outside Record - Clinical Notes
Patient Chart
Outside Record
Quality Measure Summary
SDOH Intervention
Study
Healthcare Services Reimbursement
Prescription Agreement
Prescription Dispense
International Patient Summary
Enhancing Oncology Model
DICOM
Direct Address
MedCom External Care Unit
Phenotype
SDOH Assessments
MedCom Care Message
DICOM Image Characteristics
Death Certificate
Member Attribution
Payer Guideline
Demographics
Auxiliary Function Notification
Plan Net
Supported Codes
Outside Record Vital Signs
Outside Record Results
Outside Record Problems
Outside Record Smoking Status
Organizational Directory
Outside Record Sexual Orientation
Outside Record Encounter Diagnosis
Outside Record Pregnancy Status
Outside Record Health Concern
Outside Record Screening Assessment
Prior Auth Supporting Info
Organization Med List
Patient Insurance Information
No Sub-Resources
USCDI