CA Social Insurance Number (SIN) generator

Last modified: April 3, 2025

The CA Social Insurance Number (SIN) generator produces formatted Canadian Social Insurance Numbers (SINs) for testing and simulation purposes. SINs are nine-digit identifiers used by the Canadian government to administer various social programs and services, including taxation, employment insurance, and pensions.

Note

If you select Canada from the Country-specific data list on the Options page of the Data Generator Project Properties wizard, the CA Social Insurance Number (SIN) generator will be applied to columns that meet the matching rules, replacing the default (United States) generator.

CA country specific data

Generator properties

The table provides key details about the generator, including the short name, sample of the generated data, the supported data types, and whether it is specific to a particular country.

Short name Example of generated data Data type matching Country-specific
CA SIN 891499592, 190405944, …891 499 592, 190 405 944, … character varyingcharactertextbigintintegerdecimal CA

Matching rules

The generator can be assigned to a column whose name is ‘SIN’, and it belongs to a table whose name is ‘Person’, ‘User’, ‘Cust’, ‘Emp’, or ‘Employee’.

Configure additional options

The tool allows you to specify a separator between groups of digits. By default, a hyphen is used to separate the digits.

Preview of the column data generated by the CA Social Insurance Number (SIN) generator

CA Social Insurance Number (SIN) generator