Table Detail Report

PREF_CARD_RECENT_AVERAGE



Column Section Top of Page


Table-level Detail

Description: Preference Card Recent Average
Definition: Preference Card Recent Average Table
Table Type: ACTIVITY





Column Detail - PREF_CARD_RECENT_AVERAGE


Column Name Type Null? Definition
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
PREF_CARD_ID DOUBLE N The foreign key into the PREFERENCE_CARD table to indicate which preference card these averages refer to.
PREF_CARD_RECENT_AVG_ID DOUBLE N Primary KeyColumn
PREF_CARD_RECENT_PROC_DUR DOUBLE Y Recent Procedure DurationColumn
SURG_CASE_PROC_DOC_ID DOUBLE N The primary key to the SN_SURG_CASE_PROC_DOC 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.


PREF_CARD_SEGMENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Preference Card Segment
Definition: Contains the segments associated with a preference card. This list of segments will be used in Perioperative Document Manager when a case is scheduled with this surgeon/procedure
Table Type: REFERENCE





Column Detail - PREF_CARD_SEGMENT


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.
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
DEFAULTS_EXIST_IND DOUBLE Y An indicator of whether or not preference card defaults exist for this segment
INPUT_FORM_CD DOUBLE N *** OBSOLETE ***Column
LONG_TEXT_ID DOUBLE N *** OBSOLETE ***Column
PREF_CARD_ID DOUBLE N A reference (foreign key) to the preference_card table indicating the preference card associated with this segment
PREF_CARD_SEG_ID DOUBLE N The primary key, uniquely identifying a row on this table
SEG_CD DOUBLE N The segment associated with this preference card
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_SEGMENT


Child Column in PREF_CARD_SEGMENT(FK) Parent Table Name Parent Column Name
Parents: LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
PREF_CARD_ID PREFERENCE_CARD PREF_CARD_ID




Parent Column in PREF_CARD_SEGMENT (PK) Child Table Name Child Column Name
Children: PREF_CARD_SEG_ID PREF_CARD_DEFAULT PREF_CARD_SEG_ID


SCHED_CASE_PICK_LIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scheduled Case Pick List
Definition: Contains the resources scheduled for the case.
Table Type: ACTIVITY





Column Detail - SCHED_CASE_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 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_PICK_LIST_ID DOUBLE N This is the unique identifier on the Parent table, CASE_CART_PICK_LIST. This is filled out only if the Case Cart is generated.
CHANGE_FLAG DOUBLE Y The change type for this row from the Preference_Card
CREATE_APPLCTX DOUBLE Y The application context number from the record info block.
CREATE_DT_TM DATETIME Y The Date and Time this row was created
CREATE_PRSNL_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the insert or of the row in the table.
CREATE_TASK DOUBLE Y The registered (assigned) task number for the process that inserted or updated the row.
DOC_TYPE_CD DOUBLE N The Document Type Code for which the Resource is scheduled for.
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 location that the item was scheduled to be filled from.
HOLD_QTY DOUBLE Y The Quantity this item has to be ON-HOLD
ITEM_ID DOUBLE N The Item ID, the unique identifier on the ITEM_MASTER.
OPEN_QTY DOUBLE Y The Quantity of Items that are scheduled to be Open
ORDER_ID DOUBLE N The Order ID, unique identifier of the Order this item is scheduled for.
PREF_CARD_ID DOUBLE N Referenced to a preference card.
PREF_CARD_PICK_LIST_ID DOUBLE N The Preference Card Pick List ID of the item, if it is from a PREFERENCE_CARD. If the item is not on a PREFERENCE_CARD, this will be 0.
SCHED_CASE_PICK_LIST_ID DOUBLE N The unique sequence number that is generated from the surgery_seq
SCH_EVENT_ID DOUBLE N The Scheduled Event Id for this item
SN_PREF_CARD_ID DOUBLE Y A foreign key Value from the sn_pref_card table.
SURG_AREA_CD DOUBLE N The Surgical Area this item is scheduled for
SURG_CASE_ID DOUBLE N The Surgical Case ID this Item is scheduled for.
SURG_CASE_PROC_ID DOUBLE N The Surgical Case Procedure this item is scheduled for,
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 - SCHED_CASE_PICK_LIST


