/*THESE SCRIPTS ARE PROVIDED FOR CONVENIENCE ONLY, PLEASE TEST AND BACKUP DATA BEFORE USING*/

use WID27
go

----CORE
insert into wid28.dbo.stfipstb
SELECT [stfips]
      ,[stname]
      ,[abbrev]
  FROM [dbo].[stfipstb]
GO

----CORE
insert into wid28.dbo.areatype
SELECT [stfips]
      ,[areatype]
      ,[areatyname]
  FROM [dbo].[areatype]
GO

----CORE
INSERT into wid28.dbo.geocode
SELECT [geopcode]
      ,[geopdesc]
  FROM [dbo].[geocode]
GO

----CORE
insert into wid28.dbo.geog
SELECT [stfips]
      ,[areatype]
      ,[area]
      ,[areaname]
      ,[areadesc]
      ,[latitude]
      ,[longitude]
      ,[geopcode]
  FROM [dbo].[geog]
GO

insert into wid28.dbo.subgeog
SELECT [stfips]
      ,[areatype]
      ,[area]
      ,[substfips]
      ,[subareatyp]
      ,[subarea]
  FROM [dbo].[subgeog]
GO

insert into wid28.dbo.statelst
SELECT [stfips]
      ,[statename]
      ,[stateabbrv]
  FROM [dbo].[statelst]
GO

----CORE
insert into wid28.dbo.periodty
SELECT [periodtype]
      ,[pertypdesc]
  FROM [dbo].[periodty]
GO

----CORE
insert into wid28.dbo.period
SELECT [periodyear]
      ,[periodtype]
      ,[period]
  FROM [dbo].[period]
GO

----CORE
insert into wid28.dbo.periodid
SELECT [stfips]
      ,[periodid]
      ,[periodtype]
      ,[estyear]
      ,[estperiod]
      ,[projyear]
      ,[projperiod]
      ,[perioddesc]
  FROM [dbo].[periodid]
GO

----DEPRECATED
--insert into wid28.dbo.jobfamly
--SELECT [jobfamily]
--      ,[famtitle]
--      ,[familydesc]
--  FROM [dbo].[jobfamly]
--GO

insert into wid28.dbo.benefit
SELECT [stfips]
      ,[benefit]
      ,[benedesc]
  FROM [dbo].[benefit]
GO

insert into wid28.dbo.careerclust
SELECT [clustercode]
      ,[clustertitle]
      ,[clusterdesc]
  FROM [dbo].[careerclust]
GO

insert into wid28.dbo.careerpaths
SELECT [pathcode]
      ,[pathtitle]
  FROM [dbo].[careerpaths]
GO

----CORE
insert into wid28.dbo.occtypes
SELECT [codetype]
      ,[codetydesc]
  FROM [dbo].[occtypes]
GO

----DEPRECATED
--insert into wid28.dbo.censcode
--SELECT [censcode]
--      ,[codetype]
--      ,[censtitle]
--  FROM [dbo].[censcode]
--GO

insert into wid28.dbo.edulevel
SELECT [stfips]
      ,[edulevel]
      ,[edulvldesc]
  FROM [dbo].[edulevel]
GO

insert into wid28.dbo.education
SELECT [educat]
      ,[educatdesc]
  FROM [dbo].[education]
GO

insert into wid28.dbo.experience
SELECT [expercat]
      ,[expercatdesc]
  FROM [dbo].[experience]
GO

insert into wid28.dbo.training
SELECT [trainingcat]
      ,[trainingdesc]
  FROM [dbo].[training]
GO

----DEPRECATED
--insert into wid28.dbo.eeo1cat
--SELECT [eeo1cat]
--      ,[eeo1title]
--  FROM [dbo].[eeo1cat]
--GO

----DEPRECATED
--insert into wid28.dbo.eeostloc
--SELECT [eeostoc]
--      ,[eeostloctl]
--  FROM [dbo].[eeostloc]
--GO

insert into wid28.dbo.explevel
SELECT [stfips]
      ,[explevel]
      ,[explvldesc]
  FROM [dbo].[explevel]
GO

insert into wid28.dbo.itemcpi
SELECT [CPIITEM]
      ,[ITEMDESC]
  FROM [dbo].[itemcpi]
GO

insert into wid28.dbo.lengthopen
SELECT [stfips]
      ,[lengthopen]
      ,[lodesc]
  FROM [dbo].[lengthopen]
GO

insert into wid28.dbo.oohtrntm
SELECT [oohtrntm]
      ,[oohtmdesc]
  FROM [dbo].[oohtrntm]
GO

----DEPRECATED
--insert into wid28.dbo.oesgroup
--SELECT [oesgroup1]
--      ,[oesgroup2]
--      ,[oesgroup3]
--      ,[grpdesc]
--  FROM [dbo].[oesgroup]
--GO

----DEPRECATED
--insert into wid28.dbo.oestrntm
--SELECT [oestrntm]
--      ,[oestmdesc]
--  FROM [dbo].[oestrntm]
--GO

----DEPRECATED
--insert into wid28.dbo.oescode
--SELECT [oescode]
--      ,[oestitle]
--      ,[oesdesc]
--      ,[oestrntm]
--      ,[oestitles]
--      ,[oohtrntm]
--      ,[oesgroup1]
--      ,[oesgroup2]
--      ,[oesgroup3]
--  FROM [dbo].[oescode]
--GO

----CORE
insert into wid28.dbo.occsub
SELECT [stfips]
      ,[subtot]
      ,[subtotdesc]
  FROM [dbo].[occsub]
GO

----CORE
insert into wid28.dbo.occdir
SELECT [stfips]
      ,[matoccode]
      ,[periodid]
      ,[matoccodty]
      ,[matocctitl]
      ,[subtot]
  FROM [dbo].[occdir]
GO

insert into wid28.dbo.stattype
SELECT [stfips]
      ,[stattype]
      ,[stattydesc]
  FROM [dbo].[stattype]
GO

----CORE
insert into wid28.dbo.indtypes
SELECT [codetype]
      ,[codetydesc]
  FROM [dbo].[indtypes]
GO

insert into wid28.dbo.qwisup
SELECT [qwisup]
      ,[qwisupdesc]
  FROM [dbo].[qwisup]
GO

insert into wid28.dbo.qwitype
SELECT [qwitype]
      ,[qwitypdesc]
  FROM [dbo].[qwitype]
GO

----DEPRECATED
--insert into wid28.dbo.sicdiv
--SELECT [sicdiv]
--      ,[divdesc]
--  FROM [dbo].[sicdiv]
--GO

----DEPRECATED
--insert into wid28.dbo.siclevel
--SELECT [siclevel]
--      ,[leveldesc]
--  FROM [dbo].[siclevel]
--GO

insert into wid28.dbo.inddiv
SELECT [inddiv]
      ,[indtitle]
  FROM [dbo].[inddiv]
GO

----DEPRECATED
--insert into wid28.dbo.siccode
--SELECT [siccode]
--      ,[sictitle]
--      ,[sictitlel]
--      ,[sicdesc]
--      ,[sicdiv]
--      ,[siclevel]
--      ,[inddiv]
--  FROM [dbo].[siccode]
--GO

----CORE
insert into wid28.dbo.ratetype
SELECT [ratetype]
      ,[ratetydesc]
  FROM [dbo].[ratetype]
GO

insert into wid28.dbo.salestyp
SELECT [stfips]
      ,[salestype]
      ,[saletydesc]
  FROM [dbo].[salestyp]
GO

----CORE
insert into wid28.dbo.leveltyp
SELECT [stfips]
      ,[leveltype]
      ,[lvldesc]
  FROM [dbo].[leveltyp]
GO

