IP_LDA_NOADDSINGLE

Description: |
This table stores LDA information for a patient. A record is created in LDA for insertion of every line, drain, airway, or wound for a patient, as well as entering a trip into a patient's travel history. The no-add information for this LDA is stored in the table.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
IP_LDA_ID | 1 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | IP_LDA_ID | VARCHAR | No |
The internal ID of the Lines/Drains/Airways (LDA) record.
2 | PAT_ID | VARCHAR | No |
This item stores the ID of the patient to which this line record was added.
3 | PAT_ENC_CSN_ID | NUMERIC | No |
This item stores the contact serial number of the encounter in which the record was created.
4 | FLO_MEAS_ID | VARCHAR | No |
This item stores the Flowsheet ID that defines the structure of this record. It is the flowsheet group that is used to define the set of rows for the Line/Drain/Airway (LDA).
5 | FLO_MEAS_ID_DISP_NAME | VARCHAR | No |
The display name given to the flowsheet group/row.
6 | REMOVAL_INSTANT | DATETIME (Local) | No |
This item stores the instant at which the line/drain was removed. If the line or drain has not been removed, it will store 11/19/2157 17:46:39 as the end instant.
7 | PLACEMENT_INSTANT | DATETIME (Local) | No |
This item stores the placement instant of the record.
8 | FSD_ID | VARCHAR | No |
This item stores the flowsheet data (FSD) ID of the record that has information about the properties of the line/drain/airway (LDA).
9 | DESCRIPTION | VARCHAR | No |
This item stores the name/description of the line/drain.
10 | PROPERTIES_DISPLAY | VARCHAR | No |
Stores the properties display string to be displayed in Doc Flowsheets and Reports.
11 | SITE | VARCHAR | No |
This item stores site information for the inserted Line/Drain/Airway.
12 | LDA_GROUP_CDR | FLOAT | No |
This column stores the contact date real of the Line/Drain/Airway (LDA) Group contact that created this LDA. This column is stored in Epic's datetime (DTE) format.
13 | LINKED_SUPPLY_ID | VARCHAR | No |
The unique ID of the supply record that is associated with this Line/Drain/Airway.
14 | LINKED_SUPPLY_ID_SUPPLY_NAME | VARCHAR | No |
The name of the inventory item.
15 | REMOVAL_DTTM | DATETIME (Local) | No |
This item stores the date and time at which the line/drain was removed. Unlike REMOVAL_INSTANT, if the line or drain has not been removed, it will store null.
16 | TRIP_REGION_ID | NUMERIC | No |
Represents where the patient traveled for this trip
17 | TRIP_REGION_ID_GEO_REGION_NAME | VARCHAR | No |
The record name for the geographical region record.
18 | TRIP_BEGIN_DATE | DATETIME | No |
Represents when a patient began their trip
19 | TRIP_END_DATE | DATETIME | No |
Represents the end of this patient trip
20 | TRIP_DATE_APPROX_C_NAME | VARCHAR | No |
Whether the dates for this trip are exact or approximate
May contain organization-specific values: No
Category Entries:
Specified Dates
Start Date Defaulted
End Date Defaulted
Start and End Dates Defaulted
21 | TRIP_PAT_ENTERED_YN | VARCHAR | No |
Whether some of the details of this trip were provided by patient directly
May contain organization-specific values: No
Category Entries:
No
Yes
22 | AVATAR_PROPERTY_OVERRIDE_YN | VARCHAR | No |
Specifies whether the current region for the LDA was determined by a user override and may not have been calculated from the property values.
The category values for this column were already listed for column: TRIP_PAT_ENTERED_YN
23 | AVATAR_RECORD_ID | NUMERIC | No |
The unique ID of the Anatomy record associated with the region in which this Line/Drain/Airway (LDA) is located on the LDA Avatar activity.
24 | AVATAR_RECORD_ID_RECORD_NAME | VARCHAR | No |
Stores record name (.2)
25 | AVATAR_CALCULATED_RECORD_ID | NUMERIC | No |
Used to store the current region (VEL) record calculated from the Lines/Drains/Airways (LDA) properties and the Avatar LDA Mapping Configuration.
26 | AVATAR_CALCULATED_RECORD_ID_RECORD_NAME | VARCHAR | No |
Stores record name (.2)
27 | RECORDED_DTTM | DATETIME (Local) | No |
The recorded time used in IP_FLWSHT_MEAS for storing the property data for this LDA.