11/25/2024 4:22:03 PM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss SQL Server or Oracle database administration related to SalesLogix databases. View the code of conduct for posting guidelines.
|
|
|
|
SIC Code definitions
Posted: 22 Feb 08 1:10 PM
|
I figured I'd asked before going and reinventing the wheel. Has anyone added a table to the SLX database that has SIC code definitions?
What we want to do is map the basic SIC code (4 characters) to the OOTB Industry list.
Thanks,
John G. |
|
|
|
Re: SIC Code definitions
Posted: 23 Feb 08 9:37 AM
|
| SIC code - now there's an oxymoron ! There are so many versions of this it's just best to get on an do it with whatever files you have. |
|
|
|
Re: SIC Code definitions
Posted: 23 Feb 08 10:56 AM
|
Yep.. but that's been replaced w/a new set of classifications.
--
RJLedger - rjlSystems |
|
|
|
Re: SIC Code definitions
Posted: 23 Feb 08 2:04 PM
|
RJL is probably referring to the NAICS (North American Industry Classification System), which was introduced a year or so after development on the initial version of SalesLogix began. The SLX folks kept the "SICCODE" fieldname because it was more familiar at the time, and they didn't want to break existing customizations. (That, or they were just lazy.  )
More info, including links to uncompressed Excel spreadsheets containing the actual codes, is available here:
http://www.census.gov/epcd/www/naics.html
There are several other classification schemes, though, particularly outside of North America. The University of Strathclyde Library has a good overview:
http://www.lib.strath.ac.uk/busweb/guides/indclassguide.htm
Each one is slightly different in structure, so it would be difficult to build a feature in SLX that would support all of them, or even more than one or two at a time. |
|
|
|
Re: SIC Code definitions
Posted: 25 Feb 08 6:33 AM
|
Yep. I know all about NAICS. Unfortunately, NAICS has been in place since 1997. Adoption of it is pretty much non-existent across industries. If you talk to people about it they even look at you funny  The use of SIC codes is so ingrain in the system that I'm not sure if NAICS will ever take hold.
I already have the basic SIC code listing to create a table in SLX. This is what we were going to use to cross-reference to the OOTB SLX industry codes. This thread was posted to find out if anyone had done this already or if there was a 3rd party solution. If neither is available then we will have to go through the standard SIC codes and map them manually.
Thanks,
John G.
|
|
|
|
Re: SIC Code definitions
Posted: 25 Feb 08 2:30 PM
|
Never take hold? Why, those dirty non-standards-adopting corporate ba- uh, ooops, hang on, I forgot where I was there for a moment there. 
The out-of-box list has only 20 items in it, am I right? And some are not easily mappable to specific SIC codes, though I suppose you could get most of 'em. (IOW, some would map to multiple SIC codes, requiring an eyeballing of the account to determine which specific code it should be.)
If you'd rather just use the picklist table and maybe expand the list somewhat, you could generate a simple CSV file (code-comma-name for each row) out of Excel, rename it with a .PLF extension, edit the text as required, and finally import the whole thing into SLX via the Picklist Manager's handy (and rarely-noticed) Import button. You'd still use a regular picklist control on your Account Detail form, but you'd have SLX store the ShortText "Code" into SICCODE instead of the "Item." If you pre-edit the file to match up with what's already in the INDUSTRY field (to the extent that's possible), as a final step you could use a SQL Update command to populate the SICCODE's from the PICKLIST table, with a subquery that joins them on INDUSTRY = TEXT...?
To be honest though, if I were doing something like this now, I'd probably store each account's codes into a 1:Many table - so many larger companies are diversified out the ying-yang these days, it's practically impossible to peg them as belonging to any one base classification. |
|
|
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|