CASE_ATTENDANCE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Case Attendance
Definition: Contains attendees in a surgical case, including the role being performed
Table Type: ACTIVITY





Column Detail - CASE_ATTENDANCE


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.
ATTENDEE_FREE_TEXT_NAME VARCHAR(100) Y Free Text Name of the attendee. This is to be filled out if the Attendee is not on the PRSNL table.
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.
CASE_ATTENDANCE_ID DOUBLE N This is the unique identifier for the table. It identifies the record on the table.
CASE_ATTENDEE_ID DOUBLE N The PERSON ID of the attendee, if known. If this is not filled out the CASE_ATTENDEE_FREE_TEXT_NAME has to be filled out.
CASE_ATTEND_STATIC_ID DOUBLE N Case Attendance Static ID, is the Case Attendee ID of the original record.
CREATE_APPLCTX DOUBLE Y This is the application context creating the record
CREATE_DT_TM DATETIME Y Create Date and Time
CREATE_PRSNL_ID DOUBLE N The PRSNL ID of the person creating the record.
CREATE_TASK DOUBLE Y The task creating the record
DEF_IND DOUBLE Y This indicates if the record is a defaulted entry.
DISPLAY_SEQ DOUBLE Y Display sequence
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.
IN_DT_TM DATETIME Y Begin Date and Time of the Attendee for the Case
IN_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
OUT_DT_TM DATETIME Y Begin Date and Time of the Attendee for the Case
OUT_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
PROC_SPECIFIED_IND DOUBLE Y Procedure specified indicator. OBSOLETE
REASON_FOR_RELIEF_CD DOUBLE N Reason for relief code - This is not a Code Value. The value is a Foreign Key from the Nomenclature table.
RESULT_STATUS_FLAG DOUBLE Y The result status of the current entry
ROLE_PERF_CD DOUBLE N Role Performed Code
SEGMENT_HEADER_ID DOUBLE N The SEGMENT_HEADER_ID for the segment.
SIGNING_ATTENDEE_IND DOUBLE Y Signing attendee indicator
SURG_AREA_CD DOUBLE N The surgical area, where the case is being performed.
SURG_CASE_ID DOUBLE N Surgical Case Id
SURG_START_DT_TM DATETIME Y Surgery Start Date and Time
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 - CASE_ATTENDANCE


Child Column in CASE_ATTENDANCE(FK) Parent Table Name Parent Column Name
Parents: CASE_ATTENDEE_ID PRSNL PERSON_ID
SEGMENT_HEADER_ID SEGMENT_HEADER SEGMENT_HEADER_ID
SURG_CASE_ID SURGICAL_CASE SURG_CASE_ID


CASE_CART



Column Section Relationship Section Top of Page


Table-level Detail

Description: Case Cart
Definition: This table contains case cart information for a surgical case.
Table Type: ACTIVITY





Column Detail - CASE_CART


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.
CASE_CART_ID DOUBLE N The primary key, uniquely identifying a row on this table
COMMENT_ID DOUBLE N *** OBSOLETE ***
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
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
DOC_TYPE_CD DOUBLE N The document type that this case cart is associated with.
FINALIZE_DT_TM DATETIME Y The date and time the case cart was finalized
LOCKED_APPLCTX DOUBLE Y The application context locking the record
MODIFIED_IND DOUBLE Y An indicator of whether or not this case cart has been modified, i.e. requested quantity changed, item added or deleted
PREF_CARD_TYPE_FLAG DOUBLE Y *** OBSOLETE ***
PRINT_DT_TM DATETIME Y *** OBSOLETE ***
REQUISITION_ID DOUBLE N *** OBSOLETE ***
SURG_AREA_CD DOUBLE N The surgical area associated with this case cart
SURG_CASE_ID DOUBLE N The surgical case associated with this case cart
TOT_EQUIP_COST_AVG DOUBLE Y The total equipment cost (average cost) of all equipment items associated with this case cart.
TOT_EQUIP_COST_LAST DOUBLE Y The total equipment cost (last cost) of all equipment items associated with this case pick list.
TOT_SUPPLY_COST_AVG DOUBLE Y The total supply cost (average cost) of all supply items associated with this case pick list.
TOT_SUPPLY_COST_LAST DOUBLE Y The total supply cost (last cost) of all supply items associated with this case pick list.
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.
VERIFIED_BY_ID DOUBLE N The person responsible for verifying this case cart
VERIFIED_DT_TM DATETIME Y The date and time this case cart pick list was verified



