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_?-? ?)(addr?e?s?s?)?)$ |
|
| Email_V2_2 | (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 | 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 |