UKRWH_CDE_AE_ATTENDANCE



Column Section Relationship Section Top of Page


Table-level Detail

Description: UK Reporting Warehouse Cons Data Extract Accident and Emergency Attendance
Definition: Contains additional attendance level details relating to an A&E CDS Event.
Table Type: ACTIVITY





Column Detail - UKRWH_CDE_AE_ATTENDANCE


Column Name Type Null? Definition
ACCIDENT_DT_TM DATETIME Y The date and time the accident occurred.
ACCIDENT_REF VARCHAR(40) Y Identifies the general type of accident (I.e., auto, work related, etc.)
ADMIT_SOURCE_REF VARCHAR(40) Y Admit source identifies the place from which the patient came before being admitted. (i.e., transfer from another hospital)
AE_OBS_PATIENT_IND DOUBLE Y An indication as to whether the patient is under observation in A&E
AMBULANCE_NBR_TXT VARCHAR(20) Y The service number related to the ambulance visit
ARRIVAL_DT_TM DATETIME Y The estimated or expected date/time that the patient will arrive at the facility. This field may be null.
ARRIVAL_MODE_REF VARCHAR(40) Y Information regarding the arrival of the ambulance
ATTENDANCE_CATEGORY_REF VARCHAR(40) Y Description of the encounter readmit.
ATTENDANCE_DISPOSAL_REF VARCHAR(40) Y The location to which the patient was discharged such as another hospital or nursing home.
ATTEND_DOC_PRSNL VARCHAR(40) Y The internal person ID of the physician attending the patient in A&E
CDS_BATCH_CONTENT_SK VARCHAR(40) N Unique identifier for each cds item. This is the unique CDS ID reported to the NHS.
CHECKIN_DT_TM DATETIME Y Date and time the tracking item was checked into the tracking group.
CHECKOUT_DT_TM DATETIME Y Date and time the tracking item was checked out of the tracking group.
CONCLUSION_DT_TM DATETIME Y The data time of the A&E attendance conclusion.
DECISION_TO_ADMIT_DT_TM DATETIME Y Date and Time that the Decision To Admit Tracking Event was requested.
DEPARTURE_DT_TM DATETIME Y A+E DEPARTURE TIME is the time that a PATIENT leaves the Accident And Emergency Department after an Accident And Emergency Attendance has concluded and the department is no longer responsible for the care of the PATIENT.
DEPART_DT_TM DATETIME Y A+E DEPARTURE TIME is the time that a PATIENT leaves the Accident And Emergency Department after an Accident And Emergency Attendance has concluded and the department is no longer responsible for the care of the PATIENT.
DISCHARGE_DISPOSITION_REF VARCHAR(40) Y The conditions under which the patient left the facility at the time of discharge.
DISCHARGE_PRSNL VARCHAR(40) Y The internal person ID of the personnel that discharges the patient
DISCH_DT_TM DATETIME Y The actual date/time that the patient was discharged from the facility. For most outpatients, this column may be null unless the user process requires capturing this data, for example, day surgery. Auto discharge will populate this column. This also may or may not be a system assigned date and time depending on the discharge process used.
ENCNTR_ACTIVE_IND DOUBLE Y The Millennium encounter 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.
ENCNTR_CREATE_DT_TM DATETIME Y This is the date and time that a row is created in the encounter table.
ENCNTR_CREATE_PRSNL VARCHAR(40) Y This is the person responsible for creating a row in the encounter table.
ENCNTR_LAST_UPDT_DT_TM DATETIME Y Date Time on which the assoicited Millennium Encounter was last Updated
ENCNTR_UPDT_PRSNL VARCHAR(40) Y The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the encounter table.
ENCOUNTER_SK VARCHAR(40) Y This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
EXTRACT_DT_TM DATETIME Y The date and time the row was extracted
FIRST_ASSESSMENT_DT_TM DATETIME Y Date and time the Assessment Tracking Event was completed.
FIRST_PROCESS_DT_TM DATETIME N The date/time that the first ETL process started that created this record.
HEALTH_SYSTEM_ID DOUBLE N Unique number assigned by Health Facts. Typically the universal Cerner assigned client id of the health system.
HEALTH_SYSTEM_SOURCE_ID DOUBLE N Unique number assigned by Health Facts. Typically the universal Cerner assigned client id of the sending health system but may be adjusted if there is >1 HF feed from the client.
INCIDENT_LOCATION_REF VARCHAR(40) Y Place of the accident (ex. Client s or Patient s Home Health Center Hospice Group Home etc.)
LAST_PROCESS_DT_TM DATETIME N The date/time that the last ETL process started that updated this record.
LOC_ARRIVAL_DT_TM DATETIME Y The date and time related to the ambulance visit.
LOC_BED_REF VARCHAR(40) Y This field is the current patient location with a location type of bed.
LOC_BUILDING_REF VARCHAR(40) Y This field is the current patient location with a location type of building.
LOC_CONCLUSION_DT_TM DATETIME Y The data time of the a&e attendance conclusion.
LOC_DECISION_TO_ADMIT_DT_TM DATETIME Y The date and time that the decision to admit tracking event was requested.
LOC_DEPARTURE_DT_TM DATETIME Y The a+e departure time is the time that a patient leaves the accident and emergency department after an accident and emergency attendance has concluded and the department is no longer responsible for the care of the patient.
LOC_FACILITY_REF VARCHAR(40) Y This field is the current patient location with a location type of facility.
LOC_NURSE_UNIT_REF VARCHAR(40) Y This field is the current patient location with a location type of building.
LOC_ROOM_REF VARCHAR(40) Y This field is the current patient location with a location type of room.
MIGRATED_IND DOUBLE Y Derived formt her encountercontributor_system_cd. 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.
ORGANIZATION_SK VARCHAR(40) Y It is the uniqueIdentifier of an entity whose activities encompass the funding or provision of health care and support services.
PERSON_SK VARCHAR(40) N This is the value of the unique primary identifier of the Millennium person table. It is an internal system assigned number.
REASON_FOR_VISIT_TXT 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.
REGISTERING_PRSNL VARCHAR(40) Y 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.
REG_DT_TM DATETIME Y 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.
SOURCE_OF_REFERRAL_REF VARCHAR(40) Y Admit mode identifies the method by which the patient arrived. (i.e. helicopter ambulance etc.)
STREAM_REF VARCHAR(40) Y It is the code for the Stream to which the patients are allocated according to their needs.
TETANUS_RESULT_VAL_TXT VARCHAR(255) Y This field contains the results for the Tetanus
TOTAL_UPDATES DOUBLE N The numbers of updates that have occurred on this table.
TRACKING_GROUP_REF VARCHAR(40) Y Tracking Group Code used to identify which tracking group this patient is currently checked into.
TREATMENT_START_DT_TM DATETIME Y Date and time the Treatment Start Tracking Event was completed.
UKRWH_CDE_AE_ATTENDANCE_KEY DOUBLE N This is the value of the unique primary identifier of the ukrwh cde ae attendance table. It is an internal system assigned number.
UKRWH_CDE_PERSON_PATIENT_KEY DOUBLE N This is the value of the unique primary identifier of the ukrwh cde person patient table. It is an internal system assigned number.
UKRWH_CDS_AE_ATTENDANCE DOUBLE N tbd, think this attribute must be a mistake
UKRWH_CDS_AE_ATTENDANCE_KEY DOUBLE N This is the value of the unique primary identifier of the ukrwh cde ae attendance table. It is an internal system assigned number.
UPDATE_USER VARCHAR(40) 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_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_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 - UKRWH_CDE_AE_ATTENDANCE


