A number of resources are available on the NCSC's Internet FTP server. This page documents those resources and provides links to the information. Included among the resources is an MS Access database designed for creating the licensing files through data entry or pasting information from other applications.
The NCSC has assembled state licensing information for display on the web since 1998. The center has prepared a Document that includes information about NCSC processing of files to prepare them for use in ACINet and the services the NCSC can provide to help states deal with issues that arise.
File Structure Document
The table structures are based on those found in version 2.5 of the Workforce Information Database, but they differ because of the unique needs of the ACINet application. This Document lists the table structures used and documents differences from the standard Workforce Information Database tables.
Licensing Database Containers
The NCSC has developed both MS Access and Visual FoxPro database containers for the ACINet licensing tables. The tables in these files contain fields not used by ACINet, but which are populated for use in ACINet.
Sample Occupational Enhancements
The major structure change that was incorporated into the licensing tables in version 2.3 of the Workforce Information Database was the addition of a license-to-occupation crosswalk (LICXOCC in the Workforce Information Database, LICXONET in ACINet). This addition allows relationships between a single license and multiple occupations. The NCSC has prepared a document that illustrates potential relationships for engineers and teachers. Similar enhancements can also be made for social workers, dentists, counselors, physicians (MD & DO) and psychologists. The center can help states modify their file contents to incorporate enhancements for these and other licenses.