Laserfiche WebLink
Statement of Work <br />Seq <br />Input field <br />Output Field <br />ABPT Label <br />Data type <br />Description of <br />Data <br />14 <br />1-1_STR_SUFFIX <br />Street suffix <br />Varchar(30) <br />When populated <br />will be validated <br />against the <br />standard choice of <br />'STREET <br />SUFFIXES' <br />15 <br />L1—STR—PREFIX <br />Street prefix <br />Varchar 6 <br />16 <br />L1_STR_SUFFIX_DIR <br />Street suffix dir <br />Varchar(5) <br />When populated <br />will be validated <br />against the <br />standard choice of <br />'STREET <br />DIRECTIONS' <br />17 <br />L1—SITUS- CITY* <br />Situs city <br />Varchar 32 <br />18 <br />Ll—SITUS. STATE* <br />Situs State <br />Varchar(30) <br />19 <br />L1—SITUS- ZIP <br />Situs zip <br />Varchar 10 <br />20 <br />1-1_SITUS COUNTY <br />Situs county <br />Varchar(30) <br />21 <br />L1 SITUS COUNTRY <br />Situs country <br />Varchar(30) <br />22 <br />L1_X_C00RD <br />X coordinate <br />Number 20,8 <br />23 <br />L1_Y_COORD <br />Y coordinate <br />Number 20,8 <br />24 <br />L1—ADDR—DESC <br />Address <br />Varchar(255) <br />description <br />25 <br />1-1_SITUS_COUNTRY_CODE <br />Situs country <br />Varchar(2) <br />2 character country <br />code <br />code abbreviation <br />26 <br />L1—INSP—DISTRICT <br />Inspection <br />Varchar(255) <br />Display only — not <br />district <br />linked to inspection <br />district functionality. <br />72 <br />L1_ADDRESS1 <br />Address1 <br />Varchar(200) <br />Complete street <br />address line 1 <br />73 <br />L1_ADDRESS2 <br />Address2 <br />Varchar(200) <br />Complete street <br />address line 2 <br />74 <br />L1—SITUS—NBRHD—PREFIX <br />Situs <br />Varchar(6) <br />Neighborhood <br />Neighborhood <br />prefix <br />prefix <br />75 <br />L1_SITUS_NBRHD <br />Situs <br />Varchar(30) <br />Neighborhood <br />Neighborhood <br />name <br />76 <br />L1_FULL_ADDRESS <br />Full Address <br />Varchar(1024) <br />Full, formatted <br />address <br />77 <br />EXT—UID <br />External Unique <br />Varchar(100) <br />For use with <br />ID <br />External APO <br />78 <br />L1—HSE _NBR_ALPHA—STAR <br />House Number <br />Varchar(20) <br />T <br />Alpha Start <br />79 <br />L1_HSE_NBR_ALPHA_END <br />House Number <br />Varchar(20) <br />Alpha End <br />80 <br />L1_LEVEL_PREFIX <br />Level Prefix <br />Varchar(20) <br />9 2015 Accela Inc. Page 32 <br />