REFERRAL_CE_CODE

Description:

This audit table stores the Care Everywhere Codes.

Primary Key

Column Name	Ordinal Position
REFERRAL_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	REFERRAL_ID	NUMERIC	No
	The unique identifier for the referral record.
2	LINE	INTEGER	No
	The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3	AUDIT_CODE_TYPE_C_NAME	VARCHAR	No
	Stores the type of the specialty code stored in column AUDIT_CODE. This column is used to audit data from incoming Care Everywhere referrals. May contain organization-specific values: No Category Entries: Referred To Provider Referred To Department Specialty Referring Department Specialty Referred To Provider Specialty Referring Provider Specialty Diagnosis Procedure Referral Type Priority Condition MAG Treatment MAG Specialty MAG Subspecialty MAG
4	AUDIT_CODE_RFNCID	VARCHAR	No
	Stores the reference ID corresponding to the specialty code stored in AUDIT_CODE. This reference ID is used as an index for the Diagnoses or Procedures table. This column is used to audit data from incoming Care Everywhere referrals.
5	AUDIT_CODE	VARCHAR	No
	Stores the provider or department specialty code received from the referring organization with an external referral. The type of the specialty code is stored in column AUDIT_CODE_TYPE_C. This column is used to audit data from incoming Care Everywhere referrals.
6	AUDIT_CODE_SYS	VARCHAR	No
	Stores the code system used by the referring organization to send the specialty code in column AUDIT_CODE. This column is used to audit data from incoming Care Everywhere referrals.
7	AUDIT_CODE_NAME	VARCHAR	No
	Stores the name of the specialty code in column AUDIT_CODE. This column is used to audit data from incoming Care Everywhere referrals.