| TECHNICIAN INFORMATION |
| |
There are 4 files containing the technician information:
- The TECH file: 1 per tech, id type information
- The TECHSKILL: 1 or more per tech. Each entry identifies a skill category that this tech can perform. Services will be assigned a tech skill id. This is used in the prediction of available resources.
- TECHCALEN: 1 for each week of each year. Contains the hours the associated tech will be available.
- TECHRATE: 1 or more for each tech. There may be different charge rates based on the skill level required
|
|
| TECHNICIAN |
1 per technician (user) |
|
|
|
|
loginid |
c |
10 |
|
|
Used for login to system |
|
password |
c |
10 |
|
|
Access password |
|
first |
c |
25 |
|
|
|
|
|
last |
c |
25 |
|
|
|
|
|
seclevel |
n |
1 |
0 |
|
security level |
|
dept |
c |
10 |
|
|
department |
| notes |
|
|
|
|
|
|
|
Logging in with passwords allows tracking specific items for each user. |
|
Seclevel will allow controlled access to various parts of the program |
|
and delete/modify security |
|
|
|
|
|
| |
| TECHSKILL |
multiple per tech, what services (skills)) can they perform |
|
loginid |
c |
10 |
|
|
relates to TECHNICIAN |
|
skill |
c |
10 |
|
|
name of skill |
|
ratelevel |
c |
2 |
|
|
rate level charged for this skill |
| notes |
|
|
|
|
|
|
Used for forecasting. You may have 200 hours available, but we need |
|
to know what the hours can be used for. |
|
|
|
| |
| TECHCALEN |
1 for each week, tracks time available |
|
|
loginid |
c |
10 |
|
|
relates to TECHNICIAN |
|
week |
n |
2 |
|
|
week number (week one is Jan 1) |
|
hours |
n |
5 |
2 |
|
hours available this week |
| notes |
|
|
|
|
|
|
Maintenance screen for this file will allow 'quick' fills, i.e.: one click for |
|
40 hours per week all year. Then you can edit taking out vacation, …. |
|
May also have auto company holiday insertion, vacation, start/end hours |
|
| |
| TECHRATE |
1 to many, minimum of 1 per technician |
|
|
loginid |
c |
10 |
|
|
relates to TECHNICIAN |
|
rate |
n |
7 |
2 |
|
charge rate per hour |
|
ratename |
c |
10 |
|
|
name of rate |
|
ratelevel |
c |
2 |
|
|
skill rate level |
| notes |
|
|
|
|
|
|
Multiple rates can be used for locations that have overtime, double time, … |
|
| |
|
| |
|