Overview
This view lists a record for each staff record.
It can be used to specifically list*;-
▪all staff ▪staff currently employed ▪staff by line manager ▪staff be resource group * this list is not exclusive.
Column Definitions
How to use this view
This view can be executed through any third party software you're using to connect to the Timemaster database (i.e. Microsoft Excel**, Microsoft PowerBI**, Microsoft SQL Management Studio etc.) providing it support the use of T-SQL.
It can also be executed directly from within Timemaster - Please refer to Executing SQL Scripts if you're unsure how to execute scripts from within Timemaster.
** These options can be used to create a live feed where the data can be refreshed within the software. Other options will create a static snapshot of the current data.
Click here for example syntax.
Basic Example;-
select
staff_id,
[Staff Name],
Forename,
Surname,
Initials,
Title,
[Job Title],
Email,
Department,
[Department Name],
[Resource Group],
[Resource Group Name],
Grade,
[Grade Name],
[Linemanager Name],
[Linemanager Name2],
[Linemanager Name3],
[Linemanager Name4],
[currently employed],
project_leader
from
vw_staff
This lists all columns in the view. Columns can be removed as necessary. The last column name should not have a comma separator at the end of it.
Other Examples;-
The following are some examples how the data can be manipulated;-
Staff (currently employed)
select
staff_id,
[Staff Name],
Forename,
Surname,
Initials,
Title,
[Job Title],
Email,
Department,
[Department Name],
[Resource Group],
[Resource Group Name],
Grade,
[Grade Name],
[Linemanager Name],
[Linemanager Name2],
[Linemanager Name3],
[Linemanager Name4],
[currently employed],
project_leader
from
vw_staff
where
[currently_employed]='Y'
Staff (for a specific line manager)
select
staff_id,
[Staff Name],
Forename,
Surname,
Initials,
Title,
[Job Title],
Email,
Department,
[Department Name],
[Resource Group],
[Resource Group Name],
Grade,
[Grade Name],
[Linemanager Name],
[Linemanager Name2],
[Linemanager Name3],
[Linemanager Name4],
[currently employed],
project_leader
from
vw_staff
where
[Linemanager Name]='{insert line manager's name here}'
|
|