Table Detail Report

PROBLEM_ACTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Problem Action
Definition: Each row on the table represents an action (Create, Review, etc.) that a particular clinician performed on a problem.
Table Type: ACTIVITY





Column Detail - PROBLEM_ACTION


Column Name Type Null? Definition
ACTION_DT_TM DATETIME N Action Date and Time
ACTION_TYPE_MEAN VARCHAR(12) N Indicates the type of action performed by clinician. In the initial release, it will be REVIEW.
PROBLEM_ACTION_ID DOUBLE N Unique key for the table. Sequence: PROBLEM_SEQ
PROBLEM_ID DOUBLE N Unique identifier for a clinical problem grouper from the PROBLEM table
PROBLEM_INSTANCE_ID DOUBLE N Unique identifier for a clinical problem instance from the PROBLEM table
PRSNL_ID DOUBLE N Unique Identifier for the clinician who performed a particular action on the problem.
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 - PROBLEM_ACTION


Child Column in PROBLEM_ACTION(FK) Parent Table Name Parent Column Name
Parents: PROBLEM_INSTANCE_ID PROBLEM PROBLEM_INSTANCE_ID
PRSNL_ID PRSNL PERSON_ID


PROBLEM_COMMENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Problem Comment
Definition: The Problem Comment table records the comments that have been attached to a problem.
Table Type: ACTIVITY





Column Detail - PROBLEM_COMMENT


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y 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 Y 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.
BEG_EFFECTIVE_DT_TM DATETIME Y The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
BEG_EFFECTIVE_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
COMMENT_DT_TM DATETIME Y The date and time that the comment was created.
COMMENT_PRSNL_ID DOUBLE N The unique identifier of the care provider that created the comment
COMMENT_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
CONTRIBUTOR_SYSTEM_CD DOUBLE N Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed.
DATA_STATUS_CD DOUBLE N Data status indicates a level of authenticity of the row data. Typically this will either be AUTHENTICATED or UNAUTHENTICATED.
DATA_STATUS_DT_TM DATETIME Y The date and time that the data_status_cd was set.
DATA_STATUS_PRSNL_ID DOUBLE N The person who caused the data_status_cd to be set or change.
END_EFFECTIVE_DT_TM DATETIME Y The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
PROBLEM_COMMENT LONGTEXT Y The text of a comment regarding a problem.
PROBLEM_COMMENT_ID DOUBLE N Unique identifier for problem comment.
PROBLEM_ID DOUBLE N The unique identifier of the problem that this comment was created.
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 - PROBLEM_COMMENT


Child Column in PROBLEM_COMMENT(FK) Parent Table Name Parent Column Name
Parents: PROBLEM_ID PROBLEM PROBLEM_INSTANCE_ID
COMMENT_PRSNL_ID PRSNL PERSON_ID


PROBLEM_DISCIPLINE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Problem Discipline
Definition: The Problem Discipline table records the management disciplines which have an interest in this problem.
Table Type: ACTIVITY





Column Detail - PROBLEM_DISCIPLINE


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y 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 Y 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.
BEG_EFFECTIVE_DT_TM DATETIME Y The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
CONTRIBUTOR_SYSTEM_CD DOUBLE N Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed.
DATA_STATUS_CD DOUBLE N Data status indicates a level of authenticity of the row data. Typically this will either be AUTHENTICATED or UNAUTHENTICATED.
DATA_STATUS_DT_TM DATETIME Y The date and time that the data_status_cd was set.
DATA_STATUS_PRSNL_ID DOUBLE N The person who caused the data_status_cd to be set or change.
END_EFFECTIVE_DT_TM DATETIME Y The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
MANAGEMENT_DISCIPLINE_CD DOUBLE N Indicates the category of care providers that have responsibility for managing this specific problem.
PROBLEM_DISCIPLINE_ID DOUBLE N Unique identifier for problem discipline.
PROBLEM_ID DOUBLE N The unique identifier of the problem that this discipline was created.
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 - PROBLEM_DISCIPLINE


