Table Detail Report

SN_CT_DISPLAY_FIELD



Column Section Relationship Section Top of Page


Table-level Detail

Description: Surginet Case Tracking Display Field
Definition: Stores the individual piees of data and their sequence on a row in the case tracking dynamic view
Table Type: REFERENCE





Column Detail - SN_CT_DISPLAY_FIELD


Column Name Type Null? Definition
FIELD_PROMPT VARCHAR(50) Y Field PromptColumn
FIELD_SEQUENCE DOUBLE N Determines the order in which fields with the same sn_ct_display_row_id will appear
PARENT_ENTITY_ID DOUBLE N Defines what piece of data from the surgical case the field should contain.
PARENT_ENTITY_NAME VARCHAR(32) Y Describes the source of the parent_entity_id
SN_CT_DISPLAY_FIELD_ID DOUBLE N Primary key for this table
SN_CT_DISPLAY_ROW_ID DOUBLE N Foreign key to indicate which display row this field belongs to.
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_CT_DISPLAY_FIELD


Child Column in SN_CT_DISPLAY_FIELD(FK) Parent Table Name Parent Column Name
Parents: SN_CT_DISPLAY_ROW_ID SN_CT_DISPLAY_ROW SN_CT_DISPLAY_ROW_ID


SN_CT_DISPLAY_ROW



Column Section Relationship Section Top of Page


Table-level Detail

Description: Surginet Case Tracking Display Row
Definition: Stores information regarding rows defined to appear ina view type
Table Type: REFERENCE





Column Detail - SN_CT_DISPLAY_ROW


Column Name Type Null? Definition
ROW_SEQUENCE DOUBLE N Defines the order of the rows that have the same sn_ct_view_type_id
ROW_TYPE_FLAG DOUBLE N Defines which type of row this is. 0 - event status type flag. This type of row will contain information defining the behavior of the event bar in dynamic view 1 - data field flag. This type of row will contain information on what case data to display in dynamic view
SN_CT_DISPLAY_ROW_ID DOUBLE N Primary key for this table
SN_CT_VIEW_TYPE_ID DOUBLE N Foreign key to sn_ct_view_type to identify which view type this row is defined 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_CT_DISPLAY_ROW


Child Column in SN_CT_DISPLAY_ROW(FK) Parent Table Name Parent Column Name
Parents: SN_CT_VIEW_TYPE_ID SN_CT_VIEW_TYPE SN_CT_VIEW_TYPE_ID




Parent Column in SN_CT_DISPLAY_ROW (PK) Child Table Name Child Column Name
Children: SN_CT_DISPLAY_ROW_ID SN_CT_DISPLAY_FIELD SN_CT_DISPLAY_ROW_ID


SN_CT_VIEW_TYPE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Surginet Case Tracking View Type
Definition: Stores view type definitions for case tracking dynamic views.
Table Type: REFERENCE





Column Detail - SN_CT_VIEW_TYPE


Column Name Type Null? Definition
MILESTONE_IND DOUBLE N Determines whether milestones are displayed for this view type
SN_CT_VIEW_TYPE_ID DOUBLE N Primary Key for this table
TRACK_GROUP_CD DOUBLE N Foreign key (from CODE_VALUE) to identify which tracking group this view type is defined 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.
VIEW_TYPE_NAME VARCHAR(50) N Name given for the view type



Relationship Detail - SN_CT_VIEW_TYPE




Parent Column in SN_CT_VIEW_TYPE (PK) Child Table Name Child Column Name
Children: SN_CT_VIEW_TYPE_ID SN_CT_DISPLAY_ROW SN_CT_VIEW_TYPE_ID


SN_DIAGNOSTIC



Column Section Relationship Section Top of Page


Table-level Detail

Description: The SurgiNet Diagnostics table contains the diagnostic tests for SurgiNet
Definition: The SurgiNet Diagnostics table
Table Type: REFERENCE





Column Detail - SN_DIAGNOSTIC


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.
CHK_DESCRIPTION VARCHAR(255) N Describes the Check script
COMMENT_TEXT VARCHAR(255) Y A comment for the user
DIAGNOSTIC_ID DOUBLE N The unique ID on the Table
FIX_DESCRIPTION VARCHAR(255) Y Describes the Fix portion of the Diagonostic Test
LAST_CHK_DT_TM DATETIME Y The date and time that the Diagnostic Rule was checked
LAST_CHK_PRSNL_ID DOUBLE N The person who caused the Last Check on the Diagonostic Rule.
LAST_CHK_STATUS VARCHAR(1) N The Status of the Last Check
LAST_FIX_DT_TM DATETIME Y The Date and Time the Fix was made using the Diagonostic Rule
LAST_FIX_PRSNL_ID DOUBLE N The person who caused the Last Fix using the Diagonostic Rule
LAST_FIX_STATUS VARCHAR(1) N The Status of the last Fix
READ_ONLY_IND DOUBLE N Specifies the Diagonostic is a Read only from the front-end
TEST_NAME VARCHAR(50) N The Test Name
TEST_SCRIPT VARCHAR(30) N The Script that will be executed for the Test
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_DIAGNOSTIC




Parent Column in SN_DIAGNOSTIC (PK) Child Table Name Child Column Name
Children: DIAGNOSTIC_ID SN_DIAGNOSTIC_REL DIAGNOSTIC_ID


SN_DIAGNOSTIC_GROUP



Column Section Relationship Section Top of Page


Table-level Detail

Description: SurgiNet Diagnostic Group
Definition: SurgiNet Diagnostic Group Table
Table Type: REFERENCE





Column Detail - SN_DIAGNOSTIC_GROUP


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.
COMMENT_TEXT VARCHAR(255) N The Comment Text
DIAGNOSTIC_GROUP_ID DOUBLE N The Unique Id on the table
GROUP_DESCRIPTION VARCHAR(255) N The group Description
GROUP_DISPLAY VARCHAR(50) N The group display
READ_ONLY_IND DOUBLE N Read only IndicatorColumn
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_DIAGNOSTIC_GROUP




Parent Column in SN_DIAGNOSTIC_GROUP (PK) Child Table Name Child Column Name
Children: DIAGNOSTIC_GROUP_ID SN_DIAGNOSTIC_REL DIAGNOSTIC_GROUP_ID