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. |