Table Detail Report

SN_CASE_LONG_TEXT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Surginet Case Long Text
Definition: A generic table to store blob text associated to a surgical case.
Table Type: ACTIVITY





Column Detail - SN_CASE_LONG_TEXT


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
LONG_TEXT_ID DOUBLE N This is the foreign key to the long_text table
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
SN_CASE_LONG_TEXT_ID DOUBLE N The primary key for this table
SN_TEXT_TYPE_CD DOUBLE N This is the type of text stored in the long text table (i.e., Verbal Orders)
SURG_CASE_ID DOUBLE N This is a foreign key to the SURGICAL_CASE table
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - SN_CASE_LONG_TEXT


Child Column in SN_CASE_LONG_TEXT(FK) Parent Table Name Parent Column Name
Parents: LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
PERSON_ID PRSNL PERSON_ID
SURG_CASE_ID SURGICAL_CASE SURG_CASE_ID


SN_CASE_TRACKING



Column Section Relationship Section Top of Page


Table-level Detail

Description: Surginet Case Tracking
Definition: Surginet Case Tracking Table
Table Type: ACTIVITY





Column Detail - SN_CASE_TRACKING


Column Name Type Null? Definition
ANTICIPATED_DURATION DOUBLE Y The anticipated duration of the surgical case. Defaults to the scheduled duration, but may be over-ridden by the user. This field can be null.
ANTICIPATED_OP_LOC_CD DOUBLE N Anticipated Operating room location code
ANTICIPATED_START_DT_TM DATETIME Y The anticipated start time of the surgical case. Defaults to the scheduled start time, but may be over-ridden by the user. When the actual start time is documented, this field is updated with that value and may no longer be modified. This field can be null.
SN_CASE_TRACKING_ID DOUBLE N Unique identifier.
SURG_CASE_ID DOUBLE N Foreign key to the SURGICAL_CASE table.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - SN_CASE_TRACKING


Child Column in SN_CASE_TRACKING(FK) Parent Table Name Parent Column Name
Parents: SURG_CASE_ID SURGICAL_CASE SURG_CASE_ID


SN_CE_EXTRACT_ST



Column Section Relationship Section Top of Page


Table-level Detail

Description: SurgiNet Clinical Event Extract Summary Table
Definition: This table is used to store activity data extracted from the clinical event tables. It is used in Surgery Mgmt Reporting OMF views
Table Type: ACTIVITY





Column Detail - SN_CE_EXTRACT_ST


Column Name Type Null? Definition
EVENT_ID DOUBLE N The event_id from the clinical_event table associated with this entry in PDM
PARENT_ENTITY_ID DOUBLE N The parent entity id for this clinical event entry
PARENT_ENTITY_NAME VARCHAR(50) Y The parent entity name for this clinical event entry
PERIOP_DOC_ID DOUBLE N A reference (foreign key) to the perioperative document table, indicating the document assoc. with this clinical event entry
RESULT_CD DOUBLE Y The coded result associated with this clinical event (used when an input field is validated from a codeset)
RESULT_DT_TM DATETIME Y The result associated with this clinical event -- used when the result type is Date/Time
RESULT_FREE_TEXT VARCHAR(255) Y The result associated with this clinical event -- used when the result type is free text
RESULT_ID DOUBLE Y The result associated with this clinical event -- used when the result type is Nomenclature, Item, Provider, or Prsnl Group
RESULT_PARENT_TABLE VARCHAR(50) Y The result parent table associated with this clinical event
RESULT_TYPE_MEANING CHAR(12) Y The CDF meaning for the result type associated with this clinical event
SN_CE_EXTRACT_ST_ID DOUBLE N A unique identifier (primary key) associated with this clinical event
TASK_ASSAY_CD DOUBLE N The task assay associated with this clinical event
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - SN_CE_EXTRACT_ST


Child Column in SN_CE_EXTRACT_ST(FK) Parent Table Name Parent Column Name
Parents: PERIOP_DOC_ID PERIOPERATIVE_DOCUMENT PERIOP_DOC_ID


SN_CHARGE_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: SurgiNet Charge Detail
Definition: SurgiNet Charge Detail Table
Table Type: ACTIVITY





Column Detail - SN_CHARGE_DETAIL


