Table Detail Report

STAFF_ACTIVITY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Staff Activity
Definition: Used by SNStaffAssign
Table Type: ACTIVITY





Column Detail - STAFF_ACTIVITY


Column Name Type Null? Definition
CREATE_DT_TM DATETIME Y Create Date and TimeColumn
CREATE_PRSNL_ID DOUBLE N Create Personnel IdColumn
CREATE_TASK DOUBLE Y Create TaskColumn
CREAT_APPLCTX DOUBLE Y Create Application ContextColumn
FREE_TEXT_NAME VARCHAR(100) N Free text nameColumn
METHOD_FLAG DOUBLE Y Method Flag. Possible values are: null = Assign by case; 1 = Assign by case; 2 = Assign by OR; 3 = Assign by Team
PRSNL_ID DOUBLE N Person_ID of the staff assigned
ROLE_CD DOUBLE N Role of the assigned staff
SHIFT_CD DOUBLE N Shift Code the staff is assigned to
STAFF_ACTIVITY_ID DOUBLE N Staff Activity IdColumn
START_DT_TM DATETIME N The activity Start Date and Time
START_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
STOP_DT_TM DATETIME N The activity Stop Date and Time
STOP_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
SURG_AREA_CD DOUBLE N Surgical Area Cd for the associated staff activity
SURG_CASE_ID DOUBLE N Surgical Case ID the staff is assigned to
SURG_OP_LOC_CD DOUBLE N OR the staff is assigned to
TEAM_CD DOUBLE N Team the staff is associated to
UPDT_APPLCTX DOUBLE N 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 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. 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 N 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 N 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 - STAFF_ACTIVITY


Child Column in STAFF_ACTIVITY(FK) Parent Table Name Parent Column Name
Parents: PRSNL_ID PRSNL PERSON_ID
SURG_CASE_ID SURGICAL_CASE SURG_CASE_ID


SURGICAL_CASE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Surgical Case
Definition: Contains the attributes of a surgical case, including patient, start and stop date/time, OR, primary surgeon, etc.
Table Type: ACTIVITY





