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 |