CW_ABST_DEMOGRAPHICS

Description:

General abstraction details and demographic information reported to the United States ESRD patient registry.

Primary Key

Column Name	Ordinal Position
REGISTRY_DATA_ID	1

Column Information

	Name	Type	Discontinued?
1	REGISTRY_DATA_ID	NUMERIC	No
	The unique identifier for the registry data record.
2	MCARE_STATUS_C_NAME	VARCHAR	No
	The current Medicare status of the dialysis patient. May contain organization-specific values: No Category Entries: Pending NoCoverage Coverage
3	MCARE_EFF_DATE	DATETIME	No
	The effective date of the current Medicare status of the dialysis patient.
4	EMPY_STATUS_C_NAME	VARCHAR	No
	The current employment status of the dialysis patient. May contain organization-specific values: No Category Entries: Unemployed FullTime PartTime Homemaker RetiredAgePref RetiredDisability MedicalLeave Student Volunteer
5	EMPY_EFF_DATE	DATETIME	No
	The effective date of the current employment status of the dialysis patient.
6	SCHOOL_STATUS_C_NAME	VARCHAR	No
	The current school status of the dialysis patient. May contain organization-specific values: Yes Category Entries: School Full-Time School Part-Time Not in School
7	SCHOOL_EFF_DATE	DATETIME	No
	The effective date of the current school status of the dialysis patient.
8	VOCATIONAL_REHAB_STATUS_C_NAME	VARCHAR	No
	The current vocational rehab status of the dialysis patient. May contain organization-specific values: Yes Category Entries: Referred to VR Currently in VR Completed Not Eligible for VR Declined VR
9	VOCATIONAL_REHAB_EFF_DATE	DATETIME	No
	The effective date of the current vocational rehab status of the dialysis patient.
10	ADMSN_FACILITY_ID_EXTERNAL_NAME	VARCHAR	No
	The external name of the department record. This is often used in patient correspondence such as reminder letters.
11	ADMSN_DATE	DATETIME	No
	The date when the dialysis patient started dialysis treatment in this facility.
12	ADMSN_RSN_C_NAME	VARCHAR	No
	The reason for dialysis admission. May contain organization-specific values: Yes Category Entries: New ESRD Patient Transfer In Restart Dialysis Dialysis after Transplant Failed Dialysis in Support of Transplant
13	TRANSIENT_RSN_C_NAME	VARCHAR	No
	The reason for the dialysis patient being transient. May contain organization-specific values: Yes Category Entries: Disaster Travel Home Maintenance Facility Maintenance Dialysis in Support of Transplant Backup Hemodialysis
14	TRANSFER_RSN_C_NAME	VARCHAR	No
	The transfer discharge reason of a dialysis patient. May contain organization-specific values: Yes Category Entries: Dialysis Facility Hospice Hospital Long Term Care Facility Rehab Center Nursing Home
15	DISCH_DATE	DATETIME	No
	The date when a patient is discharged from the dialysis outpatient facility.
16	DISCH_RSN_C_NAME	VARCHAR	No
	The reason for discharging a patient from the dialysis 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 Delayed Function Resolved following a Transplant Delayed Function Unresolved following a Transplant
17	PRIMARY_TRT_LOCATION_C_NAME	VARCHAR	No
	The primary setting of the patient's dialysis treatment. May contain organization-specific values: Yes Category Entries: Home Dialysis Facility/ Center SNF/ Long Term Care Facility
18	TRT_START_DATE	DATETIME	No
	The treatment start date for dialysis.
19	TRT_TYPE_C_NAME	VARCHAR	No
	The treatment type of dialysis patient. May contain organization-specific values: Yes Category Entries: Hemodialysis CAPD CCPD Other
20	SESSIONS_PER_WEEK	NUMERIC	No
	The number of hemodialysis sessions per week for the dialysis patient.
21	SESSION_LENGTH	INTEGER	No
	The hemodialysis session length.
22	TRT_PROVIDER_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.
23	IS_TRANSIENT_YN	VARCHAR	No
	Shows whether the dialysis patient is transient or not. May contain organization-specific values: No Category Entries: No Yes
24	TRAINING_TYPE_C_NAME	VARCHAR	No
	The type of training obtained by dialysis patient. The category values for this column were already listed for column: TRT_TYPE_C_NAME
25	OTHER_TRAINING_TYPE	VARCHAR	No
	The type of training type if not in the list of common types.
26	TRAINING_TIME_OF_DAY_C_NAME	VARCHAR	No
	The information on whether the patient obtained training for day or nocturnal dialysis. May contain organization-specific values: Yes Category Entries: Day Nocturnal
27	TRAINING_START_DATE	DATETIME	No
	The training start date for the dialysis patient.