Child Column in UKRWH_CDE_AE_ATTENDANCE(FK) Parent Table Name Parent Column Name
Parents: UKRWH_CDE_PERSON_PATIENT_KEY UKRWH_CDE_PERSON_PATIENT UKRWH_CDE_PERSON_PATIENT_KEY
UKRWH_CDS_AE_ATTENDANCE_KEY UKRWH_CDS_AE_ATTENDANCE UKRWH_CDS_AE_ATTENDANCE_KEY


UKRWH_CDE_APC_EPISODE



Column Section Relationship Section Top of Page


Table-level Detail

Description: UK Reporting Warehouse Consolidated Data ExtractAdmitted Patient Care Episode
Definition: Contains additional Epsiode level details relating to an Admitted Patient Care CDS Event.
Table Type: ACTIVITY





Column Detail - UKRWH_CDE_APC_EPISODE


Column Name Type Null? Definition
ATTEND_DOC_PRSNL VARCHAR(40) Y The internal person ID of the physician attending the patient in APC
CDS_BATCH_CONTENT_SK VARCHAR(40) N Unique identifier for each cds item. This is the unique CDS ID reported to the NHS.
ENCNTR_SLICE_ACTIVE_IND DOUBLE Y The Millennium encounter slice (encntr_slice) 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.
ENCNTR_SLICE_LAST_UPDT_DT_TM DATETIME Y The date and time the last encntr slice row was last inserted or updated.
ENCNTR_SLICE_SK VARCHAR(40) Y This is the value of the unique primary identifier of the Millennium encounter slice (encntr_slice) table. It is an internal system assigned number.
ENCNTR_SLICE_UPDT_PRSNL VARCHAR(40) Y This is the value of the unique primary identifier for the last updated encounter slice
ENCOUNTER_SK VARCHAR(40) Y This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
EPISODE_END_DT_TM DATETIME Y The date that an Episode ends. END DATE (EPISODE) is the same as attribute ACTIVITY DATE of ACTIVITY DATE TIME where ACTIVITY DATE TIME TYPE is National Code 11 'End Date'. Consultant Episode (Hospital Provider) is an ACTIVITY GROUP where ACTIVITY GROUP TYPE is National Code 14 'Consultant Episode (Hospital Provider)'.
EPISODE_START_DT_TM DATETIME Y START DATE (EPISODE) is the same as the attribute ACTIVITY DATE where the ACTIVITY DATE TIME TYPE is National Code 31 'Start Date' of the episode. Record the start and end dates of the episode to derive the period that the PATIENT was under the care of a particular consultant, midwife or nurse during the Hospital Provider Spell.
EXTRACT_DT_TM DATETIME Y The date and time the row was extracted
FIRST_PROCESS_DT_TM DATETIME N Date and time of the first process
HEALTH_SYSTEM_ID DOUBLE N Unique number assigned by Health Facts. Typically the universal Cerner assigned client id of the health system.
HEALTH_SYSTEM_SOURCE_ID DOUBLE N Unique number assigned by Health Facts. Typically the universal Cerner assigned client id of the sending health system but may be adjusted if there is >1 HF feed from the client.
LAST_PROCESS_DT_TM DATETIME N Date and time of the second process
MAIN_SPECIALTY_REF VARCHAR(40) Y It is the specialty in which the CONSULTANT is contracted or recognised. MAIN SPECIALTY classifies clinical work divisions more precisely for a limited number of specialties
OVERSEAS_STATUS_REF VARCHAR(40) Y The status of an overseas visitor for a particular ACTIVITY, where an overseas visitor is a PERSON not ordinarily resident in the UK, with respect to charging rates.
TOTAL_UPDATES DOUBLE N The numbers of updates that have occurred on this table.
TREATMENT_FUNCTION_REF VARCHAR(40) Y This is the TREATMENT FUNCTION under which the PATIENT is treated.
UKRWH_CDE_APC_EPISODE_KEY DOUBLE N This is the value of the unique primary identifier of the ukrwh cde apc episode table. It is an internal system assigned number.
UKRWH_CDE_IP_ADMISSION_KEY DOUBLE N This is the value of the unique primary identifier of the ukrwh cde ip admission table. It is an internal system assigned number.
UKRWH_CDS_APC_EPISODE_KEY DOUBLE N This is the value of the unique primary identifier of the ukrwh cds episode table. It is an internal system assigned number.
UPDATE_USER VARCHAR(40) 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_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_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - UKRWH_CDE_APC_EPISODE


