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
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