OFAC Batch Configuration -Details

Batch Details

Account Batch Class And Query.

Batch Class Name - BatchRunAccountOFAC (Managed Package)

Schedulable Class - ScheduleBatchRunAccountOFAC (Managed Package)

'Select Id,Customer_Status__c,Do_Not_Run_OFAC__c,Name,Type,Number_of_Opportunities__c From Account Where (Customer_Status__c != 'Prospect-Dead' OR Type IN ('Prospect','Customer,Partner','Other','Cloud Customer','Partner Prospect')) AND Do_Not_Run_OFAC__c = FALSE AND (Number_of_Opportunities__c != 0) AND Name != '[not provided]' order by CreatedDate

Contact Batch Class And Query.

Batch Class Name - BatchRunContactOFAC (Managed Package)

Schedulable Class - ScheduleBatchRunContactOFAC (Managed Package)

‘Select Id,FirstName,LastName,Name,Account.Name,CreatedDate,RecordTypeId,FCRM__FCR_Status__c From Contact Where RecordTypeId ='012A0000000VyUDIA0’ AND FCRM__FCR_Status__c NOT IN('Closed - Rejected','Closed - Not Active With Sales','No Longer at Company') AND (Account.Name != 'Test Prospect Americas' OR Account.Name != 'Test Prospect EMEA') ORDER BY CreatedDate

Custom Fields

Component Name	Component Type	Functionality	Object

Component Name

Component Type

Functionality

Object

Last OFAC Search Performed

Custom field(Date)

Field will get updated from Process builder and it will hold the value of OFAC Search Date.

Account

Last OFAC Performed

Custom field(Date)

Field will get updated from Process builder and it will hold the value of OFAC Search Date.

Contact

Do Not Run OFAC

Custom field(Check box)

This field is a formula field Which will be used as a Flag for Account query and will be updated to True Whenever the below condition satisfies.

IF(

OR((CONTAINS(Name,'Realm')),

(CONTAINS(Name,'MongoDB')),

(CONTAINS(Name,'testSyncUser, Test')),

(CONTAINS(Name,'testUpdateContact')),

(CONTAINS(Name,'MarketingIntegrationSvcIntTest')),

(CONTAINS(Name,'PrepaidPlanActivationSvcSfdcTests')),

(CONTAINS(Name,'testtestSynvInvoiceInternal')),

(CONTAINS(Name,'Reseller EMEA'))),true,false)

Process Builder

Component Name	Component Type	Functionality	Object

Component Name	Component Type	Functionality	Object
OFAC Search:Update Last OFAC Search Performed on Account And Contact	Process Builder	This Process Builder will update the Last OFAC Search performed on Account and Contact	OFAC Search
OFAC Results: Populate Account and Contact	Process Builder	This process builder will populate Account and Contact on OFAC Results Record	OFAC Results