----CORE
insert into wid28.dbo.wgsource
SELECT [stfips]
      ,[wagesource]
      ,[wagesrdesc]
  FROM [dbo].[wgsource]
GO

----DEPRECATED
--insert into wid28.dbo.cenind
--SELECT [CENIND]
--      ,[CODETYPE]
--      ,[CENTITLE]
--  FROM [dbo].[CENIND]
--GO


----CORE
insert into wid28.dbo.indsub
SELECT [stfips]
      ,[subtot]
      ,[subtotdesc]
  FROM [dbo].[indsub]
GO

----CORE---CHANGED IN V2.8--STATES WILL NEED TO ASSIGN OWNERSHIP CODES TO THEIR OWN INDUSTRIES
insert into wid28.dbo.inddir
SELECT [stfips]
      ,[matincode]
      ,[periodid]
      ,[matincodty]
      ,[matintitle]
      ,[subtot]
	  ,null as [ownership]
  FROM [dbo].[inddir]
GO

insert into wid28.dbo.popsource
SELECT [stfips]
      ,[popsource]
      ,[popsrcdesc]
  FROM [dbo].[popsource]
GO

insert into wid28.dbo.unittype
SELECT [stfips]
      ,[unittype]
      ,[typedesc]
  FROM [dbo].[unittype]
GO

----CORE---CHANGED IN V2.8--titles were expanded, current data does not require transformation
insert into wid28.dbo.cescode
SELECT [stfips]
      ,[seriescode]
      ,[seriesdesc]
      ,[seriesttls]
      ,[seriesttll]
      ,[serieslvl]
  FROM [dbo].[cescode]
GO

insert into wid28.dbo.cidscode
SELECT [cidscode]
      ,[cidstitle]
      ,[cidsdesc]
  FROM [dbo].[cidscode]
GO

----CHANGED IN V2.8--titles were expanded, current data does not require transformation
insert into wid28.dbo.cipcode
SELECT [cipcode]
      ,[cipcodetype]
      ,[ciptitle]
      ,[cipdesc]
      ,[ciptitls]
      ,[ciplevel]
  FROM [dbo].[cipcode]
GO

----DEPRECATED
--insert into wid28.dbo.cluscode
--SELECT [stfips]
--      ,[cluscode]
--      ,[clustitle]
--      ,[clusdesc]
--  FROM [dbo].[cluscode]
--GO

insert into wid28.dbo.compltyp
SELECT [stfips]
      ,[compltype]
      ,[compltitle]
      ,[compldesc]
  FROM [dbo].[compltyp]
GO

----DEPRECATED
--insert into wid28.dbo.dotcode
--SELECT [dotcode]
--      ,[dottitle]
--      ,[gedr]
--      ,[gedm]
--      ,[gedl]
--      ,[svp]
--  FROM [dbo].[dotcode]
--GO

insert into wid28.dbo.eventtyp
SELECT [eventtype]
      ,[eventdesc]
  FROM [dbo].[eventtyp]
GO

insert into wid28.dbo.gender
SELECT [gender]
      ,[genderdesc]
  FROM [dbo].[gender]
GO

insert into wid28.dbo.instown
SELECT [instown]
      ,[instowndes]
  FROM [dbo].[instown]
GO

insert into wid28.dbo.insttype
SELECT [stfips]
      ,[insttype]
      ,[insttydesc]
  FROM [dbo].[insttype]
GO

insert into wid28.dbo.lentype
SELECT [stfips]
      ,[lengthtype]
      ,[lentypdesc]
  FROM [dbo].[lentype]
GO

insert into wid28.dbo.meeicode
SELECT [meeicode]
      ,[meeidesc]
  FROM [dbo].[meeicode]
GO

----DEPRECATED
--insert into wid28.dbo.mlssepcat
--SELECT [mlssepcategory]
--      ,[mlssepcatdesc]
--  FROM [dbo].[mlssepcat]
--GO

----DEPRECATED
--insert into wid28.dbo.mlssepcdtype
--SELECT [mlssepcodetype]
--      ,[mlssepcdtypdesc]
--      ,[mlsseptypeffdate]
--  FROM [dbo].[mlssepcdtype]
--GO

----DEPRECATED
--insert into wid28.dbo.mlssepcd
--SELECT [mlssepcodetype]
--      ,[mlssepcd]
--      ,[mlssepdesc]
--      ,[mlssepcategory]
--  FROM [dbo].[mlssepcd]
--GO

insert into wid28.dbo.naicdom
SELECT [naicdomain]
      ,[domaintitl]
  FROM [dbo].[naicdom]
GO

insert into wid28.dbo.naicsupr
SELECT [naicsuper]
      ,[supertitle]
      ,[naicdomain]
  FROM [dbo].[naicsupr]
GO

insert into wid28.dbo.naicsect
SELECT [naicsect]
      ,[sectdesc]
      ,[sectdescl]
      ,[naicsuper]
  FROM [dbo].[naicsect]
GO

insert into wid28.dbo.naicslvl
SELECT [naicslvl]
      ,[leveldesc]
  FROM [dbo].[naicslvl]
GO

insert into wid28.dbo.naiccode
SELECT [naicscode]
      ,[naicstitle]
      ,[naicstitll]
      ,[naicsdesc]
      ,[naicslvl]
      ,[naicsect]
  FROM [dbo].[naiccode]
GO

----DEPRECATED
--insert into wid28.dbo.oeslaytl
--SELECT [oescode]
--      ,[laytitle]
--  FROM [dbo].[oeslaytl]
--GO

insert into wid28.dbo.onetcode
SELECT [onetcode]
      ,[onetyear]
      ,[onetver]
      ,[onettitle]
      ,[onetdesc]
  FROM [dbo].[onetcode]
GO

----CORE
insert into wid28.dbo.ownershp
SELECT [stfips]
      ,[ownership]
      ,[ownertitle]
      ,[ownerdesc]
  FROM [dbo].[ownershp]
GO

insert into wid28.dbo.paytype
SELECT [stfips]
      ,[paytype]
      ,[paytydesc]
  FROM [dbo].[paytype]
GO

insert into wid28.dbo.raceethn
SELECT [raceethn]
      ,[racetitle]
  FROM [dbo].[raceethn]
GO

insert into wid28.dbo.sizeclas
SELECT [stfips]
      ,[sizeclass]
      ,[sizedesc]
  FROM [dbo].[sizeclas]
GO

----CHANGES IN V2.8 - title lengths only, does not affect transfer
insert into wid28.dbo.soccode
SELECT [soccode]
      ,[soccodetype]
      ,[soctitle]
      ,[soctitlel]
      ,[socdesc]
      ,[education]
      ,[experience]
      ,[training]
      ,[oesflag]
      ,[socparent]
	  ,[soccodetype]
      ,[oohtrntm]
  FROM [dbo].[soccode]
GO

----CORE---CHANGES IN V2.8 - title lengths only, does not affect transfer
insert into wid28.dbo.occcodes
SELECT [stfips]
      ,[CODETYPE]
      ,[CODE]
      ,[CODETITLE]
  FROM [dbo].[occcodes]
GO

----CHANGES IN V2.8 - title lengths only, does not affect transfer
insert into wid28.dbo.stprogcd
SELECT [stfips]
      ,[codetype]
      ,[code]
      ,[title]
      ,[cipcode]
      ,[cipcodetype]
      ,[titldesc]
  FROM [dbo].[stprogcd]
GO

----CORE---CHANGES IN V2.8 - title lengths only, does not affect transfer
insert into wid28.dbo.indcodes
SELECT [stfips]
      ,[CODETYPE]
      ,[CODE]
      ,[CODETITLE]
  FROM [dbo].[indcodes]
