Table Detail Report

ENCNTR_CLASSIFICTN_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Encounter Classification History
Definition: Used for tracking history changes to ENCNTR_CLASSIFICATION rows
Table Type: ACTIVITY





Column Detail - ENCNTR_CLASSIFICTN_HIST


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.
CHANGE_BIT DOUBLE N Identifies which columns have had a change.
CLASSIFICATION1_CD DOUBLE N Indicates a categorization of patients having a set of shared qualities or characteristics.
CLASSIFICATION2_CD DOUBLE N Indicates a categorization of patients having a set of shared qualities or characteristics. This code set may be configured via code value grouping to be hierarchically below patient classification 1 if desired by the client.
CLASSIFICATION3_CD DOUBLE N Indicates a categorization of patients having a set of shared qualities or characteristics. This code set may be configured via code value grouping to be hierarchically below patient classification 2 if desired by the client
CLASSIFICATION4_CD DOUBLE N Indicates a categorization of patients having a set of shared qualities or characteristics. This code set may be configured via code value grouping to be hierarchically below patient classification 3 if desired by the client
ENCNTR_CLASSIFICATION_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
ENCNTR_CLASSIFICTN_HIST_ID DOUBLE N Unique generated number that identifies a single row on the ENCNTR_CLASSIFICTN_HIST table.
PM_HIST_TRACKING_ID DOUBLE N This is the value of the unique primary identifier of the pm_hist_tracking table. It is an internal system assigned number.
TRACKING_BIT DOUBLE N Identifies which columns are being tracked for history.
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 - ENCNTR_CLASSIFICTN_HIST


