Appointment Reference

Optional Appointment reference data which assists the data consumer in interpreting proprietary coded information such as flags in the appointment data set. Each record identifies, the field in the extract to which the mapping applies, the value and the mapping for the value that supports interpretation of the field as well as the effective dates for the mapping. Reference data may for example be used to re-construct the history of the mapping to the national appointment slot category code for the appointment slot type field.

Table 1. Appointment_reference

Database Field Name	Field Description	Sensitive Field	Identifiable Field	Field Type	Field Length	Optionality
field	The field in the appointment dataset (XML short name) to which the mapping applies	Yes	No	String	min an1 max an36	M
from_date	The Timestamp from which the appointment reference data mapping was applicable	Yes	No	Timestamp	min an4 max an23	M
issue_date_time	When the GP Data Appointment Reference Data Extract was generated	Yes	No	Timestamp	min an4max an23	M
map	The label or mapped value assigned to the value specified	Yes	No	String	min an1 max an255	M
provider_id	The Organisation Data Service (ODS) Code of the practice or provider contributing the practice/provider level extract	Yes	No	String	min an3 max an12	M
source_system	The source supplier for the extract	Yes	No	String	min an1 max an36	M
to_date	The timestamp from which the appointment reference data mapping was applicable	Yes	No	Timestamp	min an4 max an23	O
value	The value to which the mapping applied	Yes	No	String	min an1 max an255	M