Exporting data: Glossary
Below you'll find a glossary of terms used in Bamboo:
| Name | Description |
| Facility Pinged | This is the facility that received the Ping |
| Facility Name | This is the name of the facility where the patient event occurred. |
| Facility NPI | NPI associated with the facility where the patient event occurred. |
| Facility City | This is the city where the facility is located. |
| Facility State | This is the state where the facility is located. |
| Facility Type | This is the type of facility where the event occurred. Possible facility types include (but are not limited to): ALF - Assisted Living Facility HHA - Home Health Agency HOS - Hospital HOSPICE - Hospice LTAC - Long-Term Acute Care REHAB_HOS - Rehabilitation Hospital SNF - Skilled Nursing Facility URGENT_CARE –Urgent Care Facility Palliative - Palliative Care Facility |
| Visit ID | This is an internal Bamboo ID that shows what events are linked to the same patient visit or encounter. |
| Status | This refers to the type of event, typically Admit, Transferred, Presented, Discharged, or Deceased. Additional status options include Medical LOA, Resume Services, and End Services used by SNFs to indicate medical leave of absence encounter updates. Bamboo closes hanging ED visits (when a patient has been marked as in the ED for > 5 days, with no updates). These events have the status Closed. If there is a payor change without a corresponding event, the status is listed as Payor Change. The visit is used by single event encounters, such as Urgent Care visits, and only includes 1 event for the encounter. |
| Status Date | This is the date when the patient event occurred. For example, if the status is an Admit this would be the date the patient was admitted. By default, exports will be sorted in descending order by this field. |
| Status Time | This is the time when the patient event occurred. For example, if the status is an Admit this would be the time the patient was admitted. Manual facilities do not provide time stamps, and in such cases status time will be blank. Times are given in the time zone of the facility where the event occurred. By default, exports will be sorted in descending order by this field. |
| Event Receive Date | This is the date when the patient event was created in the sending system at the admitting facility or the date it was created in Bamboo if a manual event. |
| Event Receive Time | This is the time when the patient event was created in the sending system at the admitting facility or the time it was entered into Bamboo if it was a manually added event, in Eastern Time Zone (GMT -5). |
| Event Processed Date | This is the date when Bamboo received and processed the patient event |
| Event Processed Time | This is the time when Bamboo received and processed the patient event, in Eastern Time Zone (GMT -5) |
| Setting | A description of the patient's care setting (e.g., inpatient, observation, emergency, skilled, etc.), if available. Options include: Inpatient, Emergency, Observation, Unknown, Long-Term Care, Long-Term Acute Care, Memory, Skilled, Non-Skilled, Hospice, Assisted Living, Respite, Acute, Independent Living, Urgent Care or a null value. For any transfer event, the setting field will indicate the new care setting. |
| Patient ID | This is the unique ID you provided on your patient roster or MRN for admitting facilities. |
| Last Name | Patient's last name, as provided in your patient roster, via HL7, or provided manually in the application |
| First Name | Patient's first name, as provided in your patient roster, via HL7, or provided manually in the application |
| Middle Initial | Patient's middle initial, as provided in your roster. |
| Suffix | Patient's suffix (e.g., Jr.), as provided in your roster. |
| DOB | Patient's date of birth, as provided in your patient roster, or via HL7 for automated admitting facilities, or manually within the application. |
| Gender | Patient's gender, as provided in your patient roster, or via HL7 for automated admitting facilities, or manually within the application. Options are Male, Female, Other, or Unknown |
| Address 1 | Patient's street address, as provided in your roster. |
| Address 2 | The second line of your patient's street address, as provided in your roster. |
| Address 3 | The third line of your patient's street address, as provided in your roster |
| City | Patient's city, as provided in your roster. |
| State | Patient's state, as provided in your roster. |
| Zip | Patient's zip code, as provided in your roster. |
| Mobile Phone | If you provided this information in your roster, this is the mobile phone number you listed for your patient. |
| Home Phone | If you provided this information in your roster, this is the home phone number you listed for your patient. |
| Patient Phone Number (Unknown source) | This is the patient phone number provided to PatientPing via admitting facility HL7 interfaces |
| Primary Insurance Number | If you provided this information in your roster, this is the health insurance number you listed for your patient's primary insurance. |
| Primary Insurer | If you provided this information in your roster, this is the health insurer you listed for your patient's primary insurance. |
| Primary Insurance Plan | If you provided this information in your roster, this is the health insurance plan (e.g., HMO, PPO, etc.) you listed for your patient's primary insurance. |
| Secondary Insurance Number | If you provided this information in your roster, this is the health insurance number you listed for your patient's secondary insurance. |
| Secondary Insurer | If you provided this information in your roster, this is the health insurer you listed for your patient's secondary insurance. |
| Secondary Insurance Plan | If you provided this information in your roster, this is the health insurance plan (e.g., HMO, PPO, etc.) you listed for your patient's secondary insurance. |
| Insurance Billed | This field shows the insurance company name, either manually entered or received in HL7, for each patient event. If no information has been provided, this field will be blank. |
| Event Insurance Number | |
| Event Insurance Type | |
| Roster Practice | If you provided this information in your roster, this is the practice information you listed for your patient at the time of the event. |
| Roster Provider | If you provided this information in your roster, this is the provider you listed for your patient at the time of the event. |
| Roster Provider NPI | If you provided the information in your roster, this is the NPI associated with the provider you provided at the time of the event. |
| Roster Program | If you provided this information in your roster, this is the program information you listed for your patient at the time of the event. |
| Other Practices / Practices | If the patient is on other rosters at the time of the event, the practices for the other roster(s) will be listed here. This column is just titled practices for Admitting facility exports. For Program/Practice Exports and Filter Exports, the column header is Other Practices, for the other exports the header is Practices |
| Other Providers / Providers | If the patient is on other rosters at the time of the event, the practices for the other roster(s) will be listed here. This column is just titled practices for Admitting facility exports. For Program/Practice Exports and Filter Exports, the column header is Other Providers, for the other exports the header is Providers |
| Other Programs / Programs | If the patient is on other rosters at the time of the event, the practices for the other roster(s) will be listed here. This column is just titled practices for Admitting facility exports. For Program/Practice Exports and Filter Exports, the column header is Other Programs, for the other exports the header is Providers |
| Facility Visit ID | This is the Visit ID, where provided, by the admitting facility |
| Account Number | This is the account number, where provided, by the admitting facility. |
| Admitted From | This field provides information on where the patient was before the encounter began. For example, it may show that the patient came from Court/Law Enforcement, Outpatient Services, or that they were admitted from General Hospital. This information is provided in HL7 data as well as manually from admitting sites. |
| Discharged Disposition | This field provides information on where the patient is being sent when the encounter ends. For example, it may say the patient was discharged to home or to a skilled nursing facility. This information is provided in HL7 data as well as manually from admitting sites. |
| Discharged Location | This field provides the specific location where a patient is being sent. For example, if a patient is being sent home this field would specify if it's the patient's home or a caregiver's home. If the patient is being sent to a hospital - unanticipated it may show the name of the hospital. Admitting sites provide this data manually when discharging patients. |
| MLOA Disposition | If the patient has started a Medical Leave of Absence (MLOA), if provided, the disposition from the sending facility will be provided in this field. |
| MLOA Location | If the patient has started a Medical Leave of Absence (MLOA), if provided, the location of the MLOA from the Sending facility will be provided in this field. |
| Admit Care Coordinator | This is the care coordinator your organization has assigned to coordinate this patient's admission if |
| Discharge Care Coordinator | This is the care coordinator your organization has assigned to coordinate this patient's discharge. |
| Ping Active | This indicates whether this event is the most recent event, or Ping, for this patient. Y means that this is the most recent Ping for this patient. N indicates that there is a more recent Ping for the patient. |
| Status Active | |
| Entry Delay | This count (in days) shows if a facility provided this information more than 1 day after the event occurred. For example, if an event occurred on January 1st but the facility entered the data on January 5th, the entry delay would be 4 days. |
| Ping Resolution Status | This field indicates if the Ping is currently open or has been resolved by your team. If a Ping was not acted on and is no longer the active Ping, this field will be blank. If a Ping was automatically resolved after 30-days of inaction, this field will be system resolved. Possible fields: contacted patient, contacted this facility, scheduled follow-up visit, other, no action needed, and system resolved. Multiple items can be provided in a comma-separated list. Other can contain a free text entry after it with what the user has entered as the other value. |
| Ping Resolution Date | The date the Ping was resolved. |
| Ping Resolution Time | The time the Ping was resolved, in Eastern Time Zone (GMT -5). |
| Ping Resolution Username | The username of the person who resolved the Ping. For Bamboo-resolved Pings, this will be completed by support@bamboohealth.com |
| Visit Duration | This field shows the duration of a patient's encounter. If the encounter Is still open (i.e., the patient has not been discharged), this gives the number of days the patient has been at the facility at the time of export. This value is not calculated if there is no discharge event and the encounter has been manually closed by PatientPing. In these cases, this field will be populated with ‘none provided’. |
| Length of Stay | This field shows a patient's Length of Stay, in days. This often matches the patient's Visit Duration. An exception is the case of a Medical Leave of Absence, where the SNF LOS would not include the days the patient was at another facility This value is not calculated if there is no discharge event and the encounter has been manually closed by PatientPing. In these cases, this field will be populated with ‘none provided’. |
| 3DW | 3DW stands for a 3-day waiver. This column indicates if the SNF encounter was admitted as part of the 3-day waiver program for Medicare patients. Y means the patient was admitted under a 3-day rule waiver. N means this patient was not admitted under a 3-day rule waiver. NA means this was not a 3DW eligible encounter. |
| CCD | If CCDs are not available in your area, this column will not be included. This field indicates if a CCD is available for this encounter. Y means that there is a CCD document available. |
| Attending Provider NPI | This is the NPI for the attending provider, where a value is provided. |
| Attending Provider Last Name | The Last Name of the Attending Physician, if available, for the patient's encounter. |
| Attending Provider First Name | The First Name of the Attending Physician, if available, for the patient's encounter. |
| Active Roster | As a user, you are able to export the Pings you received even if a patient is no longer on your roster. This field indicates if the patient is currently on your roster. |
| Primary Diagnosis Description | This field includes the primary diagnosis (in plain English) for the patient's encounter, if available, such as Cholera due to Vibrio cholerae 01, biovar eltor |
| Primary Diagnosis Code | This field will include the primary diagnosis code (ICD-10 Full Code) for the patient's encounter, if available, such as A001. ICD10 codes will not have the decimal point after the 3 rd characters. |
| Diagnosis Category | This field includes the primary diagnosis category (Letter followed by 2 numbers) for the primary diagnosis, if available, used such as A00 |
| Subsequent Diagnosis Codes | If there are more than 1 diagnosis codes provided, the additional ICD10 diagnosis codes will be provided here in a comma separated list. ICD10 codes will not have the decimal point after the 3 rd characters. |
| High Utilizer Flag | The High Utilizer Flag will be indicated when you receive for a patient who has presented to the Emergency Department 3 or more times within the last 60 days. When a patient has had a 60-day time span with less than 3 Emergency Department encounters, the Flag will be removed from their Profile, Card and no longer appear next to their Pings. If the patient had this flag at the time of the event it will be indicated here as a Y, otherwise, it will be N |
| Readmission Risk Flag | The Bamboo Health Readmission Risk Flag identifies patients who may be at risk for 30-Day All-Cause hospital readmission due to a prior, recent inpatient hospital stay. This Flag will appear on emergency department and observation Pings for patients who have been discharged from an inpatient hospital stay within the last 30 days. The Flag will be removed when it has been more than 30 days since the patient's hospital discharge and if the patient is admitted to an inpatient setting at the hospital. If the patient had this flag at the time of the event it will be indicated here as a Y, otherwise, it will be N |
| Recent SNF Stay Flag | The Recent SNF Stay Flag appears on hospital Pings for patients who were discharged from your facility within the last 30 days. For a patient to be eligible, they must have:
|
| Recent Inpatient Stay Flag | Recent Inpatient Stay Flag applies to any patient currently an inpatient at a PatientPing hospital who's also had a prior inpatient stay within the preceding 30 days. This addition will build on our readmission risk flag, which highlights those patients currently in the ED or under observation who've also been admitted in the prior 30 days. If the patient had this flag at the time of the event it will be indicated here as a Y, otherwise, it will be N |
| Unit/Floor | Unit/Floor relates to the patient location at the time of the event. This information is provided only to admitting facilities and only shows the information your system has sent to Bamboo Health. This column is not shown if the organization is not an admitting facility. |
| Room/Bed | Room/Bed relates to the patient location at the time of the event. This information is provided only to admitting facilities and only shows the information your system has sent to Bamboo Health. This column is not shown if the organization is not an admitting facility. |
| COVID-19 Flags | COVID-19 flags apply to any patient that has recent encounter diagnosis information associated with COVID-19. You can find more information related to COVID-19 criteria here. |