TECHNICIAN INFORMATION
  There are 4 files containing the technician information:
  1. The TECH file: 1 per tech, id type information
  2. 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.
  3. TECHCALEN: 1 for each week of each year. Contains the hours the associated tech will be available.
  4. 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, …