GO

insert into wid28.dbo.taxtype
SELECT [stfips]
      ,[taxtype]
      ,[taxtypdesc]
  FROM [dbo].[taxtype]
GO

----DEPRECATED
--insert into wid28.dbo.vetcode
--SELECT [veteran]
--      ,[vetdesc]
--  FROM [dbo].[vetcode]
--GO

insert into wid28.dbo.worksite
SELECT [worksite]
      ,[wksitedesc]
  FROM [dbo].[worksite]
GO

insert into wid28.dbo.addresty
SELECT [addressty]
      ,[addresdesc]
  FROM [dbo].[addresty]
GO

insert into wid28.dbo.agegroup
SELECT [stfips]
      ,[agegroup]
      ,[agegrpdesc]
  FROM [dbo].[agegroup]
GO

----CORE 
insert into wid28.dbo.annslflg
SELECT [annsalflg]
      ,[annsadesc]
  FROM [dbo].[annslflg]
GO

----CORE 
insert into wid28.dbo.annslrng
SELECT [annsalrang]
      ,[salrngdesc]
  FROM [dbo].[annslrng]
GO

----CORE 
insert into wid28.dbo.benmark
SELECT [benchmark]
      ,[benchdesc]
  FROM [dbo].[benmark]
GO

insert into wid28.dbo.clusgrad
SELECT [stfips]
      ,[clusgrade]
      ,[clusgrdesc]
  FROM [dbo].[clusgrad]
GO

insert into wid28.dbo.cpitype
SELECT [stfips]
      ,[cpitype]
      ,[cpititle]
      ,[cpidesc]
  FROM [dbo].[cpitype]
GO

insert into wid28.dbo.cpisource
SELECT [stfips]
      ,[cpisource]
      ,[cpisrcdesc]
  FROM [dbo].[cpisource]
GO

----CORE 
insert into wid28.dbo.creditcd
SELECT [creditcd]
      ,[creditdesc]
  FROM [dbo].[creditcd]
GO

----DEPRECATED 
--insert into wid28.dbo.disabil
--SELECT [disabled]
--      ,[disabldesc]
--  FROM [dbo].[disabil]
--GO

----DEPRECATED 
--insert into wid28.dbo.disadvan
--SELECT [econdisadv]
--      ,[ecodisdesc]
--  FROM [dbo].[disadvan]
--GO

----DEPRECATED 
--insert into wid28.dbo.dislocat
--SELECT [dislocated]
--      ,[dislocdesc]
--  FROM [dbo].[dislocat]
--GO

----DEPRECATED 
--insert into wid28.dbo.dwvertyp
--SELECT [dwvertype]
--      ,[dwevetdesc]
--  FROM [dbo].[dwvertyp]
--GO

----CORE 
insert into wid28.dbo.empszflg
SELECT [empsizflg]
      ,[empflgdesc]
  FROM [dbo].[empszflg]
GO

----CORE 
insert into wid28.dbo.empszrng
SELECT [empsizrng]
      ,[emprngdesc]
  FROM [dbo].[empszrng]
GO

----CORE 
insert into wid28.dbo.growcode
SELECT [stfips]
      ,[growcode]
      ,[growdesc]
  FROM [dbo].[growcode]
GO

insert into wid28.dbo.incsourc
SELECT [stfips]
      ,[incsource]
      ,[incsrcdesc]
  FROM [dbo].[incsourc]
GO

insert into wid28.dbo.incomtyp
SELECT [stfips]
      ,[inctype]
      ,[incdesc]
  FROM [dbo].[incomtyp]
GO

insert into wid28.dbo.laytitle
SELECT [laytlcode]
      ,[laytitle]
  FROM [dbo].[laytitle]
GO

insert into wid28.dbo.licnumty
SELECT [licnumtype]
      ,[licnumdesc]
  FROM [dbo].[licnumty]
GO

----CORE 
insert into wid28.dbo.locstat
SELECT [locstat]
      ,[locstdesc]
  FROM [dbo].[locstat]
GO

insert into wid28.dbo.mpc
SELECT [mpc]
      ,[mpcdesc]
  FROM [dbo].[mpc]
GO

insert into wid28.dbo.svc
SELECT [svc]
      ,[svctitle]
  FROM [dbo].[svc]
GO

insert into wid28.dbo.moccode
SELECT [svc]
      ,[mpc]
      ,[status]
      ,[moccode]
      ,[moctitle]
      ,[mocdesc]
  FROM [dbo].[moccode]
GO

----DEPRECATED 
--insert into wid28.dbo.urltopic
--SELECT [stfips]
--      ,[urltopic]
--      ,[topicdesc]
--  FROM [dbo].[urltopic]
--GO

----CORE 
insert into wid28.dbo.prvgovst
SELECT [privgovsta]
      ,[prvgovdesc]
  FROM [dbo].[prvgovst]
GO

insert into wid28.dbo.schgrade
SELECT [stfips]
      ,[highestgrd]
      ,[highgrdesc]
  FROM [dbo].[schgrade]
GO

----DEPRECATED 
--insert into wid28.dbo.seasonal
--SELECT [seasonal]
--      ,[seasondesc]
--  FROM [dbo].[seasonal]
--GO

insert into wid28.dbo.bedtypes
SELECT [bedtypcode]
      ,[bedtypdesc]
  FROM [dbo].[bedtypes]
GO

insert into wid28.dbo.classtime
SELECT [classtime]
      ,[classtimetitle]
  FROM [dbo].[classtime]
GO

----CORE 
insert into wid28.dbo.contactpro
SELECT [contactprotitle]
      ,[contactprodesc]
  FROM [dbo].[contactpro]
GO

----CORE 
insert into wid28.dbo.contacttitle
SELECT [contacttitlecode]
      ,[contacttitledesc]
  FROM [dbo].[contacttitle]
GO

insert into wid28.dbo.stockexch
SELECT [stockexchcode]
      ,[stockexchdesc]
  FROM [dbo].[stockexch]
GO

insert into wid28.dbo.iospecialid
SELECT [stfips]
      ,[indcodty]
      ,[indcode]
      ,[occodetype]
      ,[occcode]
      ,[green]
      ,[pctgreen]
  FROM [dbo].[iospecialid]
GO

----DEPRECATED 
--insert into wid28.dbo.analysis
--SELECT [stfips]
--      ,[areatype]
--      ,[area]
--      ,[periodyear]
--      ,[periodtype]
--      ,[period]
--      ,[cluscode]
--      ,[analysis]
--      ,[clusgrade]
--      ,[placeclus]
--  FROM [dbo].[analysis]
--GO

insert into wid28.dbo.bed
SELECT [stfips]
      ,[areatype]
      ,[area]
      ,[periodyear]
      ,[periodtype]
      ,[period]
      ,[indcodtype]
      ,[indcode]
      ,[adjusted]
      ,[bedtypcode]
      ,[bedemploy]
      ,[bedempperc]
      ,[bedestabs]
      ,[bedestperc]
      ,[suppress]
  FROM [dbo].[bed]
GO

insert into wid28.dbo.blding
SELECT [stfips]
      ,[areatype]
      ,[area]
      ,[periodyear]
      ,[periodtype]
      ,[period]
      ,[unittype]
      ,[units]
      ,[unitcost]
  FROM [dbo].[blding]
GO

----DEPRECATED 
--insert into wid28.dbo.cenlabor
--SELECT [stfips]
--      ,[areatype]
--      ,[area]
--      ,[periodyear]
--      ,[periodtype]
--      ,[period]
--      ,[censcode]
--      ,[codetype]
--      ,[femalelf]
--      ,[malelf]
--  FROM [dbo].[cenlabor]
--GO

