Schema

Column Name	Data Type	Description
attendance_register_id	integer	Primary key from the attendance register.
organisation	varchar	An organisation is synonymous with a pharmacy and is also known as the RXid.
is_deleted	boolean	Whether this record should be considered deleted. Data deleted at source has non-key columns set to null while primary keys are retained.
branch_identifier	varchar	Branch identifier assigned by head office for data exchange workflows.
pharmacy_name	varchar	Name of the pharmacy.
attendance_date	date	The date when the attendance log entry was recorded.
pharmacist_registration_number	varchar	The pharmacist’s registration number.
pharmacist_name	varchar	Concatenated pharmacist forename and surname.
psc_time_signed_in	varchar	User-editable time when the pharmacist signed in.
system_time_signed_in	varchar	System-recorded time when the pharmacist signed in.
psc_time_signed_out	varchar	User-editable time when the pharmacist signed out.
system_time_signed_out	varchar	System-recorded time when the pharmacist signed out.
national_practice_code	varchar	Pharmacy NacsCode used to identify the pharmacy when the user logs in.
row_id	varchar	Unique hash generated based on column values, used to identify data changes.
last_updated_date	date	Date that this record was last updated by the orchestration process.