28	TRAINING_END_DATE	DATETIME	No
	The training end date for the dialysis patient.
29	SELFCARE_TYPE_C_NAME	VARCHAR	No
	Shows whether the dialysis patient is expected to perform self-care at home or in-center after dialysis training. May contain organization-specific values: No Category Entries: Home Incenter
30	NO_CLINICAL_DATA_YN	VARCHAR	No
	Shows whether the dialysis patient's monthly clinical submission information is available or not. The category values for this column were already listed for column: IS_TRANSIENT_YN
31	EQRS_IDENT	VARCHAR	No
	The dialysis patient's End Stage Renal Disease Quality Reporting System (EQRS) ID used in CMS reporting.
32	ADMISSION_IDENTIFIER	VARCHAR	No
	Unique identifier for dialysis admission.
33	TREATMENT_IDENTIFIER	VARCHAR	No
	It stores the dialysis treatment modality ID of a patient.
34	PAT_FIRST_NAME	VARCHAR	No
	It stores the dialysis patient's first name.
35	PAT_MIDDLE_INITIAL	VARCHAR	No
	It stores a dialysis patient's middle name initial.
36	PAT_LAST_NAME	VARCHAR	No
	It stores a dialysis patient's last name.
37	PAT_NAME_SUFFIX_C_NAME	VARCHAR	No
	It stores a dialysis patient's name suffix. May contain organization-specific values: Yes Category Entries: Jr Sr II III IV V VI
38	PAT_SEX_C_NAME	VARCHAR	No
	It stores the dialysis patient's sex assigned at birth. May contain organization-specific values: No Category Entries: F M
39	PAT_BIRTH_DATE	DATETIME	No
	It stores a dialysis patient's date of birth.
40	PAT_DEATH_DATE	DATETIME	No
	It stores a dialysis patient's date of death.
41	PAT_MBI_NUM	VARCHAR	No
	It stores a dialysis patient's Medicare Beneficiary Identifier number.
42	PAT_SSN	VARCHAR	No
	It stores a dialysis patient's social security number.
43	PHYS_ADDRESS_STREET_1	VARCHAR	No
	It stores a dialysis patient's physical address street line 1.
44	PHYS_ADDRESS_STREET_2	VARCHAR	No
	It stores a dialysis patient's physical address street line 2.
45	PHYS_ADDRESS_STATE_C_NAME	VARCHAR	No
	It stores a dialysis patient's physical address state. May contain organization-specific values: Yes
46	PHYS_ADDRESS_COUNTY_C_NAME	VARCHAR	No
	It stores a dialysis patient's physical address county. May contain organization-specific values: Yes
47	PHYS_ADDRESS_ZIP	VARCHAR	No
	It stores a dialysis patient's ZIP code.
48	PHYS_ADDRESS_ZIP_EXT	VARCHAR	No
	It stores a dialysis patient's physical address ZIP extension.
49	MAIL_ADDRESS_STREET_1	VARCHAR	No
	It stores a dialysis patient's mailing address street line 1.
50	MAIL_ADDRESS_STREET_2	VARCHAR	No
	It stores a dialysis patient's mailing address street line 2.
51	PHYS_ADDRESS_CITY	VARCHAR	No
	It stores a dialysis patient's physical address city.
52	MAIL_ADDRESS_CITY	VARCHAR	No
	It stores a dialysis patient's mailing address city.
53	MAIL_ADDRESS_STATE_C_NAME	VARCHAR	No
	It stores a dialysis patient's mailing address state. The category values for this column were already listed for column: PHYS_ADDRESS_STATE_C_NAME
54	MAIL_ADDRESS_COUNTY_C_NAME	VARCHAR	No
	It stores a dialysis patient's mailing address county. The category values for this column were already listed for column: PHYS_ADDRESS_COUNTY_C_NAME
55	MAIL_ADDRESS_ZIP	VARCHAR	No
	It stores a dialysis patient's mailing address zip code.
56	MAIL_ADDRESS_ZIP_EXT	VARCHAR	No
	It stores a dialysis patient's mailing address zip code extension.
57	WORK_PHONE_AREA_CODE	INTEGER	No
	It indicates a dialysis patient's work phone number area code.
58	WORK_PHONE_NUMBER	VARCHAR	No
	It indicates a dialysis patient's work phone number without the area code.
59	WORK_PHONE_EXTENSION	INTEGER	No
	It indicates a dialysis patient's work phone number extension.
60	HOME_PHONE_AREA_CODE	INTEGER	No
	It stores the area code from a dialysis patient's phone number.
61	HOME_PHONE_NUMBER	VARCHAR	No
	It stores a dialysis patient's phone number.
