Table Detail Report

SURGICAL_STAFF_AVAILABILITY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Surgical Staff Availability
Definition: Identifies the detailed availability of surgical staff
Table Type: REFERENCE





Column Detail - SURGICAL_STAFF_AVAILABILITY


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.
ADD_ON_IND DOUBLE N Identifies the staff availability row as loaded from a foreign system (0) or added from within Surginet (1). Default = 0
CREATE_APPLCTX DOUBLE Y The application context number from the record info block.
CREATE_DT_TM DATETIME Y The date and time the record was created
CREATE_PRSNL_ID DOUBLE N The personnel ID of the person who created the row in the table
CREATE_TASK DOUBLE Y The registered (assigned) task number for the process that inserted the row.
END_DT_TM DATETIME N The date and time for which a specific personnel is scheduled to end work.
PRSNL_ID DOUBLE N This is the value of the unique primary identifier of the PRSNL table. It is an internal system assigned number.
START_DT_TM DATETIME N The date and time for which a specific personnel is scheduled to start work.
SURGICAL_STAFF_AVAILABILITY_ID DOUBLE N unique sequence number for this table
SURG_AREA_CD DOUBLE N Surgical area the staff personnel is associated with.
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_STAFF_AVAILABILITY


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


SURGICAL_TEAM



Column Section Relationship Section Top of Page


Table-level Detail

Description: Surgical Team
Definition: Surgical Team Table
Table Type: REFERENCE





Column Detail - SURGICAL_TEAM


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.
CREATE_APPLCTX DOUBLE Y Application context that was responsible for creating this row
CREATE_DT_TM DATETIME Y Date and Time the row was created
CREATE_PRSNL_ID DOUBLE N Person responsible for creation of this row
CREATE_TASK DOUBLE Y Application task responsible for Creating this Row
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
SURGICAL_TEAM_ID DOUBLE N This is the value of the unique primary identifier of the Surgical Team table. It is an internal system assigned number.
SURG_AREA_CD DOUBLE N Surgical Area the Team is associated with
TEAM_CD DOUBLE N Surgical Team Code
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_TEAM


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


SURG_CASE_PROCEDURE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Surgical Case Procedure
Definition: Surgical Case Procedure Table
Table Type: ACTIVITY