Child Column in ENCNTR_CLASSIFICTN_HIST(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_CLASSIFICATION_ID ENCNTR_CLASSIFICATION ENCNTR_CLASSIFICATION_ID
PM_HIST_TRACKING_ID PM_HIST_TRACKING PM_HIST_TRACKING_ID


ENCNTR_CODE_VALUE_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: ENCNTR CODE VALUE R
Definition: Holds multiple select code values on the encounter level.
Table Type: ACTIVITY





Column Detail - ENCNTR_CODE_VALUE_R


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.
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.
CODE_SET DOUBLE N This is a code set that can have multiple code values for one encounter.
CODE_VALUE DOUBLE N This is the code value for certain code sets that allow for multiple selects.
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.
ENCNTR_CODE_VALUE_R_ID DOUBLE N Unique identifier for the encntr_code_value_r table.
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
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.
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 - ENCNTR_CODE_VALUE_R


Child Column in ENCNTR_CODE_VALUE_R(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID


ENCNTR_CODE_VALUE_R_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Encounter Code Value Relationship History
Definition: Holds the multiple select code values on the encounter level.
Table Type: ACTIVITY





Column Detail - ENCNTR_CODE_VALUE_R_HIST


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.
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.
CODE_SET DOUBLE N This is a code set that can have multiple values for one encounter.
CODE_VALUE DOUBLE N This is the code value for certain code sets that allow multiple selects.
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.
ENCNTR_CODE_VALUE_R_HIST_ID DOUBLE N The unique primary key of this table. It is internally generated.
ENCNTR_CODE_VALUE_R_ID DOUBLE N This is the value of the unique identifier of the encntr_code_value_r table.
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table that the code values are related to.
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.
PM_HIST_TRACKING_ID DOUBLE N This is the value of the unique primary identifier of the pm_hist_tracking table. It is an internal system assigned number.
TRANSACTION_DT_TM DATETIME Y ** OBSOLETE **. Use column updt_dt_tm for any filtering/ordering query. If transaction date time is needed, it should be retrieved from pm_hist_tracking table. Note that its date may be in the past, as in before the update date time.
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 - ENCNTR_CODE_VALUE_R_HIST


Child Column in ENCNTR_CODE_VALUE_R_HIST(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
PM_HIST_TRACKING_ID PM_HIST_TRACKING PM_HIST_TRACKING_ID


ENCNTR_COMBINE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Encounter Combine
Definition: The encounter combine table contains the audit trail for all encounters that were either automatically or manually combined as a result of determining that two rows in the encounter table represent the same encounter.
Table Type: ACTIVITY





Column Detail - ENCNTR_COMBINE


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.
APPLICATION_FLAG DOUBLE Y Tells which type of application sends the transaction.
CMB_DT_TM DATETIME Y `Date when combine finished
CMB_UPDT_ID DOUBLE Y Person who performed the combine
COMBINE_ACTION_CD DOUBLE N Action that was taken on the 'from' encounter record during the combine.
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.
ENCNTR_COMBINE_ID DOUBLE N This is the value of the unique primary identifier of the encounter combine table. It is an internal system assigned number.
FROM_ENCNTR_ID DOUBLE N This is the value of the unique primary identifier from the encounter table of the FROM encounter that was combined. It is an internal system assigned number.
PREV_ACTIVE_IND DOUBLE Y Reference Data Domain Sync (RDDS) use for determining historical occurrences.
PREV_ACTIVE_STATUS_CD DOUBLE N The value of the active_status_cd prior to the row being combined. Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
PREV_CONFID_LEVEL_CD DOUBLE N The value of the conf_level_cd prior to the row being combined. Confidential level identifies a level of security that may restrict access or release of information.
TO_ENCNTR_ID DOUBLE N This is the value of the unique primary identifier from the encounter table of the TO encounter that was combined. It is an internal system assigned number.
TRANSACTION_TYPE VARCHAR(8) Y The type of transaction that triggers the combine. For ESI transactions, the transaction_type will be the MSH event, e.g., A01, A02, ... For Combine Tool transactions, the transaction_type will be blank.
UCB_DT_TM DATETIME Y Date when uncombine finished
UCB_UPDT_ID DOUBLE Y Person who performed the uncombine
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 - ENCNTR_COMBINE


Child Column in ENCNTR_COMBINE(FK) Parent Table Name Parent Column Name
Parents: FROM_ENCNTR_ID ENCOUNTER ENCNTR_ID
TO_ENCNTR_ID ENCOUNTER ENCNTR_ID




Parent Column in ENCNTR_COMBINE (PK) Child Table Name Child Column Name
Children: ENCNTR_COMBINE_ID ENCNTR_COMBINE_DET ENCNTR_COMBINE_ID


ENCNTR_COMBINE_DET



Column Section Relationship Section Top of Page


Table-level Detail

Description: Encounter Combine Detail
Definition: The encounter combine detail table contains an audit trail for every row in every table where the encounter_id was changed to a new encounter_id as a result of combining two rows in the encounter table.
Table Type: ACTIVITY





Column Detail - ENCNTR_COMBINE_DET


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.
ATTRIBUTE_NAME VARCHAR(32) Y Name of the attribute on the child table that is related to encounter.encntr_id.
COMBINE_ACTION_CD DOUBLE N The action that was taken on the child row during the combine, e.g. add, update, etc.
COMBINE_DESC_CD DOUBLE N Further describes what happened during a combine.
ENCNTR_COMBINE_DET_ID DOUBLE N This is the value of the unique primary identifier of the encounter combine detail table. It is an internal system assigned number.
ENCNTR_COMBINE_ID DOUBLE N This is the value of the unique primary identifier of the encounter combine table. It is an internal system assigned number.
ENTITY_ID DOUBLE N The value of the primary identifier of the row in the table, identified in the entity_name field, that was combined. For example, if an encntr_alias row was combined, the value here would be the value of the row's encntr_alias_id.
ENTITY_NAME VARCHAR(32) N The upper case name of the table to which this address row is related (e.g., ENCNTR_ALIAS, ENCNTR_ACCIDENT, etc.)
PREV_ACTIVE_IND DOUBLE Y Reference Data Domain Sync (RDDS) use for determining historical occurrences.
PREV_ACTIVE_STATUS_CD DOUBLE N The value of the active_status_cd prior to the row being combined. Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
PREV_END_EFF_DT_TM DATETIME Y If a row is made 'not effective' during a combine, the value of its end_effective_dt_tm column before combine is stored here.
TO_RECORD_IND DOUBLE Y If set to 1, this record was originally a child of the to parent record.
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 - ENCNTR_COMBINE_DET


Child Column in ENCNTR_COMBINE_DET(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_COMBINE_ID ENCNTR_COMBINE ENCNTR_COMBINE_ID