SYSTEM AND METHOD FOR COUNTRY OF ORIGIN COMPLIANCE

• US 20080228822A1
• Filed: 03/03/2008
• Published: 09/18/2008
• Est. Priority Date: 03/02/2007
• Status: Abandoned Application

• Current Assignee: ePlus Incorporated
• Original Assignee: ePlus Incorporated
• Inventors: FRIEL, Ted, JARBOE, Paul, WELCH, Noreen O'hara
• Application Number:
  US12/041,120
• Publication Number:
  US 20080228822A1
• Time in Patent Office: Days
• US Class Current: 707/104.1
• CPC Class Codes: G06Q 10/10 Office automation; Time management

Abstract

A multi-faceted portal and method is provided for the pursuit, capture, maintenance and provisioning of Country of Origin data that confirms a government-contractor'"'"'s compliance with at least one of the Buy Americas Act, the Trade Agreement Acts, and other trade acts as will be determined in the future. The current invention flexibly provides these capabilities and includes at least one of a hosted service and enterprise software licensing agreement that allows at least one of a manufacturer, importer, supplier, distributor or other government contractor, or auditor to manage the Country of Origin information included about products/services it supplies, by providing a self-authoring portal. The portal also trains users and certifies their training.

Claims

1. A Country of Origin portal for user-specific and product/service-specific Country of Origin functionality, comprising:

a database for storage of a plurality of product/service Country of Origin data and a plurality of product/service Country of Origin executable functional data manipulation modules, and a plurality of portal user personality data and a plurality of portal user personality executable functional definition modules,

wherein, each of said plurality of Country of Origin data has a corresponding status; and

at least one computer operatively connected to the database for access thereto and instantiation of at least one user personality by executing at least one of said plurality of personality functional definition modules using at least one of said user personality data, wherein, said instantiated personality is persistently stored in said database for use by a corresponding class of users to access said plurality of product/service Country of Origin executable functional modules to define, store, manipulate and retrieve at least one of said plurality of product/service Country of Origin data as normally accomplished by the corresponding class of users,

wherein, each said product/service comprises a tree structure of at least one component product, each said at least one component product/service being capable of further definition as comprising at least one component product/service thereof in said database until each said at least one component product/service only comprises at least one product/service produced by a single Country of Origin.

2. The portal of claim 1, wherein:

the product/service Country of Origin executable functional data manipulation modules are selected from the group consisting of capture, approval, quality control, storage, maintenance, syndication and report generation of Country of Origin data; and

the user personality is selected from the group consisting of product/service manufacturers, product/service importers, product/service suppliers, product/service distributors, government contactors, and government audit personnel.

3. The portal of claim 2, wherein capture includes:

entry of single Country of Origin data for each said at least one component product/service including component product/service interrelationships and corresponding approval workflow processes for user personalities; and

entry of a graphical image data that incorporates the sequence of and relationships between component products and the corresponding approval workflow processes of user personalities.

4. The portal of claim 2, wherein approval includes routing selected data using a pre-defined approval workflow process to obtain go/no-go ratings from selected user personalities.

5. The portal of claim 2, wherein quality control includes processing the entered data with executable functional data manipulation modules that normalize and rationalize the data to meet at least one pre-defined usability requirement that includes a usability timeframe.

6. The portal of claim 2, wherein storage in the database includes storage of a corrected, approved data in the database for a duration of a pre-defined “

useful life”

thereof, and archival of the corrected, approved data as required to comply with at least one pre-determined government regulation for retention of Country of Origin corrected, approved data.

7. The portal of claim 1, wherein storage in the database includes storage of a corrected, approved data in the database for a duration of the pre-defined “

useful life”

thereof, and archival of the corrected, approved data as required to comply with at least one pre-determined government regulation for retention of Country of Origin corrected, approved data.

8. The portal of claim 3, wherein storage in the database includes storage of a corrected, approved data in the database having a pre-defined “

full-access”

status for a duration of a pre-defined “

useful life”

thereof, and storage of the corrected, approved data having a pre-defined “

archived”

status as required to comply with at least one pre-determined government regulation for retention of Country of Origin corrected, approved data.

9. The portal of claim 2, wherein maintenance includes:

tracking a pre-defined “

useful life”

of data stored in the database and modifying the pre-defined “

useful life”

status to a pre-defined “

expired”

status when a usability date of the “

useful life”

of the stored data has expired; and

initiating a pre-defined data update workflow process to restore stored data having an “

expired”

status to a pre-defined “

full access”

status.

10. The portal of claim 6, wherein maintenance includes:

tracking a pre-defined “

useful life”

of data stored in the database and modifying the pre-defined “

useful life”

