 |
 |
|
|
This view exposes the rows in the database table that represent practice staff members.
Base view suitable for advanced end users.
InternalId |
The internal identifier of the staff object |
VisibleId |
The user visible identifier of the staff object |
NoLongerEmployed |
Y if the staff member is no longer employed |
IsBlocked |
Y if the staff member is blocked from having further time posted |
Type |
R = regular practice hours, P = part time, C = casual |
StartDate |
Date started |
Title |
Title (Mr, Mrs etc) |
Initials |
Initials |
FirstName |
First name |
Surname |
Surname |
StaffName |
'Civilised' staff name as a single string |
MondayMinutes |
For part time staff only - the normal working day for Monday - in minutes |
TuesdayMinutes |
For part time staff only - the normal working day for Tuesday - in minutes |
WednesdayMinutes |
For part time staff only - the normal working day for Wednesday - in minutes |
ThursdayMinutes |
For part time staff only - the normal working day for Thursday - in minutes |
FridayMinutes |
For part time staff only - the normal working day for Friday - in minutes |
SaturdayMinutes |
For part time staff only - the normal working day for Saturday - in minutes |
SundayMinutes |
For part time staff only - the normal working day for Sunday - in minutes |
This view is directly inherited by the following views: