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 |