AN_HSB_LINK_INFO
Description:
This table stores Anesthesia episode-level information.

Primary Key
Column Name Ordinal Position
SUMMARY_BLOCK_ID 1

Column Information
Name Type Discontinued?
1 SUMMARY_BLOCK_ID NUMERIC No
The unique ID of the Episode (HSB) record for this row. Episodes store information including the start and end dates, episode status and type, and any contacts associated with the episode.
2 ANES_EPT_CSN_LINK NUMERIC No
Patient encounter linked to this episode, if one exists (true for surgical or scheduled reasons, false for order or other reasons).
3 AN_UNLINKED_FLAG_YN VARCHAR No
Flag indicating that episode is not linked to a reason.
May contain organization-specific values: No
Category Entries:
No
Yes
4 ANES_PROC_ID NUMERIC No
Stores the procedure that corresponds to this anesthesia episode.
5 ANES_PROC_DATE DATETIME No
Stores the date for the procedure of the anesthesia episode.
6 ANES_PRE_OP_DIAG_ID NUMERIC No
The pre-op diagnosis for this anesthesia episode.
7 ANES_PROC_TIME DATETIME (Local) No
Stores the time when the procedure associated with the anesthesia episode was performed.
8 ANES_PROC_CMT VARCHAR No
Comment for anesthesia procedure.
9 ANES_PREOP_COMP_YN VARCHAR No
This item indicates whether Pre-op documentation has been completed for Anesthesia.
The category values for this column were already listed for column: AN_UNLINKED_FLAG_YN
10 ANES_INTRAOP_COM_YN VARCHAR No
This item indicates whether Intra-op documentation has been completed for Anesthesia.
The category values for this column were already listed for column: AN_UNLINKED_FLAG_YN
11 ANES_PACU_COMP_YN VARCHAR No
This item indicates whether PACU documentation has been completed for Anesthesia.
The category values for this column were already listed for column: AN_UNLINKED_FLAG_YN
12 ANES_POSTOP_COMP_YN VARCHAR No
This item indicates whether Post-op documentation has been completed for Anesthesia.
The category values for this column were already listed for column: AN_UNLINKED_FLAG_YN
13 ANES_DOC_COMP_YN VARCHAR No
This item indicates whether or not the anesthetic record is complete.
The category values for this column were already listed for column: AN_UNLINKED_FLAG_YN
14 AN_DOC_COMP_INSTANT DATETIME (Local) No
The instant that all documentation for an anesthesia episode was marked as complete.
15 AN_BATCH_CLS_DON_YN VARCHAR No
This item indicates whether the batch job that closes Anesthesia records has run on this record. It will be set to No with the Anesthesia record is marked completed and Yes when all the constituent contacts are closed.
The category values for this column were already listed for column: AN_UNLINKED_FLAG_YN
16 AN_RESP_PROV_ID VARCHAR No
Stores the overall responsible anesthesiologist for the anesthesia record.
17 AN_DATE DATETIME No
Stores the anesthesia procedure date for the anesthesia record.
18 AN_TIME DATETIME (Local) No
Stores the time when the procedure associated with the anesthesia record was performed.
19 AN_START_DATETIME DATETIME (Local) No
Stores the instant at which anesthesia started for the anesthesia record.
20 AN_STOP_DATETIME DATETIME (Local) No
Stores the instant at which anesthesia stopped for the anesthesia record.
21 NAME VARCHAR No
The name of the anesthesia episode.
22 AN_52_ENC_CSN_ID NUMERIC No
Stores the unique contact serial number for the 52-Anesthesia patient encounter associated with the anesthesia record. This number is unique across all patient encounters in any given system.
23 AN_RECORD_DATE DATETIME No
The date for this anesthesia record.
24 AN_BILLING_CSN_ID NUMERIC No
The unique contact serial number for the Billing Encounter. This contains all the billing information needed to drop charges.
25 PRIMARY_LOG_ENC_CSN NUMERIC No
Identifies the anesthesia record's primary log encounter contact serial number (CSN).
26 PRIMARY_PRC_ENC_CSN NUMERIC No
Identifies the primary procedure's encounter contact serial number (CSN).
27 AN_PRIMARY_NOTE_ID VARCHAR No
Indicates which note record (HNO) to treat as the anesthesia preop note.