Table Detail Report

UKRWH_CDE_OP_ATTENDANCE



Column Section Relationship Section Top of Page


Table-level Detail

Description: UK Reporting Warehouse Consolidated Data Extract Outpatient Attendance
Definition: Contains additional attendance level details relating to an Outpatient CDS Event.
Table Type: ACTIVITY





Column Detail - UKRWH_CDE_OP_ATTENDANCE


Column Name Type Null? Definition
ADMINISTRATIVE_CATEGORY_REF VARCHAR(40) Y Identifies if a PATIENT is required to pay for treatment provided within a particular ACTIVITY or for transport.
APPT_LOCATION_REF VARCHAR(40) Y A coded identifier corresponding to the scheduled appointment location
APPT_TYPE_REF VARCHAR(40) Y The identifier for an appointment type.
ATTENDANCE_DT_TM DATETIME Y Begin Date and Time value
ATTEND_DOC_PRSNL VARCHAR(40) Y The internal person ID of the physician attending the patient in outpatients
CDS_BATCH_CONTENT_SK VARCHAR(40) Y Unique identifier for each cds item. This is the unique CDS ID reported to the NHS.
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_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.
ENCTR_CREATE_DT_TM DATETIME Y This is the date and time that a row is created in the encounter table.
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_PROCESS_DT_TM DATETIME N Date and time of the first process
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_PROCESS_DT_TM DATETIME N Date and time of the second process
LOC_ATTENDANCE_DT_TM DATETIME Y The begin date and time value.
LOC_FACILITY_REF VARCHAR(40) Y This field is the current patient location with a location type of facility.
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.
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.
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.
RESOURCE_REF VARCHAR(40) Y The identifier for the resource. A resource is an item of limited availability.
SCHEDULE_SK VARCHAR(40) Y The unique identifier for the millennium event schedule. The schedules are used to track rescheduling of an event.
SCH_EVENT_SK VARCHAR(40) Y The unique identifier for a resource's/patient's appointment
SCH_STATE_REF VARCHAR(40) Y The coded identifier corresponding to the current state of the appointment
SLOT_MNEMONIC_TXT VARCHAR(100) Y A 100-character string used for identification and selection
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_OP_ATTENDANCE_KEY DOUBLE N This is the value of the unique primary identifier of the ukrwh cde op attendance table. It is an internal system assigned number.
UKRWH_CDE_OP_REFERRAL_KEY DOUBLE N This is the value of the unique primary identifier of the ukrwh cde op referral table. It is an internal system assigned number.
UKRWH_CDS_OP_ATTENDANCE_KEY DOUBLE N This is the value of the unique primary identifier of the ukrwh cds op 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.
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_OP_ATTENDANCE


Child Column in UKRWH_CDE_OP_ATTENDANCE(FK) Parent Table Name Parent Column Name
Parents: UKRWH_CDE_OP_REFERRAL_KEY UKRWH_CDE_OP_REFERRAL UKRWH_CDE_OP_REFERRAL_KEY
UKRWH_CDS_OP_ATTENDANCE_KEY UKRWH_CDS_OP_ATTENDANCE UKRWH_CDS_OP_ATTENDANCE_KEY




Parent Column in UKRWH_CDE_OP_ATTENDANCE (PK) Child Table Name Child Column Name
Children: UKRWH_CDE_OP_ATTENDANCE_KEY UKRWH_CDE_SCH_EVENT_ACTION UKRWH_CDE_OP_ATTENDANCE_KEY


UKRWH_CDE_OP_REFERRAL



Column Section Relationship Section Top of Page


Table-level Detail

Description: UK Reporting Warehouse Consolidated Data Extract Outpatient Referral
Definition: Contains additional Referral level details relating to an Outpatient CDS Event.
Table Type: ACTIVITY





Column Detail - UKRWH_CDE_OP_REFERRAL


