REFERRAL_4

Description:

The REFERRAL_4 table is a continuation of the REFERRAL_3 which is continuation of the REFERRAL_2 table. These tables are the primary tables for referral information stored in the system.

Primary Key

Column Name	Ordinal Position
REFERRAL_ID	1

Column Information

	Name	Type	Discontinued?
1	REFERRAL_ID	NUMERIC	No
	The referral ID for the referral record.
2	ATTEND_PROV_ADDR_ID	VARCHAR	No
	This item stores the address ID of the attending provider. The format is as follows: SerID-AddressID. AddressID is the line number of the multiple response address items in the Provider (SER) master file. It can be used to print the correct address in a report or letter, for example.
3	RFL_NET_LVL_C_NAME	VARCHAR	No
	Store the referral's network status May contain organization-specific values: Yes Category Entries: In Network Out of Network N/A
4	GEOGRAPHIC_AREA_ID_AREA_NAME	VARCHAR	No
	The name of the geograpic region
5	IN_OUT_OF_AREA_C_NAME	VARCHAR	No
	In or out-of-area classification from ZIP code mapping. May contain organization-specific values: No Category Entries: In Out
6	GEN_RFL_SEC_SINCE_MIDNIGHT_1	NUMERIC	No
	Referral-level generic time item for general use.
7	GEN_RFL_SEC_SINCE_MIDNIGHT_2	NUMERIC	No
	Referral-level generic time item for general use.
8	GEN_RFL_SEC_SINCE_MIDNIGHT_3	NUMERIC	No
	Referral-level generic time item for general use.
9	GEN_RFL_SEC_SINCE_MIDNIGHT_4	NUMERIC	No
	Referral-level generic time item for general use.
10	GEN_RFL_SEC_SINCE_MIDNIGHT_5	NUMERIC	No
	Referral-level generic time item for general use.
11	AUDIT_REF_TO_LOC_ID_LOC_NAME	VARCHAR	No
	The name of the revenue location.
12	AUDIT_REF_TO_DEPARTMENT_ID_EXTERNAL_NAME	VARCHAR	No
	The external name of the department record. This is often used in patient correspondence such as reminder letters.
13	AUDIT_REFG_PROV_ID_PROV_NAME	VARCHAR	No
	The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
14	AUDIT_REFG_PROV_ADDR	VARCHAR	No
	This item is used to audit data from incoming Care Everywhere referrals. It stores the original text for the referring provider address ID.
15	AUDIT_REF_TO_PROV_ID_PROV_NAME	VARCHAR	No
	The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
16	AUDIT_REF_TO_PROV_ADDR	VARCHAR	No
	This item is used to audit data from incoming Care Everywhere referrals. It stores the original text for the referred-to provider address ID.
17	AUDIT_RFL_SRC_LOC_ID_LOC_NAME	VARCHAR	No
	The name of the revenue location.
18	RFL_DIRECTION_C_NAME	VARCHAR	No
	The referral direction, as calculated by logic for transitions of care May contain organization-specific values: No Category Entries: Internal Incoming Outgoing
19	REFD_TO_LINK_PROV_YN	VARCHAR	No
	Is the referred to provider an EpicCare Link provider May contain organization-specific values: No Category Entries: No Yes
20	REFD_TO_LINK_LOC_YN	VARCHAR	No
	Is the referred to location an EpicCare Link location The category values for this column were already listed for column: REFD_TO_LINK_PROV_YN
21	IS_LEAKED_YN	VARCHAR	No
	Holds whether the referral is considered leaked The category values for this column were already listed for column: REFD_TO_LINK_PROV_YN
22	TRIAGE_REMIND_DATE	DATETIME	No
	A date in the future when the user should be reminded of this referral.
23	TRIAGE_INFO_RECPNT_C_NAME	VARCHAR	No
	The recipient of a request for more information. This item holds which item should be looked to for routing purposes. May contain organization-specific values: No Category Entries: None Referred by Provider Referred by Department Referred by Location PCP Referral Source Automatic Notification Other
24	CE_DISCONNECT_YN	VARCHAR	No
	Indicates that this referral is disconnected from the sending organization for Care Everywhere referrals. The category values for this column were already listed for column: REFD_TO_LINK_PROV_YN
25	RECENT_AUTH_RSN_C_NAME	VARCHAR	No
	This item holds the most recent non-empty authorization reason for the referral. If this item is null, it means the referral was never authorized. If value is added/updated to the authorization code (I RFL 73), same value is copied into this item. But if authorization code (I RFL 73) is cleared, then this item is not updated. May contain organization-specific values: Yes
26	RECENT_DENY_RSN_C_NAME	VARCHAR	No
	This item holds the most recent non-empty denial reason for the referral. If this item is null, it means the referral was never denied. If value is added/updated to the reason for denial (I RFL 18007), same value is copied into this item. But if reason for denial (I RFL 18007) is cleared, then this item is not updated. May contain organization-specific values: Yes
27	TRIAGE_UNACCEPT_REASON_C_NAME	VARCHAR	No
	The unaccept reason that was specified when the triage decision changed from accept to no decision. May contain organization-specific values: Yes No Entries Defined
28	ADMITTING_PROV_ID_PROV_NAME	VARCHAR	No
	The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
29	EXPECTED_DISCHARGE_DATE	DATETIME	No
	The expected discharge date documented on the referral bed days form of referral entry.
