OR_LNLG_COUNTS
Description:
This table contains the Counts information for the Surgical Log (ORL).

Primary Key
Column Name Ordinal Position
RECORD_ID 1

Column Information
Name Type Discontinued?
1 RECORD_ID VARCHAR No
The unique ID of the Line (ORM) record
2 COUNT_XRAY_YN VARCHAR No
Indicates whether or not an X-ray was performed for this count record. Y indicates the X-ray was used, while N indicates that the X-ray was not used. This item may be set in the event of an incorrect count, therefore it could be null, usually indicating a correct count.
May contain organization-specific values: No
Category Entries:
Yes
No
3 COUNT_MD_NTFD_YN VARCHAR No
Indicates whether or not the physician was notified for this count record. Y indicates the physician was notified, while N indicates that the physician was not notified. This item may be set in the event of an incorrect count, therefore it could be null, usually indicating a correct count.
The category values for this column were already listed for column: COUNT_XRAY_YN
4 COUNT_INST_DTTM DATETIME (Local) No
The instant the count was taken.
5 COUNT_PERFORMD_DTTM DATETIME (Local) No
This item stores the time when a count is performed.
6 COUNT_MD_NOTIFIED_DTTM DATETIME (UTC) No
This column stores when the physician was notified during an incorrect count.
7 COUNT_XRAY_TAKEN_DTTM DATETIME (UTC) No
This column stores when the X-ray was taken during a count.
8 COUNT_ALL_CLEAR_DTTM DATETIME (UTC) No
This column stores the time when all clear was called as part of a count.
9 COUNTS_ITEM1_C_NAME VARCHAR No
Stores the item being counted in the current count. This is a category list value.
May contain organization-specific values: Yes
Category Entries:
Other
10 COUNTS_ITEM1_FREE_TEXT VARCHAR No
Stores the item being counted in the current count. This is intended to be used if a user selects "other" as the category list value.
11 COUNTS_ITEM1_TOTAL INTEGER No
The total of this type of item that was counted.
12 COUNTS_ITEM2_C_NAME VARCHAR No
Stores the item being counted in the current count. This is a category list value.
The category values for this column were already listed for column: COUNTS_ITEM1_C_NAME
13 COUNTS_ITEM2_FREE_TEXT VARCHAR No
Stores the item being counted in the current count. This is intended to be used if a user selects "other" as the category list value.
14 COUNTS_ITEM2_TOTAL INTEGER No
The total of this type of item that was counted.
15 COUNTS_ITEM3_C_NAME VARCHAR No
Stores the item being counted in the current count. This is a category list value.
The category values for this column were already listed for column: COUNTS_ITEM1_C_NAME
16 COUNTS_ITEM3_FREE_TEXT VARCHAR No
Stores the item being counted in the current count. This is intended to be used if a user selects "other" as the category list value.
17 COUNTS_ITEM3_TOTAL INTEGER No
The total of this type of item that was counted.
18 COUNTS_ITEM4_C_NAME VARCHAR No
Stores the item being counted in the current count. This is a category list value.
The category values for this column were already listed for column: COUNTS_ITEM1_C_NAME
19 COUNTS_ITEM4_FREE_TEXT VARCHAR No
Stores the item being counted in the current count. This is intended to be used if a user selects "other" as the category list value.
20 COUNTS_ITEM4_TOTAL INTEGER No
The total of this type of item that was counted.
21 COUNTS_ITEM5_C_NAME VARCHAR No
Stores the item being counted in the current count. This is a category list value.
The category values for this column were already listed for column: COUNTS_ITEM1_C_NAME
22 COUNTS_ITEM5_FREE_TEXT VARCHAR No
Stores the item being counted in the current count. This is intended to be used if a user selects "other" as the category list value.
23 COUNTS_ITEM5_TOTAL INTEGER No
The total of this type of item that was counted.