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. |