Table Detail Report

UKRWH_CDE_WARDSTAY



Column Section Relationship Section Top of Page


Table-level Detail

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





Column Detail - UKRWH_CDE_WARDSTAY


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.
CDS_BATCH_CONTENT_SK VARCHAR(40) Y Unique identifier for each cds item. This is the unique CDS ID reported to the NHS.
ENCNTR_SLICE_SK VARCHAR(40) Y Identifies an Encounter as it relates to a time 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.
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
LOC_NURSE_UNIT_REF VARCHAR(40) Y This field is the patient location with a location type of nurse unit at the time the history row is written.
TOTAL_UPDATES DOUBLE N The numbers of updates that have occurred on this table.
UKRWH_CDE_WARDSTAY_KEY DOUBLE N This is the value of the unique primary identifier of the ukrwh cde wardstay table. It is an internal system assigned number.
UKRWH_CDS_APC_WARDSTAY_KEY DOUBLE N This is the value of the unique primary identifier of the ukrwh cds apc wardstay 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.
WARD_STAY_END_DT_TM DATETIME Y The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
WARD_STAY_SEQ DOUBLE Y This is the value of the sequence of the ward stay within the CDS.
WARD_STAY_START_DT_TM DATETIME Y The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.



Relationship Detail - UKRWH_CDE_WARDSTAY


Child Column in UKRWH_CDE_WARDSTAY(FK) Parent Table Name Parent Column Name
Parents: UKRWH_CDS_APC_WARDSTAY_KEY UKRWH_CDS_APC_WARDSTAY UKRWH_CDS_APC_WARDSTAY_KEY


UKRWH_CDS_AE_ATTENDANCE



Column Section Relationship Section Top of Page


Table-level Detail

Description: UK Reporting Warehouse Commissioning Data Set Accident & Emergency Attendance
Definition: Contains CDS A&E attendance fields specific to the A&E CDS.
Table Type: ACTIVITY





Column Detail - UKRWH_CDS_AE_ATTENDANCE


