Examples of Common Identifiers
Allowance number
- Description
-
Builds an allowance number (Zulagennummer) based on the following input parameters:
-
number of the insurer (place 1-2)
-
date of birth of the insured person (place 3-8)
-
family name of the insured person (place 9)
-
gender, 00-49 male, 50-99 female (place 10-11)
-
check digit (place 12)
The allowance number is equal to the German social security number and is e.g. important to determine the pension income of an employee, to manage health insurance, as well as other issues concerning social security. The number is normally assigned to an employee via the first paycheck. Some employees like public officials, judges and soldiers have to request their allowance number manually. The allowance number is used to determine the increment of the German Riester pension (German subsidized private pension).
-
- Input type
-
COLUMN
- Parameters
| Display name | Description | Variable name | Data type | Default value | Possible values |
|---|---|---|---|---|---|
Area Number |
Number of the insurer |
areaNumber |
STRING |
- |
- |
Birth Date |
Birth date in the format ddMMYY or YYYY-MM-dd or as Date |
birthDate |
STRING |
- |
- |
Last Name |
Last name at the time of the application |
lastName |
STRING |
- |
- |
Gender |
00-49 for male, 50-99 for female |
gender |
STRING |
- |
- |
Bank identifier code
- Description
-
Generates a bank identifier code (also known as ISO 9362 or SWIFT code) based on the specified seed value. The country parameter specifies the country/region of origin ('AT', 'CH', 'DE', 'NL'). Only a single country value can be specified (e.g. 'DE'). This method requires the lookup tables to be installed.
- Input type
-
COLUMN
- Parameters
| Display name | Description | Variable name | Data type | Default value | Possible values |
|---|---|---|---|---|---|
Seed |
Column that is used to calculate the hash. |
seed |
STRING |
- |
- |
Country |
Specifies the origin of the bank identifier code. |
country |
STRING |
- |
- |
Bank name
- Description
-
Generates a bank name based on the specified seed value. The country parameter specifies the country/region of origin ('AT', 'CH', 'DE', 'NL'). Only a single country value can be specified (e.g. 'DE'). This method requires the lookup tables to be installed.
- Input type
-
COLUMN
- Parameters
| Display name | Description | Variable name | Data type | Default value | Possible values |
|---|---|---|---|---|---|
Seed |
Column that is used to calculate the hash. |
seed |
STRING |
- |
- |
Country |
Specifies the origin of the bank name. |
country |
STRING |
- |
- |
Canadian social insurance number
- Description
-
Generates a Canadian social insurance number (SIN) based on the specified seed value. The generated SIN is returned as a string. Leading zeroes are preserved.
- Input type
-
COLUMN
- Parameters
| Display name | Description | Variable name | Data type | Default value | Possible values |
|---|---|---|---|---|---|
Seed |
Specify a value that is used to calculate the hash. |
seed |
STRING |
- |
- |
Delimiter |
The delimiter character used to separate the groups of digits. May be empty. |
delimiter |
STRING |
- |
- |
Credit card number
- Description
-
Generates a credit card number. The first parameter should be an existing credit card number. The second parameter specifies how many digits are copied unchanged from the original number.
- Input type
-
COLUMN
- Parameters
| Display name | Description | Variable name | Data type | Default value | Possible values |
|---|---|---|---|---|---|
Seed |
The original credit card number. |
seed |
STRING |
- |
- |
Retain |
The number of digits to retain from the original number. |
retain |
NUMBER |
- |
- |
Czech birthday number
- Description
-
Generates a Czech birthday number based on the birthday and sex parameters. The generated number is returned as a string. If the value is a date it will be used as is. All other values will be hashed.
- Input type
-
COLUMN
- Parameters
| Display name | Description | Variable name | Data type | Default value | Possible values |
|---|---|---|---|---|---|
Birthday |
Specify a value that is used to calculate the hash. |
birthday |
STRING |
- |
- |
Sex |
Specifies the gender of the first name. |
sex |
STRING |
- |
- |
Delimiter |
The delimiter character used to separate the groups of digits. May be empty. |
delimiter |
STRING |
/ |
- |
International bank account number
- Description
-
Generates an international bank account number (IBAN) based on the specified seed value. The country parameter specifies the country/region of origin ('AT', 'CH', 'DE', 'NL'). Only a single country value can be specified (e.g. 'DE'). This method requires the lookup tables to be installed.
- Input type
-
COLUMN
- Parameters
| Display name | Description | Variable name | Data type | Default value | Possible values |
|---|---|---|---|---|---|
Seed |
Column that is used to calculate the hash. |
seed |
STRING |
- |
- |
Country |
Specifies the origin of the international bank account number. |
country |
STRING |
- |
- |
National bank identifier code
- Description
-
Generates a national bank identifier code (also known as Bankleitzahl in Austria and Germany, and as Instituts-Identifikation or Bankclearing-Nummer in Switzerland) based on the specified seed value. The country parameter specifies the country/region of origin ('AT', 'CH', 'DE', 'NL'). Only a single country value can be specified (e.g. 'DE'). This method requires the lookup tables to be installed.
- Input type
-
COLUMN
- Parameters
| Display name | Description | Variable name | Data type | Default value | Possible values |
|---|---|---|---|---|---|
Seed |
Column that is used to calculate the hash. |
seed |
STRING |
- |
- |
Country |
Specifies the origin of the national bank identifier code. |
country |
STRING |
- |
- |
Swedish id
- Description
-
Generates a Swedish id based on the birthday parameter. The generated ID is returned as a string. If the value is a date it will be used as is. All other values will be hashed.
- Input type
-
COLUMN
- Parameters
| Display name | Description | Variable name | Data type | Default value | Possible values |
|---|---|---|---|---|---|
Birthday |
Specify a value that is used to calculate the hash. |
birthday |
STRING |
- |
- |
Delimiter |
The delimiter character used to separate the groups of digits. May be empty. |
delimiter |
STRING |
- |
- |
German tax identification number
- Description
-
This modification method works column based. The input is the value of the current column, which is used to generate a number looking like the German tax identification number, which has to fulfill the following requirements:
-
The first number must not be 0
-
In the first 10 digits there is one number double or triple
-
If there are 3 same numbers at the position 1 to 10 those double numbers could never be consecutive
-
Information about how the check digit is generated and the criteria of a valid number: Prüfziffernberechnung (PDF): https://www.zfa.deutsche-rentenversicherung-bund.de/de/Inhalt/public/4_ID/47_Pruefziffernberechnung/001_Pruefziffernberechnung.pdf?__blob=publicationFile&v=2
Background information about the number: Tax identification number – BZSt: https://www.bzst.de/EN/Private_individuals/Tax_identification_number/tax_identification_number_node.html
- Input type
-
COLUMN
- Parameters
| Display name | Description | Variable name | Data type | Default value | Possible values |
|---|---|---|---|---|---|
Seed |
The original German tax identification number |
seed |
STRING |
- |
- |
U.S. social security number
- Description
-
Generates a U.S. Social Security Number (SSN) based on the specified seed value.The generated SSN is returned as a string. Leading zeroes are preserved.
- Input type
-
COLUMN
- Parameters
| Display name | Description | Variable name | Data type | Default value | Possible values |
|---|---|---|---|---|---|
Seed |
Specify a value that is used to calculate the hash. |
seed |
STRING |
- |
- |
Delimiter |
The delimiter character used to separate the groups of digits. May be empty. |
delimiter |
STRING |
- |
- |