How can I have a “unique” license ID when there are many to many relationships between licenses and SOC occupation codes? How could the primary key be improved?
This situation most commonly manifests itself in a licensed occupation that is broader than individual SOC or O*NET occupations and may be related to a number of them. Common examples include engineers, physicians and teachers. The Analyst Resource Center and the ACINet licensing application plan to address this issue by adding a license-to-occupation crosswalk file. Possible structures for these files can be found on the National Crosswalk Service Center’s Non-Standard WID Database page.
