WO2001063377A2 - Internet accessible database with telephone entry capability - Google Patents
Internet accessible database with telephone entry capability Download PDFInfo
- Publication number
- WO2001063377A2 WO2001063377A2 PCT/US2001/040186 US0140186W WO0163377A2 WO 2001063377 A2 WO2001063377 A2 WO 2001063377A2 US 0140186 W US0140186 W US 0140186W WO 0163377 A2 WO0163377 A2 WO 0163377A2
- Authority
- WO
- WIPO (PCT)
- Prior art keywords
- employee
- data
- storage system
- data storage
- module
- Prior art date
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04M—TELEPHONIC COMMUNICATION
- H04M3/00—Automatic or semi-automatic exchanges
- H04M3/42—Systems providing special services or facilities to subscribers
- H04M3/487—Arrangements for providing information services, e.g. recorded voice services or time announcements
- H04M3/493—Interactive information services, e.g. directory enquiries ; Arrangements therefor, e.g. interactive voice response [IVR] systems or voice portals
- H04M3/4938—Interactive information services, e.g. directory enquiries ; Arrangements therefor, e.g. interactive voice response [IVR] systems or voice portals comprising a voice browser which renders and interprets, e.g. VoiceXML
Definitions
- the present invention relates generally to an internet access database with telephone entry capability. More specifically, the present invention relates to a system and method for storing and manipulating data received from a remotely located employee in an internet accessible database.
- cleaning services provide employees that travel to various remote locations to clean a home or business, etc.
- repair services and installation services provide employees which travel to various locations to repair previously installed products, such as appliances, or install new products, respectively.
- a building company or building contractor provides employees that travel to various locations to construct all or a portion of a building, such as a home or a work facility.
- the present invention provides a system and method for manipulating data relating to an employee of a business.
- the system and method includes an internet accessible database having telephone entry capabilities.
- the method of the present invention further includes accessing a data storage system through use of a telephone via a first connection, which can be a telephone line connection and/or an internet connection. Data is provided to the data storage system regarding a remotely located employee via the first connection.
- specific data relating to the identity of the employee, the location from which the employee is accessing the data storage system, and the exact time and data the employee accessed the data storage system is provided to the data storage system.
- the data storage system can also be accessed through use of a computer via a second connection, which can be a local area network (LAN) connection and/or an internet connection.
- the data provided via the first connection can be monitored and manipulated via the second connection.
- the provided data can be exported to a spreadsheet and further manipulated, forwarded to a printer, or used for billing or payroll purposes.
- a data collecting device and method for collecting and manipulating various data relating to at least one employee of a business located at a remote location from the data collector includes an employee location identifier for identifying a location of an employee based upon a telephone number from which the employee is calling into the device via a telephone line and/or an internet connection.
- An employee identifier identifies the employee calling into the data collector.
- a real time identifier identifies the time at which the device receives the telephone communication from the employee.
- An event identifier identifies the event represented by the telephone communication from the employee.
- An elapsed time identifier calculates a time period that the employee is located at the remote location.
- a storage module stores information relating to the identification of the employee, the location of the employee, and the time period which the employee is located at the remote location.
- a system for receiving and manipulating data relating to at least one employee of a business includes an operator module for entering and storing data relating to the identification of an employee.
- the system also includes a password module for changing a password associated with an employee and a user module for displaying all time spent by an employee at a location relating to at least one job during a specified time period.
- the system further includes a caller identification module which displays all telephone numbers from which the employee has called into the system and a billing module which displays an itemized list of all time spent by the employee at all locations during a specific time period.
- the system further includes an events module for displaying an itemized list of each time at least one employee accesses the system to begin or end a job.
- the system still further includes a clear module for clearing information from the system and a log out module for exiting the system.
- Figure 1 is a block diagram illustrating an embodiment of the present invention.
- Figure 2 is a block diagram illustrating an alternate embodiment of the present invention.
- Figure 3 is a flow chart illustrating a method of the present invention.
- Figure 4 is a block diagram illustrating various options of the present invention.
- Figure 5-19 are various computer-generated screens which are generated via a computer portraying various aspects of the present invention.
- the present invention is a system and method for storing and manipulating data relating to an employee of a business.
- the system and method includes an internet accessible database having telephone entry capabilities.
- FIG. 1 is a block diagram illustrating system 50 incorporating the present invention.
- System 50 includes telephone 52, computer 54, data storage system 56, printer 58, payroll system 60, and billing system 62.
- System 50 is a telephone line and network-based application which permits a company to keep track of various employees' time as they perform jobs for clients at locations remote from a central location.
- System 50 also provides information about the activities, locations, and productivity of a workforce of a company.
- System 50 utilizes regular various known communication lines, such as telephone lines; therefore, system 50 is economical and easy to use.
- System 50 accomplishes several tasks and provides many benefits to its users.
- a telephone call by employee 64 from telephone 52 permits employee 64 to clock in and clock out of data storage system 56 from jobs or projects that they are working on, regardless of their locations.
- Data storage system 56 stores various data relating to the identity of employee 64 and the location of employee 64.
- Employee 64 is connected to data storage system 56 via telephone 52 and connection 68.
- connection 68 is a standard telephone line connection.
- Information relating to the identification of employee 64, the location of employee 64, and the specific time of the communication between employee 64 and data storage system 56 are automatically captured by data storage system 56, as will be later described in detail.
- employee 64 can transmit voice messages to data storage system 56 and/or retrieve a voice message from data storage system 56.
- connection 70 between computer 54 and data storage system 56 is a local area network (LAN) connection.
- connection 70 can be a network connection which includes an internet connection.
- employee 66 can review and/or manipulate various data within data storage system 56. For example, employee 66 may forward various data from data storage system 56 to printer 58, payroll system 60, and billing system 62.
- the desired data is formatted into a spread sheet program, such as the Microsoft Excel program, prior to forwarding the data to its final destination.
- the data or information can be printed out via printer 58, used to assist in the calculation of the salary of employee 64 via payroll system 60, and/or used to assist in the billing of a client for work completed by employee 64 via billing system 62. Desired information is forwarded to printer 58, payroll system 60, and billing system 62 via connections 72, 74, and 76, respectively. Connections 72, 74, and 76, similar to connection 70, represent connections within a LAN system or a network connection which includes an internet connection.
- Figure 2 is a block diagram illustrating another embodiment of the present invention.
- Figure 2 shows system 90, which is similar to system 50 of Figure 1. Similar components and features of systems 50 and 90 have been labeled as such.
- System 90 of Figure 2 differs from system 50 of Figure 1 in that remotely located employee 64 accesses data storage system 56 via data communication device 91, satellite system 92, and connections 94 and 96.
- Data communication device 91 represents various communication devices such as a telephone, a computer, or a microprocessor.
- connection 68 of Figure 1 represents a standard telephone line connection
- connections 94 and 96 each represent a data communication connection, such as a telephone line connection, an internet connection, a local area network connection, a satellite connection, a broadband cable connection, an etheraet connection, a video connection, a global positioning system (GPS)connection, and/or any combination thereof.
- Satellite system 92 represents any type of system which facilitates connection the aforementioned between telephone 52 and data storage system 56. Therefore, employee 64 may transmit data to data storage system 56 via a keypad of a telephone or computer, or may transmit visual data, such as a finger print data or a photograph to data storage system 56. In one preferred embodiment, employee 64 is only required to dial a local (non-long distance) telephone number.
- employee 64 can transmit a data communication to data storage system 56 and/or retrieve a data communication from data storage system 56.
- the data communication is a voice mail communication.
- FIG 3 is a flow chart which describes the method of which an employee, such as employee 64 shown in Figures 1 and 2, utilizes systems 50 or 90 from a location remote from data storage system 56.
- employee 64 accesses data storage system 56 via telephone line connection 68 or combined data communication connections 94 and 96.
- the specific location of employee 64 is provided to data storage system 56 via a caller identification system or a global positioning system (GPS) connected to data storage system 56.
- the caller identification system provides the name of an individual or business to which the telephone number from which employee 64 is calling is assigned. Caller identification systems have become standard devices known in the art which provide information regarding an incoming telephone call.
- the information can include the telephone number at the location of an incoming call, the identification of the person or business associated with the telephone number, and the time and date of the incoming call.
- a global positioning system GPS
- the global positioning system permits employee 66 to maintain an accurate account of the location of employees, such as employee 64.
- a specific time of the telephone call initiated by employee 64 via telephone 52 to data storage system 56 is provided to data storage system 56 by the caller identification system.
- an identifying characteristic of employee 64 is provided to data storage system 56.
- employee 64 inputs a personal identification number (PIN) via the keypad of telephone 52 which uniquely identifies employee 64.
- PIN personal identification number
- a customer identification code is provided to data storage system 56.
- employee 64 enters a series of numbers via the keypad of telephone 52 which uniquely identifies the customer or project which employee 64 is performing. It is necessary to manually enter the customer number since several telephone numbers may be assigned to a single business. Depending on the businesses telephone set-up, a caller identification system may or may not properly identify the business.
- data storage system 56 can be programmed such that system 56 will group several numbers associated with a single business. Thus, data storage system 56 will recognize various telephone numbers and associate those numbers with a single business.
- step 110 the data described with reference to steps 102-108 is stored within data storage system 56. If employee 64 is not presently clocked in to data storage system 56 as activity working on a job or project, data storage system 56 automatically indicates a clocked in mode. Conversely, if employee 64 is already clocked in to data storage system 56, data storage system 56 automatically clocks out employee 64.
- Figure 4 is a block diagram illustrating various modules associated with systems 50 and 90 shown in Figures 1 and 2. All modules shown in Figure 4 are part of data storage system 56 and can be accessed via computer 54.
- Employee 66 first logs in to system 50 or 90 via computer 54.
- Computer 54 displays a screen (later described) which requests information from employee 66 to log in to data storage system 56 (login module 122).
- Employee 66 provides a customer number representing the company for which employee 66 is employed, an operator identification code which uniquely identifies operator 66 to data storage system 56, and a password unique to operator 66.
- employee 66 is presented with a computer screen which welcomes employee 66 to data storage system 56, identifies employee 66, and provides the date and time at which employee 66 logged in to data storage system 56.
- employee 66 has various options. Particularly, employee 66 can access various modules such as operators module 124, change password module 126, users module 128, caller identification module 130, billing module 132, events module 134, clear module 136, and log out module 138. Modules 124-138 will further be described with reference to Figures 5-19.
- Employee 66 can add operators, update operators, or delete operators by accessing modules 140, 142, and 144 via operators module 124.
- employee 66 can manually clock in or clock out employees, update user information for employees, add new employees, change the status of an employee with respect to administrative rights, and export text to printer 58, payroll system 60, and billing system 62.
- Employee 66 can achieve these tasks by accessing various modules via user's modules 128 such as clocked in/clocked out employees module 146, update user information module 148, add employees module 150, change status 152, and export text module 154, respectively.
- employee 66 via billing module 132, employee 66 can select a specific time period to view data and export data to printer 58, payroll system 60, billing system 62 by accessing select time period module 156 and export text 154, respectively.
- employee 66 can access select time period module 158 via clear module 136.
- Modules 122-158 will further be described with reference to Figures 5- 19.
- Figures 5-19 show various computer-generated screens which employee 66 can access via computer 54.
- Figure 5 is a replica of a computer-generated screen which is displayed on computer 54 prior to logging into data storage system 56, shown in Figures 1 and 2.
- Figure 5 illustrates login screen 160 which represents login module 122 of Figure 4.
- Login screen 160 includes customer input block 162, operator input block 164, password block 166, and login icon 168.
- employee 66 In order for an employee to access data storage system 56 via computer 54, employee 66 must enter a customer identification number, an operator identification number, and a password.
- a customer number is a unique alphanumeric code which identifies the company for which employee 66 is employed.
- An operator number is a unique alphanumeric code which identifies employee 66.
- a password is a unique alphanumeric code which confirms the identity of employee 66.
- the operator number and password codes are case sensitive (i.e., upper and lower case letters).
- employee 66 Once employee 66 enters a customer identification number, an operator identification number, and a password, employee 66 would utilize a mouse or mouse-like device connected to computer 54 to position a cursor on top of login icon 168 and single click on login icon 168, as is well known in the computer field. Completing this process permits employee 66 to access data storage system 56 and the screen shown in Figure 6 is displayed on computer 54.
- FIG. 6 illustrates computer-generated welcome screen 170.
- welcome screen 170 Once employee 66, shown in Figures 1 and 2, properly accesses data storage system 56 via computer 54, welcome screen 170 would appear on computer 54.
- Welcome screen 170 includes customer identification 172, operator identifications 174A and 174B, date 176, time 178, and navigation menu 180.
- Customer identification 172 identifies the company for which operator 174 is employed, while operator identifications 174A and 174B identify the operator logged in to data storage system 56 (i.e. employee 66).
- Date and time 174 and 176 represent the precise date and time which operator 174 logged into data storage system 56.
- Navigation menu 180 is shown on the left side of welcome screen 170. However, it is understood in the art that navigation menu 180 can be positioned at various locations on welcome screen 170 without deviating from the present invention. Navigation menu 180 includes several options which permit employee 66 to access various modules of data storage system 56.
- employee 66 can access operators module 124, change password module 126, users module 128, caller identification module 130, billing module 132, events module 134, clear module 136, or log-out module 138 (modules 124-138 are shown in Figure 4) by moving a cursor on top of operators icon 182, change password icon 184, user icon 186, caller identification 188, billing icon 190, events icon 192, clear icon 194, or log-out icon 196, and single clicking on the mouse associated with the computer 54.
- utilizing a mouse or mouse-like device connected to computer 54 to move a cursor about a screen and click on various icons is known to those in the art. It is also known to single click or double click (depending upon the design of the computer and/or the mouse) the mouse once a cursor is positioned on top of an icon to go a module associated with the icon.
- Figure 7 illustrates computer-generated screen 200, which corresponds to operator's module 124 shown in Figure 4.
- Employee 66 can view screen 200 via computer 54 and determine which employees have administrative rights and which employees do not have administration rights. Administration rights allow an employee to enter and further manipulate information within data storage system 56.
- Employee 66 can gain access to screen 200 by clicking on operators icon 182 of navigation menu 180.
- Screen 200 includes customer identification 172, operator identification 174 A, navigation menu 180, data lines section 202, and add icon 204.
- Figure 8 illustrates computer- generated screen 210 which represents an add operator screen of data storage system 56 shown in systems 50 or 90 and corresponds to add operators module 140 of Figure 4.
- employee 66 clicks on description box 212.
- Employee 66 then enters the name of the operator to be added to the system.
- employee 66 advances to administrative box 214.
- Administration box 214 permits employee 66 to select whether the new operator either has or does not have administration rights.
- Employee 66 clicks on the down arrow button within administrative box 214 and either selects a letter 'Y,' thereby granting full administrative rights to the newly added operator, or selects a letter 'N,' thereby not granting administrative right to the newly added operator.
- An operator with full administrative rights can create other operators (users) within data storage system 56, can view all data within data storage system 56, and can clear data from data storage system 56. Conversely, an operator with no administrative rights cannot change any data in data storage system 56 except for changing their own password.
- employee 66 enters an initial password for this particular operator in password box 216.
- the password is then confirmed in password box 218.
- the password can be alpha numeric and is case sensitive (i.e., upper and lower case letters).
- Figure 9 illustrates computer- generated screen 230 which represents an update operators screen of data storage system 56 shown in system 50 or 90 and corresponds to update operators module 142 of Figure 4. Specific operator information can be changed through screen 230.
- employee 66 positions a mouse associated with computer 54 over the information to be changed and deletes the information. The new information is then typed over the old information.
- employee 66 simply clicks on delete icon 232 and the operator information shown on screen 230 is deleted from data storage system 56. For example, as shown in Figure 9, if delete icon 232 is pressed, all information corresponding to Jane Doe would be deleted from data storage system 56. Only operators having administrative rights can change their password through screen 230. Operators who do not have administrative rights must use computer- generated screen 240 shown in Figure 10.
- Figure 10 illustrates computer-generated screen 240 which represents a change password screen of data storage system 56 shown in systems 50 or 90 and corresponds to change password module 126 of Figure 4.
- An operator without administrative rights can change his/her password via computer- generated screen 240.
- Computer-generated screen 240 is accessed via change password icon 184 of navigation menu 180.
- Computer-generated screen 240 shows various information including customer identification 172, operator identification 174A, operator number 242, description 244, data entry box 246, data entry box 248, and change icon 250.
- Screen 240 allows operators who do not have full administrative rights to change their password. This feature provides increased security in the event that an operator suspects that their password has been compromised.
- employee 66 clicks on data entry box 246 and types in their existing password.
- Employee 66 clicks on data entry box 248 and enters a new password.
- a password can be alpha numeric and case sensitive.
- Figure 11 illustrates computer-generated screen 260 which represents a users screen of data storage system 56 shown in systems 50 or 90 and corresponds to users module 128 of Figure 4.
- Computer-generated screen 260 includes customer identification 172, operator identification 174A, navigation menu 180, clocked in box 262 A, clocked out box 262B, OK icon 262C, user column 264, description column 266, caller identification column 268, caller name column 270, stamp in column 272, elapsed time column 274, estimated time column 276, user identification column 278, billing column 280, change status column 282, data rows 284 and 286, and export icon 288.
- Computer-generated screen 260 represents a user list page of data storage system 56.
- the users are the employees of ABC Corporation who will be in the field performing jobs or tasks for ABC Corporation.
- employee 66 positions a mouse over a specific box and clicks on the mouse, thereby changing the check marker (i.e., from checked to unchecked, or from unchecked to checked).
- employees 66 can click on OK button 262C to view information relating to all users and their current job status. To see only information relating to clocked in employees, employee 66 checks clocked in box 262A and unchecks clocked out box 262B. Conversely, to see only information relating to clocked out employees, employee 66 unchecks clocked in box 262A and checks clocked out box 262B.
- Screen 260 includes various information such as a user (employee) number under user column 264, the name of the user under description column 266, a caller identification of the phone number from which an employee called when they were clocked in under caller identification column 268, and a name of the location from which the employee called under caller name 270.
- Screen 260 also shows the date and time that the employee clocked in under stamped in column 272, the time elapsed since the employee clocked in under elapsed time column 274, an estimated time that the job will take under estimated time column 276, and a user identification number under user identification column 278 which, as previously discussed, uniquely identifies an employee.
- Employee 66 can manipulate the information shown on screen 260 in various ways. First, employee 66 can export the information shown on screen 260 to printer 58 via export icon 288. By clicking on export icon 288, the information shown on screen 260 will be supplied to printer 58 via connection 72 (shown in Figures 1 and 2). Second, employee 66 can access detailed billing information regarding a specific employee by positioning a cursor associated with computer 54 on top of the word "billing" associated with a specific employee and clicking the mouse. Third, employee 66 can clock out an employee which is presently clocked in to data storage system 56 by clicking on the phrase "clock out" under change status column 282 of any employee that is currently clocked in to the system. This feature can be used when an employee clocks in to system 56, but forgets to clock out of system 56 upon completion of ajob.
- Computer-generated screen 290 shown in Figure 12, represents an add user screen of data storage system 56 shown in systems 50 or 90 and corresponds to add employees module 150 of Figure 4.
- Employee 66 accesses screen 290 by clicking on add icon 289, shown in Figure 11.
- Screen 290 permits employee 66 to enter new users or employees into data storage system 56.
- Data storage system 56 automatically assigns the next available numeric user number in user box 292.
- Employee 66 must enter a user identification number in user identification box 294.
- the user identification number must be numeric and long enough to be difficult to randomly duplicate but short enough for the employee to remember.
- the user identification number entered into box 294 is the code which the assigned employee types on the telephone touch pad when he/she calls to check in or check out of data storage system 56.
- the user identification number functions as the personal identification number (PIN) for that employee.
- employee 66 enters the name of the employee in description box 296 and clicks on update icon 298 to update data storage system 56.
- Computer-generated screen 300 shown in Figure 13, represents an update user information screen of data storage system 56 shown in systems 50 and 90 and corresponds to update user information module 148 of Figure 4.
- Screen 300 permits an employee to modify user (employee) information in data storage system 56.
- Employee 66 accesses screen 300 by clicking on the user number associated with an employee on the user page represented by computer- generated screen 260, shown in Figure 11.
- Screen 300 permits employee 66 to modify user (employee) information in the system. Both the user identification code in box 304 and the description code in box 306 can be modified.
- employee 66 highlights and deletes the data to be modified in either user identification box 304 or description box 306 and types in the new data. By clicking on update icon 308, the changes are stored in data storage system 56. To delete the selected user from the system, employee 66 clicks on delete icon 310 and the user (Joe Smith) is removed from data storage system 56.
- Computer-generated screen 320 shown in Figure 14, represents a billing screen of data storage system 56 shown in systems 50 and 90 and corresponds to billing module 132 of Figure 4.
- Screen 320 illustrates various billing information about a particular employee, for example, Jane Doe.
- Computer- generated screen 320 is accessed by clicking on the billing link associated with an employee on the user list page shown in Figure 11 on computer-generated screen 260. By clicking on the billing link associated with a user on computer- generated screen 260, computer-generated screen 320 appears. It is a log of all time spent at each job that a specific employee has performed during a specific time period chosen by employee 66.
- Computer-generated screen 320 is also accessed via billing icon 190 of navigation menu 180.
- Screen 320 includes various information including customer identification 172, operator identification 174A, navigation menu 180, export icon 288, user information 322, starting date 324, ending date 326, okay icon 328, billing column 330, stamp in column 332, stamp out column 334, caller identification column 336, caller name column 338, extra data column 340, lapsed time column 342, information rows 344-352, number of callers 354, and elapsed time 356.
- start date 324 and ending date 326 are provided via pull-down menus.
- This feature gives data storage system 56 the benefit of flexibility in calculating hours worked by an employee without having to clear other historical data not in the selected time frame.
- data storage system 56 eliminates any extra job data that may have been collected prior to or after the desired pay period.
- the data shown in computer-generated screen 320 is easily exported to a spreadsheet, such as an Excel spreadsheet, for manipulation, tabulation of hours, or payroll calculations, through use of export icon 288.
- Number of calls 354 indicates the total number of jobs performed during a specified time period
- elapsed time 356 indicates the total amount of time spent on all jobs during the specified time period.
- Extra data column 340 can be used to input additional information about a particular job.
- a billing rate of an employee may be entered under extra data column 340.
- the estimated time for which the time should take to complete may be entered and displayed under extra data column 340.
- Computer-generated screen 360 shown in Figure 15, represents a caller identification screen of data storage system 56 shown in systems 50 or 90 and corresponds to caller identification module 130 of Figure 4.
- Screen 360 provides a list of all caller identifications that data storage system 56 has collected.
- Screen 360 includes various information including customer identification 172, operator identification 174 A, navigation menu 180, clocked in box 262 A, clocked out box 262B, OK icon 262C, caller identification column 362, caller name column 364, user column 366, stamped in column 368, elapsed time column 370, billing column 372, change status column 374, and data information rows 376-386.
- Screen 360 can be accessed by clicking on caller identification icon 188 of navigation menu 180.
- the various caller identifications and names of the locations from which employees (users) will be calling from must be initially entered into data storage system 56. Data storage system 56 will then reject any calls made from caller identification locations which have not been entered into the system. In another preferred embodiment, where the various caller identification information has not been initially entered into data storage system 56, data storage system 56 will collect caller identification information and add this information to data storage system 56 automatically. However, data storage system 56 will not have the ability to recognize an incoming call from an invalid location.
- various information is stored in data storage system 56. Examples of stored information include a phone number from which employee 64 is calling is stored under caller identification column 362. The name of the company from which employee 64 is calling is stored under caller name column 364.
- Screen 360 also includes a stamped in time under stamped in column 368 which indicates the date and precise time when an employee calls in to data storage system 56 at the start of a job.
- Screen 360 also includes an elapsed time under elapsed time column 370 which indicates the amount of time an employee has been clocked into data storage system 56. If an employee initially calls into data storage system 56 at the start of a job and. then calls in a second time at the completion of the job, no information will be shown under columns 366, 368, 370, and 374.
- Change status column 374 permits employee 66 to manually clock out another employee, such as Jane Doe in Figure 15. This clock out feature would be used in situations where it appears that an employee had clocked into data storage system 56 at the beginning of a job, but failed to clock out of data storage system 56 at the end of the job.
- Billing column 372, shown in Figure 15, enables employee 66 to see the exact time billed at each caller identification location. This can be done by clicking on the word "billing" icon in the row associated with the location which it is desired to see the exact time billed. By clicking on the billing link of a particular row, computer-generated screen 390, shown in Figure 16 will be displayed on computer 54.
- Screen 390 displays a list of all jobs performed at a particular caller identification location.
- Screen 390 shows the billing sequence number under column 330, the time the employee called to clock into data storage system 56 under stamp in column 332, and the time the employee called to clock out of the data storage system 56 under stamp out column 334.
- Screen 390 also includes the name and employee number of the user (employee) who performed the job under user column 394, the company name at which the job was performed under caller name column 338, and the time spent on the job under elapsed time column 342.
- extra data column 340 can be used to input additional information about a particular job.
- a billing rate of an employee may be entered under extra data column 340.
- extra data column 340 may include a specific code indication a data communication, such as a voice mail message, stored in data storage system 56 from either employee 64 or employee 66. The data communication can then be retrieved from data storage system 56.
- the data communication could include, for example, an indication as to where an employee should proceed upon completion of a current job or that a particular job is taking longer to complete than expected.
- Computer-generated screen 390 permits employee 66 to easily tabulate the number of visits to each location and the time spent at a location for billing purposes.
- employee 66 clicks on export icon 288 to forward the data in rows 395 and 397 to a spreadsheet as previously discussed.
- the information is easily then manipulated.
- the information can also be transported to printer 58, payroll system 60, or billing system 62, as shown in Figures 1 and 2.
- Computer-generated screen 400 shown in Figure 17, represents a billing screen of data storage system 56 shown in systems 50 and 90 and corresponds to billing module 132 of Figure 4.
- Screen 400 can be accessed by clicking on billing icon 190 of navigation menu 180.
- Screen 400 is a log of all time spent on all completed jobs by all employees (users) during a specific time period.
- start date box 324 and end date box 326 include a pull down menu for a user to set the "from date" and the "to date" of the desired information.
- Screen 400 further includes billing column 330, stamp in column 332, stamp out column 334, user column 394, caller ID column 336, caller name column 338, extra data column 340, elapsed time column 342, information rows 402-408, number of calls 410, elapsed time 412, and export icon 288.
- the billing feature shown on screen 400 provides a user the benefit of reviewing total hours worked by all employees during a specified time period without having to clear historical data at time periods other than the specified time period. Therefore, the number of hours worked by all employees in a specified time period can be analyzed for a specific company.
- the data shown in screen 400 can be exported to a spread sheet within data storage system 56, or can be exported to printer 58, payroll system 60, or billing system 62 for further analysis and manipulation via export icon 288.
- the total number of calls made during the specified time period represented by numeric 410, as well as the total hours worked on jobs during the specified time period, as represented by numeric 412.
- Computer-generated screen 420 shown in Figure 18, represents an events screen of data storage system 56 shown in systems 50 and 90 and corresponds to events module 134 of Figure 4.
- Screen 420 can be accessed by clicking on events icon 192 of navigation menu 180.
- Screen 420 shows various information including customer identification 172, operator identification 174, navigation menu 180, export icon 288, start date 352, end date 354, start date boxes 324, end date boxes 326, okay icon 328, stamped column 372, user column 394, location column 422, extra data column 340, caller name column 338, caller identification column 336, user identification column 424, and data communication columns 426-442.
- Screen 420 provides a list of all checked in and checked out activity for all employees of a specified company for a specific date range.
- Screen 420 provides all information pertaining to employee activity on a real time basis. Screen 420 ensures that employees (users) are using the system properly and consistently.
- the information on screen 420 provides the time a call was made, the user who made the call, a location code from where the call was made, any extra data specific to the company being evaluated, the location from where the call was made, the phone number from which the call was made, and a user identification of the employee who made the call.
- the specific range of dates can be chosen utilizing starting date boxes 324 and ending date boxes 326.
- a location code which would be listed under location column 422, can be used to specify a location where an employee is working where a business has multiple caller identifications corresponding to multiple internal telephones. However, a single company is to be billed for all jobs performed at specified locations.
- Extra data information which can be entered under extra data column 340 can be specific codes for a specific customer. For example, extra data could include a work order number used to assign a specific job.
- Computer-generated screen 450 shown in Figure 19, represents a clear data screen of data storage system 56 shown in systems 50 and 90 and corresponds to clear module 136 of Figure 4. This screen can be accessed via clear icon 194 of navigation menu 180, and permits removal of event and billing information for selected date ranges.
- computer- generated screen 450 can be used to clear unwanted information from data storage system 56.
- Screen 450 includes various information including customer identification 172, operator identification 174B, navigation menu 180, starting date boxes 452, ending date boxes 454, billing boxes 456, events box 458, and okay icon 460.
- To clear event data click on the event box 458 and a check mark will appear in the box.
- To clear the check box click on event box 458 again and the check mark will disappear.
- event box 458 is checked, the specific starting and ending dates of event information to be cleared can be entered via starting date boxes 452 and ending date boxes 454. Clicking on okay icon 460 will clear the specified information from data storage system 56. This process can be repeated with respect to billing check box 456.
- data storage system 56 includes graphical mapping capabilities such that the location of various employees, such as employee 64, can be mapped on a single screen of computer 54. This technology aids in dispatching employees to further jobs base upon their current locations.
- the present invention is a system and method for storing and manipulating data relating to an employer of a business.
- the system and method includes an internet accessible database having telephone entry capabilities. More particularly, a method of collecting and monitoring data relating to an employee of a business at a remote location is disclosed. The method includes accessing a data storage system via a first connection through use of a telephone line. Data is provided to the data storage system regarding an employee located remote from the data storage system via the first connection. The data storage system can also be accessed via a second connection through use of a computer. The provided data can be monitored and manipulated via the second connection.
- the present invention also includes a data collecting device for collecting and manipulating various data relating to an employee of a business located at a remote location from the data collecting device.
- the data collecting device includes an employee location identifier for identifying a location of an employee based upon a telephone number from which the employee is calling into the data collecting device via a telephone line and an employee identifier for identifying the employee calling into the data collecting device.
- the data collecting device further includes a real time identifier for identifying the time at which the data collecting device receives a telephone communication from the employee and an event identifier for identifying the event represented by the telephone communication from the employee.
- the data collecting device includes an elapsed time identifier for calculating a time period which the employee is located at the remote location and a storage module for storing information relating to the identification of the employee, the location of the employee, and a time period which the employee is located at the remote location.
- the present invention includes a method of collecting and manipulating data relating to an employee at a remote location.
- the method includes identifying a location of an employee based upon a telephone number from which the employee is communicating and identifying the identity of the employee.
- the method further includes identifying a time of a telephone communication and identifying an event represented by a telephone communication.
- the method further includes calculating a time period which the employee is located at the remote location.
- the method still further includes storing information relating to the identification of the employee, the location of the employee, and a time period which the employee is located the remote location.
Abstract
Description
Claims
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
AU2001250006A AU2001250006A1 (en) | 2000-02-25 | 2001-02-26 | Internet accessible database with telephone entry capability |
Applications Claiming Priority (2)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US51300600A | 2000-02-25 | 2000-02-25 | |
US09/513,006 | 2000-02-25 |
Publications (2)
Publication Number | Publication Date |
---|---|
WO2001063377A2 true WO2001063377A2 (en) | 2001-08-30 |
WO2001063377A3 WO2001063377A3 (en) | 2002-05-30 |
Family
ID=24041530
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
PCT/US2001/040186 WO2001063377A2 (en) | 2000-02-25 | 2001-02-26 | Internet accessible database with telephone entry capability |
Country Status (2)
Country | Link |
---|---|
AU (1) | AU2001250006A1 (en) |
WO (1) | WO2001063377A2 (en) |
Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US5974443A (en) * | 1997-09-26 | 1999-10-26 | Intervoice Limited Partnership | Combined internet and data access system |
US5974417A (en) * | 1996-01-18 | 1999-10-26 | Sun Microsystems, Inc. | Database network connectivity product |
US5978806A (en) * | 1997-02-18 | 1999-11-02 | Ameritech Corporation | Method and apparatus for communicating information about a called party to a calling party |
-
2001
- 2001-02-26 AU AU2001250006A patent/AU2001250006A1/en not_active Abandoned
- 2001-02-26 WO PCT/US2001/040186 patent/WO2001063377A2/en active Application Filing
Patent Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US5974417A (en) * | 1996-01-18 | 1999-10-26 | Sun Microsystems, Inc. | Database network connectivity product |
US5978806A (en) * | 1997-02-18 | 1999-11-02 | Ameritech Corporation | Method and apparatus for communicating information about a called party to a calling party |
US5974443A (en) * | 1997-09-26 | 1999-10-26 | Intervoice Limited Partnership | Combined internet and data access system |
Also Published As
Publication number | Publication date |
---|---|
AU2001250006A1 (en) | 2001-09-03 |
WO2001063377A3 (en) | 2002-05-30 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US11087266B2 (en) | Asset data updating | |
US20070094109A1 (en) | Time and attendance method and system | |
US7499869B2 (en) | System and method for scheduling employee shifts | |
US7333939B1 (en) | Method for providing web-based insurance data processing services to users | |
US7640165B2 (en) | Web based methods and systems for managing compliance assurance information | |
US7289794B2 (en) | Mobile collection application | |
US6604084B1 (en) | System and method for generating an evaluation in a performance evaluation system | |
US20020111887A1 (en) | Employee online activity monitoring system | |
US20050021428A1 (en) | Time management system for mobile employees | |
US20040019542A1 (en) | Timesheet reporting and extraction system and method | |
US7028178B2 (en) | Scheduling system and method including creating and/or changing a scheduling system by an administrator and making appointments employing the schedule conducted through a global computer network | |
US20020077998A1 (en) | Web based system and method for managing sales deals | |
WO2001035679A2 (en) | Method and system for tracking equipment usage information | |
US20050209901A1 (en) | System and method for engineering project tracking | |
JPH07110831A (en) | Strict observance system of schedule | |
US20060080116A1 (en) | Web-based employee onboarding management and tracking software | |
US6941475B1 (en) | System and method for efficient processing of service requests | |
CA2335210C (en) | Answer system for technical support, and technical support method | |
JP2000268100A (en) | Employment dispatch management system and recording medium therefor | |
JP2003030394A (en) | Attending/leaving management system | |
JP2004272774A (en) | Personnel management system | |
JP2002352044A (en) | Server system for management of data for general affairs, personal affairs, and labor | |
WO2001063377A2 (en) | Internet accessible database with telephone entry capability | |
JP3694250B2 (en) | Temporary employee work status management system, work status management method, program | |
JP4512675B2 (en) | Human resource management system |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
AK | Designated states |
Kind code of ref document: A2 Designated state(s): AE AG AL AM AT AU AZ BA BB BG BR BY BZ CA CH CN CR CU CZ DE DK DM DZ EE ES FI GB GD GE GH GM HR HU ID IL IN IS JP KE KG KP KR KZ LC LK LR LS LT LU LV MA MD MG MK MN MW MX MZ NO NZ PL PT RO RU SD SE SG SI SK SL TJ TM TR TT TZ UA UG UZ VN YU ZA ZW |
|
AL | Designated countries for regional patents |
Kind code of ref document: A2 Designated state(s): GH GM KE LS MW MZ SD SL SZ TZ UG ZW AM AZ BY KG KZ MD RU TJ TM AT BE CH CY DE DK ES FI FR GB GR IE IT LU MC NL PT SE TR BF BJ CF CG CI CM GA GN GW ML MR NE SN TD TG |
|
121 | Ep: the epo has been informed by wipo that ep was designated in this application | ||
DFPE | Request for preliminary examination filed prior to expiration of 19th month from priority date (pct application filed before 20040101) | ||
AK | Designated states |
Kind code of ref document: A3 Designated state(s): AE AG AL AM AT AU AZ BA BB BG BR BY BZ CA CH CN CR CU CZ DE DK DM DZ EE ES FI GB GD GE GH GM HR HU ID IL IN IS JP KE KG KP KR KZ LC LK LR LS LT LU LV MA MD MG MK MN MW MX MZ NO NZ PL PT RO RU SD SE SG SI SK SL TJ TM TR TT TZ UA UG UZ VN YU ZA ZW |
|
AL | Designated countries for regional patents |
Kind code of ref document: A3 Designated state(s): GH GM KE LS MW MZ SD SL SZ TZ UG ZW AM AZ BY KG KZ MD RU TJ TM AT BE CH CY DE DK ES FI FR GB GR IE IT LU MC NL PT SE TR BF BJ CF CG CI CM GA GN GW ML MR NE SN TD TG |
|
REG | Reference to national code |
Ref country code: DE Ref legal event code: 8642 |
|
122 | Ep: pct application non-entry in european phase | ||
NENP | Non-entry into the national phase in: |
Ref country code: JP |