ACUTE_CARE_AUDIT_INFO
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | ACUTE CARE AUDIT INFO |
Definition: | Contains auditing info about specific events that occurred during Acute Care workflows. |
Table Type: | ACTIVITY |
Column Detail - ACUTE_CARE_AUDIT_INFO
Column Name | Type | Null? | Definition |
---|---|---|---|
ACUTE_CARE_AUDIT_INFO_ID | DOUBLE | N | Primary Key |
AUDIT_EVENT_DT_TM | DATETIME | N | Date and time when the audit information was written out into the system. |
AUDIT_EVENT_TYPE_CD | DOUBLE | N | Code value that defines the type of audit event that was written out. |
AUDIT_FACILITY_CD | DOUBLE | N | Facility code in context when the auditing event occurred |
AUDIT_INFORMATION_TEXT | VARCHAR(255) | Y | Additional information for the audit event that occurred. |
AUDIT_PATIENT_ID | DOUBLE | N | Person ID of the patient the audit event was performed on. 0 if action was not patient specific. |
AUDIT_PRSNL_ID | DOUBLE | N | Person ID of the user logged in when the audit event occurred. |
AUDIT_SOLUTION_CD | DOUBLE | N | Code value for the solution the audit was written out from. |
POSITION_CD | DOUBLE | N | Position Code of the user logged in when the audit event occurred. |
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 - ACUTE_CARE_AUDIT_INFO
Child Column in ACUTE_CARE_AUDIT_INFO(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | AUDIT_PATIENT_ID | PERSON | PERSON_ID |
AUDIT_PRSNL_ID | PRSNL | PERSON_ID |
CMS_CRITICAL_CATEGORY
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | CMS CRITICAL CATEGORY |
Definition: | CMS (Centers for Medicare and Medicaid Services) - Content represents the therapeutic drug categories which are designated by clients as time critical for schedule administrations based on location. |
Table Type: | REFERENCE |
Column Detail - CMS_CRITICAL_CATEGORY
Column Name | Type | Null? | Definition |
---|---|---|---|
CMS_CRITICAL_CATEGORY_ID | DOUBLE | N | Unique generated number that identifies a single row on the CMS_Critical_Category table. |
CMS_CRITICAL_LOCATION_ID | DOUBLE | N | LOCATION foreign key value from the CMS_CRITICAL_LOCATION table |
MULTUM_CATEGORY_ID | DOUBLE | N | The Multum drug classification category identifier. |
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 - CMS_CRITICAL_CATEGORY
Child Column in CMS_CRITICAL_CATEGORY(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CMS_CRITICAL_LOCATION_ID | CMS_CRITICAL_LOCATION | CMS_CRITICAL_LOCATION_ID |
MULTUM_CATEGORY_ID | MLTM_DRUG_CATEGORIES | MULTUM_CATEGORY_ID |
CMS_CRITICAL_LOCATION
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | CR CRITICAL LOCATION |
Definition: | CMS (Centers for Medicare and Medicaid Services) - Content represents the LOCATIONS for therapeutic drug categories which are designated by clients as time critical for schedule administrations. |
Table Type: | REFERENCE |
Column Detail - CMS_CRITICAL_LOCATION
Column Name | Type | Null? | Definition |
---|---|---|---|
CMS_CRITICAL_LOCATION_ID | DOUBLE | N | Unique generated number that identifies a single row on the CMS_Critical_Location table. |
LOCATION_CD | DOUBLE | N | The location code value designating where the category is considered critical. |
ORGANIZATION_ID | DOUBLE | N | The unique location organization identifier. |
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 - CMS_CRITICAL_LOCATION
Child Column in CMS_CRITICAL_LOCATION(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | LOCATION_CD | LOCATION | LOCATION_CD |
ORGANIZATION_ID | ORGANIZATION | ORGANIZATION_ID |
Parent Column in CMS_CRITICAL_LOCATION (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | CMS_CRITICAL_LOCATION_ID | CMS_CRITICAL_CATEGORY | CMS_CRITICAL_LOCATION_ID |
COMP_FILTER_GROUP
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Component Filter Group |
Definition: | Contains top level info for a set of filter parameters for a front end component. |
Table Type: | REFERENCE |
Column Detail - COMP_FILTER_GROUP
Column Name | Type | Null? | Definition |
---|---|---|---|
COMPONENT_CD | DOUBLE | N | Code value of the front end component that the filter is applicable to |
COMP_FILTER_GROUP_ID | DOUBLE | N | Unique row ID |
FILTER_NAME | VARCHAR(100) | N | Display name of the filter group |
PERSON_ID | DOUBLE | N | ID of the user who created the filter group. this is a PRSNL value. |
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 - COMP_FILTER_GROUP
Child Column in COMP_FILTER_GROUP(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PERSON_ID | PRSNL | PERSON_ID |
Parent Column in COMP_FILTER_GROUP (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | COMP_FILTER_GROUP_ID | COMP_FILTER_GROUP_ITEM | COMP_FILTER_GROUP_ID |
COMP_FILTER_GROUP_ITEM
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Component Filter Group Item |
Definition: | Contains top level info for a set of filter parameters for a front end component. Contains items to be included in a particular filter setting |
Table Type: | REFERENCE |
Column Detail - COMP_FILTER_GROUP_ITEM
Column Name | Type | Null? | Definition |
---|---|---|---|
COMPONENT_FILTER_TYPE_CD | DOUBLE | N | Code value of the type of info being stored. |
COMP_FILTER_GROUP_ID | DOUBLE | N | Foreign key to component_filter_group table |
COMP_FILTER_GROUP_ITEM_ID | DOUBLE | N | Unique row for ID |
FILTER_ITEM_VALUE_TXT | VARCHAR(255) | N | String representing the value to include when loading a filter 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 - COMP_FILTER_GROUP_ITEM
Child Column in COMP_FILTER_GROUP_ITEM(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | COMP_FILTER_GROUP_ID | COMP_FILTER_GROUP | COMP_FILTER_GROUP_ID |