Table Detail Report

ENCNTR_PRSNL_RELTN_HISTORY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Encounter Personnel Relation HIstory
Definition: Used to store the transactional history for encounter/personnel relationships.
Table Type: ACTIVITY





Column Detail - ENCNTR_PRSNL_RELTN_HISTORY


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.
ACTIVITY_DT_TM DATETIME Y This column holds the current system date and time that the row was inserted.
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.
CHANGE_BIT DOUBLE N Identifies which columns have had a change.
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.
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
ENCNTR_PRSNL_RELTN_HISTORY_ID DOUBLE N The primary key of the ENCNTR_PRSNL_RELTN_HISTORY table.
ENCNTR_PRSNL_RELTN_ID DOUBLE N The primary key of the ENCNTR_PRSNL_RELTN table.
ENCNTR_PRSNL_R_CD DOUBLE N The relationship of the personnel to the encounter.
ENCNTR_TYPE_CD DOUBLE N Categorizes the encounter into a logical group or type. Examples may include inpatient, outpatient, etc.
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.
EXPIRATION_IND DOUBLE Y Indicates whether the relationship between the encounter and the personnel has expired.
EXPIRE_DT_TM DATETIME Y Date/Time that the relationship has been expired from encounter. Primarily used to prevent the relationship from appearing in PowerChart application.
FREE_TEXT_CD DOUBLE N Value that shows the type of free text relationship information that is present between the encounter and personnel. When set to a meaning of 'FTBRIEF', this indicates that the prsnl_person_id is NULL, meaning that there is no reference to the personnel table.
FT_PRSNL_NAME VARCHAR(100) Y The name of the personnel in the 'free text' relationship indicated by the free_text_ind in the row being set to 'TRUE'.
INTERNAL_SEQ DOUBLE Y Used within Cerner applications, if necessary, to order encounter personnel relation rows.
MANUAL_CREATE_BY_ID DOUBLE N Person Id of the person who manually created the relationship.
MANUAL_CREATE_DT_TM DATETIME Y Date and time the encounter personnel relationship was manually created.
MANUAL_CREATE_IND DOUBLE Y Indicates whether the row was manually created.
MANUAL_INACT_BY_ID DOUBLE N The person_id of the person who inactivated the relationship.
MANUAL_INACT_DT_TM DATETIME Y Date and time the row was manually inactivated.
MANUAL_INACT_IND DOUBLE Y Indicates whether the row was manually inactivated.
NOTIFICATION_CD DOUBLE N Personnel preferred method of notification for issues concerning related person.
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.
PRIORITY_SEQ DOUBLE Y The priority given to the relation type if more than one of the same type exists
PRSNL_PERSON_ID DOUBLE N This is the value of the unique primary identifier of the personnel table. This is a 'role' name for the reference to person_id in the personnel table and used to differentiate between other references to person_id in this table.
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_PRSNL_RELTN_HISTORY


