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 |