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.