Column Name Type Null? Definition
ADMINISTRATIVE_CATEGORY_REF VARCHAR(40) Y Identifies if a PATIENT is required to pay for treatment provided within a particular ACTIVITY or for transport.
ADMIT_BOOKING_REF VARCHAR(40) Y Admission booking system type.
ADMIT_GUARANTEED_DT_TM DATETIME Y The date by which a PATIENT on an ELECTIVE ADMISSION LIST is guaranteed to be admitted.
ATTEND_DOC_PRSNL VARCHAR(40) Y This is the value of the unique primary identifier of the personnel table. This is a 'role' name for the reference to person_id in the personnel table and used to differentiate between other references to person_id in this table.
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.
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_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
LIST_TYPE_REF VARCHAR(40) Y The code value for the planned Procedure for this wait list row.
LOC_ORIG_REFERRAL_RCVD_DT_TM DATETIME Y This records the first referral request received date for a specific health care service to be provided, which was received.
LOC_WAITING_END_DT_TM DATETIME Y The waiting end date time.
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
ORIGINAL_REFERRAL_RCVD_DT_TM DATETIME Y This records the first REFERRAL REQUEST RECEIVED DATE for a specific health care service to be provided, which was received.
ORIG_OP_REF_IND DOUBLE N Original Outpatient Referral Indicator
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.
REASON_FOR_REMOVAL_REF VARCHAR(40) Y Code value for a text description of the reason a removal was made.
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.
REFERRAL_TYPE_REF VARCHAR(40) Y Referral type.
REFERRAL_WRITTEN_DT_TM DATETIME Y This records the date time when REFERRAL REQUEST for a specific health care service was written into Millennium.
REFERRER_DOC_PRSNL VARCHAR(40) Y This is the value of the unique primary identifier of the personnel table. This is a 'role' name for the reference to person_id in the personnel table and used to differentiate between other references to person_id in this table.
SERVICE_TYPE_REQUESTED_REF VARCHAR(40) Y Service type requested.
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.
UBRN_IDENT VARCHAR(12) Y This field contains the unique identifier for UBRN
UKRWH_CDE_OP_REFERRAL_KEY DOUBLE N This is the value of the unique primary identifier of the ukrwh cde op referral 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_CD 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.
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.



Relationship Detail - UKRWH_CDE_OP_REFERRAL


