Database Applications

An IDACS representative will meet with you to discuss how a database application can meet your needs. We have a number of applications that have already been designed; each can be tailored to your organization and its requirements. They range from simple, stand-alone applications, to sophisticated, referential applications. Below is a list of ready to deploy applications. Any of these can be tailored to meet your specific needs. If you need something other than what is listed here, contact us today to discuss your needs.

Contacts

This application manages all of the company's contacts, whether a vendor, sales person, customer, or other:

Quickly and easily recall by various means, information about any contact
Make phone calls or send emails directly from the Contact's Detail Form
Print an address and/or or phone book, of all contacts, or filtered to contain only those contact you choose

Addresses

This application contains addresses and associated information. This application is dependant on the Contacts database application. , such as:

Latitude and Longitude
The name (and any alias names) of the business at that address
The name of the person(s) residing at that address
Any hazards associated with that address
Any special needs of persons living at that address
Alarm company information
Contact information for person responsible for that address
The ability to print filtered reports: All addresses in a city; Addresses on a particular street; Addresses associated with a certain individual; Addresses that have special needs or hazards; And many others.

Perfect solution for any business, organization or government entity.

Employees

This application manages all forms of employee records, to include:

Hire and separation dates
Employee ID numbers, email addresses, passwords, phone numbers, addresses, access levels, etc.
Certain health records that are not HIPPA regulated
Person(s) to be notified in case of emergency
Chronological record of personnel actions, i.e. promotions, demotions, discipline, etc.
Print identification cards
This application is a required prerequisite for certain other applications
And many other features

Payroll Records

This application keeps track of employee time records. This application is dependant on the Employees database application. Features include:

Dates and hours worked, and appropriate code, i.e. Regular Hours, Overtime Hours, Compensatory Hours, Sick Leave, Vacation Leave, FMLA Leave, and Volunteer Hours (when applicable)
Application prints time sheet to sign and submit
Ability to query a single employee or group of employees by date, payroll code, etc.
And many other features

Training Records

Let's be honest; in today's litigious society, keep good records of training is critical to defend against certain allegations. This application manages all aspects of training for your organization, business or government unit. This application is dependant on the Employee database application. Features include:

Keeps track of every course an employee takes outside or within the organization
Keeps track of courses created and taught by the organization
Location, dates, times, and instructors of course taught
Application prints certificates of attendance
Application prints rosters and reports in various form to document training
And many more features

Written Directives System

This application manages all written directives of your company, organization or government unit. This application is dependant on the Employee database application. Features include:

Keep track of the progression of any directive, from draft to final distribution
Make directives available in printed form, or on-line to conserve paper
Keep track of who has received and signed for the directive
Manage amendments with version dates
Archive outdated directives for possible later reference
Application will print an index of all current, or past directives

Oganization Assets

This application keeps track of a company's assets from date of acquisition to date the asset it is removed from inventory. This application is dependant on the Personnel database application. Other features include:

Purchase from
Value new and depreciated value
Asset's current location
Who is it assigned to (if anyone)
Maintenance records (if applicable)

Property and Evidence Management

This application manages all aspects of property / evidence that is taken into the control of the organization or government unit. This application is ideal for small to large law enforcement agenices. This application is dependant on the Employee database application. Features include:

Document the item of property or evidence that has been submitted to the Property / Evidence Unit of the organization, to include who submitted the item, and the date and time it was submitted.
Chain of custody for any individual item or group of items, to include sending the laboratory, checked out for court, returned to owner, etc.
Prepare reports to submit for approval for destruction
Inventory of the property / evidence room, to include where each item is located in the room for easy retrieval

Computer Aided Dispatch (CAD) Systems

This application was primarily designed for small to mid-size law enforcement agencies to manage all aspects of incidents their personnel would respond to or self initiate. This application, however, can easily to modified for non-law enforcement applications, i.e. taxicab companies, couriers, etc. This application is dependant on the Employee and Address database applications. Features include:

Unit Setup Screen: Assign personnel and their radio call sign to a zone, district, or type of unit (traffic, admin, mounted, etc). Show personnel on and off duty. The application keeps track of the officer's hours worked.
Call Taker Form: A Call Taker enters calls received by a call taker, to include caller information, vehicle information, and a description of the incident. Each entry is time-stamped. Addresses can be entered by their unique post office assigned address, or by a common name, i.e. business name.
Dispatch Screen: Once the call is entered, a Dispatcher can assign the call to one or more units by selecting units that are shown as available or "busy but available". All entries are time stamped.
Quickly change unit status
Assign Incident (Case) Numbers
Keep track of vehicles associated with the incident
Mobile Data Terminal (MDT): Personnel can initiate their own calls, as well as added information to exisiting calls.
The following information is available for each address entered: History at that address; Any hazards entered for that address; Alarm information; and Emergency contact information.
Application will produce a number of reports, i.e. All entries made on a particular incident, All activity for a unit, etc.

Incident Reporting

Accurately reporting incidents can help protect your company, organization, or government unit from costly litigation and possible judgements against you. This application allows employees to easily and quickly document incidents that are reportable by your policy. This application is dependent on the Employee database application. Features include:

Easy to navigate entry screens ensuring that all pertinent information about the incident is entered
Drop down "pick lists" aids the employee is selecting the most correct correct choice for that entry field
Provides for supervisory review
Ability to print a hard copy of the report in the field if needed
Application provides for easy analysis and comparisons of reported incidents for any selected period
Search incidents by a multitude of criteria
And many other features

Vehicle Inspections

This application provides a means for a driver or supervisor to document the inspection of his/her vehicle at the time and intervals chosen by the customer. This application is dependant on the Employee database application. Features include:

Keeps track of fuelling and fuel consumption
Flag the vehicle if any inspection item fails
Provide for a supervisor or employee to verify that the failed item has been repaired or replaced