Powerful @Functions in IDEA for Fraud Analytics

3 posts / 0 new
Last post
Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57
Powerful @Functions in IDEA for Fraud Analytics

Hi All,

The @Functions in IDEA are well distributed between Numeric, Character, Date and Time fields.

@Functions can be deployed through Field Manipulation for computations and / or through Extraction for condition based filters.

Listed below are a few @Functions which are most effective in Fraud Analytics.

@isini

Used to look for an occurrence of a word in a character field.

Example - @isini("gift", narration) will look for the word gift in a general ledger narration

@dow

Used to locate transactions on a weekend.

Example - @dow(RemittanceDate) = 1 will look for all loan remittances on Sunday

@strip

Used to eliminate special characters and spaces from any character field.

Example - @strip(Vendor Invoice Number) will remove special characters and spaces from a Vendor Invoice Number field reference and allow effective duplicate invoice identification

@isblank

Used to detect blank character fields.

Example - @isblank(Payee Name) will allow for detection of blank Payee Names in a Pay Ledger.

@betweentime

Used to detect specific time points between defined time ranges.

Example - .NOT. @betweentime(Approval Time, "09:30:00", "18:00:00") will detect approval time points outside working hours for the entity.

Electronic data may be deliberately recorded in a sub-optimal form to create loop-holes in the system or circumvent internal controls or create a sleight of hand modus to conceal frauds. IDEA's @Functions are best suited to detect such planned attempts to defraud an entity.

Kind Regards

Jairam

markviii8
Offline
Joined: 02/27/2015 - 16:51

Is there a way to use @Strip in IDEAScript? If not is there a script to remove special characters?

Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

Yes, you should be able to use it by replacing the @ with an i, so use iStrip() and that should work for you.