Column Name Type Null? Definition
AE_STAFF_MEMBER_IDENT VARCHAR(3) Y A locally determined code used to identify the person principally responsible for the care of a PATIENT during an Accident And Emergency Attendance. In the majority of cases this will be the person who took responsibility for the discharge of the PATIENT.
AMBULANCE_CARE_CONTACT_IDENT VARCHAR(20) Y An identifier allocated to each Ambulance Incident for each PATIENT.
AMBULANCE_INCIDENT_IDENT VARCHAR(20) Y An Identifierfor each PATIENT TRANSPORT JOURNEY
ARRIVAL_DT_TM DATETIME Y Date and time of patient arrival in A/E
ARRIVAL_MODE_NHS VARCHAR(1) Y Patient arrival mode in A/E
ATTENDANCE_CATEGORY_NHS VARCHAR(1) Y An indication of whether a PATIENT is making first or follow-up attendance at a particular Accident And Emergency Department.
ATTENDANCE_CONCLUSION_DT_TM DATETIME Y The time, recorded using a 24 hour clock, that a PATIENT's Accident And Emergency Attendance concludes or when treatment in Accident and Emergency is completed (whichever is the later).
ATTENDANCE_CONCLUSION_TM_TXT VARCHAR(8) Y The result of a attendance conclusion expressed in text form
ATTENDANCE_DISPOSAL_NHS VARCHAR(2) Y A coding of the ways in which an Accident And Emergency Attendance might end
ATTENDANCE_NBR_IDENT VARCHAR(12) Y A number allocated by an Accident And Emergency Department to provide a unique identifier for each Accident And Emergency Attendance.
CDS_BATCH_CONTENT_SK VARCHAR(40) Y Unique identifier for each cds item. This is the unique CDS ID reported to the NHS.
CONVEY_AMB_TRUST_NACS VARCHAR(12) Y ORGANISATION CODE (CONVEYING AMBULANCE TRUST) is the code of an Ambulance Service which conveys a PATIENT on a PATIENT TRANSPORT JOURNEY.
DEPARTMENT_TYPE_NHS VARCHAR(2) Y This is used to record the type of Isotope Procedure Department, based on the MAIN SPECIALTY CODE of the head of the DEPARTMENT, or the type of Physiological Measurement Department.
DEPARTURE_DT_TM DATETIME Y Date and time of patient departure from A/E
DEPARTURE_TM_TXT VARCHAR(8) 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.
EC_ACUITY_SCT VARCHAR(100) Y The SNOMED CT concept ID which is used to indicate the acuity of the patient's condition on the emergency care initial assessment date and emergency care initial assessment time.
EC_ALLOC_TREATMENT_DT_TM DATETIME Y The date and time that an Emergency Care Expected Date and Time of Treatment was allocated to the PATIENT.
EC_ARRIVAL_MODE_SCT VARCHAR(100) Y The SNOMED CT concept ID which is used to identify the transport mode by which the patient arrived at the emergency care department.
EC_ATTENDANCE_CATEGORY_NHS VARCHAR(1) Y The category of emergency care attendance.
EC_ATTENDANCE_SOURCE_SCT VARCHAR(100) Y The SNOMED CT concept ID which is used to indicate the source of an emergency care attendance.
EC_ATTENDANCE_SOURCE_SITE_NACS VARCHAR(12) Y Organisation identifier of the organisation site from which a patient arrived at an emergency care department.
EC_CHIEF_COMPLAINT_SCT VARCHAR(100) Y The SNOMED CT concept ID which is used to indicate the nature of the patient¿s chief complaint as assessed by the care professional first assessing the patient.
EC_CLINCIAL_TRAIL_IDENT VARCHAR(20) Y The clinical trial identifier must be recognised and registered with an organisation which is a primary registry in the world health organisation international clinical trials registry platform.
EC_CLIN_RDY_TO_PRCED_DT_TM DATETIME Y The first date and time that the CARE PROFESSIONAL, authorised to discharge the PATIENT from the Emergency Care Department, makes a clinical decision that the PATIENT no longer requires ongoing care in the Emergency Care Department.
EC_DECIDED_TO_ADMIT_DT_TM DATETIME Y Local date time of decided to admit date time.
EC_DEPARTMENT_TYPE_NHS VARCHAR(2) Y The type of emergency care department.
EC_DISCHARGE_DESTINATION_SCT VARCHAR(100) Y The SNOMED CT concept ID which is used to identify the intended destination of the patient following discharge from the emergency care department.
EC_DISCHARGE_FOLLOW_UP_SCT VARCHAR(100) Y The SNOMED CT concept ID which is used to identify the service to which a patient was referred for continuing care following an emergency care attendance.
EC_DISCHARGE_INFO_GIVEN_SCT VARCHAR(100) Y The SNOMED CT concept ID which is used to identify whether a copy of a letter to their general practitioner has been printed and given to the patient on discharge from an emergency care department.
EC_DISCHARGE_STATUS_SCT VARCHAR(100) Y The SNOMED CT concept ID which is used indicate the status of the patient on discharge from an emergency care department.
EC_DISEASE_OUTBREAK_NOTI VARCHAR(20) Y Disease outbreak notification is to support collection of nationally-notifiable data relating to outbreaks of disease which are identified in emergency care departments. Where a SNOMED CT code is available, the disease outbreak notification field should contain this. If a SNOMED CT code is not available, then it is permissible to submit free-text detail of the disease.
EC_DISEASE_OUTBREAK_NOTI_DESC VARCHAR(100) Y The SNOMED CT concept ID describing nationally-notifiable outbreaks of disease.
EC_DISEASE_OUTBREAK_NOTI_SCT VARCHAR(100) Y The SNOMED CT concept ID describing nationally-notifiable outbreaks of disease.
EC_DTA_ACT_TREAT_FUN_CD_NHS VARCHAR(3) Y The treatment function code of the service to which a patient is to be admitted.
EC_EXP_TREATMENT_DT_TM DATETIME Y Expected date and time of Emergency Care treatment.
EC_SITE_CODE_OF_DISCHARGE_NACS VARCHAR(12) Y The organisation identifier of the organisation site to which a patient is discharged following an emergency care attendance.
ETHNIC_CATEGORY_2021_NHS VARCHAR(3) Y The ethnicity of a PERSON, as specified by the PERSON using classification code used for the 2021 census.
ETHNIC_CATEGORY_NHS VARCHAR(2) Y The ethnicity of a PERSON, as specified by the PERSON
FIRST_PROCESS_DT_TM DATETIME N The date/time that the first ETL process started that created this record.
HEALTH_SYSTEM_ID DOUBLE Y Unique number assigned by Health Facts. Typically the universal Cerner assigned client id of the health system.
HEALTH_SYSTEM_SOURCE_ID DOUBLE Y 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_TYPE_NHS VARCHAR(2) Y The type of physical LOCATION where PATIENTS are seen or where SERVICES are provided or from which requests for services are sent.
INITIAL_ASSESSMENT_DT_TM DATETIME Y Date and time of Initial assessment
INITIAL_ASSESSMENT_TM_TXT VARCHAR(8) Y The time when the patient had their initial assessment in A&E
LAST_PROCESS_DT_TM DATETIME N The date/time that the last ETL process started that updated this record.
LOC_EC_ALLOC_TREATMENT_DT_TM DATETIME Y The local date and time that an Emergency Care Expected Date and Time of Treatment was allocated to the PATIENT.
LOC_EC_CLIN_RDY_TO_PRCED_DT_TM DATETIME Y The first local date and time that the CARE PROFESSIONAL, authorised to discharge the PATIENT from the Emergency Care Department, makes a clinical decision that the PATIENT no longer requires ongoing care in the Emergency Care Department.
LOC_EC_DECIDED_TO_ADMIT_DT_TM DATETIME Y Local date time of decided to admit date time.
LOC_EC_EXP_TREATMENT_DT_TM DATETIME Y Expected local date and time of Emergency Care treatment.
PATIENT_GRP_NHS VARCHAR(2) Y The patient's group as perceived by the clinician and recorded as part of the Dataset.
SEEN_FOR_TREATMENT_DT_TM DATETIME Y Date and time when the patient was seen for treatment
SEEN_FOR_TREATMENT_TM_TXT VARCHAR(8) Y The time when the patient was seen for treatment in A&E
SITE_CODE_OF_TREAT_NACS VARCHAR(12) Y SITE CODE (OF TREATMENT) is the ORGANISATION SITE CODE of the ORGANISATION where the PATIENT was treated
SOURCE_OF_REFERRAL_NHS VARCHAR(2) Y A CLASSIFICATION which identifies the source of referral of each Accident And Emergency Episode.
TOTAL_UPDATES DOUBLE N The numbers of updates that have occurred on this table.
UKRWH_CDS_AE_ATTENDANCE_KEY DOUBLE N The event action identifier on the SCH_EVENT_ACTION table of the A/E attendance
UKRWH_CDS_HEADER_KEY DOUBLE N This is the value of the unique primary identifier of the ukrwh cds header 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_CDS_AE_ATTENDANCE


