Table Detail Report
SN_TRACK_RULE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Surginet Track Rule Table |
Definition: | This is the parent table for all client defined rules used in Surginet Case Tracking |
Table Type: | REFERENCE |
Column Detail - SN_TRACK_RULE
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. |
RULE_NAME | VARCHAR(255) | Y | Client defined name given to the rule. xxx |
RULE_SEQUENCE | DOUBLE | N | The order in which the rules are processed |
RULE_TYPE_CD | DOUBLE | N | Denotes the template used to create the rule. |
SN_TRACK_RULE_ID | DOUBLE | N | Primary Key |
TRACKING_GROUP_CD | DOUBLE | N | Foreign key to identify the tracking group associates with this rule. |
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_TRACK_RULE
Parent Column in SN_TRACK_RULE (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | SN_TRACK_RULE_ID | SN_TRACK_RULE_PROMPT | SN_TRACK_RULE_ID |
SN_TRACK_RULE_PROMPT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Surginet Track Rule Prompt |
Definition: | This table holds the prompts for all client defined rules used in Surginet Case Tracking. |
Table Type: | REFERENCE |
Column Detail - SN_TRACK_RULE_PROMPT
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. |
PROMPT_SEQUENCE | DOUBLE | N | Defines order of the prompts that allows us to determine what the prompt is based on the rule_type_flag of the parent sn_track_rule record. |
SN_TRACK_RULE_ID | DOUBLE | N | Foreign key to sn_track_rule table |
SN_TRACK_RULE_PROMPT_ID | DOUBLE | N | Primary Key |
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_TRACK_RULE_PROMPT
Child Column in SN_TRACK_RULE_PROMPT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | SN_TRACK_RULE_ID | SN_TRACK_RULE | SN_TRACK_RULE_ID |
Parent Column in SN_TRACK_RULE_PROMPT (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | SN_TRACK_RULE_PROMPT_ID | SN_TRACK_RULE_RESPONSE | SN_TRACK_RULE_PROMPT_ID |
SN_TRACK_RULE_RESPONSE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Surginet Track Rule Response |
Definition: | This is the table holding the responses to the prompts for all client defined rules used in Surginet Case Tracking. |
Table Type: | REFERENCE |
Column Detail - SN_TRACK_RULE_RESPONSE
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. |
RESPONSE_VALUE | VARCHAR(255) | Y | Holds the user's response to the given prompt. |
SN_TRACK_RULE_PROMPT_ID | DOUBLE | N | Foreign key from SN_Track_Rule_Prompt |
SN_TRACK_RULE_RESPONSE_ID | DOUBLE | N | Primary key |
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. |
VALUE_TYPE_CD | DOUBLE | N | Determines the type of value stored |
Relationship Detail - SN_TRACK_RULE_RESPONSE
Child Column in SN_TRACK_RULE_RESPONSE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | SN_TRACK_RULE_PROMPT_ID | SN_TRACK_RULE_PROMPT | SN_TRACK_RULE_PROMPT_ID |
SN_UNFINALIZE_REASON
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | SN Unfinalize Reason |
Definition: | Stores user's reasons for unfinalizing a case/document type. |
Table Type: | ACTIVITY |
Column Detail - SN_UNFINALIZE_REASON
Column Name | Type | Null? | Definition |
---|---|---|---|
CREATE_DT_TM | DATETIME | N | The date and time the action was done and this entry made. |
PERIOP_DOC_ID | DOUBLE | N | Foreign key to PERIOPERATIVE_DOCUMENT table |
PRSNL_ID | DOUBLE | N | User who unfinalized case/document type |
UNFINALIZE_REASON_CD | DOUBLE | N | Codified reason case/document type was unfinalized |
UNFINALIZE_REASON_FREE_TXT | VARCHAR(255) | Y | Additional unfinalize comments |
UNFINALIZE_REASON_ID | DOUBLE | N | PRIMARY KEY |
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_UNFINALIZE_REASON
Child Column in SN_UNFINALIZE_REASON(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PERIOP_DOC_ID | PERIOPERATIVE_DOCUMENT | PERIOP_DOC_ID |
PRSNL_ID | PRSNL | PERSON_ID |
SN_UNLOCKING_TEXT
Column Section | Top of Page |
Table-level Detail
Description: | SN UNLOCKING TEXT |
Definition: | SurgiNet Unlocking Text |
Table Type: | ACTIVITY |
Column Detail - SN_UNLOCKING_TEXT
Column Name | Type | Null? | Definition |
---|---|---|---|
COMMENT_TEXT | VARCHAR(100) | N | Comment TextColumn |
PARENT_ENTITY_ID | DOUBLE | N | Parent Entity IdColumn |
PARENT_ENTITY_NAME | VARCHAR(32) | N | Parent Entity NameColumn |
UNLOCKED_BY_ID | DOUBLE | N | Unlocked By IdColumn |
UNLOCKED_DT_TM | DATETIME | N | Unlocked Date and TimeColumn |
UNLOCKING_TEXT_ID | DOUBLE | N | Unlocking Text 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. |