62	HOME_PHONE_EXTENSION	INTEGER	No
	It stores the phone number extension of a dialysis patient.
63	FAX_PHONE_AREA_CODE	INTEGER	No
	It indicates a dialysis patient's fax number area code.
64	FAX_PHONE_NUMBER	VARCHAR	No
	It indicates a dialysis patient's fax number without the area code.
65	FAX_PHONE_EXTENSION	INTEGER	No
	It indicates a dialysis patient's fax number extension.
66	MOBILE_PHONE_AREA_CODE	INTEGER	No
	It indicates a dialysis patient's mobile phone number area code piece.
67	MOBILE_PHONE_NUMBER	VARCHAR	No
	It indicates a dialysis patient's mobile phone number without the area code.
68	PAGER_PHONE_AREA_CODE	INTEGER	No
	It indicates a dialysis patient's pager number area code piece.
69	PAGER_PHONE_NUMBER	VARCHAR	No
	It indicates a dialysis patient's pager number without the area code.
70	PAGER_PHONE_EXTENSION	INTEGER	No
	It indicates a dialysis patient's pager number extension.
71	OTHER_PHONE_AREA_CODE	INTEGER	No
	It indicates a dialysis patient's other phone number area code.
72	OTHER_PHONE_NUMBER	VARCHAR	No
	It indicates a dialysis patient's other phone number without the area code.
73	OTHER_PHONE_EXTENSION	INTEGER	No
	It indicates a dialysis patient's other phone number extension.
74	TRANSIENT_ADDRESS_STREET_1	VARCHAR	No
	It stores a transient dialysis patient's street address line 1.
75	TRANSIENT_ADDRESS_STREET_2	VARCHAR	No
	It stores a transient dialysis patient's street address line 2.
76	TRANSIENT_ADDRESS_CITY	VARCHAR	No
	It stores the city name of a dialysis patient's transient address.
77	TRANSIENT_ADDRESS_STATE_C_NAME	VARCHAR	No
	It stores a dialysis patient's transient address state. The category values for this column were already listed for column: PHYS_ADDRESS_STATE_C_NAME
78	TRANSIENT_ADDRESS_ZIP	VARCHAR	No
	It stores a dialysis patient's transient address ZIP code.
79	TRANSIENT_ADDRESS_ZIP_EXT	VARCHAR	No
	It stores a dialysis patient's transient address ZIP code extension.
80	TRANSIENT_PHONE_TYPE_C_NAME	VARCHAR	No
	It stores a transient dialysis patient's preferred phone number type. May contain organization-specific values: Yes Category Entries: Work Tel Fax Mobile Pager Other
81	TRANSIENT_PHONE_AREA_CODE	INTEGER	No
	It stores the area code from a transient dialysis patient's phone number.
82	TRANSIENT_PHONE_NUMBER	VARCHAR	No
	It stores the transient phone number of a dialysis patient.
83	TRANSIENT_PHONE_EXTENSION	INTEGER	No
	It stores the extension from a dialysis patient's transient phone number.
84	TRANSIENT_ADDRESS_COUNTY_C_NAME	VARCHAR	No
	It stores a dialysis patient's transient address county. The category values for this column were already listed for column: PHYS_ADDRESS_COUNTY_C_NAME
85	PAT_ETHNICITY_C_NAME	VARCHAR	No
	It stores a dialysis patient's ethnicity. May contain organization-specific values: Yes Category Entries: Non-Hispanic or Latino Hispanic or Latino
