Skip to main content
Skip table of contents

Standard profile set expressions

This section lists all the column and type profile expressions used by the standard profile set included with the product.

Column level expressions

Expression Name

Domain

Expression

Account_Number_V2

ACCOUNT_NO

(?>(account|accnt|acct)_?-? ?(number|num|nbr|no|user))$

Address_Line1_V2

ADDRESS

(?>((street_?-? ?address)|street|address)_?-? ?((line)? ?_?(1|))?)$

Address_Line2_V2

ADDRESS_LINE2

(?>((street_?-? ?address)|street|address)_?-? ?((line)? ?_?(2|3|4|5))?)$

Beneficiary_NO_V2

BENEFICIARY_NO

(?>(bene(ficiary)?_?-? ?(Number|Num|Nbr|No|Id)))$

Biometric_V2

BIOMETRIC

(?>(biometric)$)

Certificate_Number_V2

CERTIFICATE_NO

(?>(Cert(ificate)?_?-? ?(Number|Num|Nbr|No)))$

Certificate_ID_V2

CERTIFICATE_NO

(?>cert(ificate)?_?-? ?id)

City_V2

CITY

(?>^(address_?-? ?city|city|city_?-? ?address)$)

City_V2_2

CITY

(?>^(address|home_?-? ?city|city|city_?-? ?ad?dress?e?)$)

County_V2

COUNTY

(?>(county)$)

Card_Number_V2

CREDIT CARD

(?>card_?-? ?(number|num|nbr|no))$

Credit_Card_Number_V2

CREDIT CARD

(?>credit_?-? ?card_?-? ?(number|num|nbr|no))$

Customer_Number_V2

CUSTOMER_NO

(?>(cust(omer|mr)?) ?_?-?(num(ber)?|nbr|no))$

Birth_Date_V2

DOB

(?>b(irth)?_?-? ?(date|day|dt))$

DOB_Date_V2

DOB

(?>dob|dtofb|(day|date?|dt)_?-?(of)?_?(birth))$

Admission_Date_V2

DOB

(?>(adm(it|ission)?|tr(ea)?t(ment)?_?-?|ds|disc(h|harge))_? ?(date|day|dt))$

Drivers_License_Number_V2

DRIVING_LC

(?>(drivers?|lic(ense)?)_?-? ?(number|num|nbr|no))$

Email_V2

EMAIL

(?>(email_?-? ?)(addr?e?s?s?)?)$

Email_V2_2

EMAIL

(cust|customer|partner|home|private|def|default)_?-? ?(email)_?-? ?(address|)

First_Name_V2

FIRST_NAME

(?>(f(irst)?_?-? ?(na?me?))(_?-?user)?)$

Middle_Name_V2

FIRST_NAME

(?>(mid(dle)?_?-? ?(na?me?))(_?-?user)?)$

Full_Name_V2

FULL_NAME

(?>((fu?l?l_?-? ?|whole_?-? ?)?_?-?(na?me?))(_?-?user)?)$

IP_Address_V2

IP ADDRESS

(?>(ip_?-? ?addre?s?s?))$

Last_Name_V2

LAST_NAME

(?>((l(as)?t)_?-? ?(na?me?))(_?-?user)?)$

Surname_V2

LAST_NAME

(?>(sur) ?_?-? ?(name)?_?-? ?(no|id|str|value|))

Password_V2

PASSWORD

(?>(pass) ?_?-??(word)?_?-? ?(word|nbr|no|id|value|))

PO_Box_V2

PO_BOX

(?>(p.?o.?_?-? ?box|post_?-? ?office_?-? ?box ?_?-?)(number|num|nbr|no)?$)

Precinct_V2

PRECINCT

(?>precinct|prcnct)$

Record_Number_V2

RECORD_NO

(?>(rec|record)_?(number|num|nbr|no))$

School_Name_V2

SCHOOL_NM

(?>school_?-?na?me?)$

Security_Code_V2

SECURITY_CODE

(?>se?cu?r(i?ty?)?_?co?de?)$

Serial_Number_V2

SERIAL_NO

(?>(ser(ial)?)_?-? ?(number|num|nbr|no))$

Signature_V2

SIGNATURE

(?>(signature)$)

Social_Security_Number_V2

SSN

(?>(ssn$|social_?-? ?security_?-? ?(number|num|nbr|no|code|id))$)

