| Data element |
Definition |
| Activedateend Indexed - no
Format - Date
May be Null? Y | |
| Activedatestart Indexed - no
Format - Date
May be Null? Y | |
| Addresstypeid Indexed - no
Format - Number
May be Null? N | Address type |
| City Indexed - no
Format - Varchar2(240)
May be Null? Y | |
| Countryid Indexed - no
Format - Number
May be Null? Y | |
| Datemodified Indexed - no
Format - Date
May be Null? Y | |
| Email Indexed - no
Format - Varchar2(400)
May be Null? Y | |
| Entryaddressid Indexed - yes
Format - Number
May be Null? N | Unique Identifier |
| Entryid Indexed - no
Format - Number
May be Null? N | Entry Unique Identifier |
| Phone Indexed - no
Format - Varchar2(100)
May be Null? Y | |
| Phonemobilecell Indexed - no
Format - Varchar2(100)
May be Null? Y | |
| Phoneother Indexed - no
Format - Varchar2(100)
May be Null? Y | |
| Phoneother2 Indexed - no
Format - Varchar2(100)
May be Null? Y | |
| Stateprovince Indexed - no
Format - Varchar2(240)
May be Null? Y | |
| Street Indexed - no
Format - Varchar2(320)
May be Null? Y | |
| Street2 Indexed - no
Format - Varchar2(320)
May be Null? Y | |
| Zippostcode Indexed - no
Format - Varchar2(60)
May be Null? Y | |