Child Column in UKRWH_CDE_APC_EPISODE(FK) Parent Table Name Parent Column Name
Parents: UKRWH_CDE_IP_ADMISSION_KEY UKRWH_CDE_IP_ADMISSION UKRWH_CDE_IP_ADMISSION_KEY
UKRWH_CDS_APC_EPISODE_KEY UKRWH_CDS_APC_EPISODE UKRWH_CDS_APC_EPISODE_KEY


UKRWH_CDE_CODE_VALUE



Column Section Top of Page


Table-level Detail

Description: UK Reporting Warehouse Consolidated Data Extract Code Value
Definition: Contains Code Values along with corresponding NHS Reporting outbound aliases.
Table Type: REFERENCE





Column Detail - UKRWH_CDE_CODE_VALUE


Column Name Type Null? Definition
CODE_SET VARCHAR(40) Y The code set for the code value
CODE_VALUE VARCHAR(40) Y Stores the actual code values for a given numeric code_set
CODE_VALUE_ACTIVE_IND DOUBLE Y The Millennium code value 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.
CODE_VALUE_SET_DISPLAY VARCHAR(40) Y Display of the code set
DEFINITION VARCHAR(100) Y The display string for the code_value
DESCRIPTION VARCHAR(60) Y The description for the code value
DISPLAY VARCHAR(40) Y The display string for the code_value
DISPLAY_UNF VARCHAR(40) Y Same as display only converted to upper case
EXTRACT_DT_TM DATETIME Y The date and time the row was extracted
FIRST_PROCESS_DT_TM DATETIME N The date/time that the first ETL process started that created this record.
HEALTH_SYSTEM_ID DOUBLE N Unique number assigned by Health Facts. Typically the universal Cerner assigned client id of the health system.
HEALTH_SYSTEM_SOURCE_ID DOUBLE N Unique number assigned by Health Facts. Typically the universal Cerner assigned client id of the sending health system but may be adjusted if there is >1 HF feed from the client.
LAST_PROCESS_DT_TM DATETIME N The date/time that the last ETL process started that updated this record.
NHSREPORT_CV_OUTBOUND_ALIAS VARCHAR(100) Y This field contains the code value for the NHS Report Outbound alias
TOTAL_UPDATES DOUBLE N The numbers of updates that have occurred on this table.
UKRWH_CDE_CODE_VALUE_KEY DOUBLE N This is the value of the unique primary identifier of the ukrwh cde code value table. It is an internal system assigned number.
UPDATE_USER VARCHAR(40) 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_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_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.


