Table Detail Report

SN_SURG_CASE_PROC_DOC



Column Section Relationship Section Top of Page


Table-level Detail

Description: SN SURG CASE PROC DOC
Definition: SurgiNet Surgical Case Procedure Document
Table Type: ACTIVITY





Column Detail - SN_SURG_CASE_PROC_DOC


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y 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 Y 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.
BEG_EFFECTIVE_DT_TM DATETIME Y The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
CREATE_APPLCTX DOUBLE Y Create Application Context
CREATE_DT_TM DATETIME Y Create Date and Time
CREATE_PRSNL_ID DOUBLE N Create Personnel ID
CREATE_TASK DOUBLE Y Create TaskColumn
DOC_TYPE_CD DOUBLE N The document type that this procedure and preference card belongs to.
END_EFFECTIVE_DT_TM DATETIME Y The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
PICK_LIST_CHG_FLAG DOUBLE Y Used when something is changed for a filled case that would directly affect what pick list is needed.
PREF_CARD_ID DOUBLE N The Preference Card ID being used for this procedure and document
PREF_CARD_SECTIONS DOUBLE N The preference Card Sections that are being used
SURG_CASE_PROC_DOC_ID DOUBLE N The unique ID for this table
SURG_CASE_PROC_ID DOUBLE N The Surgical Case Procedure Id for the Procedure and document
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_SURG_CASE_PROC_DOC


Child Column in SN_SURG_CASE_PROC_DOC(FK) Parent Table Name Parent Column Name
Parents: PREF_CARD_ID PREFERENCE_CARD PREF_CARD_ID
SURG_CASE_PROC_ID SURG_CASE_PROCEDURE SURG_CASE_PROC_ID


SN_SURG_CASE_ST



Column Section Relationship Section Top of Page


Table-level Detail

Description: SurgiNet Surgical Case Summary Table
Definition: Contains summary data associated with surgical cases
Table Type: ACTIVITY





Column Detail - SN_SURG_CASE_ST


Column Name Type Null? Definition
ACTUAL_SLOT_TYPE_ID DOUBLE N Actual Slot Type ID
SCH_APPT_ID DOUBLE N Scheduling Appointment ID
SCH_FLEX_ID DOUBLE N Scheduling Flex String ID
SCH_SLOT_OVERRIDE_IND DOUBLE Y Scheduling Slot Override Indicator
SCH_SLOT_STATE_MEANING CHAR(12) Y Scheduling Slot State Meaning
SCH_SLOT_TYPE_ID DOUBLE N Scheduled Slot Type ID
SN_SURG_CASE_ST_ID DOUBLE N SurgiNet Surgical Case Summary Table ID
SURG_CASE_ID DOUBLE N Surgical Case ID
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_SURG_CASE_ST


Child Column in SN_SURG_CASE_ST(FK) Parent Table Name Parent Column Name
Parents: SCH_FLEX_ID SCH_FLEX_STRING SCH_FLEX_ID
ACTUAL_SLOT_TYPE_ID SCH_SLOT_TYPE SLOT_TYPE_ID
SCH_SLOT_TYPE_ID SCH_SLOT_TYPE SLOT_TYPE_ID
SURG_CASE_ID SURGICAL_CASE SURG_CASE_ID


SN_SYSTEM_PARAMETER



Column Section Top of Page


Table-level Detail

Description: SurgiNet System Parameter
Definition: System parameters used by various SurgiNet applications
Table Type: REFERENCE





Column Detail - SN_SYSTEM_PARAMETER


