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