Laserfiche WebLink
Statement of Work <br />4. ACCELA AUTOMATION STANDARD TABLE FOR ADDRESSES ASSOCIATED TO <br />PARCELS <br />PARCEL ADDRESS Table <br />Seq <br />Input field <br />Output Field <br />ABPT Label <br />Data type <br />Description of <br />Data <br />1 <br />SERV_PROV_CODE* <br />Serv_prov_code <br />Varchar(15) <br />Service provider <br />code for the <br />agency. <br />2 <br />SOURCE_SEO_NBR* <br />Source_seq_nbr <br />Number <br />Sequence number <br />identifying agency's <br />APO data. <br />Required <br />3 <br />L1_PARCEL_NBR* <br />Parcel number <br />Varchar(24) <br />Parcel number to <br />associate to the <br />address when <br />populated. <br />4 <br />L1_ADDR_STATUS <br />Address status <br />Varchar(1) <br />Valid values are T <br />or'A' if T then T <br />otherwise will load <br />'A' <br />5 <br />L1_HSE_NBR_START <br />Street number <br />Number <br />If not provided will <br />start <br />set to 0 <br />6 <br />L1_HSE_NBR_END <br />Street number <br />Number <br />end <br />7 <br />L1_HSE_FRAC_NBR_START <br />Street fraction <br />Varchar(3) <br />When populated, <br />start <br />will be validated <br />against the <br />standard choice of <br />'STREET <br />FRACTIONS' <br />8 <br />L1_HSE_FRAC_NBR_END <br />Street Fraction <br />Varchar(3) <br />end <br />9 <br />1-1_UNIT_START <br />Unit number <br />Varchar(10) <br />start <br />10 <br />1-1_UNIT_END <br />Unit number <br />Varchar(10) <br />end <br />11 <br />1-1_UNIT_TYPE <br />Unit type <br />Varchar(6) <br />When populated <br />will be validated <br />against the <br />standard choice of <br />'UNIT TYPES' <br />12 <br />L1_STR_DIR <br />Street direction <br />Varchar(2) <br />When populated <br />will be validated <br />against the <br />standard choice of <br />'STREET <br />DIRECTIONS' <br />13 <br />L1 STR NAME* <br />Street Name <br />Varchar 40 <br />© 2015 Accela Inc. Page 31 <br />