Table Detail Report

PERIOPERATIVE_DOCUMENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Perioperative Document
Definition: Contains the attributes of a perioperative document, including document type, status of document, etc.
Table Type: ACTIVITY





Column Detail - PERIOPERATIVE_DOCUMENT


Column Name Type Null? Definition
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
DOC_TERM_BY_ID DOUBLE N The person responsible for terminating this document
DOC_TERM_DT_TM DATETIME Y The date and time this document was terminated
DOC_TERM_REASON_CD DOUBLE N The reason this document was terminated
DOC_TERM_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
DOC_TYPE_CD DOUBLE N The document type associated with this perioperative document, i.e. OR Nursing Record, Preop Nursing Assessment, etc.
LAST_PRINT_DT_TM DATETIME Y Indicates the date and time of the last printing of the case document
LAST_PRINT_TZ DOUBLE Y Time zone for the last_print_dt_tm column.
LAST_VER_DT_TM DATETIME Y The date and time this document was last verified
LAST_VER_ID DOUBLE N The person responsible for verifying this document last
LAST_VER_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
LOCKED_APPLCTX DOUBLE Y Locked ApplicationContextColumn
LONG_TEXT_ID DOUBLE N *** OBSOLETE ***Column
ORIG_PRINT_DT_TM DATETIME Y Indicates the date and time of the original printing of the case document
ORIG_PRINT_TZ DOUBLE Y Time zone of the orig_print_dt_tm column.
PERIOP_DOC_ID DOUBLE N The primary key, uniquely identifying a perioperative document
PERIOP_DOC_TYPE_FLAG DOUBLE N *** OBSOLETE ***Column
REC_VER_DT_TM DATETIME Y The date and time this document was verified
REC_VER_ID DOUBLE N The person responsible for verifying this document
REC_VER_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
RETROSPECTIVE_DOC_IND DOUBLE Y An indicator of whether or not this document was documented retrospectively (outside of the OR).
ROOM_COST_PT_DUR DOUBLE Y The room cost associated with this perioperative document (calculated using patient in room duration)
ROOM_COST_SURG_DUR DOUBLE Y The room cost associated with this perioperative document (calculated using surgery duration)
SURG_AREA_CD DOUBLE N The surgical area associated with this perioperative document
SURG_CASE_ID DOUBLE N The surgical case associated with this perioperative document
TOT_ATTENDEE_COST DOUBLE Y The total cost of all attendees associated with this perioperative document
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 - PERIOPERATIVE_DOCUMENT


Child Column in PERIOPERATIVE_DOCUMENT(FK) Parent Table Name Parent Column Name
Parents: LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
DOC_TERM_BY_ID PRSNL PERSON_ID
LAST_VER_ID PRSNL PERSON_ID
REC_VER_ID PRSNL PERSON_ID
SURG_CASE_ID SURGICAL_CASE SURG_CASE_ID




Parent Column in PERIOPERATIVE_DOCUMENT (PK) Child Table Name Child Column Name
Children: PERIOP_DOC_ID SEGMENT_HEADER PERIOP_DOC_ID
SN_CE_EXTRACT_ST PERIOP_DOC_ID
SN_IMPLANT_LOG_ST PERIOP_DOC_ID
SN_SIGNATURE PERIOP_DOC_ID
SN_UNFINALIZE_REASON PERIOP_DOC_ID


PREFERENCE_CARD



Column Section Relationship Section Top of Page


Table-level Detail

Description: Preference Card
Definition: Contains the attributes of a surgeon/procedure preference card, including surgical specialty, historical average, etc.
Table Type: REFERENCE





Column Detail - PREFERENCE_CARD


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.
CATALOG_CD DOUBLE N The surgical procedure associated with this preference card
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
DATA_STATUS_CD DOUBLE N Data status indicates a level of authenticity of the row data. Typically this will either be AUTHENTICATED or UNAUTHENTICATED.
DOC_TYPE_CD DOUBLE N The type of document that this preference card is used for.
HIST_AVG_DUR DOUBLE Y The historical average duration for this surgeon performing this procedure.
LAST_USED_DT_TM DATETIME Y The date and time the Preference Card was used for documentation. This is updated on Finalize.
LOCKED_APPLCTX DOUBLE Y Locked Application ContextColumn
LONG_TEXT_ID DOUBLE N *** OBSOLETE ***Column
NUM_CASES_REC_AVG DOUBLE Y Number of cases to use for recent average
OVERRIDE_HIST_AVG_DUR DOUBLE Y An override value for the historical average duration for this preference card. Should only be used if the actual historical average duration has become very inaccurate. Once this is changed, the historical average duration will "roll into" the override value.
OVERRIDE_LOOKBACK_NBR DOUBLE Y The number of cases to lookback in calculating the Recent Average Duration.
OVERRIDE_TOT_NBR_CASES DOUBLE Y An override value for the total number of cases for this surgeon/procedure. This will be used in calculating the historical average duration.
PREF_CARD_ID DOUBLE N The primary key, uniquely identifying a preference card.
PREF_CARD_TYPE_FLAG DOUBLE Y *** OBSOLETE ***Column
PRSNL_ID DOUBLE N The provider associated with this preference card.
REC_AVG_DUR DOUBLE Y Recent Average DurationColumn
SURG_AREA_CD DOUBLE N The surgical area associated with this preference card
SURG_SPECIALTY_ID DOUBLE N The surgical specialty associated with this preference card, i.e. Orthopedics, ENT, etc. The value is a reference (foreign key) to the prsnl_group table with a CDF meaning of "SURGSPEC".
TEMPLATE_DESC_CD DOUBLE N *** OBSOLETE ***Column
TEMPLATE_IND DOUBLE Y *** OBSOLETE ***Column
TOT_NBR_CASES DOUBLE Y The total number of cases performed for this surgeon/procedure. Used in the calculation of historical average duration.
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 - PREFERENCE_CARD


