Table Detail Report

UKRWH_CDS_NHS_DATA_DICT



Column Section Top of Page


Table-level Detail

Description: UK Reporting Warehouse Comm Data Set National Health Service Data Dictionary
Definition: Contains Reference Descriptiions for NHS Data Dictionary Code values.
Table Type: REFERENCE





Column Detail - UKRWH_CDS_NHS_DATA_DICT


Column Name Type Null? Definition
BEG_EFFECTIVE_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.
DATA_DICT_CODE_NHS VARCHAR(20) Y This field contains the NHS code for the NHS Data Dictionary Data element
DATA_DICT_DEFAULT_IND DOUBLE Y This field indicates whether the particular NHS Data Dictionary Data element has a default value
END_EFFECTIVE_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.
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
NHS_DATA_DICT_DESCRIPTION_TXT VARCHAR(200) Y This field contains the description for the NHS Data Dictionary Data element
NHS_DATA_DICT_ELEMENT_NAME VARCHAR(100) Y This field contains the name of the NHS Data Dictionary Data element
NHS_DATA_DICT_ELEMENT_NAME_UNF VARCHAR(100) Y This field contains the name key of the NHS Data Dictionary Data element
TOTAL_UPDATES DOUBLE N The numbers of updates that have occurred on this table.
UKRWH_CDS_NHS_DATA_DICT_KEY DOUBLE N This is the value of the unique primary identifier of the ukrwh cds nhs data dict 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.


UKRWH_CDS_OP_ATTENDANCE



Column Section Relationship Section Top of Page


Table-level Detail

Description: UK Reporting Warehouse Commissioning Data Set Outpatient Attendance
Definition: Contains CDS Outpatient details relating to an Outpatient CDS Event.
Table Type: ACTIVITY





Column Detail - UKRWH_CDS_OP_ATTENDANCE


Column Name Type Null? Definition
ACTIVITY_LOC_TYPE_NHS VARCHAR(3) Y The type of LOCATION for an ACTIVITY
ATTENDANCE_DT_TM DATETIME Y The date of an attendance, for example at a Consultant Clinic, Nurse Clinic, Accident And Emergency Department or by a Ward Attender.
ATTENDANCE_IDENT VARCHAR(12) Y The ACTIVITY IDENTIFIER for the attendance. A sequential number or time of day used to enable an attendance to be uniquely identified.
ATTENDED_NHS VARCHAR(1) Y This indicates whether or not an APPOINTMENT for a CARE CONTACT took place. If the APPOINTMENT did not take place it also indicates whether or not advanced warning was given.
CDS_BATCH_CONTENT_SK VARCHAR(40) N Unique identifier for each cds item. This is the unique CDS ID reported to the NHS.
CLINIC_NHS VARCHAR(12) Y An identifier for a CLINIC OR FACILITY
CONSULTATION_MEDIUM_USED_NHS VARCHAR(2) Y "CONSULTATION MEDIUM USED identifies the communication mechanism used to relay information between the CARE PROFESSIONAL and the PERSON who is the subject of the consultation, during a CARE ACTIVITY."
EARLIEST_CLIN_APPROP_DT_TM DATETIME Y The earliest DATE that it was clinically appropriate for an ACTIVITY to take place.
EARLIEST_RSNBL_OFFER_DT_TM DATETIME Y It is the date of the earliest of the Reasonable Offers made to a PATIENT for an APPOINTMENT or Elective Admission. It should only be included on the Commissioning Data Sets where the PATIENT has declined at least two Reasonable Offers.
EXPECTED_DUR_OF_APPT DOUBLE Y The expected duration in minutes of an APPOINTMENT when booked, prior to the attendance of the PATIENT.
FIRST_ATTENDANCE_NHS VARCHAR(1) Y This indicates whether a PATIENT is making a first attendance or contact; or a follow-up attendance or contact.
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_DNA_CANCELLED_DT_TM DATETIME Y The DATE recorded when PATIENTS who have been offered a date for admission have missed this admission date with or without advance notice.
LAST_PROCESS_DT_TM DATETIME N Date and time of the second process
LOCATION_CLASS_NHS VARCHAR(2) Y A classification for use within CDS messages of the physical location within which the recorded patient event occurs.
MEDICAL_STAFF_TYPE_NHS VARCHAR(2) Y A classification of the type of care professional staff dealing with the PATIENT during an Out-Patient Attendance Consultant or Nurse or Midwife Contact.
MULTI_PROFESS_OR_MCIC_NHS VARCHAR(1) Y An indication of whether a PATIENT was seen by a single or multiple CARE PROFESSIONALS during an Clinic Attendance Consultant or Clinic Attendance Non-Consultant, recorded for the purposes of Payment by Results.
OPERATION_STATUS_NHS VARCHAR(1) Y OPERATION STATUS should be used once for each record to record states of knowledge regarding the operative procedure.
OUTCOME_OF_ATTENDANCE_NHS VARCHAR(1) Y This records the outcome of an Out-Patient Attendance Consultant.
PRIORITY_TYPE_NHS VARCHAR(1) Y This is the priority of a request for services; in the case of services to be provided by a CONSULTANT, it is as assessed by or on behalf of the CONSULTANT.
REFERRAL_REQUEST_RCVD_DT_TM DATETIME Y This records the date the REFERRAL REQUEST was received by the Health Care Provider.
REFERRAL_SOURCE_NHS VARCHAR(2) Y A CLASSIFICATION which is used to identify the source of referral of each Consultant Out-Patient Episode.
REHAB_ASSESS_TEAM_TYPE_NHS VARCHAR(1) Y An indication of whether the CARE PROFESSIONAL TEAM undertaking a Rehabilitation Assessment, is specialised or non-specialised. This information is recorded for the purposes of Payment by Results.
SERVICE_REQUESTED_TYPE_NHS VARCHAR(1) Y A request for the provision of care services to a PATIENT.
TOTAL_UPDATES DOUBLE N The numbers of updates that have occurred on this table.
TREATMENT_SITE_NACS VARCHAR(12) Y SITE CODE (OF TREATMENT) is the ORGANISATION SITE CODE for the ORGANISATION SITE where the PATIENT was treated.
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.
UKRWH_CDS_OP_ATTENDANCE_KEY DOUBLE N The ACTIVITY IDENTIFIER for the OP attendance.
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_OP_ATTENDANCE


