Table Detail Report

SEGMENT_PROCEDURE



Column Section Top of Page


Table-level Detail

Description: Segment Procedure
Definition: Contains the procedure associated with an "entry" of a perioperative document.
Table Type: ACTIVITY





Column Detail - SEGMENT_PROCEDURE


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.
CREATE_APPLCTX DOUBLE Y The application context responsible for inserting this row on the table.
CREATE_DT_TM DATETIME Y The date and time this row was inserted on the table.
CREATE_PRSNL_ID DOUBLE N The person responsible for inserting this row on the table.
CREATE_TASK DOUBLE Y The task responsible for inserting this row on the table.
PARENT_ENTITY_NAME VARCHAR(50) Y The table name for the "entry" of the perioperative document with which this row on the table is associated.
PARENT_ENTITY_STATIC_ID DOUBLE N The static id for the "entry" of the perioperative document with which this row on the table is associated.
SEGMENT_PROC_ID DOUBLE N The primary key, uniquely identifying a row on this table.
SURG_CASE_PROC_ID DOUBLE N Foreign key into the surg_case_procedure table.Column
SURG_PROC_CD DOUBLE N The surgical procedure documented as being associated with this "entry" of the perioperative document.
SURG_PROC_PERF_STATIC_ID DOUBLE N Surg Proc perf Static IDColumn
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.


SEGMENT_REFERENCE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Segment Reference
Definition: Contains the attributes associated with a documentation segment
Table Type: REFERENCE





Column Detail - SEGMENT_REFERENCE


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.
CREATE_APPLCTX DOUBLE Y The application context responsible for inserting this row on the table
CREATE_DT_TM DATETIME Y The date and time this row was inserted on the table
CREATE_PRSNL_ID DOUBLE N The person responsible for inserting this row on the table
CREATE_TASK DOUBLE Y The task responsible for inserting this row on the table
DOC_TYPE_CD DOUBLE N The document type associated with this documentation segment, i.e. OR Nursing Record, Preop Nursing Assessment
EQUIP_CLASS_NODE_ID DOUBLE N *** OBSOLETE ***Column
EXECUTE_SEQ DOUBLE Y *** OBSOLETE ***Column
INPUT_FORM_CD DOUBLE N The input form associated with this documentation segment. This is the form that will be launched by the form builder when this segment is selected in the Segment Navigator
OBJECT_NAME VARCHAR(50) Y *** OBSOLETE ***Column
POST_CARE_TEXT_ID DOUBLE N A reference (foreign key) to the long_text table identifying the care text that should print AFTER this segment on the intraoperative record.
PREF_CARD_DEFAULTS_IND DOUBLE Y An indicator of whether or not preference card defaults may exist for this documentation segment
PRE_CARE_TEXT_ID DOUBLE N A reference (foreign key) to the long_text table identifying the care text that should print BEFORE this segment on the intraoperative record.
PRINTABLE_IND DOUBLE Y An indicator of whether or not this segment is printable on the Intraoperative Record or not. Unchartable Events is an example of a segment that may have a printable indicator of 0. The default is 1.
PRINT_SEQ DOUBLE Y This defines the printing sequence for the segment in the Preference Card defaults and the Perioperative Record
REQUIRED_FIELD_IND DOUBLE Y *** OBSOLETE ***Column
SEG_CD DOUBLE N The primary key, uniquely identifying a row on this table.
SEG_GRP_CD DOUBLE N The segment group of which this segment is a part of. Each segment may only be contained in one segment group.
SEG_REQ_FLAG DOUBLE Y Indicates whether this segment is required within the document type. If the value is 1 (system required) or 2 (site required), the Perioperative Document Manager will not allow a "Delete" or "N/A" of this segment.
SEG_SEQ DOUBLE Y The absolute sequence of this segment within the specified document type.
SIGNATURE_FLAG DOUBLE N Indicates if the segment allows or requires electronic signature (0 = does not allow or require signature, 1 = allows signature, 2 = requires signature)
SURG_AREA_CD DOUBLE N The surgical area associated with this documentation segment. Identified by a CDF Meaning of "SURGAREA" on the Service Resource codeset.
SYSTEM_DEFINED_IND DOUBLE Y An indicator of whether or not this segment is system-defined.
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.
VERBAL_ORDERS_IND DOUBLE N This marks the segment as being part of the Verbal Orders Review Process.
VERIFY_SCRIPT_NAME VARCHAR(50) Y *** OBSOLETE ***Column



