Table Detail Report

SA_REF_CAT_PRSNL_PROVIDER



Column Section Relationship Section Top of Page


Table-level Detail

Description: SA REF CAT PRSNL PROVIDER
Definition: Categorizes individual PRSNL IDs
Table Type: REFERENCE





Column Detail - SA_REF_CAT_PRSNL_PROVIDER


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.
PROVIDER_SEQUENCE DOUBLE N The sequence of the provider in the category
PRSNL_ID DOUBLE N Provider Id for person being categorized
SA_REF_CAT_PRSNL_ID DOUBLE N Category provider belongs to
SA_REF_CAT_PRSNL_PROVIDER_ID DOUBLE N Unique identifier for row
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 - SA_REF_CAT_PRSNL_PROVIDER


Child Column in SA_REF_CAT_PRSNL_PROVIDER(FK) Parent Table Name Parent Column Name
Parents: SA_REF_CAT_PRSNL_ID SA_REF_CAT_PRSNL SA_REF_CAT_PRSNL_ID


SA_REF_DEVICE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Anesthesia Reference Device
Definition: BMDI Devices that are used in Anesthesia
Table Type: REFERENCE





Column Detail - SA_REF_DEVICE


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.
MONITORED_DEVICE_ID DOUBLE N Key to monitored device for this row
SA_REF_DEVICE_ID DOUBLE N Primary Key for 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 - SA_REF_DEVICE


Child Column in SA_REF_DEVICE(FK) Parent Table Name Parent Column Name
Parents: MONITORED_DEVICE_ID BMDI_MONITORED_DEVICE MONITORED_DEVICE_ID




Parent Column in SA_REF_DEVICE (PK) Child Table Name Child Column Name
Children: SA_REF_DEVICE_ID SA_REF_CAT_DEVICE SA_REF_DEVICE_ID
SA_REF_EXCLUDE_DEVICE SA_REF_DEVICE_ID


SA_REF_DILUENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: SA_REF_DILUENT
Definition: Stores reference data for diluents
Table Type: REFERENCE





Column Detail - SA_REF_DILUENT


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.
ITEM_ID DOUBLE N The item that identifies the diluent item, FK from item_master
SA_REF_DILUENT_ID DOUBLE N Unique value to the diluent record. Primary Key.
SEQUENCE DOUBLE N Sequence of item for display. Applys to all ACTIVE rows in the 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 - SA_REF_DILUENT


Child Column in SA_REF_DILUENT(FK) Parent Table Name Parent Column Name
Parents: ITEM_ID ITEM_MASTER ITEM_ID




Parent Column in SA_REF_DILUENT (PK) Child Table Name Child Column Name
Children: SA_REF_DILUENT_ID SA_MEDICATION_ADMIN SA_REF_DILUENT_ID
SA_REF_EXCLUDE_DILUENT SA_REF_DILUENT_ID


SA_REF_DOC_TYPE



Column Section Relationship Section Top of Page


Table-level Detail

Description: SA REFERENCE DOC TYPE
Definition: SA REFERENCE DOCUMENT TYPE
Table Type: REFERENCE





Column Detail - SA_REF_DOC_TYPE


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.
BLOB_EVENT_CD DOUBLE N Event Cd used for the finalized printed record
CV_REPORT_EVENT_CD DOUBLE N Event cd used for the cv report
GEN_ACTION_EVENT_CD DOUBLE N Event Cd used for generic actions
RECORD_EVENT_CD DOUBLE N Event Cd used for finalized record
SA_DOC_TYPE_CD DOUBLE N Doc Type Cd defining the type of document
SA_REF_DOC_TYPE_ID DOUBLE N Unique identifier for row
SA_REF_DOC_TYPE_NAME VARCHAR(255) N Name of Document type
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 - SA_REF_DOC_TYPE




Parent Column in SA_REF_DOC_TYPE (PK) Child Table Name Child Column Name
Children: SA_REF_DOC_TYPE_ID SA_ANESTHESIA_RECORD SA_REF_DOC_TYPE_ID
SA_PREFERENCE SA_REF_DOC_TYPE_ID
SA_REF_DOC_TYPE_AREA SA_REF_DOC_TYPE_ID
SA_REF_EXCLUDE_ACTION SA_REF_DOC_TYPE_ID
SA_REF_EXCLUDE_DEVICE SA_REF_DOC_TYPE_ID
SA_REF_EXCLUDE_DILUENT SA_REF_DOC_TYPE_ID
SA_REF_EXCLUDE_FLUID SA_REF_DOC_TYPE_ID
SA_REF_EXCLUDE_ITEM SA_REF_DOC_TYPE_ID
SA_REF_EXCLUDE_MEDICATION SA_REF_DOC_TYPE_ID
SA_REF_EXCLUDE_PARAMETER SA_REF_DOC_TYPE_ID
SA_REF_EXCLUDE_POSITION SA_REF_DOC_TYPE_ID
SA_REF_EXCLUDE_PROVIDER SA_REF_DOC_TYPE_ID
SA_REF_FLUID_PREFERENCE SA_REF_DOC_TYPE_ID
SA_REF_MACRO SA_REF_DOC_TYPE_ID
SA_REF_MED_PREFERENCE SA_REF_DOC_TYPE_ID
SA_REF_REQUIRED_ACTION SA_REF_DOC_TYPE_ID
SA_REF_REQUIRED_CATEGORY SA_REF_DOC_TYPE_ID
SA_REF_REQUIRED_FLUID SA_REF_DOC_TYPE_ID
SA_REF_REQUIRED_ITEM SA_REF_DOC_TYPE_ID
SA_REF_REQUIRED_MEDICATION SA_REF_DOC_TYPE_ID
SA_REF_REQUIRED_PARAMETER SA_REF_DOC_TYPE_ID
SA_REF_REQUIRED_PRSNL_ACTIVITY SA_REF_DOC_TYPE_ID


SA_REF_DOC_TYPE_AREA



Column Section Relationship Section Top of Page


Table-level Detail

Description: SA REF DOC TYPE AREA
Definition: ANESTHESIA REF DOCUMENT TYPE AREA
Table Type: REFERENCE





Column Detail - SA_REF_DOC_TYPE_AREA


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.
SA_REF_DOC_TYPE_AREA_ID DOUBLE N Unique identifier for row
SA_REF_DOC_TYPE_ID DOUBLE N Doc Type that is associated to the surgical area (one doc type can be tied to many surgical areas)
SURG_AREA_CD DOUBLE N Surgical area that the doc type is associated to (only one doc type per surgical area)
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 - SA_REF_DOC_TYPE_AREA


Child Column in SA_REF_DOC_TYPE_AREA(FK) Parent Table Name Parent Column Name
Parents: SA_REF_DOC_TYPE_ID SA_REF_DOC_TYPE SA_REF_DOC_TYPE_ID