Child Column in PREFERENCE_CARD(FK) Parent Table Name Parent Column Name
Parents: CATALOG_CD ORDER_CATALOG CATALOG_CD
PRSNL_ID PRSNL PERSON_ID
SURG_SPECIALTY_ID PRSNL_GROUP PRSNL_GROUP_ID




Parent Column in PREFERENCE_CARD (PK) Child Table Name Child Column Name
Children: PREF_CARD_ID PREF_CARD_PICK_LIST PREF_CARD_ID
PREF_CARD_SEGMENT PREF_CARD_ID
SCHED_CASE_PICK_LIST PREF_CARD_ID
SCH_PEND_SURG_ITEM PREF_CARD_ID
SN_PICKLIST_PREF_CARD_R PREF_CARD_ID
SN_PICKLIST_REQUEST_PC PREF_CARD_ID
SN_PREFCARD_MPAGE_SNOOZE PREF_CARD_ID
SN_SURG_CASE_PROC_DOC PREF_CARD_ID


PREF_CARD_DEFAULT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Preference Card Default
Definition: Contains attributes about a preference card default entry.
Table Type: REFERENCE





Column Detail - PREF_CARD_DEFAULT


Column Name Type Null? Definition
AUTO_SEQ_DEF_IND DOUBLE Y Indicates whether this default should automatically be populated in the Intraoperative Record.
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
DEFAULT_NAME VARCHAR(40) Y Default NameColumn
ENTRY_NBR DOUBLE N The entry number (sequence) for this preference card default. Only populated for repeating forms.
INPUT_GROUP_ID DOUBLE N *** OBSOLETE ***Column
INPUT_GROUP_SEQ DOUBLE Y *** OBSOLETE ***Column
PREF_CARD_DEF_ID DOUBLE N The primary key, uniquely identifying a preference card default entry.
PREF_CARD_SEG_ID DOUBLE N The documentation segment associated with this preference card default entry, i.e. Patient Positioning
TASK_ASSAY_CD DOUBLE N The input control associated with this preference card default entry. Contains a reference (foreign key) to the discrete_task_assay 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 - PREF_CARD_DEFAULT


Child Column in PREF_CARD_DEFAULT(FK) Parent Table Name Parent Column Name
Parents: PREF_CARD_SEG_ID PREF_CARD_SEGMENT PREF_CARD_SEG_ID




Parent Column in PREF_CARD_DEFAULT (PK) Child Table Name Child Column Name
Children: PREF_CARD_DEF_ID PREF_CARD_DEF_DETAIL PREF_CARD_DEF_ID


PREF_CARD_DEF_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Preference Card Default Detail
Definition: Contains the values associated with preference card default entries
Table Type: REFERENCE





Column Detail - PREF_CARD_DEF_DETAIL


Column Name Type Null? Definition
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
LONG_TEXT_ID DOUBLE N A reference (foreign key) to the long_text table indicating the text associated with this preference card default. This column is only populated if the accept length for the default detail is greater than 200 (defined in the Form Builder Design and Test Tool).
PREF_CARD_DEF_DETAIL_ID DOUBLE N The primary key, uniquely identifying a preference card default value.
PREF_CARD_DEF_ID DOUBLE N A reference (foreign key) to the pref_card_default table indicating the entry associated with this preference card default value.
PREF_CARD_DEF_TEXT_SEQ DOUBLE Y The sequence of a default value for repeating input controls. This column is only populated for free-text input controls.
PREF_CARD_DEF_VALUE VARCHAR(200) Y The value associated with this preference card default
PREF_CARD_DEF_VALUE_SEQ DOUBLE Y The sequence of this preference card default value (for repeating input controls).
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 - PREF_CARD_DEF_DETAIL


Child Column in PREF_CARD_DEF_DETAIL(FK) Parent Table Name Parent Column Name
Parents: LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
PREF_CARD_DEF_ID PREF_CARD_DEFAULT PREF_CARD_DEF_ID


PREF_CARD_PICK_LIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Preference Card Pick List
Definition: Contains the items on the preference card pick list
Table Type: REFERENCE





Column Detail - PREF_CARD_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.
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.
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
END_EFFECTIVE_DT_TM DATETIME N 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.
INVALID_ORG_ASSOC_IND DOUBLE N Indicates whether the item's organization association is valid for prefcard's organization
ITEM_ID DOUBLE N Item Id of the Item on the Item Definition Table
PARENT_ENTITY_ID DOUBLE N *** OBSOLETE ***Column
PARENT_ENTITY_NAME VARCHAR(32) Y *** OBSOLETE ***Column
PARENT_PACK_ID DOUBLE N *** OBSOLETE ***Column
PREF_CARD_ID DOUBLE N A reference (foreign key) to the PREFERENCE_CARD table indicating the preference card this pick list item is associated with.
PREF_CARD_PICK_LIST_ID DOUBLE N The primary key, uniquely identifying a preference card pick list item
REQUEST_HOLD_QTY DOUBLE Y The requested hold quantity for this pick list item
REQUEST_OPEN_QTY DOUBLE Y The requested open quantity for this pick list item
SCHED_ITEM_IND DOUBLE Y *** OBSOLETE ***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 - PREF_CARD_PICK_LIST


Child Column in PREF_CARD_PICK_LIST(FK) Parent Table Name Parent Column Name
Parents: ITEM_ID ITEM_DEFINITION ITEM_ID
PREF_CARD_ID PREFERENCE_CARD PREF_CARD_ID