Relationship Detail - SEGMENT_REFERENCE


Child Column in SEGMENT_REFERENCE(FK) Parent Table Name Parent Column Name
Parents: EQUIP_CLASS_NODE_ID CLASS_NODE CLASS_NODE_ID
SEG_CD CODE_VALUE CODE_VALUE
POST_CARE_TEXT_ID LONG_TEXT LONG_TEXT_ID
PRE_CARE_TEXT_ID LONG_TEXT LONG_TEXT_ID
SEG_GRP_CD SEGMENT_GRP_REFERENCE SEG_GRP_CD




Parent Column in SEGMENT_REFERENCE (PK) Child Table Name Child Column Name
Children: SEG_CD SEG_GRP_SEQ_R SEG_CD


SEG_GRP_SEQ_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: SEG GRP SEQ R
Definition: Segment Group Sequence Relationship
Table Type: REFERENCE





Column Detail - SEG_GRP_SEQ_R


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.
CREATE_APPLCTX DOUBLE N The application context creating the row on the table
CREATE_DT_TM DATETIME N The date and time the row was created
CREATE_PRSNL_ID DOUBLE N The Personnel ID of the person that created the row on the table
CREATE_TASK DOUBLE N The task that created the row on the table
EXECUTE_SEQ DOUBLE Y The execute seqence for the segment.
SEG_CD DOUBLE N The segment code for the segment which the sequence is defined for.
SEG_GRP_CD DOUBLE N *** OBSOLETE ***Column
SEG_GRP_SEQ_R_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 - SEG_GRP_SEQ_R


Child Column in SEG_GRP_SEQ_R(FK) Parent Table Name Parent Column Name
Parents: SEG_GRP_CD SEGMENT_GRP_REFERENCE SEG_GRP_CD
SEG_CD SEGMENT_REFERENCE SEG_CD


SN_ACUITY_LEVEL



Column Section Relationship Section Top of Page


Table-level Detail

Description: SurgiNet Acuity Levels
Definition: The times associated with acuity levels, i.e. acuity 1, 2,3,4 Start/Stop Time etc.
Table Type: ACTIVITY





Column Detail - SN_ACUITY_LEVEL


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.
ACUITY_LEVEL_CD DOUBLE N Indicates the Acuity Level such as ACUITY Level I, II etc?
ACUITY_LEVEL_ID DOUBLE N The primary key, uniquely identifying a row on this table. This value is unique for all versions of a given acuity level for a case.
ACUITY_START_DT_TM DATETIME Y The date and time associated with this Acuity start date and time.
ACUITY_STOP_DT_TM DATETIME Y The date and time associated with this Acuity stop date and time.
SEGMENT_HEADER_ID DOUBLE N A reference (foreign key) to the segment_header table indicating the status of this segment, i.e. Accessed, Discontinued, etc.
SURG_CASE_ID DOUBLE N Surgical Case Identifier
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_ACUITY_LEVEL


Child Column in SN_ACUITY_LEVEL(FK) Parent Table Name Parent Column Name
Parents: SEGMENT_HEADER_ID SEGMENT_HEADER SEGMENT_HEADER_ID
SURG_CASE_ID SURGICAL_CASE SURG_CASE_ID


SN_APP_PREFS



Column Section Relationship Section Top of Page


Table-level Detail

Description: SurgiNet Application Preferences
Definition: SurgiNet Application Preferences Table
Table Type: REFERENCE





Column Detail - SN_APP_PREFS


Column Name Type Null? Definition
APPLICATION_NUMBER DOUBLE N Application Number for the preference
APP_PREFS_ID DOUBLE N Application Preferences ID. The unique ID of the table
COMPONENT_NAME VARCHAR(32) N The Component name for which the preference is stored for
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 of the person for which the preference is stored for.
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_APP_PREFS


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