Table Detail Report

SURG_PROC_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Surgical Procedure Detail
Definition: Contains the default attributes associated with a surgical procedure for a specific surgical area.
Table Type: REFERENCE





Column Detail - SURG_PROC_DETAIL


Column Name Type Null? Definition
ANESTHESIA_TYPE_CD DOUBLE N The default anesthesia type associated with this surgical procedure and area.
BLOOD_PRODUCT_REQ_IND DOUBLE N An indicator of whether blood products are required for this surgical procedure and area.
CASE_LEVEL_CD DOUBLE N The default case level (such as Routine 1 Circ 1 Scrub) associated with this procedure and area.
CATALOG_CD DOUBLE N A reference (foreign key) to the ORDER_CATALOG table indicating the order catalog entry associated with this surgical procedure.
FROZEN_SECTION_REQ_IND DOUBLE N An indicator of whether a frozen section is required for this surgical procedure and area.
IMPLANT_IND DOUBLE N An indicator of whether an implant is required for this surgical procedure and area.
PROC_CNT DOUBLE N The number of procedures that are actually represented by this surgical procedure and area. If this is a combination of procedures, this will be greater than one.
SPEC_REQ_IND DOUBLE N An indicator of whether a specimen is required for this surgical procedure and area. This indicator will be used when the Intraoperative Record is being verified.
SURG_AREA_CD DOUBLE N The surgical area associated with this procedure.
SURG_PROC_DETAIL_ID DOUBLE N The Primary Key, uniquely identifying a procedure / area relation.
SURG_SPECIALTY_ID DOUBLE N Surgical Specialty ID. FK from PRSNL_GROUP.
UD1_CD DOUBLE N This is a user-defined, codified default for this surgical procedure and area.
UD2_CD DOUBLE N This is a user-defined, codified default for this surgical procedure and area.
UD3_CD DOUBLE N This is a user-defined, codified default for this surgical procedure and area.
UD4_CD DOUBLE N This is a user-defined, codified default for this surgical procedure and area.
UD5_CD DOUBLE N This is a user-defined, codified default for this surgical procedure and area.
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.
WOUND_CLASS_CD DOUBLE N The default wound class associated with this procedure and area.
XRAY_IND DOUBLE N An indicator of whether an Xray is required for this surgical procedure and area.
XRAY_TECH_IND DOUBLE N An indicator of whether an Xray technician is required for this surgical procedure and area.



Relationship Detail - SURG_PROC_DETAIL


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




Parent Column in SURG_PROC_DETAIL (PK) Child Table Name Child Column Name
Children: SURG_PROC_DETAIL_ID SURG_PROC_DURATION SURG_PROC_DETAIL_ID


SURG_PROC_DURATION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Surgical Procedure Duration
Definition: Contains the default durations for a specific surgical procedure, surgical area, and surgeon.
Table Type: REFERENCE





Column Detail - SURG_PROC_DURATION


Column Name Type Null? Definition
DEF_CLEANUP_DUR DOUBLE N The default cleanup duration associated with this procedure, area, and surgeon.
DEF_POST_CLOSURE_DUR DOUBLE N The default post-closure duration associated with this procedure, area, and surgeon.
DEF_PRE_INCISION_DUR DOUBLE N The default pre-incision duration associated with this procedure, area, and surgeon.
DEF_PROCEDURE_DUR DOUBLE N The default procedure duration associated with this procedure, area, and surgeon.
DEF_SETUP_DUR DOUBLE N The default setup duration associated with this procedure, area, and surgeon.
HIST_CLEANUP_DUR DOUBLE N The historical cleanup duration associated with this procedure, area, and surgeon.
HIST_POST_CLOSURE_DUR DOUBLE N The historical post-closure duration associated with this procedure, area, and surgeon.
HIST_PRE_INCISION_DUR DOUBLE N The historical pre-incision duration associated with this procedure, area, and surgeon.
HIST_PROCEDURE_DUR DOUBLE N The historical procedure duration associated with this procedure, area, and surgeon.
HIST_SETUP_DUR DOUBLE N The historical setup duration associated with this procedure, area, and surgeon.
PRSNL_ID DOUBLE N Personnel ID of the surgeon to whom these default durations are associated. If this value is 0, the values are generic durations for the procedure and area.
REC_CLEANUP_DUR DOUBLE N The recent cleanup duration associated with this procedure, area, and surgeon.
REC_POST_CLOSURE_DUR DOUBLE N The recent post-closure duration associated with this procedure, area, and surgeon.
REC_PRE_INCISION_DUR DOUBLE N The recent pre-incision duration associated with this procedure, area, and surgeon.
REC_PROCEDURE_DUR DOUBLE N The recent procedure duration associated with this procedure, area, and surgeon.
REC_SETUP_DUR DOUBLE N The recent setup duration associated with this procedure, area, and surgeon.
SURG_PROC_DETAIL_ID DOUBLE N A reference (foreign key) to the SURG_PROC_DETAIL table indicating the entry associated with this surgical procedure.
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 - SURG_PROC_DURATION


Child Column in SURG_PROC_DURATION(FK) Parent Table Name Parent Column Name
Parents: PRSNL_ID PRSNL PERSON_ID
SURG_PROC_DETAIL_ID SURG_PROC_DETAIL SURG_PROC_DETAIL_ID


SURG_RESOURCE_STATUS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Surgery Resource Status
Definition: This table will store status from Surginet Gap checking
Table Type: REFERENCE





Column Detail - SURG_RESOURCE_STATUS


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.
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 N 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 N 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.
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.
RESOURCE_STATUS_CD DOUBLE N Bed status code from code set 291.
SERVICE_RESOURCE_CD DOUBLE N Foreign Key from Service Resource Table
SURG_RESOURCE_STATUS_ID DOUBLE N Primary key 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 - SURG_RESOURCE_STATUS


Child Column in SURG_RESOURCE_STATUS(FK) Parent Table Name Parent Column Name
Parents: SERVICE_RESOURCE_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD