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 |