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 |