Smartstaff, administrator
3,320
edits
Changes
→General Overview
=General Overview=
The ''ssGet'' variable is used to extract information from a number of databases. These include:
* Watch List Integration third party providers
* U.S. [[Census Integration|census data]]
==Configuration - Office of Foreign Assets Control (OFAC)==
{{Template:ProfessionalServices}}
On-request checks can be made against the OFAC's online database within SmartSimple. For example, on an organization [[profile]], a web page view field [[Web_Page_View_Field]] can be configured that exposes the following check results: <br /> : [[Image:RunOFACCheck2.png|link=|600px]]<br />
In the above illustration, the OFAC check has returned one 100% match result on the company name, and no results on the attached contacts.
The syntax for configuring the OFAC check is as follows:
: <span style="font-size: medium;">'''@ssGet(OFAC,''entity'';;''firstname'';;''lastname'';;''search options'';;''roleslist'';;''meta template'';;''line template'')@'''</span>
===Settings Explained - Office of Foreign Assets Control (OFAC)===
{| class="contenttable" style="height: 170px;" border=".5" width="1208"
|-
|}
In order to run an ad hoc OFAC check on a particular organization record, a Web Page View field [[Web_Page_View_Field]] must be created within the Organization custom fields. The content of the Web Page View [[Web_Page_View_Field]] may be configured simiarly to the example shown below:
: [[Image:OFAC WPV.png|link=|800px]]
When using a Web Page View field[[Web_Page_View_Field]], you have the option to 'Enable Save to Server' within the field settings. This will allow you to define an upload field on the organization profile where the stored PDF copy of the OFAC results will be saved when triggered.
==Configuration - Watch List Scanning==
SmartSimple, in partnership with our Watch List providers (CSI Web or Lexis Nexis) can provide access to additional third party services lists beyond the OFAC list. When utilizing these services, a contractual agreement must be established with one of the two integrated providers. The account credentials you receive will be utilized within your instance of SmartSimple to establish the integration.
In Global Settings, under the Integrations tab, you will locate the Watch List Settings.
The Watch List Settings provide the ability to enter your billing id and password for the third party service you are utilizing. <br />When utilizing CSI Web, there are settings to define the watch list(s) you wish to search against, and the scan threshold, which will dictate only being shown results that match or exceed the percentage match threshold. The list of supported third party services with CSI Web includes: * U.S. Bureau Of Industry and Security* Department of State - Bureau of International Security & *Nonproliferation list* Department of State - Defense Trade Controls Debarred Parties list* International Criminal Police Organization (INTERPOL)* Politically Exposed Persons, CIA Foreign Officials* Office of Inspector General* Excluded Parties List System provided by the General Services Administration (GSA)* Financial Crimes Enforcement Network* FinCEN Money Services Business* World Bank Ineligible Firms* Terrorist Exclusion List* FBI Most Wanted Fugitives When utilizing Lexis Nexis, the settings for which watch list services will be included in each scan, along with threshold settings, will be managed within your Lexis Nexis account and not within the SmartSimple instance. ===Returning information from Watch List===The syntax for configuring the Watch List check is as follows: :: <span style="font-size: medium;">'''@ssGet(ServiceName,entity;;firstname;;lastname;;search options;;roleslist;;meta template;;line template<span style="color: #ff0000;">;;''additional search attribute''</span>)@'''</span>The ServiceName is dependent on which third party service you are utilizing: : CSI Web: WatchList: Lexis Nexis: LexisNexisThe line template portion of the syntax allows you to include unique values and parameters in the online scan criteria, such as date of birth or country. These values and the variables that correspond to them are unique to CSI Web and Lexis Nexis and will require reviewing the individual service provider's fields and available options.<pre style="padding-left: 30px;">@parent.client.xml.Board of Directors XML.boardDirectors.boardDirectorsAdd[#$ssGet(WatchList,company;;owner;;;;3;;Grant Seeker,Executive Director,Board Member;;<strong>Board Member Search:</strong> ~Name.nodevalue~<br />Matches Found: [[recordcount]];;</pre>{| class="xmlSectionTable"|-! class="xmlHead"|Result! class="xmlHead"|ID! class="xmlHead"|Name! class="xmlHead"|Type! class="xmlHead"|Alias! class="xmlHead"|Details! class="xmlHead"|Score|- id="matchfound"| class="xmlCell"|[[index]]| class="xmlCell"|[[id]]| class="xmlCell"|[[name]]| class="xmlCell"|[[type]]||[[alias]]||[[details]]| class="xmlCell"|[[score]]|}<pre>;;unparsedname=~Name.nodevalue~)$#]@<br /><br />@ssGet(LexisNexis,people;;@firstname@;;@lastname@;;1;;;;<strong>Applicant Search:</strong> @firstname@ @lastname@<br />Matches Found: [[recordcount]];;</pre>{| class="xmlSectionTable"|-! class="xmlHead"|Result! class="xmlHead"|ID! class="xmlHead"|Name! class="xmlHead"|Type! class="xmlHead"|Alias! class="xmlHead"|Details! class="xmlHead"|Score||[[alias]]||[[details]]| class="xmlCell"|[[score]]|}<pre>;;)@[[index]][[id]][[name]][[type]] </pre> ==Configuration - U.S. Census databaseOnline Database==
@ssGet(FFD,FIPS;;@address@ @city@ @state@)@<br />
@ssGet(FFD,Profile;;year;;Address or FIPS code;;level;;<nowiki>[[template]]</nowiki>)@<br />
'''(See [[Census_Integration#Returning_Census_Data|Census Integration]] for detailed description of syntax.)'''<br />'''(See [[List of census templates]] for links to full list of values for <nowiki>[[</nowiki>''template''<nowiki>]]</nowiki>)'''
==See Also==
:* [[Census Integration]]
:* [[OFAC, IRS, CRA Checks|OFAC, IRS and CRA Checks]]
[[Category:Integration]][[Category:External Data Source]][[Category:Variables]]
<!-- OFAC OFACS ofac ofacs OFACs -->