30	GEN_RFL_DATE_6_DT	DATETIME	No
	This contains information from generic referral date item 6.
31	GEN_RFL_DATE_7_DT	DATETIME	No
	This contains information from generic referral date item 7.
32	GEN_RFL_DATE_8_DT	DATETIME	No
	This contains information from generic referral date item 8.
33	GEN_RFL_DATE_9_DT	DATETIME	No
	This contains information from generic referral date item 9.
34	GEN_RFL_DATE_10_DT	DATETIME	No
	This contains information from generic referral date item 10.
35	GEN_RFL_SEC_SINCE_MIDNIGHT_6	NUMERIC	No
	This contains information from generic referral time item 6.
36	RFL_SVC_TYPE_CODE_C_NAME	VARCHAR	No
	Specifies the service type that applies to the entire referral. May contain organization-specific values: No Category Entries: Medical Care Surgical Consultation Diagnostic X-Ray Diagnostic Lab Radiation Therapy Anesthesia Surgical Assistance Other Medical Blood Charges Used Durable Medical Equipment Durable Medical Equipment Purchase Ambulatory Service Center Facility Renal Supplies in the Home Alternate Method Dialysis Chronic Renal Disease (CRD) Equipment Pre-Admission Testing Durable Medical Equipment Rental Pneumonia Vaccine Second Surgical Opinion Third Surgical Opinion Social Work Diagnostic Dental Periodontics Restorative Endodontics Maxillofacial Prosthetics Adjunctive Dental Services Health Benefit Plan Coverage Plan Waiting Period Chiropractic Chiropractic Office Visits Dental Care Dental Crowns Dental Accident Orthodontics Prosthodontics Oral Surgery Routine (Preventive) Dental Home Health Care Home Health Prescriptions Home Health Visits Hospice Respite Care Hospital Hospital - Inpatient Hospital - Room and Board Hospital - Outpatient Hospital - Emergency Accident Hospital - Emergency Medical Hospital - Ambulatory Surgical Long Term Care Major Medical Medically Related Transportation Air Transportation Cabulance Licensed Ambulance General Benefits In-vitro Fertilization MRI/CAT Scan Donor Procedures Acupuncture Newborn Care Pathology Smoking Cessation Well Baby Care Maternity Transplants Audiology Exam Inhalation Therapy Diagnostic Medical Private Duty Nursing Prosthetic Device Dialysis Otological Exam Chemotherapy Allergy Testing Immunizations Routine Physical Family Planning Infertility Abortion AIDS Emergency Services Cancer Pharmacy Free Standing Prescription Drug Mail Order Prescription Drug Brand Name Prescription Drug Generic Prescription Drug Podiatry Podiatry - Office Visits Podiatry - Nursing Home Visits Professional (Physician) Anesthesiologist Professional (Physician) Visit - Office Professional (Physician) Visit - Inpatient Professional (Physician) Visit - Outpatient Professional (Physician) Visit - Nursing Home Professional (Physician) Visit - Skilled Nursing Facility Professional (Physician) Visit - Home Psychiatric Psychiatric - Room and Board Psychotherapy Psychiatric - Inpatient Psychiatric - Outpatient Rehabilitation Rehabilitation - Room and Board Rehabilitation - Inpatient Rehabilitation - Outpatient Occupational Therapy Physical Medicine Speech Therapy Skilled Nursing Care Skilled Nursing Care - Room and Board Substance Abuse Alcoholism Drug Addiction Vision (Optometry) Frames Routine Exam Lenses Nonmedically Necessary Physical Experimental Drug Therapy Burn Care Brand Name Prescription Drug - Formulary Brand Name Prescription Drug - Non-Formulary Independent Medical Evaluation Partial Hospitalization (Psychiatric) Day Care (Psychiatric) Cognitive Therapy Massage Therapy Pulmonary Rehabilitation Cardiac Rehabilitation Pediatric Nursery Skin Orthopedic Cardiac Lymphatic Gastrointestinal Endocrine Neurology Eye Invasive Procedures Gynecological Obstetrical Obstetrical/Gynecological Mail Order Prescription Drug: Brand Name Mail Order Prescription Drug: Generic Physician Visit - Office: Sick Physician Visit - Office: Well Coronary Care Private Duty Nursing - Inpatient Private Duty Nursing - Home Surgical Benefits - Professional (Physician) Surgical Benefits - Facility Mental Health Provider - Inpatient Mental Health Provider - Outpatient Mental Health Facility - Inpatient Mental Health Facility - Outpatient Substance Abuse Facility - Inpatient Substance Abuse Facility - Outpatient Screening X-ray Screening laboratory Mammogram, High Risk Patient Mammogram, Low Risk Patient Flu Vaccination Eyewear and Eyewear Accessories Case Management Dermatology Durable Medical Equipment Diabetic Supplies Generic Prescription Drug - Formulary Generic Prescription Drug - Non-Formulary Allergy Intensive Care Mental Health Neonatal Intensive Care Oncology Physical Therapy Pulmonary Renal Residential Psychiatric Treatment Transitional Care Transitional Nursery Care Urgent Care
37	INT_RFL_TYPE_C_NAME	VARCHAR	No
	The internal referral type for the referral. May contain organization-specific values: No Category Entries: Home Health Hospice