Child Column in UKRWH_CDS_AE_ATTENDANCE(FK) Parent Table Name Parent Column Name
Parents: UKRWH_CDS_HEADER_KEY UKRWH_CDS_HEADER UKRWH_CDS_HEADER_KEY




Parent Column in UKRWH_CDS_AE_ATTENDANCE (PK) Child Table Name Child Column Name
Children: UKRWH_CDS_AE_ATTENDANCE_KEY UKRWH_CDE_AE_ATTENDANCE UKRWH_CDS_AE_ATTENDANCE_KEY
UKRWH_CDS_AE_INVESTIGATION UKRWH_CDS_AE_ATTENDANCE_KEY
UKRWH_CDS_AE_TREATMENT UKRWH_CDS_AE_ATTENDANCE_KEY


UKRWH_CDS_AE_INVESTIGATION



Column Section Relationship Section Top of Page


Table-level Detail

Description: UK Reporting Warehouse Commissioning Data Set Accident & Emergency Investigation
Definition: Contains CDS A&E attendance Investigation details relating to an A&E CDS Event.
Table Type: ACTIVITY





Column Detail - UKRWH_CDS_AE_INVESTIGATION


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.
CDS_BATCH_CONTENT_SK VARCHAR(40) N Unique identifier for each cds item. This is the unique CDS ID reported to the NHS.
EC_CLINICAL_INVESTIGATION_SCT VARCHAR(100) Y The SNOMED CT concept ID which is used to identify a clinical investigation performed while a patient is under the care of an emergency care department.
EC_INVEST_PROC_DT_TM DATETIME Y The date and time clinical investigation was performed during an emergency care attendance.
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.
INVESTIGATION_CD_TXT VARCHAR(6) Y The result of a clinical investigation expressed in text form
INVESTIGATION_SCHEME_NHS VARCHAR(2) Y This is used in the Clinical Activity Group of the CDS to denote the scheme basis of an A&E investigation
INVESTIGATION_SEQ DOUBLE Y This field contains the investigation sequence number
LAST_PROCESS_DT_TM DATETIME N The date/time that the last ETL process started that updated this record.
LOC_EC_INVEST_PROC_DT_TM DATETIME Y The local date and time clinical investigation was performed during an emergency care attendance.
TOTAL_UPDATES DOUBLE N The numbers of updates that have occurred on this table.
UKRWH_CDS_AE_ATTENDANCE_KEY DOUBLE N A number allocated by an Accident And Emergency Department to provide a unique identifier for each Accident And Emergency Attendance
UKRWH_CDS_AE_INVESTIGATION_KEY DOUBLE N This is the value of the unique primary identifier of the ukrwh cds ae investigation 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_CDS_AE_INVESTIGATION