Column Detail - SURG_CASE_PROCEDURE


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.
ANESTH_TYPE_CD DOUBLE N Used for Surgery Mgmt Reporting -- indicates the anesthesia type assoc. w/ this case
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.
CONCURRENT_IND DOUBLE Y Concurrent Indicator - Specifies that the procedure is concurrent with the previous procedure in the sequence.
CREATE_APPLCTX DOUBLE Y Create Application ContextColumn
CREATE_DT_TM DATETIME Y Create Date and TimeColumn
CREATE_PRSNL_ID DOUBLE N Create Personnel IdColumn
CREATE_TASK DOUBLE Y Create TaskColumn
DEPT_CD DOUBLE N Used for Surgery Mgmt Reporting -- indicates the department assoc. w/ this procedure
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.
EVENT_ID DOUBLE N Event IdColumn
INST_CD DOUBLE N Used for Surgery Mgmt Reporting -- indicates the institution assoc. w/ this procedure
MODIFIER VARCHAR(500) Y Used for Surgery Mgmt Reporting -- the modifiers documented for this procedure
ORDER_ID DOUBLE N Order IdColumn
PICK_LIST_CHG_FLAG DOUBLE Y Pick List Change FlagColumn
PREF_CARD_ID DOUBLE N Preference Card Id for the procedure
PRIMARY_PROC_IND DOUBLE Y Primary Procedure IndicatorColumn
PRIMARY_SURGEON_ID DOUBLE N Primary Surgeon Id for the CaseColumn
PROC_COMPLETE_QTY DOUBLE Y Used for Surgery Mgmt Reporting -- indicates the completion of this procedure
PROC_DUR_MIN DOUBLE Y Used for Surgery Mgmt Reporting -- indicates the duration of this procedure
PROC_END_DT_TM DATETIME Y Procedure End Date and TimeColumn
PROC_END_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
PROC_START_DAY DOUBLE Y Used for Surgery Mgmt Reporting -- indicates the day of the week this Procedure started
PROC_START_DT_TM DATETIME Y Procedure Start Date and TimeColumn
PROC_START_HOUR DOUBLE Y Used for Surgery Mgmt Reporting -- indicates the hour of the day this procaedure started at
PROC_START_MONTH DOUBLE Y Used for Surgery Mgmt Reporting -- indicates the month this case is Procedure started at
PROC_START_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
PROC_TEXT VARCHAR(255) Y Procedure TextColumn
REPORTING_PROC_IND DOUBLE Y Reporting Procedure IndicatorColumn
SCHED_ANESTH_TYPE_CD DOUBLE N Scheduled Anesthesia Type CodeColumn
SCHED_BLOOD_PRODUCT_REQ_IND DOUBLE N A scheduled indicator of whether blood products are required for this surgical procedure.
SCHED_CASE_LEVEL_CD DOUBLE N The scheduled case level (such as Routine 1 Circ 1 Scrub) for this procedure.
SCHED_DUR DOUBLE Y Scheduled Duration of the procedure
SCHED_FROZEN_SECTION_REQ_IND DOUBLE N A scheduled indicator of whether a frozen section is required for this surgical procedure.
SCHED_IMPLANT_IND DOUBLE N A scheduled indicator of whether an implant is required for this surgical procedure.
SCHED_MODIFIER VARCHAR(100) Y Used for Surgery Mgmt Reporting -- the modifiers scheduled for this procedure
SCHED_PRIMARY_IND DOUBLE Y Used for Surgery Mgmt Reporting -- indicates whether this procedure was scheduled as the primary
SCHED_PRIMARY_SURGEON_ID DOUBLE N Scheduled Primary Surgeon IdColumn
SCHED_PROC_CNT DOUBLE N The scheduled number of procedures that are actually represented by this surgical procedure. If this is a combination of procedures, this will be greater than one.
SCHED_QTY DOUBLE Y Used for Surgery Mgmt Reporting -- indicates that this procedure has been scheduled
SCHED_SEQ_NUM DOUBLE Y Scheduled Sequnce number of the procedure
SCHED_SPEC_REQ_IND DOUBLE N An scheduled indicator of whether a specimen is required for this surgical procedure.
SCHED_SURG_AREA_CD DOUBLE N Scheduled Surgical Area
SCHED_SURG_PROC_CD DOUBLE N Scheduled Surgical Procedure CodeColumn
SCHED_SURG_SPECIALTY_ID DOUBLE N Used for Surgery Mgmt Reporting -- the surgical specialty scheduled for this procedure
SCHED_UD1_CD DOUBLE N The scheduled value of the first user-defined field for this surgical procedure.
SCHED_UD2_CD DOUBLE N The scheduled value of the second user-defined field for this surgical procedure.
SCHED_UD3_CD DOUBLE N The scheduled value of the third user-defined field for this surgical procedure.
SCHED_UD4_CD DOUBLE N The scheduled value of the fourth user-defined field for this surgical procedure.
SCHED_UD5_CD DOUBLE N The scheduled value of the fifth user-defined field for this surgical procedure.
SCHED_WOUND_CLASS_CD DOUBLE N The scheduled wound class for this procedure.
SCHED_XRAY_IND DOUBLE N A scheduled indicator of whether an Xray is required for this surgical procedure.
SCHED_XRAY_TECH_IND DOUBLE N A scheduled indicator of whether an Xray technician is required for this surgical procedure.
SEGMENT_HEADER_ID DOUBLE N Segment Header IDColumn
SPEC_NOT_COLLECTED_REASON_CD DOUBLE N Specimen Not collected Reason Code
SURG_AREA_CD DOUBLE N Surgical Area CodeColumn
SURG_CASE_ID DOUBLE N Surgical Case IDColumn
SURG_CASE_PROC_ID DOUBLE N Surgical Case Procedure ID - the unique number on this table to identity the row
SURG_PROC_CD DOUBLE N Surgical Procedure CodeColumn
SURG_SPECIALTY_ID DOUBLE N Surgical Specialty IDColumn
SYNONYM_ID DOUBLE N Synonym 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.
WOUND_CLASS_CD DOUBLE N Wound Class CodeColumn