----CORE 
insert into wid28.dbo.ces
SELECT [stfips]
      ,[areatype]
      ,[area]
      ,[periodyear]
      ,[periodtype]
      ,[period]
      ,[seriescode]
      ,[adjusted]
      ,[benchmark]
      ,[prelim]
      ,[empces]
      ,[empprodwrk]
      ,[empfemale]
      ,[hours]
      ,[earnings]
      ,[hourearn]
      ,[supprecord]
      ,[supphe]
      ,[supppw]
      ,[suppfem]
      ,[hoursallwrkr]
      ,[earningsallwrkr]
      ,[hourearnallwrkr]
      ,[suppheallwrkr]
  FROM [dbo].[ces]
GO

insert into wid28.dbo.commute
SELECT [stfips]
      ,[areatype]
      ,[area]
      ,[periodyear]
      ,[periodtype]
      ,[period]
      ,[wkstfips]
      ,[wkareaty]
      ,[wkarea]
      ,[workers]
  FROM [dbo].[commute]
GO

insert into wid28.dbo.cpi
SELECT [stfips]
      ,[areatype]
      ,[area]
      ,[periodyear]
      ,[periodtype]
      ,[period]
      ,[cpitype]
      ,[cpisource]
      ,[cpi]
      ,[pctchgy]
      ,[pctchgm]
  FROM [dbo].[cpi]
GO

insert into wid28.dbo.cpiplus
SELECT [STFIPS]
      ,[AREATYPE]
      ,[AREA]
      ,[PERIODYEAR]
      ,[PERIODTYPE]
      ,[PERIOD]
      ,[ADJUSTED]
      ,[CPIINDEX]
      ,[CPIITEM]
      ,[CPISOURCE]
      ,[BASIS]
      ,[CPI]
      ,[PCTCHANGEY]
      ,[PCTCHANGEM]
  FROM [dbo].[cpiplus]
GO

----CHANGED IN V2.8
insert into wid28.dbo.demographics
SELECT [stfips]
      ,[areatype]
      ,[area]
      ,[periodyear]
      ,[periodtype]
      ,[period]
      ,[popsource]
      ,[population]
      ,[female]
      ,[male]
      ,[median]
      ,[medianmale]
      ,[medianfem]
      ,[totunder5]
      ,[femunder5]
      ,[maleunder5]
      ,[tot5to9]
      ,[fem5to9]
      ,[male5to9]
      ,[tot10to14]
      ,[fem10to14]
      ,[male10to14]
      ,[tot15to19]
      ,[fem15to19]
      ,[male15to19]
      ,[tot15to17]
      ,[fem15to17]
      ,[male15to17]
      ,[tot18to19]
      ,[fem18to19]
      ,[male18to19]
      ,[tot20to24]
      ,[fem20to24]
      ,[male20to24]
      ,[tot20]
      ,[fem20]
      ,[male20]
      ,[tot21]
      ,[fem21]
      ,[male21]
      ,[tot22to24]
      ,[fem22to24]
      ,[male22to24]
      ,[tot25to34]
      ,[fem25to34]
      ,[male25to34]
      ,[tot25to29]
      ,[fem25to29]
      ,[male25to29]
      ,[tot30to34]
      ,[fem30to34]
      ,[male30to34]
      ,[tot35to44]
      ,[fem35to44]
      ,[male35to44]
      ,[tot35to39]
      ,[fem35to39]
      ,[male35to39]
      ,[tot40to44]
      ,[fem40to44]
      ,[male40to44]
      ,[tot45to54]
      ,[fem45to54]
      ,[male45to54]
      ,[tot45to49]
      ,[fem45to49]
      ,[male45to49]
      ,[tot50to54]
      ,[fem50to54]
      ,[male50to54]
      ,[tot55to59]
      ,[fem55to59]
      ,[male55to59]
      ,[tot60to64]
      ,[fem60to64]
      ,[male60to64]
      ,[tot60to61]
      ,[fem60to61]
      ,[male60to61]
      ,[tot62to64]
      ,[fem62to64]
      ,[male62to64]
      ,[tot65to69]
      ,[fem65to69]
      ,[male65to69]
      ,[tot65to66]
      ,[fem65to66]
      ,[male65to66]
      ,[tot67to69]
      ,[fem67to69]
      ,[male67to69]
      ,[tot70to74]
      ,[fem70to74]
      ,[male70to74]
      ,[tot75to84]
      ,[fem75to84]
      ,[male75to84]
      ,[tot75to79]
      ,[fem75to79]
      ,[male75to79]
      ,[tot80to84]
      ,[fem80to84]
      ,[male80to84]
      ,[tot85xx]
      ,[fem85xx]
      ,[male85xx]
      ,[tot18xx]
      ,[fem18xx]
      ,[male18xx]
      ,[tot21xx]
      ,[fem21xx]
      ,[male21xx]
      ,[tot62xx]
      ,[fem62xx]
      ,[male62xx]
      ,[onerace]
      ,[white]
      ,[black]
      ,[naan]
      ,[asian]
      ,[pacisland]
      ,[other]
      ,[twomoraces]
      ,[hispanic]
      ,[hispwhite]
      ,[hispblack]
      ,[hispnaan]
      ,[hispasian]
      ,[hisppacisl]
      ,[hispother]
      ,[hisp2race]
  FROM [dbo].[demographics]
GO

----DEPRECATED 
--insert into wid28.dbo.develop
--SELECT [stfips]
--      ,[areatype]
--      ,[area]
--      ,[periodyear]
--      ,[periodtype]
--      ,[period]
--      ,[indcodty]
--      ,[indcode]
--      ,[newinvest]
--      ,[newemply]
--      ,[newfirms]
--      ,[expinvest]
--      ,[expemply]
--      ,[expfirms]
--      ,[invincent]
--  FROM [dbo].[develop]
--GO

----CORE 
insert into wid28.dbo.empdbinf
SELECT [RELEASENO]
      ,[RELEASEMO]
      ,[RELEASEYR]
      ,[COPYRTYEAR]
      ,[CONTRACTYR]
      ,[EDITIONYR]
  FROM [dbo].[empdbinf]
GO

----CORE 
insert into wid28.dbo.empdb
SELECT [stfips]
      ,[areatype]
      ,[area]
      ,[uniqueid]
      ,[fein]
      ,[lastupdate]
      ,[name]
      ,[addressp]
      ,[cityp]
      ,[statep]
      ,[zipcodep]
      ,[zipplusp]
      ,[latitude]
      ,[longitude]
      ,[geopcode]
      ,[censustract]
      ,[censusblockgrp]
      ,[addressm]
      ,[citym]
      ,[statem]
      ,[zipcodem]
      ,[zipplusm]
      ,[addressl]
      ,[cityl]
      ,[statel]
      ,[zipcodel]
      ,[zipplusl]
      ,[telenum]
      ,[cntctlname]
      ,[cntctfname]
      ,[cntcttitle]
      ,[contacttitlecode]
      ,[contactprotitle]
      ,[contactgender]
      ,[contactemail]
      ,[tollfreetele]
      ,[faxnumber]
      ,[weburl]
      ,[busdesc]
      ,[primarysic]
      ,[sic2]
      ,[sic3]
      ,[sic4]
      ,[sic5]
      ,[primnaics]
      ,[naics2]
      ,[naics3]
      ,[naics4]
      ,[naics5]
      ,[privgovsta]
      ,[locstat]
      ,[stockexchcode]
      ,[stockticker]
      ,[whitecollarpct]
      ,[whitecollarind]
      ,[empsizrng]
      ,[empsizval]
      ,[empsizflg]
      ,[annsalrng]
      ,[annsalval]
      ,[annsalflg]
      ,[yearest]
      ,[creditcd]
      ,[hdqtrsid]
      ,[parentid]
      ,[ultimateparentid]
      ,[foreignparentind]
      ,[exportimportind]
      ,[businesstype]
      ,[workathome]
      ,[releaseno]
  FROM [dbo].[empdb]