Column Name Type Null? Definition
ALLOW_DB_DELETES_IND DOUBLE Y *** OBSOLETE ***Column
ANESTHESIA_INTERVAL DOUBLE Y Default time interval for data collection
ANEST_OPT_FLAG DOUBLE Y Used to determine the type of charge used for anesthesia.
ANEST_TIME_IND DOUBLE Y *** OBSOLETE ***Column
ASSIGN_DT_RANGE_IND DOUBLE Y *** OBSOLETE ***Column
ASSIGN_GRID_TM_START DOUBLE Y *** OBSOLETE ***Column
ASSIGN_GRID_TM_STOP DOUBLE Y *** OBSOLETE ***Column
ASSIGN_METHOD_FLAG DOUBLE Y *** OBSOLETE ***Column
ASSIGN_SURG_PRSNL_IND DOUBLE Y *** OBSOLETE ***Column
ASSIGN_SURG_ROLE_IND DOUBLE Y *** OBSOLETE ***Column
ASSIGN_TM_RANGE_IND DOUBLE Y *** OBSOLETE ***Column
ASSIGN_TM_RANGE_START_TM DOUBLE Y *** OBSOLETE ***Column
AUTO_GROUP_IND DOUBLE Y *** OBSOLETE ***Column
BY_PROC_DOC_IND DOUBLE Y *** OBSOLETE ***Column
BY_PROC_PICK_LIST_IND DOUBLE Y *** OBSOLETE ***Column
CASE_CART_GEN_DAYS_AHEAD DOUBLE Y *** OBSOLETE ***Column
CHARGE_WASTE_IND DOUBLE Y *** OBSOLETE ***Column
CLEANUP_TIME DOUBLE Y Default Cleanup Time for the Procedure
CNT_NUM_CONFIRM DOUBLE Y *** OBSOLETE ***Column
DEF_CNT_HDG VARCHAR(25) Y *** OBSOLETE ***Column
DEF_GRP_HDG VARCHAR(25) Y *** OBSOLETE ***Column
DEF_POSTOP_DIAG_SAME_IND DOUBLE Y *** OBSOLETE ***Column
DEF_SEG_LIST_ID DOUBLE N *** OBSOLETE ***Column
DEF_SEG_LIST_VER_NBR DOUBLE Y *** OBSOLETE ***Column
DEF_SURG_SPECIALTY_FLAG DOUBLE Y Used by Surgical Case Manager -- An indicator of whether the surgical specialty should be defaulted from the primary surgeon's primary specialty (personnel group of "SURGSPEC") or the scheduled procedure's associated specialty
DEPT_CD DOUBLE N The department to be used for department-specific logic. This will eventually be replaced by location-filter logic (when sign-on to a location is available).
GENERIC_PREF_CARD_DESC VARCHAR(30) Y *** OBSOLETE ***Column
INST_CD DOUBLE N The institution to be used for institution-specific logic. This will eventually be replaced by location-filter logic (when sign-on to a location is available).
INTRAOP_DOC_IND DOUBLE Y *** OBSOLETE ***Column
ITEM_COST_TYPE_CD DOUBLE N *** OBSOLETE ***Column
ITEM_MERGE_OPTION_FLAG DOUBLE Y *** OBSOLETE ***Column
NUM_CASES_REC_AVG DOUBLE Y Number of cases to be used for recent average calculation
NUM_DAYS_ASSIGN_START_DT DOUBLE Y *** OBSOLETE ***Column
NUM_DAYS_EXISTING_ASSIGNS DOUBLE Y *** OBSOLETE ***Column
NUM_DAYS_LOOKBACK DOUBLE Y *** OBSOLETE ***Column
PICK_LIST_DUP_FLAG DOUBLE Y *** OBSOLETE ***Column
PREF_CARD_DETAILS_TAB_IND DOUBLE Y *** OBSOLETE ***Column
PREF_CARD_EMAIL_ADDR VARCHAR(100) Y *** OBSOLETE ***Column
PRINT_OPEN_HOLD_IND DOUBLE Y An indicator of whether open and hold quantity or just total requested quantity should print on the Case Pick List.
PROCEDURE_CHARGE_FLAG DOUBLE Y This specifies how the procedure charges are calculated
QTY_ON_HAND_IND DOUBLE Y *** OBSOLETE ***Column
REPORTS_VERSION_NBR VARCHAR(20) Y *** OBSOLETE ***Column
REPORT_CLASS_INSTANCE_CD DOUBLE N *** OBSOLETE ***Column
ROOM_TIME_OPT_FLAG DOUBLE N Time in/out to use for room time charges
ROOT_LOC_CD DOUBLE N *** OBSOLETE ***Column
SETUP_CLEANUP_IND DOUBLE N determine if setup and cleanup times should be included in room charges
SETUP_TIME DOUBLE Y Default Setup Time
SN_SYS_PARAM_ID DOUBLE N The primary key, uniquely identifying a row on this table
SUB_FOR_ALL_DATES_IND DOUBLE Y *** OBSOLETE ***Column
SUB_WITH_VERIFY_IND DOUBLE Y *** OBSOLETE ***Column
SURG_AREA_CD DOUBLE N The surgical area (CDF Meaning = "SURGAREA" on service resource codeset) to be used for surgical area-specific logic. This will eventually be replaced by location-filter logic (when sign-on to a location is available).
SURG_AREA_NAME_KEY VARCHAR(32) Y A unique key used to identify a row on the table; associated with the surgical area
SURG_CHARGES_IND DOUBLE N To determine if charging info should be sent to the AFC server
SURG_STAGE_CD DOUBLE N The surgical staging area to be used for surgical staging area-specific logic. This will eventually be replaced by location-filter logic (when sign-on to a location is available).
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.
USE_CNT_TOTAL_IND DOUBLE Y *** OBSOLETE ***Column
USE_OPTION_FLAG DOUBLE Y *** OBSOLETE ***Column
WOUND_CLASS_DISP_IND DOUBLE Y *** OBSOLETE ***Column


