Table Detail Report

PM_TEMPLATE_DETAIL



Column Section Top of Page


Table-level Detail

Description: Person Management Template Detail.
Definition: Details for a given Template.
Table Type: REFERENCE





Column Detail - PM_TEMPLATE_DETAIL


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME Y The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
DAY_CD DOUBLE N This field contains the code value for day of the week. Monday, Tuesday, etc.
DAY_END_DT_TM DATETIME Y The time the given template row is ended.
DAY_START_DT_TM DATETIME Y The time the given template row has started.
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.
TEMPLATE_DETAIL_ID DOUBLE N This field contains the unique value representing the template detail.
TEMPLATE_ID DOUBLE N Id of the parent template.
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.


PM_TRANSACTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Person Management Transaction Table
Definition: Audit table for every Person Management transaction. ADMT, TRAN, DSCH...
Table Type: ACTIVITY





Column Detail - PM_TRANSACTION


Column Name Type Null? Definition
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.



Relationship Detail - PM_TRANSACTION


Child Column in PM_TRANSACTION(FK) Parent Table Name Parent Column Name
Parents: O_PER_BUS_ADDRESS_ID ADDRESS ADDRESS_ID
O_PER_HOME_ADDRESS_ID ADDRESS ADDRESS_ID
O_ENCNTR_FIN_ID ENCNTR_FINANCIAL ENCNTR_FINANCIAL_ID
N_LOCATION_CD LOCATION LOCATION_CD
N_LOC_BED_CD LOCATION LOCATION_CD
N_LOC_BUILDING_CD LOCATION LOCATION_CD
N_LOC_FACILITY_CD LOCATION LOCATION_CD
N_LOC_NURSE_UNIT_CD LOCATION LOCATION_CD
N_LOC_ROOM_CD LOCATION LOCATION_CD
O_LOCATION_CD LOCATION LOCATION_CD
O_LOC_BED_CD LOCATION LOCATION_CD
O_LOC_BUILDING_CD LOCATION LOCATION_CD
O_LOC_FACILITY_CD LOCATION LOCATION_CD
O_LOC_NURSE_UNIT_CD LOCATION LOCATION_CD
O_LOC_ROOM_CD LOCATION LOCATION_CD
N_CHART_ACCESS_ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
N_ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
O_CHART_ACCESS_ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
O_ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
O_PER_BUS_PHONE_ID PHONE PHONE_ID
O_PER_HOME_PHONE_ID PHONE PHONE_ID
PM_HIST_TRACKING_ID PM_HIST_TRACKING PM_HIST_TRACKING_ID
REPORT_ID PM_RPT_REPORT REPORT_ID


PM_TRANSACTION2



Column Section Top of Page


Table-level Detail

Description: Person Management Transaction 2
Definition: Extension table to the pm_transaction table
Table Type: ACTIVITY





Column Detail - PM_TRANSACTION2


Column Name Type Null? Definition
ABS_N_BIRTH_DT_TM DATETIME Y Absolute date stored for birth date that is always saved using GMT instead of the system time zone or the _tz column.
ABS_O_BIRTH_DT_TM DATETIME Y Absolute date stored for birth date that is always saved using GMT instead of the system time zone or the _tz column.
N_BIRTH_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
N_SERVICE_CATEGORY_CD DOUBLE N New service category code was captured in.
N_SPECIALTY_UNIT_CD DOUBLE N Represents the current specialty unit associated with the program service of the patient
O_BIRTH_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
O_SERVICE_CATEGORY_CD DOUBLE N Old service category code was captured in.
O_SPECIALTY_UNIT_CD DOUBLE N Represents the old specialty unit associated with the program service of the patient registration
TRANSACTION_DT_TM DATETIME Y The date and time of the transaction.
TRANSACTION_ID DOUBLE N Unique identifier for the transaction


PM_USER_DEFINED



Column Section Top of Page


Table-level Detail

Description: This table will hold the information from the user defined prompts
Definition: PM User Defined
Table Type: ACTIVITY





Column Detail - PM_USER_DEFINED


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.
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.
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.
PARENT_ENTITY_ID DOUBLE N The value of the primary identifier of the table to which the user defined row is related (i.e., person_id, encntr_id)
PARENT_ENTITY_NAME VARCHAR(32) N The upper case name of the table to which this User Defined row is related (i.e.,PERSON, ENCOUNTER)
PM_USER_DEFINED_ID DOUBLE N The pm user defined ID is the primary key of the pm_user_defined table.
UDF_TYPE_CD DOUBLE N The user defined type code is the code set value which identifies the user defined information for the pm_user_defined row.
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 This field holds Coded value information for user defined prompts This field can hold any Code Set and should be in the group of numbers set aside for User_defined data
VALUE_DT_TM DATETIME Y This field holds Date value information for user defined prompts
VALUE_IND DOUBLE N This field holds Indicator value information for user defined prompts
VALUE_LONG_TEXT_REF_ID DOUBLE N Foreign key from LONG_TEXT table. This field holds the Text value information for user defined prompts.
VALUE_NBR DOUBLE N This field holds Number value information for user defined prompts
VALUE_TYPE DOUBLE N This field holds the indicator as to what type of User Defined Information is in the row. (1 -Text , 2 - coded, 3 - data/time, 4 - Indicator, 5 - numeric)


PM_USER_DEFINED_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: PM USER DEFINED HIST
Definition: Tracks modifications to history elements for a given user defined field.
Table Type: ACTIVITY





Column Detail - PM_USER_DEFINED_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.
CHANGE_BIT DOUBLE N Identifies which columns have had a change.
PARENT_ENTITY_ID DOUBLE N The value of the primary identifier of the table to which the user defined row is related (i.e., person_id, encntr_id)
PARENT_ENTITY_NAME VARCHAR(30) Y The upper case name of the table to which this User Defined row is related (i.e.,PERSON, 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.
PM_USER_DEFINED_HIST_ID DOUBLE N This is the value of the unique primary identifier of the pm_user_defined_hist table. It is an internal system assigned number.
TRACKING_BIT DOUBLE N Identifies which columns are being tracked for history.
TRANSACTION_DT_TM DATETIME Y Date and time the transaction, which triggered the history row, occurred. This field can be system assigned or manually manipulated by users.
UDF_TYPE_CD DOUBLE N The user defined type code is the code set value which identifies the user defined information for the pm_user_defined row.
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 Stores historical values of type double from the parent table
VALUE_DT_TM DATETIME Y This field holds Date value information for user defined prompts
VALUE_LONG_TEXT_ID DOUBLE N This is the value of the unique primary identifier of the long_text table. It is an internal system assigned number.
VALUE_NBR DOUBLE N This field holds Number value information for user defined prompts
VALUE_NBR_IND DOUBLE N Indicates whether or not the input from the front end tool for column VALUE_NBRis 0 or NULL.
VALUE_TYPE DOUBLE N This field holds the indicator as to what type of User Defined Information is in the row. (1 -Text , 2 - coded, 3 - data/time, 4 - Indicator, 5 - numeric)



Relationship Detail - PM_USER_DEFINED_HIST


Child Column in PM_USER_DEFINED_HIST(FK) Parent Table Name Parent Column Name
Parents: VALUE_LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
PM_HIST_TRACKING_ID PM_HIST_TRACKING PM_HIST_TRACKING_ID