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
Is there a way to use @Strip
Is there a way to use @Strip in IDEAScript? If not is there a script to remove special characters?