Child Column in UKRWH_CDS_AE_INVESTIGATION(FK) Parent Table Name Parent Column Name
Parents: UKRWH_CDS_AE_ATTENDANCE_KEY UKRWH_CDS_AE_ATTENDANCE UKRWH_CDS_AE_ATTENDANCE_KEY


UKRWH_CDS_AE_TREATMENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: UK Reporting Warehouse Commissioning Data Set Accident & Emergency Treatment
Definition: Contains CDS A&E attendance Treatment details relating to an A&E CDS Event.
Table Type: ACTIVITY





Column Detail - UKRWH_CDS_AE_TREATMENT


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.
CDS_BATCH_CONTENT_SK VARCHAR(40) N Unique identifier for each cds item. This is the unique CDS ID reported to the NHS.
EC_TREATMENT_PROCEDURE_SCT VARCHAR(100) Y The SNOMED CT concept ID which is used to identify a patient procedure performed while a patient is under the care of an emergency care department.
EC_TREATMENT_PROC_DT_TM DATETIME Y The date and time a patient procedure was performed during an emergency care attendance.
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.
LOC_EC_TREATMENT_PROC_DT_TM DATETIME Y The local date and time a patient procedure was performed during an emergency care attendance.
TOTAL_UPDATES DOUBLE N The numbers of updates that have occurred on this table.
TREATMENT_CD_TXT VARCHAR(6) Y A broad classification of types of treatment or guidance which may be provided to a PATIENT as a result of Accident And Emergency Attendance.
TREATMENT_DT_TM DATETIME Y The time, recorded using the 24 hour clock, that the PATIENT is seen by a health professional to diagnose the problem and arrange or start tests and start treatment as necessary.
TREATMENT_SCHEME_NHS VARCHAR(2) Y This is used in the Clinical Activity Group of the CDS to denote the scheme basis of an A&E treatment
TREATMENT_SEQ DOUBLE Y A number indicating the sequence of a type of planned treatment
UKRWH_CDS_AE_ATTENDANCE_KEY DOUBLE N A number allocated by an Accident And Emergency Department to provide a unique identifier for each Accident And Emergency Attendance
UKRWH_CDS_AE_TREATMENT_KEY DOUBLE N This is the value of the unique primary identifier of the ukrwh cde ae treatment 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_CDS_AE_TREATMENT