status to a pre-defined “

expired”

status when a usability date of the “

useful life”

of the stored data has expired; and

initiating a pre-defined data update workflow process to restore stored data having an “

expired”

status to a pre-defined “

full access”

status.

11. The portal of claim 7, wherein maintenance includes:

tracking the pre-defined “

useful life”

of data stored in the database and modifying the pre-defined “

useful life”

status to a pre-defined “

expired”

status when a usability date of the “

useful life”

of the stored data has expired; and

initiating a pre-defined data update workflow process to restore stored data having an “

expired”

status to a pre-defined “

full access”

status.

12. The portal of claim 8, wherein maintenance includes:

tracking the pre-defined “

useful life”

of data stored in the database and modifying the pre-defined “

useful life”

status to a pre-defined “

expired”

status when a usability date of the “

useful life”

of the stored data has expired; and

initiating a pre-defined data update workflow process to restore stored data having an “

expired”

status to a pre-defined “

full access”

status.

13. The portal of claim 2, wherein syndication includes exporting selected data stored in the database in a plurality of required formats selected from the group consisting of EXCEL, .csv, .txt, XML, and cXML to at least one external system.

14. The portal of claim 2, wherein report generation includes selection, according to user-specified criteria, data stored in the database to provide the selected data in at least one pre-determined format.

15. The portal of claim 2, wherein a user can specify and assume multiple user personalities when using the portal.

16. The portal of claim 1, wherein the plurality of Country of Origin executable functional data manipulations includes at least one computer-aided-instruction module that teaches Country of Origin requirements and procedures to all user personalities, wherein

the at least one computer-aided-instruction module is customizable to a user personality;

and

the at least one computer-aided-instruction module is updatable, as needed, to comply with changes to Country of Origin requirements and procedures.

17. The portal of claim 1, further comprising at least one Country of Origin functional data manipulation module that certifies Country of Origin data a product/service stored in the database for a certification duration according to pre-determined requirements and procedures for products/services of at least one designated user and that recertifies said Country of Origin data of said products/services whenever said certification duration expires.

18. The portal of claim 1, further comprising at least one Country of Origin functional data manipulation module for each of cleanse, rationalize and normalize product/service and service data prior to storage thereof in the database.

19. The portal of claim 18, wherein cleanse further includes definition of characters to be removed from entered data and capture of said defined characters for re-use in a subsequent cleanse of entered data.

20. The portal of claim 18, wherein rationalize further includes executable functional data manipulation modules for:

conversion of hard copy data to an electronic format,

movement of data from improper fields to improve data organization,

correction of misspelling to improve data consistency,

modification of data to meet standards,

removal of duplicate data, and

addition of tags to data to facilitate its proper classification,

wherein application of each said module results in rationalized data that is more structured and consistent, such that processing said rationalized data is quicker, easier and more efficient.

21. The portal of claim 18, wherein normalize further includes representing a same information in a consistent manner across all stored data.

22. The portal of claim 1, further comprising:

a product/service Country of Origin executable functional data manipulation module to define label information for a product/service that includes Country of Origin code, and print the label information using text and barcodes to be affixed to the product/service; and

a product/service Country of Origin executable functional data manipulation module that outputs the label information as an RFID tag to be affixed to the product/service.

23. The portal of claim 1, further comprising product/service Country of Origin executable functional data manipulation modules that enable users to specify selection criteria and generate report output from all data stored in the database, said report output selected from the group consisting of:

product/service breakdown reports including information about product/service components, including a listing of Country of Origin data associated with each component, any documentation supporting the data elements, and a graphic image of the parts, sub-assemblies, and processes that comprise the product/service,

user information wherein user is selected from the group consisting of manufacturer, importer, supplier, distributor, and government contractor and includes user profile data, user certification data, and user associated products/services,

workflow process control data that identifies at least one workflow process, users and tasks involved in each said identified workflow process, and a status of each identified workflow process,

inventory data to allow a user to manage an inventory,

Country of Origin related rules and regulations, and

change management information to track when, where, by whom, and approved by whom whenever stored data are changed.

24. The portal of claim 1, further comprising executable data manipulation modules that allow an auditor to review and report on any stored data that supports a basis for a Country of Origin certification of a product/service;

and view a user profile of any user that performed the certification of the product/service.

25. A method for a Country of Origin certification portal, comprising the steps of:

providing a database for storage of a plurality of product/service data that includes Country of Origin data;

selecting by a user a personality from the group consisting of manufacturer, importer, supplier, distributor, government contractor and contract auditor to perform at least one of function selected from the group consisting of capture, approve, quality control, store, maintain, export, syndicate the product/service Country of Origin data stored in the database.

