Financial institutions in the UK must comply with Sanctions policies laid down by the FSA; this is mandated by law and organisations failing to comply risks the imposition of severe financial penalties, and even prison.
In order to comply, the bank must demonstrate that it has mechanisms in place to match all of its customers against Sanction lists provided by government organisations and to freeze accounts for any Sanctions team approved matches.
The batch job will extract the data for all new Policyholders for submission to Barclays Compliance for comparison to the sanctions lists provided by government. These batch screening files will be moved to a specified location.
For more information on new Policyholders refer to
Products
Endowment
New Policyholder Details
Products
Credit Life
Master File Upload
The file will be processed by the Barclays Compliance team servers in the Data Centre of Excellence. Any possible matches that are identified will be added to the existing processes being used for current in-country screening analysis queues.
When the batch job runs, the system will read all of the Person records created with a Timestamp greater than the timestamp of the previous extract. The system will read the Country for the Scheme for which the Person has a Membership record or in the case of a Beneficiary, the Country of the Scheme for the Membership to which the Beneficiary is linked.
A separate file will be created per country.
A text file will be created with a name according to the following naming convention:
WIMI-country_Source_xx.txt
Where:
WIMI- is a standard prefix for all files
Country is the first three letters of the Country
Source is the system generating the file.
xx is a counter
Example:
WIMI-Ken_Vision_01.txt
The system will extract the data for each field in the file as per the details in the Vision Value / Default Value column in the tables below and create a text file with a value for the counter equal to the value for the previous file incremented by 1.
|
HEADER RECORD |
|||
|
Field |
Format |
Position |
Vision Value / Default Value |
|
System Name |
Char 20 |
1 |
WIMI-Ken |
|
Feed Name |
Char 20 |
21 |
Vision_Counter |
|
Extraction Timestamp |
Char 19 |
41 |
Date and time the file is extracted in the format: CCYY/MM/DD HH:MM:Ss |
|
Detail Record Format |
Char 10 |
60 |
Read the Translation Value with a Translation Purpose of SCREENING FILE for the Target System Attribute RECORD FPRMAT for the Source System Attribute COUNTRY where the value is equal to the value for the Country for which the file is being created |
|
DETAIL RECORD |
||||
|
Field |
|
Format |
Position |
Vision Value / Default Value |
|
Source Reference |
Char 20 |
1 |
Sequential number for each detail record starting with 1.
The Source Reference number is defined as follows:
KEVISID#, e.g. KEVIS89726329190, i.e the prefix should be followed by the clients ID number.
KE is the country code (KENYA) VIS is the system name (VISION) ID# is ths policyholders ID number. |
|
|
Registered Company Name |
Char 100 |
21 |
Spaces |
|
|
Trading Company Name |
Char 30 |
121 |
Spaces |
|
|
Title |
Char 30 |
151 |
Title on Natural Person record |
|
|
Forename |
Char 30 |
181 |
First Name 1 on Natural Person record |
|
|
Middle Names |
Char 30 |
211 |
First Name 2 and First Name 3 on Natural Person record |
|
|
Surname |
Char 30 |
241 |
Surname on Natural Person record |
|
|
Previous Surname |
Char 30 |
271 |
Original Name on Natural Person record |
|
|
Street Address 1 |
Char 30 |
301 |
Address Line 1 on Client Address linked to the Person and with an Address Type of RESIDENTIAL |
|
|
Street Address 2 |
Char 30 |
331 |
Address Line 2 on Client Address linked to the Person and with an Address Type of RESIDENTIAL |
|
|
Street Address 3 |
Char 30 |
361 |
Address Line 3 on Client Address linked to the Person and with an Address Type of RESIDENTIAL. If null then spaces. |
|
|
Street Address 4 |
Char 30 |
391 |
Address Line 4 on Client Address linked to the Person and with an Address Type of RESIDENTIAL. If null then spaces. |
|
|
Postal Town |
Char 30 |
421 |
Address Line 5 on Client Address linked to the Person and with an Address Type of RESIDENTIAL. If null then spaces. |
|
|
County |
Char 30 |
451 |
Province on Client Address linked to the Person and with an Address Type of RESIDENTIAL |
|
|
UK Postcode / ZIP |
Char 10 |
481 |
Postal Code on Client Address with an Address Type of RESIDENTIAL |
|
|
Country |
Char 30 |
491 |
Country on Client Address linked to the Person and with an Address Type of RESIDENTIAL |
|
|
Date of Birth |
Char 10 |
521 |
Date of Birth on Natural Person record in the format YYYY/MM/DD |
|
|
Passport Number |
Char 30 |
531 |
Identity Number on Natural Person record for which the Identity Type is PASSPORT |
|
|
Nationality |
Char 30 |
561 |
Nationality on Natural Person record. |
|
|
National Identity (e.g. NINO) |
Char 30 |
591 |
Identity Number on Natural Person record for which the Identity Type is not PASSPORT |
|
|
Job Title |
Char 50 |
621 |
First 50 characters of the value for Description for the UDPV Position Type on the Client Relationship with a Client Relationship Type of EMPLOYS. |
|
|
TRAILER RECORD |
|||
|
Field |
Format |
Position |
Vision Value / Default Value |
|
Record ID |
Char 20 |
1 |
TRAILER RECORD |
|
Detail Record count |
Char 10 |
21 |
Total number of detail records |
When the file has been created the system will read the Description for the Batch Parameter SCREENING FILE and for the value env insert the environment e.g. uat or prd, and for the value Country insert the value for the first three characters of the country.