Child Column in SCHED_CASE_PICK_LIST(FK) Parent Table Name Parent Column Name
Parents: CASE_CART_PICK_LIST_ID CASE_CART_PICK_LIST CASE_CART_PICK_LIST_ID
PREF_CARD_ID PREFERENCE_CARD PREF_CARD_ID
SN_PREF_CARD_ID SN_PREF_CARD SN_PREF_CARD_ID
SURG_CASE_ID SURGICAL_CASE SURG_CASE_ID
SURG_CASE_PROC_ID SURG_CASE_PROCEDURE SURG_CASE_PROC_ID


SEGMENT_GRP_REFERENCE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Segment Group Reference
Definition: Contains attributes of a segment group, including the document type that the group is associated with
Table Type: REFERENCE





Column Detail - SEGMENT_GRP_REFERENCE


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 Y 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 Y The person who caused the active_status_cd to be set or change.
CREATE_APPLCTX DOUBLE Y The application context associated with the creation of this row
CREATE_DT_TM DATETIME Y The date and time this row was created
CREATE_PRSNL_ID DOUBLE Y The person who created/inserted this row.
CREATE_TASK DOUBLE Y The task associated with the creation of this row
DOC_TYPE_CD DOUBLE Y The document type associated with this segment group, i.e. OR Nursing Record, Preop Nursing Assessment.
SEG_GRP_CD DOUBLE N The primary key, uniquely identifying a segment group.
SEG_GRP_SEQ DOUBLE Y The sequence of this segment group within a document type.
SEG_IND DOUBLE Y An indicator of whether or not this is a single-segment segment group (1=more than one)
SURG_AREA_CD DOUBLE Y The surgical area associated with this segment group.
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 - SEGMENT_GRP_REFERENCE




Parent Column in SEGMENT_GRP_REFERENCE (PK) Child Table Name Child Column Name
Children: SEG_GRP_CD SEGMENT_REFERENCE SEG_GRP_CD
SEG_GRP_SEQ_R SEG_GRP_CD


SEGMENT_HEADER



Column Section Relationship Section Top of Page


Table-level Detail

Description: Segment Header
Definition: Contains attributes of the segments within a perioperative document, i.e. Accessed, Discontinued, Not Applicable, etc.
Table Type: ACTIVITY





Column Detail - SEGMENT_HEADER


Column Name Type Null? Definition
ACCESS_FLAG DOUBLE Y An indicator of whether this segment has been accessed for this perioperative document
ADDL_INFO_IND DOUBLE Y *** OBSOLETE ***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
DISCONTINUE_REASON_CD DOUBLE N The reason this segment was discontinued, i.e. equipment failure, no specimen collected, etc.
INPUT_FORM_CD DOUBLE N The input form associated with this segment being documented. This column will only be populated for segments that use the Form Builder.
INPUT_FORM_VER_NBR DOUBLE Y The version number associated with the input form being documented for this segment. This column will only be populated for segments that use the form builder.
LAST_CORR_DT_TM DATETIME Y The date and time of the last correction to this segment
LAST_CORR_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
LONG_TEXT_ID DOUBLE N *** OBSOLETE ***Column
NOT_APPLICABLE_IND DOUBLE Y An indicator of whether or not this segment has been designated as Not Applicable for this perioperative document
PERIOP_DOC_ID DOUBLE N A reference (foreign key) to the perioperative_document table indicating the perioperative document associated with this segment.
SEGMENT_HEADER_ID DOUBLE N The primary key, uniquely identifying a row on this table
SEG_CD DOUBLE N The segment being documented for this perioperative document
SEG_TYPE_FLAG 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 - SEGMENT_HEADER


Child Column in SEGMENT_HEADER(FK) Parent Table Name Parent Column Name
Parents: PERIOP_DOC_ID PERIOPERATIVE_DOCUMENT PERIOP_DOC_ID




Parent Column in SEGMENT_HEADER (PK) Child Table Name Child Column Name
Children: SEGMENT_HEADER_ID CASE_ATTENDANCE SEGMENT_HEADER_ID
CASE_TIMES SEGMENT_HEADER_ID
SN_ACUITY_LEVEL SEGMENT_HEADER_ID
SN_IMPLANT_LOG_ST SEGMENT_HEADER_ID
SURGICAL_DELAY SEGMENT_HEADER_ID
SURG_CASE_PROCEDURE SEGMENT_HEADER_ID