Changes

[[Image:CensusProfileWPV.png|link=|1000px]] Census Data can be referenced anywhere in SmartSimple:  ...on a [[list view]]: [[Image:CensusVariableInListView.png|link=|850px]] ...on a {{UTA}} record: [[Image:CensusFieldsOnL1.png|link=|850px]] ...or anywhere else. Data from the U.S. census can also be used to drive [[branching logic]] on SmartSimple [[workflows]], or perform other [[How Calculated Custom Fields Work|calculations]].

USmartSimple's Census Integration works by deriving the ''census block number'' from your organization or contact's address details. The ''census block number'' is a 15-digit code that incorporates - reading from left to right - the location's two-digit ''State'' code, three-digit ''County'' code, and six-digit ''census tract code''. [[Image:TractCode.Spng|link=|450px]] In the above example:* ''22'' is the ''State code'' for Louisiana, * ''113'' is the ''County code'' for Vermilion Parish and* ''951100'' is the ''census tract code'' for the address of Abbeville Womens Equality. Federal Census Tract <!--what are the last four digits?--> ===FIPS CodeSyntax===

:<font size="3">'''@ssGet(FFD,FIPS;;@address@ @city@ @state@)@'''</font><pre style=Returning Census "white-space: pre-wrap; white-space: -moz-pre-wrap; white-space: -pre-wrap; white-space: -o-pre-wrap; word-wrap: break-word;">FFD stands for "Federal Financial Data==" and FIPS stands for Federal Information Processing Standards.</pre>

<pre style="white-space: pre-wrap; white-space: -moz-pre-wrap; white-space: -pre-wrap; white-space: -o-pre-wrap; word-wrap: break-word;">Note: The U.S. Federal Communications Commission writes:"Form 477 requires broadband providers to submit data on a census -tract basis. For the filing of data can be retrieved at three levelsas of December 31, the ''tract''2011, ''county''or later dates, the Form 477 electronic filing system will recognize as valid the combinations of County and Census tract codes from the Year 2010 Census."- from http://transition.fcc.gov/form477/censustracts.htmlReturning the FIPS code makes it easy for SmartSimple''state''s clients to submit forms electronically to the FCC. </pre>

You would then use the following template: for the tract level <font size="3">'''@ssGet(FFD(,Profile;;''year'';;''Address or FIPS code'';;tract''level'';;<nowiki>[[</nowiki>''template''<nowiki>]]</nowiki>)@'''</font>'''Where:''' for the county level @FFD(:* ''Profile;;'' is a constant. :* ''year;;Address or FIPS code;;county;;template) for '' is the state level @FFD(Profile;;census year;;from which the data is returned. Accepts '''2012''', '''2011''', and '''2010''':* ''Address or FIPS code;;state;;template)'' accepts Example: @FFD(profile;;2012;;:* a variable reference to the address, such as ''@address@ @city@ @state@;;''::* the 15-digit ''census block number'':* ''level'' accepts three values, one of ::* '''tract'''::* '''county;; ''' or::* '''state''':* ''template'' is the type of census data to be returned. Over 45,000 different database fields can be reported on from the online census database. [[Census_Integration#List_of_Commonly-used_Templates|Examples]] are listed below. Note that the template should be enclosed within a double set of square brackets (e.g., <nowiki>[[</nowiki>B01003_001E<nowiki>]]</nowiki> will return the ''Total Population'')'''Example:'''In the example at the top of the page, the Median Family Income for Louisiana in 2012 ($56,047.00)is returned using

Profile – constant, query nameYear – integer value of year like 2012,2013. Normally last year statistics are not available until second halve of ==Characteristics Available in the current yearAddress or FIPS code – can be full address or fips code like “@address@ @city@ @state@“ or “@FIPS@Template – html template with statistic variables like “Earnings for Households:$[[B06002_001E]]”Where B06002_001E is field name of Census data (please refer to the xlsx for complete list I sent earlier) ,2 square brackets are used to embed a fieldnameTemplates==

A full list of the census data templates can be found here: {link to [[List of census templates} ]]