Laserfiche WebLink
Statement of Work <br />2. ACCELA AUTOMATION STANDARD TABLE FOR PARCELS <br />PARCEL BASE Table <br />Se <br />Input Field <br />Outpu <br />ABPT Label <br />Data type <br />Description of Data <br />t Field <br />1 <br />SOURCE_SEQ_NBR' <br />Source_seq_n <br />Number <br />Unique Client Number. <br />br <br />Required for all APO data. <br />The Accela Project Staff will <br />define this number <br />2 <br />L1_PARCEL_NBR' <br />Parcel Number <br />Varchar(24) <br />Required for all APO data <br />Must be unique <br />3 <br />Ll—PARCEL—STATUS <br />Parcel Status <br />Varchar(1) <br />Parcel Status (A or 1) <br />Defaults to A if null. <br />Defaults to I if not null, and not A <br />ort <br />4 <br />Ll—BLOCK <br />Block <br />Varchar 15 <br />Block Number <br />5 <br />1-1_BOOK <br />Book <br />Varchar 8 <br />Book Number <br />6 <br />L1_ CENSUS_ TRACT <br />Census Tract <br />Varchar 10 <br />Census Tract Number <br />7 <br />L1 COUNCIL DISTRICT <br />Council District <br />Varchar 10 <br />Council District <br />8 <br />1-1_EXEMPT_VALUE <br />Exempt Value <br />Number(15,2 <br />Exemption Value <br />9 <br />L1_GIS_SEQ_NBR <br />GIS seq nbr <br />Number(15) <br />GIS number for the Parcel <br />Display only — not linked to GIS <br />10 <br />1-1_IMPROVED_VALUE <br />Improvement <br />Number(15,2 <br />Improvement Value <br />Value <br />11 <br />L1_ INSPECTION_DISTRIC <br />Inspection <br />Varchar(255) <br />Inspection District <br />T <br />District <br />12 <br />Ll—LAND—VALUE <br />Land Value <br />Number(15,2 <br />Land Value <br />13 <br />L1_LEGAL_DESC <br />Legal Desc <br />Varchar(2000 <br />Legal Description <br />14 <br />Ll—LOT <br />Lot <br />Varchar(40) <br />Optional validation against <br />Standard Choice <br />'APO _SUBD IVIS I ONS_LOTS_s <br />ub <br />divisionName' <br />15 <br />L1_MAP_NBR <br />Map Nbr <br />Varchar 10 <br />16 <br />L1—MAP—REF <br />Map Ref <br />Varchar 30 <br />17 <br />L1_PAGE <br />Pae <br />Varchar 8 <br />18 <br />Ll—PARCEL <br />Parcel <br />Varchar 9 <br />19 <br />L1_PARCEL_AREA <br />Parcel area <br />Number(15,2 <br />20 <br />Ll—PLAN—AREA <br />Plan area <br />Varchar 8 <br />21 <br />L1_SUPERVISOR_DISTRI <br />Supervisor <br />Varchar(10) <br />CT <br />district <br />22 <br />Ll—TRACT <br />Tract <br />Varchar 80 <br />23 <br />GIS—ID <br />GIS ID <br />Varchar(70) <br />Must match object ID in the <br />Parcel layer of Agency's GIS <br />system. <br />9 2015 Accela Inc. Page 27 <br />