Table Detail Report

ENCNTR_VALUE_CODE



Column Section Relationship Section Top of Page


Table-level Detail

Description: ENCNTR VALUE CODE
Definition: Encounter value code (UB92).
Table Type: ACTIVITY





Column Detail - ENCNTR_VALUE_CODE


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.
AMOUNT DOUBLE Y Dollar (numeric) value for the type of UB92 value stored.
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.
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.
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.
SEQUENCE DOUBLE Y NOT USED. Placeholder for future use of prioritizing encntr_value_code rows.
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.
VALUE_CD DOUBLE N Type of encounter value, UB92 value code, that is stored.
VALUE_CODE_ID DOUBLE N This is the value of the unique primary identifier of the encounter value code table. It is an internal system assigned number.



Relationship Detail - ENCNTR_VALUE_CODE


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


ENCOUNTER



Column Section Relationship Section Top of Page


Table-level Detail

Description: Encounter
Definition: The encounter table contains patient information for a specific period of time that a person comes in contact with a healthcare provider (i.e., inpatient hospital stay, outpatient clinic visit, office visit, phone call to the doctor, etc.).
Table Type: ACTIVITY





Column Detail - ENCOUNTER


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.
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_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.
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 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.
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.
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.
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 The actual date/time that the patient was discharged from the facility. For most outpatients, this column may be null unless the user process requires capturing this data, for example, day surgery. Auto discharge will populate this column. This also may or may not be a system assigned date and time depending on the discharge process used.
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_ID DOUBLE N Unique identifier for the Encounter table.
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 codeset all have Cerner defined meanings.
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_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 Contains the estimated amount for which the patient is responsible for this encounter.
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.
EXTERNAL_IND DOUBLE N Set to true (1), if the encounter is external to the hospital network. Otherwise, set to false (0).
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 Person whom this encounter is for.
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.
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 Security Access Code value.
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.
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 - ENCOUNTER