Column Detail - SURGICAL_CASE


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.
ADDL_SUPPLIES_IND DOUBLE Y Indicates that additional supplies have been requested by the Surgeon.
ADD_ON_IND DOUBLE Y Indicates that the Case is an "add-on" i.e. case is scheduled after the schedule has been finalized.
ANESTH_PRSNL_ID DOUBLE N The primary anesthesiologist associated with this surgical case
ANESTH_TYPE_CD DOUBLE N *** OBSOLETE ***Column
APPT_ID DOUBLE N *** OBSOLETE ***Column
ASA_CLASS_CD DOUBLE N Used for Surgery Mgmt Reporting -- indicates the ASA class assoc. w/ this case
CANCEL_DT_TM DATETIME Y The date and time this case was cancelled
CANCEL_REASON_CD DOUBLE N The reason this surgical case was cancelled
CANCEL_REQ_BY_ID DOUBLE N The person responsible for requesting the cancel of this case
CANCEL_REQ_BY_TEXT VARCHAR(100) Y The free-text name of the person responsible for requesting the cancel of this case (when not on prsnl table)
CANCEL_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
CASE_LEVEL_CD DOUBLE N Used for Surgery Mgmt Reporting -- indicates the case level assoc. w/ this case
CHECKIN_BY_ID DOUBLE N This is the person_id of the user that checked in the case.
CHECKIN_DT_TM DATETIME Y This is the date/time that the user checked in the case.
CHECKIN_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
CREATE_APPLCTX DOUBLE Y Context of the application creating the row
CREATE_DT_TM DATETIME Y Creation Date and Time for this row
CREATE_PRSNL_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the creation of the row in the table.
CREATE_TASK DOUBLE Y The registered (assigned) task number for the process that created the row.
CURR_CASE_STATUS_CD DOUBLE N The current status of this case, i.e. Patient In Holding, Patient In OR, etc.
CURR_CASE_STATUS_DT_TM DATETIME Y The date and time the current status of this case became effective
DEPT_CD DOUBLE N Used for Surgery Mgmt Reporting -- indicates the department assoc. w/ this case
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
ENHANCED_UI_IND DOUBLE N Stores the preference indicator(0/1) which would help differentiate whether patient chart(surgical case) documentation should occur with enhanced workflows support or not.
INST_CD DOUBLE N Used for Surgery Mgmt Reporting -- indicates the institution assoc. w/ this case
OR_SHIFT_CD DOUBLE N Used for Surgery Mgmt Reporting -- indicates the shift that the start of this case falls in
PAT_TYPE_CD DOUBLE N Used for Surgery Mgmt Reporting -- indicates the patient type assoc. with this case
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
POSTOP_DIAG_TEXT_ID DOUBLE N Postop Diagonosis Text Id
PREOP_DIAG_TEXT_ID DOUBLE N Preop Diagonosis Text IdColumn
SCHED_ANESTH_PRSNL_ID DOUBLE N Used for Surgery Mgmt Reporting -- the anesthesiologist scheduled for this case
SCHED_CASE_NBR_LOCN_CD DOUBLE N Scheduled Case Number Location CodeColumn
SCHED_CASE_TYPE_CD DOUBLE N Scheduled Case Type
SCHED_CLEANUP_DUR DOUBLE N Scheduled Cleanup DurationColumn
SCHED_DUR DOUBLE Y Scheduled Case DurationColumn
SCHED_OP_LOC_CD DOUBLE N Scheduled Operating Room Location Code
SCHED_OR_SHIFT_CD DOUBLE N Used for Surgery Mgmt Reporting -- indicates the OR Shift assoc. w/ this case
SCHED_PAT_TYPE_CD DOUBLE N Scheduled Patient Type CodeColumn
SCHED_QTY DOUBLE Y Used for Surgery Mgmt Reporting -- indicates that this case has been scheduled
SCHED_SETUP_DUR DOUBLE Y Scheduled setup durationColumn
SCHED_START_DAY DOUBLE Y Used for Surgery Mgmt Reporting -- indicates the day of the week this case is scheduled to start on
SCHED_START_DT_TM DATETIME Y Scheduled Start Date TimeColumn
SCHED_START_HOUR DOUBLE Y Used for Surgery Mgmt Reporting -- indicates the hour of the day this case is scheduled to start on
SCHED_START_MONTH DOUBLE Y Used for Surgery Mgmt Reporting -- indicates the month this case is scheduled to start on
SCHED_START_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
SCHED_SURG_AREA_CD DOUBLE N Scheduled Surgical Area CodeColumn
SCHED_SURG_SPECIALTY_ID DOUBLE N *** OBSOLETE ***
SCHED_TYPE_CD DOUBLE N Scheduled Type CodeColumn
SCH_EVENT_ID DOUBLE N Scheduled Event IdColumn
SURGEON_PRSNL_ID DOUBLE N The primary surgeon associated with this surgical case
SURG_AREA_CD DOUBLE N The surgical area associated with this surgical case
SURG_CASE_ID DOUBLE N The primary key, uniquely identifying a surgical case
SURG_CASE_NBR_CNT DOUBLE Y The last portion of the OR Case Number, i.e. MAIN-1997- XXXXX. This number is incremented by 1 for each case, starting at 1 for the first case scheduled in a given year.
SURG_CASE_NBR_FORMATTED VARCHAR(100) Y The formatted Surgical case number
SURG_CASE_NBR_LOCN_CD DOUBLE N The surgical area associated with this case, used to retrieve the accession site prefix to be use in the OR Case Number, i.e. MAIN-xxxx-xxxx.
SURG_CASE_NBR_YR DOUBLE Y The middle portion of the OR Case Number, i.e. xxxx-1997-xxxx. The value is the year the case was scheduled IN, not the year the case was scheduled FOR.
SURG_COMPLETE_QTY DOUBLE Y Used for Surgery Mgmt Reporting -- indicates the completion of this case
SURG_DUR_MIN DOUBLE Y Used for Surgery Mgmt Reporting -- indicates the duration of this case
SURG_OP_LOC_CD DOUBLE N Used for Surgery Mgmt Reporting -- indicates the OR Number assoc. w/ this case
SURG_SPECIALTY_ID DOUBLE N Used for Surgery Mgmt Reporting -- indicates the surgical specialty assoc. w/ this case
SURG_START_DAY DOUBLE Y Used for Surgery Mgmt Reporting -- indicates the day of the week this case was started
SURG_START_DT_TM DATETIME Y The date and time the surgical case started.
SURG_START_HOUR DOUBLE Y Used for Surgery Mgmt Reporting -- indicates the hour of the day this case was started
SURG_START_MONTH DOUBLE Y Used for Surgery Mgmt Reporting -- indicates the month this case was started
SURG_START_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
SURG_STOP_DT_TM DATETIME Y The surgery stop date and time.
SURG_STOP_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
TURNOVER_DUR DOUBLE Y Used for Surgery Mgmt Reporting -- the turnover duration for this case
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.
UPDT_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
WOUND_CLASS_CD DOUBLE N Used for Surgery Mgmt Reporting -- indicates the wound class assoc. w/ this case