GO

----DEPRECATED 
--insert into wid28.dbo.eeolabfac
--SELECT [stfips]
--      ,[areatype]
--      ,[area]
--      ,[periodyear]
--      ,[periodtype]
--      ,[period]
--      ,[gender]
--      ,[raceethn]
--      ,[lffact]
--      ,[empfact]
--      ,[unempfact]
--  FROM [dbo].[eeolabfac]
--GO

----DEPRECATED 
--insert into wid28.dbo.eeolabfor
--SELECT [stfips]
--      ,[areatype]
--      ,[area]
--      ,[periodyear]
--      ,[periodtype]
--      ,[period]
--      ,[gender]
--      ,[raceethn]
--      ,[laborforce]
--      ,[emplab]
--      ,[unemp]
--      ,[unemprate]
--  FROM [dbo].[eeolabfor]
--GO

----DEPRECATED 
--insert into wid28.dbo.eeoocc
--SELECT [stfips]
--      ,[areatype]
--      ,[area]
--      ,[periodyear]
--      ,[periodtype]
--      ,[period]
--      ,[gender]
--      ,[raceethn]
--      ,[occodetype]
--      ,[occcode]
--      ,[explabfor]
--  FROM [dbo].[eeoocc]
--GO

----DEPRECATED 
--insert into wid28.dbo.eeopop
--SELECT [stfips]
--      ,[areatype]
--      ,[area]
--      ,[periodyear]
--      ,[periodtype]
--      ,[period]
--      ,[gender]
--      ,[raceethn]
--      ,[population]
--  FROM [dbo].[eeopop]
--GO

----DEPRECATED 
--insert into wid28.dbo.esapplic1
--SELECT [stfips]
--      ,[areatype]
--      ,[area]
--      ,[periodyear]
--      ,[periodtype]
--      ,[period]
--      ,[occodetype]
--      ,[occcode]
--      ,[agegroup]
--      ,[gender]
--      ,[raceethn]
--      ,[highestgrd]
--      ,[esapplicid]
--      ,[applicants]
--  FROM [dbo].[esapplic1]
--GO

----DEPRECATED 
--insert into wid28.dbo.esapplic2
--SELECT [stfips]
--      ,[esapplicid]
--      ,[veteran]
--      ,[disabled]
--      ,[seasonal]
--      ,[econdisadv]
--      ,[dislocated]
--      ,[applicants]
--  FROM [dbo].[esapplic2]
--GO

insert into wid28.dbo.esdata
SELECT [stfips]
      ,[areatype]
      ,[area]
      ,[periodyear]
      ,[periodtype]
      ,[period]
      ,[occodetype]
      ,[occcode]
      ,[stattype]
      ,[eswage]
      ,[esorders]
      ,[esopen]
      ,[esapps]
      ,[newapps]
      ,[referrals]
      ,[ratetype]
  FROM [dbo].[esdata]
GO

insert into wid28.dbo.income
SELECT [stfips]
      ,[areatype]
      ,[area]
      ,[periodyear]
      ,[periodtype]
      ,[period]
      ,[inctype]
      ,[incsource]
      ,[income]
      ,[incrank]
      ,[population]
      ,[releasedate]
  FROM [dbo].[income]
GO

----DEPRECATED 
--insert into wid28.dbo.indprj
--SELECT [stfips]
--      ,[areatype]
--      ,[area]
--      ,[periodid]
--      ,[matincode]
--      ,[estindprj]
--      ,[projindprj]
--      ,[grrate]
--      ,[nchg]
--      ,[pchg]
--      ,[growcode]
--      ,[suppress]
--  FROM [dbo].[indprj]
--GO

insert into wid28.dbo.indsum
SELECT [stfips]
      ,[areatype]
      ,[area]
      ,[indcodetyp]
      ,[indcode]
      ,[indsource]
      ,[employers]
  FROM [dbo].[indsum]
GO

----CORE 
insert into wid28.dbo.industry
SELECT [stfips]
      ,[areatype]
      ,[area]
      ,[periodyear]
      ,[periodtype]
      ,[period]
      ,[indcodty]
      ,[indcode]
      ,[ownership]
      ,[prelim]
      ,[firms]
      ,[estab]
      ,[avgemp]
      ,[mnth1emp]
      ,[mnth2emp]
      ,[mnth3emp]
      ,[topempav]
      ,[totwage]
      ,[avgwkwage]
      ,[taxwage]
      ,[contrib]
      ,[suppress]
  FROM [dbo].[industry]
GO

----CORE 
insert into wid28.dbo.iomatrix
SELECT [stfips]
      ,[areatype]
      ,[area]
      ,[periodid]
      ,[matincode]
      ,[matoccode]
      ,[estemp]
      ,[projemp]
      ,[pctestind]
      ,[pctestocc]
      ,[pctprojind]
      ,[pctprojocc]
      ,[nchg]
      ,[pchg]
      ,[growrate]
      ,[growcode]
      ,[aopeng]
      ,[aopenr]
      ,[aopent]
      ,[exits]
      ,[annualexits]
      ,[transfers]
      ,[annualtransfers]
      ,[change]
      ,[annualchange]
      ,[openings]
      ,[annualopenings]
      ,[suppress]
  FROM [dbo].[iomatrix]
GO

----CORE 
insert into wid28.dbo.labforce
SELECT [stfips]
      ,[areatype]
      ,[area]
      ,[periodyear]
      ,[periodtype]
      ,[period]
      ,[adjusted]
      ,[prelim]
      ,[benchmark]
      ,[laborforce]
      ,[emplab]
      ,[unemp]
      ,[unemprate]
      ,[clfprate]
      ,[emppopratio]
  FROM [dbo].[labforce]
GO

insert into wid28.dbo.jvs
SELECT [STFIPS]
      ,[AREATYPE]
      ,[AREA]
      ,[PERIODYEAR]
      ,[PERIODTYPE]
      ,[PERIOD]
      ,[OWNERSHIP]
      ,[INDCODTY]
      ,[INDCODE]
      ,[OCCODETYPE]
      ,[OCCCODE]
      ,[SIZECLASS]
      ,[JVSCELLID]
      ,[VACANCIES]
      ,[VACANRATE]
      ,[MEDIANWAGE]
      ,[MEANWAGE]
      ,[MINWAGE]
      ,[MAXWAGE]
      ,[SUPPRESS]
  FROM [dbo].[jvs]
GO

insert into wid28.dbo.jvsaddit
SELECT [STFIPS]
      ,[JVSCELLID]
      ,[PARTFULL]
      ,[PERMSEAS]
      ,[LENGTHOPEN]
      ,[EDULEVEL]
      ,[EXPLEVEL]
      ,[CERTREQ]
      ,[BENEFIT]
      ,[PERCENTOPN]
      ,[SUPPRESS]
  FROM [dbo].[jvsaddit]
GO

----CORE---CHANGED IN V2.8 
--wid28.dbo.licensetypes
----CORE---CHANGED IN V2.8 
--wid28.dbo.licenseexams
----CORE---CHANGED IN V2.8 
--wid28.dbo.licenseeducation
----CORE---CHANGED IN V2.8 
--wid28.dbo.liccontinuingedu
----CORE---CHANGED IN V2.8 
--wid28.dbo.licensecertification
----CORE---CHANGED IN V2.8 
--wid28.dbo.licenseexperience
----CORE---CHANGED IN V2.8 
--wid28.dbo.licensecriminal
----CORE---CHANGED IN V2.8 
--wid28.dbo.licensephysicalreqs
----CORE---CHANGED IN V2.8 
--wid28.dbo.licenseactivestatus
----CORE---CHANGED IN V2.8 
--wid28.dbo.licenseveteran

