Table Detail Report

SN_SUPPLY_CAB_DEF_PREFS



Column Section Top of Page


Table-level Detail

Description: SN Supply Cabinet Default Preferences
Definition: Stores the segments and event code defaults for supply cabinet information.
Table Type: REFERENCE





Column Detail - SN_SUPPLY_CAB_DEF_PREFS


Column Name Type Null? Definition
DOC_TYPE_CD DOUBLE N The document type for which a list of segments and event codes will display
EVENT_CD DOUBLE N Event code of the field
SEG_CD DOUBLE N For this document type, the segment on which supply cabinet data will default
SN_SUPPLY_CAB_DEF_PREFS_ID DOUBLE N primary key
SUP_CAB_DATA_ELM_CD DOUBLE N Code of the supply cabinet data element
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.


SN_SUP_CAB_PREF_CLASS



Column Section Relationship Section Top of Page


Table-level Detail

Description: SN SUPPLY CAB PREF CLASS
Definition: Stores segment item class info to default the supply cabinet information
Table Type: REFERENCE





Column Detail - SN_SUP_CAB_PREF_CLASS


Column Name Type Null? Definition
ITEM_CLASS_ID DOUBLE N Item class identifier
SN_SUP_CAB_PREF_CLASS_ID DOUBLE N The unique identifier for supply cabinet preference class
SN_SUP_CAB_PREF_SEG_ID DOUBLE N The unique identifier for the supply cabinet's segment
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 - SN_SUP_CAB_PREF_CLASS


Child Column in SN_SUP_CAB_PREF_CLASS(FK) Parent Table Name Parent Column Name
Parents: ITEM_CLASS_ID CLASS_NODE CLASS_NODE_ID
SN_SUP_CAB_PREF_SEG_ID SN_SUP_CAB_PREF_SEG SN_SUP_CAB_PREF_SEG_ID


SN_SUP_CAB_PREF_FIELD



Column Section Relationship Section Top of Page


Table-level Detail

Description: SN SUPPLY CABINET PREF FIELDS
Definition: Stores event code(s) to map with the supply cabinet data elements
Table Type: REFERENCE





Column Detail - SN_SUP_CAB_PREF_FIELD


Column Name Type Null? Definition
EVENT_CD DOUBLE N event codes for a particular document type
SN_SUP_CAB_PREF_FIELD_ID DOUBLE N Primary Key
SN_SUP_CAB_PREF_SEG_ID DOUBLE N The unique identifier for the supply cabinet's segment
SUP_CAB_DATA_ELM_CD DOUBLE N Code of the supply cabinet data element
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 - SN_SUP_CAB_PREF_FIELD


Child Column in SN_SUP_CAB_PREF_FIELD(FK) Parent Table Name Parent Column Name
Parents: SN_SUP_CAB_PREF_SEG_ID SN_SUP_CAB_PREF_SEG SN_SUP_CAB_PREF_SEG_ID


SN_SUP_CAB_PREF_SEG



Column Section Relationship Section Top of Page


Table-level Detail

Description: SN SUPPLY CABINET PREF SEGMENT
Definition: Stores the segment(s) to default supply cabinet information to
Table Type: REFERENCE





Column Detail - SN_SUP_CAB_PREF_SEG


Column Name Type Null? Definition
AREA_CD DOUBLE N The Surgical Area this supply cabinet preference is built for
DOC_TYPE_CD DOUBLE N The document type for which a list of segments and event codes will display
SEG_CD DOUBLE N For this document type, the segment on which supply cabinet data will default
SN_SUP_CAB_PREF_SEG_ID DOUBLE N The unique identifier for the supply cabinet's segmentPrimary Key
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 - SN_SUP_CAB_PREF_SEG




Parent Column in SN_SUP_CAB_PREF_SEG (PK) Child Table Name Child Column Name
Children: SN_SUP_CAB_PREF_SEG_ID SN_SUP_CAB_PREF_CLASS SN_SUP_CAB_PREF_SEG_ID
SN_SUP_CAB_PREF_FIELD SN_SUP_CAB_PREF_SEG_ID


SN_SURG_CASE_PROC_CPT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Surgical Case Procedure CPT4 Codes
Definition: Identifies the CPT4 code(s) associated with a procedure from a surgical case.
Table Type: ACTIVITY





Column Detail - SN_SURG_CASE_PROC_CPT


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.
ACTUAL_IND DOUBLE N Indicates the CPT4 has been assigned during scheduling (value 0) or is the actual CPT4 assigned from Document Manager (value 1).
CPT_SEQ DOUBLE N Identifies the priority and sequence in which the CPT was selected.
NOMENCLATURE_ID DOUBLE N This is the value of the unique primary identifier of the NOMENCLATURE table. It is an internal system assigned number. This value is used to identify a specific CPT4 code.
SN_SURG_CASE_PROC_CPT_ID DOUBLE N Unique sequence number (primary key) for this table
SURG_CASE_PROC_ID DOUBLE N This is the value of the unique primary identifier of the SURG_CASE_PROCEDURE table. It is an internal system assigned 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.



Relationship Detail - SN_SURG_CASE_PROC_CPT


Child Column in SN_SURG_CASE_PROC_CPT(FK) Parent Table Name Parent Column Name
Parents: NOMENCLATURE_ID NOMENCLATURE NOMENCLATURE_ID
SURG_CASE_PROC_ID SURG_CASE_PROCEDURE SURG_CASE_PROC_ID