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 |