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 |