Child Column in UKRWH_CDS_OP_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_OP_ATTENDANCE (PK) Child Table Name Child Column Name
Children: UKRWH_CDS_OP_ATTENDANCE_KEY UKRWH_CDE_OP_ATTENDANCE UKRWH_CDS_OP_ATTENDANCE_KEY


UKRWH_CDS_ORG_NACS



Column Section Top of Page


Table-level Detail

Description: UK Reporting Warehouse Comm Data Set Org National Administrative Code Service
Definition: Contains Reference Descriptions for NHS NACS Organisations.
Table Type: REFERENCE





Column Detail - UKRWH_CDS_ORG_NACS


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.
BEG_EFFECTIVE_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.
END_EFFECTIVE_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.
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.
IT_CLUSTER_NACS VARCHAR(3) Y LO - LOCAL SERVICE PROVIDER (LSP)
LAST_PROCESS_DT_TM DATETIME N Date and time of the second process
LINE1_ADDR VARCHAR(35) Y The first text string comprising one line of an ADDRESS.
LINE2_ADDR VARCHAR(35) Y The second text string comprising one line of an ADDRESS.
LINE3_ADDR VARCHAR(35) Y The third text string comprising one line of an ADDRESS.
LINE4_ADDR VARCHAR(35) Y The fourth text string comprising one line of an ADDRESS.
LINE5_ADDR VARCHAR(35) Y The fifth text string comprising one line of an ADDRESS.
ORGANISATION_NAME VARCHAR(100) Y The name by which an ORGANISATION wishes to be known or the official name given to an ORGANISATION.
ORGANISATION_NAME_UNF VARCHAR(100) Y This organization name in all capitals with punctuation removed. This field is used for indexing and searching for a organization by name.
ORGANISATION_TYPE VARCHAR(50) Y A list of ORGANISATION TYPES of ORGANISATIONS according to the nature of the ORGANISATION (e.g. NHS Trust, Health Authority etc.).
ORGANIZATION_SK VARCHAR(40) Y This is the value of the unique primary identifier of the organization table. It is an internal system assigned number.
ORG_CODE_NACS VARCHAR(8) Y The code by which an ORGANISATION wishes to be known or the official code given to an ORGANISATION.
POSTCODE VARCHAR(25) Y The code allocated by the Post Office to identify a group of postal delivery points. A code used primarily for the delivery of correspondence to ADDRESSES. POSTCODES may also be used to define a GEOGRAPHIC AREA.
SHA_NACS VARCHAR(3) Y Strategic Health Authority is an ORGANISATION. An NHS organisation established to lead the strategic development of the local health service and manage Primary Care Trusts and NHS Trusts on the basis of local accountability agreements.
TOTAL_UPDATES DOUBLE N The numbers of updates that have occurred on this table.
UKRWH_CDS_ORG_NACS_KEY DOUBLE N This is the value of the unique primary identifier of the ukrwh cds org nacs 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.


UKRWH_CDS_PROCEDURE



Column Section Relationship Section Top of Page


Table-level Detail

Description: UK Reporting Warehouse Commissioning Data Set Procedure
Definition: Contains CDS Procedure details at the level of a Procedure relating to a CDS Event.
Table Type: ACTIVITY