Relationship Detail - CASE_CART


Child Column in CASE_CART(FK) Parent Table Name Parent Column Name
Parents: VERIFIED_BY_ID PRSNL PERSON_ID
SURG_CASE_ID SURGICAL_CASE SURG_CASE_ID




Parent Column in CASE_CART (PK) Child Table Name Child Column Name
Children: CASE_CART_ID CASE_CART_PICK_LIST CASE_CART_ID


CASE_CART_PICK_LIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Case Cart Pick List
Definition: Contains all of the items on a case cart pick list, including requested qty, fill qty, used qty, returned qty, wasted qty, charge qty
Table Type: ACTIVITY





Column Detail - CASE_CART_PICK_LIST


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.
AVG_COST DOUBLE Y Average cost of the pick list item.
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.
CASE_CART_ID DOUBLE N A reference (foreign key) to the case_cart table indicating the case cart associated with this case cart pick list item
CASE_CART_PICK_LIST_ID DOUBLE N The primary key, uniquely identifying a row on this table
CHARGE_DUR DOUBLE Y The duration to be used in calculating charges associated with this case cart pick list item
CHARGE_QTY DOUBLE Y Charge Qty for the Pick List Item
CHARGE_UNITS DOUBLE Y The units to be used in calculating the charges associated with this case cart pick list item
COST DOUBLE Y Cost of the Pick List Item
COST_TYPE_CD DOUBLE N The cost associated with the item for departmental charging and general ledger updates
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
CURRENT_IND DOUBLE Y An indicator of whether or not this is a current item on the case cart pick list
DUP_IND DOUBLE Y An indicator of whether or not this case cart pick list item is a duplicate with an item from another procedure (for multiple procedure cases only)
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.
FILL_LOCN_CD DOUBLE N The inventory location this case cart pick list item was filled from
FILL_QTY DOUBLE Y The quantity of this item that was filled
FREE_TEXT_ITEM_DESC VARCHAR(200) Y A free-text description of this case cart pick list item. This column will only be populated if the item is not found in the item_master table.
HOLD_QTY DOUBLE Y The requested hold quantity for this item. Defaulted from the preference card
ITEM_ID DOUBLE N Item Id for the Pick List Item
LAST_COST DOUBLE Y Last cost of the pick list item.
LINE_ITEM_ID DOUBLE N A reference to the line_item table indicating which line item on the requisition this pick list item refers to
MERGED_ITEM_FLAG DOUBLE Y An indicator of whether this duplicate item has been merged
OBJECT_TYPE_FLAG DOUBLE Y An indicator of the type of object this free-text case cart pick list item is, i.e. Equipment, Medication, Implant
OPEN_QTY DOUBLE Y The requested open quantity associated with this case cart pick list item
PARENT_ENTITY_ID DOUBLE N A reference to either the order_catalog table or the item_definition table depending on the type of item -- either inventory item or medication
PARENT_ENTITY_NAME VARCHAR(32) Y The name of the table this item is associated with -- either order_catalog or item_definition, depending on the type of item (inventory item or medication)
PARENT_PACK_ID DOUBLE N The parent pack id if this item is a component of a pack, else it is 0.
PREF_CARD_TYPE_FLAG DOUBLE Y The type of preference card associated with this case cart pick list item, i.e. surgeon/procedure
QTY_USED DOUBLE Y The quantity of this case cart pick list item that was used
REQUEST_QTY DOUBLE Y The quantity of this case cart pick list item that was requested
RETURN_LOCN_CD DOUBLE N The inventory location that this case cart pick list item was returned to.
RETURN_QTY DOUBLE Y The quantity of this case cart pick list item that was returned
STATUS_FLAG DOUBLE Y NOT CURRENTLY BEING USED (always being set to 1)
SURG_CASE_ID DOUBLE N A reference (foreign key) to the surgical_case table indicating the surgical case associated with this case cart pick list item
SURG_CASE_PROC_ID DOUBLE N Surgical Case Procedure associated with this Pick List Item
SURG_PROC_GRP_DET_ID DOUBLE N A reference (foreign key) to the surg_proc_group_detail indicating the surgical procedure/group associated with this case cart pick list item
SURG_PROC_GRP_ID DOUBLE N **OBSOLETE**A reference (foreign key) to the surgical_procedure_group table indicating the surgical procedure group associated with this case cart pick list item
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.
WASTED_QTY DOUBLE Y The quantity of this case cart pick list item that was wasted
WASTED_REASON_CD DOUBLE N The reason this pick list item was wasted