Child Column in UKRWH_CDS_AE_TREATMENT(FK) Parent Table Name Parent Column Name
Parents: UKRWH_CDS_AE_ATTENDANCE_KEY UKRWH_CDS_AE_ATTENDANCE UKRWH_CDS_AE_ATTENDANCE_KEY


UKRWH_CDS_APC_ACP



Column Section Relationship Section Top of Page


Table-level Detail

Description: UK Reporting Warehouse Comm Data Set Admitted Patient Care Augmeted Care Period
Definition: Contains CDS Augmented Care Period details at the level of an Augmented Care Period relating to an Admitted Patient Care CDS Event.
Table Type: ACTIVITY





Column Detail - UKRWH_CDS_APC_ACP


Column Name Type Null? Definition
ACP_DISPOSAL_NHS VARCHAR(2) Y A coding of the ways in which an ACP encounter might end
ACP_LOCATION_NHS VARCHAR(2) Y The location at which augmented care (critical care) is delivered, excluding general wards, A&E, Radiology Departments, labour wards and special care baby units.
ACP_NBR_NHS VARCHAR(2) Y An ordered sequence number between 01 to 97 used to identify Augmented Care Periods uniquely within a Consultant Episode (Hospital Provider).
ACP_OUTCOME_IND_NHS VARCHAR(2) Y An indication as to whether the PATIENT survived the Augmented Care Period (retired 1 Apr 2006), and if they did not survive, whether they donated organs, (heart, lung, liver, kidney, pancreas and other whole organs
ACP_PLANNED_IND_NHS VARCHAR(1) N An indication as to whether any of the Augmented Care Period (retired 1 Apr 2006) were initiated as a result of a non-emergency treatment plan
ACP_SEQ DOUBLE Y A number indicating the sequence of a type of ACP
ACP_SOURCE_NHS VARCHAR(2) Y The location of the PATIENT prior to an Augmented Care Period (retired 1 Apr 2006).
ACP_SPECIALTY_FUNCTION_NHS VARCHAR(3) Y Specialties are divisions of clinical work which may be defined by body systems (dermatology), age (paediatrics), clinical technology (nuclear medicine), clinical function (rheumatology), group of diseases (oncology) or combinations of these factors. Only Specialty titles recognised by the Royal Colleges and Faculties should be used. This list is maintained by the European Specialist Medical Qualifications Order 1995 and European Primary and Specialist Dental Qualifications Regulations 1998.
ACP_START_DT_TM DATETIME Y Date & time of the start of the ACP encounter
CDS_BATCH_CONTENT_SK VARCHAR(40) N Unique identifier for each cds item. This is the unique CDS ID reported to the NHS.
ENCNT_AUGM_CARE_PERIOD_SK VARCHAR(40) Y This is a unique local ACTIVITY IDENTIFIER used to identify continuous augmented care when that care is split into different periods due to a change other than the completion of that care, e.g. the CONSULTANT responsible for the overall consultant episode changes.
END_DT_TM DATETIME Y The Date and time at the end of a ACPstay, an ACP episode, ACP period covered by a plan, or other period of time
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.
HIGH_DEPENDENCE_LEVEL_DAYS DOUBLE Y The number of high dependency care days between 0000 to 9998 (retired 1 Apr 2006)
INTENSIVE_CARE_LEVEL_DAYS DOUBLE Y The number of intensive care days between 0000 to 9998 (retired 1 Apr 2006)
LAST_PROCESS_DT_TM DATETIME N Date and time of the second process
ORGANS_SUPPORTED_CNT DOUBLE Y The number of organ systems supported can be between 00 to 05 (retired 1 Apr 2006)
TOTAL_UPDATES DOUBLE N The numbers of updates that have occurred on this table.
UKRWH_CDS_APC_ACP_KEY DOUBLE N This is the value of the unique primary identifier of the ukrwh cde apc acp 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 apc 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_CDS_APC_ACP


Child Column in UKRWH_CDS_APC_ACP(FK) Parent Table Name Parent Column Name
Parents: UKRWH_CDS_APC_EPISODE_KEY UKRWH_CDS_APC_EPISODE UKRWH_CDS_APC_EPISODE_KEY