create table groundview_update_profile_attribute
(
code TEXT,
ge_p0004cx DECIMAL(6,2),
ge_p0509cx DECIMAL(6,2),
ge_p1014cx DECIMAL(6,2),
ge_p1519cx DECIMAL(6,2),
ge_p2024cx DECIMAL(6,2),
ge_p2529cx DECIMAL(6,2),
ge_p3034cx DECIMAL(6,2),
ge_p3539cx DECIMAL(6,2),
ge_p4044cx DECIMAL(6,2),
ge_p4549cx DECIMAL(6,2),
ge_p5054cx DECIMAL(6,2),
ge_p5559cx DECIMAL(6,2),
ge_p6064cx DECIMAL(6,2),
ge_p6569cx DECIMAL(6,2),
ge_p7074cx DECIMAL(6,2),
ge_p7579cx DECIMAL(6,2),
ge_p8084cx DECIMAL(6,2),
ge_p85pcx DECIMAL(6,2),
ge_pmedcy DECIMAL(5,1),
ge_malecx DECIMAL(6,2),
ge_m0004cx DECIMAL(6,2),
ge_m0509cx DECIMAL(6,2),
ge_m1014cx DECIMAL(6,2),
ge_m1519cx DECIMAL(6,2),
ge_m2024cx DECIMAL(6,2),
ge_m2529cx DECIMAL(6,2),
ge_m3034cx DECIMAL(6,2),
ge_m3539cx DECIMAL(6,2),
ge_m4044cx DECIMAL(6,2),
ge_m4549cx DECIMAL(6,2),
ge_m5054cx DECIMAL(6,2),
ge_m5559cx DECIMAL(6,2),
ge_m6064cx DECIMAL(6,2),
ge_m6569cx DECIMAL(6,2),
ge_m7074cx DECIMAL(6,2),
ge_m7579cx DECIMAL(6,2),
ge_m8084cx DECIMAL(6,2),
ge_m85pcx DECIMAL(6,2),
ge_mmedcy DECIMAL(5,1),
ge_femalecx DECIMAL(6,2),
ge_f0004cx DECIMAL(6,2),
ge_f0509cx DECIMAL(6,2),
ge_f1014cx DECIMAL(6,2),
ge_f1519cx DECIMAL(6,2),
ge_f2024cx DECIMAL(6,2),
ge_f2529cx DECIMAL(6,2),
ge_f3034cx DECIMAL(6,2),
ge_f3539cx DECIMAL(6,2),
ge_f4044cx DECIMAL(6,2),
ge_f4549cx DECIMAL(6,2),
ge_f5054cx DECIMAL(6,2),
ge_f5559cx DECIMAL(6,2),
ge_f6064cx DECIMAL(6,2),
ge_f6569cx DECIMAL(6,2),
ge_f7074cx DECIMAL(6,2),
ge_f7579cx DECIMAL(6,2),
ge_f8084cx DECIMAL(6,2),
ge_f85pcx DECIMAL(6,2),
ge_fmedcy DECIMAL(5,1),
ge_whtpopcx DECIMAL(6,2),
ge_blkpopcx DECIMAL(6,2),
ge_indpopcx DECIMAL(6,2),
ge_asnpopcx DECIMAL(6,2),
ge_hpipopcx DECIMAL(6,2),
ge_othpopcx DECIMAL(6,2),
ge_twopopcx DECIMAL(6,2),
ge_hsppopcx DECIMAL(6,2),
ge_nhpopcx DECIMAL(6,2),
ge_ms2pnmcx DECIMAL(6,2),
ge_ms3pmarcx DECIMAL(6,2),
ge_ms4psepcx DECIMAL(6,2),
ge_ms5pwidcx DECIMAL(6,2),
ge_ms6pdivcx DECIMAL(6,2),
ge_wrknahcx DECIMAL(6,2),
ge_wrkahcx DECIMAL(6,2),
ge_mt01dacx DECIMAL(6,2),
ge_mt02cpcx DECIMAL(6,2),
ge_mt03buscx DECIMAL(6,2),
ge_mt04subcx DECIMAL(6,2),
ge_mt05railcx DECIMAL(6,2),
ge_mt06stccx DECIMAL(6,2),
ge_mt07boatcx DECIMAL(6,2),
ge_mt08taxicx DECIMAL(6,2),
ge_mt09mccx DECIMAL(6,2),
ge_mt10bikecx DECIMAL(6,2),
ge_mt11walkcx DECIMAL(6,2),
ge_mt12othcx DECIMAL(6,2),
ge_tt0004cx DECIMAL(6,2),
ge_tt0509cx DECIMAL(6,2),
ge_tt1014cx DECIMAL(6,2),
ge_tt1519cx DECIMAL(6,2),
ge_tt2024cx DECIMAL(6,2),
ge_tt2529cx DECIMAL(6,2),
ge_tt3034cx DECIMAL(6,2),
ge_tt3539cx DECIMAL(6,2),
ge_tt4044cx DECIMAL(6,2),
ge_tt4559cx DECIMAL(6,2),
ge_tt6089cx DECIMAL(6,2),
ge_tt90pcx DECIMAL(6,2),
ge_ttavgcy DECIMAL(5,1),
ge_ed02nsccx DECIMAL(6,2),
ge_ed03grn4cx DECIMAL(6,2),
ge_ed04gr56cx DECIMAL(6,2),
ge_ed05gr78cx DECIMAL(6,2),
ge_ed06gr9cx DECIMAL(6,2),
ge_ed07gr10cx DECIMAL(6,2),
ge_ed08gr11cx DECIMAL(6,2),
ge_ed09gr12cx DECIMAL(6,2),
ge_ed10hschcx DECIMAL(6,2),
ge_ed11sc1cx DECIMAL(6,2),
ge_ed12sc1pcx DECIMAL(6,2),
ge_ed13assocx DECIMAL(6,2),
ge_ed14bachcx DECIMAL(6,2),
ge_ed15mastcx DECIMAL(6,2),
ge_ed16profcx DECIMAL(6,2),
ge_ed17doctcx DECIMAL(6,2),
ge_es2lfcx DECIMAL(6,2),
ge_es3clfcx DECIMAL(6,2),
ge_es4clfecx DECIMAL(6,2),
ge_es5clfucx DECIMAL(6,2),
ge_es6afcx DECIMAL(6,2),
ge_es7nlfcx DECIMAL(6,2),
ge_in01agrcx DECIMAL(6,2),
ge_in02cnstcx DECIMAL(6,2),
ge_in03mfgcx DECIMAL(6,2),
ge_in04wtrdcx DECIMAL(6,2),
ge_in05rtrdcx DECIMAL(6,2),
ge_in06trancx DECIMAL(6,2),
ge_in07infocx DECIMAL(6,2),
ge_in08firecx DECIMAL(6,2),
ge_in09profcx DECIMAL(6,2),
ge_in10educcx DECIMAL(6,2),
ge_in11artscx DECIMAL(6,2),
ge_in12othscx DECIMAL(6,2),
ge_in13publcx DECIMAL(6,2),
ge_oc01mgntcx DECIMAL(6,2),
ge_oc02bfopcx DECIMAL(6,2),
ge_oc03compcx DECIMAL(6,2),
ge_oc04archcx DECIMAL(6,2),
ge_oc05lifecx DECIMAL(6,2),
ge_oc06csscx DECIMAL(6,2),
ge_oc07leglcx DECIMAL(6,2),
ge_oc08etlcx DECIMAL(6,2),
ge_oc09artscx DECIMAL(6,2),
ge_oc10hltdcx DECIMAL(6,2),
ge_oc11hlttcx DECIMAL(6,2),
ge_oc12hltscx DECIMAL(6,2),
ge_oc13firecx DECIMAL(6,2),
ge_oc14lawcx DECIMAL(6,2),
ge_oc15foodcx DECIMAL(6,2),
ge_oc16bldgcx DECIMAL(6,2),
ge_oc17perscx DECIMAL(6,2),
ge_oc18salecx DECIMAL(6,2),
ge_oc19admncx DECIMAL(6,2),
ge_oc20farmcx DECIMAL(6,2),
ge_oc21cnstcx DECIMAL(6,2),
ge_oc22instcx DECIMAL(6,2),
ge_oc23prodcx DECIMAL(6,2),
ge_oc24trancx DECIMAL(6,2),
ge_oc25matlcx DECIMAL(6,2),
ge_oc26wccx DECIMAL(6,2),
ge_oc27bccx DECIMAL(6,2),
ge_avghhszcy DECIMAL(6,2),
ge_hhs1percx DECIMAL(6,2),
ge_hhs2percx DECIMAL(6,2),
ge_hhs3percx DECIMAL(6,2),
ge_hhs4percx DECIMAL(6,2),
ge_hhs5percx DECIMAL(6,2),
ge_hhs6percx DECIMAL(6,2),
ge_hhs7percx DECIMAL(6,2),
ge_owncx DECIMAL(6,2),
ge_rntcx DECIMAL(6,2),
ge_hh1whtcx DECIMAL(6,2),
ge_hh2blkcx DECIMAL(6,2),
ge_hh3indcx DECIMAL(6,2),
ge_hh4asncx DECIMAL(6,2),
ge_hh5hpicx DECIMAL(6,2),
ge_hh6othcx DECIMAL(6,2),
ge_hh7twocx DECIMAL(6,2),
ge_nhhhcx DECIMAL(6,2),
ge_hsphhcx DECIMAL(6,2),
ge_hhu01cx DECIMAL(6,2),
ge_hhu01acx DECIMAL(6,2),
ge_hhu02cx DECIMAL(6,2),
ge_hhu0304cx DECIMAL(6,2),
ge_hhu0509cx DECIMAL(6,2),
ge_hhu1019cx DECIMAL(6,2),
ge_hhu2049cx DECIMAL(6,2),
ge_hhu50pcx DECIMAL(6,2),
ge_hhumhcx DECIMAL(6,2),
ge_hhurvcx DECIMAL(6,2),
ge_hhf1gascx DECIMAL(6,2),
ge_hhf2lpcx DECIMAL(6,2),
ge_hhf3eleccx DECIMAL(6,2),
ge_hhf4oilcx DECIMAL(6,2),
ge_hhf5coalcx DECIMAL(6,2),
ge_hhf6woodcx DECIMAL(6,2),
ge_hhf7suncx DECIMAL(6,2),
ge_hhf8othcx DECIMAL(6,2),
ge_hhf9nfucx DECIMAL(6,2),
ge_hhveh0cx DECIMAL(6,2),
ge_hhveh1cx DECIMAL(6,2),
ge_hhveh2cx DECIMAL(6,2),
ge_hhveh3cx DECIMAL(6,2),
ge_hhveh4cx DECIMAL(6,2),
ge_hhveh5pcx DECIMAL(6,2),
ge_hhvavgcy DECIMAL(5,1),
ge_crcashcx DECIMAL(6,2),
ge_cr0000cx DECIMAL(6,2),
ge_cr0100cx DECIMAL(6,2),
ge_cr0150cx DECIMAL(6,2),
ge_cr0200cx DECIMAL(6,2),
ge_cr0250cx DECIMAL(6,2),
ge_cr0300cx DECIMAL(6,2),
ge_cr0350cx DECIMAL(6,2),
ge_cr0400cx DECIMAL(6,2),
ge_cr0450cx DECIMAL(6,2),
ge_cr0500cx DECIMAL(6,2),
ge_cr0550cx DECIMAL(6,2),
ge_cr0600cx DECIMAL(6,2),
ge_cr0650cx DECIMAL(6,2),
ge_cr0700cx DECIMAL(6,2),
ge_cr0750cx DECIMAL(6,2),
ge_cr0800cx DECIMAL(6,2),
ge_cr0900cx DECIMAL(6,2),
ge_cr1000cx DECIMAL(6,2),
ge_cr1250cx DECIMAL(6,2),
ge_cr1500cx DECIMAL(6,2),
ge_cr2000cx DECIMAL(6,2),
ge_cr2500cx DECIMAL(6,2),
ge_cr3000cx DECIMAL(6,2),
ge_cr3500pcx DECIMAL(6,2),
ge_crnocashcx DECIMAL(6,2),
ge_crmedcy DECIMAL(6,0),
ge_cravgcy DECIMAL(6,0),
ge_hv0000kcx DECIMAL(6,2),
ge_hv0010kcx DECIMAL(6,2),
ge_hv0015kcx DECIMAL(6,2),
ge_hv0020kcx DECIMAL(6,2),
ge_hv0025kcx DECIMAL(6,2),
ge_hv0030kcx DECIMAL(6,2),
ge_hv0035kcx DECIMAL(6,2),
ge_hv0040kcx DECIMAL(6,2),
ge_hv0050kcx DECIMAL(6,2),
ge_hv0060kcx DECIMAL(6,2),
ge_hv0070kcx DECIMAL(6,2),
ge_hv0080kcx DECIMAL(6,2),
ge_hv0090kcx DECIMAL(6,2),
ge_hv0100kcx DECIMAL(6,2),
ge_hv0125kcx DECIMAL(6,2),
ge_hv0150kcx DECIMAL(6,2),
ge_hv0175kcx DECIMAL(6,2),
ge_hv0200kcx DECIMAL(6,2),
ge_hv0250kcx DECIMAL(6,2),
ge_hv0300kcx DECIMAL(6,2),
ge_hv0400kcx DECIMAL(6,2),
ge_hv0500kcx DECIMAL(6,2),
ge_hv0750kcx DECIMAL(6,2),
ge_hv1000kcx DECIMAL(6,2),
ge_hv1500kcx DECIMAL(6,2),
ge_hv2000kpcx DECIMAL(6,2),
ge_hvmedcy DECIMAL(8,0),
ge_hvavgcy DECIMAL(8,0),
ge_hha1524cx DECIMAL(6,2),
ge_hha2534cx DECIMAL(6,2),
ge_hha3544cx DECIMAL(6,2),
ge_hha4554cx DECIMAL(6,2),
ge_hha5559cx DECIMAL(6,2),
ge_hha6064cx DECIMAL(6,2),
ge_hha6574cx DECIMAL(6,2),
ge_hha7584cx DECIMAL(6,2),
ge_hha85pcx DECIMAL(6,2),
ge_hi000kcx DECIMAL(6,2),
ge_hi010kcx DECIMAL(6,2),
ge_hi015kcx DECIMAL(6,2),
ge_hi020kcx DECIMAL(6,2),
ge_hi025kcx DECIMAL(6,2),
ge_hi030kcx DECIMAL(6,2),
ge_hi035kcx DECIMAL(6,2),
ge_hi040kcx DECIMAL(6,2),
ge_hi045kcx DECIMAL(6,2),
ge_hi050kcx DECIMAL(6,2),
ge_hi060kcx DECIMAL(6,2),
ge_hi075kcx DECIMAL(6,2),
ge_hi100kcx DECIMAL(6,2),
ge_hi125kcx DECIMAL(6,2),
ge_hi150kcx DECIMAL(6,2),
ge_hi200pcx DECIMAL(6,2),
ge_himedcy DECIMAL(6,0),
ge_hiavgcy DECIMAL(6,0),
)