Child Column in ENCNTR_PRSNL_RELTN_HISTORY(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_PRSNL_RELTN_ID ENCNTR_PRSNL_RELTN ENCNTR_PRSNL_RELTN_ID
ENCNTR_ID ENCOUNTER ENCNTR_ID
PM_HIST_TRACKING_ID PM_HIST_TRACKING PM_HIST_TRACKING_ID
PRSNL_PERSON_ID PRSNL PERSON_ID


ENCNTR_SLICE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Encounter Slice
Definition: Stores different slices of time for an encounter (i.e. Consultant Epsiodes)
Table Type: ACTIVITY





Column Detail - ENCNTR_SLICE


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.
ENCNTR_ID DOUBLE N Associated Encounter for the time slice
ENCNTR_SLICE_FLAG DOUBLE N Encounter slice origin and update activity 0 - Normal Process; 1 - Upload from service_cat_hist table; 2 - Insert from Encntr Slice Viewer; 3 - Update from Encntr Slice Viewer; 4 - Removed from Encntr Slice Viewer
ENCNTR_SLICE_ID DOUBLE N Identifies an Encounter as it relates to a time slice.
ENCNTR_SLICE_TYPE_CD DOUBLE N Identifies the type of slice that is being recorded for an Encounter.
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. 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_SLICE


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




Parent Column in ENCNTR_SLICE (PK) Child Table Name Child Column Name
Children: ENCNTR_SLICE_ID ABSTRACTING ENCNTR_SLICE_ID
ABSTRACT_DATA ENCNTR_SLICE_ID
ABST_CODING_RELTN ENCNTR_SLICE_ID
CAC_DOCUMENT ENCNTR_SLICE_ID
CODING ENCNTR_SLICE_ID
CODING_AUDIT ENCNTR_SLICE_ID
CODING_HIST ENCNTR_SLICE_ID
CODING_SPECIALTY ENCNTR_SLICE_ID
DIAGNOSIS ENCNTR_SLICE_ID
DIAGNOSIS_HIST ENCNTR_SLICE_ID
DRG ENCNTR_SLICE_ID
DRG_ENCNTR_EXTENSION ENCNTR_SLICE_ID
DRG_SPECIALTY ENCNTR_SLICE_ID
EEM_BENEFIT_ALLOC ENCNTR_SLICE_ID
ENCNTR_AUGM_CARE_PERIOD ENCNTR_SLICE_ID
ENCNTR_SLICE_ACT ENCNTR_SLICE_ID
ENCNTR_SLICE_HIST ENCNTR_SLICE_ID
NOMENCLATURE_ENCNTR_DESC ENCNTR_SLICE_ID
PM_POST_PROCESS ENCNTR_SLICE_ID
PROCEDURE ENCNTR_SLICE_ID
PROCEDURE_HIST ENCNTR_SLICE_ID


ENCNTR_SLICE_ACT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Encounter Slice Activity
Definition: Used to store the current state of an encounter slice's activity related to the parent entity tables.
Table Type: ACTIVITY





Column Detail - ENCNTR_SLICE_ACT


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.
COLUMN_CD DOUBLE N The identifier for the column that the value_cd contains data for.
COLUMN_VALUE_CD DOUBLE N The value of the column on the parent_entity_name table and the parent_entity_id row.
ENCNTR_SLICE_ACT_ID DOUBLE N The unique primary key of the ENCNTR_SLICE_ACT table.
ENCNTR_SLICE_ID DOUBLE N Identifies which encounter slice the activity row applies to.
PARENT_ENTITY_ID DOUBLE N The ID for the table row which for the table represented by the parent_entity_name.
PARENT_ENTITY_NAME VARCHAR(30) N The table which is being referenced.
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_SLICE_ACT


Child Column in ENCNTR_SLICE_ACT(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_SLICE_ID ENCNTR_SLICE ENCNTR_SLICE_ID




Parent Column in ENCNTR_SLICE_ACT (PK) Child Table Name Child Column Name
Children: ENCNTR_SLICE_ACT_ID ENCNTR_SLICE_ACT_HIST ENCNTR_SLICE_ACT_ID


ENCNTR_SLICE_ACT_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Encounter Slice Activity History
Definition: Used to store the encounter slice activity transactional history.
Table Type: ACTIVITY





Column Detail - ENCNTR_SLICE_ACT_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.
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.
COLUMN_CD DOUBLE N The identifier for the column that the value_cd contains data for.
COLUMN_VALUE_CD DOUBLE N The value of the column on the parent_entity_name table and the parent_entity_id row.
ENCNTR_SLICE_ACT_HIST_ID DOUBLE N The unique primary key of this table.
ENCNTR_SLICE_ACT_ID DOUBLE N The unique primary key of the ENCNTR_SLICE_ACT table.
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.
PARENT_ENTITY_ID DOUBLE N The ID for the table row which for the table represented by the parent_entity_name.
PARENT_ENTITY_NAME VARCHAR(30) N The table which is being referenced.
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_SLICE_ACT_HIST


Child Column in ENCNTR_SLICE_ACT_HIST(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_SLICE_ACT_ID ENCNTR_SLICE_ACT ENCNTR_SLICE_ACT_ID


ENCNTR_SLICE_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Encounter Slice Activity
Definition: Used to store the encounter slice transactional history.
Table Type: ACTIVITY





Column Detail - ENCNTR_SLICE_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.
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.
ENCNTR_SLICE_HIST_ID DOUBLE N The unique primary key of the ENCNTR_SLICE_HIST table.
ENCNTR_SLICE_ID DOUBLE N The primary key from the ENCNTR_SLICE table.
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.
HIST_ACTION VARCHAR(3) N The action taken. Example: UPT, RMV.
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. It is used to track changes.
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_SLICE_HIST


Child Column in ENCNTR_SLICE_HIST(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_SLICE_ID ENCNTR_SLICE ENCNTR_SLICE_ID
PM_HIST_TRACKING_ID PM_HIST_TRACKING PM_HIST_TRACKING_ID