86	PAT_COUNTRY_OF_ORIGIN_C_NAME	VARCHAR	No
	It stores a dialysis patient's country of origin. May contain organization-specific values: No Category Entries: Afghanistan Aland Islands Albania Algeria American Samoa Andorra Angola Anguilla Antarctica Antigua and Barbuda Argentina Armenia Aruba Australia Austria Azerbaijan Bahamas Bahrain Bangladesh Barbados Belarus Belgium Belize Benin Bermuda Bhutan Bolivia Bosnia and Herzegovina Botswana Bouvet Island Brazil British Indian Ocean Territory Brunei Darussalam Bulgaria Burkina Faso Burundi Cambodia Cameroon Canada Cape Verde Cayman Islands Central African Republic Chad Chile China Christmas Island Cocos (Keeling) Islands Colombia Comoros Congo Congo, The Democratic Republic of the Cook Islands Costa Rica Cote D'Ivoire Croatia Cuba Cyprus Czech Republic Denmark Djibouti Dominica Dominican Republic Ecuador Egypt El Salvador Equatorial Guinea Eritrea Estonia Ethiopia Falkland Islands (Malvinas) Faroe Islands Fiji Finland France French Guiana French Polynesia French Southern Territories Gabon Gambia Georgia Germany Ghana Gibraltar Greece Greenland Grenada Guadeloupe Guam Guatemala Guinea Guinea-Bissau Guyana Haiti Heard Island and McDonald Islands Holy See (Vatican City State) Honduras Hong Kong Hungary Iceland India Indonesia Iran, Islamic Republic of Iraq Ireland Israel Italy Jamaica Japan Jordan Kazakhstan Kenya Kiribati Korea, Democratic People's Republic of (North Korea) Korea, Republic of (South Korea) Kuwait Kyrgyzstan Lao People's Democratic Republic (Laos) Latvia Lebanon Lesotho Liberia Libyan Arab Jamahiriya (Libya) Liechtenstein Lithuania Luxembourg Macao Macedonia, The Former Yugoslav Republic of Madagascar Malawi Malaysia Maldives Mali Malta Marshall Islands Martinique Mauritania Mauritius Mayotte Mexico Micronesia Moldova, Republic of Monaco Mongolia Montserrat Morocco Mozambique Myanmar Namibia Nauru Nepal Netherlands Netherlands Antilles New Caledonia New Zealand Nicaragua Niger Nigeria Niue Norfolk Island Northern Mariana Islands Norway Oman Pakistan Palau Palestinian Territory, Occupied Panama Papua New Guinea Paraguay Peru Philippines Pitcairn Poland Portugal Puerto Rico Qatar Reunion Romania Russian Federation Rwanda Saint Helena Saint Kitts and Nevis Saint Lucia Saint Pierre and Miquelon Saint Vincent and The Grenadines Samoa San Marino Sao Tome and Principe Saudi Arabia Senegal Serbia and Montenegro Seychelles Sierra Leone Singapore Slovakia Slovenia Solomon Islands Somalia South Africa South Georgia and South Sandwich Islands Spain Sri Lanka Sudan Suriname Svalbard and Jan Mayen Swaziland Sweden Switzerland Syrian Arab Republic Taiwan Tajikistan Tanzania, United Republic of Thailand Timor-Leste Togo Tokelau Tonga Trinidad and Tobago Tunisia Turkey Turkmenistan Turks and Caicos Islands Tuvalu Uganda Ukraine United Arab Emirates Great Britain United States United States Minor Outlying Islands Uruguay Uzbekistan Vanuatu Venezuela Vietnam Virgin Islands (British) Virgin Islands (U.S.) Wallis and Futuna Western Sahara Yemen Zambia Zimbabwe
87	PAT_ETHNICITY_SOURCE_C_NAME	VARCHAR	No
	It stores the source of a dialysis patient's race and ethnicity information. May contain organization-specific values: No Category Entries: SelfReported NotSelfReported FamilyReported PatientDeclined
88	PAT_CITIZENSHIP_STATUS_C_NAME	VARCHAR	No
	It stores the current citizenship status of a dialysis patient. May contain organization-specific values: No Category Entries: USCitizen NonUSCitizen ForeignUsResident USResident
89	PAT_CITIZENSHIP_EFF_DATE	DATETIME	No
	It stores the effective date of the current citizenship status of a dialysis patient.
90	PAT_HIC_NUM	VARCHAR	No
	It stores a dialysis patient's Medicare health insurance claim number.
91	PAT_TRIBE_CODE	INTEGER	No
	It stores a dialysis patient's tribe code.
92	INVOLUNTARY_DISCH_RSN_C_NAME	VARCHAR	No
	It stores the reason of involuntary discharge for a dialysis patient. May contain organization-specific values: Yes Category Entries: Non-adherence Verbal/written abuse Verbal/written threat Physical threat Physical harm Property damage/theft Lack of payment
93	DLYS_ABSTRACTION_PURPOSE_C_NAME	VARCHAR	No
	It stores the purpose of a patient's dialysis regulatory reporting form, such as an admission, a discharge, or a monthly submission. May contain organization-specific values: No Category Entries: Monthly Admission Discharge Transient Admission
94	PAT_IN_NURSING_HOME_YN	VARCHAR	No
	It stores whether the dialysis patient was in a nursing home setting as of the end of the reporting period. The category values for this column were already listed for column: IS_TRANSIENT_YN
95	DIALYSIS_NURSING_HOME_C_NAME	VARCHAR	No
	It stores the dialysis patient's nursing home setting. May contain organization-specific values: No Category Entries: Permanent Resident Short Term Care/Rehabilitation Other
96	PAT_ORG_IDENT	VARCHAR	No
	The dialysis patient's organization identifier used in CMS reporting.
97	PAT_ENTERED_NURSING_HOME_DATE	DATETIME	No
	The date when the dialysis patient entered the nursing home.