SN_SURG_PROFILE



Column Section Relationship Section Top of Page


Table-level Detail

Description: SurgiNet Surgeon Profile
Definition: Surgeon Profile for storing surgeon specific data used in surgical cases (pref cards, picklist, comments, etc.)
Table Type: REFERENCE





Column Detail - SN_SURG_PROFILE


Column Name Type Null? Definition
ACTIVE_DT_TM DATETIME Y The Date and Time the profile was marked active or inactive;
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_PRSNL_ID DOUBLE Y The personnel who marked the profile as active or inactive;
CREATE_DT_TM DATETIME Y Date and Time the Surgeon Profile was created;
CREATE_PRSNL_ID DOUBLE Y Personnel who created the surgeon profile;
PRSNL_ID DOUBLE Y Personnel Id for the Surgeon ;
SN_SURG_PROFILE_ID DOUBLE N PRIMARY KEY
UPDT_APPLCTX DOUBLE Y The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_CNT DOUBLE Y 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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME Y The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_ID DOUBLE Y The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE Y The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - SN_SURG_PROFILE


Child Column in SN_SURG_PROFILE(FK) Parent Table Name Parent Column Name
Parents: ACTIVE_PRSNL_ID PRSNL PERSON_ID
CREATE_PRSNL_ID PRSNL PERSON_ID
PRSNL_ID PRSNL PERSON_ID




Parent Column in SN_SURG_PROFILE (PK) Child Table Name Child Column Name
Children: SN_SURG_PROFILE_ID SN_SURG_PROFILE_COMMENT SN_SURG_PROFILE_ID
SN_SURG_PROFILE_LOCK SN_SURG_PROFILE_ID
SN_SURG_PROFILE_MOD_HIST SN_SURG_PROFILE_ID


SN_SURG_PROFILE_COMMENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: SurgiNet Surgeon Profile Comment
Definition: Stores surgeon specific comments used during surgical cases (room setup preferences, sizes, handedness, etc.)
Table Type: REFERENCE





Column Detail - SN_SURG_PROFILE_COMMENT


Column Name Type Null? Definition
ACTIVE_DT_TM DATETIME Y The Date and Time the profile comment version was marked active or inactive;
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_PRSNL_ID DOUBLE Y The personnel who marked the profile comment as active or inactive;
COMMENT_VALUE LONGTEXT Y Comment for Surgeon Profile stored in HTML format;
CREATE_DT_TM DATETIME Y Date and Time the Surgeon Profile comment version was created;
CREATE_PRSNL_ID DOUBLE Y Personnel who created the surgeon profile comment version;
PREV_SURG_PROFILE_COMMENT_ID DOUBLE Y Identifies the previous version of the surgeon profile comment ;
SN_SURG_PROFILE_COMMENT_ID DOUBLE N PRIMARY KEY
SN_SURG_PROFILE_ID DOUBLE Y Identifies the surgeon profile that this comment belongs to;
UPDT_APPLCTX DOUBLE Y The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_CNT DOUBLE Y 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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME Y The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_ID DOUBLE Y The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE Y The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - SN_SURG_PROFILE_COMMENT


Child Column in SN_SURG_PROFILE_COMMENT(FK) Parent Table Name Parent Column Name
Parents: ACTIVE_PRSNL_ID PRSNL PERSON_ID
CREATE_PRSNL_ID PRSNL PERSON_ID
SN_SURG_PROFILE_ID SN_SURG_PROFILE SN_SURG_PROFILE_ID
PREV_SURG_PROFILE_COMMENT_ID SN_SURG_PROFILE_COMMENT SN_SURG_PROFILE_COMMENT_ID




Parent Column in SN_SURG_PROFILE_COMMENT (PK) Child Table Name Child Column Name
Children: SN_SURG_PROFILE_COMMENT_ID SN_SURG_PROFILE_COMMENT PREV_SURG_PROFILE_COMMENT_ID


SN_SURG_PROFILE_LOCK



Column Section Relationship Section Top of Page


Table-level Detail

Description: SurgiNet Surgeon Profile Lock
Definition: Contains who and when users had locks on a surgeon profile for editing
Table Type: ACTIVITY





Column Detail - SN_SURG_PROFILE_LOCK


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.
BREAK_TYPE_FLAG DOUBLE Y How the lock was unlocked, through normal process or broken by another user
LAST_UPDT_DT_TM DATETIME Y The last time the surgeon profile was updated. This is used to determine if a lock is eligible to be broken;
LOCK_DT_TM DATETIME Y Date and Time the lock was acquired;
LOCK_PRSNL_ID DOUBLE Y The provider who obtained the lock;
SN_SURG_PROFILE_ID DOUBLE Y Profile that the lock applies to;
SN_SURG_PROFILE_LOCK_ID DOUBLE N PRIMARY KEY
UPDT_APPLCTX DOUBLE Y The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_CNT DOUBLE Y 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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME Y The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_ID DOUBLE Y The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE Y The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - SN_SURG_PROFILE_LOCK


Child Column in SN_SURG_PROFILE_LOCK(FK) Parent Table Name Parent Column Name
Parents: LOCK_PRSNL_ID PRSNL PERSON_ID
SN_SURG_PROFILE_ID SN_SURG_PROFILE SN_SURG_PROFILE_ID




Parent Column in SN_SURG_PROFILE_LOCK (PK) Child Table Name Child Column Name
Children: SN_SURG_PROFILE_LOCK_ID SN_SURG_PROFILE_MOD_HIST MODIFY_LOCK_ID


SN_SURG_PROFILE_MOD_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: SurgiNet Surgeon Profile Modify History
Definition: Contains history of who and when changes were made to a surgeons profile
Table Type: ACTIVITY





Column Detail - SN_SURG_PROFILE_MOD_HIST


Column Name Type Null? Definition
MODIFY_DT_TM DATETIME Y Date and Time a modification was made to the surgeons profile;
MODIFY_LOCK_ID DOUBLE Y The surgeon profile lock that was used to make the modification;
MODIFY_PRSNL_ID DOUBLE Y User who made a modification to a surgeons profile;
MODIFY_TYPE_FLAG DOUBLE Y The type of data that was modified on the surgeons profile;
SN_SURG_PROFILE_ID DOUBLE Y Surgeon Profile associated to the modification history;
SN_SURG_PROFILE_MOD_HIST_ID DOUBLE N PRIMARY KEY
UPDT_APPLCTX DOUBLE Y The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_CNT DOUBLE Y 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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME Y The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_ID DOUBLE Y The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE Y The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - SN_SURG_PROFILE_MOD_HIST


Child Column in SN_SURG_PROFILE_MOD_HIST(FK) Parent Table Name Parent Column Name
Parents: MODIFY_PRSNL_ID PRSNL PERSON_ID
SN_SURG_PROFILE_ID SN_SURG_PROFILE SN_SURG_PROFILE_ID
MODIFY_LOCK_ID SN_SURG_PROFILE_LOCK SN_SURG_PROFILE_LOCK_ID