Module / Queue

Personal Public Service Number (PPSN) Extraction & Checksum Validation

Personal Public Service Number (PPSN) Extraction & Checksum Validation Overview

Everyone born in Ireland from 1971 onwards has a Personal Public Service Number (PPSN). PPS numbers are often found on many documents including payslips, public services card and tax assessments. This asset demonstrates how a PPSN can be extracted and validated using a checksum calculation.

Features

Field Extraction:

Get a head start in extracting the PPSN by downloading the PPSN module. The module shows how the PPSN can be extracted using a combination of training and use of a format locator. The extraction can be further configured/extended to suit your exact requirements.

Checksum Validation:

To avoid picking up an invalid PPSN (possibly as a result of a poor quality image), the module contains a useful implementation of a modulus check that will ensure only alternatives complying with the PPSN format are considered. To do that, the 8th (check) character of the PPSN is compared to the result of a weighted addition of all the numbers(https://en.wikipedia.org/wiki/Personal_Public_Service_Number).

TotalAgility or Transformation Modules:

Designed for flexibility, the module contains a solution for both TotalAgility and Transformation. For TotalAgility, please use the TotalAgility business rule orientated solution. The business rule is named 'BR_ValidatePPSN' and can be imported into TotalAgility by importing the package named 'KTA_PPSN_Package'. For Transformation, please use the script found inside the two script text files.

Benefits

This module allows you to speed up the implementation of PPSN extraction and checksum validation. Avoid picking up invalid PPSN values by only picking up those which pass the checksum validation.

Resources

All resources can be found within the download package.

Sample test documents for both valid and invalid scenarios can be found within the samples subfolder.

Technical Details

Inputs

The download package also contains a set of test documents which cover both valid and invalid scenarios. 

Outputs

Once extraction is performed, the software will extract the PPSN field. A Modulus 23 calculation is also performed on the extracted PPSN to help ensure you are only accepting valid PPSNs. This demo can be further configured/extended as required.

Geographic Availability
Global

Additional Information

The modulus 23 calculation has been created based on https://en.wikipedia.org/wiki/Personal_Public_Service_Number.

 

PLEASE NOTE: Tungsten Labs is independent of Tungsten Automation and this listing is not officially supported or maintained.

Required Software / Applications

None

Details

Products

TotalAgility
Transformation

Industry

Other

compatibility

TotalAgility 7.9+, Transformation 6.3+

Business Process

General / Other

Categories

Document Processing

Last Updated

March 26, 2024

Consulting Required

No

Support Available

Yes

Pricing

Free