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 |