UKRWH_CDE_EAL_ENTRY



Column Section Relationship Section Top of Page


Table-level Detail

Description: UK Reporting Warehouse Consolidated Data Extract Elective Admission List Entry
Definition: Contains additional Elective Admnission List Entry (EAL) level details relating to an EAL CDS Event.
Table Type: ACTIVITY





Column Detail - UKRWH_CDE_EAL_ENTRY


Column Name Type Null? Definition
ADMIT_BOOKING_REF VARCHAR(40) Y Admission booking system type.
ADMIT_CATEGORY_REF VARCHAR(40) Y Admission or administrative category
ADMIT_DECISION_DT_TM DATETIME Y Date and time the decision to admit was made
ADMIT_GUARANTEED_DT_TM DATETIME Y Guaranteed admission date and time
ADMIT_TYPE_REF VARCHAR(40) Y Type of waiting list admission. (ex. Day case, inpatient)
ATTEND_DOC_PRSNL VARCHAR(40) Y The internal person ID of the physician attending the patient in elective admissions (wait list)
BOTH_DATES_REFUSED_REF VARCHAR(40) Y This field indicates whether the patient has refused both the wait list offers
CDS_BATCH_CONTENT_SK VARCHAR(40) N Unique identifier for each cds item. This is the unique CDS ID reported to the NHS.
EAL_ENTRY_SK VARCHAR(40) Y A number to provide a unique identifier for each ELECTIVE ADMISSION LIST ENTRY within an ELECTIVE ADMISSION LIST.
ENCNTR_ACTIVE_IND DOUBLE Y The Millennium encounter 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.
ENCNTR_CREATE_DT_TM DATETIME Y This is the date and time that a row is created in the encounter table.
ENCNTR_CREATE_PRSNL VARCHAR(40) Y This is the person responsible for creating a row in the encounter table.
ENCNTR_UPDT_DT_TM DATETIME Y The date and time the row on the encounter table was last inserted or updated.
ENCNTR_UPDT_PRSNL VARCHAR(40) Y The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the encounter table.
ENCOUNTER_SK VARCHAR(40) Y This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
EXTRACT_DT_TM DATETIME Y The date and time the row was extracted
FIN_IDENT VARCHAR(200) Y The alias is an identifier (I.e., financial number) for an encounter. The alias may be unique or non-unique depending on the type of alias.
FIRST_OFFERED_DT_TM DATETIME Y It is the date/time for which the patient was offered the first elective admission (wait list)
FIRST_PROCESS_DT_TM DATETIME N Date and time of the first process
HEALTH_SYSTEM_ID DOUBLE N Unique number assigned by Health Facts. Typically the universal Cerner assigned client id of the health system.
HEALTH_SYSTEM_SOURCE_ID DOUBLE N Unique number assigned by Health Facts. Typically the universal Cerner assigned client id of the sending health system but may be adjusted if there is >1 HF feed from the client.
INTENDED_MANAGEMENT_REF VARCHAR(40) Y Intended management.
LAST_DNA_DT_TM DATETIME Y Last date and time a DNA was recorded for a waiting list entry
LAST_PROCESS_DT_TM DATETIME N Date and time of the second process
LAST_STATUS_REVIEW_DT_TM DATETIME Y The date/time that a wait list status was reviewed.
MAIN_SPECIALTY_REF VARCHAR(40) Y It is the specialty in which the CONSULTANT is contracted or recognised. MAIN SPECIALTY classifies clinical work divisions more precisely for a limited number of specialties
MIGRATED_IND DOUBLE Y Derived formt her encountercontributor_system_cd. 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.
OFFERS_MADE_DT_TM DATETIME Y It is the date/time at which the elective admission (wait list) offer/s were made.
ORIGINAL_ADMIT_DECISION_DT_TM DATETIME Y The date/time at which the original decision was made to admit the patient
OVERSEAS_STATUS_REF VARCHAR(40) Y The status of an overseas visitor for a particular ACTIVITY, where an overseas visitor is a PERSON not ordinarily resident in the UK, with respect to charging rates.
PERSON_SK VARCHAR(40) Y This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
PRE_ADMIT_WARD_REF VARCHAR(40) Y This field is the code value for the current patient location with a location type of Nurse Unit.
REASON_FOR_CHANGE_REF VARCHAR(40) Y Code value for a text description of the reason a change was made.
REASON_FOR_REMOVAL_REF VARCHAR(40) Y Code value for a text description of the reason a removal was made.
REFERRER_DOC_PRSNL VARCHAR(40) Y The internal person ID of the physician referring the patient in elective admissions (wait list)
SECOND_OFFERED_DT_TM DATETIME Y It is the date/time for which the patient was offered the second elective admission (wait list)
STAND_BY_REF VARCHAR(40) Y Code Value that contains a text description of a wait list stand by.
TOTAL_UPDATES DOUBLE N The numbers of updates that have occurred on this table.
TREATMENT_FUNCTION_REF VARCHAR(40) Y This is the TREATMENT FUNCTION under which the PATIENT is treated.
UKRWH_CDE_EAL_ENTRY_KEY DOUBLE N This is the value of the unique primary identifier of the ukrwh cde eal entry table. It is an internal system assigned number.
UKRWH_CDE_PERSON_PATIENT_KEY DOUBLE N This is the value of the unique primary identifier of the ukrwh cde person patient table. It is an internal system assigned number.
UKRWH_CDS_EAL_ENTRY_KEY DOUBLE N This is the value of the unique primary identifier of the ukrwh cde eal entry table. It is an internal system assigned number.
UPDATE_USER VARCHAR(40) 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_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_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row
URGENCY_REF VARCHAR(40) Y Code Value for the urgency of patient event on wait list. Example: within 7 days.
WAITING_END_DT_TM DATETIME Y Waiting End Date Time.
WAITLIST_STATUS_REF VARCHAR(40) Y Code value that refers to the status of a wait list row. Examples: Normal Deferred.