SN_TEMPERATURE_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: SN_Temperature_History
Definition: History of the temperature recorded for locations and item instances.
Table Type: ACTIVITY





Column Detail - SN_TEMPERATURE_HIST


Column Name Type Null? Definition
MANUAL_ENTRY_IND DOUBLE N indicates whether the temperature was manually recorded
PARENT_ENTITY_ID DOUBLE N identifier of the parent entity whose temperature was recorded. It¿s the primary key to the table specified by parent_entity_name column. Eg mm_instance_id or location_cd
PARENT_ENTITY_NAME VARCHAR(30) N name of the parent table that defines parent_entity_id. Eg ""LOCATION"" if parent_entity_id is a location_cd or ""MM_INSTANCE"" if parent_entity_id is a mm_instance_id
PRSNL_ID DOUBLE N identifier of the personnel recording the temperature.
SN_TEMPERATURE_HIST_ID DOUBLE N Primary Key
TEMPERATURE_DT_TM DATETIME N Date and time when the temperature was recorded
TEMPERATURE_IN_VALID_RANGE_IND DOUBLE N Indicates if the temperature is within the valid range defined for the entity
TEMPERATURE_UNIT_CD DOUBLE N code value of the temperature specified at temp column
TEMPERATURE_VALUE DOUBLE N recorded temperature
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_TEMPERATURE_HIST


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


SN_TRACK_EVENT_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Surginet Track Event Relation Details
Definition: Stote Form codes associated with track events. ( ASC Set Perioperative Tracking Events based on Powerform Events)
Table Type: REFERENCE





Column Detail - SN_TRACK_EVENT_RELTN


Column Name Type Null? Definition
EVENT_CD DOUBLE Y Clinical event code of the power form associated with a track event.;
SN_TRACK_EVENT_RELTN_ID DOUBLE N PRIMARY KEY
TRACK_EVENT_ID DOUBLE Y The track event the form is associated to (from the TRACK_EVENT table).;
UPDT_APPLCTX DOUBLE Y 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 Y 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 Y 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 Y 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 Y 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_TRACK_EVENT_RELTN


Child Column in SN_TRACK_EVENT_RELTN(FK) Parent Table Name Parent Column Name
Parents: EVENT_CD CODE_VALUE CODE_VALUE
TRACK_EVENT_ID TRACK_EVENT TRACK_EVENT_ID