Table Detail Report

SN_DIAGNOSTIC_REL



Column Section Relationship Section Top of Page


Table-level Detail

Description: SurgiNet Diagnostic Relationship table
Definition: SurgiNet Diagnostic Relationship
Table Type: REFERENCE





Column Detail - SN_DIAGNOSTIC_REL


Column Name Type Null? Definition
DIAGNOSTIC_GROUP_ID DOUBLE N The Diagnostic Group IdColumn
DIAGNOSTIC_ID DOUBLE N Diagnostic IDColumn
DIAGNOSTIC_REL_ID DOUBLE N The Unique Id on the 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_DIAGNOSTIC_REL


Child Column in SN_DIAGNOSTIC_REL(FK) Parent Table Name Parent Column Name
Parents: DIAGNOSTIC_ID SN_DIAGNOSTIC DIAGNOSTIC_ID
DIAGNOSTIC_GROUP_ID SN_DIAGNOSTIC_GROUP DIAGNOSTIC_GROUP_ID


SN_DOC_REF



Column Section Top of Page


Table-level Detail

Description: SurgiNet Document Reference
Definition: SurgiNet Document Reference Table
Table Type: REFERENCE





Column Detail - SN_DOC_REF


Column Name Type Null? Definition
AREA_CD DOUBLE N The Area the document is used for.
DOC_REF_ID DOUBLE N The Unique ID for the Table
DOC_TYPE_CD DOUBLE N The Document type for the document
STAGE_CD DOUBLE N The Stage in which the document is used
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.


SN_EVENT_CODE_PREFS



Column Section Top of Page


Table-level Detail

Description: SN_EVENT_CODE_PREFS
Definition: Stores event codes to be displayed in Case Overview
Table Type: REFERENCE





Column Detail - SN_EVENT_CODE_PREFS


Column Name Type Null? Definition
DOC_TYPE_CD DOUBLE N The document type for which a list of event codes will display
EVENT_CD DOUBLE N For this document type, the event codes to display in case overview
EVENT_CD_LBL VARCHAR(99) Y The user-defined label that will display to the left of the result for the event code.
EVENT_CD_SEQ DOUBLE N For this document type, the order the event codes will display in case overview
SN_EVENT_CODE_PREFS_ID DOUBLE N Primary key
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.


SN_IMPLANT_LOG_ST



Column Section Relationship Section Top of Page


Table-level Detail

Description: SurgiNet Implant Log Summary Table
Definition: Table used to store implant log data to be used in Surgery Management Reporting's Implant Log Analysis view.
Table Type: ACTIVITY





Column Detail - SN_IMPLANT_LOG_ST


Column Name Type Null? Definition
BATCH_NUMBER VARCHAR(50) Y Indicates the implants Batch Number, as entered on the Prosthetic Devices form in PDM
CATALOG_NUMBER VARCHAR(50) Y Indicates the implant's Catalog Number, as entered on the Prosthetic Devices form in PDM
CULTURED_IND DOUBLE Y Indicates whether this impalnt has been cultured, as entered in the Prosthetic Devices form in PDM
DISPLAY_SEQ DOUBLE N Indicates the sequence in which this implant entry was made in the Prosthetic Devices form in PDM
DOC_TYPE_CD DOUBLE N Indicates the document type associated with this PDM entry
ECRI_DEVICE_CODE VARCHAR(50) Y Indicates the implant's ECRI Device Code, as entered in the Prosthetic Devices form in PDM
EXP_DATE DATETIME Y Indicates the implant's expiration date, as entered in the Prosthetic Devices form in PDM
FREE_TEXT_ITEM_DESC VARCHAR(200) Y The free-text description associated with this implant item. This column is only populated if a free-text inventory item was entered in the inventory control in the Prosthetic Devices form in Perioperative Document Manager.
IMPLANTED_BY_ID DOUBLE N The person responsible for implanting this device
IMPLANT_ACTION_CD DOUBLE N Indicates whether the implant action value is "Implant", "Explant" or "Not-Implanted".
IMPLANT_LOG_ST_ID DOUBLE N A unique sequence number used as the primary key to the table
IMPLANT_PROCESSED_FLAG DOUBLE N Indicates whether data has been copied from this table to the IMPLANT_HISTORY table (1) or whether data has not yet been copied (0)
IMPLANT_SITE VARCHAR(100) Y The site where this device was implanted
IMPLANT_SIZE VARCHAR(50) Y The size of this prosthetic device
ITEM_ID DOUBLE N The item associated with this prosthetic device
LOT_NUMBER VARCHAR(50) Y The lot number associated with this prosthetic device
MANUFACTURER VARCHAR(100) Y The manufacturer associated with this prosthetic device
MANUF_ECRI_CODE VARCHAR(50) Y The manufacturer's ECRI Code for this prosthetic device
MODEL_NUMBER VARCHAR(50) Y The model number associated with this prosthetic device
OTHER_IDENTIFIER VARCHAR(50) Y A miscellaneous identifier associated with this prosthetic device
PERIOP_DOC_ID DOUBLE N A reference to the perioperative document associated with this prosthetic device entry in PDM
QUANTITY VARCHAR(50) Y The quantity associated with this prosthetic device
SEGMENT_HEADER_ID DOUBLE N A reference to the segment header associated with this Prosthetic Device entry in PDM
SERIAL_NUMBER VARCHAR(50) Y The serial number associated with this prosthetic device
SURG_CASE_ID DOUBLE N A reference to the surgical_case table, identifying the surgical case associated with this prosthetic device entry in PDM
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_IMPLANT_LOG_ST


Child Column in SN_IMPLANT_LOG_ST(FK) Parent Table Name Parent Column Name
Parents: PERIOP_DOC_ID PERIOPERATIVE_DOCUMENT PERIOP_DOC_ID
SEGMENT_HEADER_ID SEGMENT_HEADER SEGMENT_HEADER_ID
SURG_CASE_ID SURGICAL_CASE SURG_CASE_ID


SN_NAME_VALUE_PREFS



Column Section Top of Page


Table-level Detail

Description: SurgiNet Name Value Preferences
Definition: SurgiNet Name Value Preferences Table
Table Type: REFERENCE





Column Detail - SN_NAME_VALUE_PREFS


Column Name Type Null? Definition
NAME_VALUE_PREFS_ID DOUBLE N Unique ID for the Table
PARENT_ENTITY_ID DOUBLE N The ID from the table specified in PAREN_ENTITY_NAME
PARENT_ENTITY_NAME VARCHAR(32) N The Table that this row is a child of
PREF_NAME VARCHAR(32) N The Preference NameColumn
PREF_VALUE VARCHAR(255) Y The Prefernece Value
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.