DOCS_RCVD_PROC

Description:

This table stores procedure 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
	The unique identifier 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	PROC_REF_ID	VARCHAR	No
	This item stores the unique reference ID.
6	PROC_TYPE_ID_PROC_NAME	VARCHAR	No
	The name of each procedure.
7	PROC_TYPE_TXT	VARCHAR	No
	This item stores the free text name for the external procedure.
8	PROC_PERF_AT_ID_LOC_NAME	VARCHAR	No
	The name of the revenue location.
9	PROC_PERF_AT_TXT	VARCHAR	No
	This item stores the free text location where the external procedure was performed.
10	PROC_START_DATE	DATETIME	No
	This item stores the start date of the external procedure.
11	PROC_END_DATE	DATETIME	No
	This item stores the end date of the external procedure.
12	PROC_EVENT_ID	VARCHAR	No
	This item holds the event identifier of the event information for the procedure.
13	PROC_MASTER_REF_ID	VARCHAR	No
	This item will be used to indicate duplicate procedure data.
14	PROC_LST_UPD_INST_DTTM	DATETIME (UTC)	No
	Stores the last update instant of the procedure in Coordinated Universal Time (UTC).
15	PROC_UNSUCCESSFUL_FLG_C_NAME	VARCHAR	No
	Indicates whether a procedure was an unsuccessful attempt May contain organization-specific values: No Category Entries: Unsuccessful Attempt Documented on Wrong Patient
16	PROC_UNSUCCESS_INST_UTC_DTTM	DATETIME (UTC)	No
	Instant the procedure unsuccessful flag was set
17	PROC_STATE_C_NAME	VARCHAR	No
	This item contains the status code of a procedure when received from a document. May contain organization-specific values: No Category Entries: Other Normal Aborted Active Cancelled Completed Held New Suspended Nullified Obsolete
18	PROC_DUP_INT_PROC_ID	NUMERIC	No
	Stores the ID of the Order record of an internal charge that is a duplicate of this row in an external document record.
19	PROC_DUP_INT_UCL_ID	VARCHAR	No
	Stores the ID of the Universal Charge Lines record of an internal charge that is a duplicate of this row in an external document record.
20	PROC_DUP_INT_TX_ID	NUMERIC	No
	Stores the ID of the Accounts Receivable Transaction record of an internal charge that is a duplicate of this row in an external document record.
21	PROC_DUP_INT_HOSP_TX_ID	NUMERIC	No
	Stores the ID of the Hospital Permanent Transaction record of an internal charge that is a duplicate of this row in an external document record.
22	PROC_FILTER_RSN_C_NAME	VARCHAR	No
	Stores the reason why an external procedure should be filtered from the composite 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 Claim Derivation: Missing face-to-face services