----CORE---CHANGED IN V2.8 --this should be modified to suit how the specific state uses name fields
insert into wid28.dbo.licauth
SELECT [stfips]
      ,[areatype]
      ,[area]
      ,[licauthid]
      ,[name1]
      ,[name2]
      ,[name3]
      ,[address1]
      ,[address2]
      ,[city]
      ,[st]
      ,[zip]
      ,[zipext]
      ,[latitude]
      ,[longitude]
      ,[geopcode]
      ,[telephone]
      ,[teleext]
      ,[fax]
      ,[contact]
      ,[email]
      ,[url]
  FROM [dbo].[licauth]
GO

----CORE---CHANGED IN V2.8 ---correct coding
insert into wid28.dbo.license
SELECT [stfips]
      ,[areatype]
      ,[area]
      ,[licenseid]
      ,[licauthid]
      ,[lictitle]
      ,[licdesc]
      ,null as [licensetype]
      ,null as [exam]
      ,null as [education]
      ,null as [continuingedu]
      ,null as [certification]
      ,null as [experience]
      ,null as [criminal]
      ,null as [physical]
      ,null as [veteran]
      ,null as [inactive]
      ,[licenseurl]
      ,year(getdate())+right('00'+month(getdate()),2)+right('00'+day(getdate()),2) as [licenseupdated]
  FROM [dbo].[license]
GO

insert into wid28.dbo.lichist
SELECT [stfips]
      ,[areatype]
      ,[area]
      ,[periodyear]
      ,[periodtype]
      ,[period]
      ,[licenseid]
      ,[licnumtype]
      ,[licnum]
  FROM [dbo].[lichist]
GO

----DEPRECATED 
--insert into wid28.dbo.mls
--SELECT [stfips]
--      ,[areatype]
--      ,[area]
--      ,[periodyear]
--      ,[periodtype]
--      ,[period]
--      ,[indcodty]
--      ,[indcode]
--      ,[ownership]
--      ,[gender]
--      ,[raceethn]
--      ,[agegroup]
--      ,[veteran]
--      ,[worksite]
--      ,[prisepcodetype]
--      ,[prisepcd]
--      ,[separat]
--      ,[claimants]
--      ,[events]
--      ,[suppress]
--  FROM [dbo].[mls]
--GO

----DEPRECATED 
--insert into wid28.dbo.mlsevent
--SELECT [stfips]
--      ,[areatype]
--      ,[area]
--      ,[periodyear]
--      ,[periodtype]
--      ,[period]
--      ,[uiaccount]
--      ,[eventid]
--      ,[siccode]
--      ,[naicscode]
--      ,[ownership]
--      ,[name1]
--      ,[name2]
--      ,[address1]
--      ,[city]
--      ,[st]
--      ,[zip]
--      ,[meeicode]
--      ,[telephone]
--      ,[teleext]
--      ,[worksite]
--      ,[preemp]
--      ,[separat]
--      ,[prisepcodetype]
--      ,[prisepcd]
--      ,[secsepcodetype]
--      ,[secsepcd]
--      ,[layweek]
--      ,[eventtype]
--      ,[dwvertype]
--  FROM [dbo].[mlsevent]
--GO

----DEPRECATED 
--insert into wid28.dbo.mlsclaim
--SELECT [stfips]
--      ,[areatype]
--      ,[area]
--      ,[periodyear]
--      ,[periodtype]
--      ,[period]
--      ,[uiaccount]
--      ,[eventid]
--      ,[ssn]
--      ,[gender]
--      ,[raceethn]
--      ,[birthday]
--      ,[veteran]
--      ,[finalpay]
--      ,[claimtype]
--      ,[finalweek]
--  FROM [dbo].[mlsclaim]
--GO

----DEPRECATED 
--insert into wid28.dbo.occprj
--SELECT [stfips]
--      ,[areatype]
--      ,[area]
--      ,[periodid]
--      ,[matoccode]
--      ,[estoccprj]
--      ,[projoccprj]
--      ,[grrate]
--      ,[nchg]
--      ,[pchg]
--      ,[aopeng]
--      ,[aopenr]
--      ,[aopent]
--      ,[growcode]
--      ,[suppress]
--  FROM [dbo].[occprj]
--GO

----CORE 
insert into wid28.dbo.iowage
SELECT [stfips]
      ,[areatype]
      ,[area]
      ,[periodyear]
      ,[periodtype]
      ,[period]
      ,[indcodty]
      ,[indcode]
      ,[occodetype]
      ,[occcode]
      ,[wagesource]
      ,[ratetype]
      ,[empcount]
      ,[response]
      ,[mean]
      ,[entrywg]
      ,[experience]
      ,[pct10]
      ,[pct25]
      ,[median]
      ,[pct75]
      ,[pct90]
      ,[udpct]
      ,[upctwage]
      ,[udrnglopct]
      ,[udrnghipct]
      ,[udrngmean]
      ,[wpctrelerr]
      ,[epctrelerr]
      ,[panelcode]
      ,[suppressall]
      ,[suppressemp]
      ,[suppresswage]
  FROM [dbo].[iowage]
GO

----DEPRECATED 
--insert into wid28.dbo.oeswage
--SELECT [stfips]
--      ,[areatype]
--      ,[area]
--      ,[periodyear]
--      ,[periodtype]
--      ,[period]
--      ,[indcodty]
--      ,[indcode]
--      ,[occodetype]
--      ,[occcode]
--      ,[wagesource]
--      ,[ratetype]
--      ,[empcount]
--      ,[response]
--      ,[mean]
--      ,[entrywg]
--      ,[experience]
--      ,[pct10]
--      ,[pct25]
--      ,[median]
--      ,[pct75]
--      ,[pct90]
--      ,[udpct]
--      ,[upctwage]
--      ,[udrnglopct]
--      ,[udrnghipct]
--      ,[udrngmean]
--      ,[wpctrelerr]
--      ,[epctrelerr]
--      ,[panelcode]
--      ,[suppress]
--      ,[meansup]
--      ,[entrywgsup]
--      ,[experiencesup]
--      ,[pct10sup]
--      ,[pct25sup]
--      ,[mediansup]
--      ,[pct75sup]
--      ,[pct90sup]
--      ,[udpctwagesup]
--      ,[udrngmeansup]
--  FROM [dbo].[oeswage]
--GO

insert into wid28.dbo.payment
SELECT [stfips]
      ,[areatype]
      ,[area]
      ,[periodyear]
      ,[periodtype]
      ,[period]
      ,[paytype]
      ,[amountpaid]
  FROM [dbo].[payment]
GO

insert into wid28.dbo.populatn
SELECT [stfips]
      ,[areatype]
      ,[area]
      ,[periodyear]
      ,[periodtype]
      ,[period]
      ,[popsource]
      ,[population]
      ,[releasedate]
  FROM [dbo].[populatn]
GO

insert into wid28.dbo.schools
SELECT [stfips]
      ,[areatype]
      ,[area]
      ,[instcode]
      ,[insttype]
      ,[instown]
      ,[instname1]
      ,[instname2]
      ,[address1]
      ,[address2]
      ,[city]
      ,[st]
      ,[zip]
      ,[zipext]
      ,[latitude]
      ,[longitude]
      ,[geopcode]
      ,[telephone]
      ,[teleext]
      ,[fax]
      ,[url]
      ,[contact]
      ,[distancelearn]
      ,[satellitecampus]
  FROM [dbo].[schools]
