Recruiting accession and paperwork management system

• US 20050283499A1
• Filed: 06/09/2005
• Published: 12/22/2005
• Est. Priority Date: 06/17/2004
• Status: Abandoned Application

• Current Assignee: Larry Fowler
• Original Assignee: Larry Fowler
• Inventors: Fowler, Larry
• Application Number:
  US11/148,660
• Publication Number:
  US 20050283499A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06Q 10/10 Office automation; Time management

Abstract

A comprehensive recruiting accession and paperwork management application that provides near real-time leads transfer, one-time data entry capability, command control and reporting capability, seamless paperwork processing and management, and full ODBC compliant communications capability.

Claims

1. An automated method of recruiting accession and paperwork management, comprising the steps of:

a. receiving from a variety of sources lead information about possible recruits;

b. storing and managing said lead information in a networked database system;

c. making said lead information available to recruiters to facilitate contacting the recruits; and

,

d. synchronizing said networked database system for uniformity of said lead information thereacross.

23. The method of claim 1, further comprising the step of providing forms that serve as a data portal, wherein data from each said form is entered and saved into said networked database system, and is made available to automatically populate other forms that may require the same data;

thereby, providing one-time data entry.

24. The method of claim 1, further comprising the step of delivering a variety of predefined reports to command staff and marketing and fulfillment personnel via a central website, wherein said predefined reports comprise information selected from the group consisting of marketing effectiveness, recruiting applicant demographics, recruiter efficiency, lead disposition, media effectiveness, number of leads converted to accessions, number of recruits enlisted from requested demographic profiles, frequency of implementation of said step d., and combinations thereof.

2. The method of claim 2, wherein said step a. comprises capturing national lead data and storing said national lead data in a master database of said networked database system.

3. The method of claim 2, wherein said step a. comprises entering local lead data into a local database of said networked database system.

4. The method of claim 3, wherein said step b. further comprises the step of assigning a unique identifier to each piece of said lead information stored in said networked database system.

5. The method of claim 4, wherein said step b. further comprises the step of evaluating said national lead data to determine an appropriate recruiting office in which to assign said national lead data for follow-up.

6. The method of claim 5, wherein said step b. further comprises the step of extracting zip code information from said national lead data and comparing said zip code information against a zip code table, said zip code table corresponding to a recruiting office, and assigning said national lead data to a recruiting office that corresponds with said zip code.

7. The method of claim 6, wherein said step b. further comprises the step of screening all said lead information against a matrix of minimum enlistment standards prior to said step c.

8. The method of claim 6, further comprising the step of providing said national lead data to a recruiter-in-charge of a respective receiving office through a central website, wherein said national lead data is presented in chronological order based on date of receipt within said master database.

9. The method of claim 8, further comprising the step of tasking the recruiter-in-charge with assigning said national lead data to subordinate recruiters via a manual assignment process or an automated assignment process.

10. The method of claim 9, wherein said manual assignment process comprises the step of providing said national lead information to a subordinate recruiter for access through said central website, or through an offline program following implementation of said step d.

11. The method of claim 10, wherein said automated assignment process comprises the step of predetermining and setting assignment of specific national lead data to a specific subordinate recruiter based on specific criteria.

12. The method of claim 11, further comprising the step of automatic report generation or downloading of said national lead data assigned to each subordinate recruiter.

13. The method of claim 12, further comprising the step of gathering the final disposition, value and relevance of said national lead data, and reporting same to recruiting command at every step of said method, thereby “

closing the loop”

of data flow.

14. The method of claim 13, wherein said step d. further comprises the step of comparing said national database with said local database and bringing said lead information thereof into alignment.

15. The method of claim 14, further comprising the step of comparing said unique identifiers of said lead information and adding said lead information from either said national database or said local database to either said local database or said national database, respectively, to ensure uniformity of said lead information thereacross.

16. The method of claim 15, further comprising the step of comparing last-updated and last-sync date-times between said master and said local databases, and giving precedence to any said lead information having a younger or more recent date-time than that stored within said databases.

17. The method of claim 16, wherein said step d. further comprises the step of updating code, forms, and database structures with current versions of same.

18. The method of claim 13, further comprising the step of modifying and comparing database structures of said local and said master databases to bring said local database into alignment, structurally, with said master database.

19. The method of claim 18, wherein said step of modifying and comparing database structures is performed at the beginning of every synchronization of said step d. to ensure that subsequent steps will not be interrupted due to database misalignment.

20. The method of claim 13, further comprising the step of assigning a temporary unique identifier to local lead data on said local database so that said lead information within said master and said local databases can be tracked.

21. The method of claim 20, further comprising the step identifying said local lead data on said local database that comprises said temporary unique identifier, and overwriting said temporary unique identifier with a permanent unique identifier assigned by said master database, and thereafter, updating said databases.

22. The method of claim 13, further comprising the step comparing Social Security Account Numbers of the possible recruits of said lead information to eliminate duplicate entries and identify possible recruits that may have been rejected by another office and are now attempting entry through another.

25. An automated method of recruiting accession and paperwork management, comprising the steps of:

synchronizing lead data of a master database with lead data of a local database.

26. The method of claim 25, further comprising the step of performing a total database structure check to determine if a specific script must be run on said local database to modify said master database.

27. The method of claim 26, further comprising the step of automatically launching scripts to bring said local database into alignment, structurally, with said master database.

28. The method of claim 25, further comprising the step of performing a tables check to ensure that all tables of said master database also exist on said local database, wherein if a table is not found on said local database, a script runs to add same.

29. The method of claim 25, further comprising the step of performing a files check by comparing documents within said local database directly with a files table within said master database, and adding files that are listed in said files table, but not in a documents directory of said local database, to said local database.

30. The method of claim 25, further comprising the step of transferring said lead data from said master database to said local database based upon comparison and matching of unique identifiers associated with said lead data with unique identifiers of a recruiter;

thereby, enabling the recruiter to access said lead data from said master database through said local database.

31. The method of claim 30, further comprising the step of comparing last-updated and last-sync date-times between said master and said local databases, and giving precedence to any said lead data of either said master or said local databases having a younger or more recent date-time than that stored within said databases;

thus, ensuring that both said databases contain identical data.

32. The method of claim 25, further comprising the step of assigning a temporary unique identifier to said lead data on said local database so that said lead data within said master and said local databases can be tracked.

33. The method of claim 32, further comprising the step identifying said lead data on said local database that comprises said temporary unique identifier, and overwriting said temporary unique identifier with a permanent unique identifier assigned by said master database, and thereafter, updating said databases.

34. The method of claim 25, further comprising the step of assigning said lead data of either said master or local databases to a first party for follow-up.

35. The method of claim 34, further comprising the step of transferring said lead data of either said master or local databases from the first party to a second party and, thereafter, synchronizing said databases to reflect reassignment of said lead data to the second party.

36. The method of claim 25, further comprising the step of comparing Social Security Account Numbers of possible recruits of said lead data of either said master or local databases to eliminate duplicate entries and identify possible recruits that may have been rejected by another office and are now attempting entry through another.

37. An automated system of recruiting accession, comprising:

a master database receiving national leads;

a local database receiving local leads; and

,

a synchronization process for establishing uniformity of said national leads and said local leads across said master database and said local database.