Column Detail - UKRWH_CDS_PROCEDURE


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.
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
PRIMARY_PROCEDURE_DT_TM DATETIME Y This is the Clinical Intervention Date of the PRIMARY OPERATION (OPCS-4). Primary Procedure Date is an ACTIVITY DATE where the ACTIVITY DATE TIME TYPE is National Code 41 'Primary Procedure Date'. Clinical Intervention Date is an ACTIVITY DATE were ACTIVITY DATE TIME TYPE is National Code 34 'Clinical Intervention Date'.
PROCEDURE_CD_TXT VARCHAR(4) Y Primary' is a classification of PATIENT PROCEDURE CODING SIGNIFICANCE of INTERVENTION CLASSIFICATION ASSOCIATION for the coding of an OPERATIVE PROCEDURE.
PROCEDURE_MOHPR_ENTRY_IDENT VARCHAR(12) Y The PROFESSIONAL REGISTRATION ENTRY IDENTIFIER of the CARE PROFESSIONAL carrying out a Patient Procedure of MAIN Operating healthcare professional.
PROCEDURE_MOHPR_ISSUE_NHS VARCHAR(2) Y PROFESSIONAL REGISTRATION ISSUER CODE is the same as attribute PROFESSIONAL REGISTRATION BODY CODE of MAIN Operating healthcare professional.
PROCEDURE_RAPR_ENTRY_IDENT VARCHAR(12) Y PROFESSIONAL REGISTRATION ISSUER CODE is the same as attribute PROFESSIONAL REGISTRATION BODY CODE of the carrying out a Patient Procedure of responsible anaesthetist.
PROCEDURE_RAPR_ISSUE_NHS VARCHAR(2) Y An indication of whether a PATIENT DIAGNOSIS was already present when the PATIENT started a Hospital Provider Spell of the carrying out a Patient Procedure of responsible anaesthetist.
PROCEDURE_SCHEME_NHS VARCHAR(2) Y This is used in the Clinical Activity Group of the CDS to denote the scheme basis of an Intervention, Operation or A&E Treatment.
PROCEDURE_SEQ DOUBLE Y A Number given to a procedure other than the PRIMARY PROCEDURE (OPCS), carried out and recorded for CDS or HES purposes. For CDS purposes it is recommended that multiple Procedures are recorded and the CDS-XML Message (CDS Version 6 onwards) has been designed to carry as many Procedures as required.
TOTAL_UPDATES DOUBLE N The numbers of updates that have occurred on this table.
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.
UKRWH_CDS_PROCEDURE_KEY DOUBLE N This is the value of the unique primary identifier of the ukrwh cds procedure 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_PROCEDURE


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


UKRWH_CDS_PRSNL



Column Section Top of Page


Table-level Detail

Description: UK Reporting Warehouse Commissioning Data Set Personnel
Definition: Contains Personnel details.
Table Type: REFERENCE





Column Detail - UKRWH_CDS_PRSNL


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_PRSNL VARCHAR(40) Y The person who caused the active_status_cd to be set or change.
CONSULTANT_CODE_IDENT VARCHAR(15) Y This is the GENERAL MEDICAL COUNCIL (GMC) NUMBER for the CONSULTANT. For GENERAL MEDICAL PRACTITIONERS working as CONSULTANTS, the GENERAL MEDICAL PRACTITIONER's GENERAL MEDICAL COUNCIL (GMC) NUMBER should be used, see data item note for GENERAL MEDICAL PRACTITIONER (SPECIFIED).
FIRST_NAME VARCHAR(200) Y The specific first name of a patient by which a PERSON may be known.
FIRST_NAME_UNF VARCHAR(200) Y This is the person's first given name all capitals with punctuation removed. This field is used for indexing and searching for a person by name.
FIRST_PROCESS_DT_TM DATETIME N Date and time of the first process
FULL_FORMATTED_NAME VARCHAR(200) Y This is the complete person name including punctuation and formatting.
GP_CODE_IDENT VARCHAR(15) Y This is the code of the GENERAL MEDICAL PRACTITIONER specified by the PATIENT.
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.
LAST_NAME VARCHAR(200) Y The specific surname / last name of a patient by which a PERSON may be known.
LAST_NAME_UNF VARCHAR(200) Y This is the person's family name all capitals with punctuation removed. This field is used for indexing and searching for a person by name.
LAST_PROCESS_DT_TM DATETIME N Date and time of the second process
MIDDLE_NAME VARCHAR(200) Y The specific middle name of a patient by which a PERSON may be known.
MILL_USERNAME VARCHAR(50) Y The system user name for the personnel used to gain primary access to the computer system.
PHYSICIAN_IND DOUBLE Y Set to TRUE, if the personnel is a physician. Otherwise, set to FALSE.
POSITION_DISPLAY_TXT VARCHAR(40) Y The Display text of the position that was used to determine the applications and tasks the personnel is authorized to use.
POSITION_REF VARCHAR(40) Y The position is used to determine the applications and tasks the personnel is authorized to use.
PREFIX_NAME VARCHAR(100) Y Name prefix includes any titles that will precede the regular person name.
PRSNL_CODE_IDENT VARCHAR(100) Y Personnel Id associated with routing rule
PRSNL_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.
TOTAL_UPDATES DOUBLE N The numbers of updates that have occurred on this table.
UKRWH_CDS_PRSNL_KEY DOUBLE N This is the value of the unique primary identifier of the ukrwh cds prsnl 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.