Relationship Detail - CASE_CART_PICK_LIST


Child Column in CASE_CART_PICK_LIST(FK) Parent Table Name Parent Column Name
Parents: CASE_CART_ID CASE_CART CASE_CART_ID
ITEM_ID ITEM_MASTER ITEM_ID
SURG_CASE_ID SURGICAL_CASE SURG_CASE_ID
SURG_CASE_PROC_ID SURG_CASE_PROCEDURE SURG_CASE_PROC_ID




Parent Column in CASE_CART_PICK_LIST (PK) Child Table Name Child Column Name
Children: CASE_CART_PICK_LIST_ID SCHED_CASE_PICK_LIST CASE_CART_PICK_LIST_ID


CASE_TIMES



Column Section Relationship Section Top of Page


Table-level Detail

Description: Case Times
Definition: The times associated with this surgical case, i.e. Surgery Start/Stop Time, Patient In/Out of Room Time, etc.
Table Type: ACTIVITY





Column Detail - CASE_TIMES


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.
CASE_TIMES_ID DOUBLE N The primary key, uniquely identifying a row on this table. This value is unique for all versions of a given case time for a case.
CASE_TIMES_STATIC_ID DOUBLE N OBSOLETE -- A value that is used to group together all versions of Case Times entries. It remains static across all versions. When the first version is inserted, this value is equal to the case_times_id.
CASE_TIME_DT_TM DATETIME Y The date and time associated with this case time entry.
CASE_TIME_MEANING CHAR(12) Y OBSOLETE -- The CDF meaning (on the Discrete Task Assay codeset) associated with this case time entry, i.e. SURGSTART. Used to apply application logic to a specific case time.
CASE_TIME_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
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
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 case times entry, i.e. New Unverified, Corrected, etc.
SEGMENT_HEADER_ID DOUBLE N A reference (foreign key) to the segment_header table indicating the status of this segment, i.e. Accessed, Discontinued, etc.
STAGE_CD DOUBLE N The surgical staging area associated with this Case Times entry
SURG_CASE_ID DOUBLE N Surgical Case Identifier
TASK_ASSAY_CD DOUBLE N Task Assay Code from the Form for Case Times
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 - CASE_TIMES


Child Column in CASE_TIMES(FK) Parent Table Name Parent Column Name
Parents: SEGMENT_HEADER_ID SEGMENT_HEADER SEGMENT_HEADER_ID
SURG_CASE_ID SURGICAL_CASE SURG_CASE_ID


CONDITIONAL_BEHAVIOR



Column Section Relationship Section Top of Page


Table-level Detail

Description: CONDITIONAL BEHAVIOR
Definition: Conditional behavior definitions for formbuilder forms.
Table Type: REFERENCE





Column Detail - CONDITIONAL_BEHAVIOR


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.
BEHAVIOR_FLAG DOUBLE Y Defines the behavior of the condition.
CONDITION_CONTROL_CD DOUBLE N The control which value defines the behavior.
CONDITION_FLAG DOUBLE Y The test to apply to the value of the control.
CONDITION_ID DOUBLE N Unique identifier of the condition.
DATA_STATUS_CD DOUBLE N Data status indicates a level of authenticity of the row data. Typically this will either be AUTHENTICATED or UNAUTHENTICATED.
DATA_STATUS_DT_TM DATETIME Y The date and time that the data_status_cd was set.
DATA_STATUS_PRSNL_ID DOUBLE N The person who caused the data_status_cd to be set or change.
EFFECTED_CONTROL_CD DOUBLE N The control that has the behavior applied to it.
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.
INPUT_FORM_CD DOUBLE N The form that contains the two fields.
INPUT_FORM_VERSION_NBR DOUBLE Y The version of the form that contains the two fields.
RANGE_VALUE_1 VARCHAR(255) Y First value to test the condition against.
RANGE_VALUE_2 VARCHAR(255) Y Second value to test the condition against.
UPDT_APP DOUBLE Y Update application.
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_REQ DOUBLE Y Update request.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - CONDITIONAL_BEHAVIOR


Child Column in CONDITIONAL_BEHAVIOR(FK) Parent Table Name Parent Column Name
Parents: INPUT_FORM_CD INPUT_FORM_REFERENCE INPUT_FORM_CD
INPUT_FORM_VERSION_NBR INPUT_FORM_REFERENCE INPUT_FORM_VERSION_NBR