"TABLE_NAME"|"COLUMN_NAME"|"DATA_TYPE"|"CHARACTER_MAXIMUM_LENGTH"|"NUMERIC_PRECISION"|"NUMERIC_SCALE"
"CAMAEXTRACTWEBVERSION"|"VersionId"|"int"|""|"10"|"0"
"CAMAEXTRACTWEBVERSION"|"VersionNumber"|"nvarchar"|"50"|""|""
"CAMAEXTRACTWEBVERSION"|"Description"|"nvarchar"|"-1"|""|""
"CAMAEXTRACTWEBVERSION"|"AppliedDate"|"datetime"|""|""|""
"CAMAEXTRACTWEBVERSION"|"AppliedBy"|"nvarchar"|"100"|""|""
"EXTRACT_ADDRESS"|"FISCAL_YEAR"|"varchar"|"4"|""|""
"EXTRACT_ADDRESS"|"RE_YEAR"|"varchar"|"4"|""|""
"EXTRACT_ADDRESS"|"ADR_PID"|"numeric"|""|"9"|"0"
"EXTRACT_ADDRESS"|"ADR_LINE_NUM"|"numeric"|""|"9"|"0"
"EXTRACT_ADDRESS"|"ADR_TYPE"|"varchar"|"2"|""|""
"EXTRACT_ADDRESS"|"ADR_LOCN"|"varchar"|"100"|""|""
"EXTRACT_ADDRESS"|"ADR_STR_PFX"|"varchar"|"5"|""|""
"EXTRACT_ADDRESS"|"ADR_STREET"|"varchar"|"40"|""|""
"EXTRACT_ADDRESS"|"ADR_STR_SFX"|"varchar"|"5"|""|""
"EXTRACT_ADDRESS"|"ADR_NUM"|"numeric"|""|"9"|"0"
"EXTRACT_ADDRESS"|"ADR_NUM_CHAR"|"varchar"|"15"|""|""
"EXTRACT_ADDRESS"|"ADR_CITY"|"varchar"|"18"|""|""
"EXTRACT_ADDRESS"|"ADR_STT"|"varchar"|"2"|""|""
"EXTRACT_ADDRESS"|"ADR_ZIP"|"varchar"|"12"|""|""
"EXTRACT_ADDRESS"|"ADR_APT"|"varchar"|"12"|""|""
"EXTRACT_ADDRESS"|"ADR_BLDG_NUM"|"numeric"|""|"9"|"0"
"EXTRACT_ADDRESS"|"ADR_IS_PRIMARY"|"numeric"|""|"9"|"0"
"EXTRACT_ADDRESS"|"ADR_NUM_HIGH"|"numeric"|""|"9"|"0"
"EXTRACT_ADDRESS"|"ADR_NUM_CHAR_HIGH"|"varchar"|"15"|""|""
"EXTRACT_ADDRESS"|"ADR_LAST_UPDATE"|"datetime"|""|""|""
"EXTRACT_ADDRESS"|"ADR_ADDRESS_ID"|"numeric"|""|"9"|"0"
"EXTRACT_ADDRESS"|"ADR_BOX_NUMBER"|"varchar"|"9"|""|""
"EXTRACT_ADDRESS"|"ADR_COUNTRY"|"varchar"|"50"|""|""
"EXTRACT_ADDRESS"|"ADR_COUNTY"|"varchar"|"50"|""|""
"EXTRACT_ADDRESS"|"ADR_ADDRESS_INFO"|"varchar"|"250"|""|""
"EXTRACT_ADDRESS"|"ADR_POST_DIRECTION"|"varchar"|"3"|""|""
"EXTRACT_ADDRESS"|"ADR_PRE_DIRECTION"|"varchar"|"3"|""|""
"EXTRACT_ADDRESS"|"ADR_STREET_TYPE"|"varchar"|"10"|""|""
"EXTRACT_ADDRESS"|"ADR_UNIT_TYPE"|"varchar"|"10"|""|""
"EXTRACT_ADDRESS"|"ADR_STREET_NUMBER_PREFIX"|"varchar"|"25"|""|""
"EXTRACT_ADDRESS"|"ADR_STREET_NUMBER_SUFFIX"|"varchar"|"25"|""|""
"EXTRACT_ADDRESS"|"ADR_PRCL_LOCN_ADDRESS_ID"|"varchar"|"100"|""|""
"EXTRACT_ADDRESS"|"REM_ACCT_NUM"|"varchar"|"30"|""|""
"EXTRACT_ADDRESS"|"REM_PARCEL_STATUS"|"varchar"|"1"|""|""
"EXTRACT_AHDATE"|"FISCAL_YEAR"|"varchar"|"4"|""|""
"EXTRACT_AHDATE"|"RE_YEAR"|"varchar"|"4"|""|""
"EXTRACT_AHDATE"|"AHD_MNC"|"numeric"|""|"9"|"0"
"EXTRACT_AHDATE"|"AHD_PID"|"numeric"|""|"9"|"0"
"EXTRACT_AHDATE"|"AHD_SAVE_NUM"|"numeric"|""|"9"|"0"
"EXTRACT_AHDATE"|"AHD_SAVE_DATE"|"datetime2"|""|""|""
"EXTRACT_AHDATE"|"AHD_FISCAL_YR"|"numeric"|""|"9"|"0"
"EXTRACT_AHDATE"|"AHD_FINAL_SAVE"|"numeric"|""|"9"|"0"
"EXTRACT_AHDATE"|"AHD_TTL_APPRAIS_BLDG"|"numeric"|""|"12"|"0"
"EXTRACT_AHDATE"|"AHD_TTL_ASSESS_BLDG"|"numeric"|""|"12"|"0"
"EXTRACT_AHDATE"|"AHD_TTL_APPRAIS_IMPROVEMENTS"|"numeric"|""|"12"|"0"
"EXTRACT_AHDATE"|"AHD_TTL_ASSESS_IMPROVEMENTS"|"numeric"|""|"12"|"0"
"EXTRACT_AHDATE"|"AHD_TTL_APPRAIS_LND"|"numeric"|""|"12"|"0"
"EXTRACT_AHDATE"|"AHD_TTL_ASSESS_LND"|"numeric"|""|"12"|"0"
"EXTRACT_AHDATE"|"AHD_TTL_APPRAIS"|"numeric"|""|"12"|"0"
"EXTRACT_AHDATE"|"AHD_TTL_ASSESS"|"numeric"|""|"12"|"0"
"EXTRACT_AHDATE"|"AHD_TTL_APPRAIS_ALT"|"numeric"|""|"12"|"0"
"EXTRACT_AHDATE"|"AHD_TTL_ASSESS_ALT"|"numeric"|""|"12"|"0"
"EXTRACT_AHDATE"|"AHD_LAST_UPDATE"|"datetime"|""|""|""
"EXTRACT_AHDATE"|"AHD_ASSESSMENT_RATIO"|"numeric"|""|"7"|"4"
"EXTRACT_AHDATE"|"AHD_MRKT_APPRAIS_VAL"|"numeric"|""|"12"|"0"
"EXTRACT_AHDATE"|"AHD_MRKT_ASSESS_VAL"|"numeric"|""|"12"|"0"
"EXTRACT_AHDATE"|"AHD_TTL_APPRAIS_LND_ALT"|"numeric"|""|"12"|"0"
"EXTRACT_AHDATE"|"AHD_TTL_ASSESS_LND_ALT"|"numeric"|""|"12"|"0"
"EXTRACT_AHDATE"|"REM_ACCT_NUM"|"varchar"|"30"|""|""
"EXTRACT_AHDATE"|"REM_PARCEL_STATUS"|"varchar"|"1"|""|""
"EXTRACT_AHDATE"|"AHD_TTL_EXEMPT"|"numeric"|""|"12"|"2"
"EXTRACT_BUILDINGS"|"FISCAL_YEAR"|"varchar"|"4"|""|""
"EXTRACT_BUILDINGS"|"RE_YEAR"|"varchar"|"4"|""|""
"EXTRACT_BUILDINGS"|"BLD_MNC"|"numeric"|""|"9"|"0"
"EXTRACT_BUILDINGS"|"BLD_PID"|"numeric"|""|"9"|"0"
"EXTRACT_BUILDINGS"|"BLD_BID"|"numeric"|""|"9"|"0"
"EXTRACT_BUILDINGS"|"BLD_BLDG_NUM"|"numeric"|""|"9"|"0"
"EXTRACT_BUILDINGS"|"BLD_NOTES1"|"varchar"|"40"|""|""
"EXTRACT_BUILDINGS"|"BLD_NOTES2"|"varchar"|"40"|""|""
"EXTRACT_BUILDINGS"|"BLD_NOTES3"|"varchar"|"40"|""|""
"EXTRACT_BUILDINGS"|"BLD_NOTES4"|"varchar"|"40"|""|""
"EXTRACT_BUILDINGS"|"BLD_NOTES5"|"varchar"|"40"|""|""
"EXTRACT_BUILDINGS"|"BLD_NOTES6"|"varchar"|"40"|""|""
"EXTRACT_BUILDINGS"|"BLD_NOTES7"|"varchar"|"40"|""|""
"EXTRACT_BUILDINGS"|"BLD_NOTES8"|"varchar"|"40"|""|""
"EXTRACT_BUILDINGS"|"BLD_NOTES9"|"varchar"|"40"|""|""
"EXTRACT_BUILDINGS"|"BLD_NOTES10"|"varchar"|"40"|""|""
"EXTRACT_BUILDINGS"|"BLD_NOTES11"|"varchar"|"40"|""|""
"EXTRACT_BUILDINGS"|"BLD_FRONTAGE"|"numeric"|""|"7"|"2"
"EXTRACT_BUILDINGS"|"BLD_DEPTH"|"numeric"|""|"7"|"2"
"EXTRACT_BUILDINGS"|"BLD_PERIMETER"|"numeric"|""|"7"|"2"
"EXTRACT_BUILDINGS"|"BLD_LAST_UPDATE"|"datetime"|""|""|""
"EXTRACT_BUILDINGS"|"REM_ACCT_NUM"|"varchar"|"30"|""|""
"EXTRACT_BUILDINGS"|"REM_PARCEL_STATUS"|"varchar"|"1"|""|""
"EXTRACT_CONSTRUCTION"|"FISCAL_YEAR"|"varchar"|"4"|""|""
"EXTRACT_CONSTRUCTION"|"RE_YEAR"|"varchar"|"4"|""|""
"EXTRACT_CONSTRUCTION"|"CONSTR_CNS_MNC"|"numeric"|""|"9"|"0"
"EXTRACT_CONSTRUCTION"|"CONSTR_CNS_PID"|"numeric"|""|"9"|"0"
"EXTRACT_CONSTRUCTION"|"CONSTR_CNS_BID"|"numeric"|""|"9"|"0"
"EXTRACT_CONSTRUCTION"|"CONSTR_CNS_BID_IDENT"|"numeric"|""|"9"|"0"
"EXTRACT_CONSTRUCTION"|"CONSTR_CNS_STYLE"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CONSTR_CNS_STYLE_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CONSTR_CNS_BASE_RATE"|"numeric"|""|"9"|"2"
"EXTRACT_CONSTRUCTION"|"CONSTR_CNS_IS_CMRCL"|"numeric"|""|"9"|"0"
"EXTRACT_CONSTRUCTION"|"CONSTR_CNS_IS_CONDO"|"numeric"|""|"9"|"0"
"EXTRACT_CONSTRUCTION"|"CONSTR_CNS_IS_CONDO_MAIN"|"numeric"|""|"9"|"0"
"EXTRACT_CONSTRUCTION"|"CONSTR_CNS_IS_VACANT"|"numeric"|""|"9"|"0"
"EXTRACT_CONSTRUCTION"|"CONSTR_CNS_ISRES"|"bit"|""|""|""
"EXTRACT_CONSTRUCTION"|"CONSTR_CNS_MDL"|"varchar"|"4"|""|""
"EXTRACT_CONSTRUCTION"|"CONSTR_CNS_MDL_DESC"|"varchar"|"20"|""|""
"EXTRACT_CONSTRUCTION"|"CONSTR_CNS_SIZ_ADJ_FACTOR"|"numeric"|""|"8"|"5"
"EXTRACT_CONSTRUCTION"|"CONSTR_CNS_AREA_EFFECTIVE"|"numeric"|""|"9"|"0"
"EXTRACT_CONSTRUCTION"|"CONSTR_CNS_AREA_GROSS"|"numeric"|""|"9"|"0"
"EXTRACT_CONSTRUCTION"|"CONSTR_CNS_AREA_LIVING"|"numeric"|""|"9"|"0"
"EXTRACT_CONSTRUCTION"|"CONSTR_CNS_REPLACE_COST"|"numeric"|""|"11"|"0"
"EXTRACT_CONSTRUCTION"|"CONSTR_CNS_APPRAIS_VAL"|"numeric"|""|"11"|"0"
"EXTRACT_CONSTRUCTION"|"CONSTR_CNS_REAL_APPRAIS_VAL"|"numeric"|""|"11"|"0"
"EXTRACT_CONSTRUCTION"|"CONSTR_CNS_ASSESS_VAL"|"numeric"|""|"11"|"0"
"EXTRACT_CONSTRUCTION"|"CONSTR_CNS_REAL_ASSESS_VAL"|"numeric"|""|"11"|"0"
"EXTRACT_CONSTRUCTION"|"CONSTR_CNS_OVERRIDE_VAL"|"numeric"|""|"11"|"0"
"EXTRACT_CONSTRUCTION"|"CONSTR_CNS_OVERRIDE_INITIALS"|"varchar"|"4"|""|""
"EXTRACT_CONSTRUCTION"|"CONSTR_CNS_STATUS_DATE"|"datetime2"|""|""|""
"EXTRACT_CONSTRUCTION"|"CONSTR_CNS_REGRESSION_VAL"|"numeric"|""|"11"|"0"
"EXTRACT_CONSTRUCTION"|"CONSTR_CNS_OCC"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CONSTR_CNS_OCC_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CONSTR_CNS_BLDG_STORIES"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CONSTR_CNS_GROUP"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CONSTR_CNS_STRUCT_CLASS"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CONSTR_CNS_IS_EXE1"|"numeric"|""|"1"|"0"
"EXTRACT_CONSTRUCTION"|"CONSTR_CNS_IS_EXE1_PCT"|"numeric"|""|"4"|"0"
"EXTRACT_CONSTRUCTION"|"CONSTR_CNS_IS_EXE2"|"numeric"|""|"1"|"0"
"EXTRACT_CONSTRUCTION"|"CONSTR_CNS_IS_EXE2_PCT"|"numeric"|""|"4"|"0"
"EXTRACT_CONSTRUCTION"|"CONSTR_CNS_OVERRIDE_VAL_ASSESS"|"numeric"|""|"11"|"0"
"EXTRACT_CONSTRUCTION"|"CONSTR_CNS_ALT_CODE_1"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CONSTR_CNS_ALT_ISSUED_1"|"numeric"|""|"4"|"0"
"EXTRACT_CONSTRUCTION"|"CONSTR_CNS_ALT_COMPLETE_1"|"numeric"|""|"4"|"0"
"EXTRACT_CONSTRUCTION"|"CONSTR_CNS_ALT_CODE_2"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CONSTR_CNS_ALT_ISSUED_2"|"numeric"|""|"4"|"0"
"EXTRACT_CONSTRUCTION"|"CONSTR_CNS_ALT_COMPLETE_2"|"numeric"|""|"4"|"0"
"EXTRACT_CONSTRUCTION"|"CONSTR_CNS_BIS_CODE"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CONSTR_CNS_BIS_CODE_DESC"|"varchar"|"50"|""|""
"EXTRACT_CONSTRUCTION"|"CONSTR_CNS_BIS_PCT"|"numeric"|""|"9"|"0"
"EXTRACT_CONSTRUCTION"|"CONSTR_CNS_BLD_STATUS"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CONSTR_CNS_BLD_STATUS_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CONSTR_CNS_COM_UNITS"|"numeric"|""|"9"|"0"
"EXTRACT_CONSTRUCTION"|"CONSTR_CNS_RES_UNITS"|"numeric"|""|"9"|"0"
"EXTRACT_CONSTRUCTION"|"CONSTR_CNS_OOSF"|"numeric"|""|"9"|"0"
"EXTRACT_CONSTRUCTION"|"CONSTR_CNS_ALT_CODE_1_DESC"|"varchar"|"50"|""|""
"EXTRACT_CONSTRUCTION"|"CONSTR_CNS_ALT_CODE_2_DESC"|"varchar"|"50"|""|""
"EXTRACT_CONSTRUCTION"|"CONSTR_CNS_USE_APEX"|"numeric"|""|"1"|"0"
"EXTRACT_CONSTRUCTION"|"CONSTR_CNS_AREA_DEMO"|"numeric"|""|"9"|"0"
"EXTRACT_CONSTRUCTION"|"CONSTR_CNS_DEMO_COST"|"numeric"|""|"12"|"2"
"EXTRACT_CONSTRUCTION"|"CONSTR_CNS_IS_EXE1_VAL"|"numeric"|""|"13"|"2"
"EXTRACT_CONSTRUCTION"|"CONSTR_CNS_IS_EXE2_VAL"|"numeric"|""|"13"|"2"
"EXTRACT_CONSTRUCTION"|"CONSTR_CNS_RES_SQFT"|"numeric"|""|"11"|"0"
"EXTRACT_CONSTRUCTION"|"CONSTR_CNS_COM_SQFT"|"numeric"|""|"11"|"0"
"EXTRACT_CONSTRUCTION"|"CONSTR_CNS_TTL_SQFT"|"numeric"|""|"11"|"0"
"EXTRACT_CONSTRUCTION"|"CONSTR_CNS_IS_HOMESITE"|"bit"|""|""|""
"EXTRACT_CONSTRUCTION"|"CONSTRDEP_CNS_AYB"|"numeric"|""|"9"|"0"
"EXTRACT_CONSTRUCTION"|"CONSTRDEP_CNS_YEAR_REMODEL"|"numeric"|""|"9"|"0"
"EXTRACT_CONSTRUCTION"|"CONSTRDEP_CNS_EYB"|"numeric"|""|"9"|"0"
"EXTRACT_CONSTRUCTION"|"CONSTRDEP_CNS_EYB_DPR"|"numeric"|""|"9"|"0"
"EXTRACT_CONSTRUCTION"|"CONSTRDEP_CNS_EYB_OVR"|"numeric"|""|"9"|"0"
"EXTRACT_CONSTRUCTION"|"CONSTRDEP_CNS_EYB_CODE"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CONSTRDEP_CNS_PCT_GOOD"|"numeric"|""|"25"|"14"
"EXTRACT_CONSTRUCTION"|"CONSTRDEP_CNS_FUNC_OBSOL"|"numeric"|""|"25"|"14"
"EXTRACT_CONSTRUCTION"|"CONSTRDEP_CNS_ECON_OBSOL"|"numeric"|""|"25"|"14"
"EXTRACT_CONSTRUCTION"|"CONSTRDEP_CNS_REMOD_EXT"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CONSTRDEP_CNS_REMOD_EXT_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CONSTRDEP_CNS_REG_PCT_GOOD"|"numeric"|""|"9"|"0"
"EXTRACT_CONSTRUCTION"|"CONSTRDEP_CNS_STATUS"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CONSTRDEP_CNS_PCT_COMPLETE"|"numeric"|""|"9"|"0"
"EXTRACT_CONSTRUCTION"|"CNS_GRADE"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_GRADE_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_STORIES"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_STORIES_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_OCC_BUILDING"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_OCC_BUILDING_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_EXT_WALL_1"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_EXT_WALL_1_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_ROOF_STRUCT"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_ROOF_STRUCT_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_ROOF_COVER"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_ROOF_COVER_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_INT_WALL_1"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_INT_WALL_1_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_HEAT_TYPE"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_HEAT_TYPE_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_AC_TYPE"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_AC_TYPE_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_FIREPLACES"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"RES_CNS_FIREPLACES_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_INT_CNDTN"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_INT_CNDTN_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_EXT_CNDTN"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_EXT_CNDTN_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_FOUNDATION"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_FOUNDATION_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_NUM_RMS"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_NUM_RMS_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_NUM_BEDRM"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_NUM_BEDRM_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_NUM_BATHRM"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_NUM_BATHRM_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_NUM_HALF_BATHS"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_NUM_HALF_BATHS_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_NUM_XTRA_FIX"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_NUM_XTRA_FIX_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_BATHRM_STYLE"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_BATHRM_STYLE_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_BATHRM_STYLE2"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_BATHRM_STYLE2_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_BATHRM_STYLE3"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_BATHRM_STYLE3_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"RES_CNS_NUM_KITCHENS"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_KITCHEN_STYLE"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_KITCHEN_STYLE_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_VIEW"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_VIEW_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_USRFLD_81"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_USRFLD_81_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_USRFLD_82"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_USRFLD_82_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_NUM_PARK"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_STYLE_SECT"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_STYLE_DESC_SECT"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_USRFLD_100"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_USRFLD_100_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_USRFLD_101"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_USRFLD_101_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_USRFLD_102"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_USRFLD_102_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_USRFLD_103"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_USRFLD_103_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_USRFLD_104"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_USRFLD_104_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_USRFLD_105"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_USRFLD_105_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_USRFLD_106"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_USRFLD_106_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_USRFLD_107"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_USRFLD_107_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_USRFLD_108"|"varchar"|"20"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_USRFLD_108_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_GROUP_SECT"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_AREA_EFFECTIVE_SECT"|"numeric"|""|"9"|"0"
"EXTRACT_CONSTRUCTION"|"CNS_AREA_GROSS_SECT"|"numeric"|""|"9"|"0"
"EXTRACT_CONSTRUCTION"|"CNS_AREA_LIVING_SECT"|"numeric"|""|"9"|"0"
"EXTRACT_CONSTRUCTION"|"CNS_AREA_DEMO"|"numeric"|""|"9"|"0"
"EXTRACT_CONSTRUCTION"|"CNS_BASE_RATE"|"numeric"|""|"9"|"2"
"EXTRACT_CONSTRUCTION"|"CNS_ADJ_BASE_RATE"|"numeric"|""|"9"|"2"
"EXTRACT_CONSTRUCTION"|"CNS_SQFT_WITH_GRADE"|"numeric"|""|"12"|"3"
"EXTRACT_CONSTRUCTION"|"CNS_SQFT_WITHOUT_GRADE"|"numeric"|""|"12"|"3"
"EXTRACT_CONSTRUCTION"|"CNS_USRFLD_300"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_USRFLD_300_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_USRFLD_301"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_USRFLD_301_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_USRFLD_302"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_USRFLD_302_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_USRFLD_303"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_USRFLD_303_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_USRFLD_304"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_USRFLD_304_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_USRFLD_305"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_USRFLD_305_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_USRFLD_600"|"varchar"|"500"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_USRFLD_601"|"varchar"|"500"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_USRFLD_700"|"numeric"|""|"12"|"0"
"EXTRACT_CONSTRUCTION"|"CNS_USRFLD_701"|"numeric"|""|"12"|"0"
"EXTRACT_CONSTRUCTION"|"CNS_USRFLD_800"|"numeric"|""|"25"|"14"
"EXTRACT_CONSTRUCTION"|"CNS_USRFLD_801"|"numeric"|""|"25"|"14"
"EXTRACT_CONSTRUCTION"|"CNS_USRFLD_900"|"numeric"|""|"1"|"0"
"EXTRACT_CONSTRUCTION"|"CNS_USRFLD_901"|"numeric"|""|"1"|"0"
"EXTRACT_CONSTRUCTION"|"CNS_USRFLD_702"|"numeric"|""|"12"|"0"
"EXTRACT_CONSTRUCTION"|"CNS_USRFLD_703"|"numeric"|""|"12"|"0"
"EXTRACT_CONSTRUCTION"|"CNS_USRFLD_704"|"numeric"|""|"12"|"0"
"EXTRACT_CONSTRUCTION"|"CNS_USRFLD_705"|"numeric"|""|"12"|"0"
"EXTRACT_CONSTRUCTION"|"CNS_USRFLD_706"|"numeric"|""|"12"|"0"
"EXTRACT_CONSTRUCTION"|"CNS_USRFLD_707"|"numeric"|""|"12"|"0"
"EXTRACT_CONSTRUCTION"|"CNS_USRFLD_708"|"numeric"|""|"12"|"0"
"EXTRACT_CONSTRUCTION"|"CNS_USRFLD_709"|"numeric"|""|"12"|"0"
"EXTRACT_CONSTRUCTION"|"CNS_USRFLD_710"|"numeric"|""|"12"|"0"
"EXTRACT_CONSTRUCTION"|"CNS_USRFLD_711"|"numeric"|""|"12"|"0"
"EXTRACT_CONSTRUCTION"|"CNS_USRFLD_712"|"numeric"|""|"12"|"0"
"EXTRACT_CONSTRUCTION"|"CNS_USRFLD_713"|"numeric"|""|"12"|"0"
"EXTRACT_CONSTRUCTION"|"CNS_USRFLD_714"|"numeric"|""|"12"|"0"
"EXTRACT_CONSTRUCTION"|"CNS_USRFLD_715"|"numeric"|""|"12"|"0"
"EXTRACT_CONSTRUCTION"|"CNS_USRFLD_716"|"numeric"|""|"12"|"0"
"EXTRACT_CONSTRUCTION"|"CNS_USRFLD_717"|"numeric"|""|"12"|"0"
"EXTRACT_CONSTRUCTION"|"CNS_USRFLD_718"|"numeric"|""|"12"|"0"
"EXTRACT_CONSTRUCTION"|"CNS_USRFLD_719"|"numeric"|""|"12"|"0"
"EXTRACT_CONSTRUCTION"|"RES_CNS_CNDTN"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"RES_CNS_CNDTN_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"RES_CNS_FNDTN_CNDTN"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"RES_CNS_FNDTN_CNDTN_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"RES_CNS_BASEMENT"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"RES_CNS_BASEMENT_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"RES_CNS_KITCHEN_STYLE2"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"RES_CNS_KITCHEN_STYLE2_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"RES_CNS_KITCHEN_STYLE3"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"RES_CNS_KITCHEN_STYLE3_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"COM_CNS_STRUCT_CLASS"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"COM_CNS_STRUCT_CLASS_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"COM_CNS_SIZ_ADJ_FACTOR"|"numeric"|""|"8"|"5"
"EXTRACT_CONSTRUCTION"|"COM_CNS_FLR1_OCC"|"varchar"|"30"|""|""
"EXTRACT_CONSTRUCTION"|"COM_CNS_FLR1_OCC_DESC"|"varchar"|"30"|""|""
"EXTRACT_CONSTRUCTION"|"COM_CNS_WALL_HEIGHT"|"numeric"|""|"5"|"2"
"EXTRACT_CONSTRUCTION"|"COM_CNS_WALL_HEIGHT_ADJ"|"numeric"|""|"7"|"4"
"EXTRACT_CONSTRUCTION"|"COM_CNS_NUM_UNITS"|"numeric"|""|"7"|"2"
"EXTRACT_CONSTRUCTION"|"COM_CNS_USRFLD_84"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"COM_CNS_USRFLD_84_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"COM_CNS_REPLACE_COST"|"numeric"|""|"11"|"0"
"EXTRACT_CONSTRUCTION"|"COM_CNS_USRFLD_200"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"COM_CNS_USRFLD_200_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"COM_CNS_USRFLD_201"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"COM_CNS_USRFLD_201_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"COM_CNS_USRFLD_202"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"COM_CNS_USRFLD_202_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"COM_CNS_USRFLD_203"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"COM_CNS_USRFLD_203_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"COM_CNS_USRFLD_204"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"COM_CNS_USRFLD_204_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"COM_CNS_USRFLD_205"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"COM_CNS_USRFLD_205_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"COM_CNS_USRFLD_206"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"COM_CNS_USRFLD_206_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"COM_CNS_USRFLD_207"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"COM_CNS_USRFLD_207_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"COM_CNS_USRFLD_208"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"COM_CNS_USRFLD_208_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"COM_CNS_USRFLD_209"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"COM_CNS_USRFLD_209_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"COM_CNS_USRFLD_210"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"COM_CNS_USRFLD_210_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"COM_CNS_USRFLD_211"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"COM_CNS_USRFLD_211_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"COM_CNS_USRFLD_212"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"COM_CNS_USRFLD_212_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"COM_CNS_USRFLD_213"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"COM_CNS_USRFLD_213_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"COM_CNS_USRFLD_214"|"numeric"|""|"9"|"2"
"EXTRACT_CONSTRUCTION"|"COM_CNS_USRFLD_214_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"COM_CNS_USRFLD_215"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"COM_CNS_USRFLD_215_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"COM_CNS_USRFLD_216"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"COM_CNS_USRFLD_216_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"COM_CNS_USRFLD_217"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"COM_CNS_USRFLD_217_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"COM_CNS_USRFLD_218"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"COM_CNS_USRFLD_218_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"COM_CNS_USRFLD_219"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"COM_CNS_USRFLD_219_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"COM_CNS_USRFLD_220"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"COM_CNS_USRFLD_220_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"COM_CNS_USRFLD_221"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"COM_CNS_USRFLD_221_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"COM_CNS_USRFLD_222"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"COM_CNS_USRFLD_222_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"COM_CNS_USRFLD_223"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"COM_CNS_USRFLD_223_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"COM_CNS_USRFLD_224"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"COM_CNS_USRFLD_224_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"COM_CNS_USRFLD_225"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"COM_CNS_USRFLD_225_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"COM_CNS_USRFLD_226"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"COM_CNS_USRFLD_226_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"COM_CNS_USRFLD_227"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"COM_CNS_USRFLD_227_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"COM_CNS_USRFLD_228"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"COM_CNS_USRFLD_228_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"COM_CNS_USRFLD_229"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"COM_CNS_USRFLD_229_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CondoMain_CNS_NUM_BLDGS"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CondoMain_CNS_NUM_SECTS"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CondoMain_CNS_NUM_UNITS_RES"|"numeric"|""|"9"|"0"
"EXTRACT_CONSTRUCTION"|"CondoMain_CNS_NUM_UNITS_CMRCL"|"numeric"|""|"9"|"0"
"EXTRACT_CONSTRUCTION"|"CondoMain_CNS_NUM_UNITS_RES_COM"|"numeric"|""|"9"|"0"
"EXTRACT_CONSTRUCTION"|"CondoMain_CNS_REMOD_EXT"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CondoMain_CNS_REMOD_EXT_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CondoMain_CNS_SECURITY"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CondoMain_CNS_SECURITY_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CondoMain_CNS_CONDO_APPEAL"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CondoMain_CNS_CONDO_APPEAL_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CondoMain_CNS_NUM_PARK_EASEMENT"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CondoMain_CNS_NUM_PARK_COMMON"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CondoMain_CNS_NUM_PARK_DEEDED"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CondoMain_CNS_SUPER"|"varchar"|"30"|""|""
"EXTRACT_CONSTRUCTION"|"CondoMain_CNS_USRFLD_400"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CondoMain_CNS_USRFLD_400_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CondoMain_CNS_USRFLD_401"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CondoMain_CNS_USRFLD_401_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CondoMain_CNS_USRFLD_402"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CondoMain_CNS_USRFLD_402_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CondoMain_CNS_USRFLD_403"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CondoMain_CNS_USRFLD_403_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CondoMain_CNS_USRFLD_404"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CondoMain_CNS_USRFLD_404_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CondoMain_CNS_USRFLD_405"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CondoMain_CNS_USRFLD_405_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CondoMain_CNS_USRFLD_406"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CondoMain_CNS_USRFLD_406_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CondoMain_CNS_USRFLD_407"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CondoMain_CNS_USRFLD_407_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CondoMain_CNS_USRFLD_408"|"numeric"|""|"9"|"2"
"EXTRACT_CONSTRUCTION"|"CondoMain_CNS_USRFLD_408_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CONDO_CNS_BASE_FLR"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CONDO_CNS_BASE_FLR_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CONDO_CNS_UNIT_LOCN"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CONDO_CNS_UNIT_LOCN_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CONDO_CNS_UNIT_LOCN2"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CONDO_CNS_UNIT_LOCN2_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CONDO_CNS_BEDRM_FUNC"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CONDO_CNS_BEDRM_FUNC_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CONDO_CNS_NUM_PART_BEDRM"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CONDO_CNS_BATHRM_FUNC"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CONDO_CNS_BATHRM_FUNC_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CONDO_CNS_KITCHEN_TYPE"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CONDO_CNS_KITCHEN_TYPE_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CONDO_CNS_KITCHEN_FUNC"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CONDO_CNS_KITCHEN_FUNC_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CONDO_CNS_HEAT_SYS"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CONDO_CNS_HEAT_SYS_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CONDO_CNS_HTWTR_TYPE"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CONDO_CNS_HTWTR_TYPE_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CONDO_CNS_ATYPICAL"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CONDO_CNS_ATYPICAL_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CONDO_CNS_USRFLD_83"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CONDO_CNS_USRFLD_83_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CONDO_CNS_PARK_TYPE"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CONDO_CNS_PARK_TYPE_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CONDO_CNS_PARK_OWN"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CONDO_CNS_PARK_OWN_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CONDO_CNS_PARK_TANDEM"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CONDO_CNS_BASE_FLR_PM"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CONDO_CNS_PCT_LOW_CEILING"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CONDO_CNS_CONDO_FLR"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CONDO_CNS_CONDO_FLR_PCT"|"numeric"|""|"3"|"0"
"EXTRACT_CONSTRUCTION"|"CONDO_CNS_CONDO_FLR_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CONDO_CNS_CONDO_UNIT_LOCN"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CONDO_CNS_CONDO_UNIT_LOCN_PCT"|"numeric"|""|"3"|"0"
"EXTRACT_CONSTRUCTION"|"CONDO_CNS_CONDO_UNIT_LOCN_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CONDO_CNS_CONDO_ADJ1"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CONDO_CNS_CONDO_ADJ1_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CONDO_CNS_CONDO_ADJ2"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CONDO_CNS_CONDO_ADJ2_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CONDO_CNS_CONDO_ADJ3"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CONDO_CNS_CONDO_ADJ3_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CONDO_CNS_CONDO_ADJ4"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CONDO_CNS_CONDO_ADJ4_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CONDO_CNS_CONDO_ADJ5"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CONDO_CNS_CONDO_ADJ5_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CONDO_CNS_CONDO_ADJ6"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CONDO_CNS_CONDO_ADJ6_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CNS_LAST_UPDATE"|"datetime"|""|""|""
"EXTRACT_CONSTRUCTION"|"CONSTRDEP_CNS_SECT_NUM"|"numeric"|""|"9"|"0"
"EXTRACT_CONSTRUCTION"|"CONSTRRES_CNS_STYLE"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CONSTRRES_CNS_STYLE_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CONSTRCOM_CNS_STYLE"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CONSTRCOM_CNS_STYLE_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CONDO_CNS_STYLE"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CONDO_CNS_STYLE_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"CondoMain_CNS_STYLE"|"varchar"|"6"|""|""
"EXTRACT_CONSTRUCTION"|"CondoMain_CNS_STYLE_DESC"|"varchar"|"40"|""|""
"EXTRACT_CONSTRUCTION"|"REM_ACCT_NUM"|"varchar"|"30"|""|""
"EXTRACT_CONSTRUCTION"|"REM_PARCEL_STATUS"|"varchar"|"1"|""|""
"EXTRACT_INCMLINE"|"FISCAL_YEAR"|"varchar"|"4"|""|""
"EXTRACT_INCMLINE"|"RE_YEAR"|"varchar"|"4"|""|""
"EXTRACT_INCMLINE"|"ICL_MNC"|"numeric"|""|"9"|"0"
"EXTRACT_INCMLINE"|"ICL_PID"|"numeric"|""|"9"|"0"
"EXTRACT_INCMLINE"|"ICL_BID"|"numeric"|""|"9"|"0"
"EXTRACT_INCMLINE"|"ICL_BLDG_NUM"|"numeric"|""|"9"|"0"
"EXTRACT_INCMLINE"|"ICL_LINE_NUM"|"numeric"|""|"9"|"0"
"EXTRACT_INCMLINE"|"ICL_STYLE"|"varchar"|"6"|""|""
"EXTRACT_INCMLINE"|"ICL_STYLE_DESC"|"varchar"|"40"|""|""
"EXTRACT_INCMLINE"|"ICL_LOC_ADJ"|"varchar"|"4"|""|""
"EXTRACT_INCMLINE"|"ICL_LOC_ADJ_PCT"|"numeric"|""|"7"|"2"
"EXTRACT_INCMLINE"|"ICL_USE_ADJ"|"varchar"|"4"|""|""
"EXTRACT_INCMLINE"|"ICL_USE_ADJ_PCT"|"numeric"|""|"7"|"2"
"EXTRACT_INCMLINE"|"ICL_VAC_DBT_ADJ"|"varchar"|"4"|""|""
"EXTRACT_INCMLINE"|"ICL_VAC_DBT_PCT"|"numeric"|""|"7"|"4"
"EXTRACT_INCMLINE"|"ICL_VAC_DBT_VAL"|"numeric"|""|"9"|"0"
"EXTRACT_INCMLINE"|"ICL_EXP_ADJ"|"varchar"|"4"|""|""
"EXTRACT_INCMLINE"|"ICL_EXP_ADJ_PCT"|"numeric"|""|"7"|"4"
"EXTRACT_INCMLINE"|"ICL_EXP_VAL"|"numeric"|""|"9"|"0"
"EXTRACT_INCMLINE"|"ICL_TEN_ADJ"|"varchar"|"1"|""|""
"EXTRACT_INCMLINE"|"ICL_OCC"|"numeric"|""|"9"|"0"
"EXTRACT_INCMLINE"|"ICL_FLOOR_LEV"|"varchar"|"3"|""|""
"EXTRACT_INCMLINE"|"ICL_AREA_UNITS"|"numeric"|""|"9"|"0"
"EXTRACT_INCMLINE"|"ICL_OTHER_INC"|"numeric"|""|"9"|"0"
"EXTRACT_INCMLINE"|"ICL_EXPENSES"|"numeric"|""|"9"|"0"
"EXTRACT_INCMLINE"|"ICL_RENT_PER_UNIT"|"numeric"|""|"11"|"2"
"EXTRACT_INCMLINE"|"ICL_GROSS_RENT"|"numeric"|""|"9"|"0"
"EXTRACT_INCMLINE"|"ICL_NOTES"|"varchar"|"255"|""|""
"EXTRACT_INCMLINE"|"ICL_GROSS_RENT_OVR"|"numeric"|""|"9"|"0"
"EXTRACT_INCMLINE"|"ICL_VAC_DBT_OVR"|"numeric"|""|"9"|"0"
"EXTRACT_INCMLINE"|"ICL_EXPENSES_OVR"|"numeric"|""|"9"|"0"
"EXTRACT_INCMLINE"|"ICL_EGI"|"numeric"|""|"9"|"0"
"EXTRACT_INCMLINE"|"ICL_NOI"|"numeric"|""|"9"|"0"
"EXTRACT_INCMLINE"|"ICL_BASE_RATE"|"numeric"|""|"11"|"2"
"EXTRACT_INCMLINE"|"ICL_IS_XPER"|"numeric"|""|"9"|"0"
"EXTRACT_INCMLINE"|"ICL_VALIDITY"|"varchar"|"1"|""|""
"EXTRACT_INCMLINE"|"ICL_LEASE_BEGIN"|"datetime2"|""|""|""
"EXTRACT_INCMLINE"|"ICL_TENANT"|"varchar"|"20"|""|""
"EXTRACT_INCMLINE"|"ICL_LEASE_YRS"|"numeric"|""|"9"|"0"
"EXTRACT_INCMLINE"|"ICL_INCOME_YR"|"numeric"|""|"9"|"0"
"EXTRACT_INCMLINE"|"ICL_UTILITIES"|"varchar"|"30"|""|""
"EXTRACT_INCMLINE"|"ICL_XPER_CODE"|"varchar"|"2"|""|""
"EXTRACT_INCMLINE"|"ICL_USE_SF"|"float"|""|"53"|""
"EXTRACT_INCMLINE"|"ICL_ADJ_TABLE"|"varchar"|"4"|""|""
"EXTRACT_INCMLINE"|"ICL_SECT_NUM"|"numeric"|""|"9"|"0"
"EXTRACT_INCMLINE"|"ICL_EXP_ADJ_UOM"|"numeric"|""|"9"|"2"
"EXTRACT_INCMLINE"|"ICL_EXP_TYPE"|"numeric"|""|"1"|"0"
"EXTRACT_INCMLINE"|"ICL_CREATE_DATE"|"datetime"|""|""|""
"EXTRACT_INCMLINE"|"ICL_LAST_UPDATE"|"datetime"|""|""|""
"EXTRACT_INCMLINE"|"ICL_MONTHLY_RENT"|"numeric"|""|"11"|"0"
"EXTRACT_INCMLINE"|"REM_ACCT_NUM"|"varchar"|"30"|""|""
"EXTRACT_INCMLINE"|"REM_PARCEL_STATUS"|"varchar"|"1"|""|""
"EXTRACT_INCOME"|"FISCAL_YEAR"|"varchar"|"4"|""|""
"EXTRACT_INCOME"|"RE_YEAR"|"varchar"|"4"|""|""
"EXTRACT_INCOME"|"INC_MNC"|"numeric"|""|"9"|"0"
"EXTRACT_INCOME"|"INC_PID"|"numeric"|""|"9"|"0"
"EXTRACT_INCOME"|"INC_CAP_ADJ"|"varchar"|"4"|""|""
"EXTRACT_INCOME"|"INC_CAP_CODE"|"varchar"|"4"|""|""
"EXTRACT_INCOME"|"INC_CAP_RATE"|"numeric"|""|"7"|"4"
"EXTRACT_INCOME"|"INC_NOTES"|"varchar"|"300"|""|""
"EXTRACT_INCOME"|"INC_GROSS_AREA"|"float"|""|"53"|""
"EXTRACT_INCOME"|"INC_LAND_USE_CODE"|"float"|""|"53"|""
"EXTRACT_INCOME"|"INC_DBT_ADJ"|"varchar"|"1"|""|""
"EXTRACT_INCOME"|"INC_EXP_ADJ"|"varchar"|"1"|""|""
"EXTRACT_INCOME"|"INC_VALIDITY"|"varchar"|"1"|""|""
"EXTRACT_INCOME"|"INC_DBT_LOSS"|"numeric"|""|"11"|"0"
"EXTRACT_INCOME"|"INC_EXPENSES"|"numeric"|""|"11"|"0"
"EXTRACT_INCOME"|"INC_SALE_DATE"|"datetime2"|""|""|""
"EXTRACT_INCOME"|"INC_SALE_PRICE"|"numeric"|""|"11"|"0"
"EXTRACT_INCOME"|"INC_XPER_CODE"|"numeric"|""|"9"|"0"
"EXTRACT_INCOME"|"INC_IS_XPER"|"numeric"|""|"9"|"0"
"EXTRACT_INCOME"|"INC_TTL_VAL_PER_UNIT"|"numeric"|""|"11"|"2"
"EXTRACT_INCOME"|"INC_TTL_GROSS_RENT"|"numeric"|""|"11"|"0"
"EXTRACT_INCOME"|"INC_TTL_VAC_PCT"|"numeric"|""|"7"|"4"
"EXTRACT_INCOME"|"INC_TTL_VAC"|"numeric"|""|"11"|"0"
"EXTRACT_INCOME"|"INC_TTL_EGI"|"numeric"|""|"11"|"0"
"EXTRACT_INCOME"|"INC_TTL_EXP_PCT"|"numeric"|""|"7"|"2"
"EXTRACT_INCOME"|"INC_TTL_EXP"|"numeric"|""|"11"|"0"
"EXTRACT_INCOME"|"INC_TTL_NOI"|"numeric"|""|"11"|"0"
"EXTRACT_INCOME"|"INC_EXCESS_LAND"|"numeric"|""|"11"|"0"
"EXTRACT_INCOME"|"INC_TTL_BLDG_VALUE"|"numeric"|""|"11"|"0"
"EXTRACT_INCOME"|"INC_TTL_INCOME"|"numeric"|""|"11"|"0"
"EXTRACT_INCOME"|"INC_REFRESH_TTL"|"numeric"|""|"9"|"0"
"EXTRACT_INCOME"|"INC_CAP_OVERRIDE"|"numeric"|""|"9"|"0"
"EXTRACT_INCOME"|"INC_INCOME_YR"|"numeric"|""|"4"|"0"
"EXTRACT_INCOME"|"INC_TTL_OTHER_INC"|"numeric"|""|"11"|"0"
"EXTRACT_INCOME"|"INC_TTL_AREA_GL"|"numeric"|""|"11"|"0"
"EXTRACT_INCOME"|"INC_TTL_AREA_LL"|"numeric"|""|"11"|"0"
"EXTRACT_INCOME"|"INC_TTL_AREA_UL"|"numeric"|""|"11"|"0"
"EXTRACT_INCOME"|"INC_HEAT"|"numeric"|""|"11"|"0"
"EXTRACT_INCOME"|"INC_ELECTRIC"|"numeric"|""|"11"|"0"
"EXTRACT_INCOME"|"INC_WATER"|"numeric"|""|"11"|"0"
"EXTRACT_INCOME"|"INC_SEWER"|"numeric"|""|"11"|"0"
"EXTRACT_INCOME"|"INC_MAINTENANCE"|"numeric"|""|"11"|"0"
"EXTRACT_INCOME"|"INC_INSURANCE"|"numeric"|""|"11"|"0"
"EXTRACT_INCOME"|"INC_TRASH"|"numeric"|""|"11"|"0"
"EXTRACT_INCOME"|"INC_SNOW"|"numeric"|""|"11"|"0"
"EXTRACT_INCOME"|"INC_ACCOUNTING"|"numeric"|""|"11"|"0"
"EXTRACT_INCOME"|"INC_MANAGEMENT"|"numeric"|""|"11"|"0"
"EXTRACT_INCOME"|"INC_RESERVES"|"numeric"|""|"11"|"0"
"EXTRACT_INCOME"|"INC_OTHER_EXP"|"numeric"|""|"11"|"0"
"EXTRACT_INCOME"|"INC_RECALC"|"numeric"|""|"9"|"0"
"EXTRACT_INCOME"|"INC_CAP_ADJ_PCT"|"numeric"|""|"3"|"2"
"EXTRACT_INCOME"|"INC_RENT_CRV"|"varchar"|"9"|""|""
"EXTRACT_INCOME"|"INC_FLAG"|"numeric"|""|"1"|"0"
"EXTRACT_INCOME"|"INC_EXCLUDE"|"numeric"|""|"1"|"0"
"EXTRACT_INCOME"|"INC_EXP_PSF"|"numeric"|""|"9"|"2"
"EXTRACT_INCOME"|"INC_EXP_PGI"|"numeric"|""|"11"|"4"
"EXTRACT_INCOME"|"INC_EXP_OVR"|"numeric"|""|"1"|"0"
"EXTRACT_INCOME"|"INC_CREATE_DATE"|"datetime"|""|""|""
"EXTRACT_INCOME"|"INC_LAST_UPDATE"|"datetime"|""|""|""
"EXTRACT_INCOME"|"INC_APPLY_VALUE"|"numeric"|""|"1"|"0"
"EXTRACT_INCOME"|"INC_GIM_CODE"|"varchar"|"6"|""|""
"EXTRACT_INCOME"|"INC_GIM_ADJ"|"varchar"|"6"|""|""
"EXTRACT_INCOME"|"INC_GIM_OVERRIDE"|"numeric"|""|"1"|"0"
"EXTRACT_INCOME"|"INC_GIM_FACTOR"|"numeric"|""|"7"|"4"
"EXTRACT_INCOME"|"INC_GIM_VALUE"|"numeric"|""|"11"|"2"
"EXTRACT_INCOME"|"INC_MONTHLY_RENT"|"numeric"|""|"11"|"0"
"EXTRACT_INCOME"|"INC_GRM_CODE"|"varchar"|"6"|""|""
"EXTRACT_INCOME"|"INC_GRM_ADJ"|"varchar"|"6"|""|""
"EXTRACT_INCOME"|"INC_GRM_OVERRIDE"|"numeric"|""|"1"|"0"
"EXTRACT_INCOME"|"INC_GRM_FACTOR"|"numeric"|""|"7"|"4"
"EXTRACT_INCOME"|"INC_GRM_VALUE"|"numeric"|""|"11"|"2"
"EXTRACT_INCOME"|"INC_CAP_COMMENT"|"varchar"|"255"|""|""
"EXTRACT_INCOME"|"INC_GIM_COMMENT"|"varchar"|"255"|""|""
"EXTRACT_INCOME"|"INC_GRM_COMMENT"|"varchar"|"255"|""|""
"EXTRACT_INCOME"|"INC_TTL_GRM_INCOME"|"numeric"|""|"12"|"0"
"EXTRACT_INCOME"|"INC_TTL_GIM_INCOME"|"numeric"|""|"12"|"0"
"EXTRACT_INCOME"|"INC_TTL_GRM_BLDG_VALUE"|"numeric"|""|"12"|"0"
"EXTRACT_INCOME"|"INC_TTL_GIM_BLDG_VALUE"|"numeric"|""|"12"|"0"
"EXTRACT_INCOME"|"INC_TTL_VAL_PER_UNIT_GRM"|"numeric"|""|"12"|"0"
"EXTRACT_INCOME"|"INC_TTL_VAL_PER_UNIT_GIM"|"numeric"|""|"12"|"0"
"EXTRACT_INCOME"|"INC_BOI_CAP_RATE"|"numeric"|""|"7"|"4"
"EXTRACT_INCOME"|"INC_BOI_CAP_ADJ"|"varchar"|"4"|""|""
"EXTRACT_INCOME"|"INC_BOI_CAP_OVERRIDE"|"numeric"|""|"1"|"0"
"EXTRACT_INCOME"|"INC_ORIG_CAP_RATE"|"numeric"|""|"7"|"4"
"EXTRACT_INCOME"|"INC_ORIG_GRM_FACTOR"|"numeric"|""|"7"|"4"
"EXTRACT_INCOME"|"INC_ORIG_GIM_FACTOR"|"numeric"|""|"7"|"4"
"EXTRACT_INCOME"|"INC_TTL_ORIG_BLDG_VALUE"|"numeric"|""|"11"|"0"
"EXTRACT_INCOME"|"INC_TTL_ORIG_GRM_INCOME"|"numeric"|""|"11"|"0"
"EXTRACT_INCOME"|"INC_TTL_ORIG_GiM_INCOME"|"numeric"|""|"11"|"0"
"EXTRACT_INCOME"|"INC_DEDUCT_PERSPROP"|"numeric"|""|"11"|"0"
"EXTRACT_INCOME"|"REM_ACCT_NUM"|"varchar"|"30"|""|""
"EXTRACT_INCOME"|"REM_PARCEL_STATUS"|"varchar"|"1"|""|""
"EXTRACT_LA13"|"FISCAL_YEAR"|"varchar"|"4"|""|""
"EXTRACT_LA13"|"RE_YEAR"|"varchar"|"4"|""|""
"EXTRACT_LA13"|"L13_MNC"|"numeric"|""|"9"|"0"
"EXTRACT_LA13"|"L13_PID"|"numeric"|""|"9"|"0"
"EXTRACT_LA13"|"L13_LINE_NUM"|"numeric"|""|"9"|"0"
"EXTRACT_LA13"|"L13_TYPE"|"varchar"|"3"|""|""
"EXTRACT_LA13"|"L13_DELETED"|"numeric"|""|"1"|"0"
"EXTRACT_LA13"|"L13_FISCAL_YR"|"numeric"|""|"4"|"0"
"EXTRACT_LA13"|"L13_USE_CODE"|"varchar"|"6"|""|""
"EXTRACT_LA13"|"L13_AMOUNT"|"numeric"|""|"12"|"0"
"EXTRACT_LA13"|"L13_MBLU"|"varchar"|"50"|""|""
"EXTRACT_LA13"|"L13_KEY"|"varchar"|"1"|""|""
"EXTRACT_LA13"|"L13_STATUS_DATE"|"datetime2"|""|""|""
"EXTRACT_LA13"|"L13_COMMENT"|"varchar"|"255"|""|""
"EXTRACT_LA13"|"L13_TTL_ASSESS_IMP"|"numeric"|""|"12"|"0"
"EXTRACT_LA13"|"L13_TTL_ASSESS_LND"|"numeric"|""|"12"|"0"
"EXTRACT_LA13"|"L13_USER"|"varchar"|"30"|""|""
"EXTRACT_LA13"|"L13_TTL_ASSESS"|"numeric"|""|"12"|"0"
"EXTRACT_LA13"|"L13_TTL_APPRAIS"|"numeric"|""|"12"|"0"
"EXTRACT_LA13"|"L13_TTL_APPRAIS_IMP"|"numeric"|""|"12"|"0"
"EXTRACT_LA13"|"L13_TTL_APPRAIS_LND"|"numeric"|""|"12"|"0"
"EXTRACT_LA13"|"L13_APPRAIS_OVR"|"numeric"|""|"1"|"0"
"EXTRACT_LA13"|"L13_APPRAIS_AMOUNT"|"numeric"|""|"12"|"0"
"EXTRACT_LA13"|"L13_ACCEPT_CODE"|"varchar"|"1"|""|""
"EXTRACT_LA13"|"L13_ACCEPT_CODE_DESC"|"varchar"|"30"|""|""
"EXTRACT_LA13"|"L13_END_MONTH"|"numeric"|""|"2"|"0"
"EXTRACT_LA13"|"L13_AMT_LND_AS"|"numeric"|""|"14"|"0"
"EXTRACT_LA13"|"L13_AMT_LND_AP"|"numeric"|""|"14"|"0"
"EXTRACT_LA13"|"L13_AMT_IMP_AS"|"numeric"|""|"14"|"0"
"EXTRACT_LA13"|"L13_AMT_IMP_AP"|"numeric"|""|"14"|"0"
"EXTRACT_LA13"|"L13_AMT_AS"|"numeric"|""|"14"|"0"
"EXTRACT_LA13"|"L13_AMT_AP"|"numeric"|""|"14"|"0"
"EXTRACT_LA13"|"L13_AMT_ALT_LND_AS"|"numeric"|""|"14"|"0"
"EXTRACT_LA13"|"L13_AMT_ALT_LND_AP"|"numeric"|""|"14"|"0"
"EXTRACT_LA13"|"L13_TYPE_DESC"|"varchar"|"30"|""|""
"EXTRACT_LA13"|"L13_EFFECTIVEDATE"|"datetime"|""|""|""
"EXTRACT_LA13"|"L13_OVR"|"numeric"|""|"1"|"0"
"EXTRACT_LA13"|"L13_SMART_TRACK"|"numeric"|""|"1"|"0"
"EXTRACT_LA13"|"L13_UNFREEZE"|"numeric"|""|"1"|"0"
"EXTRACT_LA13"|"L13_ASH_TYPE"|"varchar"|"1"|""|""
"EXTRACT_LA13"|"L13_ABATE_YR"|"numeric"|""|"4"|"0"
"EXTRACT_LA13"|"L13_AMT_ALT"|"numeric"|""|"12"|"0"
"EXTRACT_LA13"|"L13_AMT_IMP"|"numeric"|""|"12"|"0"
"EXTRACT_LA13"|"L13_AMT_LND_ALT"|"numeric"|""|"12"|"0"
"EXTRACT_LA13"|"L13_LND_ALT_MKT_PART_AP"|"numeric"|""|"12"|"0"
"EXTRACT_LA13"|"L13_LND_ALT_PART_AP"|"numeric"|""|"12"|"0"
"EXTRACT_LA13"|"L13_OLD_TTL_ASSESS"|"numeric"|""|"12"|"0"
"EXTRACT_LA13"|"L13_UF_POSTED"|"numeric"|""|"1"|"0"
"EXTRACT_LA13"|"L13_LAST_UPDATE"|"datetime"|""|""|""
"EXTRACT_LA13"|"REM_ACCT_NUM"|"varchar"|"30"|""|""
"EXTRACT_LA13"|"REM_PARCEL_STATUS"|"varchar"|"1"|""|""
"EXTRACT_LAND"|"FISCAL_YEAR"|"varchar"|"4"|""|""
"EXTRACT_LAND"|"RE_YEAR"|"varchar"|"4"|""|""
"EXTRACT_LAND"|"LND_MNC"|"numeric"|""|"9"|"0"
"EXTRACT_LAND"|"LND_PID"|"numeric"|""|"9"|"0"
"EXTRACT_LAND"|"LND_LINE_ID"|"numeric"|""|"9"|"0"
"EXTRACT_LAND"|"LND_LINE_NUM"|"numeric"|""|"9"|"0"
"EXTRACT_LAND"|"LND_USE_CODE"|"varchar"|"6"|""|""
"EXTRACT_LAND"|"LND_USE_DESC"|"varchar"|"40"|""|""
"EXTRACT_LAND"|"LND_CLASS"|"varchar"|"1"|""|""
"EXTRACT_LAND"|"LND_ZONE"|"varchar"|"8"|""|""
"EXTRACT_LAND"|"LND_ZONE_DESC"|"varchar"|"40"|""|""
"EXTRACT_LAND"|"LND_DSTRCT"|"varchar"|"6"|""|""
"EXTRACT_LAND"|"LND_UNIT_PRICE_SF"|"numeric"|""|"18"|"10"
"EXTRACT_LAND"|"LND_DSTRCT_DESC"|"varchar"|"40"|""|""
"EXTRACT_LAND"|"LND_FRONTAGE"|"numeric"|""|"9"|"0"
"EXTRACT_LAND"|"LND_FRONTAGE_ACT"|"numeric"|""|"9"|"0"
"EXTRACT_LAND"|"LND_DEPTH"|"numeric"|""|"9"|"0"
"EXTRACT_LAND"|"LND_DEPTH_ACT"|"numeric"|""|"9"|"0"
"EXTRACT_LAND"|"LND_UNITS"|"numeric"|""|"19"|"4"
"EXTRACT_LAND"|"LND_UNIT_TYPE"|"varchar"|"2"|""|""
"EXTRACT_LAND"|"LND_UNIT_TYPE_DESC"|"varchar"|"40"|""|""
"EXTRACT_LAND"|"LND_UNITS_SF"|"numeric"|""|"24"|"4"
"EXTRACT_LAND"|"LND_UNIT_PRICE"|"numeric"|""|"13"|"4"
"EXTRACT_LAND"|"LND_TTL_ADJ"|"numeric"|""|"7"|"4"
"EXTRACT_LAND"|"LND_ADJ_UNIT_PRICE_SF"|"numeric"|""|"13"|"4"
"EXTRACT_LAND"|"LND_APPRAIS_VAL"|"numeric"|""|"14"|"2"
"EXTRACT_LAND"|"LND_ASSESS_VAL"|"numeric"|""|"14"|"2"
"EXTRACT_LAND"|"LND_ADJ_UNIT_PRICE"|"numeric"|""|"13"|"4"
"EXTRACT_LAND"|"LND_OCC"|"varchar"|"6"|""|""
"EXTRACT_LAND"|"LND_OCC_DESC"|"varchar"|"40"|""|""
"EXTRACT_LAND"|"LND_LOT_TYPE"|"varchar"|"6"|""|""
"EXTRACT_LAND"|"LND_LOT_TYPE_DESC"|"varchar"|"40"|""|""
"EXTRACT_LAND"|"LND_SIZE_ADJ"|"numeric"|""|"9"|"4"
"EXTRACT_LAND"|"LND_IS_EXEMPT"|"numeric"|""|"1"|"0"
"EXTRACT_LAND"|"LND_OVR_ASSESS"|"numeric"|""|"1"|"0"
"EXTRACT_LAND"|"LND_IS_PRIMARY_LINE"|"numeric"|""|"1"|"0"
"EXTRACT_LAND"|"LND_TOTAL_UNITS"|"numeric"|""|"12"|"3"
"EXTRACT_LAND"|"LND_TOTAL_UNITS_SF"|"numeric"|""|"13"|"2"
"EXTRACT_LAND"|"LND_UNITS_AC"|"numeric"|""|"19"|"4"
"EXTRACT_LAND"|"LND_OVERRIDE_TOTAL_UNITS"|"bit"|""|""|""
"EXTRACT_LAND"|"LND_TOTAL_UNITS_AC"|"numeric"|""|"19"|"4"
"EXTRACT_LAND"|"LND_IS_HOMESITE"|"bit"|""|""|""
"EXTRACT_LAND"|"LND_LAST_UPDATE"|"datetime"|""|""|""
"EXTRACT_LAND"|"LND_BID"|"numeric"|""|"9"|"0"
"EXTRACT_LAND"|"LND_BLDG_NUM"|"numeric"|""|"9"|"0"
"EXTRACT_LAND"|"REM_ACCT_NUM"|"varchar"|"30"|""|""
"EXTRACT_LAND"|"REM_PARCEL_STATUS"|"varchar"|"1"|""|""
"EXTRACT_LAND"|"LND_NBHD"|"varchar"|"6"|""|""
"EXTRACT_LAND"|"LND_SITE_IDX"|"varchar"|"2"|""|""
"EXTRACT_LAND_AG"|"FISCAL_YEAR"|"varchar"|"4"|""|""
"EXTRACT_LAND_AG"|"RE_YEAR"|"varchar"|"4"|""|""
"EXTRACT_LAND_AG"|"LDA_MNC"|"numeric"|""|"9"|"0"
"EXTRACT_LAND_AG"|"LDA_PID"|"numeric"|""|"9"|"0"
"EXTRACT_LAND_AG"|"LDA_LINE_NUM"|"numeric"|""|"9"|"0"
"EXTRACT_LAND_AG"|"LDA_SRC"|"varchar"|"1"|""|""
"EXTRACT_LAND_AG"|"LDA_MKT_LINE_NUM"|"numeric"|""|"9"|"0"
"EXTRACT_LAND_AG"|"LDA_TYPE"|"varchar"|"6"|""|""
"EXTRACT_LAND_AG"|"LDA_TYPE_DESC"|"varchar"|"40"|""|""
"EXTRACT_LAND_AG"|"LDA_LST_CODE"|"varchar"|"8"|""|""
"EXTRACT_LAND_AG"|"LDA_ACRES"|"numeric"|""|"19"|"4"
"EXTRACT_LAND_AG"|"LDA_UNIT_PRICE"|"numeric"|""|"11"|"2"
"EXTRACT_LAND_AG"|"LDA_APPRAIS_VAL"|"numeric"|""|"12"|"0"
"EXTRACT_LAND_AG"|"LDA_ASSESS_VAL"|"numeric"|""|"12"|"0"
"EXTRACT_LAND_AG"|"LDA_OVR"|"numeric"|""|"1"|"0"
"EXTRACT_LAND_AG"|"LDA_IS_CONS"|"bit"|""|""|""
"EXTRACT_LAND_AG"|"LDA_LINE_ID"|"numeric"|""|"9"|"0"
"EXTRACT_LAND_AG"|"LDA_LND_LOT_TYPE"|"varchar"|"6"|""|""
"EXTRACT_LAND_AG"|"LDA_LND_LOT_TYPE_DESC"|"varchar"|"40"|""|""
"EXTRACT_LAND_AG"|"LDA_MRKT_UNIT_PRICE"|"numeric"|""|"11"|"2"
"EXTRACT_LAND_AG"|"LDA_MRKT_APPRAIS_VAL"|"numeric"|""|"12"|"0"
"EXTRACT_LAND_AG"|"LDA_MRKT_ASSESS_VAL"|"numeric"|""|"12"|"0"
"EXTRACT_LAND_AG"|"LDA_MRKT_PRC_TOT_ADJ"|"numeric"|""|"12"|"0"
"EXTRACT_LAND_AG"|"LDA_LAST_UPDATE"|"datetime"|""|""|""
"EXTRACT_LAND_AG"|"LDA_PROD"|"varchar"|"6"|""|""
"EXTRACT_LAND_AG"|"LDA_PROD_DESC"|"varchar"|"40"|""|""
"EXTRACT_LAND_AG"|"REM_ACCT_NUM"|"varchar"|"30"|""|""
"EXTRACT_LAND_AG"|"REM_PARCEL_STATUS"|"varchar"|"1"|""|""
"EXTRACT_METADATA_LABELS"|"FISCAL_YEAR"|"varchar"|"4"|""|""
"EXTRACT_METADATA_LABELS"|"RE_YEAR"|"varchar"|"4"|""|""
"EXTRACT_METADATA_LABELS"|"EXTRACT_TABLE"|"varchar"|"50"|""|""
"EXTRACT_METADATA_LABELS"|"EXTRACT_COLUMN"|"varchar"|"100"|""|""
"EXTRACT_METADATA_LABELS"|"CAMA_FIELDNAME"|"varchar"|"100"|""|""
"EXTRACT_METADATA_LABELS"|"CAMA_FIELDLABEL"|"varchar"|"60"|""|""
"EXTRACT_METADATA_LABELS"|"CAMA_PICKKEY"|"varchar"|"6"|""|""
"EXTRACT_METADATA_LABELS"|"CAMA_DATA_TYPE"|"varchar"|"50"|""|""
"EXTRACT_METADATA_LABELS"|"CAMA_DATA_LENGTH"|"varchar"|"50"|""|""
"EXTRACT_METADATA_PICKLIST"|"FISCAL_YEAR"|"varchar"|"4"|""|""
"EXTRACT_METADATA_PICKLIST"|"RE_YEAR"|"varchar"|"4"|""|""
"EXTRACT_METADATA_PICKLIST"|"PICKKEY_TYPE"|"varchar"|"50"|""|""
"EXTRACT_METADATA_PICKLIST"|"PICKKEY_CODE"|"varchar"|"100"|""|""
"EXTRACT_METADATA_PICKLIST"|"PICKKEY_SUBCODE"|"varchar"|"100"|""|""
"EXTRACT_METADATA_PICKLIST"|"PICKKEY_DESC"|"varchar"|"100"|""|""
"EXTRACT_METADATA_PICKLIST"|"PICKKEY_STATUS"|"varchar"|"60"|""|""
"EXTRACT_NOTES"|"FISCAL_YEAR"|"varchar"|"4"|""|""
"EXTRACT_NOTES"|"RE_YEAR"|"varchar"|"4"|""|""
"EXTRACT_NOTES"|"NOT_MNC"|"numeric"|""|"9"|"0"
"EXTRACT_NOTES"|"NOT_PID"|"numeric"|""|"9"|"0"
"EXTRACT_NOTES"|"NOT_LINE_NUM"|"numeric"|""|"9"|"0"
"EXTRACT_NOTES"|"NOT_TYPE"|"varchar"|"6"|""|""
"EXTRACT_NOTES"|"NOT_DESC"|"varchar"|"40"|""|""
"EXTRACT_NOTES"|"NOT_YEAR"|"numeric"|""|"4"|"0"
"EXTRACT_NOTES"|"NOT_TEXT"|"varchar"|"2000"|""|""
"EXTRACT_NOTES"|"NOT_DATE_CREATED"|"datetime2"|""|""|""
"EXTRACT_NOTES"|"NOT_LAST_UPDATE"|"datetime"|""|""|""
"EXTRACT_NOTES"|"REM_ACCT_NUM"|"varchar"|"30"|""|""
"EXTRACT_NOTES"|"REM_PARCEL_STATUS"|"varchar"|"1"|""|""
"EXTRACT_OUTBUILDINGS"|"FISCAL_YEAR"|"varchar"|"4"|""|""
"EXTRACT_OUTBUILDINGS"|"RE_YEAR"|"varchar"|"4"|""|""
"EXTRACT_OUTBUILDINGS"|"OXF_MNC"|"numeric"|""|"9"|"0"
"EXTRACT_OUTBUILDINGS"|"OXF_PID"|"numeric"|""|"9"|"0"
"EXTRACT_OUTBUILDINGS"|"OXF_LINE_NUM"|"numeric"|""|"9"|"0"
"EXTRACT_OUTBUILDINGS"|"OXF_CODE"|"varchar"|"6"|""|""
"EXTRACT_OUTBUILDINGS"|"OXF_DESC"|"varchar"|"40"|""|""
"EXTRACT_OUTBUILDINGS"|"OXF_UNITS"|"numeric"|""|"9"|"2"
"EXTRACT_OUTBUILDINGS"|"OXF_UNIT_TYPE"|"varchar"|"30"|""|""
"EXTRACT_OUTBUILDINGS"|"OXF_UNIT_PRICE"|"numeric"|""|"11"|"2"
"EXTRACT_OUTBUILDINGS"|"OXF_YR"|"numeric"|""|"9"|"0"
"EXTRACT_OUTBUILDINGS"|"OXF_IS_OB"|"numeric"|""|"9"|"0"
"EXTRACT_OUTBUILDINGS"|"OXF_QUALITY"|"varchar"|"6"|""|""
"EXTRACT_OUTBUILDINGS"|"OXF_QUAL_ADJ"|"numeric"|""|"3"|"2"
"EXTRACT_OUTBUILDINGS"|"OXF_RCN"|"numeric"|""|"11"|"2"
"EXTRACT_OUTBUILDINGS"|"OXF_CNDTN"|"varchar"|"6"|""|""
"EXTRACT_OUTBUILDINGS"|"OXF_PCT_GOOD"|"numeric"|""|"9"|"0"
"EXTRACT_OUTBUILDINGS"|"OXF_APPRAIS_VAL"|"numeric"|""|"11"|"2"
"EXTRACT_OUTBUILDINGS"|"OXF_ASSESS_VAL"|"numeric"|""|"11"|"2"
"EXTRACT_OUTBUILDINGS"|"OXF_SUBTYPE"|"varchar"|"6"|""|""
"EXTRACT_OUTBUILDINGS"|"OXF_SUBTYPE_DESC"|"varchar"|"40"|""|""
"EXTRACT_OUTBUILDINGS"|"OXF_MEASURE_1"|"numeric"|""|"9"|"0"
"EXTRACT_OUTBUILDINGS"|"OXF_MEASURE_2"|"numeric"|""|"9"|"0"
"EXTRACT_OUTBUILDINGS"|"OXF_OVR"|"numeric"|""|"1"|"0"
"EXTRACT_OUTBUILDINGS"|"OXF_OVR_ASSESS"|"numeric"|""|"1"|"0"
"EXTRACT_OUTBUILDINGS"|"OXF_QUANTITY"|"numeric"|""|"9"|"0"
"EXTRACT_OUTBUILDINGS"|"OXF_UNIT_PR_OVR"|"numeric"|""|"11"|"2"
"EXTRACT_OUTBUILDINGS"|"OXF_EYB"|"numeric"|""|"9"|"0"
"EXTRACT_OUTBUILDINGS"|"OXF_OVR_EYB"|"numeric"|""|"1"|"0"
"EXTRACT_OUTBUILDINGS"|"OXF_OCC"|"varchar"|"6"|""|""
"EXTRACT_OUTBUILDINGS"|"OXF_OCC_DESC"|"varchar"|"40"|""|""
"EXTRACT_OUTBUILDINGS"|"OXF_LAST_UPDATE"|"datetime"|""|""|""
"EXTRACT_OUTBUILDINGS"|"REM_ACCT_NUM"|"varchar"|"30"|""|""
"EXTRACT_OUTBUILDINGS"|"OXF_STORIES"|"varchar"|"6"|""|""
"EXTRACT_OUTBUILDINGS"|"REM_PARCEL_STATUS"|"varchar"|"1"|""|""
"EXTRACT_PARCEL"|"FISCAL_YEAR"|"varchar"|"4"|""|""
"EXTRACT_PARCEL"|"RE_YEAR"|"varchar"|"4"|""|""
"EXTRACT_PARCEL"|"REM_MNC"|"numeric"|""|"9"|"0"
"EXTRACT_PARCEL"|"REM_PID"|"numeric"|""|"9"|"0"
"EXTRACT_PARCEL"|"REM_PROPERTY_TYPE"|"varchar"|"6"|""|""
"EXTRACT_PARCEL"|"REM_PROPERTY_TYPE_DESC"|"varchar"|"40"|""|""
"EXTRACT_PARCEL"|"REM_PIN"|"varchar"|"35"|""|""
"EXTRACT_PARCEL"|"REM_OWN_NAME"|"varchar"|"85"|""|""
"EXTRACT_PARCEL"|"REM_ACCT_NUM"|"varchar"|"30"|""|""
"EXTRACT_PARCEL"|"REM_PRCL_LOCN"|"varchar"|"50"|""|""
"EXTRACT_PARCEL"|"REM_PRCL_LOCN_STR_PFX"|"varchar"|"5"|""|""
"EXTRACT_PARCEL"|"REM_PRCL_LOCN_STREET"|"varchar"|"40"|""|""
"EXTRACT_PARCEL"|"REM_PRCL_LOCN_STR_SFX"|"varchar"|"5"|""|""
"EXTRACT_PARCEL"|"REM_PRCL_LOCN_NUM"|"numeric"|""|"9"|"0"
"EXTRACT_PARCEL"|"REM_PRCL_LOCN_NUM_CHAR"|"varchar"|"15"|""|""
"EXTRACT_PARCEL"|"REM_PRCL_LOCN_CITY"|"varchar"|"18"|""|""
"EXTRACT_PARCEL"|"REM_PRCL_LOCN_STT"|"varchar"|"2"|""|""
"EXTRACT_PARCEL"|"REM_PRCL_LOCN_ZIP"|"varchar"|"12"|""|""
"EXTRACT_PARCEL"|"REM_PRCL_LOCN_APT"|"varchar"|"12"|""|""
"EXTRACT_PARCEL"|"REM_ALT_PRCL_ID"|"varchar"|"35"|""|""
"EXTRACT_PARCEL"|"REM_PRCL_STATUS_DATE"|"datetime2"|""|""|""
"EXTRACT_PARCEL"|"REM_MBLU_MAP"|"varchar"|"7"|""|""
"EXTRACT_PARCEL"|"REM_MBLU_MAP_CUT"|"varchar"|"3"|""|""
"EXTRACT_PARCEL"|"REM_MBLU_BLOCK"|"varchar"|"7"|""|""
"EXTRACT_PARCEL"|"REM_MBLU_BLOCK_CUT"|"varchar"|"3"|""|""
"EXTRACT_PARCEL"|"REM_MBLU_LOT"|"varchar"|"7"|""|""
"EXTRACT_PARCEL"|"REM_MBLU_LOT_CUT"|"varchar"|"3"|""|""
"EXTRACT_PARCEL"|"REM_MBLU_UNIT"|"varchar"|"7"|""|""
"EXTRACT_PARCEL"|"REM_MBLU_UNIT_CUT"|"varchar"|"3"|""|""
"EXTRACT_PARCEL"|"REM_GIS_ID"|"varchar"|"30"|""|""
"EXTRACT_PARCEL"|"REM_INET_SUPPRESS"|"numeric"|""|"9"|"0"
"EXTRACT_PARCEL"|"REM_USE_CODE"|"varchar"|"6"|""|""
"EXTRACT_PARCEL"|"REM_USE_TYPE"|"varchar"|"4"|""|""
"EXTRACT_PARCEL"|"REM_LEGAL_AREA"|"numeric"|""|"19"|"4"
"EXTRACT_PARCEL"|"REM_PRCL_ID"|"varchar"|"20"|""|""
"EXTRACT_PARCEL"|"REM_INTRNL_SUPPRESS"|"numeric"|""|"9"|"0"
"EXTRACT_PARCEL"|"REM_PRCL_LOCN_NUM_HIGH"|"numeric"|""|"9"|"0"
"EXTRACT_PARCEL"|"REM_PRCL_LOCN_NUM_CHAR_HIGH"|"varchar"|"15"|""|""
"EXTRACT_PARCEL"|"REM_BLDG_CLASS"|"varchar"|"6"|""|""
"EXTRACT_PARCEL"|"REM_BLDG_CLASS_DESC"|"varchar"|"40"|""|""
"EXTRACT_PARCEL"|"REM_ST_CODE"|"numeric"|""|"11"|"0"
"EXTRACT_PARCEL"|"REM_PARCEL_STATUS"|"varchar"|"1"|""|""
"EXTRACT_PARCEL"|"REM_MBLU_MAP_DESC"|"varchar"|"40"|""|""
"EXTRACT_PARCEL"|"REM_FIELD_REVIEW"|"numeric"|""|"1"|"0"
"EXTRACT_PARCEL"|"REM_CREATE_STAMP"|"numeric"|""|"18"|"0"
"EXTRACT_PARCEL"|"REM_USER_ID"|"varchar"|"30"|""|""
"EXTRACT_PARCEL"|"REM_TAX_ID"|"varchar"|"20"|""|""
"EXTRACT_PARCEL"|"REM_SUBMNC"|"numeric"|""|"9"|"0"
"EXTRACT_PARCEL"|"REM_PRCL_LOCN_COUNTRY"|"varchar"|"50"|""|""
"EXTRACT_PARCEL"|"REM_PRCL_LOCN_COUNTY"|"varchar"|"50"|""|""
"EXTRACT_PARCEL"|"REM_PRCL_LOCN_POST_DIRECTION"|"varchar"|"3"|""|""
"EXTRACT_PARCEL"|"REM_PRCL_LOCN_PRE_DIRECTION"|"varchar"|"3"|""|""
"EXTRACT_PARCEL"|"REM_PRCL_LOCN_STREET_TYPE"|"varchar"|"10"|""|""
"EXTRACT_PARCEL"|"REM_PRCL_LOCN_APT_TYPE"|"varchar"|"25"|""|""
"EXTRACT_PARCEL"|"REM_ACCT_NUM_RAW"|"varchar"|"200"|""|""
"EXTRACT_PARCEL"|"REM_FORMATTED_ADDRESS"|"varchar"|"2000"|""|""
"EXTRACT_PARCEL"|"PRC_ASSNG_DIST"|"varchar"|"6"|""|""
"EXTRACT_PARCEL"|"PRC_ASSNG_SUBDIST"|"varchar"|"6"|""|""
"EXTRACT_PARCEL"|"PRC_RES_DIST"|"varchar"|"6"|""|""
"EXTRACT_PARCEL"|"PRC_CONDO_DIST"|"varchar"|"6"|""|""
"EXTRACT_PARCEL"|"PRC_CMRCL_DIST"|"varchar"|"6"|""|""
"EXTRACT_PARCEL"|"PRC_WARD"|"varchar"|"30"|""|""
"EXTRACT_PARCEL"|"PRC_PRECINCT"|"varchar"|"30"|""|""
"EXTRACT_PARCEL"|"PRC_SUBDIV"|"varchar"|"30"|""|""
"EXTRACT_PARCEL"|"PRC_X_COORD"|"varchar"|"20"|""|""
"EXTRACT_PARCEL"|"PRC_Y_COORD"|"varchar"|"20"|""|""
"EXTRACT_PARCEL"|"PRC_USRFLD_01"|"varchar"|"30"|""|""
"EXTRACT_PARCEL"|"PRC_USRFLD_02"|"varchar"|"30"|""|""
"EXTRACT_PARCEL"|"PRC_USRFLD_03"|"varchar"|"30"|""|""
"EXTRACT_PARCEL"|"PRC_USRFLD_04"|"varchar"|"30"|""|""
"EXTRACT_PARCEL"|"PRC_USRFLD_05"|"varchar"|"30"|""|""
"EXTRACT_PARCEL"|"PRC_USRFLD_06"|"varchar"|"30"|""|""
"EXTRACT_PARCEL"|"PRC_USRFLD_07"|"varchar"|"30"|""|""
"EXTRACT_PARCEL"|"PRC_USRFLD_08"|"varchar"|"30"|""|""
"EXTRACT_PARCEL"|"PRC_USRFLD_09"|"varchar"|"30"|""|""
"EXTRACT_PARCEL"|"PRC_USRFLD_10"|"varchar"|"30"|""|""
"EXTRACT_PARCEL"|"PRC_PRIMARY_OCC"|"varchar"|"6"|""|""
"EXTRACT_PARCEL"|"PRC_RES_LAND_PCT"|"numeric"|""|"3"|"0"
"EXTRACT_PARCEL"|"PRC_RES_BLDG_PCT"|"numeric"|""|"3"|"0"
"EXTRACT_PARCEL"|"PRC_COM_LAND_PCT"|"numeric"|""|"3"|"0"
"EXTRACT_PARCEL"|"PRC_COM_BLDG_PCT"|"numeric"|""|"3"|"0"
"EXTRACT_PARCEL"|"PRC_MIXUSE_OVR"|"varchar"|"1"|""|""
"EXTRACT_PARCEL"|"PRC_ASSESS_SQFT_EFF"|"numeric"|""|"11"|"2"
"EXTRACT_PARCEL"|"PRC_APPRAIS_SQFT_EFF"|"numeric"|""|"11"|"2"
"EXTRACT_PARCEL"|"PRC_ASSESS_SQFT_LIV"|"numeric"|""|"11"|"2"
"EXTRACT_PARCEL"|"PRC_APPRAIS_SQFT_LIV"|"numeric"|""|"11"|"2"
"EXTRACT_PARCEL"|"PRC_ASSNG_DIST_DESC"|"varchar"|"40"|""|""
"EXTRACT_PARCEL"|"PRC_DESCRIPTION"|"varchar"|"3500"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_16"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_17"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_18"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_19"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_20"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_21"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_22"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_23"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_24"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_25"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_26"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_27"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_28"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_29"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_30"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_31"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_32"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_33"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_34"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_35"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_36"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_37"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_38"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_39"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_40"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_41"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_42"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_43"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_44"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_45"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_46"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_47"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_48"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_49"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_50"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_51"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_52"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_53"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_54"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_55"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_56"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_57"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_58"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_59"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_60"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_61"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_62"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_63"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_64"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_65"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_66"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_67"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_68"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_69"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_70"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_71"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_72"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_73"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_74"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_75"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_76"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_77"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_78"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_79"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_80"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_81"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_82"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_83"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_84"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_85"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_86"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_87"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_88"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_89"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_90"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_91"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_92"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_93"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_94"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_95"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_96"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_97"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_98"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_99"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_100"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_03"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_01"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_02"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_04"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_05"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_06"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_07"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_08"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_09"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_10"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_11"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_12"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_13"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_14"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_15"|"varchar"|"255"|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_101"|"bit"|""|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_102"|"bit"|""|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_103"|"bit"|""|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_104"|"bit"|""|""|""
"EXTRACT_PARCEL"|"PRX_USRFLD_105"|"bit"|""|""|""
"EXTRACT_PARCEL"|"OWN_NAME1"|"varchar"|"85"|""|""
"EXTRACT_PARCEL"|"OWN_NAME2"|"varchar"|"85"|""|""
"EXTRACT_PARCEL"|"MAD_LINE_NUM"|"numeric"|""|"9"|"0"
"EXTRACT_PARCEL"|"MAD_ADR_TYPE"|"varchar"|"6"|""|""
"EXTRACT_PARCEL"|"MAD_MAIL_NAME1"|"varchar"|"85"|""|""
"EXTRACT_PARCEL"|"MAD_MAIL_NAME2"|"varchar"|"85"|""|""
"EXTRACT_PARCEL"|"MAD_CO_LINE"|"varchar"|"85"|""|""
"EXTRACT_PARCEL"|"MAD_MAIL_ADDR1"|"varchar"|"50"|""|""
"EXTRACT_PARCEL"|"MAD_MAIL_CITY"|"varchar"|"30"|""|""
"EXTRACT_PARCEL"|"MAD_MAIL_STATE"|"varchar"|"20"|""|""
"EXTRACT_PARCEL"|"MAD_MAIL_ZIP"|"varchar"|"20"|""|""
"EXTRACT_PARCEL"|"MAD_MAIL_COUNTY"|"varchar"|"30"|""|""
"EXTRACT_PARCEL"|"MAD_MAIL_COUNTRY"|"varchar"|"30"|""|""
"EXTRACT_PARCEL"|"MAD_MAIL_CARR"|"varchar"|"10"|""|""
"EXTRACT_PARCEL"|"MAD_START_MONTH"|"varchar"|"2"|""|""
"EXTRACT_PARCEL"|"MAD_START_DAY"|"varchar"|"2"|""|""
"EXTRACT_PARCEL"|"MAD_END_MONTH"|"varchar"|"2"|""|""
"EXTRACT_PARCEL"|"MAD_END_DAY"|"varchar"|"2"|""|""
"EXTRACT_PARCEL"|"MAD_START_DATE"|"datetime"|""|""|""
"EXTRACT_PARCEL"|"MAD_END_DATE"|"datetime"|""|""|""
"EXTRACT_PARCEL"|"MAD_POST_DIRECTION"|"varchar"|"3"|""|""
"EXTRACT_PARCEL"|"MAD_PRE_DIRECTION"|"varchar"|"3"|""|""
"EXTRACT_PARCEL"|"MAD_BOX_NUMBER"|"varchar"|"9"|""|""
"EXTRACT_PARCEL"|"MAD_STREET_NAME_PREFIX"|"varchar"|"25"|""|""
"EXTRACT_PARCEL"|"MAD_STREET_NAME_SUFFIX"|"varchar"|"25"|""|""
"EXTRACT_PARCEL"|"MAD_STREET_NUMBER"|"numeric"|""|"9"|"0"
"EXTRACT_PARCEL"|"MAD_UNIT_TYPE"|"varchar"|"10"|""|""
"EXTRACT_PARCEL"|"MAD_UNIT_NUMBER"|"varchar"|"9"|""|""
"EXTRACT_PARCEL"|"MAD_STREET_NAME"|"varchar"|"50"|""|""
"EXTRACT_PARCEL"|"MAD_STREET_TYPE"|"varchar"|"10"|""|""
"EXTRACT_PARCEL"|"MAD_MAIL_ADDR2"|"varchar"|"50"|""|""
"EXTRACT_PARCEL"|"MAD_MAIL_ADDR3"|"varchar"|"50"|""|""
"EXTRACT_PARCEL"|"PreviousOwner"|"varchar"|"85"|""|""
"EXTRACT_PARCEL"|"REM_LAST_UPDATE"|"datetime"|""|""|""
"EXTRACT_PARCEL"|"PRC_ALT_APPROVED"|"numeric"|""|"1"|"0"
"EXTRACT_PARCEL"|"PRC_LIVING_GBA"|"numeric"|""|"11"|"2"
"EXTRACT_PARCEL"|"PRC_EFFECTIVE_AREA"|"numeric"|""|"9"|"0"
"EXTRACT_PARCEL"|"PRC_TTL_LND_AREA_ACRES"|"numeric"|""|"21"|"6"
"EXTRACT_PARCEL"|"PRC_CMPLX_PID"|"numeric"|""|"9"|"0"
"EXTRACT_PARCEL"|"PRC_CMPLX_BID"|"numeric"|""|"9"|"0"
"EXTRACT_PARCEL"|"PRC_PF_01"|"varchar"|"6"|""|""
"EXTRACT_PARCEL"|"PRC_PF_01_DESC"|"varchar"|"40"|""|""
"EXTRACT_PARCEL"|"PRC_PF_02"|"varchar"|"6"|""|""
"EXTRACT_PARCEL"|"PRC_PF_02_DESC"|"varchar"|"40"|""|""
"EXTRACT_PARCEL"|"PRC_PF_03"|"varchar"|"6"|""|""
"EXTRACT_PARCEL"|"PRC_PF_03_DESC"|"varchar"|"40"|""|""
"EXTRACT_PARCEL"|"PRC_PF_04"|"varchar"|"6"|""|""
"EXTRACT_PARCEL"|"PRC_PF_04_DESC"|"varchar"|"40"|""|""
"EXTRACT_PARCEL"|"PRC_PF_05"|"varchar"|"6"|""|""
"EXTRACT_PARCEL"|"PRC_PF_05_DESC"|"varchar"|"40"|""|""
"EXTRACT_PARCEL"|"PRC_PF_06"|"varchar"|"6"|""|""
"EXTRACT_PARCEL"|"PRC_PF_06_DESC"|"varchar"|"40"|""|""
"EXTRACT_PARCEL"|"PRC_PF_07"|"varchar"|"6"|""|""
"EXTRACT_PARCEL"|"PRC_PF_07_DESC"|"varchar"|"40"|""|""
"EXTRACT_PARCEL"|"PRC_PF_08"|"varchar"|"6"|""|""
"EXTRACT_PARCEL"|"PRC_PF_08_DESC"|"varchar"|"40"|""|""
"EXTRACT_PARCEL"|"PRC_PF_09"|"varchar"|"6"|""|""
"EXTRACT_PARCEL"|"PRC_PF_09_DESC"|"varchar"|"40"|""|""
"EXTRACT_PARCEL"|"PRC_PF_10"|"varchar"|"6"|""|""
"EXTRACT_PARCEL"|"PRC_PF_10_DESC"|"varchar"|"40"|""|""
"EXTRACT_PARCEL"|"PRC_PF_11"|"varchar"|"6"|""|""
"EXTRACT_PARCEL"|"PRC_PF_11_DESC"|"varchar"|"40"|""|""
"EXTRACT_PARCEL"|"PRC_PF_12"|"varchar"|"6"|""|""
"EXTRACT_PARCEL"|"PRC_PF_12_DESC"|"varchar"|"40"|""|""
"EXTRACT_PARCEL"|"PRC_FRONTAGE"|"numeric"|""|"7"|"2"
"EXTRACT_PARCEL"|"PRC_DEPTH"|"numeric"|""|"7"|"2"
"EXTRACT_PARCEL"|"PRC_SEC_FRONTAGE"|"numeric"|""|"9"|"0"
"EXTRACT_PARCEL"|"PRC_NUM_FRONTAGE"|"numeric"|""|"9"|"0"
"EXTRACT_PARCEL"|"PRC_PERIMETER"|"numeric"|""|"7"|"2"
"EXTRACT_PARCEL"|"PRC_GIS_AREA"|"numeric"|""|"7"|"2"
"EXTRACT_PARCEL"|"PRC_GIS_PERIMETER"|"numeric"|""|"7"|"2"
"EXTRACT_PARCEL"|"PRC_PROP_TYPE"|"varchar"|"6"|""|""
"EXTRACT_PARCEL"|"PRC_PROP_TYPE_DESC"|"varchar"|"40"|""|""
"EXTRACT_PARCEL"|"PRC_GROSS_AREA"|"numeric"|""|"9"|"0"
"EXTRACT_PARCEL"|"PRC_LAT_COORD"|"varchar"|"20"|""|""
"EXTRACT_PARCEL"|"PRC_LON_COORD"|"varchar"|"20"|""|""
"EXTRACT_PARCEL"|"PRC_TRACING_NUM"|"varchar"|"20"|""|""
"EXTRACT_PARCEL"|"PRC_RES_SQFT"|"numeric"|""|"11"|"2"
"EXTRACT_PARCEL"|"PRC_COMM_SQFT"|"numeric"|""|"11"|"2"
"EXTRACT_PARCEL"|"PRC_CENSUS"|"varchar"|"20"|""|""
"EXTRACT_PARCEL"|"PRC_NUM_BLDGS"|"numeric"|""|"9"|"0"
"EXTRACT_PARCEL"|"PRC_BATCH_NUM"|"varchar"|"10"|""|""
"EXTRACT_PARCEL"|"PRC_GIS_REGION"|"varchar"|"6"|""|""
"EXTRACT_PARCEL"|"PRC_UNFREEZE"|"numeric"|""|"1"|"0"
"EXTRACT_PARCEL"|"PRC_TAX_GROUP_CODE"|"varchar"|"6"|""|""
"EXTRACT_PARCEL"|"REM_CMPLX_NAME"|"varchar"|"40"|""|""
"EXTRACT_PARCEL"|"REM_IS_CONDO_MAIN"|"numeric"|""|"1"|"0"
"EXTRACT_PARCEL"|"REM_BLDG_NAME"|"varchar"|"60"|""|""
"EXTRACT_PARCEL"|"REM_USRFLD"|"varchar"|"6"|""|""
"EXTRACT_PARCEL"|"REM_USRFLD_DESC"|"varchar"|"40"|""|""
"EXTRACT_PARCEL"|"PRC_VALUE_SOURCE"|"varchar"|"1"|""|""
"EXTRACT_PARCEL"|"PRC_TTL_EXEMPT"|"numeric"|""|"12"|"2"
"EXTRACT_PARCEL"|"REM_CROSS_STREET_1"|"varchar"|"25"|""|""
"EXTRACT_PARCEL"|"REM_CROSS_STREET_2"|"varchar"|"25"|""|""
"EXTRACT_PHOTOS"|"FISCAL_YEAR"|"varchar"|"4"|""|""
"EXTRACT_PHOTOS"|"RE_YEAR"|"varchar"|"4"|""|""
"EXTRACT_PHOTOS"|"RIM_MNC"|"numeric"|""|"9"|"0"
"EXTRACT_PHOTOS"|"RIM_ID"|"numeric"|""|"9"|"0"
"EXTRACT_PHOTOS"|"RIM_PID"|"numeric"|""|"9"|"0"
"EXTRACT_PHOTOS"|"RIM_IMAGE"|"varbinary"|"-1"|""|""
"EXTRACT_PHOTOS"|"RIM_LOCATION"|"varchar"|"2048"|""|""
"EXTRACT_PHOTOS"|"RIM_LOCATION_TYPE"|"varchar"|"1"|""|""
"EXTRACT_PHOTOS"|"RIM_CREATE_DATE"|"datetime"|""|""|""
"EXTRACT_PHOTOS"|"RIM_LAST_UPDATE"|"datetime"|""|""|""
"EXTRACT_PHOTOS"|"RIM_ISPRIMARY"|"numeric"|""|"1"|"0"
"EXTRACT_PHOTOS"|"RIM_BASE_DIRECTORY"|"varchar"|"2048"|""|""
"EXTRACT_PHOTOS"|"RIM_BID"|"numeric"|""|"9"|"0"
"EXTRACT_PHOTOS"|"REM_ACCT_NUM"|"varchar"|"30"|""|""
"EXTRACT_PHOTOS"|"REM_PARCEL_STATUS"|"varchar"|"1"|""|""
"EXTRACT_SALES"|"FISCAL_YEAR"|"varchar"|"4"|""|""
"EXTRACT_SALES"|"RE_YEAR"|"varchar"|"4"|""|""
"EXTRACT_SALES"|"SLH_MNC"|"numeric"|""|"9"|"0"
"EXTRACT_SALES"|"SLH_PID"|"numeric"|""|"9"|"0"
"EXTRACT_SALES"|"SLH_LINE_NUM"|"numeric"|""|"9"|"0"
"EXTRACT_SALES"|"SLH_SALE_DATE"|"datetime2"|""|""|""
"EXTRACT_SALES"|"SLH_BOOK"|"varchar"|"15"|""|""
"EXTRACT_SALES"|"SLH_PAGE"|"varchar"|"15"|""|""
"EXTRACT_SALES"|"SLH_INSTRUMENT"|"varchar"|"6"|""|""
"EXTRACT_SALES"|"SLH_INSTRUMENT2"|"varchar"|"6"|""|""
"EXTRACT_SALES"|"SLH_QUALIFIED"|"varchar"|"1"|""|""
"EXTRACT_SALES"|"SLH_QUALIFIED2"|"varchar"|"1"|""|""
"EXTRACT_SALES"|"SLH_IMPROVED"|"varchar"|"1"|""|""
"EXTRACT_SALES"|"SLH_PRICE"|"numeric"|""|"11"|"0"
"EXTRACT_SALES"|"SLH_STAMP_RATE"|"numeric"|""|"5"|"4"
"EXTRACT_SALES"|"SLH_STAMP_TAX"|"numeric"|""|"17"|"2"
"EXTRACT_SALES"|"SLH_STATUS_DATE"|"datetime2"|""|""|""
"EXTRACT_SALES"|"SLH_TIME_ADJ_PRICE"|"numeric"|""|"11"|"0"
"EXTRACT_SALES"|"SLH_CERTIFICATE"|"varchar"|"12"|""|""
"EXTRACT_SALES"|"SLH_NOTES"|"varchar"|"255"|""|""
"EXTRACT_SALES"|"SLH_SALE_TYPE"|"varchar"|"6"|""|""
"EXTRACT_SALES"|"SLH_DEED_TYPE"|"varchar"|"6"|""|""
"EXTRACT_SALES"|"SLH_DEED_DATE"|"datetime2"|""|""|""
"EXTRACT_SALES"|"SLH_RECORD_DATE"|"datetime2"|""|""|""
"EXTRACT_SALES"|"SLH_REFERENCE_NUM"|"varchar"|"20"|""|""
"EXTRACT_SALES"|"SLH_EXEMPT_SALE"|"numeric"|""|"1"|"0"
"EXTRACT_SALES"|"SLH_STAMP_RATE_ADDL"|"numeric"|""|"5"|"4"
"EXTRACT_SALES"|"SLH_STAMP_TAX_ADDL"|"numeric"|""|"17"|"2"
"EXTRACT_SALES"|"SLH_STAMP_RATE_BASIS"|"numeric"|""|"5"|"4"
"EXTRACT_SALES"|"SLH_STAMP_FEE"|"numeric"|""|"8"|"2"
"EXTRACT_SALES"|"SLH_STAMP_TAX_TOTAL"|"numeric"|""|"17"|"2"
"EXTRACT_SALES"|"SLH_USER_FLAG1"|"numeric"|""|"1"|"0"
"EXTRACT_SALES"|"SLH_USER_FLAG2"|"numeric"|""|"1"|"0"
"EXTRACT_SALES"|"SLH_USER1"|"varchar"|"20"|""|""
"EXTRACT_SALES"|"SLH_USER_DESC1"|"varchar"|"40"|""|""
"EXTRACT_SALES"|"SLH_USER2"|"varchar"|"20"|""|""
"EXTRACT_SALES"|"SLH_USER_DESC2"|"varchar"|"40"|""|""
"EXTRACT_SALES"|"SLH_FUTURE"|"numeric"|""|"1"|"0"
"EXTRACT_SALES"|"SLH_LEGAL_OWNER"|"numeric"|""|"1"|"0"
"EXTRACT_SALES"|"SLH_CURRENT_OWNER"|"numeric"|""|"1"|"0"
"EXTRACT_SALES"|"SLH_LAST_UPDATE"|"datetime"|""|""|""
"EXTRACT_SALES"|"GRANTEE"|"varchar"|"85"|""|""
"EXTRACT_SALES"|"PREVIOUSOWNER"|"varchar"|"85"|""|""
"EXTRACT_SALES"|"SLH_SEQUENCE_NUM"|"int"|""|"10"|"0"
"EXTRACT_SALES"|"REM_ACCT_NUM"|"varchar"|"30"|""|""
"EXTRACT_SALES"|"SLH_USER3"|"varchar"|"20"|""|""
"EXTRACT_SALES"|"SLH_USER_DESC3"|"varchar"|"40"|""|""
"EXTRACT_SALES"|"SLH_USER4"|"varchar"|"20"|""|""
"EXTRACT_SALES"|"SLH_USER_DESC4"|"varchar"|"40"|""|""
"EXTRACT_SALES"|"SLH_USER5"|"varchar"|"20"|""|""
"EXTRACT_SALES"|"SLH_USER_DESC5"|"varchar"|"40"|""|""
"EXTRACT_SALES"|"SLH_USER6"|"varchar"|"20"|""|""
"EXTRACT_SALES"|"SLH_USER_DESC6"|"varchar"|"40"|""|""
"EXTRACT_SALES"|"SLH_USER7"|"varchar"|"20"|""|""
"EXTRACT_SALES"|"SLH_USER_DESC7"|"varchar"|"40"|""|""
"EXTRACT_SALES"|"REM_PARCEL_STATUS"|"varchar"|"1"|""|""
"EXTRACT_SALES"|"ROW_PRIMARY"|"numeric"|""|"1"|"0"
"EXTRACT_SALES_MAILADDRESSES"|"FISCAL_YEAR"|"varchar"|"4"|""|""
"EXTRACT_SALES_MAILADDRESSES"|"RE_YEAR"|"varchar"|"4"|""|""
"EXTRACT_SALES_MAILADDRESSES"|"ROW_PID"|"numeric"|""|"9"|"0"
"EXTRACT_SALES_MAILADDRESSES"|"SLH_SALE_DATE"|"datetime2"|""|""|""
"EXTRACT_SALES_MAILADDRESSES"|"ROW_LINE_NUM"|"numeric"|""|"9"|"0"
"EXTRACT_SALES_MAILADDRESSES"|"OWN_NAME1"|"varchar"|"85"|""|""
"EXTRACT_SALES_MAILADDRESSES"|"OWN_NAME2"|"varchar"|"85"|""|""
"EXTRACT_SALES_MAILADDRESSES"|"MAD_ADR_TYPE"|"varchar"|"6"|""|""
"EXTRACT_SALES_MAILADDRESSES"|"MAD_MAIL_ADDR1"|"varchar"|"85"|""|""
"EXTRACT_SALES_MAILADDRESSES"|"MAD_MAIL_ADDR2"|"varchar"|"85"|""|""
"EXTRACT_SALES_MAILADDRESSES"|"MAD_MAIL_ADDR3"|"varchar"|"85"|""|""
"EXTRACT_SALES_MAILADDRESSES"|"MAD_MAIL_CITY"|"varchar"|"85"|""|""
"EXTRACT_SALES_MAILADDRESSES"|"MAD_MAIL_STATE"|"varchar"|"85"|""|""
"EXTRACT_SALES_MAILADDRESSES"|"MAD_MAIL_ZIP"|"varchar"|"85"|""|""
"EXTRACT_SALES_MAILADDRESSES"|"MAD_MAIL_COUNTRY"|"varchar"|"85"|""|""
"EXTRACT_SALES_MAILADDRESSES"|"ROW_OWN_PCT"|"numeric"|""|"3"|"0"
"EXTRACT_SALES_MAILADDRESSES"|"ROW_PRIMARY"|"numeric"|""|"1"|"0"
"EXTRACT_SALES_MAILADDRESSES"|"SLH_LAST_UPDATE"|"datetime"|""|""|""
"EXTRACT_SALES_MAILADDRESSES"|"REM_ACCT_NUM"|"varchar"|"30"|""|""
"EXTRACT_SALES_MAILADDRESSES"|"REM_PARCEL_STATUS"|"varchar"|"1"|""|""
"EXTRACT_SALES_OWNERS"|"FISCAL_YEAR"|"varchar"|"4"|""|""
"EXTRACT_SALES_OWNERS"|"RE_YEAR"|"varchar"|"4"|""|""
"EXTRACT_SALES_OWNERS"|"ROW_PID"|"numeric"|""|"9"|"0"
"EXTRACT_SALES_OWNERS"|"SLH_SALE_DATE"|"datetime2"|""|""|""
"EXTRACT_SALES_OWNERS"|"ROW_LINE_NUM"|"numeric"|""|"9"|"0"
"EXTRACT_SALES_OWNERS"|"OWN_NAME1"|"varchar"|"85"|""|""
"EXTRACT_SALES_OWNERS"|"OWN_NAME2"|"varchar"|"85"|""|""
"EXTRACT_SALES_OWNERS"|"MAD_MAIL_ADDR1"|"varchar"|"85"|""|""
"EXTRACT_SALES_OWNERS"|"MAD_MAIL_ADDR2"|"varchar"|"85"|""|""
"EXTRACT_SALES_OWNERS"|"MAD_MAIL_ADDR3"|"varchar"|"85"|""|""
"EXTRACT_SALES_OWNERS"|"MAD_MAIL_CITY"|"varchar"|"85"|""|""
"EXTRACT_SALES_OWNERS"|"MAD_MAIL_STATE"|"varchar"|"85"|""|""
"EXTRACT_SALES_OWNERS"|"MAD_MAIL_ZIP"|"varchar"|"85"|""|""
"EXTRACT_SALES_OWNERS"|"MAD_MAIL_COUNTRY"|"varchar"|"85"|""|""
"EXTRACT_SALES_OWNERS"|"ROW_OWN_PCT"|"numeric"|""|"3"|"0"
"EXTRACT_SALES_OWNERS"|"ROW_PRIMARY"|"numeric"|""|"1"|"0"
"EXTRACT_SALES_OWNERS"|"SLH_LAST_UPDATE"|"datetime"|""|""|""
"EXTRACT_SALES_OWNERS"|"MAD_ADR_TYPE"|"varchar"|"6"|""|""
"EXTRACT_SALES_OWNERS"|"REM_ACCT_NUM"|"varchar"|"30"|""|""
"EXTRACT_SALES_OWNERS"|"MAD_CO_LINE"|"varchar"|"85"|""|""
"EXTRACT_SALES_OWNERS"|"REM_PARCEL_STATUS"|"varchar"|"1"|""|""
"EXTRACT_SKETCH_XML"|"FISCAL_YEAR"|"varchar"|"4"|""|""
"EXTRACT_SKETCH_XML"|"RE_YEAR"|"varchar"|"4"|""|""
"EXTRACT_SKETCH_XML"|"SHP_MNC"|"numeric"|""|"9"|"0"
"EXTRACT_SKETCH_XML"|"SHP_PID"|"numeric"|""|"9"|"0"
"EXTRACT_SKETCH_XML"|"SHP_BID"|"numeric"|""|"9"|"0"
"EXTRACT_SKETCH_XML"|"SHP_SKETCH_DATA"|"xml"|"-1"|""|""
"EXTRACT_SKETCH_XML"|"SHP_LAST_UPDATE"|"datetime"|""|""|""
"EXTRACT_SKETCH_XML"|"REM_ACCT_NUM"|"varchar"|"30"|""|""
"EXTRACT_SKETCH_XML"|"REM_PARCEL_STATUS"|"varchar"|"1"|""|""
"EXTRACT_SKETCHCODES"|"FISCAL_YEAR"|"varchar"|"4"|""|""
"EXTRACT_SKETCHCODES"|"RE_YEAR"|"varchar"|"4"|""|""
"EXTRACT_SKETCHCODES"|"SAT_AREA_TYPE"|"varchar"|"6"|""|""
"EXTRACT_SKETCHCODES"|"SAT_AREA_TYPE_DESC"|"varchar"|"40"|""|""
"EXTRACT_SKETCHCODES"|"SAT_EFF_PCT"|"numeric"|""|"5"|"2"
"EXTRACT_SKETCHCODES"|"SAT_LIVING"|"numeric"|""|"5"|"2"
"EXTRACT_SKETCHCODES"|"SAT_LAST_UPDATE"|"datetime"|""|""|""
"EXTRACT_SUBAREA"|"FISCAL_YEAR"|"varchar"|"4"|""|""
"EXTRACT_SUBAREA"|"RE_YEAR"|"varchar"|"4"|""|""
"EXTRACT_SUBAREA"|"SUB_MNC"|"numeric"|""|"9"|"0"
"EXTRACT_SUBAREA"|"SUB_UID"|"uniqueidentifier"|""|""|""
"EXTRACT_SUBAREA"|"SUB_PID"|"numeric"|""|"9"|"0"
"EXTRACT_SUBAREA"|"SUB_BID"|"numeric"|""|"9"|"0"
"EXTRACT_SUBAREA"|"SUB_CODE"|"varchar"|"6"|""|""
"EXTRACT_SUBAREA"|"SUB_AREA_EFFECTIVE"|"numeric"|""|"9"|"0"
"EXTRACT_SUBAREA"|"SUB_AREA_GROSS"|"numeric"|""|"9"|"0"
"EXTRACT_SUBAREA"|"SUB_GRP_TOT_GROSS"|"numeric"|""|"9"|"0"
"EXTRACT_SUBAREA"|"SUB_AREA_LIVING"|"numeric"|""|"9"|"0"
"EXTRACT_SUBAREA"|"SUB_SECT_NUM"|"numeric"|""|"9"|"0"
"EXTRACT_SUBAREA"|"SUB_UNITS"|"numeric"|""|"12"|"0"
"EXTRACT_SUBAREA"|"SUB_DESC"|"varchar"|"40"|""|""
"EXTRACT_SUBAREA"|"SUB_LAST_UPDATE"|"datetime"|""|""|""
"EXTRACT_SUBAREA"|"SAT_AREA_TYPE_DESC"|"varchar"|"40"|""|""
"EXTRACT_SUBAREA"|"SAT_EFF_PCT"|"numeric"|""|"5"|"2"
"EXTRACT_SUBAREA"|"SAT_LIVING"|"numeric"|""|"5"|"2"
"EXTRACT_SUBAREA"|"REM_ACCT_NUM"|"varchar"|"30"|""|""
"EXTRACT_SUBAREA"|"REM_PARCEL_STATUS"|"varchar"|"1"|""|""
"EXTRACT_TAXAUTHORITY"|"FISCAL_YEAR"|"varchar"|"4"|""|""
"EXTRACT_TAXAUTHORITY"|"RE_YEAR"|"varchar"|"4"|""|""
"EXTRACT_TAXAUTHORITY"|"REM_PID"|"numeric"|""|"9"|"0"
"EXTRACT_TAXAUTHORITY"|"REM_ACCT_NUM"|"varchar"|"30"|""|""
"EXTRACT_TAXAUTHORITY"|"PRC_TAX_GROUP_CODE"|"varchar"|"6"|""|""
"EXTRACT_TAXAUTHORITY"|"PRC_TAX_GROUP_DESC"|"varchar"|"50"|""|""
"EXTRACT_TAXAUTHORITY"|"TAU_CODE"|"varchar"|"30"|""|""
"EXTRACT_TAXAUTHORITY"|"TAU_DESC"|"varchar"|"50"|""|""
"EXTRACT_TAXAUTHORITY"|"TAU_TYPE_CODE"|"varchar"|"6"|""|""
"EXTRACT_TAXAUTHORITY"|"TAU_TYPE_CODE_DESC"|"varchar"|"40"|""|""
"EXTRACT_TAXAUTHORITY"|"REM_LAST_UPDATE"|"datetime"|""|""|""
"EXTRACT_TAXAUTHORITY"|"REM_PARCEL_STATUS"|"varchar"|"1"|""|""
"EXTRACT_VALUES"|"FISCAL_YEAR"|"varchar"|"4"|""|""
"EXTRACT_VALUES"|"RE_YEAR"|"varchar"|"4"|""|""
"EXTRACT_VALUES"|"ADL_MNC"|"numeric"|""|"9"|"0"
"EXTRACT_VALUES"|"ADL_UID"|"uniqueidentifier"|""|""|""
"EXTRACT_VALUES"|"ADL_ASSESSMENT_ROLL_UID"|"uniqueidentifier"|""|""|""
"EXTRACT_VALUES"|"ADL_ASSESSMENT_TYPE"|"varchar"|"6"|""|""
"EXTRACT_VALUES"|"ADL_APPROVAL_STATUS"|"varchar"|"6"|""|""
"EXTRACT_VALUES"|"ADL_PID"|"numeric"|""|"9"|"0"
"EXTRACT_VALUES"|"ADL_FISCAL_YR"|"numeric"|""|"9"|"0"
"EXTRACT_VALUES"|"ADL_SEQUENCE_NUMBER"|"numeric"|""|"9"|"0"
"EXTRACT_VALUES"|"ADL_TTL_APPRAIS_IMPROVEMENTS"|"numeric"|""|"12"|"0"
"EXTRACT_VALUES"|"ADL_TTL_ASSESS_IMPROVEMENTS"|"numeric"|""|"12"|"0"
"EXTRACT_VALUES"|"ADL_TTL_APPRAIS_LND"|"numeric"|""|"12"|"0"
"EXTRACT_VALUES"|"ADL_TTL_ASSESS_LND"|"numeric"|""|"12"|"0"
"EXTRACT_VALUES"|"ADL_TTL_APPRAIS"|"numeric"|""|"12"|"0"
"EXTRACT_VALUES"|"ADL_TTL_ASSESS"|"numeric"|""|"12"|"0"
"EXTRACT_VALUES"|"ADL_TTL_APPRAIS_LND_ALT"|"numeric"|""|"12"|"0"
"EXTRACT_VALUES"|"ADL_TTL_ASSESS_LND_ALT"|"numeric"|""|"12"|"0"
"EXTRACT_VALUES"|"ADL_TTL_APPRAIS_ALT"|"numeric"|""|"12"|"0"
"EXTRACT_VALUES"|"ADL_TTL_ASSESS_ALT"|"numeric"|""|"12"|"0"
"EXTRACT_VALUES"|"ADL_LND_USE"|"varchar"|"6"|""|""
"EXTRACT_VALUES"|"ADL_LND_TYPE"|"varchar"|"4"|""|""
"EXTRACT_VALUES"|"ADL_USE_CODE"|"varchar"|"6"|""|""
"EXTRACT_VALUES"|"ADL_USE_TYPE"|"varchar"|"4"|""|""
"EXTRACT_VALUES"|"ADL_TTL_EXEMPT"|"numeric"|""|"12"|"2"
"EXTRACT_VALUES"|"ADL_ASSESSMENT_RATIO"|"numeric"|""|"7"|"4"
"EXTRACT_VALUES"|"ADL_APPRAIS_TAXABLE"|"numeric"|""|"12"|"0"
"EXTRACT_VALUES"|"ADL_ASSESS_TAXABLE"|"numeric"|""|"12"|"0"
"EXTRACT_VALUES"|"ADL_ALT_APPROVED"|"bit"|""|""|""
"EXTRACT_VALUES"|"ADL_TTL_ASSESS_MRKT_LND"|"int"|""|"10"|"0"
"EXTRACT_VALUES"|"ADL_TTL_ASSESS_MRKT"|"int"|""|"10"|"0"
"EXTRACT_VALUES"|"ADL_LAST_UPDATE"|"datetime"|""|""|""
"EXTRACT_VALUES"|"REM_ACCT_NUM"|"varchar"|"30"|""|""
"EXTRACT_VALUES"|"REM_PARCEL_STATUS"|"varchar"|"1"|""|""