Relationship Detail - SURG_CASE_PROCEDURE


Child Column in SURG_CASE_PROCEDURE(FK) Parent Table Name Parent Column Name
Parents: ORDER_ID ORDERS ORDER_ID
SYNONYM_ID ORDER_CATALOG_SYNONYM SYNONYM_ID
PRIMARY_SURGEON_ID PRSNL PERSON_ID
SCHED_PRIMARY_SURGEON_ID PRSNL PERSON_ID
SCHED_SURG_SPECIALTY_ID PRSNL_GROUP PRSNL_GROUP_ID
SURG_SPECIALTY_ID PRSNL_GROUP PRSNL_GROUP_ID
SEGMENT_HEADER_ID SEGMENT_HEADER SEGMENT_HEADER_ID
SURG_CASE_ID SURGICAL_CASE SURG_CASE_ID




Parent Column in SURG_CASE_PROCEDURE (PK) Child Table Name Child Column Name
Children: SURG_CASE_PROC_ID CASE_CART_PICK_LIST SURG_CASE_PROC_ID
IMPLANT_HISTORY SURG_CASE_PROC_ID
LH_CNT_IC_PATIENT_READ_SRG SURG_CASE_PROC_ID
SCHED_CASE_PICK_LIST SURG_CASE_PROC_ID
SN_PICKLIST_REQUEST SURG_CASE_PROC_ID
SN_PICKLIST_REQUEST_PC SURG_CASE_PROC_ID
SN_PICKLIST_USE SURG_CASE_PROC_ID
SN_SURG_CASE_PROC_CPT SURG_CASE_PROC_ID
SN_SURG_CASE_PROC_DOC SURG_CASE_PROC_ID
SURG_CASE_PROC_MODIFIER SURG_CASE_PROC_ID


SURG_CASE_PROC_MODIFIER



Column Section Relationship Section Top of Page


Table-level Detail

Description: Surgical Case Procedure Modifier
Definition: Surgical Case Procedure Modifier Table
Table Type: ACTIVITY





Column Detail - SURG_CASE_PROC_MODIFIER


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 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 N The Application Context creating the row
CREATE_DT_TM DATETIME N Create Date and TimeColumn
CREATE_PRSNL_ID DOUBLE N Create Personnel IdColumn
CREATE_TASK DOUBLE N Create TaskColumn
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.
MODIFIER_CD DOUBLE N Modifier CodeColumn
MODIFIER_SEQ DOUBLE N Sequence Number of the modifier
SURG_CASE_PROC_ID DOUBLE N Surgical Case Procedure IDColumn
SURG_CASE_PROC_MOD_ID DOUBLE N Unique 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.



Relationship Detail - SURG_CASE_PROC_MODIFIER


Child Column in SURG_CASE_PROC_MODIFIER(FK) Parent Table Name Parent Column Name
Parents: SURG_CASE_PROC_ID SURG_CASE_PROCEDURE SURG_CASE_PROC_ID


SURG_NEXT_VAL



Column Section Top of Page


Table-level Detail

Description: Surgery Next Value
Definition: Contains the next value to use for generating an OR Case Number
Table Type: REFERENCE





Column Detail - SURG_NEXT_VAL


Column Name Type Null? Definition
NEXT_VAL DOUBLE Y The next value to use when generating an OR Case Number when creating a case in Surgical Case Manager.
NEXT_VAL_ID DOUBLE N The primary key, uniquely identifying a row on this table
NEXT_VAL_QUALIFIER_CD DOUBLE N The surgical area associated with this next value row
NEXT_VAL_TYPE_FLAG DOUBLE Y The type of next value, i.e. current year, next year
NEXT_VAL_YEAR DOUBLE Y The year associated with this next value row -- to be used in the OR Case Number.
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.