Child Column in PROBLEM_DISCIPLINE(FK) Parent Table Name Parent Column Name
Parents: PROBLEM_ID PROBLEM PROBLEM_INSTANCE_ID


PROBLEM_EXT_DATA



Column Section Relationship Section Top of Page


Table-level Detail

Description: External staging table for Problems concept
Definition: To temporarily hold untrusted data that has come from an external source (e.g. FHIR)
Table Type: ACTIVITY





Column Detail - PROBLEM_EXT_DATA


Column Name Type Null? Definition
ACTION_DT_TM DATETIME Y The date and time of the action
ACTION_PRSNL_ID DOUBLE N The personnel who performed the action.
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.
CLIENT_IDENT VARCHAR(255) Y The client identifier that represents the client who wrote the data to the system.
CORRELATION_IDENT VARCHAR(80) N Uppercase, hyphenated GUID that identifies the transaction that updated this row.
DATA_LOB_ENCODING_STR VARCHAR(10) N The encoding of the external data
DATA_STATUS_CD DOUBLE N Data status indicates a level of authenticity of the row data.
ENCNTR_ID DOUBLE N The encounter ID associated to the problem external data.
LIFE_CYCLE_STATUS_CD DOUBLE N The encoding of the external data.
ORIGINATING_NOMENCLATURE_ID DOUBLE N The term that was searched by a user to add the condition.
PERSON_ID DOUBLE N The person related to the external data.
PROBLEM_DISPLAY_KEYCAP VARCHAR(255) N This field is used to sort and search by the display of the external problem data. This is character data and is all CAPS. It can contain embedded special characters.
PROBLEM_EXT_BLOB LONGBLOB Y The data that has come from an external interface.
PROBLEM_EXT_DATA_ID DOUBLE N PRIMARY KEY
PROBLEM_ID DOUBLE N ID from the PROBLEM table - the problem being acted on
REQUESTED_ACTION_CD DOUBLE N Action requested for the data.
SUBMITTED_DT_TM DATETIME Y The date and time this external data was added to the staging tables.
TARGET_NOMENCLATURE_ID DOUBLE N The nomenclature id for the target of the condition if it is an ongoing condition.
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.
VERSION_NBR DOUBLE Y The version of the external data.



Relationship Detail - PROBLEM_EXT_DATA


Child Column in PROBLEM_EXT_DATA(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
ORIGINATING_NOMENCLATURE_ID NOMENCLATURE NOMENCLATURE_ID
TARGET_NOMENCLATURE_ID NOMENCLATURE NOMENCLATURE_ID
PERSON_ID PERSON PERSON_ID
PROBLEM_ID PROBLEM PROBLEM_INSTANCE_ID
ACTION_PRSNL_ID PRSNL PERSON_ID


PROBLEM_PRSNL_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Problem Personnel Relation
Definition: The Problem Personnel Relation table records the relationships that providers have to a problem.
Table Type: ACTIVITY





Column Detail - PROBLEM_PRSNL_R


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y 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 Y 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.
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
CONTRIBUTOR_SYSTEM_CD DOUBLE N Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed.
DATA_STATUS_CD DOUBLE N Data status indicates a level of authenticity of the row data. Typically this will either be AUTHENTICATED or UNAUTHENTICATED.
DATA_STATUS_DT_TM DATETIME Y The date and time that the data_status_cd was set.
DATA_STATUS_PRSNL_ID DOUBLE N The person who caused the data_status_cd to be set or change.
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
PROBLEM_ID DOUBLE N Unique identifier to track problem evolution.
PROBLEM_PRSNL_ID DOUBLE N Unique identifier for problem personnel relationship.
PROBLEM_RELTN_CD DOUBLE N The reason or purpose of the relationship.
PROBLEM_RELTN_DT_TM DATETIME Y The date and time that the personnel relationship was created.
PROBLEM_RELTN_PRSNL_ID DOUBLE N The unique identifier of the care provider that established the relationship.
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 - PROBLEM_PRSNL_R


Child Column in PROBLEM_PRSNL_R(FK) Parent Table Name Parent Column Name
Parents: PROBLEM_ID PROBLEM PROBLEM_INSTANCE_ID