Child Column in ENCOUNTER(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_FINANCIAL_ID ENCNTR_FINANCIAL ENCNTR_FINANCIAL_ID
LOCATION_CD LOCATION LOCATION_CD
LOC_BED_CD LOCATION LOCATION_CD
LOC_BUILDING_CD LOCATION LOCATION_CD
LOC_FACILITY_CD LOCATION LOCATION_CD
LOC_NURSE_UNIT_CD LOCATION LOCATION_CD
LOC_ROOM_CD LOCATION LOCATION_CD
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
COMPLETE_REG_PRSNL_ID PRSNL PERSON_ID
DISCH_PRSNL_ID PRSNL PERSON_ID




Parent Column in ENCOUNTER (PK) Child Table Name Child Column Name
Children: ENCNTR_ID ABSTRACTING ENCNTR_ID
ABSTRACT_DATA ENCNTR_ID
ABST_CODING_RELTN ENCNTR_ID
ACT_PW_COMP ENCNTR_ID
ACT_PW_COMP ORIGINATING_ENCNTR_ID
ALERT_AUDIT_ALLERGY_DOM ENCNTR_ID
ALERT_AUDIT_DRUG_DOM ENCNTR_ID
ALERT_AUDIT_DUP_DOM ENCNTR_ID
ALERT_AUDIT_FOOD_DOM ENCNTR_ID
ALLERGY ENCNTR_ID
ALLERGY_EXT_DATA ENCNTR_ID
AOAV_CONDITION ENCNTR_ID
AOAV_DIAGNOSES ENCNTR_ID
AOAV_ENCNTR_LOC_HIST ENCNTR_ID
AOAV_ENCNTR_RISK_HIST ENCNTR_ID
AOAV_EVENT ENCNTR_ID
AOAV_HOSP_OUTCOMES ENCNTR_ID
AOAV_ICU_STAY ENCNTR_ID
AOAV_MED_RESULT ENCNTR_ID
AOAV_OUTCOME ENCNTR_ID
AOAV_PERSON_ENCNTR ENCNTR_ID
AP_EXT_DATA ENCNTR_ID
AP_LOGIN_ORDER_LIST ENCNTR_ID
AUTHORIZATION ENCNTR_ID
AUTO_DIRECTED ENCNTR_ID
BATCH_TRANS_FILE ENCNTR_ID
BBHIST_PRODUCT_EVENT ENCNTR_ID
BB_SPEC_EXPIRE_OVRD ENCNTR_ID
BCE_EVENT_LOG ENCNTR_ID
BH_GROUP_DOC_PATIENT ENCNTR_ID
BMDI_ADT_PERSON_R ENCNTR_ID
CAC_DOCUMENT ENCNTR_ID
CDI_TRANS_LOG ENCNTR_ID
CE_EVENT_ACTION ENCNTR_ID
CE_FLAGGED_RESULT ENCNTR_ID
CE_INTAKE_OUTPUT_RESULT ENCNTR_ID
CE_IO_TOTAL_RESULT ENCNTR_ID
CE_LINKED_RESULT ENCNTR_ID
CHARGE ENCNTR_ID
CHARGE ORIGINAL_ENCNTR_ID
CHARGE_BATCH_DETAIL ENCNTR_ID
CHARGE_EVENT ENCNTR_ID
CHARGE_TRANS_LOG ENCNTR_ID
CHART_ENCNTR_DISCHARGE ENCNTR_ID
CHART_PROCESS ENCNTR_ID
CHART_REQUEST ENCNTR_ID
CHART_REQUEST_ENCNTR ENCNTR_ID
CHART_TEMP ENCNTR_ID
CLINICAL_EVENT ENCNTR_ID
CN_DCP_SHIFT_ASSIGNMENT_ST ENCNTR_ID
CODING ENCNTR_ID
CODING_AUDIT ENCNTR_ID
CODING_ENTITY ENCNTR_ID
CODING_HIST ENCNTR_ID
CODING_SPECIALTY ENCNTR_ID
CODING_SPECIALTY MERGED_ENCNTR_ID
COMPLETION_HOLD ENCNTR_ID
CONDITION_PRIORITY ENCNTR_ID
CORRECTED_PRODUCT ENCNTR_ID
CP_PATHWAY_ACTION ENCNTR_ID
CP_PATHWAY_ACTIVITY ENCNTR_ID
CR_REPORT_REQUEST ENCNTR_ID
CR_REPORT_REQUEST_ENCNTR ENCNTR_ID
CR_XML_DOC_REQUEST ENCNTR_ID
CS_CPP_ERROR_LOG ENCNTR_ID
CS_CPP_UNDO ENCNTR_ID
CUSTOM_PT_LIST_ENTRY ENCNTR_ID
CV_CASE ENCNTR_ID
CV_PROC ENCNTR_ID
CV_PROC_HX ENCNTR_ID
CV_STG_METADATA ENCNTR_ID
DCP_FORMS_ACTIVITY ENCNTR_ID
DCP_MP_PL_CUSTOM_ENTRY ENCNTR_ID
DCP_PL_CUSTOM_ENTRY ENCNTR_ID
DCP_PL_PRIORITIZATION ENCNTR_ID
DCP_SHIFT_ASSIGNMENT ENCNTR_ID
DD_CONTRIBUTION ENCNTR_ID
DD_SDOC_SECTION ENCNTR_ID
DIAGNOSIS ENCNTR_ID
DIAGNOSIS_HIST ENCNTR_ID
DM_COMBINE_ERROR ENCNTR_ID
DM_COMBINE_QUEUE ENCNTR_ID
DOCUMENT_QUALITY_REVIEW ENCNTR_ID
DOC_TRANSCRIPTION_QUEUE ENCNTR_ID
DQR_DOCUMENT_ACTION ENCOUNTER_ID
DRG ENCNTR_ID
DRG_ENCNTR_EXTENSION ENCNTR_ID
DRG_SPECIALTY ENCNTR_ID
DSI_FEEDBACK ENCNTR_ID
DSM_ASSESSMENT ENCNTR_ID
DTS_TRANS_STATS ENCNTR_ID
EEM_ABN_CHECK ENCNTR_ID
EEM_ABN_LINK ENCNTR_ID
EEM_AUTH_DETAIL ENCOUNTER_ID
EEM_BENEFIT_ALLOC ENCNTR_ID
EEM_NOTIFICATION_DETAIL ENCNTR_ID
EEM_RX_ELIG_DETAIL ENCNTR_ID
EKS_ADVSR_EVENT ENCNTR_ID
EKS_ALERT_ESCALATION ENCNTR_ID
EKS_ALERT_ESC_HIST ENCNTR_ID
EKS_DLG_EVENT ENCNTR_ID
EKS_MODULE_AUDIT_DET ENCNTR_ID
ENCNTR_ACCIDENT ENCNTR_ID
ENCNTR_ALIAS_HIST ENCNTR_ID
ENCNTR_AMBULANCE ENCNTR_ID
ENCNTR_APPEAL ENCNTR_ID
ENCNTR_AUGM_CARE_PERIOD ENCNTR_ID
ENCNTR_AVOIDABLE_DAYS ENCNTR_ID
ENCNTR_CARE_MGMT ENCNTR_ID
ENCNTR_CARE_MGMT_COMM ENCNTR_ID
ENCNTR_CATCHMENT_RELTN ENCNTR_ID
ENCNTR_CATCHMENT_R_HIST ENCNTR_ID
ENCNTR_CLASSIFICATION ENCNTR_ID
ENCNTR_CLIN_REVIEW ENCNTR_ID
ENCNTR_CMNTY_CASE ENCNTR_ID
ENCNTR_CODE_VALUE_R ENCNTR_ID
ENCNTR_CODE_VALUE_R_HIST ENCNTR_ID
ENCNTR_COMBINE FROM_ENCNTR_ID
ENCNTR_COMBINE TO_ENCNTR_ID
ENCNTR_CONDITION_CODE ENCNTR_ID
ENCNTR_CRIMINAL_CHARGES_R ENCNTR_ID
ENCNTR_DATA_NOT_COLL ENCNTR_ID
ENCNTR_DENIED_DAYS ENCNTR_ID
ENCNTR_DOMAIN ENCNTR_ID
ENCNTR_ENCNTR_RELTN ENCNTR_ID
ENCNTR_ENCNTR_RELTN RELATED_ENCNTR_ID
ENCNTR_EVENT_SET_IO ENCNTR_ID
ENCNTR_FLEX_HIST ENCNTR_ID
ENCNTR_INFO ENCNTR_ID
ENCNTR_INFO_HIST ENCNTR_ID
ENCNTR_INPTNT_REHAB ENCNTR_ID
ENCNTR_LEAVE ENCNTR_ID
ENCNTR_LEGAL_AUTH_RELTN ENCNTR_ID
ENCNTR_LEGAL_AUTH_R_HIST ENCNTR_ID
ENCNTR_LEGAL_STATUS_R ENCNTR_ID
ENCNTR_LOCATION ENCNTR_ID
ENCNTR_LOC_HIST ENCNTR_ID
ENCNTR_MEDICARE_MGMT ENCNTR_ID
ENCNTR_MOTHER_CHILD_RELTN CHILD_ENCNTR_ID
ENCNTR_MOTHER_CHILD_RELTN MOTHER_ENCNTR_ID
ENCNTR_NEWBORN_CE_RELTN ENCNTR_ID
ENCNTR_OCCURRENCE_CODE ENCNTR_ID
ENCNTR_ORG_RELTN ENCNTR_ID
ENCNTR_ORG_SERVICE_RELTN ENCNTR_ID
ENCNTR_PENDING ENCNTR_ID
ENCNTR_PENDING_HIST ENCNTR_ID
ENCNTR_PERSON_RELTN ENCNTR_ID
ENCNTR_PLAN_COB ENCNTR_ID
ENCNTR_PLAN_RELTN ENCNTR_ID
ENCNTR_POSTACUTE_ORG_RELTN ENCNTR_ID
ENCNTR_PROCEDURE ENCNTR_ID
ENCNTR_PRSNL_GRP_RELTN ENCNTR_ID
ENCNTR_PRSNL_RELTN ENCNTR_ID
ENCNTR_PRSNL_RELTN_HISTORY ENCNTR_ID
ENCNTR_READMIT_ASSESS ENCNTR_ID
ENCNTR_READMIT_ASSESS PREVIOUS_ENCNTR_ID
ENCNTR_SLICE ENCNTR_ID
ENCNTR_SOCIAL_HEALTHCARE ENCNTR_ID
ENCNTR_SPAN_CODE ENCNTR_ID
ENCNTR_VALUE_CODE ENCNTR_ID
EPA_RECORD ENCNTR_ID
EPISODE_ACTIVITY CREATED_BY_ENCNTR_ID
EPISODE_ACTIVITY_HIST CREATED_BY_ENCNTR_ID
EPISODE_ENCNTR_RELTN ENCNTR_ID
ERX_EXT_MED_LIST_ACCESS ENCNTR_ID
ESI_LOG ENCNTR_ID
ESO_TRANSACTION_RECORD ENCNTR_ID
EXAM_DATA ENCNTR_ID
EXPEDITE_LOG ENCNTR_ID
EXPEDITE_MANUAL ENCNTR_ID
EXT_DATA_GROUP SUBMITTED_ENCNTR_ID
EXT_DATA_INFO ENCNTR_ID
EXT_REQ_STATUS ENCNTR_ID
FHX_ACTIVITY ORIGINATING_ENCNTR_ID
FILL_PRINT_ORD_HX ENCNTR_ID
FN_EV_SURVEY_ACT ENCNTR_ID
FN_OMF_ENCNTR ENCNTR_ID
GEN_LAB_EXT_DATA ENCNTR_ID
HANDHELD_DETAIL ENCNTR1_ID
HANDHELD_DETAIL ENCNTR2_ID
HCM_COMM_EVENT ENCNTR_ID
HCM_COMM_EVENT_H ENCNTR_ID
HEALTH_CONCERN DOCUMENTED_ENCNTR_ID
HEALTH_CONCERN LAST_UPDT_ENCNTR_ID
HIM_EVENT_ALLOCATION ENCNTR_ID
HIM_LETTERS_TEMP ENCNTR_ID
HIM_PV_CHART ENCNTR_ID
HIM_PV_DOCUMENT ENCNTR_ID
HIM_PV_PHYSICIAN ENCNTR_ID
HIM_REQUEST_CRITERIA ENCNTR_ID
HIM_REQUEST_PATIENT ENCNTR_ID
HIM_TEMP_REQUEST_LOG ENCNTR_ID
HIM_UNSIGNED_ORDERS ENCNTR_ID
HISTORY_ACTION ENCNTR_ID
HM_RECOMMENDATION_ACTION ENCNTR_ID
HOLD_QUEUE ENCNTR_ID
IB_RX_REQ_ACTION PROPOSED_ENCNTR_ID
IMMUNIZATION_EXT_DATA ENCNTR_ID
IMPLANT_HISTORY ENCNTR_ID
IMPLANT_HISTORY ORIGINATING_ENCNTR_ID
IM_U_NOTIFY ENCNTR_ID
INFUSION_BILLING_EVENT ENCNTR_ID
INFUSION_BILL_RPT ENCNTR_ID
INTERFACE_TRANSACTION ENCNTR_ID
IO_DEVICE_INTERRUPT ENCNTR_ID
IO_TOTAL_START_TIME ENCNTR_ID
LAB_EXT_IDENTIFIER ENCNTR_ID
LH_CNT_IC_ADV_EVENT_LOC ENCNTR_ID
LH_CNT_IC_ADV_LAB_DATA ENCNTR_ID
LH_CNT_IC_ADV_LTD ENCNTR_ID
LH_CNT_IC_ADV_MICRO ENCNTR_ID
LH_CNT_IC_ADV_SURG_DATA ENCNTR_ID
LH_CNT_IC_ADV_WOUND_DATA ENCNTR_ID
LH_CNT_IC_LOC_HIST ENCNTR_ID
LH_CNT_IC_MED_ADMIN_EVENT ENCNTR_ID
LH_CNT_IC_MICRO_EVENT ENCNTR_ID
LH_CNT_IC_PATIENT_POP ENCNTR_ID
LH_CNT_IC_PATIENT_POP_TAGS ENCNTR_ID
LH_CNT_IC_RPT_EVENT ENCNTR_ID
LH_CNT_IC_VAE ENCNTR_ID
LH_CNT_IRFPAI ENCNTR_ID
LH_CNT_IRFPAI_CHANGE ENCNTR_ID
LH_CNT_IRFPAI_ICD ENCNTR_ID
LH_CNT_LTD_DATA INSERT_ENCNTR_ID
LH_CNT_PATIENT_EXTENSION ENCNTR_ID
LH_CNT_READMIT_WORKLIST ENCNTR_ID
LH_CNT_REPORT ENCNTR_ID
LH_CNT_WL_POP ENCNTR_ID
LH_CNT_WL_POP_H ENCNTR_ID
LINE_ITEM ENCNTR_ID
MAMMO_STUDY ENCNTR_ID
MEDIA_ENCNTR_RELTN ENCNTR_ID
MEDIA_EXAM ENCNTR_ID
MEDIA_MASTER ENCNTR_ID
MED_ADMIN_IDENT_ERROR ENCNTR_ID
MED_ADMIN_INGREDIENT_META ENCNTR_ID
MED_ADMIN_MED_ERROR ENCOUNTER_ID
MED_ADMIN_RECORD ENCNTR_ID
MED_HISTORY_AUDIT ENCNTR_ID
MESSAGING_AUDIT ENCNTR_ID
MIC_ACT_ANG_SUM_RPT ENCNTR_ID
MIC_EXT_DATA ENCNTR_ID
MIC_IC_ORDERS ENCNTR_ID
MIC_STAT_ORDER ENCNTR_ID
MM_TRANS_LINE ENCNTR_ID
MP_NOTIFICATION ENCNTR_ID
MP_PRIMED_VIEW_ACT ENCNTR_ID
NC_CHARTED_SECTION ENCNTR_ID
NC_CHARTED_VIEW ENCNTR_ID
NOMENCLATURE_ENCNTR_DESC ENCNTR_ID
NOMEN_ENTITY_RELTN ENCNTR_ID
NURSING_ENCNTR_SCRATCHPAD ENCNTR_ID
OMF_ABSTRACT_DATA_ST ENCNTR_ID
OMF_ABST_CODING_RELTN_ST ENCNTR_ID
OMF_APC_CODING_ST ENCNTR_ID
OMF_CHARGE_ST ENCNTR_ID
OMF_CLINICAL_EVENT_ST ENCNTR_ID
OMF_CODING_ST ENCNTR_ID
OMF_ENCNTR_PRSNL_RELTN_ST ENCNTR_ID
OMF_ENCNTR_ST ENCNTR_ID
OMF_ENCNTR_ST_EXT ENCNTR_ID
OMF_ENCNTR_TYPE_HIST_ST ENCNTR_ID
OMF_LOCATION_HIST_ST ENCNTR_ID
OMF_MED_SERVICE_HIST_ST ENCNTR_ID
OMF_ORDER_ST ENCNTR_ID
OMF_POSTED_CHARGE_ST ENCNTR_ID
OMF_RADMGMT_ORDER_ST ENCNTR_ID
OMF_REVENUE_ST ENCNTR_ID
OMF_SVC_CAT_HIST_ST ENCNTR_ID
ONC_FORM_ACTIVITY ENCNTR_ID
ONC_II_AUTO_ACTIVITY ENCNTR_ID
ONC_INFUSION_ACTIVITY ENCNTR_ID
ORDERS ENCNTR_ID
ORDERS ORIGINATING_ENCNTR_ID
ORDER_COMPLIANCE ENCNTR_ID
ORDER_DAILY_REVIEW_RSPNL ENCNTR_ID
ORDER_DISPENSE ENCNTR_ID
ORDER_PROPOSAL ENCNTR_ID
ORDER_PROPOSAL ORIGINATING_ENCNTR_ID
ORDER_RADIOLOGY ENCNTR_ID
ORDER_RECON ENCNTR_ID
ORDER_STAGING ENCOUNTER_ID
ORDER_SUPPLY_REVIEW ENCNTR_ID
ORDER_TRACKING_WORKLIST EFFECTIVE_ENCNTR_ID
ORD_RQSTN ENCNTR_ID
ORM_ERROR_LOG ENCNTR_ID
ORM_ORD_HIST_SNAPSHOT ENCNTR_ID
ORM_ORD_HIST_SNAPSHOT_COMP ENCNTR_ID
OUTCOME_ACTIVITY ENCNTR_ID
PASSIVE_ALERT ENCNTR_ID
PATHOLOGY_CASE ENCNTR_ID
PATHWAY ENCNTR_ID
PATIENT_CASE_ENCNTR_R ENCNTR_ID
PATIENT_EVENT ENCNTR_ID
PAT_ED_DOCUMENT ENCNTR_ID
PCA_ENCNTR_MEASURE_OUTCOME ENCNTR_ID
PCA_ENCNTR_TOPIC_RELTN ENCNTR_ID
PCT_IPASS ENCNTR_ID
PDOC_AUTOSAVE ENCNTR_ID
PDOC_TAG ENCNTR_ID
PDOC_TAG_TEXT ENCNTR_ID
PERSON_ABORH_RESULT ENCNTR_ID
PERSON_ANTIBODY ENCNTR_ID
PERSON_ANTIGEN ENCNTR_ID
PERSON_RH_PHENO_RESULT ENCNTR_ID
PERSON_TRANS_REQ ENCNTR_ID
PFT_ACCT_FIN_ENCNTR ENCNTR_ID
PFT_ARWB_DATA_EXT ENCNTR_ID
PFT_AR_CONV_CODES ENCNTR_ID
PFT_AR_CONV_TRANS ENCNTR_ID
PFT_BENEFIT_ORDER ENCNTR_ID
PFT_CHARGE_GLOBAL_DAYS ENCNTR_ID
PFT_CM_ERROR ENCNTR_ID
PFT_COMBINE_LOG FROM_ENCNTR_ID
PFT_COMBINE_LOG TO_ENCNTR_ID
PFT_ENCNTR ENCNTR_ID
PFT_ENCNTR_ALIAS ENCNTR_ID
PFT_ENCNTR_CODE ENCNTR_ID
PFT_ENCNTR_FACT ENCNTR_ID
PFT_ENCNTR_HIST ENCNTR_ID
PFT_QUEUE_ITEM ENCNTR_ID
PFT_REG_MOD ENCNTR_ID
PFT_SYSTEM_ACTIVITY_LOG ENCNTR_ID
PHA_BATCH_REPORT_ACT ENCNTR_ID
PHA_DISP_OBS_ST ENCNTR_ID
PHA_ORD_ACT_OBS_ST ENCNTR_ID
PHA_PROD_DISP_OBS_ST ENCNTR_ID
PIE_RECORD_COMPLIANCE ENCNTR_ID
PM_DOC_PRINT_HIST ENCNTR_ID
PM_HIST_TRACKING ENCNTR_ID
PM_LOCATOR ENCNTR_ID
PM_MENTAL_HEALTH ENCNTR_ID
PM_OFFER ENCNTR_ID
PM_OFFER_HIST ENCNTR_ID
PM_POST_PROCESS ENCNTR_ID
PM_RBC_RS_ENCNTR_R ENCNTR_ID
PM_ROOM_BED_CHARGE ENCNTR_ID
PM_TRANSFER_ENCNTR_RELTN ENCNTR_ID
PM_WAIT_LIST ENCNTR_ID
PM_WAIT_LIST_HIST ENCNTR_ID
PM_WORK_QUEUE ENCNTR_ID
PPR_CONSENT_STATUS ENCNTR_ID
PP_AUDIT_EVENT ENCNTR_ID
PREGNANCY_INFORMATION ENCNTR_ID
PREGNANCY_INSTANCE ENCNTR_ID
PROBLEM ORIGINATING_ENCNTR_ID
PROBLEM UPDATE_ENCNTR_ID
PROBLEM_EXT_DATA ENCNTR_ID
PROCEDURE ENCNTR_ID
PROCEDURE_ACTION UPDATE_ENCNTR_ID
PROCEDURE_EXT_DATA ENCNTR_ID
PROCEDURE_HIST ENCNTR_ID
PRODUCT_EVENT ENCNTR_ID
PROP_ORDER ENCNTR_ID
PRSNL_RELTN_ACTIVITY ENCNTR_ID
PW_PROCESSING_ACTION ENCNTR_ID
RAD_STG_DATA ENCNTR_ID
RCA_MOBILE_SESSION ENCNTR_ID
RCM_DIRECT_COMM ENCNTR_ID
RCM_DOC_REVIEW ENCNTR_ID
RCM_DRG ENCNTR_ID
RCM_NOTE ENCNTR_ID
RCM_POST_ACUTE_EVENT ENCNTR_ID
RCM_POST_ACUTE_UPLOAD ENCNTR_ID
RCM_SECURITY_TOKEN ENCNTR_ID
RCM_TLC_PLACEMENT ENCNTR_ID
RCM_TLC_SERVICE ENCNTR_ID
RC_CLOUD_TRANSACTION ENCNTR_ID
REFERRAL OUTBOUND_ENCNTR_ID
REFERRAL_HIST OUTBOUND_ENCNTR_ID
REF_CD_MAP_HEADER ENCNTR_ID
REGIMEN ENCNTR_ID
REVIEW_GROUP_RELTN ENCNTR_ID
RXS_ITEM_GROUP_ACT ENCNTR_ID
RXS_LOCATION_TASK ENCNTR_ID
RXS_LOCATOR_ENCNTR ENCNTR_ID
RXS_ORDER_TASK_QUEUE ENCNTR_ID
RX_IMAGE ENCNTR_ID
RX_PENDING_REFILL ENCNTR_ID
RX_REFILL_HX ENCNTR_ID
RX_WORK_ITEM_QUEUE ENCNTR_ID
SA_ANESTHESIA_REC_FIELD_VALUES ENCNTR_ID
SA_TODO_MEDICATION ENCNTR_ID
SCD_STORY ENCOUNTER_ID
SCH_APPT ENCNTR_ID
SCH_BOOKING ENCNTR_ID
SCH_ENTRY ENCNTR_ID
SCH_EVENT_PATIENT ENCNTR_ID
SCH_EVENT_RECUR_LIST ENCNTR_ID
SCH_EVENT_RECUR_ROLE ENCNTR_ID
SCH_LOC_BOOKING ENCNTR_ID
SCH_PEND_EVENT ENCNTR_ID
SERVICE_CATEGORY_HIST ENCNTR_ID
SHX_ACTIVITY ORIGINATING_ENCNTR_ID
SHX_ACTIVITY UPDATE_ENCNTR_ID
SI_CUSTOM_CDG_LOG ENCNTR_ID
SI_DOCUMENT_INFO ENCNTR_ID
SI_DOCUMENT_METADATA ENCNTR_ID
SI_DOCUMENT_TRANSACTION_LOG ENCNTR_ID
SI_ERX_DIGITAL_SIG_LOG ENCNTR_ID
SI_INTEROP_METADATA ENCNTR_ID
SI_TRANSACTION ENCNTR_ID
SI_TRANSACTION_SET ENCNTR_ID
SUBSCRIPTION ENCOUNTER_ID
SURGICAL_CASE ENCNTR_ID
SURG_REQ ENCNTR_ID
TAG_COLOR ENCNTR_ID
TASK_ACTIVITY ENCNTR_ID
TASK_ACTIVITY_HISTORY ENCNTR_ID
TASK_ACTIVITY_MSG_H ENCNTR_ID
TEMPORARY_EXAM ENCNTR_ID
TRACKING_AUDIT ENCNTR_ID
TRACKING_COMMENT ENCNTR_ID
TRACKING_ENCNTR_EXTENSION ENCNTR_ID
TRACKING_ITEM ENCNTR_ID
TRACKING_PREARRIVAL ATTACHED_ENCNTR_ID
TRACK_TRIGGER_ACTIVITY ENCNTR_ID
TRANSACTION_ADMIT_NOTIFY ENCNTR_ID
TRANSACTION_ELIGIBILITY ENCNTR_ID
UM_CHARGE_EVENT_ST ENCNTR_ID
VISITCODING_AUDIT ENCNTR_ID
VITALS_EXT_DATA ENCNTR_ID
WKF_WORKFLOW ENCNTR_ID
WL_ACTIVITY ENCNTR_ID
WORKING_VIEW_PERSON ENCNTR_ID


EPISODE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Episode
Definition: The episode table identifies a grouping or collection of information depending on the type of episode. If it is a person episode, then the episode might point to a series of encounters for the person related to a chronic condition or diagnosis.
Table Type: ACTIVITY





Column Detail - EPISODE


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.
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.
CREATE_DT_TM DATETIME Y The date and time this episode was created.
CREATE_PRSNL_ID DOUBLE Y The ID of the person who created the episode.
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.
DISPLAY VARCHAR(100) Y Episode name.
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.
EPISODE_BREACH_DT_TM DATETIME Y Contains the breach date and time for the episode. The breach date is the date that the episode is supposed to be completed by. If it continues past the breach_dt_tm then the episode is considered breached.
EPISODE_CLOSE_REASON_CD DOUBLE N The reason for closing an episode.
EPISODE_ID DOUBLE N This is the value of the unique primary identifier of the episode table. It is an internal system assigned number.
EPISODE_PAUSE_DAYS_CNT DOUBLE N Count of the number of pause days used to calculate the episode_breach_dt_tm or can be used to determine how many days were not paused between the episode start date time and the episode stop date time.
EPISODE_START_DT_TM DATETIME Y The Start Date and Time of the Episode.
EPISODE_STATUS_CD DOUBLE N The Current Status of the Episode.
EPISODE_STOP_DT_TM DATETIME Y The Stop Date and Time of the Episode.
EPISODE_TYPE_CD DOUBLE N Episode type code identifies the kind of episode (I.e., person, research, epidemic, etc.).
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
REFER_FACILITY_CD DOUBLE N The Location of the Referring Facility.
SERVICE_CATEGORY_CD DOUBLE N Codified field which identifies the current category of service the patient is receiving for this episode.
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 - EPISODE


Child Column in EPISODE(FK) Parent Table Name Parent Column Name
Parents: PERSON_ID PERSON PERSON_ID




Parent Column in EPISODE (PK) Child Table Name Child Column Name
Children: EPISODE_ID EPISODE_ACTIVITY EPISODE_ID
EPISODE_PRSNL_RELTN EPISODE_ID
EPISODE_PRSNL_RELTN_HIST EPISODE_ID
MEDIA_MASTER EPISODE_ID
PT_PROT_REG EPISODE_ID


EPISODE_ACTIVITY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Episode Activity
Definition: Contains Activities Performed during an Episode.
Table Type: ACTIVITY





Column Detail - EPISODE_ACTIVITY


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.
ACTIVITY_CD DOUBLE N The activity that was performed.
ACTIVITY_DT_TM DATETIME N The date and time the activity was performed.
ACTIVITY_TYPE_CD DOUBLE N The Type of Activity that was performed.
CREATED_BY_CE_EVENT_ID DOUBLE N The ID of the clinical event that generated the activity row to be written if the activity was generated by a clinical event.
CREATED_BY_ENCNTR_ID DOUBLE N The ID of the encounter that generated the activity row to be written if the activity was generated by an encounter.
CREATED_BY_SCHEDULE_ID DOUBLE N The ID of the schedule that generated the activity row to be written if the activity was generated by a schedule.
EPISODE_ACTIVITY_ID DOUBLE N The unique primary key of this table. It is an internally generated number.
EPISODE_ID DOUBLE N The ID of the episode associated to the activity.
EPISODE_PAUSE_DAYS_CNT DOUBLE N Number of pause days counter for current activity.
EPISODE_STATUS_CD DOUBLE N The Episode Status when the Activity was performed
INTENDED_EPISODE_STATUS_CD DOUBLE N The status that was intended to be set on the episode when performing the episode activity.
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 - EPISODE_ACTIVITY


Child Column in EPISODE_ACTIVITY(FK) Parent Table Name Parent Column Name
Parents: CREATED_BY_ENCNTR_ID ENCOUNTER ENCNTR_ID
EPISODE_ID EPISODE EPISODE_ID
CREATED_BY_SCHEDULE_ID SCH_SCHEDULE SCHEDULE_ID




Parent Column in EPISODE_ACTIVITY (PK) Child Table Name Child Column Name
Children: EPISODE_ACTIVITY_ID EPISODE_ACTIVITY_HIST EPISODE_ACTIVITY_ID


EPISODE_ACTIVITY_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Episode Activity History
Definition: Contains History of Activities Performed during an Episode.
Table Type: ACTIVITY





Column Detail - EPISODE_ACTIVITY_HIST


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
ACTIVITY_CD DOUBLE N The activity that was performed.
ACTIVITY_DT_TM DATETIME N The date and time the activity was performed.
ACTIVITY_TYPE_CD DOUBLE N The Type of Activity that was performed.
CREATED_BY_CE_EVENT_ID DOUBLE N The ID of the clinical event that generated the activity row to be written if the activity was generated by a clinical event.
CREATED_BY_ENCNTR_ID DOUBLE N The ID of the encounter that generated the activity row to be written if the activity was generated by an encounter.
CREATED_BY_SCHEDULE_ID DOUBLE N The ID of the schedule that generated the activity row to be written if the activity was generated by a schedule.
CREATE_DT_TM DATETIME N The date and time that the history row was created.
EPISODE_ACTIVITY_HIST_ID DOUBLE N This is the value of the unique primary identifier of the episode activity hist table. It is an internal system assigned number.
EPISODE_ACTIVITY_ID DOUBLE N The Episode Activity Row that the history row relates to.
EPISODE_ID DOUBLE N The Episode that the activity is written for.
EPISODE_PAUSE_DAYS_CNT DOUBLE N Number of pause days counter for current activity.
EPISODE_STATUS_CD DOUBLE N The Episode Status when the Activity was performed.
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 - EPISODE_ACTIVITY_HIST


Child Column in EPISODE_ACTIVITY_HIST(FK) Parent Table Name Parent Column Name
Parents: CREATED_BY_ENCNTR_ID ENCOUNTER ENCNTR_ID
EPISODE_ACTIVITY_ID EPISODE_ACTIVITY EPISODE_ACTIVITY_ID