DOCS_RCVD_DX

Description: |
This table stores discrete diagnosis information 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 |
This item stores the Received Document record ID.
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 | DX_REF_ID | VARCHAR | No |
Reference ID for this diagnosis.
6 | DX_ENC_ID | VARCHAR | No |
Reference ID of the encounter associated with this diagnosis.
7 | DX_NAME | VARCHAR | No |
Display name of this diagnosis.
8 | DX_CONTEXT_C_NAME | VARCHAR | No |
The type of diagnosis.
May contain organization-specific values: No
Category Entries:
Admitting Diagnosis
Discharge Diagnosis
Encounter Diagnosis
Result Order
9 | DX_SRC_CSN | NUMERIC | No |
Contains the Contact Serial Number (CSN) of the source external document record that has the external diagnosis information.
10 | DX_START_DTTM | DATETIME (Local) | No |
Start time for this diagnosis.
11 | DX_END_DTTM | DATETIME (Local) | No |
End time for this diagnosis.
12 | DX_EDG_ID_DX_NAME | VARCHAR | No |
The name of the diagnosis.
13 | DX_LST_UPD_INST_DTTM | DATETIME (UTC) | No |
Stores the last update instant of the diagnosis in UTC.
14 | DX_PRIMARY_YN | VARCHAR | No |
Denotes if this diagnosis is the primary diagnosis.
May contain organization-specific values: No
Category Entries:
No
Yes
15 | DX_FILTER_RSN_C_NAME | VARCHAR | No |
Stores the reason why an external diagnosis should be filtered from the composite external document record
May contain organization-specific values: No
Category Entries:
Claim Derivation: Procedure Code Inclusion/Exclusion List
Claim Derivation: Missing Provider
Claim Derivation: Sensitive Diagnosis
Claim Derivation: Missing Procedure Start Date
Claim Derivation: Excluded Procedure Modifier
Source Organization Unknown
Source Organization Mismatch
Source Organization Is Self
Clinical Note Type Exclusion List
Clinical Note Missing Service Instant
Clinical Note Missing Last Filed Instant
Clinical Note Missing Author Name
Dispense Cancellation
Same Day as Internal Encounter
Missing or Invalid Binary URL
Filtered or Missing Source Note
DocumentReference Status not Current
Claim Derivation: Excluded Linked Diagnoses
Claim Derivation: Missing Encounter Start Date
Entered In Error
FHIR resource contained an invalid category
Condition verification status is no longer confirmed
Condition is no longer valid for this patient due to age or sex
FHIR resource has an invalid start date
Encounter FHIR resource is missing the type element
FHIR resource is missing the status element
Encounter FHIR resource is missing the class element
Encounter FHIR resource contained an unrecognized status code
Encounter FHIR resource contained a status code for a future encounter
Encounter FHIR resource contained a class code for a future encounter
FHIR resource has a future start date
FHIR resource does not have a status of completed
FHIR resource is missing the code element
Diagnosis is missing a link to an encounter
FHIR resource contains a reference to encounter not in the system
FHIR resource contained a patient reference not matching the searched for patient
Immunization FHIR Resource is missing the vaccineCode element or did not contain a CVX code
FHIR Resource is missing an effective date/time
FHIR resource contained an invalid status
Observation FHIR resource is linked to a filtered Condition FHIR resource
SDOH Assessment contains no questions
Missing required data for data type
FHIR resource does not have a status of confirmed
Claim Derivation: Missing face-to-face services
Condition marked invalid in external data
Condition missing from subsequent bulk flat file load
Data invalidated by delete utility
LDA Added in Error
LDA Assessment Moved/Deleted
LDA Not Wound/Burn
Row Concept Unmappable
Row Value Unmappable
16 | DX_IS_ED_YN | VARCHAR | No |
Denotes if this diagnosis was made in the ED.
The category values for this column were already listed for column: DX_PRIMARY_YN
17 | DX_BULK_STAT_C_NAME | VARCHAR | No |
The status of this data element within DINE.
May contain organization-specific values: No
Category Entries:
Invalid
Valid
Inactive
18 | DX_BULK_INCL_DATE | DATETIME | No |
The date to compare to the change tracking window when loading flat files in bulk via DINE. If the date is within the window, but the data element is missing from the load, then the data element is invalidated.
19 | DX_GENERIC_NAME | VARCHAR | No |
The generic name for an Ambient-detected dianosis, representing what was heard in the visit recording.
20 | DX_BEST_MATCH_DX_REFID | VARCHAR | No |
For an Ambient diagnosis, stores the ID from I DXR 11300 of the Ambient diagnosis that this is an alternative to. This allows Ambient vendors to send multiple variations of a single detected diagnosis for a provider to choose from.
21 | DX_CONFIDENCE_RANK | INTEGER | No |
Ranking of confidence in an Ambient-detected diagnosis, compared to other alternatives presented, with 1 being the most confident.
22 | DX_STATE_HOLOGRAM_ID | NUMERIC | No |
ID of the HOL record storing the current state of an Ambient-detected diagnosis
23 | DX_TOPIC_NAME | VARCHAR | No |
The topic name for an Ambient-detected diagnosis. Diagnoses that share a topic name will be grouped together under that name when presented to the user in the "Heard In Visit Recording" workflow.
24 | DX_NOTED_DATE | DATETIME | No |
This item stores the noted date for the visit diagnosis from a hospital admission, which comes from the hospital problem list.
25 | DX_DOCUMENTED_INST_UTC_DTTM | DATETIME (UTC) | No |
This item stores the instant the diagnosis was first documented in UTC.
26 | DX_POA_C_NAME | VARCHAR | No |
This item stores the present on admission category value for the diagnosis.
May contain organization-specific values: Yes
Category Entries:
Yes
No
Unknown
Clinically Undetermined
Exempt from POA reporting