GO

insert into wid28.dbo.progcomp
SELECT [stfips]
      ,[areatype]
      ,[area]
      ,[instcode]
      ,[periodyear]
      ,[periodtype]
      ,[period]
      ,[codetype]
      ,[code]
      ,[compltype]
      ,[completers]
      ,[placecomp]
  FROM [dbo].[progcomp]
GO

----CHANGED IN V2.8 - ADD ETPL FLAG
insert into wid28.dbo.programs
SELECT [stfips]
      ,[areatype]
      ,[area]
      ,[instcode]
      ,[codetype]
      ,[code]
      ,[compltype]
      ,[length]
      ,[lengthtype]
      ,[progcost]
      ,[progtitle]
      ,[progdesc]
      ,[cipcodetype]
      ,[cipcode]
      ,[url]
      ,[classroom]
      ,[online]
      ,[classtime]
      ,null as [etplapproval]
  FROM [dbo].[programs]
GO

----DEPRECATED 
--insert into wid28.dbo.propval
--SELECT [stfips]
--      ,[areatype]
--      ,[area]
--      ,[periodyear]
--      ,[periodtype]
--      ,[period]
--      ,[taxtype]
--      ,[propvalue]
--      ,[taxvalue]
--      ,[millrate]
--  FROM [dbo].[propval]
--GO

insert into wid28.dbo.qwichar
SELECT [STFIPS]
      ,[AREATYPE]
      ,[AREA]
      ,[PERIODYEAR]
      ,[PERIODTYPE]
      ,[PERIOD]
      ,[INDCODTY]
      ,[INDCODE]
      ,[OWNERSHIP]
      ,[GENDER]
      ,[AGEGROUP]
      ,[QWIID]
  FROM [dbo].[qwichar]
GO

insert into wid28.dbo.qwidata
SELECT [STFIPS]
      ,[QWIID]
      ,[QWITYPE]
      ,[QWIVAQLUE]
      ,[QWISUP]
  FROM [dbo].[qwidata]
GO

insert into wid28.dbo.sales
SELECT [stfips]
      ,[areatype]
      ,[area]
      ,[periodyear]
      ,[periodtype]
      ,[period]
      ,[salestype]
      ,[sales]
  FROM [dbo].[sales]
GO

insert into wid28.dbo.stfirms
SELECT [stfips]
      ,[areatype]
      ,[area]
      ,[uiaccount]
      ,[reptunit]
      ,[yrqtr]
      ,[name1]
      ,[name2]
      ,[address1]
      ,[address2]
      ,[city]
      ,[st]
      ,[zip]
      ,[zipext]
      ,[addressty]
      ,[latitude]
      ,[longitude]
      ,[geopcode]
      ,[telephone]
      ,[teleext]
      ,[employment]
      ,[indcodetype]
      ,[indcode]
      ,[ownership]
      ,[sizeclass]
      ,[busdesc]
  FROM [dbo].[stfirms]
GO

----DEPRECATED 
--insert into wid28.dbo.stindprj
--SELECT [stfips]
--      ,[areatype]
--      ,[area]
--      ,[periodid]
--      ,[matincode]
--      ,[estindst]
--      ,[projindst]
--      ,[nchg]
--      ,[grrate]
--      ,[growcode]
--      ,[suppress]
--  FROM [dbo].[stindprj]
--GO

----DEPRECATED 
--insert into wid28.dbo.stoccprj
--SELECT [stfips]
--      ,[areatype]
--      ,[area]
--      ,[periodid]
--      ,[matoccode]
--      ,[estoccst]
--      ,[projoccst]
--      ,[nchg]
--      ,[grrate]
--      ,[aopeng]
--      ,[aopenr]
--      ,[aopent]
--      ,[growcode]
--      ,[suppress]
--  FROM [dbo].[stoccprj]
--GO

insert into wid28.dbo.supply
SELECT [stfips]
      ,[areatype]
      ,[area]
      ,[periodyear]
      ,[periodtype]
      ,[period]
      ,[insttype]
      ,[instown]
      ,[codetype]
      ,[code]
      ,[compltype]
      ,[completers]
  FROM [dbo].[supply]
GO

insert into wid28.dbo.tax
SELECT [stfips]
      ,[areatype]
      ,[area]
      ,[periodyear]
      ,[periodtype]
      ,[period]
      ,[taxtype]
      ,[taxrevenue]
  FROM [dbo].[tax]
GO

----CHANGED IN V2.8 -- ADD WEEKSCOMP AND FIRSTPAYMENTS
insert into wid28.dbo.uiclaims
SELECT [stfips]
      ,[areatype]
      ,[area]
      ,[periodyear]
      ,[periodtype]
      ,[period]
      ,[claimtype]
      ,[occodetype]
      ,[occcode]
      ,[indcodty]
      ,[indcode]
      ,[agegroup]
      ,[raceethn]
      ,[gender]
      ,[claimants]
      ,null as [weekscomp]
      ,null as [firstpayments]
      ,[duration]
  FROM [dbo].[uiclaims]
GO

----DEPRECATED 
--insert into wid28.dbo.url
--SELECT [urlid]
--      ,[url]
--      ,[urlname]
--      ,[urldesc]
--  FROM [dbo].[url]
--GO

----DEPRECATED 
--insert into wid28.dbo.urllinks
--SELECT [urlid]
--      ,[stfips]
--      ,[areatype]
--      ,[area]
--      ,[urltopic]
--  FROM [dbo].[urllinks]
--GO

----DEPRECATED 
--insert into wid28.dbo.wage
--SELECT [stfips]
--      ,[areatype]
--      ,[area]
--      ,[periodyear]
--      ,[periodtype]
--      ,[period]
--      ,[indcodty]
--      ,[indcode]
--      ,[occodetype]
--      ,[occcode]
--      ,[wagesource]
--      ,[ratetype]
--      ,[leveltype]
--      ,[stattype]
--      ,[wage]
--      ,[respondent]
--      ,[empcount]
--  FROM [dbo].[wage]
--GO

----DEPRECATED 
--insert into wid28.dbo.workstop
--SELECT [stfips]
--      ,[areatype]
--      ,[area]
--      ,[periodyear]
--      ,[periodtype]
--      ,[period]
--      ,[indcodty]
--      ,[indcode]
--      ,[ownership]
--      ,[stopstatus]
--      ,[firms]
--      ,[workers]
--      ,[daysidle]
--  FROM [dbo].[workstop]
--GO

insert into wid28.dbo.occxocc
SELECT [stfips]
      ,[codetype]
      ,[code]
      ,[codetype2]
      ,[code2]
  FROM [dbo].[occxocc]
GO

insert into wid28.dbo.indxind
SELECT [stfips]
      ,[codetype]
      ,[code]
      ,[codetype2]
      ,[code2]
  FROM [dbo].[indxind]
GO

----DEPRECATED 
--insert into wid28.dbo.matxoes
--SELECT [stfips]
--      ,[matoccode]
--      ,[periodid]
--      ,[oescode]
--      ,[subtot]
--  FROM [dbo].[matxoes]
--GO

----DEPRECATED 
--insert into wid28.dbo.matxsic
--SELECT [stfips]
--      ,[matincode]
--      ,[periodid]
--      ,[siccode]
--      ,[subtot]
--  FROM [dbo].[matxsic]
--GO

insert into wid28.dbo.clsxproj
SELECT [stfips]
      ,[areatype]
      ,[area]
      ,[cluscode]
      ,[occodetype]
      ,[occcode]
      ,[alloc]
  FROM [dbo].[clsxproj]
GO

