I am working on an employee database (design features are listed below).
We have various training courses that are required 30, 60, 90 days from date of hire.
What I want to do is run 30, 60, 90 day queries or reports that will show me all employees missing the required training for those timeframes.
Not sure how to do this. The training table I have right now has the following fields:
Training ID (autonumber) - primary key
employeeID (to link to the main table/form)
ethics (date/time)
diversity (date/time)
etc (list of course names - all date/time to capture completion date)
If I add a"required by" field to this table do I add it for each course or just one "required by" field for the entire table?
Would I then do a calculation to add 30, 60, 90 days from the hire date? Note the "hire date" field is in a diff table - does that matter?
I also want to run something that will show me: of the total # of current employees, __ (# or %) have completed X course.
Any help you can provide is appreciated.
Thanks
Employee Database Design
CURRENT TABLES/FORMS:
Employee Info:
• Last Name
• First Name
• Blue Sky Job Title
• Hire Date
• People First ID
• Affiliation (State, County, Other)
• City
• Zip
• Div Dir
• Supervisor
Training
• Capture dates for all mandatory DOH training
• Other disaster preparedness training (ICS 200, 300, etc)
Emergency Duty Assignment
• ICS Section
• Primary ED
• Secondary ED
• IMT member (yes/no)
• Reassignment info:
o Exempt/LD
o Comments
Deployment
• Willing to deploy (yes/no)
• Deployment team (spns, epi, etc)
Activation History
• Event name
• Assignment
• State Date
• End Date
• Comments
REPORTS:
• Emergency duty assignments
o By employee name
o By ED
o By ICS section
• Training
o % completed mandatory
• All staff list
• By DD?
• By Supervisor?
o Tickler for 30, 60, 90 day training requirements
o NIMS compliance check (training vs ED assignment)
OTHER:
• Mail merge/labels for bar codes
We have various training courses that are required 30, 60, 90 days from date of hire.
What I want to do is run 30, 60, 90 day queries or reports that will show me all employees missing the required training for those timeframes.
Not sure how to do this. The training table I have right now has the following fields:
Training ID (autonumber) - primary key
employeeID (to link to the main table/form)
ethics (date/time)
diversity (date/time)
etc (list of course names - all date/time to capture completion date)
If I add a"required by" field to this table do I add it for each course or just one "required by" field for the entire table?
Would I then do a calculation to add 30, 60, 90 days from the hire date? Note the "hire date" field is in a diff table - does that matter?
I also want to run something that will show me: of the total # of current employees, __ (# or %) have completed X course.
Any help you can provide is appreciated.
Thanks
Employee Database Design
CURRENT TABLES/FORMS:
Employee Info:
• Last Name
• First Name
• Blue Sky Job Title
• Hire Date
• People First ID
• Affiliation (State, County, Other)
• City
• Zip
• Div Dir
• Supervisor
Training
• Capture dates for all mandatory DOH training
• Other disaster preparedness training (ICS 200, 300, etc)
Emergency Duty Assignment
• ICS Section
• Primary ED
• Secondary ED
• IMT member (yes/no)
• Reassignment info:
o Exempt/LD
o Comments
Deployment
• Willing to deploy (yes/no)
• Deployment team (spns, epi, etc)
Activation History
• Event name
• Assignment
• State Date
• End Date
• Comments
REPORTS:
• Emergency duty assignments
o By employee name
o By ED
o By ICS section
• Training
o % completed mandatory
• All staff list
• By DD?
• By Supervisor?
o Tickler for 30, 60, 90 day training requirements
o NIMS compliance check (training vs ED assignment)
OTHER:
• Mail merge/labels for bar codes
