IP_DATA_STORE

Description: |
This table contains generic information related to a patient's inpatient stay, including data on patient education, notes, and other topics.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
INPATIENT_DATA_ID | 1 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | INPATIENT_DATA_ID | VARCHAR | No |
The unique ID of the inpatient data store record.
2 | TEMPLATE_ID | VARCHAR | No |
The unique ID of the flowsheet template.
3 | TEMPLATE_ID_DISPLAY_NAME | VARCHAR | No |
The display name associated with this template.
4 | DISCH_INST_HNO_ID | VARCHAR | No |
The HNO ID of the patient's discharge instructions, for discharge instructions created in version Epic Aug 2021 or prior. In version Epic Nov 2021 and later, the discharge instruction information that was previously stored in INP will now be stored in HNO for Note Type 18-Discharge Instructions, with information about instances where discharge instructions were reviewed, updated, or signed extracted in the Clarity table DISCH_INSTR_HISTORY.
5 | RECORD_STATUS_C_NAME | VARCHAR | No |
The current status of the Inpatient Data record: active or resolved.
May contain organization-specific values: No
Category Entries:
Active
Resolved
Deleted
6 | EPT_CSN | NUMERIC | No |
Link to Contact Serial Number in EPT for associated encounter.
7 | BRST_STAT_INST_TM | DATETIME (Local) | No |
Stores the last instant that Breastfeeding Status was saved.
8 | PAIN_EDU_INST_TM | DATETIME (Local) | No |
Stores the last instant the Pain Education was saved.
9 | HC_INSTANT_TM | DATETIME (Local) | No |
Stores the last instant that the Head Circumference was saved.
10 | PF_INSTANT_TM | DATETIME (Local) | No |
Stores the last instant that Peak Flow was saved.
11 | EXINGC_INSTANT_TM | DATETIME (Local) | No |
Stores the last instant that Exclude in Growth Charts information was saved.
12 | ALT_PRINT_INST_TM | DATETIME (Local) | No |
Stores the last instant OurPractice Advisory (OPA) alert information was saved.
13 | IP_NOTE_MOD_INST_TM | DATETIME (UTC) | No |
The time the Notes were last modified for this Inpatient Data record.
14 | UPDATE_DATE | DATETIME (Local) | No |
The date and time this row was last updated (the last time it was extracted or this column was backfilled).