TaxID_Code_or_Number_V2

TAX_ID

(?>(tax)_?-? ?(id(ent)?)_?-? ?((co?de?)|(number|num|nbr|no))?)$

TaxID_Number_V2

TAX_ID

(?>tin$)

Telephone_or_Contact_Number_V2

TELEPHONE_NO

(?>(phone|contact|tel|fax)_?-? ?)(number|num|nbr|no)?$

Vehicle_V2

VIN_NO

(?>(vehicle)$)

VIN_NO_V2

VIN_NO

(?>(^vin$|Vehicle_?-? ?Id(entification)?_?-? ?(Number|Num|Nbr|No))$)

Web_URL_Address_V2

WEB

(?>(^url_?-? ?|web_? ?)(addr?e?s?s?)?)$

Zip_or_Postal_Code_V2

ZIP

(?>(zip|post|postal)_?-? ?(co?de?)|(zip))

Type expressions

The column data type, if recognized, must match one of the specified types for the domain to be assigned.

Expression Name

Domain

Expression

Minimum Length

ACCOUNT_NO_type_V2

ACCOUNT_NO

Number

5

ACCOUNT_NO_type_V2_2

ACCOUNT_NO

String

5

ADDRESS_type_V2

ADDRESS

String

20

ADDRESS_LINE2_type_V2

ADDRESS_LINE2

String

20

BENEFICIARY_NO_type_V2

BENEFICIARY_NO

String

10

BENEFICIARY_NO_type_V2_2

BENEFICIARY_NO

Number

5

BIOMETRIC_type_V2

BIOMETRIC

String

10

BIOMETRIC_type_V2_2

BIOMETRIC

Binary

None

CERTIFICATE_NO_type_V2

CERTIFICATE_NO

String

10

CERTIFICATE_NO_type_V2_2

CERTIFICATE_NO

Number

5

CITY_type_V2

CITY

String

10

COUNTY_type_V2

COUNTY

String

10

CREDIT CARD_type_V2

CREDIT CARD

String

15

CREDIT CARD_type_V2_2

CREDIT CARD

Number

15

CUSTOMER_NO_type_V2

CUSTOMER_NO

String

5

CUSTOMER_NO_type_V2_2

CUSTOMER_NO

Number

5

DOB_type_V2

DOB

String

6

DOB_type_V2_2

DOB

Date

None

DRIVING_LC_type_V2

DRIVING_LC

String

10

DRIVING_LC_type_V2_2

DRIVING_LC

Number

10

EMAIL_type_V2

EMAIL

String

20

FIRST_NAME_type_V2

FIRST_NAME

String

10

FULL_NAME_type_V2

FULL_NAME

String

20

IP ADDRESS_type_V2

IP ADDRESS

String

10

LAST_NAME_type_V2

LAST_NAME

String

10

PASSWORD_type_V2

PASSWORD

String

6

PO_BOX_type_V2

PO_BOX

String

4

PO_BOX_type_V2_2

PO_BOX

Number

4

PRECINCT_type_V2

PRECINCT

String

None

PRECINCT_type_V2_2

PRECINCT

Number

None

RECORD_NO_type_V2

RECORD_NO

String

5

RECORD_NO_type_V2_2

RECORD_NO

Number

5

SCHOOL_NM_type_V2

SCHOOL_NM

String

20

SECURITY_CODE_type_V2

SECURITY_CODE

String

5

SECURITY_CODE_type_V2_2

SECURITY_CODE

Number

5

SERIAL_NO_type_V2

SERIAL_NO

Number

None

SERIAL_NO_type_V2_2

SERIAL_NO

String

None

SIGNATURE_type_V2

SIGNATURE

String

None

SIGNATURE_type_V2_2

SIGNATURE

Binary

None

SSN_type_V2

SSN

String

None

SSN_type_V2_2

SSN

Number

None

TAX_ID_type_V2

TAX_ID

String

6

TAX_ID_type_V2_2

TAX_ID

Number

6

TELEPHONE_NO_type_V2

TELEPHONE_NO

String

7

TELEPHONE_NO_type_V2_2

TELEPHONE_NO

Number

7

VIN_NO_type_V2

VIN_NO

String

10

WEB_type_V2

WEB

String

10

ZIP_type_V2

ZIP

Number

4

ZIP_type_V2_2

ZIP

String

4

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.