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 |