Schema

Column Name	Data Type	Description
attendance_register_id	integer	Primary key from the attendance register.
leave_register_id	integer	Primary key for the leave 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.
psc_sign_out_time	varchar	User-editable leave sign-out time.
system_sign_out_time	varchar	System-recorded leave sign-out time.
psc_sign_in_time	varchar	User-editable leave sign-in time.
actual_sign_in_time	varchar	System-recorded leave sign-in time.
destination	varchar	Destination recorded during leave period.
reason_for_leaving	varchar	Reason provided for taking leave.
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.