Column Name Type Null? Definition
CEA_TYPE_CD DOUBLE N The charge event activity type associated with the transaction.
CHARGE_DETAIL_ID DOUBLE N The primary key, uniquely identifying a charge detail.
CHARGE_HEADER_ID DOUBLE N The charge header associated with this charge detail.
CHARGE_TYPE_CD DOUBLE N The charge type associated with the transaction.
EXT_ITEM_EVENT_ID DOUBLE N External Item Event ID.
EXT_ITEM_EVENT_NAME VARCHAR(32) Y Contains the table name which primary key is stored in ext_item_event_id field.
EXT_ITEM_REFERENCE_ID DOUBLE N External Item Reference ID.
EXT_ITEM_REFERENCE_NAME VARCHAR(32) Y Contains the table name which primary key is stored in ext_item_reference_id field.
EXT_MASTER_EVENT_ID DOUBLE N External Master Event ID.
EXT_MASTER_EVENT_NAME VARCHAR(32) Y Contains the table name which primary key is stored in ext_master_event_id field.
EXT_PARENT_EVENT_ID DOUBLE N External Parent Event ID.
EXT_PARENT_EVENT_NAME VARCHAR(32) Y Contains the table name which primary key is stored in ext_parent_event_id field.
EXT_PARENT_REFERENCE_ID DOUBLE N External Parent Reference ID.
EXT_PARENT_REFERENCE_NAME VARCHAR(32) Y Contains the table name which primary key is stored in ext_parent_reference_id field.
QTY DOUBLE N The quantity of the transaction.
RECHARGED_IND DOUBLE N Indicates the recharged status of the transaction (0 = False, 1 = True).
RECHARGE_DT_TM DATETIME Y The date and time the transaction was recharged.
RECHARGE_PRSNL_ID DOUBLE N The personnel who requested to recharge the transaction.
RESULT DOUBLE N The result value of the transaction.
ROOT_DETAIL_ID DOUBLE N The parent ID of the transaction.
TOTAL_CHARGED_QTY DOUBLE N Total charged quantity.
TOTAL_CHARGED_RESULT DOUBLE N Total charged result value.
TRANS_DESC VARCHAR(250) Y Description of the transaction.
TRANS_DT_TM DATETIME Y The date and time of the transaction.
TRANS_TYPE_MEAN VARCHAR(12) Y The type of transaction.
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - SN_CHARGE_DETAIL


Child Column in SN_CHARGE_DETAIL(FK) Parent Table Name Parent Column Name
Parents: RECHARGE_PRSNL_ID PRSNL PERSON_ID
CHARGE_HEADER_ID SN_CHARGE_HEADER CHARGE_HEADER_ID


SN_CHARGE_HEADER



Column Section Relationship Section Top of Page


Table-level Detail

Description: SurgiNet Charge Header
Definition: SurgiNet Charge Header Table
Table Type: ACTIVITY





Column Detail - SN_CHARGE_HEADER


Column Name Type Null? Definition
ANESTH_TYPE_CD DOUBLE N The primary anesthesia type associated with the surgical case.
CASE_LEVEL_CD DOUBLE N The case level associated with the surgical case.
CHARGE_HEADER_ID DOUBLE N The primary key, uniquely identifying a charge header.
DOC_TYPE_CD DOUBLE N The document type associated with the surgical case.
PRIORITY_CD DOUBLE N Surgical cases need to be able to have their charges flexed by the priority of a case. If a case is an emergency case that is not planned for the charges will probably be higher due to the costs associated with shuffling all other work around and potentially bringing in additional staff to accommodate the case.
SERVICE_DT_TM DATETIME Y The date and time of either the start of the surgery or the patient in- room.
SURGEON_PRSNL_ID DOUBLE N The primary surgeon associated with this charge header.
SURG_CASE_ID DOUBLE N The surgical case associated with this charge header.
SURG_OP_LOC_CD DOUBLE N The OR number associated with the surgical case.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - SN_CHARGE_HEADER


Child Column in SN_CHARGE_HEADER(FK) Parent Table Name Parent Column Name
Parents: SURG_CASE_ID SURGICAL_CASE SURG_CASE_ID




Parent Column in SN_CHARGE_HEADER (PK) Child Table Name Child Column Name
Children: CHARGE_HEADER_ID SN_CHARGE_DETAIL CHARGE_HEADER_ID