Table Detail Report

ENCNTR_ORG_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Encounter Organization Relationship
Definition: The encounter-organization relation table contains pointers to related organizations in the organization table. Usually, a row in this table represents an organization which is the guarantor of a specific encounter as in the case of an auto accident.
Table Type: ACTIVITY





Column Detail - ENCNTR_ORG_RELTN


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 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.
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_ORG_ALIAS VARCHAR(100) Y Free-text alias relating the encounter and organization.
ENCNTR_ORG_NBR VARCHAR(100) Y Free-text number relating the encounter and organization.
ENCNTR_ORG_RELTN_CD DOUBLE N Identifies the general type of relationship between the encounter and an organization. This field has meanings in the common data foundation which are defined by Cerner (i.e., guarantor, insurance company, etc.).
ENCNTR_ORG_RELTN_ID DOUBLE N This is the value of the unique primary identifier of the encounter organization relation table. It is an internal system assigned number.
ENCNTR_ORG_RELTN_TYPE_CD DOUBLE N ** obsolete ** This column has been replaced by ENCNTR_ORG_RELTN_CD. Identifies the general type of relationship between the encounter and an organization. This field has meanings in the common data foundation which are defined by Cerner (I.e., GUARANTOR, 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.
FREE_TEXT_IND DOUBLE N Indicates whether the relationship between encounter and organization is free-text.
FT_ORG_NAME VARCHAR(100) Y If the relationship is free-text, this field can display the name of the organization to which the encounter is related.
INTERNAL_SEQ DOUBLE N Sequence used within Cerner applications to order encounter organization relationships.
ORGANIZATION_ID DOUBLE N This is the value of the unique primary identifier of the organization table. It is an internal system assigned number.
PRIORITY_SEQ DOUBLE N Identifies a sequencing priority to be used when a duplicate relationship of the same type is created.
RESEARCH_ACCOUNT_ID DOUBLE N This is the id that relates to the research account that is guarantor for this encounter
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_ORG_RELTN


Child Column in ENCNTR_ORG_RELTN(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
RESEARCH_ACCOUNT_ID RESEARCH_ACCOUNT RESEARCH_ACCOUNT_ID


ENCNTR_PENDING



Column Section Relationship Section Top of Page


Table-level Detail

Description: encntr_pending
Definition: Stores information relating to an encounter that has been put in a 'Pend' transfer or discharge. It is also used to capture information when the transfer or discharge is completed and any information relating to a cancel of the pending action.
Table Type: ACTIVITY





Column Detail - ENCNTR_PENDING


Column Name Type Null? Definition
ACCOMMODATION_CD DOUBLE N Current type of accommodations in which the patient (encounter) has been placed. (e.g. Private, Semi Private, etc.)
ACCOMMODATION_REASON_CD DOUBLE N Describes why the accommodation the patient received was given. (e.g. Doctor requested, patient requested)
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.
ALC_DECOMP_DT_TM DATETIME Y The date and time of the alternate level of care decompensation
ALC_REASON_CD DOUBLE N Reason the alternate level of care value is being assigned or changed
ALT_LVL_CARE_CD DOUBLE N Level of care for the encounter that signals a difference, or alternative, to the care signified by the encntr_type, med service, location, or combination therein. Used primarily as a billing function to trigger a change in charging rates.
ALT_LVL_CARE_DT_TM DATETIME Y The date and time the alternate level of care was assigned
ATTENDDOC_ID DOUBLE N Request Attending Physician ID for pending encounter.
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.
DISCH_DISPOSITION_CD DOUBLE N The conditions under which the patient left the facility at the time of discharge.
DISCH_TO_LOCTN_CD DOUBLE N The location to which the patient was discharged such as another hospital or nursing home.
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_PENDING_ID DOUBLE N This is the value of the unique primary identifier of the encntr_pending table. It is an internal system assigned number.
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.
EST_COMPLETE_DT_TM DATETIME Y The estimated or expected date/time that the pending action will be completed. This field may be null.
ISOLATION_CD DOUBLE N The isolation code indicates that some level of isolation or restricted access is required or in place for this patient indicating special procedure or consideration to be used when dealing with the patient.
MED_SERVICE_CD DOUBLE N The type or category of medical service that the patient is receiving in relation to their encounter. The category may be of treatment type, surgery, general resources, or others.
PENDING_DT_TM DATETIME Y The date and time for which a pending action becomes active. Normally, this will be the date and time the row is added, but could be a past or future date and time.
PENDING_PRIORITY_CD DOUBLE N This represents the priority of the pending action. (i.e. Urgent, Low, High, etc.)
PENDING_PRSNL_ID DOUBLE N The Id of the personnel who initiated the pending activity on the encounter.
PENDING_STATUS_CD DOUBLE N This represents the status of the pending action. (i.e. On Hold, Waiting for Chart, etc.)
PENDING_TYPE_FLAG DOUBLE N Identifies the type of pending action associated with the row.
PEND_BED_CD DOUBLE N This field is the current patient location with a location type of bed.
PEND_BUILDING_CD DOUBLE N This field is the current patient location with a location type of building.
PEND_FACILITY_CD DOUBLE N This field is the current patient location with a location type of facility.
PEND_NURSE_UNIT_CD DOUBLE N This field is the current patient location with a location type of nurse unit.
PEND_ROOM_CD DOUBLE N This field is the current patient location with a location type of room.
PREV_EST_DEPART_DT_TM DATETIME Y Previous Estimated Depart Date and Time that was stamped on the encounter table before a pending action.
PRIORITY_SEQ DOUBLE Y Identifies an sequencing priority to be used when there is more than one location with the same encounter.
PROCESS_STATUS_DT_TM DATETIME Y The date/time that the process status flag changed.
PROCESS_STATUS_FLAG DOUBLE N Identifies the status of pending action associated with the row.
PROGRAM_SERVICE_CD DOUBLE N The program service associated with the location of the patient
SERVICE_CATEGORY_CD DOUBLE N Codified field which identifies the current category of service the patient is receiving for this encounter.
SPECIALTY_UNIT_CD DOUBLE N The specialty associated with a program service
TRANSACTION_REASON VARCHAR(200) Y Text that describes the reason for the transaction.
TRANSACTION_REASON_CD DOUBLE N Identifies the reason for the transaction.
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_PENDING


Child Column in ENCNTR_PENDING(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
PEND_BED_CD LOCATION LOCATION_CD
PEND_BUILDING_CD LOCATION LOCATION_CD
PEND_FACILITY_CD LOCATION LOCATION_CD
PEND_NURSE_UNIT_CD LOCATION LOCATION_CD
PEND_ROOM_CD LOCATION LOCATION_CD
ATTENDDOC_ID PRSNL PERSON_ID


ENCNTR_PENDING_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: encntr_pending_hist
Definition: Stores history information relating to an encounter that has a pending transfer or discharge
Table Type: ACTIVITY





Column Detail - ENCNTR_PENDING_HIST


Column Name Type Null? Definition
ACCOMMODATION_CD DOUBLE N Current type of accommodations in which the patient (encounter) has been placed. (e.g. Private, Semi Private, etc.)
ACCOMMODATION_REASON_CD DOUBLE N Describes why the accommodation the patient received was given. (e.g. Doctor requested, patient requested)
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.
ALC_DECOMP_DT_TM DATETIME Y Date and time of the alternate level of care decompensation
ALC_REASON_CD DOUBLE N Reason the alternate level of care value is being assigned or changed
ALT_LVL_CARE_CD DOUBLE N Level of care for the encounter that signals a difference, or alternative, to the care signified by the encntr_type, med service, location, or combination therein. Used primarily as a billing function to trigger a change in charging rates.
ALT_LVL_CARE_DT_TM DATETIME Y Date and time the alternate level of care was assigned
ATTENDDOC_ID DOUBLE N Request Attending Physician ID for pending encounter.
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.
DISCH_DISPOSITION_CD DOUBLE N The conditions under which the patient left the facility at the time of discharge.
DISCH_TO_LOCTN_CD DOUBLE N The location to which the patient was discharged such as another hospital or nursing home.
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_PENDING_HIST_ID DOUBLE N This is the value of the unique primary identifier of the encntr_pending_hist table. It is an internal system assigned number.
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.
EST_COMPLETE_DT_TM DATETIME Y The estimated or expected date/time that the pending action will be completed. This field may be null.
ISOLATION_CD DOUBLE N The isolation code indicates that some level of isolation or restricted access is required or in place for this patient indicating special procedure or consideration to be used when dealing with the patient.
MED_SERVICE_CD DOUBLE N The type or category of medical service that the patient is receiving in relation to their encounter. The category may be of treatment type, surgery, general resources, or others.
PENDING_DT_TM DATETIME Y The date and time for which a pending action becomes active. Normally, this will be the date and time the row is added, but could be a past or future date and time.
PENDING_PRIORITY_CD DOUBLE N This represents the priority of the pending action. (i.e. Urgent, Low, High, etc.)
PENDING_PRSNL_ID DOUBLE N The Id of the personnel who initiated the pending activity on the encounter.
PENDING_STATUS_CD DOUBLE N This represents the status of the pending action. (i.e. On Hold, Waiting for Chart, etc.)
PENDING_TYPE_FLAG DOUBLE N Identifies the type of pending action associated with the row.
PEND_BED_CD DOUBLE N This field is the current patient location with a location type of bed.
PEND_BUILDING_CD DOUBLE N This field is the current patient location with a location type of building.
PEND_FACILITY_CD DOUBLE N This field is the current patient location with a location type of facility.
PEND_NURSE_UNIT_CD DOUBLE N This field is the current patient location with a location type of nurse unit.
PEND_ROOM_CD DOUBLE N This field is the current patient location with a location type of room.
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.
PREV_EST_DEPART_DT_TM DATETIME Y Previous Estimated Depart Date and Time that was stamped on the encounter table before a pending action.
PRIORITY_SEQ DOUBLE Y Identifies an sequencing priority to be used when there is more than one location with the same encounter.
PROCESS_STATUS_DT_TM DATETIME Y The date and time the process status flag changed.
PROCESS_STATUS_FLAG DOUBLE N Identifies the status of pending action associated with the row.
PROGRAM_SERVICE_CD DOUBLE N The program service associated with the location of the patient
SERVICE_CATEGORY_CD DOUBLE N Codified field which identifies the current category of service the patient is receiving for this encounter.
SPECIALTY_UNIT_CD DOUBLE N The specialty associated with a program service
TRACKING_BIT DOUBLE N Identifies which columns are being tracked for history.
TRANSACTION_REASON VARCHAR(100) Y Text that describes the reason for the transaction.
TRANSACTION_REASON_CD DOUBLE N Identifies the reason for the transaction.
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_PENDING_HIST


Child Column in ENCNTR_PENDING_HIST(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
PEND_BED_CD LOCATION LOCATION_CD
PEND_BUILDING_CD LOCATION LOCATION_CD
PEND_FACILITY_CD LOCATION LOCATION_CD
PEND_NURSE_UNIT_CD LOCATION LOCATION_CD
PEND_ROOM_CD LOCATION LOCATION_CD
PM_HIST_TRACKING_ID PM_HIST_TRACKING PM_HIST_TRACKING_ID
ATTENDDOC_ID PRSNL PERSON_ID


ENCNTR_PERSON_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Encounter Person Relationship
Definition: The encounter-person relationship table contains pointers to related persons in the person table .The kind of relationship (i.e., accompanied by, accident witness, etc.) and genetic indication defines how the encounter and person are related.
Table Type: ACTIVITY





Column Detail - ENCNTR_PERSON_RELTN


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 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.
CONTACT_ROLE_CD DOUBLE N This field is equivalent to the HL7 contact role field in the Next of Kin segment. This field is generally not used by the Cerner system, since there are other preferred ways to store data indicated by this HL7 field.
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.
COPY_CORRESPONDENCE_CD DOUBLE N Denotes whether the related person should be copied on any correspondence to the person.
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.
DEFAULT_RELTN_IND DOUBLE Y Identifies whether the relationship is the default displayable Mother-Child relationship.
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_PERSON_RELTN_ID DOUBLE N This is the value of the unique primary identifier of the encounter person relationship 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.
FAMILY_RELTN_SUB_TYPE_CD DOUBLE N The specific family relationship
FREE_TEXT_CD DOUBLE N Describes the type of free text information that is available for the person. When set to a meaning of 'FTBRIEF', this indicates that the related_person_id is NULL, meaning that there is no reference to the person table.
FT_REL_PERSON_NAME VARCHAR(100) Y The name of the person in the 'free text' relationship indicated by the free_text_ind in the row being set to 'TRUE'.
GENETIC_RELATIONSHIP_IND DOUBLE N Indicates whether the relationship is genetic.
INTERNAL_SEQ DOUBLE N Sequence used within Cerner applications to order encounter person relationship rows.
LIVING_WITH_IND DOUBLE N Indicates whether the encounter's person (patient) is living with the person represented by the related_person_id.
PERSON_RELTN_CD DOUBLE N Identifies the specific type of relationship between two persons for the encounter. This field is user defined (I.e., father, mother, spouse, self, friend, etc.). This is equivalent to the HL7 relationship field in the Next of Kin segment.
PERSON_RELTN_TYPE_CD DOUBLE N Identifies the general type of relationship between two persons for the encounter. This field is has meanings in the common data foundation which are defined by Cerner (I.e., next of kin, emergency contact, default guarantor, etc.)
PRIORITY_SEQ DOUBLE N Identifies an sequencing priority to be used when there is more than one related person with the same person relationship type (I.e., emergency contact)
RELATED_PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. This is a 'role' name for the reference to person_id in the person table and used to differentiate between other references to person_id in this table.
RELATED_PERSON_RELTN_CD DOUBLE N This identifies the inverse specific relationship of the two person for the encounter.
RELATION_SEQ DOUBLE N Zero based sequence for all encntr_ person_reltn rows across all relation types set by the master system. Added to support he UK's PDS transactions.
SOURCE_IDENTIFIER VARCHAR(255) Y Identifier assigned from a master system to this row. Added to support he UK's PDS Allocated Object Identifier. Used to help keep the UK master database in sync with Millennium.
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.
VISITATION_ALLOWED_CD DOUBLE N Identifies whether or not the related person has visitation privilege, potentially specifying the level of privilege.



Relationship Detail - ENCNTR_PERSON_RELTN


Child Column in ENCNTR_PERSON_RELTN(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
RELATED_PERSON_ID PERSON PERSON_ID




Parent Column in ENCNTR_PERSON_RELTN (PK) Child Table Name Child Column Name
Children: ENCNTR_PERSON_RELTN_ID ENCNTR_PERSON_RELTN_HIST ENCNTR_PERSON_RELTN_ID


ENCNTR_PERSON_RELTN_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Encounter Person Relationship History
Definition: This table contains transactional history of table ENCNTR_PERSON_RELTN.
Table Type: ACTIVITY





Column Detail - ENCNTR_PERSON_RELTN_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 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.
CHANGE_BIT DOUBLE N Identifies which columns have changed.
CONTACT_ROLE_CD DOUBLE N This field is equivalent to the HL7 contact role field in the Next of Kin segment. This field is generally not used by the Cerner system, since there are other preferred ways to store data indicated by this HL7 field.
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.
COPY_CORRESPONDENCE_CD DOUBLE N Denotes whether the related person should be copied on any correspondence to the person.
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.
DEFAULT_RELTN_IND DOUBLE Y Identifies whether the relationship is the default displayable Mother-Child relationship.
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_PERSON_RELTN_HIST_ID DOUBLE N The unique primary key of this table. It is internally generated by Cerner.
ENCNTR_PERSON_RELTN_ID DOUBLE N This is the value of the primary identifier of the ENCNTR_PERSON_RELTN table. It associates which row on the ENCNTR_PERSON_RELTN table the history is related to.
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.
FAMILY_RELTN_SUB_TYPE_CD DOUBLE N The specific family relationship
FREE_TEXT_CD DOUBLE N Describes the type of free text information that is available for the person. When set to a meaning of 'FTBRIEF', this indicates that the related_person_id is NULL, meaning that there is no reference to the person table.
FT_REL_PERSON_NAME VARCHAR(100) Y The name of the person in the 'free text' relationship indicated by the free_text_ind in the row being set to 'TRUE'.
GENETIC_RELATIONSHIP_IND DOUBLE Y Indicates whether the relationship is genetic.
INTERNAL_SEQ DOUBLE Y Sequence used within Cerner applications to order encounter person relationship rows.
LIVING_WITH_IND DOUBLE Y Indicates whether the encounter's person (patient) is living with the person represented by the related_person_id.
PERSON_RELTN_CD DOUBLE N Identifies the specific type of relationship between two persons for the encounter. This field is user defined (I.e., father, mother, spouse, self, friend, etc.). This is equivalent to the HL7 relationship field in the Next of Kin segment.
PERSON_RELTN_TYPE_CD DOUBLE N Identifies the general type of relationship between two persons for the encounter. This field is has meanings in the common data foundation which are defined by Cerner (I.e., next of kin, emergency contact, default guarantor, etc.)
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 Identifies an sequencing priority to be used when there is more than one related person with the same person relationship type (I.e., emergency contact)
RELATED_PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. This is a 'role' name for the reference to person_id in the person table and used to differentiate between other references to person_id in this table.
RELATED_PERSON_RELTN_CD DOUBLE N This identifies the inverse specific relationship of the two person for the encounter.
RELATION_SEQ DOUBLE N Zero based sequence for all encntr_ person_reltn rows across all relation types set by the master system. Added to support he UK's PDS transactions.
SOURCE_IDENTIFIER VARCHAR(255) Y Identifier assigned from a master system to this row. Added to support he UK's PDS Allocated Object Identifier. Used to help keep the UK master database in sync with Millennium.
TRACKING_BIT DOUBLE N Identifies which columns are being tracked for history.
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.
VISITATION_ALLOWED_CD DOUBLE N Identifies whether or not the related person has visitation privilege, potentially specifying the level of privilege.



Relationship Detail - ENCNTR_PERSON_RELTN_HIST


Child Column in ENCNTR_PERSON_RELTN_HIST(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_PERSON_RELTN_ID ENCNTR_PERSON_RELTN ENCNTR_PERSON_RELTN_ID
PM_HIST_TRACKING_ID PM_HIST_TRACKING PM_HIST_TRACKING_ID