insert into wid28.dbo.clsxsupl
SELECT [stfips]
      ,[areatype]
      ,[area]
      ,[periodyear]
      ,[periodtype]
      ,[period]
      ,[cluscode]
      ,[codetype]
      ,[code]
      ,[compltype]
  FROM [dbo].[clsxsupl]
GO

----DEPRECATED 
--insert into wid28.dbo.clusxpath
--SELECT [clustercode]
--      ,[pathcode]
--  FROM [dbo].[clusxpath]
--GO

----DEPRECATED 
--insert into wid28.dbo.clusxcip
--SELECT [stfips]
--      ,[codetype]
--      ,[code]
--      ,[clustercode]
--  FROM [dbo].[clusxcip]
--GO

----DEPRECATED 
--insert into wid28.dbo.clusxsoc
--SELECT [stfips]
--      ,[codetype]
--      ,[code]
--      ,[clustercode]
--  FROM [dbo].[clusxsoc]
--GO

----DEPRECATED 
--insert into wid28.dbo.cidsxcip
--SELECT [stfips]
--      ,[codetype]
--      ,[code]
--      ,[cidscode]
--  FROM [dbo].[cidsxcip]
--GO

----DEPRECATED 
--insert into wid28.dbo.dotxcip
--SELECT [dotcode]
--      ,[cipcode]
--      ,[cipcodetype]
--  FROM [dbo].[dotxcip]
--GO

----DEPRECATED 
--insert into wid28.dbo.dotxonet
--SELECT [dotcode]
--      ,[onetcode]
--  FROM [dbo].[dotxonet]
--GO

----DEPRECATED 
--insert into wid28.dbo.oesxcens
--SELECT [oescode]
--      ,[censcode]
--      ,[codetype]
--  FROM [dbo].[oesxcens]
--GO

----DEPRECATED 
--insert into wid28.dbo.oesxcids
--SELECT [oescode]
--      ,[cidscode]
--  FROM [dbo].[oesxcids]
--GO

----DEPRECATED 
--insert into wid28.dbo.oesxcip
--SELECT [oescode]
--      ,[cipcode]
--      ,[cipcodetype]
--  FROM [dbo].[oesxcip]
--GO

----DEPRECATED 
--insert into wid28.dbo.oesxdot
--SELECT [oescode]
--      ,[dotcode]
--  FROM [dbo].[oesxdot]
--GO

----DEPRECATED 
--insert into wid28.dbo.sicxnaic
--SELECT [siccode]
--      ,[naicscode]
--  FROM [dbo].[sicxnaic]
--GO

----DEPRECATED 
--insert into wid28.dbo.oesxonet
--SELECT [oescode]
--      ,[onetcode]
--  FROM [dbo].[oesxonet]
--GO

----DEPRECATED 
--insert into wid28.dbo.oesxjob
--SELECT [oescode]
--      ,[jobfamily]
--  FROM [dbo].[oesxjob]
--GO

insert into wid28.dbo.laytxocc
SELECT [stfips]
      ,[occodetype]
      ,[occcode]
      ,[laytlcode]
  FROM [dbo].[laytxocc]
GO

----CORE 
insert into wid28.dbo.licxocc
SELECT [stfips]
      ,[licenseid]
      ,[occodetype]
      ,[occcode]
  FROM [dbo].[licxocc]
GO

----DEPRECATED 
--insert into wid28.dbo.matxnaic
--SELECT [stfips]
--      ,[matincode]
--      ,[periodid]
--      ,[naicscode]
--      ,[subtot]
--  FROM [dbo].[matxnaic]
--GO

----CORE 
insert into wid28.dbo.matxind
SELECT [stfips]
      ,[matincode]
      ,[periodid]
      ,[indcodetype]
      ,[indcode]
      ,[subtot]
  FROM [dbo].[matxind]
GO

----CORE 
insert into wid28.dbo.matxocc
SELECT [stfips]
      ,[matoccode]
      ,[periodid]
      ,[occodetype]
      ,[occcode]
      ,[subtot]
  FROM [dbo].[matxocc]
GO

----DEPRECATED 
--insert into wid28.dbo.matxsoc
--SELECT [stfips]
--      ,[matoccode]
--      ,[periodid]
--      ,[soccode]
--      ,[subtot]
--  FROM [dbo].[matxsoc]
--GO

insert into wid28.dbo.mocxocc
SELECT [stfips]
      ,[codetype]
      ,[code]
      ,[svc]
      ,[mpc]
      ,[status]
      ,[moccode]
  FROM [dbo].[mocxocc]
GO

----DEPRECATED 
--insert into wid28.dbo.oesxsoc
--SELECT [oescode]
--      ,[soccode]
--      ,[soccodetype]
--  FROM [dbo].[oesxsoc]
--GO

----DEPRECATED 
--insert into wid28.dbo.socxcens
--SELECT [stfips]
--      ,[codetype]
--      ,[code]
--      ,[censcode]
--      ,[censcodetype]
--  FROM [dbo].[socxcens]
--GO

----DEPRECATED 
--insert into wid28.dbo.socxcids
--SELECT [stfips]
--      ,[codetype]
--      ,[code]
--      ,[cidscode]
--  FROM [dbo].[socxcids]
--GO

----DEPRECATED 
--insert into wid28.dbo.socxcip
--SELECT [stfips]
--      ,[codetype]
--      ,[code]
--      ,[cipcode]
--      ,[cipcodetype]
--  FROM [dbo].[socxcip]
--GO

----DEPRECATED 
--insert into wid28.dbo.socxdot
--SELECT [soccode]
--      ,[soccodetype]
--      ,[dotcode]
--  FROM [dbo].[socxdot]
--GO

----DEPRECATED 
--insert into wid28.dbo.socxjob
--SELECT [soccode]
--      ,[soccodetype]
--      ,[jobfamily]
--  FROM [dbo].[socxjob]
--GO

----DEPRECATED 
--insert into wid28.dbo.socxonet
--SELECT [stfips]
--      ,[codetype]
--      ,[code]
--      ,[onetcode]
--  FROM [dbo].[socxonet]
--GO

----DEPRECATED 
--insert into wid28.dbo.eeo1xcens
--SELECT [eeo1cat]
--      ,[censcode]
--      ,[censcodetype]
--  FROM [dbo].[eeo1xcens]
--GO

----DEPRECATED 
--insert into wid28.dbo.eeosxcens
--SELECT [eeostloc]
--      ,[censcode]
--      ,[censcodetype]
--  FROM [dbo].[eeosxcens]
--GO

insert into wid28.dbo.datasess
SELECT [appl]
      ,[session]
      ,[sessdesc]
      ,[suppavail]
  FROM [dbo].[datasess]
GO

insert into wid28.dbo.[source]
SELECT [stfips]
      ,[appl]
      ,[session]
      ,[source]
  FROM [dbo].[source]
GO

insert into wid28.dbo.maplist
SELECT [stfips]
      ,[areatype]
      ,[area]
      ,[periodyear]
      ,[periodtype]
      ,[period]
      ,[mapname]
      ,[mapdesc]
      ,[mapimage]
  FROM [dbo].[maplist]
GO

insert into wid28.dbo.tabllist
SELECT [tablename]
      ,[tabledesc]
      ,[tabletype]
  FROM [dbo].[tabllist]
GO

insert into wid28.dbo.sesstabl
SELECT [appl]
      ,[session]
      ,[tablename]
  FROM [dbo].[sesstabl]
GO

insert into wid28.dbo.tablsrce
SELECT [stfips]
      ,[tablename]
      ,[supplier]
      ,[contact]
      ,[telephone]
      ,[teleext]
      ,[lastupdate]
      ,[nextupdate]
      ,[filetype]
      ,[info]
  FROM [dbo].[tablsrce]
GO