Relationship Detail - SURGICAL_CASE


Child Column in SURGICAL_CASE(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
PERSON_ID PERSON PERSON_ID
ANESTH_PRSNL_ID PRSNL PERSON_ID
CANCEL_REQ_BY_ID PRSNL PERSON_ID
CHECKIN_BY_ID PRSNL PERSON_ID
SCHED_ANESTH_PRSNL_ID PRSNL PERSON_ID
SURGEON_PRSNL_ID PRSNL PERSON_ID
SURG_SPECIALTY_ID PRSNL_GROUP PRSNL_GROUP_ID
SCH_EVENT_ID SCH_EVENT SCH_EVENT_ID




Parent Column in SURGICAL_CASE (PK) Child Table Name Child Column Name
Children: SURG_CASE_ID CASE_ATTENDANCE SURG_CASE_ID
CASE_CART SURG_CASE_ID
CASE_CART_PICK_LIST SURG_CASE_ID
CASE_TIMES SURG_CASE_ID
LH_CNT_IC_ADV_SURG_DATA SURG_CASE_ID
MM_SUPPLY_CABINET SURG_CASE_ID
PERIOPERATIVE_DOCUMENT SURG_CASE_ID
RXS_ITEM_GROUP_ACT SURG_CASE_ID
RXS_LOCATION_TASK SURG_CASE_ID
SA_ANESTHESIA_RECORD SURGICAL_CASE_ID
SCHED_CASE_PICK_LIST SURG_CASE_ID
SN_ACUITY_LEVEL SURG_CASE_ID
SN_CASE_LONG_TEXT SURG_CASE_ID
SN_CASE_TRACKING SURG_CASE_ID
SN_CHARGE_HEADER SURG_CASE_ID
SN_CHARGE_ITEM SURG_CASE_ID
SN_CHARGE_QUEUE SURG_CASE_ID
SN_IMPLANT_LOG_ST SURG_CASE_ID
SN_NOMEN_ST SURG_CASE_ID
SN_PICKLIST SURG_CASE_ID
SN_SURG_CASE_ST SURG_CASE_ID
STAFF_ACTIVITY SURG_CASE_ID
SURGICAL_DELAY SURG_CASE_ID
SURG_CASE_PROCEDURE SURG_CASE_ID


SURGICAL_DELAY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Surgical Delay
Definition: Contains entries documented in Intraoperative Record associated with surgical delays
Table Type: ACTIVITY





Column Detail - SURGICAL_DELAY


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.
BEG_EFFECTIVE_DT_TM DATETIME Y The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
CREATE_APPLCTX DOUBLE Y The application context responsible for inserting this row on the table
CREATE_DT_TM DATETIME Y The date and time this row was inserted on the table
CREATE_PRSNL_ID DOUBLE N The person responsible for inserting this row on the table
CREATE_TASK DOUBLE Y The task responsible for inserting this row on the table
DEF_IND DOUBLE Y OBSOLETE -- An indicator of whether or not this is a default value that has not yet been accepted by the user
DELAY_DESC VARCHAR(255) Y The description of the delay.Column
DELAY_DOC_BY_ID DOUBLE N A reference (foreign key) to the person table indicating the person responsible for documenting the intraoperative delay
DELAY_DURATION DOUBLE Y The duration of this intraoperative delay
DELAY_OBSERVE_BY_ID DOUBLE N A reference (foreign key) to the person table indicating the person that has observed the intraoperative delay
DELAY_REASON_CD DOUBLE N The reason for this intraoperative delay
DELAY_REPORT_TO_ID DOUBLE N A reference (foreign key) to the person table indicating the person this intraoperative delay was reported to.
DELAY_REPORT_TO_TEXT VARCHAR(100) Y A free-text name of the person to whom this intraoperative delay was reported to
DISPLAY_SEQ DOUBLE Y The sequence in which this intraoperative delay should be displayed
DOC_TYPE_CD DOUBLE N This column references the specific document type that this delay is associated with.
END_EFFECTIVE_DT_TM DATETIME Y The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
RESULT_STATUS_FLAG DOUBLE Y OBSOLETE -- The status of this entry of Surgical Delays, i.e. new unverified, Corrected, etc.
SEGMENT_HEADER_ID DOUBLE N A reference (foreign key) to the segment_header, indicating the status of this segment, i.e. Not Applicable, Accessed, Discontinued, etc.
STAGE_CD DOUBLE N Represents which surgical staging area the delay is associated with.
SURG_AREA_CD DOUBLE N The surgical area associated with this intraoperative delay
SURG_CASE_ID DOUBLE N A reference (foreign key) to the surgical_case table, indicating the surgical case associated with this delays entry.
SURG_DELAY_ID DOUBLE N The primary key, uniquely identifying a row on this table. This value is unique for each version of a Surgical Delay entry.
SURG_DELAY_STATIC_ID DOUBLE N OBSOLETE -- A value that is used to group together all versions of Surgical Delay entries. It remains static across all versions. When the first version is inserted, this value is equal to the surg_delay_id
SURG_START_DT_TM DATETIME Y The date and time this surgical encounter was started. This column was added to this table for reporting purposes
SURG_START_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
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 - SURGICAL_DELAY


Child Column in SURGICAL_DELAY(FK) Parent Table Name Parent Column Name
Parents: DELAY_DOC_BY_ID PRSNL PERSON_ID
DELAY_OBSERVE_BY_ID PRSNL PERSON_ID
DELAY_REPORT_TO_ID PRSNL PERSON_ID
SEGMENT_HEADER_ID SEGMENT_HEADER SEGMENT_HEADER_ID
SURG_CASE_ID SURGICAL_CASE SURG_CASE_ID


SURGICAL_PROCEDURE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Surgical Procedure
Definition: Contains the attributes of an order catalog entry specific to a surgical procedure
Table Type: REFERENCE





Column Detail - SURGICAL_PROCEDURE


Column Name Type Null? Definition
CATALOG_CD DOUBLE N A reference (foreign key) to the order_catalog table indicating the order catalog entry associated with this surgical procedure
CLEANUP_TIME DOUBLE Y ** OBSOLETE** This column becomes obsolete when new table SURGE_PROC_DETAIL is implemented. Cleanup time required for the procedure in Minutes
CREATE_APPLCTX DOUBLE Y Create Appltication ContextColumn
CREATE_DT_TM DATETIME Y Create Date and TimeColumn
CREATE_PRSNL_ID DOUBLE Y Create Personnel IdColumn
CREATE_TASK DOUBLE Y Create TaskColumn
DEF_ANESTH_TYPE_CD DOUBLE N ** OBSOLETE** This column becomes obsolete when new table SURGE_PROC_DETAIL is implemented. The default anesthesia type associated with this surgical procedure
DEF_CASE_LEVEL_CD DOUBLE N ** OBSOLETE** This column becomes obsolete when new table SURGE_PROC_DETAIL is implemented. The default case level associated with this surgical procedure, i.e. Routine 1 Circ 1 Scrub
DEF_PROC_DUR DOUBLE Y ** OBSOLETE** This column becomes obsolete when new table SURGE_PROC_DETAIL is implemented. The default duration associated with this surgical procedure
DEF_WOUND_CLASS_CD DOUBLE N ** OBSOLETE** This column becomes obsolete when new table SURGE_PROC_DETAIL is implemented. The default wound class associated with this surgical procedure
FROZEN_SECTION_REQ_IND DOUBLE Y ** OBSOLETE** This column becomes obsolete when new table SURGE_PROC_DETAIL is implemented. An indicator of whether or not a frozen section is required for this surgical procedure
SETUP_TIME DOUBLE Y ** OBSOLETE** This column becomes obsolete when new table SURGE_PROC_DETAIL is implemented. Setup Time
SPEC_REQ_IND DOUBLE Y ** OBSOLETE** This column becomes obsolete when new table SURGE_PROC_DETAIL is implemented. An indicator of whether or not a specimen is required for this surgical procedure. This indicator will be used when the Intraoperative Record is being verified.
SURG_SPECIALTY_ID DOUBLE N ** OBSOLETE** This column becomes obsolete when new table SURGE_PROC_DETAIL is implemented. The surgical specialty associated with this surgical procedure. Corresponds to the CDF Meaning of "SURGSPEC" on the prsnl_group table.
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 - SURGICAL_PROCEDURE


Child Column in SURGICAL_PROCEDURE(FK) Parent Table Name Parent Column Name
Parents: CATALOG_CD ORDER_CATALOG CATALOG_CD
SURG_SPECIALTY_ID PRSNL_GROUP PRSNL_GROUP_ID


SURGICAL_STAFF



Column Section Relationship Section Top of Page


Table-level Detail

Description: Surgical Staff
Definition: Surgical Staff Table
Table Type: REFERENCE





Column Detail - SURGICAL_STAFF


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.
BEG_EFFECTIVE_DT_TM DATETIME Y The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
CREATE_APPLCTX DOUBLE Y Create Application ContextColumn
CREATE_DT_TM DATETIME Y Create Date and time of the rowColumn
CREATE_PRSNL_ID DOUBLE N Prsnl Id of the person creating the rowColumn
CREATE_TASK DOUBLE Y The Application task that created the row.
DEF_DAYS DOUBLE Y Default days the surgical staff person works Saturday is 1, sunday is 2, Monday is 4..
DEF_ROLE_CD DOUBLE N Default Role for the Personnel
DEF_SHIFT_CD DOUBLE N Default Shift the Person works
DEF_SURG_OP_LOC_CD DOUBLE N Default Operating Room the Person works in
DEF_TEAM_CD DOUBLE N Default team the person works in
END_EFFECTIVE_DT_TM DATETIME Y The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
SURG_AREA_CD DOUBLE N Surgical Area the Staff is associated with
SURG_STAFF_ID DOUBLE N Unique Sequence Number for this table
UPDT_APPLCTX DOUBLE N 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 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. 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 N 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 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. 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 N 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 - SURGICAL_STAFF


Child Column in SURGICAL_STAFF(FK) Parent Table Name Parent Column Name
Parents: PERSON_ID PRSNL PERSON_ID