Table Detail Report

SN_NOMEN_ST



Column Section Relationship Section Top of Page


Table-level Detail

Description: SN_NOMEN_ST
Definition: Table will store Nomenclature's documented at the "case" and "procedure" level
Table Type: ACTIVITY





Column Detail - SN_NOMEN_ST


Column Name Type Null? Definition
ACTUAL_IND DOUBLE N Indicates whether this row holds scheduled data (0) or documented data (1)
DIAGNOSIS_DISPLAY VARCHAR(255) N Holds the nomenclature string if NOMENCLATURE_ID is supplied, otherwise, holds the free text user entered for the diagnosis
DIAGNOSIS_IDENTIFIER VARCHAR(50) N Holds the nomenclature identifier if NOMENCLATURE_ID is supplied, otherwise, is empty
NOMENCLATURE_ID DOUBLE N The nomenclature(s) value when the case was finalized
NOMENCLATURE_SEQ DOUBLE N The order the nomenclature(s) were listed when the case was finalized
POSTOP_IND DOUBLE N Indicates whether this nomenclature is PreOp (0), or PostOp (1)
SN_NOMEN_ST_ID DOUBLE N PRIMARY KEY
SURG_CASE_ID DOUBLE N Foreign key to the SURGICAL_CASE table. This identifiers the surgical case containing nomenclature(s) at either the case level, procedure level or both.
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_NOMEN_ST


Child Column in SN_NOMEN_ST(FK) Parent Table Name Parent Column Name
Parents: NOMENCLATURE_ID NOMENCLATURE NOMENCLATURE_ID
SURG_CASE_ID SURGICAL_CASE SURG_CASE_ID


SN_PREFCARD_MPAGE_SNOOZE



Column Section Relationship Section Top of Page


Table-level Detail

Description: sn_pref_card_mpage_snooze
Definition: SurgiNet Preference Card MPage Snooze Table
Table Type: ACTIVITY





Column Detail - SN_PREFCARD_MPAGE_SNOOZE


Column Name Type Null? Definition
ACTION_FLAG DOUBLE N action snoozed: 0 - modify, 1 - add, 2 - remove
CREATE_DT_TM DATETIME Y date time user snoozed the action
EXPIRATION_DT_TM DATETIME Y date snooze expires
ITEM_ID DOUBLE N item being snoozed on prefcard by user
PREF_CARD_ID DOUBLE N prefcard having item snoozed by user
SN_PREFCARD_MPAGE_SNOOZE_ID DOUBLE N Unique generated number that identifies a single row on the table. 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.
USER_ID DOUBLE N user snoozing action on item on prefcard



Relationship Detail - SN_PREFCARD_MPAGE_SNOOZE


Child Column in SN_PREFCARD_MPAGE_SNOOZE(FK) Parent Table Name Parent Column Name
Parents: ITEM_ID ITEM_MASTER ITEM_ID
PREF_CARD_ID PREFERENCE_CARD PREF_CARD_ID
USER_ID PRSNL PERSON_ID


SN_PREFS



Column Section Top of Page


Table-level Detail

Description: SurgiNet Preferences
Definition: This tables contains system preferences for SurgiNet applications
Table Type: REFERENCE





Column Detail - SN_PREFS


Column Name Type Null? Definition
PARENT_ENTITY_ID DOUBLE N Parent Entity ID
PARENT_ENTITY_NAME VARCHAR(32) N Parent Entity Name
PREF_DOMAIN VARCHAR(60) Y Preference Domain
PREF_ID DOUBLE N Preference ID
PREF_NAME VARCHAR(60) N Preference Name
PREF_SECTION VARCHAR(60) Y Preference Section
PREF_VALUE_CD DOUBLE N Preference Value Code
PREF_VALUE_DT_TM DATETIME Y Preference Value Date/Time
PREF_VALUE_ID DOUBLE N Preference Value ID
PREF_VALUE_NAME VARCHAR(32) Y Preference Value Name
PREF_VALUE_NBR DOUBLE Y Preference Value Number
PREF_VALUE_STR VARCHAR(255) Y Preference Value String
REFERENCE_IND DOUBLE N Reference Indicator
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_PRIV



Column Section Relationship Section Top of Page


Table-level Detail

Description: SN PRIV
Definition: Contains all privileging information for SurgiNet applications.
Table Type: REFERENCE





Column Detail - SN_PRIV


Column Name Type Null? Definition
ACCESS_FLAG DOUBLE N Indicates the type of access to the specified application for a given person or position.
APPLICATION_NUMBER DOUBLE N The application that this privilege applies to.
CREATE_APPLCTX DOUBLE Y The application context number from the record info block.
CREATE_DT_TM DATETIME Y The date and time the row was initially inserted.
CREATE_PRSNL_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.
CREATE_TASK DOUBLE Y The registered (assigned) task number for the process that inserted or updated the row.
PARENT_ENTITY_ID DOUBLE N The primary key ID of the table in the PARENT_ENTITY_NAME that this privilege belongs to.
PARENT_ENTITY_NAME VARCHAR(32) Y The name of the table this privilege is associated with.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
POSITION_CD DOUBLE N The position code value that this privilege applies to.
PRIV_ID DOUBLE N The primary key ID for this 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_PRIV


Child Column in SN_PRIV(FK) Parent Table Name Parent Column Name
Parents: PERSON_ID PRSNL PERSON_ID


SN_PRIV_APP_REF



Column Section Top of Page


Table-level Detail

Description: Reference table holding applications for a given privilege type.
Definition: This table holds the applications that are available for building privileges of a specific type.
Table Type: REFERENCE





Column Detail - SN_PRIV_APP_REF


Column Name Type Null? Definition
ACCESS_FLAG DOUBLE N Indicates the type of access to the specified application for a given person or position.
APPLICATION_NUMBER DOUBLE N The number off of the APPLICATION table for an application that will be used for a privilege type.
PARENT_ENTITY_ID DOUBLE N The _id of the reference object in the table listed in PARENT_ENTITY_NAME that needs to have applications attached to it.
PARENT_ENTITY_NAME VARCHAR(32) N The name of the table that this privilege type refers to.
PRIV_APP_REF_ID DOUBLE N The primary key for this table.
PRIV_TYPE_NAME VARCHAR(32) N The name of the privilege type that these applications are available for. Typically, this is the name of another 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.