 |
 |
|
|
This view exposes the options set for recording time for the whole practice. The result set of the view is a singleton.
The 'always' columns are maintained in the view to implement a logical primary key for reporting services.
Base view suitable for advanced end users.
Always5 |
Always equal to 5 - included to provide a logical prime key |
AlwaysZero |
Always equal to zero - included to provide a logical prime key |
StandardUnit |
The practice's standard time unit in minutes |
MondayMinutes |
The length of a standard working day in minutes for Monday |
TuesdayMinutes |
The length of a standard working day in minutes for Tuesday |
WednesdayMinutes |
The length of a standard working day in minutes for Wednesday |
ThursdayMinutes |
The length of a standard working day in minutes for Thursday |
FridayMinutes |
The length of a standard working day in minutes for Friday |
SaturdayMinutes |
The length of a standard working day in minutes for Saturday |
SundayMinutes |
The length of a standard working day in minutes for Sunday |
PeriodsPerYear |
Number of periods in one year |