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 |