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 |