ACTIVITY_DT_TM |
DATETIME |
N |
Date and time the transaction happened |
CURRENT_USER |
CHAR(10) |
Y |
Current User of the system when this transaction row was created |
HL7_EVENT |
VARCHAR(10) |
Y |
Stores the according HL7_Event. |
N_ACCOM_CD |
DOUBLE |
N |
The codeset value for the new accommodation. |
N_ACCOM_REQ_CD |
DOUBLE |
N |
Code value representing the new accommodation request. |
N_ADMIT_DOC_ID |
DOUBLE |
N |
ID of the new Doctor that admitted the patient. This is a key from the personnel (prsnl) table. |
N_ADMIT_DOC_NAME |
CHAR(30) |
Y |
Name of new doctor that admitted the patient. |
N_ADMIT_DOC_NBR |
CHAR(16) |
Y |
Doctor Number for the new admitting doctor. |
N_ADMIT_MODE_CD |
DOUBLE |
N |
Code value for the new admit. |
N_ADMIT_SRC_CD |
DOUBLE |
N |
Code value for the new admit source. |
N_ADMIT_TYPE_CD |
DOUBLE |
N |
Code value for the new admit type. |
N_ADMIT_WITH_MED_CD |
DOUBLE |
N |
Code value for a new admit with medication. |
N_ALT_LVL_CARE_CD |
DOUBLE |
N |
New alternate level of care code value. |
N_ALT_RESULT_DEST_CD |
DOUBLE |
N |
*** No longer in Use *** |
N_AMB_COND_CD |
DOUBLE |
N |
New Ambulatory Condition Code value. Ambulatory condition describes the general physical condition, impairment, or limitation of the patient upon arrival. |
N_ARRIVE_DT_TM |
DATETIME |
Y |
Date/Time of new transaction arrival. |
N_ASSIGN_TO_LOC_DT_TM |
DATETIME |
Y |
Date and time that the encounter was assigned to a location. |
N_ATTEND_DOC_ID |
DOUBLE |
N |
ID of new attending doctor. This is a primary key from the personnel (prsnl) table. |
N_ATTEND_DOC_NAME |
CHAR(30) |
Y |
Name of new attending doctor. |
N_ATTEND_DOC_NBR |
CHAR(16) |
Y |
Doctor Nuber of new attending doctor |
N_AUTOPSY_CD |
DOUBLE |
N |
New Autopsy Code Value |
N_BIRTH_DT_CD |
DOUBLE |
N |
New Birth Date Code Value |
N_BIRTH_DT_TM |
DATETIME |
Y |
Date/Time of new birth. |
N_CAUSE_OF_DEATH |
CHAR(40) |
Y |
New Cause of Death |
N_CHART_ACCESS_ORGANIZATION_ID |
DOUBLE |
Y |
New Identifier. The identifying information of the organization (real or vitural) taht indicates which groups of users should have a medical changre access to the encounter. |
N_CITIZENSHIP_CD |
DOUBLE |
N |
New Citizenship Code Value. |
N_CMNTY_CASE_CLOSURE_REASON_CD |
DOUBLE |
N |
The new community case closure reason. The reason the community case was closed. |
N_CMNTY_CASE_ENROLLMENT_DT_TM |
DATETIME |
Y |
The new community case enrollment date and time. The date and time of the patient's enrollment on the community case. |
N_CMNTY_CASE_STATUS_CD |
DOUBLE |
N |
The new community case status code. The case status identifies the state of a particular community case from the time it is initiated until it is closed |
N_CONCEPTION_DT_TM |
DATETIME |
Y |
Date and Time of a new conception. |
N_CONFID_LEVEL_CD |
DOUBLE |
N |
New Confidence Level Code Value. |
N_CONSULT_DOC_ID |
DOUBLE |
N |
New Consulting Doctor ID. This is a primary key the personnel (prsnl) table. |
N_CONSULT_DOC_NAME |
CHAR(30) |
Y |
Name of new consulting doctor. |
N_CONSULT_DOC_NBR |
CHAR(16) |
Y |
Doctor Number of new consulting doctor. |
N_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 |
N_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. |
N_DECEASED_CD |
DOUBLE |
N |
This is a codified cause of death. |
N_DECEASED_DT_TM |
DATETIME |
Y |
Date/Time of new deceased transaction. |
N_DEPART_DT_TM |
DATETIME |
Y |
New Date/Time of patient departure. |
N_DIET_TYPE_CD |
DOUBLE |
N |
New Diet Type Code Value. Diet type is used to indicate that the patient is on a special diet. |
N_DISCH_DISP_CD |
DOUBLE |
N |
The conditions under which the patient left the facility at the time of discharge. |
N_DISCH_DT_TM |
DATETIME |
Y |
Date/Time of new discharge. |
N_DISCH_TO_LOCTN_CD |
DOUBLE |
N |
New Discharge to Location Code Value. The location to which the patient was discharged such as another hospital or nursing home. |
N_ENCNTR_CLASS_CD |
DOUBLE |
N |
New Encntr Class Code Value. Encounter class defines how this encounter row is being used in relation to the person table. |
N_ENCNTR_COMPLETE_DT_TM |
DATETIME |
Y |
Encounter complete date/time after updates have occurred |
N_ENCNTR_FIN_ID |
DOUBLE |
N |
New Encounter Financial Id. This is the value of the unique primary identifier of the encounter financial table. It is an internal system assigned number. |
N_ENCNTR_ID |
DOUBLE |
N |
New Encounter ID. This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number. |
N_ENCNTR_SEX_CD |
DOUBLE |
N |
New Encntr Sex Code Value. Code that represents the sex of the patient in a transaction. |
N_ENCNTR_STATUS_CD |
DOUBLE |
N |
New Encounterr Status Code. 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). |
N_ENCNTR_TYPE_CD |
DOUBLE |
N |
New Ecounter Type Code. Encounter type such as Inpatient, Outpatient, ER, etc. |
N_ENCNTR_TYPE_CLASS_CD |
DOUBLE |
N |
New Encounter Type Class Code. 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. |
N_ENCNTR_VIP_CD |
DOUBLE |
N |
New Enchounter VIP Code. 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). |
N_EST_ARRIVE_DT_TM |
DATETIME |
Y |
New Estimated Arrive Date/Time. |
N_EST_DEPART_DT_TM |
DATETIME |
Y |
New Estimated Depart Date/Time |
N_ETHNIC_GRP_CD |
DOUBLE |
N |
New Ethnic Group Code Value |
N_FIN_CLASS_CD |
DOUBLE |
N |
The financial classification. Examples may include Worker's Comp, Self Pay, etc. |
N_FIN_NBR |
CHAR(20) |
Y |
New Financial Number. |
N_GUAR_TYPE_CD |
DOUBLE |
N |
New Guaranotor Type Code. 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. |
N_ISOLATION_CD |
DOUBLE |
N |
New Isolation Code. 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. |
N_LANGUAGE_CD |
DOUBLE |
N |
New Language Code. The code_value identifying the language of the patient. |
N_LANG_DIALECT_CD |
DOUBLE |
N |
New Language Dialect Code. The dialect of the primary language spoken by the person. |
N_LOCATION_CD |
DOUBLE |
N |
New Location Code. 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. |
N_LOC_BED_CD |
DOUBLE |
N |
New Location Bed Code. This field is the current patient location with a location type of bed. |
N_LOC_BUILDING_CD |
DOUBLE |
N |
New Location Building Code. This field is the current patient location with a location type of building. |
N_LOC_FACILITY_CD |
DOUBLE |
N |
New Location Facility Code. This field is the current patient location with a location type of facility. |
N_LOC_NURSE_UNIT_CD |
DOUBLE |
N |
New Location Nurse Unit Code. This field is the current patient location with a location type of Nurse Unit. |
N_LOC_ROOM_CD |
DOUBLE |
N |
New Location Room Code. This field is the current patient location with a location type of room. |
N_LOC_TEMP_CD |
DOUBLE |
N |
New Location Temporary Code. This field identifies the temporary location of the patient. The temporary location may be valued at the same time the location_cd is valued. |
N_MARITAL_TYPE_CD |
DOUBLE |
N |
New Marital Type Code. This field identifies the status of the person with regard to being married. |
N_MED_SERVICE_CD |
DOUBLE |
N |
New Medical Serice Code. 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. |
N_MRN |
CHAR(20) |
Y |
New Medical Record Number |
N_MTHR_MAID_NAME |
CHAR(20) |
Y |
New Mother's Maiden Name |
N_NAME_FIRST |
CHAR(20) |
Y |
New First Name |
N_NAME_FORMATTED |
CHAR(30) |
Y |
New Formatted Name |
N_NAME_LAST |
CHAR(20) |
Y |
New Last Name |
N_NAME_MIDDLE |
CHAR(20) |
Y |
New Middle Name |
N_NATIONALITY_CD |
DOUBLE |
N |
New Nationality Code Value. |
N_ORGANIZATION_ID |
DOUBLE |
N |
Organization ID on encounter after updates have occurred |
N_PERSON_BIRTH_SEX_CD |
DOUBLE |
N |
The new person birth sex code. The sex, typically determined by biological characteristics such as reproductive anatomy or genetic makeup, assigned at birth for the purposes of birth registration. |
N_PERSON_ID |
DOUBLE |
N |
New Person ID. This is a key from the Person table. |
N_PERSON_SEX_CD |
DOUBLE |
N |
The new person sex code. The sex/gender that the patient is considered to have for administration and record keeping purposes. this is typically asserted by the patient when they present to administrative users. this may not match the biological sex as determined by anatomy or genetics, or the individual's preferred identification (gender identity). |
N_PERSON_TYPE_CD |
DOUBLE |
N |
New Person Type Code. The person type field identifies the general type of data being stored in a given person row. As a general guideline, most rows in the person table will be identifiedwith a person type of PERSON. This field can be used to filter out NON-PERSON rows. |
N_PERSON_VIP_CD |
DOUBLE |
N |
New Person VIP Code. 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). |
N_PER_BUS_ADDRESS_ID |
DOUBLE |
N |
New Person Business Address ID. This is a primary key in the Address table. |
N_PER_BUS_ADDR_CITY |
CHAR(40) |
Y |
New Person Business Address City. |
N_PER_BUS_ADDR_COUNTRY |
CHAR(20) |
Y |
New Person Business Address Country |
N_PER_BUS_ADDR_COUNTY |
CHAR(20) |
Y |
New Person Business Address County |
N_PER_BUS_ADDR_STATE |
CHAR(20) |
Y |
New Person Business Address State |
N_PER_BUS_ADDR_STREET |
CHAR(100) |
Y |
New Person Business Address Street |
N_PER_BUS_ADDR_STREET2 |
CHAR(100) |
Y |
New Person Business Address Street 2 |
N_PER_BUS_ADDR_ZIPCODE |
CHAR(20) |
Y |
New Person Business Address Zipcode |
N_PER_BUS_EXT |
CHAR(10) |
Y |
New Person Business Extension |
N_PER_BUS_PHONE_ID |
DOUBLE |
N |
New Person Business Phone ID used to identify a phone number. |
N_PER_BUS_PH_FORMAT_CD |
DOUBLE |
N |
New Person Business Phone Format Code |
N_PER_BUS_PH_NUMBER |
CHAR(20) |
Y |
New Person Business Phone Number |
N_PER_HOME_ADDRESS_ID |
DOUBLE |
N |
New Person Home Address ID |
N_PER_HOME_ADDR_CITY |
CHAR(40) |
Y |
New Person Home Address City |
N_PER_HOME_ADDR_COUNTRY |
CHAR(20) |
Y |
New Person Home Address Country |
N_PER_HOME_ADDR_COUNTY |
CHAR(20) |
Y |
New Person Home Address County |
N_PER_HOME_ADDR_STATE |
CHAR(20) |
Y |
New Person Home Address State |
N_PER_HOME_ADDR_STREET |
CHAR(100) |
Y |
New Person Home Address Street |
N_PER_HOME_ADDR_STREET2 |
CHAR(100) |
Y |
New Person Home Address Street 2 |
N_PER_HOME_ADDR_ZIPCODE |
CHAR(20) |
Y |
New Person Home Address Zipcode |
N_PER_HOME_EXT |
CHAR(10) |
Y |
New Person Home Extension |
N_PER_HOME_PHONE_ID |
DOUBLE |
N |
New Person Home Phone Id |
N_PER_HOME_PH_FORMAT_CD |
DOUBLE |
N |
New Person Home Phone Format Code |
N_PER_HOME_PH_NUMBER |
CHAR(20) |
Y |
New Person Home Phone Number |
N_PREADMIT_NBR |
CHAR(20) |
Y |
New Preadmit Number |
N_PREADMIT_TEST_CD |
DOUBLE |
N |
New Preadmit Test Code |
N_PRE_REG_DT_TM |
DATETIME |
Y |
New Pre-Registration Date/Time. 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. |
N_PRE_REG_PRSNL_ID |
DOUBLE |
N |
New Pre-Registration PersonnelID. 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. |
N_PROGRAM_SERVICE_CD |
DOUBLE |
N |
Code value identifying the new program service associated with the patient registration |
N_RACE_CD |
DOUBLE |
N |
New Race Code. The code_value identifying the race of the patient |
N_READMIT_CD |
DOUBLE |
N |
New Readmit Code. Value contains a description of the encounter readmit. |
N_REASON_FOR_VISIT |
CHAR(40) |
Y |
New Reason For Visit. 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. |
N_REFER_COMMENT |
CHAR(40) |
Y |
A text field containing the comments from the referring physician or service. |
N_REFER_DOC_ID |
DOUBLE |
N |
ID of the new referring doctor. This is a key value from the personnel (prsnl) table. |
N_REFER_DOC_NAME |
CHAR(30) |
Y |
Name of the new referring doctor. |
N_REFER_DOC_NBR |
CHAR(16) |
Y |
Nubmer of the new referring doctor. |
N_REG_DT_TM |
DATETIME |
Y |
New Registration Date/Time. The date/time that the registration or admission process was performed. 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. |
N_REG_PRSNL_ID |
DOUBLE |
N |
New Registration PersonnelID. 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. |
N_RELIGION_CD |
DOUBLE |
N |
New Religion Code. The code_value identifying the religion of the patient. |
N_RESULT_DEST_CD |
DOUBLE |
N |
*** No longer in Use *** |
N_SEX_AGE_CHG_IND |
DOUBLE |
Y |
New Sex Age Change Indicator. This field indicates that the sex of the person has changed as the result of a correction of the data or actual physical change to the person. |
N_SPECIES_CD |
DOUBLE |
N |
New Species Code. A fundamental category of taxonomic classification, ranking after a genus and consisting of organisms capable of interbreeding. |
N_SSN |
CHAR(15) |
Y |
New Social Security Number |
N_VET_MIL_STAT_CD |
DOUBLE |
N |
New Veterans Military Status Code. |
O_ACCOM_CD |
DOUBLE |
N |
The codeset value for the old accommodation. |
O_ACCOM_REQ_CD |
DOUBLE |
N |
Code value representing the old accommodation request. |
O_ADMIT_DOC_ID |
DOUBLE |
N |
ID of the old Doctor that admitted the patient. This is a key from the personnel (prsnl) table. |
O_ADMIT_DOC_NAME |
CHAR(30) |
Y |
Name of old doctor that admitted the patient. |
O_ADMIT_DOC_NBR |
CHAR(16) |
Y |
Doctor Number for the old admitting doctor. |
O_ADMIT_MODE_CD |
DOUBLE |
N |
Code value for the old admit. |
O_ADMIT_SRC_CD |
DOUBLE |
N |
Code value for the old admit source. |
O_ADMIT_TYPE_CD |
DOUBLE |
N |
Code value for the old admit type. |
O_ADMIT_WITH_MED_CD |
DOUBLE |
N |
Code value for an old admit with medication. |
O_ALT_LVL_CARE_CD |
DOUBLE |
N |
Old alternate level of care code value. |
O_ALT_RESULT_DEST_CD |
DOUBLE |
N |
*** No longer in Use *** |
O_AMB_COND_CD |
DOUBLE |
N |
Old Ambulatory Condition Code Value. Ambulatory condition describes the general physical condition, impairment, or limitation of the patient upon arrival. |
O_ARRIVE_DT_TM |
DATETIME |
Y |
Date/Time of old transaction arrival. |
O_ASSIGN_TO_LOC_DT_TM |
DATETIME |
Y |
Date and time that the encounter was assigned to a location. |
O_ATTEND_DOC_ID |
DOUBLE |
N |
ID of old attending doctor. This is a primary key from the personnel (prsnl) table. |
O_ATTEND_DOC_NAME |
CHAR(30) |
Y |
Name of old attending doctor. |
O_ATTEND_DOC_NBR |
CHAR(16) |
Y |
Doctor number of new attending doctor. |
O_AUTOPSY_CD |
DOUBLE |
N |
Old Autopsy Code Value. |
O_BIRTH_DT_CD |
DOUBLE |
N |
New Birth Date Code Value. |
O_BIRTH_DT_TM |
DATETIME |
Y |
Date/Time of new birth. |
O_CAUSE_OF_DEATH |
CHAR(40) |
Y |
Old Cause of Death |
O_CHART_ACCESS_ORGANIZATION_ID |
DOUBLE |
Y |
Old Identifier. The identifying information of the orgainzation (real or virtual) that indicates which groups of users should have medical chart access to the encounter. |
O_CITIZENSHIP_CD |
DOUBLE |
N |
Old Citizenship Code value. |
O_CMNTY_CASE_CLOSURE_REASON_CD |
DOUBLE |
N |
The old community case closure reason. The reason the community case was closed. |
O_CMNTY_CASE_ENROLLMENT_DT_TM |
DATETIME |
Y |
The old community case enrollment date and time. The date and time of the patient's enrollment on the community case. |
O_CMNTY_CASE_STATUS_CD |
DOUBLE |
N |
The old community case status code. The case status identifies the state of a particular community case from the time it is initiated until it is closed |
O_CONCEPTION_DT_TM |
DATETIME |
Y |
Date and time of old conception. |
O_CONFID_LEVEL_CD |
DOUBLE |
N |
Old Confidence Level Code Value. |
O_CONSULT_DOC_ID |
DOUBLE |
N |
Old Consulting Doctor ID. This is a primary key the perosnel (prsnl) table. |
O_CONSULT_DOC_NAME |
CHAR(30) |
Y |
Name of old consulting doctor. |
O_CONSULT_DOC_NBR |
CHAR(16) |
Y |
Doctor number of old consulting doctor. |
O_CONTRIBUTOR_SYSTEM_CD |
DOUBLE |
N |
OId contributor system code. 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 |
O_COURTESY_CD |
DOUBLE |
N |
Old Courtesy Code value. 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. |
O_DECEASED_CD |
DOUBLE |
N |
This is the old codified cause of death. |
O_DECEASED_DT_TM |
DATETIME |
Y |
Date/Time of old deceased transaction. |
O_DEPART_DT_TM |
DATETIME |
Y |
Old date/time of patient departure. |
O_DIET_TYPE_CD |
DOUBLE |
N |
Old Diet Type Code Value. Diet type is used to indicate that the patient is on a special diet. |
O_DISCH_DISP_CD |
DOUBLE |
N |
The conditions under which the patient left the facility at the time of discharge. |
O_DISCH_DT_TM |
DATETIME |
Y |
Date/Time of new discharge. |
O_DISCH_TO_LOCTN_CD |
DOUBLE |
N |
Old Discharge to Location Code Value. The location to which the patient was discharged such as another hospital or nursing home. |
O_ENCNTR_CLASS_CD |
DOUBLE |
N |
Old Encntr Class Code Value. Encounter class defines how this encounter row is being used in relation to the person table. |
O_ENCNTR_COMPLETE_DT_TM |
DATETIME |
Y |
Encounter Complete Date/Time Prior to update |
O_ENCNTR_FIN_ID |
DOUBLE |
N |
Old Encounter Financial Id. This is the value of the unique primary identifier of the encounter financial table. It is an internal system assigned number. |
O_ENCNTR_ID |
DOUBLE |
N |
Old Encounter ID. This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number. |
O_ENCNTR_SEX_CD |
DOUBLE |
N |
Old Encntr Sex Code Value. Code that represents the sex of the patient in a transaction. |
O_ENCNTR_STATUS_CD |
DOUBLE |
N |
Old Encounterr Status Code. 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). |
O_ENCNTR_TYPE_CD |
DOUBLE |
N |
Old Ecounter Type Code. Encounter type such as Inpatient, Outpatient, ER, etc. |
O_ENCNTR_TYPE_CLASS_CD |
DOUBLE |
N |
Old Encounter Type Class Code. 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. |
O_ENCNTR_VIP_CD |
DOUBLE |
N |
Old Encounter VIP Code. 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). |
O_EST_ARRIVE_DT_TM |
DATETIME |
Y |
Old Estimated Arrive Date/Time |
O_EST_DEPART_DT_TM |
DATETIME |
Y |
Old Estimated Depart Date/Time |
O_ETHNIC_GRP_CD |
DOUBLE |
N |
Old Ethnic Group Code Value |
O_FIN_CLASS_CD |
DOUBLE |
N |
The financial classification. Examples may include Worker's Comp, Self Pay, etc.. |
O_FIN_NBR |
CHAR(20) |
Y |
Old Financial Number |
O_GUAR_TYPE_CD |
DOUBLE |
N |
Old Guaranotor Type Code. 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. |
O_ISOLATION_CD |
DOUBLE |
N |
Old Isolation Code. 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. |
O_LANGUAGE_CD |
DOUBLE |
N |
Old Language Code. The code_value identifying the language of the patient |
O_LANG_DIALECT_CD |
DOUBLE |
N |
Old Language Dialect Code. The dialect of the primary language spoken by the person. |
O_LOCATION_CD |
DOUBLE |
N |
Old Location Code. 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. |
O_LOC_BED_CD |
DOUBLE |
N |
Old Location Bed Code. This field is the current patient location with a location type of bed. |
O_LOC_BUILDING_CD |
DOUBLE |
N |
Old Location Building Code. This field is the current patient location with a location type of building. |
O_LOC_FACILITY_CD |
DOUBLE |
N |
Old Location Facility Code. This field is the current patient location with a location type of facility. |
O_LOC_NURSE_UNIT_CD |
DOUBLE |
N |
Old Location Nurse Unit Code. This field is the current patient location with a location type of Nurse Unit. |
O_LOC_ROOM_CD |
DOUBLE |
N |
Old Location Room Code. This field is the current patient location with a location type of room. |
O_LOC_TEMP_CD |
DOUBLE |
N |
Old Location Temporary Code. This field identifies the temporary location of the patient. The temporary location may be valued at the same time the location_cd is valued. |
O_MARITAL_TYPE_CD |
DOUBLE |
N |
Old Marital Type Code. This field identifies the status of the person with regard to being married. |
O_MED_SERVICE_CD |
DOUBLE |
N |
Old Medical Serice Code. 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. |
O_MRN |
CHAR(20) |
Y |
Old Medical Record Number |
O_MTHR_MAID_NAME |
CHAR(20) |
Y |
Old Mother's Maiden Name |
O_NAME_FIRST |
CHAR(20) |
Y |
Old First Name |
O_NAME_FORMATTED |
CHAR(30) |
Y |
Old Name Formatted |
O_NAME_LAST |
CHAR(20) |
Y |
Old Name Last |
O_NAME_MIDDLE |
CHAR(20) |
Y |
Old Name Middle |
O_NATIONALITY_CD |
DOUBLE |
N |
Old Nationality Code Value |
O_ORGANIZATION_ID |
DOUBLE |
N |
Organization ID on encounter before updates |
O_PERSON_BIRTH_SEX_CD |
DOUBLE |
N |
The old person birth sex code. The sex, typically determined by biological characteristics such as reproductive anatomy or genetic makeup, assigned at birth for the purposes of birth registration. |
O_PERSON_ID |
DOUBLE |
N |
Old Person Id. This is a key from the Person table. |
O_PERSON_SEX_CD |
DOUBLE |
N |
The old person sex code. The sex/gender that the patient is considered to have for administration and record keeping purposes. this is typically asserted by the patient when they present to administrative users. this may not match the biological sex as determined by anatomy or genetics, or the individual's preferred identification (gender identity). |
O_PERSON_TYPE_CD |
DOUBLE |
N |
Old Person Type Code. The person type field identifies the general type of data being stored in a given person row. As a general guideline, most rows in the person table will be identifiedwith a person type of PERSON. This field can be used to filter out NON-PERSON rows. |
O_PERSON_VIP_CD |
DOUBLE |
N |
Old Person VIP Code. 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). |
O_PER_BUS_ADDRESS_ID |
DOUBLE |
N |
Old Person Business Address ID. This is a primary key in the Address table. |
O_PER_BUS_ADDR_CITY |
CHAR(40) |
Y |
Old Person Business Address City |
O_PER_BUS_ADDR_COUNTRY |
CHAR(20) |
Y |
Old Person Business Address Country |
O_PER_BUS_ADDR_COUNTY |
CHAR(20) |
Y |
Old Person Business Address County |
O_PER_BUS_ADDR_STATE |
CHAR(20) |
Y |
Old Person Business Address State |
O_PER_BUS_ADDR_STREET |
CHAR(100) |
Y |
Old Person Business Address Street |
O_PER_BUS_ADDR_STREET2 |
CHAR(100) |
Y |
Old Person Business Address Street 2 |
O_PER_BUS_ADDR_ZIPCODE |
CHAR(20) |
Y |
Old Person Business Address Zipcode |
O_PER_BUS_EXT |
CHAR(10) |
Y |
Old Person Business Phone Extension |
O_PER_BUS_PHONE_ID |
DOUBLE |
N |
Old Person Business Phone ID used to identify a phone number. |
O_PER_BUS_PH_FORMAT_CD |
DOUBLE |
N |
Old Person Business Phone Format Code. |
O_PER_BUS_PH_NUMBER |
CHAR(20) |
Y |
Old Person Business Phone Number. |
O_PER_HOME_ADDRESS_ID |
DOUBLE |
N |
Old Person Home Address ID |
O_PER_HOME_ADDR_CITY |
CHAR(40) |
Y |
Old Person Home Address City |
O_PER_HOME_ADDR_COUNTRY |
CHAR(20) |
Y |
Old Person Home Address Country |
O_PER_HOME_ADDR_COUNTY |
CHAR(20) |
Y |
Old Person Home Address County |
O_PER_HOME_ADDR_STATE |
CHAR(20) |
Y |
Old Person Home Address State |
O_PER_HOME_ADDR_STREET |
CHAR(100) |
Y |
Old Person Home Address Street |
O_PER_HOME_ADDR_STREET2 |
CHAR(100) |
Y |
Old Person Home Address Street 2 |
O_PER_HOME_ADDR_ZIPCODE |
CHAR(20) |
Y |
Old Person Home Address Zipcode |
O_PER_HOME_EXT |
CHAR(10) |
Y |
Old Person Home Extension |
O_PER_HOME_PHONE_ID |
DOUBLE |
N |
Old Person Home Phone Id |
O_PER_HOME_PH_FORMAT_CD |
DOUBLE |
N |
Old Person Home Phone Format Code. |
O_PER_HOME_PH_NUMBER |
CHAR(20) |
Y |
Old Person Home Phone Number |
O_PREADMIT_NBR |
CHAR(20) |
Y |
Old Preadmit Number. |
O_PREADMIT_TEST_CD |
DOUBLE |
N |
Old Preadmit Test Code. |
O_PRE_REG_DT_TM |
DATETIME |
Y |
Old Pre-Registration Date/Time. 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. |
O_PRE_REG_PRSNL_ID |
DOUBLE |
N |
Old Pre-Registration PersonnelID. 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. |
O_PROGRAM_SERVICE_CD |
DOUBLE |
N |
Code value identifying the old program service associated with the patient registration |
O_RACE_CD |
DOUBLE |
N |
Old Race Code. The code_value identifying the race of the patient. |
O_READMIT_CD |
DOUBLE |
N |
Old Readmit Code. Value contains a description of the encounter readmit. |
O_REASON_FOR_VISIT |
CHAR(40) |
Y |
Old Reason For Visit. 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. |
O_REFER_COMMENT |
CHAR(40) |
Y |
A text field containing the comments from the referring physician or service. |
O_REFER_DOC_ID |
DOUBLE |
N |
ID of the old referring doctor. This is a key value from the personnel (prsnl) table. |
O_REFER_DOC_NAME |
CHAR(30) |
Y |
Name of the old referring doctor. |
O_REFER_DOC_NBR |
CHAR(16) |
Y |
Number of the old referring doctor. |
O_REG_DT_TM |
DATETIME |
Y |
Old Registration Date/Time. The date/time that the registration or admission process was performed. 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. |
O_REG_PRSNL_ID |
DOUBLE |
N |
Old Registration PersonnelID. 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. |
O_RELIGION_CD |
DOUBLE |
N |
Old Religion Code. The code_value identifying the religion of the patient. |
O_RESULT_DEST_CD |
DOUBLE |
N |
*** No longer in Use *** |
O_SEX_AGE_CHG_IND |
DOUBLE |
Y |
Old Sex Age Change Indicator. This field indicates that the sex of the person has changed as the result of a correction of the data or actual physical change to the person. |
O_SPECIES_CD |
DOUBLE |
N |
Old Species Code. A fundamental category of taxonomic classification, ranking after a genus and consisting of organisms capable of interbreeding. |
O_SSN |
CHAR(15) |
Y |
Old Social Security Number. |
O_VET_MIL_STAT_CD |
DOUBLE |
N |
Old Veteran Military Status Code Value |
PM_HIST_TRACKING_ID |
DOUBLE |
N |
Contains the foreign key to the history tracking table identifying the associated history row. |
REPORT_ID |
DOUBLE |
N |
Foreign Key to the PM_RPT_REPORT table identifying the report that was ran |
REPORT_NAME |
CHAR(20) |
Y |
Free-text Name of the report that was ran |
TASK_NUMBER |
DOUBLE |
Y |
The task_number of the application that created the transaction row. |
TRANSACTION |
CHAR(4) |
N |
Type of transaction that occurred. Example: UPDT, ATDS, etc. |
TRANSACTION_ID |
DOUBLE |
N |
Unique identifier of the transaction. |
TRANSACTION_REASON |
VARCHAR(100) |
Y |
Text that describes the reason for the transaction. |
TRANSACTION_REASON_CD |
DOUBLE |
N |
Identifies the reason for the transaction. |
UPDT_APPLCTX |
DOUBLE |
N |
The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_CNT |
DOUBLE |
N |
Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_DT_TM |
DATETIME |
N |
The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_ID |
DOUBLE |
N |
The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_TASK |
DOUBLE |
N |
The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |