DOCS_RCVD_RISK_ADJ_ENC_DT

Description:

This table stores the encounter details for risk adjustment diagnosis loads.

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	RAD_ENC_REF_IDENT	VARCHAR	No
	The checksum identifier for this coded encounter detail line.
6	RAD_DX_REF_IDENT	VARCHAR	No
	The reference identifier linking this encounter detail to its diagnosis line in table DOCS_RCVD_RISK_ADJ_CAT. Use this value to look up the corresponding diagnosis.
7	RAD_SVC_START_DATE	DATETIME	No
	The service start date for this coded encounter detail.
8	RAD_SVC_END_DATE	DATETIME	No
	The service end date for this coded encounter detail.
9	RAD_SUBMITTER_CLAIM_IDENT	VARCHAR	No
	The claim identifier assigned by the provider for this coded encounter detail. Filed by DINE from external chart review flat files.
10	RAD_EXTERNAL_DX_ACTION_C_NAME	NUMERIC	No
	The action on diagnosis category ID for the action on the diagnosis taken. Indicates whether this coded encounter detail is an add, remove, or verify action from external chart review. May contain organization-specific values: No Category Entries: Add Remove
11	RAD_PROC_ID_PROC_NAME	VARCHAR	No
	The name of each procedure.
12	RAD_REV_CODE_ID	NUMERIC	No
	The unique ID of the revenue code for this coded encounter detail.
13	RAD_REV_CODE_ID_REVENUE_CODE_NAME	VARCHAR	No
	The name of the revenue code.
14	RAD_REND_PROV_REF_IDENT	VARCHAR	No
	The rendering provider identifier linking this encounter detail to the provider in table DOCS_RCVD_PROV_INFO.
15	RAD_BILLING_PROV_REF_IDENT	VARCHAR	No
	The billing provider identifier linking this encounter detail to the billing provider in table DOCS_RCVD_BILLING_PROV.
16	RAD_ENC_ACTION_CMT_NOTE_ID	VARCHAR	No
	The unique ID of the note storing the comment support the diagnosis action on an encounter detail for risk adjustment.
17	RAD_ENC_BULK_STAT_C_NAME	NUMERIC	No
	The status category ID for the encounter detail data element within the bulk flat file framework (DINE). May contain organization-specific values: No Category Entries: Invalid Valid Inactive
18	RAD_ENC_DATA_FILTER_REASON_C_NAME	NUMERIC	No
	The filter reasons category ID for the reason why the external risk adjustment coded encounter data should be filtered. 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