Child Column in UKRWH_CDE_OP_REFERRAL(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_OP_REFERRAL (PK) Child Table Name Child Column Name
Children: UKRWH_CDE_OP_REFERRAL_KEY UKRWH_CDE_OP_ATTENDANCE UKRWH_CDE_OP_REFERRAL_KEY


UKRWH_CDE_PERSON_PATIENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: UK Reporting Warehouse Consolidated Data Extract Person Patient
Definition: Contains patient details pertinent to a specific Trust.
Table Type: ACTIVITY





Column Detail - UKRWH_CDE_PERSON_PATIENT


Column Name Type Null? Definition
BIRTH_DT_TM DATETIME Y The date and time of birth for the person.
BUSINESS_PHONE_NBR VARCHAR(100) Y The patients business phone number
CITY VARCHAR(100) Y The city field is the text name of the city associated with the address row.
COUNTRY_REF VARCHAR(40) Y The country code is the code set value which identifies the country for the address row.
DECEASED_DT_TM DATETIME Y The date and time of death for the person.
DECEASED_REF VARCHAR(40) Y Identifies if the person is deceased.
DECEASED_SOURCE_REF VARCHAR(40) Y Defines the particular source that gave deceased information concerning a person..
EMAIL_ADDR VARCHAR(100) Y This field contains the patients email address
ESTIMATED_BIRTH_DT_REF VARCHAR(40) Y Birth date code indicates the kind of birth date and time value that is contained in the birth_dt_tm field. (i.e., estimated, still born, unknown, etc.)
ETHNIC_GROUP_REF VARCHAR(40) Y Identifies a religious, national, racial, or cultural group of the person.
EXTRACT_DT_TM DATETIME Y The date and time the row was extracted
FIRST_NAME VARCHAR(200) Y This is the person's given first name.
FIRST_NAME_UNF VARCHAR(100) 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(100) Y This is the complete person name including punctuation and formatting.
GP_PRSNL VARCHAR(40) Y This is the value of the unique primary identifier of the personnel table. This is a 'role' name for the reference to person_id in the personnel table and used to differentiate between other references to person_id in this table
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.
HOME_PHONE_NBR VARCHAR(100) Y The patients home phone number
LAST_NAME VARCHAR(200) Y This is the person's family name.
LAST_NAME_UNF VARCHAR(100) 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
LINE1_ADDR VARCHAR(100) Y This is the first line of the street address.
LINE2_ADDR VARCHAR(100) Y This is the second line of the street address.
LINE3_ADDR VARCHAR(100) Y This is the third line of the street address. The third line of the street address will generally only be used for international addresses.
LINE4_ADDR VARCHAR(100) Y This is the fourth line of the street address. The fourth line of the street address will generally only be used for international addresses.
LOCAL_PATIENT_IDENT VARCHAR(10) Y This number is used to identify a patient uniquely within a Health Care Provider.
LOCAL_PATIENT_IDENT_ALIAS_REF VARCHAR(40) Y The alias is an identifier (I.e., SSN, medical record number, etc.) for a person. The alias may be unique or non-unique depending on the type of alias.
MARITAL_TYPE_REF VARCHAR(40) Y This field identifies the status of the person with regard to being married.
MIDDLE_NAME VARCHAR(200) Y This is the given middle name for the person.
MOBILE_PHONE_NBR VARCHAR(100) Y The patients mobile phone number
NAME_PREFIX_NAME VARCHAR(100) Y This field containsthe patients name prefix
NHS_NBR_IDENT VARCHAR(20) Y The alias is an identifier (I.e., SSN, medical record number, etc.) for a person. The alias may be unique or non-unique depending on the type of alias.
NHS_NBR_IDENT_STATUS_REF VARCHAR(40) Y Person Alias Status Code identifies the status of an alias( i.e. Verified, Not traced, Trace in Progress, etc.)
ORGANIZATION_SK VARCHAR(40) Y This field contains the unique identifier for the Trust
ORGAN_DONOR_IND DOUBLE Y A sequentially assigned number which uniquely identifies an Organ Donor record.
PCT_RESIDENCE_NACS VARCHAR(5) Y This field contains the NACS code for the PCT where the patient resides
PERSON_ACTIVE_IND DOUBLE Y The Millennium person 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.
PERSON_CREATE_DT_TM DATETIME Y This is the date and time that a row is created in the person table.
PERSON_CREATE_PRSNL VARCHAR(40) Y This is the person/personnel responsible for creating a row in the person table.
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.
PERSON_UPDT_DT_TM DATETIME Y The date and time the row was last inserted or updated.
PERSON_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 table.
POSTCODE VARCHAR(25) Y This field contains the postal code for the street address in the address row.
REGISTERED_GP_PRCTC_ORG_NACS VARCHAR(6) Y The NACS code for the registered GP Practice
RELIGION_REF VARCHAR(40) Y A particular integrated system of belief in a supernatural power.
SERIAL_CHANGE_NBR_IDENT DOUBLE Y A number to provide a unique identifier for each serial change
SEX_REF VARCHAR(40) Y The gender of the patient (i.e., male, female, unknown).
SHA_RESIDENCE_NACS VARCHAR(5) Y This field contains the NACS code for the SHA where the patient resides
TOTAL_UPDATES DOUBLE N The numbers of updates that have occurred on this table.
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.
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_PERSON_PATIENT




Parent Column in UKRWH_CDE_PERSON_PATIENT (PK) Child Table Name Child Column Name
Children: UKRWH_CDE_PERSON_PATIENT_KEY UKRWH_CDE_AE_ATTENDANCE UKRWH_CDE_PERSON_PATIENT_KEY
UKRWH_CDE_EAL_ENTRY UKRWH_CDE_PERSON_PATIENT_KEY
UKRWH_CDE_IP_ADMISSION UKRWH_CDE_PERSON_PATIENT_KEY
UKRWH_CDE_OP_REFERRAL UKRWH_CDE_PERSON_PATIENT_KEY
UKRWH_CDE_PERSON_PERSON_RELTN UKRWH_CDE_PERSON_PATIENT_KEY


UKRWH_CDE_PERSON_PERSON_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: UK Reporting Warehouse Consolidated Data Extract Person Person Relationship
Definition: Contains Person Person relationships pertinent to pateints for a specific Trust.
Table Type: ACTIVITY





Column Detail - UKRWH_CDE_PERSON_PERSON_RELTN


Column Name Type Null? Definition
BUSINESS_PHONE_NBR VARCHAR(100) Y The patients business phone number
CITY VARCHAR(100) Y The fifth text string comprising one line of an ADDRESS of the patient
COUNTRY_REF VARCHAR(40) Y The country code is the code set value which identifies the country for the address row.
EMAIL_ADDR VARCHAR(100) Y The code allocated by the Post Office to identify a group of postal delivery points
EXTRACT_DT_M DATETIME Y The date and time the row was extracted
FIRST_NAME VARCHAR(200) Y This is the person's first given name
FIRST_NAME_UNF VARCHAR(100) Y First name key
FIRST_PROCESS_DT_TM DATETIME N Date and time of the first process
FULL_FORMATTED_NAME VARCHAR(100) Y This is the complete person name including punctuation, formatting, prefix, and suffix
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.
HOME_PHONE_NBR VARCHAR(100) Y The patients home phone number
LAST_NAME VARCHAR(200) Y This is the person's family name
LAST_NAME_UNF VARCHAR(100) Y Last name key
LAST_PROCESS_DT_TM DATETIME N Date and time of the second process
LINE1_ADDR VARCHAR(100) Y The first text string comprising one line of an ADDRESS of the patient
LINE2_ADDR VARCHAR(100) Y The second text string comprising one line of an ADDRESS of the patient
LINE3_ADDR VARCHAR(100) Y The third text string comprising one line of an ADDRESS of the patient
LINE4_ADDR VARCHAR(100) Y The fourth text string comprising one line of an ADDRESS of the patient
MIDDLE_NAME VARCHAR(200) Y This is the person's middle or secondary given name or names
MOBILE_PHONE_NBR VARCHAR(100) Y The patients mobile phone number
PERSON_PERSON_RELTN_SK VARCHAR(40) Y The identifying key of Millennium Person Person Relationship
PERSON_RELTN_REF VARCHAR(40) Y Person Relation Code Value
PERSON_RELTN_TYPE_REF VARCHAR(40) Y Code value indicating what type of relationship this is
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.
POSTCODE CHAR(25) Y This field contains the postal code for the street address in the address row.
PREFIX_NAME VARCHAR(100) Y Name prefix includes any titles that will precede the regular person name
RELATED_PERSON_SK VARCHAR(40) Y Millennium Related Person ID
TOTAL_UPDATES DOUBLE N The numbers of updates that have occurred on this table.
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_CDE_PERS_PERS_RELTN_KEY DOUBLE N This is the value of the unique primary identifier of the ukrwh cde person person relation 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_PERSON_PERSON_RELTN


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


UKRWH_CDE_SCH_EVENT_ACTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: UK Reporting Warehouse Consolidated Data Extract Schedule Event Action
Definition: Contains denormalised schedule event action details relating to Outpatiient and Elective Admission List CDS Events.
Table Type: ACTIVITY





Column Detail - UKRWH_CDE_SCH_EVENT_ACTION


Column Name Type Null? Definition
BOOKING_ACTION_DT_TM DATETIME Y Booking Action Date and Time
BOOKING_ACTION_PRSNL VARCHAR(40) Y The internal person ID of the personnel making the booking
CANCEL_DNA_ACTION_DT_TM DATETIME Y DNA Cancel Date and Time
CANCEL_DNA_ACTION_PRSNL VARCHAR(40) Y The person_id of the person from the personnel table (prsnl) that cancelled the DNA
CANCEL_DNA_PERFOM_DT_TM DATETIME Y Date and Time when the DNA was actually perfomed
CANCEL_REASON_MEANING_TXT VARCHAR(12) Y A 12-character description corresponding to the cancelling reason
CANCEL_REASON_REF VARCHAR(40) Y The coded identifier of the cancelling reason
CDS_BATCH_CONTENT_SK VARCHAR(40) N Unique identifier for each cds item. This is the unique CDS ID reported to the NHS.
CHECKIN_ACTION_DT_TM DATETIME Y Date and Time of Checkin
CHECKIN_ACTION_PRSNL VARCHAR(40) Y The Millennium person_id of the person from the personnel table (prsnl) that checked in the patient
CHECKIN_PERFOM_DT_TM DATETIME Y Date and Time when the Checkin was actually performed
CHECKOUT_ACTION_DT_TM DATETIME Y Date and Time of Checkout
CHECKOUT_ACTION_PRSNL VARCHAR(40) Y The person_id of the person from the personnel table (prsnl) that checked out the patient
CHECKOUT_PERFORM_DT_TM DATETIME Y Date and Time when the Checkout was actually performed
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_BOOKING_ACTION_DT_TM DATETIME Y The booking action date and time.
LOC_CANCEL_DNA_ACTION_DT_TM DATETIME Y The DNA cancel date and time.
RESCHEDULE_ACTION_DT_TM DATETIME Y Scheduling Action Data and Time
RESCHEDULE_ACTION_PRSNL VARCHAR(40) Y The person_id of the person from the personnel table (prsnl) that rescheduled the appointment
RESCHEDULE_PERFORM_DT_TM DATETIME Y The performed date and time specified by the user that the Rescheduling action was performed. It is used for retroactive checkin.
RESCHEDULE_REASON_MEANING_TXT VARCHAR(12) Y A 12-character description corresponding to the scheduling reason
RESCHEDULE_REASON_REF VARCHAR(40) Y The coded identifier of the scheduling reason
SCHEDULE_SK VARCHAR(40) Y The unique identifier for the event schedule.
SCH_ACTION_SK VARCHAR(40) Y The Millennium identifier to uniquely identify the action being performed
SCH_EVENT_SK VARCHAR(40) Y The identifier to uniquely identify the event being performed
TOTAL_UPDATES DOUBLE N The numbers of updates that have occurred on this table.
UKRWH_CDE_OP_ATTENDANCE_KEY DOUBLE N The event action identifier on the SCH_EVENT_ACTION table of the O/P attendance
UKRWH_CDE_SCH_EVENT_ACTION_KEY DOUBLE N The event action identifier of the event action
UKRWH_CDS_EAL_OFFER_KEY DOUBLE N The event action identifier on the SCH_EVENT_ACTION table of the EAL offer
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.
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_SCH_EVENT_ACTION


Child Column in UKRWH_CDE_SCH_EVENT_ACTION(FK) Parent Table Name Parent Column Name
Parents: UKRWH_CDE_OP_ATTENDANCE_KEY UKRWH_CDE_OP_ATTENDANCE UKRWH_CDE_OP_ATTENDANCE_KEY
UKRWH_CDS_EAL_OFFER_KEY UKRWH_CDS_EAL_OFFER UKRWH_CDS_EAL_OFFER_KEY
UKRWH_CDS_HEADER_KEY UKRWH_CDS_HEADER UKRWH_CDS_HEADER_KEY