SAS Quality Knowledge Base for Contact Information 25
Definitions for the Italian, Italy locale are described below.
Case Definitions
Gender Analysis Definitions
Identification Analysis Definitions
Match Definitions
Parse Definitions
Pattern Analysis Definitions
Standardization Definitions
Inherited Definitions
Proper (Address) | ||
---|---|---|
Description | The Case definition for Proper (Address) propercases addresses. | |
Input | Output | |
Examples | L GO CAVALIERI DI MALTA, 6 | L go Cavalieri di Malta, 6 |
PIAZZA PIO XI 53 A-B | Piazza Pio XI 53 A-B | |
MEDAGLIE D'ORO 399 | Medaglie d'Oro 399 | |
P ZZA DELLA REPUBBLICA 1/A | P zza della Repubblica 1/A | |
P.LE CARLO ARCHINTO 7 | P.le Carlo Archinto 7 | |
Remarks |
Social Security Number | ||
---|---|---|
Description | The Gender Analysis definition for Social Security Number determines the gender associated with an Italian Social Security Number. | |
Possible Outputs | M F U |
|
Input | Output | |
Examples | BRNLGU71D13F205J | M |
BRNLGU71H50E155Q | F | |
BRNLGU76B28F205U | M | |
BRNLIA63H65B716Z | F | |
BRNLLL40A58L220M | F | |
Remarks |
None.
Address | ||
---|---|---|
Description | The Address match definition generates match codes which can be used to cluster records containing addresses. | |
Max Length of Match Code | 37 characters | |
Input | Cluster ID | |
Examples | corso Sempione 17/10 | 0 |
via Sempione 17-10 | 0 | |
C.So Italia 46 / CP. N° 7709 Focette | 1 | |
CP. N° 7709 Focette, C.So Italia 46 | 1 | |
Strada Statale Padana Superiore km 30.700 | 2 | |
SS 11 KM 30+700 | 2 | |
Remarks |
Note: The results listed above reflect the default match sensitivity (85). |
|
The Street Type is included in the match code at sensitivity 95. Street number is completely excluded at sensitivity 50. Information from Street Name and PO Box Number are (if present in the input string) always part of the match key. |
Address (PO Box Only) | ||
---|---|---|
Description | The Address (PO Box Only) match definition generates match codes which can be used to cluster records containing the PO Box portion of an address. | |
Max Length of Match Code | 15 characters | |
Input | Cluster ID | |
Examples | C.So Italia 46 / CP. N° 7709 Focette | 0 |
CP. N° 7709 Focette, C.So Italia 46 | 0 | |
CP. N° 7709 Focette, C.So Italia 11 | 0 | |
CP.7709 | 0 | |
Casella Postale 12601 Uff. Postale di Castellammare Del Golfo | 1 | |
CP N° 12601 | 1 | |
Remarks |
Note: The results listed above reflect the default match sensitivity (85). |
|
The street address information is always omitted from the match code. |
Address (Street Only) | ||
---|---|---|
Description | The Address (Street Only) match definition generates match codes which can be used to cluster records containing the street portion of an address. | |
Max Length of Match Code | 31 characters | |
Input | Cluster ID | |
Examples | corso Sempione 17/10 | 0 |
via Sempione 17-10 | 0 | |
Cso Xxii Marzo 63 / C.P. 81000 | 1 | |
C.P. 91075, Cso Xxii Marzo 63 | 1 | |
Cso Xxii Marzo 63 | 1 | |
Strada Statale Padana Superiore km 30.700 | 2 | |
SS 11 KM 30+700 | 2 | |
Remarks |
Note: The results listed above reflect the default match sensitivity (85). |
|
The PO Box number is always omitted from the match code. |
City | ||
---|---|---|
Description | The City match definition generates match codes which can be used to cluster records containing city names. | |
Max Length of Match Code | 23 characters | |
Input | Cluster ID | |
Examples | Abano Terme Bagni | 0 |
Abano Tme Bagni | 0 | |
Acquanegra Chiese | 1 | |
Acquanegra Sul Chiese | 1 | |
Baia e Latina | 2 | |
Baia/Latina | 2 | |
Baia & Latina | 2 | |
Baia-Latina | 2 | |
Belforte | 3 | |
Belforte Del Chienti | 3 | |
Remarks |
Note: The results listed above reflect the default match sensitivity (85). |
City - State/Province - Postal Code | ||
---|---|---|
Description | The City - State/Province - Postal Code match definition generates match codes which can be used to cluster records containing last line address information. | |
Max Length of Match Code | 40 characters | |
Input | Cluster ID | |
Examples | Darfo Boario Terme 25040 BS | 0 |
25040 Darfo Boario Tme BS | 0 | |
00118 Roma | 1 | |
118 Roma | 1 | |
67040 Ocre, L'Aquila | 2 | |
67041 Ocre, Aquila | 2 | |
Remarks |
Note: The results listed above reflect the default match sensitivity (85). |
Phone | ||
---|---|---|
Description | The Phone match definition generates match codes which can be used to cluster records containing phone numbers. | |
Max Length of Match Code | 22 characters | |
Input | Cluster ID | |
Examples | (+39) 0444 965351 | 0 |
0039 0444 965351 | 0 | |
0444 965351 | 0 | |
+44 (0)2012345000 | 1 | |
+44 2012345000 | 1 | |
06 12345678 | 2 | |
06 12345670 | 2 | |
06 12345600 | 3 | |
045 1234567 | 4 | |
045 1234560 | 4 | |
045 1234500 | 5 | |
0165 884685 | 6 | |
165 884685 | 6 | |
Remarks |
Note: The results listed above reflect the default match sensitivity (85). |
|
Note that the number of digits retained in the match codes is a function of the number of digits in the base number and the match sensitivity. Two domestic numbers match if one contains the area code's leading zero and the other does not, as shown in the final 2 examples. |
Postal Code | ||
---|---|---|
Description | The Postal Code match definition generates match codes which can be used to cluster records containing postal codes. | |
Max Length of Match Code | 15 characters | |
Input | Cluster ID | |
Examples | 60042 | 0 |
CAP 60042 | 0 | |
IT-60042 | 0 | |
10118 | 1 | |
Remarks |
Note: The results listed above reflect the default match sensitivity (85). |
Social Security Number | ||
---|---|---|
Description | The Social Security Number match definition generates match codes which can be used to cluster records containing Social Security Numbers. | |
Max Length of Match Code | 16 characters | |
Input | Cluster ID | |
Examples | BRNGTN66L09F205Z | 0 |
BRNGTN66L09F205J | 0 | |
BRPGTF66L09F205Z | 1 | |
Remarks |
Note: The results listed above reflect the default match sensitivity (85). |
|
A Control Code is included in the match code at sensitivities 90 and 95. Year, month, and day/gender are included in all sensitivities. |
State/Province | ||
---|---|---|
Description | The State/Province match definition generates match codes which can be used to cluster records containing states and provinces. | |
Max Length of Match Code | 15 characters | |
Input | Cluster ID | |
Examples | ASCOLI PICENO AP | 0 |
ASCOLI PICENO | 0 | |
AP | 0 | |
Pesaro e Urbino | 1 | |
Remarks |
Note: The results listed above reflect the default match sensitivity (85). |
|
"Repubblica di San Marino" and "Città del Vaticano" are considered Italian provinces for the purposes of matching. |
Address | |||
---|---|---|---|
Description | The Parse definition for Address parses addresses into a set of tokens. | ||
Output Tokens | Building Name Street Type Additional Street Type Street Name Street Number Street Number Extension PO Box Post Office Location Additional Info |
||
Input | Output | ||
Example 1 | Villa Taranto Strada Privata Belfiore 2/E C.P. 23423 Zona Pallanza | Building Name | Villa Taranto |
Street Type | Strada | ||
Additional Street Type | Privata | ||
Street Name | Belfiore | ||
Street Number | 2 | ||
Street Number Extension | E | ||
PO Box | C.P. 23423 | ||
Post Office Location | |||
Additional Info | Zona Pallanza | ||
Input | Output | ||
Example 2 | Palazzo 1 Via Superiore Del Boscasso 10 Casella Postale 15264 Uff. PPTT Napoli | Building Name | Palazzo 1 |
Street Type | Via | ||
Additional Street Type | Superiore | ||
Street Name | Del Boscasso | ||
Street Number | 10 | ||
Street Number Extension | |||
PO Box | Casella Postale 15264 | ||
Post Office Location | Uff. PPTT Napoli | ||
Additional Info | |||
Input | Output | ||
Example 3 | via Mario Rossi 5/A angolo via Marinetti | Building Name | |
Street Type | via | ||
Additional Street Type | |||
Street Name | Mario Rossi | ||
Street Number | 5 | ||
Street Number Extension | A | ||
PO Box | |||
Post Office Location | |||
Additional Info | angolo via Marinetti | ||
Remarks |
Address (Full) | |||
---|---|---|---|
Description | The Parse definition for Address (Full) parses complete two-line addresses. | ||
Output Tokens | Building Name Building Number Street Extension Postal Code City State/Province Additional Info |
||
Input | Output | ||
Example 1 | Piazza Del Maestrale - Fabbricato 4 - 84131 Salerno (Sa) | Building Name | |
Building Number | |||
Street | Piazza Del Maestrale | ||
Extension | |||
Postal Code | 84131 | ||
City | Salerno | ||
State/Province | (Sa) | ||
Additional Info | Fabbricato 4 | ||
Input | Output | ||
Example 2 | Via D. Padula 121 Pal. Gardenia 80126 Napoli Na | Building Name | Pal. Gardenia |
Building Number | 121 | ||
Street | Via D. Padula | ||
Extension | |||
Postal Code | 80126 | ||
City | Napoli | ||
State/Province | Na | ||
Additional Info | |||
Input | Output | ||
Example 3 | Via Alfredo 19 Casella Postale 12300 - 00199 Roma Rm | Building Name | |
Building Number | 19 | ||
Street | Via Alfredo | ||
Extension | Casella Postale 12300 | ||
Postal Code | 00199 | ||
City | Roma | ||
State/Province | Rm | ||
Additional Info | |||
Remarks |
Address (Global) | |||
---|---|---|---|
Description |
The Address (Global) parse definition parses addresses into a globally recognized set of tokens. |
||
Output Tokens | Recipient Building/Site Street Extension PO Box Additional Info |
||
Input | Output | ||
Example 1 | Villa Taranto Strada Privata Belfiore 2/E C.P. 23423 Zona Pallanza | Recipient | |
Building/Site | Villa Taranto | ||
Street | Strada Privata Belfiore 2 | ||
Extension | E | ||
PO Box | C.P. 23423 | ||
Additional Info | Zona Pallanza | ||
Input | Output | ||
Example 2 | via Mario Rossi 5/A angolo via Marinetti | Recipient | |
Building/Site | |||
Street | via Mario Rossi 5 | ||
Extension | A | ||
PO Box | |||
Additional Info | angolo via Marinetti | ||
Remarks | Parse definitions named with the Global keyword use a set of output tokens that is consistent across every locale. Results obtained from these definitions can be stored in the same database fields as the results obtained from definitions of the same name in other locales. | ||
The Address (Global) (v23) parse definition is now deprecated and will be removed in a future release of the QKB. The Address (Global) parse definition has been replaced with a copy of the Address (Global) (v23) definition which takes advantage of the new tokens and updated processing. If you changed your jobs to use Address (Global) (v23) it is suggested that you change them back. |
Address (Global) (v23) | |||
---|---|---|---|
Description |
The Address (Global) (v23) parse definition parses addresses into a globally recognized set of tokens. |
||
Output Tokens | Recipient Building/Site Street Extension PO Box Additional Info |
||
Input | Output | ||
Example 1 | Villa Taranto Strada Privata Belfiore 2/E C.P. 23423 Zona Pallanza | Recipient | |
Building/Site | Villa Taranto | ||
Street | Strada Privata Belfiore 2 | ||
Extension | E | ||
PO Box | C.P. 23423 | ||
Additional Info | Zona Pallanza | ||
Input | Output | ||
Example 2 | via Mario Rossi 5/A angolo via Marinetti | Recipient | |
Building/Site | |||
Street | via Mario Rossi 5 | ||
Extension | A | ||
PO Box | |||
Additional Info | angolo via Marinetti | ||
Remarks | Parse definitions named with the Global keyword use a set of output tokens that is consistent across every locale. Results obtained from these definitions can be stored in the same database fields as the results obtained from definitions of the same name in other locales. | ||
The Address (Global) (v23) parse definition is now deprecated and will be removed in a future release of the QKB. The Address (Global) parse definition has been replaced with a copy of the Address (Global) (v23) definition which takes advantage of the new tokens and updated processing. If you changed your jobs to use Address (Global) (v23) it is suggested that you change them back. |
City - State/Province - Postal Code | |||
---|---|---|---|
Description | The Parse definition for City - State/Province - Postal Code parses address last line data into a set of tokens. | ||
Output Tokens | City State/Province Postal Code Additional Info |
||
Input | Output | ||
Example 1 | Navelli, 67020 L'Aquila | City | Navelli |
State/Province | L'Aquila | ||
Postal Code | 67020 | ||
Additional Info | |||
Input | Output | ||
Example 2 | 30023 Lignano Sabbiadoro, Udine | City | Lignano Sabbiadoro |
State/Province | Udine | ||
Postal Code | 30023 | ||
Additional Info | |||
Input | Output | ||
Example 3 | Via Rio 7 30030 Camponogara (VE) | City | Camponogara |
State/Province | (VE) | ||
Postal Code | 30030 | ||
Additional Info | Via Rio 7 | ||
Remarks |
City - State/Province - Postal Code (Global) | |||
---|---|---|---|
Description | The Parse definition for City - State/Province - Postal Code (Global) parses address last line data into a globally recognized set of tokens. | ||
Output Tokens | City State/Province Postal Code Additional Info |
||
Input | Output | ||
Example 1 | Navelli, 67020 L'Aquila | City | Navelli |
State/Province | L'Aquila | ||
Postal Code | 67020 | ||
Additional Info | |||
Input | Output | ||
Example 2 | 30023 Lignano Sabbiadoro, Udine | City | Lignano Sabbiadoro |
State/Province | Udine | ||
Postal Code | 30023 | ||
Additional Info | |||
Input | Output | ||
Example 3 | Via Rio 7 30030 Camponogara (VE) | City | Camponogara |
State/Province | (VE) | ||
Postal Code | 30030 | ||
Additional Info | Via Rio 7 | ||
Remarks |
Parse definitions named with the Global keyword use a set of output tokens that is consistent across every locale. Results obtained from these definitions can be stored in the same database fields as the results obtained from definitions of the same name in other locales. |
Phone | |||
---|---|---|---|
Description | The Parse definition for Phone parses phone numbers into a set of tokens. | ||
Output Tokens | Country Code Area Code Base Number Extension Line Type Additional Info |
||
Input | Output | ||
Example 1 | Ufficio: +39 06 7980 0323 Est. 208 (notte e nei fine settimana) | Country Code | +39 |
Area Code | 06 | ||
Base Number | 7980 0323 | ||
Extension | 208 | ||
Line Type | Ufficio: | ||
Additional Info | (notte e nei fine settimana) | ||
Input | Output | ||
Example 2 | 347/9987676 - cellulare | Country Code | |
Area Code | |||
Base Number | 347/9987676 | ||
Extension | |||
Line Type | cellulare | ||
Additional Info | |||
Input | Output | ||
Example 3 | MGE UPS Systems: +33 8 00 33 68 58 | Country Code | +33 |
Area Code | |||
Base Number | 8 00 33 68 58 | ||
Extension | |||
Line Type | |||
Additional Info | MGE UPS Systems: | ||
Input | Output | ||
Example 4 | 02 321661 (Numero Fax) | Country Code | |
Area Code | 02 | ||
Base Number | 321661 | ||
Extension | |||
Line Type | (Numero Fax) | ||
Additional Info | |||
Remarks |
Phone (Global) | |||
---|---|---|---|
Description | The Parse definition for Phone (Global) parses phone numbers into a globally recognized set of tokens. | ||
Output Tokens | Country Code Area Code Base Number Extension Line Type Additional Info |
||
Input | Output | ||
Example 1 | Ufficio: +39 06 7980 0323 Est. 208 (notte e nei fine settimana) | Country Code | +39 |
Area Code | 06 | ||
Base Number | 7980 0323 | ||
Extension | 208 | ||
Line Type | Ufficio: | ||
Additional Info | (notte e nei fine settimana) | ||
Input | Output | ||
Example 2 | 347/9987676 - cellulare | Country Code | |
Area Code | |||
Base Number | 347/9987676 | ||
Extension | |||
Line Type | cellulare | ||
Additional Info | |||
Input | Output | ||
Example 3 | MGE UPS Systems: +33 8 00 33 68 58 | Country Code | +33 |
Area Code | |||
Base Number | 8 00 33 68 58 | ||
Extension | |||
Line Type | |||
Additional Info | MGE UPS Systems: | ||
Input | Output | ||
Example 4 | 02 321661 (Numero Fax) | Country Code | |
Area Code | 02 | ||
Base Number | 321661 | ||
Extension | |||
Line Type | (Numero Fax) | ||
Additional Info | |||
Remarks | Parse definitions named with the Global keyword use a set of output tokens that is consistent across every locale. Results obtained from these definitions can be stored in the same database fields as the results obtained from definitions of the same name in other locales. |
Phone (Separate Mobile Prefix) | |||
---|---|---|---|
Description | The Parse definition for Phone (Separate Mobile Prefix) parses phone numbers into a set of tokens and parses the mobile phone prefix into its own token. | ||
Output Tokens | Country Code Area Code Mobile Prefix Base Number Extension Line Type Additional Info |
||
Input | Output | ||
Example 1 | 347/9987676 - cellulare | Country Code | |
Area Code | |||
Mobile Prefix | 347 | ||
Base Number | 9987676 | ||
Extension | |||
Line Type | cellulare | ||
Additional Info | |||
Input | Output | ||
Example 2 | 331 6106543 | Country Code | |
Area Code | |||
Mobile Prefix | 331 | ||
Base Number | 6106543 | ||
Extension | |||
Line Type | |||
Additional Info | |||
Input | Output | ||
Example 3 | 3403431847 cell. del marito | Country Code | |
Area Code | |||
Mobile Prefix | 340 | ||
Base Number | 3431847 | ||
Extension | |||
Line Type | cell. | ||
Additional Info | del marito | ||
Input | Output | ||
Example 4 | Ufficio: +39 06 7980 0323 Est. 208 (notte e nei fine settimana) | Country Code | +39 |
Area Code | 06 | ||
Mobile Prefix | |||
Base Number | 7980 0323 | ||
Extension | 208 | ||
Line Type | Ufficio: | ||
Additional Info | (notte e nei fine settimana) | ||
Remarks |
Social Security Number | |||
---|---|---|---|
Description | The Parse definition for Social Security Number parses Social Security Numbers into a set of tokens. | ||
Output Tokens | Given Name Family Name Year Month Day/Gender City Code Control Code |
||
Input | Output | ||
Examples | BRNGTN66L09F205J | Given Name | BRN |
Family Name | GTN | ||
Year | 66 | ||
Month | L | ||
Day/Gender | 09 | ||
City Code | F205 | ||
Control Code | J | ||
Remarks |
None.
Accent | ||
---|---|---|
Description | The Standardization definition for Accent transforms apostrophe characters into accent marks where appropriate. | |
Input | Output | |
Examples | l'universita' | L'UNIVERSITÀ |
Affe' | AFFÈ | |
Abbu'ra | ABBÙRA | |
Ai`ro | AÌRO | |
Ai´ro | AÍRO | |
Remarks |
Address | ||
---|---|---|
Description | The Standardization definition for Address standardizes addresses. | |
Input | Output | |
Examples | Via Forte Tiburtino,160-Edif.14,Sc.C,Int | Via Forte Tiburtino, 160/Edificio 14, Scala C, Interno |
C. Post. N° 34393 Uff. PPTT Montalcinello | Casella Postale 34393 | |
P/zza G.D'Annunzio 16 | Piazza G d'Annunzio, 16 | |
Remarks |
Address (Postal Standard) | ||
---|---|---|
Description | The Standardization definition for Address (Postal Standard) standardizes addresses. | |
Input | Output | |
Examples | Via Forte Tiburtino,160-Edif.14,Sc.C,Int | VIA FORTE TIBURTINO, 160/ED 14, SC C, INT |
C. Post. N° 34393 Uff. PPTT Montalcinello | CASELLA POSTALE 34393 | |
P/zza G.D'Annunzio 16 | P.ZA G D'ANNUNZIO, 16 | |
Remarks | This definition standardizes addresses according to the recommended format of the Italian postal service. |
City | ||
---|---|---|
Description | The Standardization definition for City standardizes city names. | |
Input | Output | |
Examples | Abano Tme | Abano Terme |
Erbe' | Erbè | |
Barbara (AN) | Barbara, Ancona | |
Cornedo all'Isarco | Cornedo all'Isarco/Karneid | |
Remarks |
City (Postal Standard) | ||
---|---|---|
Description | The Standardization definition for City (Postal Standard) standardizes city names. | |
Input | Output | |
Examples | Abano Tme | ABANO TERME |
Erbe' | ERBE | |
Barbara (AN) | BARBARA AN | |
Cornedo all'Isarco | CORNEDO ALL ISARCO | |
Remarks | This definition standardizes city names according to the recommended format of the Italian postal service. |
City - State/Province - Postal Code | ||
---|---|---|
Description | The Standardization definition for City - State/Province - Postal Code standardizes address last line data. | |
Input | Output | |
Examples | Ferrera Di Varese 21030 VA | 21030 FERRERA DI VARESE VA |
Lodè 08020 NU | 08020 LODE NU | |
80058 Torre Del Greco (Napoli) | 80058 TORRE DEL GRECO NA | |
Catania CT, Codice Postale 95100 | 95100 CATANIA CT | |
Remarks | This definition standardizes city and province names according to the recommended format of the Italian postal service. |
City - State/Province - Postal Code (International) | ||
---|---|---|
Description | The Standardization definition for City - State/Province - Postal Code (International) standardizes address last line data and formats Postal Code with a country code prefix. | |
Input | Output | |
Examples | Ferrera Di Varese 21030 VA | IT-21030 FERRERA DI VARESE VA |
Lodè 08020 NU | IT-08020 LODE NU | |
80058 Torre Del Greco (Napoli) | IT-80058 TORRE DEL GRECO NA | |
Catania CT, Codice Postale 95100 | IT-95100 CATANIA CT | |
Remarks | City and province names are standardized according to recommendations given by the Italian postal service. |
Phone | ||
---|---|---|
Description | The Standardization definition for Phone standardizes phone numbers for domestic use. | |
Input | Output | |
Examples | +39 348 2146532 | 348 2146532 |
0039 02 764401 | 02 764401 | |
011 9723798 EST 456 | 011 9723798 x456 | |
0125 929384, uff. | 0125 929384, Uff | |
0044 (0)20 12345000 | +44 2012345000 | |
165/555414 | 0165 555414 | |
Remarks | A leading zero is added if it is missing from the area code, as shown in the final example. |
Phone (Electronic) | ||
---|---|---|
Description | The Standardization definition for Phone (Electronic) standardizes phone numbers for automated calling systems. | |
Input | Output | |
Examples | +39 010 6096111 | +390106096111 |
Ufficio: +39 06 7980 0323 Ext 208 (notte e nei fine settimana) | +390679800323 | |
0775 856 374 | +390775856374 | |
+39 (0165) 555414 | +390165555414 | |
0044 (0)20 12345000 | +442012345000 | |
+1-800-DATAFLUX | +180032823589 | |
Remarks |
Phone (with Country Code) | ||
---|---|---|
Description | The Standardization definition for Phone (with Country Code) standardizes phone numbers for international use. | |
Input | Output | |
Examples | 348 2146532 | +39 348 2146532 |
0039 02 764401 | +39 02 764401 | |
+39 3408281977 | +39 340 8281977 | |
+39 (0165) 555414 | +39 0165 555414 | |
+1 (919) 447-3000 | +1 9194473000 | |
Remarks |
Postal Code | ||
---|---|---|
Description | The Standardization definition for Postal Code standardizes postal codes. | |
Input | Output | |
Examples | 330 59 | 33059 |
IT33059 | 33059 | |
FR 12345 | FR-12345 | |
Remarks | This Standardization definition uses domestic formatting unless the input is a foreign postal code. |
Postal Code (with Country Code) | ||
---|---|---|
Description | The Standardization definition for Postal Code (with Country Code) standardizes postal codes and adds a domestic country code, unless there is already a country code in the input. | |
Input | Output | |
Examples | 33059 | IT-33059 |
FR 12345 | FR-12345 | |
Remarks | This Standardization definition uses international formatting, with no spaces. |
Social Security Number | ||
---|---|---|
Description | The Standardization definition for Social Security Number standardizes Social Security Numbers. | |
Input | Output | |
Examples | 'BRNGTN68B05F915Q' | BRNGTN68B05F915Q |
BRN-GTN-73-C-57-A225-D | BRNGTN73C57A225D | |
Remarks |
Social Security Number (Birth Date) | ||
---|---|---|
Description | The Standardization definition for Social Security Number (Birth Date) returns the birth date information in Italian Social Security Numbers in YYMMDD format. | |
Input | Output | |
Examples | 'BRNGTN68B05F915Q' | 680205 |
BRN-GTN-73-C-57-A225-D | 730317 | |
BJOISA56P12A123B | 560912 | |
JORPAU45P62C123B | 450922 | |
Remarks | This definition converts the single letter representing the month into a two-digit number. The definition also converts the two-digit number representing both day and gender into the correct day by subtracting 40 if the number is greater than 40. For example: 41 = 01, 57 = 17, 13 = 13. |
State/Province | ||
---|---|---|
Description | The Standardization definition for State/Province standardizes provinces to their full name. | |
Input | Output | |
Examples | FORLI CESENA | Forlì-Cesena |
FC | Forlì-Cesena | |
Provincie de Cúneo | Cuneo | |
SAN MARINO | Repubblica di San Marino | |
Vaticano | Città del Vaticano | |
Remarks | Repubblica di San Marino and Città del Vaticano (as shown in the examples above) are considered Italian provinces for the purposes of standardization. |
State/Province (Postal Standard) | ||
---|---|---|
Description | The Standardization definition for State/Province (Postal Standard) standardizes provinces to a 2-letter abbreviation. | |
Input | Output | |
Examples | FORLI CESENA | FC |
Forlì-Cesena | FC | |
Provincie de Cúneo | CN | |
Repubblica di San Marino | RSM | |
Città del Vaticano | Vaticano | |
Remarks | Repubblica di San Marino and Città del Vaticano do not have two letter abbreviations. |
In addition to the definitions listed on this page, the Italian, Italy locale also inherits all definitions for the Italian language and all Global definitions.
Documentation Feedback: yourturn@sas.com
|
Doc ID: QKBCI_ITITA_defs.html |