NEPHROLOGY_INFO
Description:
The NEPHROLOGY_INFO table contains information about a patient's dialysis episode. The records included in this table are HSB records that are designated as dialysis episodes, where the episode type (HSB 35250) has a value of 35.

Primary Key
Column Name Ordinal Position
EPISODE_ID 1

Column Information
Name Type Discontinued?
1 EPISODE_ID NUMERIC No
The unique identifier for the dialysis episode record.
2 CONTACT_TYPE_ID_EPISODE_DEF_NAME VARCHAR No
This column displays the name of the episode / block definition record.
3 EPISODE_STATUS_C_NAME VARCHAR No
The episode's status.
May contain organization-specific values: No
Category Entries:
Active
Resolved
Deleted
4 DEPARTMENT_ID_EXTERNAL_NAME VARCHAR No
The external name of the department record. This is often used in patient correspondence such as reminder letters.
5 COMMENTS VARCHAR No
The episode comments.
6 DIALYSIS_ADMISSION_REASON_C_NAME VARCHAR No
This item stores the patient's reason for starting dialysis treatment in a facility.
May contain organization-specific values: Yes
Category Entries:
New Dialysis Patient
Transfer In
Restart Dialysis
Dialysis after Transplant Failed
Dialysis in Support of Transplant
7 TRANSIENT_YN VARCHAR No
This item is used to indicate whether the patient is receiving temporary treatment at a dialysis facility.
May contain organization-specific values: No
Category Entries:
Yes
No
8 DIALYSIS_DISCHARGE_REASON_C_NAME VARCHAR No
This item stores the patient's reason for ending dialysis treatment in a facility.
May contain organization-specific values: Yes
Category Entries:
Death
Discontinue
Lost to Follow-Up
Recover Function of Original Kidney
Involuntary
Other
Transplant in US
Transplant outside US
Transfer
Acute
Move to Chronic
Delayed Function Resolved following a Transplant
Delayed Function Unresolved following a Transplant
9 TRANSFER_DESTINATION_C_NAME VARCHAR No
This item is used to store where a patient will be getting dialysis treatment after discharging from the current facility.
May contain organization-specific values: Yes
Category Entries:
Dialysis Facility
Hospice
Hospital
Long Term Care Facility
Rehab Center
Nursing Home
10 TREATMENT_TYPE_C_NAME VARCHAR No
This item is used to store a patient's type of dialysis treatment.
May contain organization-specific values: Yes
Category Entries:
Hemo
Peritoneal
Continuous Arteriovenous Hemofiltration
Continuous Veno-Venous Hemofiltration
Acute-Hemo
Acute-Peritoneal
Continuous Veno-Venous Hemodialysis
Continuous Arteriovenous Hemodialysis
Maintenance (Type Unknown)
In-center Hemodialysis
Home Hemodialysis
Continuous Ambulatory Peritoneal Dialysis
Continuous Cycling Peritoneal Dialysis
11 DIALYSIS_HISTORICAL_EPISODE_YN VARCHAR No
This item is used to indicate whether the episode is a historical or external dialysis treatment episode, or an internal dialysis treatment episode.
May contain organization-specific values: No
Category Entries:
No
Yes
12 DIALYSIS_DISCHARGE_OTHR VARCHAR No
This item stores a free text comment if a patient's dialysis discharge reason is set to Other.
13 DIALYSIS_START_DATE DATETIME No
This item is used to store the start date of a patient's dialysis treatment episode.
14 DIALYSIS_END_DATE DATETIME No
This item is used to store the end date of a patient's dialysis treatment episode.
15 PLACE_OF_SERVICE_ID_LOC_NAME VARCHAR No
The name of the revenue location.
16 MODALITY_START_DATE DATETIME No
This item stores a dialysis patient's start date of their current treatment details.
17 DIALYSIS_EPISODE_PURPOSE_C_NAME VARCHAR No
Indicates the purpose of the dialysis episode.
May contain organization-specific values: No
Category Entries:
Dialysis Tracking
SPoC Pre-Dialysis Tracking
18 NEPH_DLYS_TYPE_C_NAME VARCHAR No
The type of dialysis. Either end stage renal disease (ESRD) or acute kidney injury (AKI). If null then the episode is assumed to be ESRD.
May contain organization-specific values: No
Category Entries:
End Stage Renal Disease
Acute Kidney Injury
19 NEPH_TRANSIENT_RSN_C_NAME VARCHAR No
This item stores the patient's reason for receiving temporary treatment at a dialysis facility.
May contain organization-specific values: Yes
Category Entries:
Disaster
Travel
Home Maintenance
Facility Maintenance
Dialysis in Support of Transplant
Backup Hemodialysis
20 TREATMENT_SESSIONS_PER_WEEK NUMERIC No
This item stores the most recently prescribed sessions per week of the dialysis treatments.
21 TREATMENT_DURATION_MINUTES INTEGER No
This item stores the most recently prescribed duration of each dialysis treatment in minutes.
22 EXTERNAL_FACILITY_ID_LOC_NAME VARCHAR No
The name of the revenue location.