The services table
Table source: Hospital database.
Table purpose: Lists services that a patient was admitted/transferred under.
Number of rows: 73,343
- PATIENTS on
- ADMISSIONS on
The services table describes the service that a patient was admitted under. While a patient can be physicially located at a given ICU type (say MICU), they are not necessarily being cared for by the team which staffs the MICU. This can happen due to a number of reasons, including bed shortage. The SERVICES table should be used if interested in identifying the type of service a patient is receiving in the hospital. For example, if interested in identifying surgical patients, the recommended method is searching for patients admitted under a surgical service.
Each service is listed in the table as an abbreviation - this is exactly how the data is stored in the hospital database. For user convenience, we have provided a description of each service type.
|CMED||Cardiac Medical - for non-surgical cardiac related admissions|
|CSURG||Cardiac Surgery - for surgical cardiac admissions|
|DENT||Dental - for dental/jaw related admissions|
|ENT||Ear, nose, and throat - conditions primarily affecting these areas|
|GU||Genitourinary - reproductive organs/urinary system|
|GYN||Gynecological - female reproductive systems and breasts|
|MED||Medical - general service for internal medicine|
|NB||Newborn - infants born at the hospital|
|NBB||Newborn baby - infants born at the hospital|
|NMED||Neurologic Medical - non-surgical, relating to the brain|
|NSURG||Neurologic Surgical - surgical, relating to the brain|
|OBS||Obstetrics - conerned with childbirth and the care of women giving birth|
|ORTHO||Orthopaedic - surgical, relating to the musculoskeletal system|
|OMED||Orthopaedic medicine - non-surgical, relating to musculoskeletal system|
|PSURG||Plastic - restortation/reconstruction of the human body (including cosmetic or aesthetic)|
|PSYCH||Psychiatric - mental disorders relating to mood, behaviour, cognition, or perceptions|
|SURG||Surgical - general surgical service not classified elsewhere|
|TRAUM||Trauma - injury or damage caused by physical harm from an external source|
|TSURG||Thoracic Surgical - surgery on the thorax, located between the neck and the abdomen|
|VSURG||Vascular Surgical - surgery relating to the circulatory system|
|Name||Postgres data type|
Identifiers which specify the patient:
SUBJECT_ID is unique to a patient and
HADM_ID is unique to a patient hospital stay.
TRANSFERTIME is the time at which the patient moved from the
PREV_SERVICE (if present) to the
CURR_SERVICE are the previous and current service that the patient resides under.
Was this page helpful?
Glad to hear it! Please raise an issue here to tell us how we can improve.
Sorry to hear that. Please raise an issue here to tell us how we can improve.