DISCRETE_PAT_INSTR_EDIT
Description:
This table contains contact specific discrete patient instructions information such as the entering user, entry date, and linked medication.

Primary Key
Column Name Ordinal Position
DISCRETE_PAT_INSTR_ID 1
CONTACT_DATE_REAL 2

Column Information
Name Type Discontinued?
1 DISCRETE_PAT_INSTR_ID NUMERIC No
The unique identifier (.1 item) for the instructions name record.
2 CONTACT_DATE_REAL FLOAT No
A unique contact date in decimal format. The integer portion of the number indicates the date of contact. The digits after the decimal distinguish different contacts on the same date and are unique for each contact on that date. For example, .00 is the first/only contact, .01 is the second contact, etc.
3 CONTACT_DATE DATETIME No
The date of this contact in calendar format.
4 CONTACT_SERIAL_NUM NUMERIC No
The unique contact serial number (CSN) of the discrete patient instructions (DPI) contact. If you use IntraConnect, this is the Unique Contact Identifier (UCI).
5 CONTACT_NUM INTEGER No
Stores the contact number
6 DISPLAY_NAME VARCHAR No
Display name of the DPI record.
7 PAT_CSN NUMERIC No
The contact serial number (CSN) of the patient contact on which these instructions were last edited.
8 ENTERING_USER_ID VARCHAR No
Stores the user who last edited this record
9 ENTERING_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
10 LAST_EDIT_UTC_DTTM DATETIME (UTC) No
Stores the last instant the instructions were edited.
11 INSTRUCTIONS_END_UTC_DTTM DATETIME (UTC) No
Stores the date the instructions are no longer valid
12 DISCRETE_PAT_INSTR_SRC_C_NAME VARCHAR No
The source of these instructions
May contain organization-specific values: No
Category Entries:
Physician Entered
13 MEDICATION_ID_MEDICATION_NAME VARCHAR No
The name of this medication record.
14 INSTANT_OF_ENTRY_DTTM DATETIME (Attached) No
Stores the instant of entry when a record is edited
15 SHOW_CARB_RANGES_YN VARCHAR No
Indicates if carbs should be printed with a range (ex "10-19") or not (ex "10") on the AVS.
May contain organization-specific values: No
Category Entries:
No
Yes
16 DOSE_ROUNDING_C_NAME VARCHAR No
Indicates if the AVS insulin injection tables should round Down (first row is 0 units) or round Up (first row is one unit increment).
May contain organization-specific values: No
Category Entries:
Up
Down
17 DOSING_METHOD_C_NAME VARCHAR No
Indicates the dosing method used on the insulin injection tables.
May contain organization-specific values: No
Category Entries:
Carb Ratio
Fixed Dose
Carb Servings
18 MAX_BLOOD_GLUCOSE NUMERIC No
Maximum blood glucose, in mg/dL, to display on the AVS insulin injection tables.
19 MAX_CARBOHYDRATES NUMERIC No
Maximum carbohydrates to display on the AVS insulin injection tables.
20 GLUC_UNIT_INCREMENT NUMERIC No
Indicates the number of units to increment each row of the AVS insulin injection tables by. Enter a value of 0.5 to get half unit increment behavior.
21 HYPO_THRESHOLD NUMERIC No
Hypoglycemia threshold, in mg/dL, to display as the lower bound for the first row on the AVS insulin injection tables.