Table Detail Report

ENCNTR_FINANCIAL_HIST



Column Section Top of Page


Table-level Detail

Description: Encounter Financial History
Definition: Records History of financial class changes for an encounter
Table Type: ACTIVITY





Column Detail - ENCNTR_FINANCIAL_HIST


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.
ENCNTR_FINANCIAL_ID DOUBLE N This is the value of the unique primary identifier of the encounter financial table. It is an internal system assigned number.
ENCNTR_FIN_HIST_ID DOUBLE N This is the value of the unique primary identifier of the encounter financial history table. It is an internal system assigned number.
ENCNTR_FIN_HIST_TYPE_CD DOUBLE N Encounter financial history type code identifies the type of, or reason for, the history row.
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 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.
FINANCIAL_CLASS_CD DOUBLE N The financial classification used for a given encounter. Examples may include Worker's Comp, Self Pay, etc.
TRANSACTION_DT_TM DATETIME Y Physical, not necessarily, but often, system, date and time the change to the encounter financial history was made which prompted this new row on the table.
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.


ENCNTR_FLEX_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Encounter Flex History
Definition: Used for tracking, modifying and inactivating the history elements of encounter information.
Table Type: ACTIVITY





Column Detail - ENCNTR_FLEX_HIST


Column Name Type Null? Definition
ABN_STATUS_CD DOUBLE N Tracks the current ABN status for the encounter.
ACCIDENT_RELATED_IND DOUBLE Y The information indicating if the patient's visit is related to an accident.
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)
ACCOMMODATION_REQUEST_CD DOUBLE N Describes the accommodation that was requested, either by the patient or a staff member. This value may differ from the actual accommodation that the patient/encounter was given. For example, the patient may request a private room, but only receive a semi-private room because no private beds were available.
ACCOMP_BY_CD DOUBLE N Describes who the patient was with at the time of registration. (e.g. friend, spouse, parent, etc.)
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.
ACTIVITY_DT_TM DATETIME N This column holds the current date and time of the system that the row was inserted
ADMINISTRATIVE_PROBLEM_CD DOUBLE Y Indicates the chronic condition that is being treated for this encounter from an administrative perspective.
ADMIT_DECISION_DT_TM DATETIME Y The date and time that the decision to admit the patient to the facility is made.
ADMIT_EARLY_IND DOUBLE N Indicates if the patient's admission qualified under the early admission rules of the facility.
ADMIT_MODE_CD DOUBLE N Admit mode identifies the method by which the patient arrived. (i.e., helicopter, ambulance, etc.)
ADMIT_SRC_CD DOUBLE N Admit source identifies the place from which the patient came before being admitted. (i.e., transfer from another hospital)
ADMIT_TYPE_CD DOUBLE N Admit type indicates the circumstance under which the patient was admitted or will be admitted. (i.e., accident, emergent, routine, elective, labor/delivery, etc.)
ADMIT_WITH_MEDICATION_CD DOUBLE N Admit with medication describes that the patient brought their own medication with them when admitted.
ALC_DECOMP_DT_TM DATETIME Y Date and time the alternate level of care decompensation
ALC_REASON_CD DOUBLE N Reason the alternate level of care 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_DECOMP_DT_TM DATETIME Y Alternate level of care decomposition date/time.
ALT_LVL_CARE_DT_TM DATETIME Y The date and time the alternate level of care was assigned
ALT_RESULT_DEST_CD DOUBLE N NOT USED.
AMBULATORY_COND_CD DOUBLE N Ambulatory condition describes the general physical condition, impairment, or limitation of the patient upon arrival.
ARCHIVE_DT_TM_ACT DATETIME N The actual date/time when the encounter was archived.
ARCHIVE_DT_TM_EST DATETIME N The estimated date when the encounter will be archived. This date is calculated based on client-defined archive criteria.
ARRIVE_DT_TM DATETIME Y The actual date/time that the patient arrived at the facility. At the time of registration, if this field is null then it should be valued with the reg_dt_tm. Otherwise, the actual arrival date/time is captured.
ARRIVE_PRSNL_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the arrive_dt_tm.
ASSIGN_TO_LOC_DT_TM DATETIME Y Date and time that the encounter was assigned to a location.
BBD_PROCEDURE_CD DOUBLE N Encounter (patient) was a blood blank donor and this lists the type of procedure performed on them.
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.
BIRTH_DT_CD DOUBLE N Birth date code indicates the kind of birth date and time value that is contained in the birth_dt_tm field. This field will be null where the field encntr_class_cd indicates that this encounter row references a row in the person table. OBSOLETE: SHOULD USE INFORMATION ON THE PERSON TABLE.
BIRTH_DT_TM DATETIME Y The date and time of birth for the person or thing for which the encounter is being created. This field will be null where the field encntr_class_cd indicates that this encounter row references a row in the person table. OBSOLETE: SHOULD USE INFORMATION ON THE PERSON TABLE.
CHANGE_BIT DOUBLE N Identifies which columns have had a change.
CHART_ACCESS_ORGANIZATION_ID DOUBLE Y The identifying information of the organization (real or virtual) that indicates which groups of users should have medical chart access to the encounter.
CHART_COMPLETE_DT_TM DATETIME Y Date/time when the chart is complete for the encounter.
CLERGY_VISIT_CD DOUBLE N Indicates if the patient has requested a clergy visit.
CLIENT_ORGANIZATION_ID DOUBLE N Identifies the organization financially responsible for the encounter (e.g. an employer paying for an employee's drug test).
CLIENT_REFERENCE_NBR_TXT VARCHAR(50) Y Indicates the number assigned to the encounter for tracking purposes by an external organization that is financially responsible for the encounter.
COMPLETE_REG_DT_TM DATETIME Y The date/time that all required financial and clinical data collection necessary for registration has been completed.
COMPLETE_REG_PRSNL_ID DOUBLE N The internal person id of the personnel that completed the collection of all required financial and clinical data necessary for registration. if the complete_reg_dt_tm is valued, then this field should be valued.
CONFID_LEVEL_CD DOUBLE N Confidential level identifies a level of security that may restrict access or release of information.
CONTRACT_STATUS_CD DOUBLE N Codified field indicating status of a care contract.
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.
COURTESY_CD DOUBLE N This field indicates whether the patient will be extended certain special courtesies such as express discharge, bypassing a stop at the cashiers window upon leaving when financial arrangements are agreed upon in advance.
CREATE_DT_TM DATETIME Y This is the date and time that a row is created in the encounter table.
CREATE_PRSNL_ID DOUBLE N This is the person responsible for creating a row in the encounter table.
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.
DEPART_DT_TM DATETIME Y The actual date/time that the patient left from the facility. In many cases, this field may be null unless the user process requires capturing this data.
DEPART_PRSNL_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the depart_dt_tm.
DIET_TYPE_CD DOUBLE N Diet type is used to indicate that the patient is on a special diet.
DISCH_DISPOSITION_CD DOUBLE N The conditions under which the patient left the facility at the time of discharge.
DISCH_DT_TM DATETIME Y Date the person was discharged from the facility
DISCH_PRSNL_ID DOUBLE N The internal person identifier of the personnel that performed the discharge process. If the disch_dt_tm is valued, then this field must be valued.
DISCH_TO_LOCTN_CD DOUBLE N The location to which the patient was discharged such as another hospital or nursing home.
DOC_RCVD_DT_TM DATETIME Y Date and Time documents were received for the encounter
ED_REFERRAL_SOURCE_CD DOUBLE N Indicates the source of referral for the visit to the emergency department.
ENCNTR_CLASS_CD DOUBLE N Encounter class defines how this encounter row is being used in relation to the person table.
ENCNTR_COMPLETE_DT_TM DATETIME N Date/time when the encounter is considered to be in a completed status.
ENCNTR_FINANCIAL_ID DOUBLE N This is the value of the unique primary identifier of the encounter financial table. It is an internal system assigned number.
ENCNTR_FLEX_HIST_ID DOUBLE N Unique identifier for the encntr_flex_hist 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.
ENCNTR_STATUS_CD DOUBLE N Encounter status identifies the state of a particular encounter type from the time it is initiated until it is complete. (i.e., temporary, preliminary, active, discharged (complete), cancelled).
ENCNTR_TYPE_CD DOUBLE N Categorizes the encounter into a logical group or type. Examples may include inpatient, outpatient, etc.
ENCNTR_TYPE_CLASS_CD DOUBLE N Encounter type class is used to categorize patients into more general groups than encounter type. (i.e., inpatient, outpatient, emergency, recurring outpatient). The values in this code set all have Cerner defined meanings.
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.
EST_ARRIVE_DT_TM DATETIME Y The estimated or expected date/time that the patient will arrive at the facility. This field may be null.
EST_DEPART_DT_TM DATETIME Y The estimated or expected date/time that the patient will depart (outpatient) or will be discharged (inpatient) from the facility. This field may be null.
EST_FINANCIAL_RESP_AMT DOUBLE Y The estimated financial responsibility of the patient (or gaurantor) for this visit.
EST_LENGTH_OF_STAY DOUBLE Y Estimated length of the patient/encounter stay, in days
EXPECTED_DELIVERY_DT_TM DATETIME Y The date and time the delivery is expected.
FINANCIAL_CLASS_CD DOUBLE N The financial classification used for a given encounter. Examples may include Worker's Comp, Self Pay, etc.
GUARANTOR_TYPE_CD DOUBLE N The guarantor type indicates that the guarantor for the encounter is either a person or an organization. This code is used to determine which set of tables to query to find the guarantor.
INCIDENT_CD DOUBLE N Indicates the incident or disaster that led to the patient's visit.
INFO_GIVEN_BY CHAR(100) Y Free-text attribute specifying who gave the information for this encounter. Might be a guardian, parent, patient, etc.
INITIAL_CONTACT_DT_TM DATETIME Y The initial contact of the patient and the provider submitting the claim.
INPATIENT_ADMIT_DT_TM DATETIME Y Stores the inpatient admit date and time
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.
KIOSK_QUEUE_NBR_DT_TM DATETIME Y The date and time when the system generated ticket number representing their position within the queue was assigned to the patient when they are checking in for the visit.
KIOSK_QUEUE_NBR_TXT VARCHAR(50) Y The system generated ticket number assigned to the patient to represent their position within the queue when they are checking in for the visit.
LAST_MENSTRUAL_PERIOD_DT_TM DATETIME Y The date and time of the last menstrual period.
LEVEL_OF_SERVICE_CD DOUBLE N The level of service provided. Examples are emergency, elective, urgent and routine.
LOCATION_CD DOUBLE N The field identifies the current permanent location of the patient. The location for an inpatient will be valued with the lowest level location type in the hierarchy of facility, building, nurse unit, room, bed.
LOC_BED_CD DOUBLE N This field is the current patient location with a location type of bed.
LOC_BUILDING_CD DOUBLE N This field is the current patient location with a location type of building.
LOC_FACILITY_CD DOUBLE N This field is the current patient location with a location type of facility.
LOC_NURSE_UNIT_CD DOUBLE N This field is the current patient location with a location type of nurse unit.
LOC_ROOM_CD DOUBLE N This field is the current patient location with a location type of room.
LOC_TEMP_CD DOUBLE N This field identifies the temporary location of the patient. the temporary location may be valued at the same time the location_cd is valued.
LODGER_CD DOUBLE N Indicates if an additional person is staying with the patient in the same room.
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.
MENTAL_CATEGORY_CD DOUBLE N Mental category code (ex. Mental illness, Mental impairment, severe mental impairment)
MENTAL_HEALTH_CD DOUBLE N The field is the mental health status of a patient which indicates if a patient was involuntarily or voluntarily admitted. This field is not used by all clients.
MENTAL_HEALTH_DT_TM DATETIME Y The date and time of the last time the mental health info was updated.
MILITARY_SERVICE_RELATED_CD DOUBLE N Indicates if the patient's visit is related to their military service.
NAME_FIRST VARCHAR(200) Y OBSOLETE - This is the person's first given name. OBSOLETE: SHOULD USE INFORMATION ON THE PERSON TABLE.
NAME_FIRST_KEY VARCHAR(200) Y OBSOLETE - This is the person's first given name all capitals with punctuation removed. This field is used for indexing and searching for a person by name. OBSOLETE: SHOULD USE INFORMATION ON THE PERSON TABLE.
NAME_FIRST_SYNONYM_ID DOUBLE N OBSOLETE - This is the value of the unique primary identifier of the first name synonym table. It is an internal system assigned number. It is used to when searching for a person where other first names would be considered as a match. OBSOLETE: SHOULD USE INFORMATION ON THE PERSON TABLE.
NAME_FULL_FORMATTED VARCHAR(200) Y OBSOLETE - This is the complete person name including punctuation and formatting. OBSOLETE: SHOULD USE INFORMATION ON THE PERSON TABLE.
NAME_LAST VARCHAR(200) Y OBSOLETE - This is the person's family name. OBSOLETE: SHOULD USE INFORMATION ON THE PERSON TABLE.
NAME_LAST_KEY VARCHAR(200) Y OBSOLETE - This is the person's family name all capitals with punctuation removed. This field is used for indexing and searching for a person by name. OBSOLETE: SHOULD USE INFORMATION ON THE PERSON TABLE.
NAME_PHONETIC VARCHAR(200) Y OBSOLETE - This is the Soundex coded representation of the person's name. This field is used for indexing and searching for a patient by name when the exact spelling is not known. OBSOLETE: SHOULD USE INFORMATION ON THE PERSON TABLE.
ONSET_DT_TM DATETIME Y The date and time of the onset of current symptoms.
ORDER_SOURCE_CD DOUBLE N The source of the order (i.e. electronic, scanned, faxed by physician, faxed by patient, etc.)
ORGANIZATION_ID DOUBLE N This is the value of the unique primary identifier of the organization table. It is an internal system assigned number. This column is either valued with the facility or the client organization for the encounter.
OVRD_AUTOMTC_CVRG_PRTZTN_IND DOUBLE Y Indicates if the automatic coverage prioritization processing was overridden by the user to maintain the manually entered coverage priority sequencing.
PARENT_RET_CRITERIA_ID DOUBLE N ** OBSOLETE ** This column is no longer used. This column indicates which set of retention criteria was last applied to the encounter to calculate the value in the archive_dt_tm_est column. **OBSOLETE **
PATIENT_CLASSIFICATION_CD DOUBLE N Patient classification code (ex. Ordinary admission, day case admission, regular day, regular night)
PAYMENT_COLLECTION_STATUS_CD DOUBLE N The status of the payment collection (i.e. 1st attempt - left message, payment in full received, unable to pay - proceed with service, etc.)
PA_CURRENT_STATUS_CD DOUBLE N This column shows the last action that was performed on the encounter in relation to the purge/archive process.
PA_CURRENT_STATUS_DT_TM DATETIME Y Date/time of last purge/archive action taken on the encounter.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
PERSON_PLAN_PROFILE_TYPE_CD DOUBLE N Indicates the type of health insurance profile to be used for the encounter (i.e., professional, institutional, workmen's comp).
PLACEMENT_AUTH_PRSNL_ID DOUBLE N The id of the personnel who authorized the override of a patient placement into a location that had a "stop" attribute associated to it.
PLACE_OF_SVC_ADMIT_DT_TM DATETIME Y The date and time of admission to the place of service organization.
PLACE_OF_SVC_ORG_ID DOUBLE N Uniquely identifies the place of service organization for the encounter.
PLACE_OF_SVC_TYPE_CD DOUBLE N Code to identify the type of service performed at the place of service organization for the encounter.
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.
PREADMIT_NBR VARCHAR(100) Y The number assigned to a pre-admit encounter. A pre-admit encounter is not required to have a pre-admit number
PREADMIT_TESTING_CD DOUBLE N Indicates that the patient must have pre-admission testing done in order to be admitted.
PREGNANCY_STATUS_CD DOUBLE N The status of the pregnancy.
PRE_REG_DT_TM DATETIME Y The date/time that the pre-registration or pre-admission process was performed. If the reg_dt_tm is valued, or no pre-registration occurred, then this field may be null.
PRE_REG_PRSNL_ID DOUBLE N The internal person ID of the personnel that performed the pre-registration or pre-admission. If the pre_reg_dt_tm is valued, then this field must be valued.
PROGRAM_SERVICE_CD DOUBLE N Represents the program service associated with the patient's location
PSYCHIATRIC_STATUS_CD DOUBLE N Psychiatric status code (ex. One or more previous, not known, not applicable)
PURGE_DT_TM_ACT DATETIME Y The actual date/time when data for the encounter was purged from the database.
PURGE_DT_TM_EST DATETIME Y The estimated date/time when data for the encounter will be purged from the database.
READMIT_CD DOUBLE N Description of the encounter readmit.
REASON_FOR_VISIT VARCHAR(255) Y The free text description of reason for visit. Otherwise known as admitting symptom, presenting symptom, etc. It is a brief description of why the person has presented for examination or treatment and may be the patient described symptom.
REFERRAL_RCVD_DT_TM DATETIME Y The date and time the referral was received
REFERRAL_SOURCE_CD DOUBLE N The information indicating the source of referral like provider, friend, web-site, etc.
REFERRING_COMMENT VARCHAR(100) Y A text field containing the comments from the referring physician or service.
REFER_FACILITY_CD DOUBLE N The location of the referring facility. This code set is used at sites that do not have full referral management integration.
REFER_TO_UNIT_STAFF_CD DOUBLE N Indicates if any inquiries regarding the patient need to be redirected to a unit staff member.
REGION_CD DOUBLE N A codified field which indicates the area or region which the encounter was referred.
REG_DT_TM DATETIME Y The date/time that the registration or admission process was performed. In some circumstances this may only involve a minimal amount of data collection to simply get the encounter added to the system for clinical purposes.if the pre_reg_dt_tm is valued, then this field may be null, but will be valued when the patient presents for their visit/appointment.
REG_PRSNL_ID DOUBLE N The internal person ID of the personnel that performed the registration or admission. If the reg_dt_tm is valued, then this field must be valued.
RESULT_ACCUMULATION_DT_TM DATETIME Y Reference date for an encounter that determines the starting point when printing a patient's chart
RESULT_DEST_CD DOUBLE N NOT USED.
SAFEKEEPING_CD DOUBLE N Where or how valuables are being stored.
SECURITY_ACCESS_CD DOUBLE N The security access code is a codified field which identifies the current level of security access the encounter requires.
SERVICE_CATEGORY_CD DOUBLE N Codified field which identifies the current category of service the patient is receiving for this encounter.
SERVICE_DT_TM DATETIME Y The start or if in the future the anticipated start date of service for the encounter. The service date time is determined per the following date availability: Arrival date/time, Registration date/time, Estimated arrival date/time, and Pre-Registration date/time.
SERVICE_PROVIDER_ORG_ID DOUBLE Y The identifier of the organization (real or virtual) that is primarily responsible for the encounter (owner of the information).
SEX_CD DOUBLE N The gender of the patient (i.e., male, female, unknown). This field will be null where the field encntr_class_cd indicates that this encounter row references a row in the person table. OBSOLETE: SHOULD USE INFORMATION ON THE PERSON TABLE.
SITTER_REQUIRED_CD DOUBLE N A codified field that indicates whether a Personnel is required to sit with the encounter
SPECIALTY_UNIT_CD DOUBLE N The specialty unit associated with the program service
SPECIES_CD DOUBLE N A fundamental category of taxonomic classification, ranking after a genus and consisting of organisms capable of interbreeding. OBSOLETE: SHOULD USE INFORMATION ON THE PERSON TABLE.
TRACKING_BIT DOUBLE N Identifies which columns are being tracked for history.
TRANSACTION_DT_TM DATETIME N Date and time the transaction, which triggered the history row, occurred. This field can be system assigned or manually manipulated by users.
TRANSFER_REASON_CD DOUBLE N Identifies the reason the person was transferred or moved from one location to another.
TRAUMA_CD DOUBLE N Type of trauma related to this encounter.
TRAUMA_DT_TM DATETIME Y Date and time the trauma related incident occurred.
TREATMENT_PHASE_CD DOUBLE N Treatment phase (Code Set: 4018002) identifies the current stage of a unit that the encounter is in (i.e. phase 1, phase 2, entry, intermediate). Used to describe the different levels of care as the encounter progresses. A common use would be behavioral health scenarios.
TRIAGE_CD DOUBLE N Describes the triage performed on, or related to, this encounter.
TRIAGE_DT_TM DATETIME Y Date and time the triage occurred.
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.
VALUABLES_CD DOUBLE N Type of valuables being kept for the patient.
VIP_CD DOUBLE N The VIP code indicates for this encounter that the person is to be identified and possibly treated with special consideration during the active time of the encounter. (i.e., employee, board member, famous person).
VISITOR_STATUS_CD DOUBLE N Describes the type, or what kind of, visitors the patient wishes to see during their encounter.
ZERO_BALANCE_DT_TM DATETIME Y Date/time when the account balance becomes zero for the encounter.



Relationship Detail - ENCNTR_FLEX_HIST


Child Column in ENCNTR_FLEX_HIST(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
CHART_ACCESS_ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
CLIENT_ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
PLACE_OF_SVC_ORG_ID ORGANIZATION ORGANIZATION_ID
SERVICE_PROVIDER_ORG_ID ORGANIZATION ORGANIZATION_ID
PERSON_ID PERSON PERSON_ID
PM_HIST_TRACKING_ID PM_HIST_TRACKING PM_HIST_TRACKING_ID
COMPLETE_REG_PRSNL_ID PRSNL PERSON_ID
DISCH_PRSNL_ID PRSNL PERSON_ID


ENCNTR_INFO



Column Section Relationship Section Top of Page


Table-level Detail

Description: Encounter Information
Definition: The encounter information table may contain a variety of information related to an encounter, not otherwise defined in the HNA database. It represents a code set driven method of extending the HNA database for Cerner and user defined data.
Table Type: ACTIVITY





Column Detail - ENCNTR_INFO


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.
CHARTABLE_IND DOUBLE Y Defines whether this encounter level comment can be shown on a chart.
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_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
ENCNTR_INFO_ID DOUBLE N Primary Key for ENCNTR_INFO. Internal 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.
INFO_SUB_TYPE_CD DOUBLE N Auxilliary information which further specifies the type of encounter information contained in the row. A sub-category of the info_type_cd value.
INFO_TYPE_CD DOUBLE N The specific type of encounter information contained on the row. Examples may include comments and user-defined fields.
INTERNAL_SEQ DOUBLE Y Cerner-owned internal sequence which can be used to order given types of encounter information.
LONG_TEXT_ID DOUBLE N Foreign key to the LONG_TEXT table. Ties a long_text row (such as a comment) to this table. Encntr_info_id becomes the parent_entity_id on the long_text table, and "ENCNTR_INFO" becomes the parent_entity_name.
PRIORITY_SEQ DOUBLE Y Identifies a sequencing priority to be used when a duplicate relationship of the same type is created.
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.
VALUE_CD DOUBLE Y Note: NOT tied specifically to codeset 1! Varies based on the type of encounter information being stored. For example, codified comments may be stored here, or the value for a codified user-defined field, or others. Values in this column will originate from various codesets depending on their intended use.
VALUE_DT_TM DATETIME Y The date and time value of the encounter information. If the value of the row necessitates storing a date/time, it is placed in this column.
VALUE_NOMENCLATURE_ID DOUBLE N The nomenclature identifier value of the encounter information. If the value of the row necessitates storing a nomenclature identifier value, it is placed in this column.
VALUE_NUMERIC DOUBLE Y The numeric (non-codified) value of the encounter information. If the value of the row necessitates storing a numeric (non-codified) value, it is placed in this column.
VALUE_NUMERIC_IND DOUBLE N Indicates whether or not the input from the front end tool for column VALUE_NUMBER is 0 or NULL.



Relationship Detail - ENCNTR_INFO


Child Column in ENCNTR_INFO(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
VALUE_NOMENCLATURE_ID NOMENCLATURE NOMENCLATURE_ID




Parent Column in ENCNTR_INFO (PK) Child Table Name Child Column Name
Children: ENCNTR_INFO_ID ENCNTR_INFO_HIST ENCNTR_INFO_ID


ENCNTR_INFO_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: ENCNTR INFO HIST
Definition: Tracks modifications to history elements for a given encntr_info table.
Table Type: ACTIVITY





Column Detail - ENCNTR_INFO_HIST


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.
CHANGE_BIT DOUBLE N Identifies which columns have had a change.
CHARTABLE_IND DOUBLE Y Defines whether this encounter level comment can be shown on a chart.
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_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
ENCNTR_INFO_HIST_ID DOUBLE N This is the value of the unique primary identifier of the encntr_info_hist table. It is an internal system assigned number.
ENCNTR_INFO_ID DOUBLE N This is a FK from the Encntr_Info table. This is the value of the unique primary identifier of the encntr_info table. It is an internal system assigned number.
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.
INFO_SUB_TYPE_CD DOUBLE N Auxilliary information which further specifies the type of encounter information contained in the row. A sub-category of the info_type_cd value.
INFO_TYPE_CD DOUBLE N The specific type of encounter information contained on the row. Examples may include comments and user-defined fields.
INTERNAL_SEQ DOUBLE Y Cerner-owned internal sequence which can be used to order given types of encounter information.
LONG_TEXT_ID DOUBLE N A foreign key to the long_text table. ties a long_text row (such as a comment) to this table. encntr_info_id becomes the parent_entity_id on the long_text table, and "encntr_info" becomes the parent_entity_name.
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 a sequencing priority to be used when a duplicate relationship of the same type is created.
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.
VALUE_CD DOUBLE Y Stores historical values of type double from the parent table
VALUE_DT_TM DATETIME Y The date and time value of the encounter information. If the value of the row necessitates storing a date/time, it is placed in this column.
VALUE_LONG_TEXT_ID DOUBLE N This is the value of the unique primary identifier of the long_text table. It is an internal system assigned number.
VALUE_NOMENCLATURE_ID DOUBLE N The nomenclature identifier value of the encounter information. If the value of the row necessitates storing a nomenclature identifier value, it is placed in this column.
VALUE_NUMERIC DOUBLE Y The numeric (non-codified) value of the encounter information. If the value of the row necessitates storing a numeric (non-codified) value, it is placed in this column.
VALUE_NUMERIC_IND DOUBLE N Indicates whether or not the input from the front end tool for column value_number is 0 or null.
VALUE_TYPE DOUBLE N ** obsolete ** This column is no longer being used. This field holds the indicator as to what type of user defined information is in the row.(1 -text , 2 - coded, 3 - data/time, 4 - indicator, 5 - numeric). ** obsolete **



Relationship Detail - ENCNTR_INFO_HIST


Child Column in ENCNTR_INFO_HIST(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_INFO_ID ENCNTR_INFO ENCNTR_INFO_ID
ENCNTR_ID ENCOUNTER ENCNTR_ID
LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
VALUE_NOMENCLATURE_ID NOMENCLATURE NOMENCLATURE_ID
PM_HIST_TRACKING_ID PM_HIST_TRACKING PM_HIST_TRACKING_ID


ENCNTR_INPTNT_REHAB



Column Section Relationship Section Top of Page


Table-level Detail

Description: Encounter Inpatient Rehab
Definition: Stores information specific to a patient's inpatient rehabilitation visit.
Table Type: ACTIVITY





Column Detail - ENCNTR_INPTNT_REHAB


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 Y 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 Y The person who caused the active_status_cd to be set or change.
ADMIT_IMPAIR_GRP_CD DOUBLE Y The physical, mental, or cognitive limitation category for the patient at the time of admission. Each impairment group may require different types of support, accommodations, and interventions to address the specific challenges and needs of individuals with those limitations.
DISCH_IMPAIR_GRP_CD DOUBLE Y The physical, mental, or cognitive limitation category for the patient at the time of discharge. Each impairment group may require different types of support, accommodations, and interventions to address the specific challenges and needs of individuals with those limitations.
ENCNTR_ID DOUBLE Y This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
ENCNTR_INPTNT_REHAB_ID DOUBLE N A system generated number used to uniquely identify a row on the ENCNTR_INPTNT_REHAB table.
QUALIFYING_COND_CD DOUBLE Y The condition that qualifies the patient for Medicare coverage at an inpatient rehab facility.
UPDT_APPLCTX DOUBLE Y 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 Y 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 Y 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 Y 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 Y 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_INPTNT_REHAB


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