Relationship Detail - UKRWH_CDE_EAL_ENTRY


Child Column in UKRWH_CDE_EAL_ENTRY(FK) Parent Table Name Parent Column Name
Parents: UKRWH_CDE_PERSON_PATIENT_KEY UKRWH_CDE_PERSON_PATIENT UKRWH_CDE_PERSON_PATIENT_KEY
UKRWH_CDS_EAL_ENTRY_KEY UKRWH_CDS_EAL_ENTRY UKRWH_CDS_EAL_ENTRY_KEY


UKRWH_CDE_IP_ADMISSION



Column Section Relationship Section Top of Page


Table-level Detail

Description: UK Reporting Warehouse Consolidated Data Extract Inpatient Admission
Definition: Contains additional Spell level details relating to an Admitted Patient Care CDS Event.
Table Type: ACTIVITY





Column Detail - UKRWH_CDE_IP_ADMISSION


Column Name Type Null? Definition
ADMISSION_DT_TM DATETIME Y 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.
ADMISSION_METHOD_REF VARCHAR(40) Y The method of admission to a Hospital Provider Spell.
DISCHARGE_DT_TM DATETIME Y Date of discharge from a Hospital Provider Spell.
DISCHARGE_PRSNL VARCHAR(40) Y The internal person ID of the personnel that discharges the patient
ENCNTR_ACTIVE_IND DOUBLE Y The Millennium encounter 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.
ENCNTR_CREATE_DT_TM DATETIME Y This is the date and time that a row is created in the encounter table.
ENCNTR_CREATE_PRSNL VARCHAR(40) Y This is the person responsible for creating a row in the encounter table.
ENCNTR_UPDT_DT_TM DATETIME Y The date and time the row on the encounter table was last inserted or updated.
ENCNTR_UPDT_PRSNL VARCHAR(40) Y The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the encounter table.
ENCOUNTER_SK VARCHAR(40) N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
ENCTR_COMMENTS_TXT VARCHAR(4000) Y Used to store the text for the long text identifier
EST_DISCH_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.
EXTRACT_DT_TM DATETIME Y The date and time the row was extracted
FIRST_PROCESS_DT_TM DATETIME N Date and time of the first process
FIT_FOR_DISCH_DT_TM DATETIME Y The date and time value of the encounter information. If the value of the row necessitates storing a date/time, it is placed in this column.
HEALTH_SYSTEM_ID DOUBLE N Unique number assigned by Health Facts. Typically the universal Cerner assigned client id of the health system.
HEALTH_SYSTEM_SOURCE_ID DOUBLE N Unique number assigned by Health Facts. Typically the universal Cerner assigned client id of the sending health system but may be adjusted if there is >1 HF feed from the client.
HOSPITAL_PRVDR_SPELL_IDENT VARCHAR(40) Y A number to provide a unique identifier for each Hospital Provider Spell for a Health Care Provider.
LAST_PROCESS_DT_TM DATETIME N Date and time of the second process
LOC_ADMISSION_DT_TM DATETIME Y The admission date time.
LOC_DISCHARGE_DT_TM DATETIME Y The date offered for admission to hospital to start a hospital provider spell.
LOC_FACILITY_REF VARCHAR(40) Y This field is the current patient location with a location type of facility.
PENDING_DISCH_DISPOSITION_REF VARCHAR(40) Y The conditions under which the patient left the facility at the time of discharge
PENDING_DISCH_LOC_REF VARCHAR(40) Y The location to which the patient was discharged such as another hospital or nursing home.
PENDING_EST_DISCHARGE_DT_TM DATETIME Y The estimated or expected date/time that the pending action will be completed. This field may be null.
PERSON_SK VARCHAR(40) N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
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 VARCHAR(40) Y 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.
REG_PRSNL VARCHAR(40) Y 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.
SOURCE_OF_ADMISSION_REF VARCHAR(40) Y The coded source of admission to a Hospital Provider Spell or a Nursing Episode when the PATIENT is in a Hospital Site or a Care Home.
TOTAL_UPDATES DOUBLE N The numbers of updates that have occurred on this table.
UKRWH_CDE_APC_EPISODE_KEY DOUBLE N This is the value of the unique primary identifier of the ukrwh cde episode table. It is an internal system assigned number.
UKRWH_CDE_IP_ADMISSION_KEY DOUBLE N This is the value of the unique primary identifier of the ukrwh cde ip admission table. It is an internal system assigned number.
UKRWH_CDE_PERSON_PATIENT_KEY DOUBLE N This is the value of the unique primary identifier of the ukrwh cde person patient table. It is an internal system assigned number.
UK_RESIDENT_IND DOUBLE Y The status of Patient with regards to whetherthey have been resident in the UK for the past 12 months.
UPDATE_USER VARCHAR(40) 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_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_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - UKRWH_CDE_IP_ADMISSION


Child Column in UKRWH_CDE_IP_ADMISSION(FK) Parent Table Name Parent Column Name
Parents: UKRWH_CDE_PERSON_PATIENT_KEY UKRWH_CDE_PERSON_PATIENT UKRWH_CDE_PERSON_PATIENT_KEY




Parent Column in UKRWH_CDE_IP_ADMISSION (PK) Child Table Name Child Column Name
Children: UKRWH_CDE_IP_ADMISSION_KEY UKRWH_CDE_APC_EPISODE UKRWH_CDE_IP_ADMISSION_KEY