26. The method of claim 25, wherein the capture function comprises the steps of:

capturing product/service data in a database by performing one of importing and entering parts, sub-assemblies, and processes of a product/service;

establishing a graphic image that includes a sequence of relationships between the parts, sub-assemblies, and processes of the captured product/service data;

determining Country of Origin for the captured product/service data by performing the steps of identifying the product'"'"'s country of origin based on a set of pre-specified rules and regulations relevant to the product/service and component parts, sub-assemblies, and processes thereof,

certifying a determined Country of Origin using regulations specified by at least the BAA and TAA trade agreements and the FTC and GSA administration thereof, that the USA has with the determined Country of Origin of a product/service and storing in the database said certification as certification data associated with the product/service.

27. The method of claim 26, wherein:

the approval function comprises the steps of approving the captured product/service data by performing routing of said captured product/service data and said established graphic image via a pre-defined workflow process, and obtaining at least one go/no-go rating from at least one pre-selected approver;

the quality control function comprises the steps of normalizing and rationalizing the approved product/service data to meet pre-determined usability requirements;

the storage function comprises the steps of maintaining the quality controlled data in a product/service item database for the duration of its useful life, and archiving the data as required to meet regulations;

the maintenance function comprises the steps of when using product/service data stored in the database that has an expired usability date, initiating a data update workflow process to restore the expired product/service data stored in the database to have a non-expired usability date;

the syndication function comprises the steps of selecting product/service data stored in the database, formatting the selected product/service data in at least one required format selected from the group consisting of EXCEL, .csv, .txt, XML, and cXML, and exporting said formatted product/service data to at least one of an external system and a user.

the use function comprises the steps of selecting product/service data stored in the database and obtaining reports thereof formatted according to at least one of a pre-determined report specification and an ad hoc user report specification.

28. A system for Country of Origin compliance, comprising:

data quality control modules to control data quality;

data approval processes to approve quality controlled data for storage in a product/service database;

product/service Country of Origin determination and certification modules for Country of Origin data management, said Country of Origin determination an certification module to determine, certify and store in the database the country of origin of each component of a quality controlled and approved product/service stored in said database;

network communication elements for remote user access to the data quality control modules, data approval processes and data stored in the product/service database;

computer-aided training and certification modules that employ the data quality control and data approval processes to train local users and the network communication elements to train remote users;

syndication modules that syndicate data stored in the product/service database using said network communication elements; and

report generation modules that report data stored in the product/service database.

29. The system of claim 28, wherein the product/service data includes product/service components selected from the group consisting of parts, subassemblies, and processes.

30. The system of claim 29, wherein the product/service components of a product/service are organized into a graphic representation thereof that is stored in the database and associated with the product/service.

31. The system of claim 30, further comprises a plurality of product/service data entry means including:

at least one screen form on a component by component basis, and a graphic “

fishbone-like”

representation of the product/service components of the product;

a popup form used to select a component of the graphic “

fishbone-like”

representation and enter data about the component therein; and

at least one user-defined field for each product/service and component thereof that a user designates for a particular purpose and defines the nature of the data that populates the user-defined field.

32. The system of claim 28, wherein the data quality control modules include cleanse, normalize and rationalize product/service data before storage thereof in the product/service database.

33. The system of claim 28, wherein the data approval processes include route selected information via a pre-defined workflow process to obtain ratings from selected approvers.

34. The system of claim 28, wherein the network communication elements include wired and wireless components that enable remote and local users to access the portal and communicate with the product/service database using the data modules and processes.

35. The system of claim 28, wherein the computer-aided training modules include instructional modules to present to a user pre-determined rules and pre-determined requirements related to Country of Origin data management, and to test an ability of the user to make proper discriminations and take appropriate actions that demonstrate the user can act upon the Country of Origin pre-determined rules and pre-determined requirements.

36. The system of claim 35, wherein the certification modules include a test to verify that a user understands and can act upon the rules and requirements of Country of Origin data management.

37. The system of claim 28, wherein the syndication modules include export of data selected from the product/service database in a format for input to another system or use, the format selected from the group consisting of MS Excel, .csv, .txt, XML, and cXML.

38. The system of claim 31, wherein the data entry means is customizable to a plurality of user types selected from the group consisting of manufacturer, importer, supplier, distributor, government contractor, and compliance auditor.

39. The system of claim 28, wherein for an approved product/service stored in the database, the product/service Country of Origin determination and certification modules certify a determined Country of Origin using regulations specified by at least the BAA and TAA trade agreements and the FTC and GSA administration thereof, that the USA has with the determined Country of Origin of a product/service and storing in the database said certification as certification data associated with the approved product/service.