| Variable |
Name |
Type |
Description |
| SERNAME.APT |
Apartment |
Text |
|
| SERNAME.BCADRSZ |
Business Suite |
Text |
|
| SERNAME.BCNAME |
c–Business Name |
Text |
|
| SERNAME.CDIR |
c–Universal Direction |
Text |
For "Individual" type constituent records, holds the street directional from the "Home" address. For "Business", "Government" and "Organization" type records, holds the street directional from the "Work" address. |
| SERNAME.CITY |
City |
Text |
|
| SERNAME.CNAME |
c–Universal Name |
Text |
For "Individual" type constituent records, holds the street name from the "Home" address. For "Business", "Government" and "Organization" type records, holds the street name from the "Work" address. |
| SERNAME.CNUM |
c–Universal House Number |
Text |
For "Individual" type constituent records, holds the building number from the "Home" address. For "Business", "Government" and "Organization" type records, holds the building number from the "Work" address. |
| SERNAME.CODE1 |
N/S |
Text |
|
| SERNAME.CODE2 |
District |
Text |
|
| SERNAME.CODE3 |
City |
Text |
|
| SERNAME.CPHONE |
Car/Mobile Phone |
Text |
Not currently used. |
| SERNAME.CTY |
County |
Text |
|
| SERNAME.CUS |
Map Grid # |
Text |
|
| SERNAME.FPHONE |
Fax |
Text |
|
| SERNAME.HPHONE |
Home Phone |
Text |
|
| SERNAME.IBCO |
Type I–B–O–G |
Text |
|
| SERNAME.LNAME |
Last Name |
Text |
|
| SERNAME.MAIL |
Mail to H or W or A |
Text |
|
| SERNAME.MRK |
Marked by Query Select |
Text |
Used internally by OT2. If not an empty value, this record has been marked with a query. Usually contains a capitol "I". |
| SERNAME.NNUM |
n–Universal House Number |
Numeric |
Numeric value of the c–Universal House Number (see SERNAME.CNUM, c–Universal House Number). Useful for sorting addresses numberically, as "12" will be seen as larger than "2". |
| SERNAME.PCT |
Precinct |
Text |
|
| SERNAME.PPHONE |
Pager |
Text |
|
| SERNAME.SCNT |
Number of Cases |
Text |
Number of requests associated with the constituent record. |
| SERNAME.SEX |
Sex |
Text |
Sex (M/F) of the primary contact for this constituent record. Not currently used. |
| SERNAME.SID |
Constituent ID |
Text |
|
| SERNAME.STDIR |
Street Direction |
Text |
|
| SERNAME.STNAME |
Street Name |
Text |
|
| SERNAME.STNUM |
Street Number |
Text |
|
| SERNAME.STSUF |
Street Suffix (Ave) |
Text |
|
| SERNAME.TC1 |
Odd/Even Address |
Text |
Contains one of three values: "O","E", or blank. "O" indicates that the Universal House Number for the constituent record (see SERNAME.NNUM, n–Universal House Number) ends in an odd number (not counting fractions such as 1/2) and "E" indicates that it ends with an even number. Useful for sorting constituent records by which side of the street their primary location is when querying by an address range. |
| SERNAME.TC10 |
MiscCode 10 |
Text |
Not currently used. |
| SERNAME.TC11 |
MiscCode 11 |
Text |
Not currently used. |
| SERNAME.TC12 |
MiscCode 12 |
Text |
Not currently used. |
| SERNAME.TC13 |
MiscCode 13 |
Text |
Not currently used. |
| SERNAME.TC14 |
MiscCode 14 |
Text |
Not currently used. |
| SERNAME.TC15 |
MiscCode 15 |
Text |
Not currently used. |
| SERNAME.TC2 |
MiscCode 02 |
Text |
Not currently used. |
| SERNAME.TC3 |
MiscCode 03 |
Text |
Not currently used. |
| SERNAME.TC4 |
MiscCode 04 |
Text |
Not currently used. |
| SERNAME.TC5 |
MiscCode 05 |
Text |
Not currently used. |
| SERNAME.TC6 |
MiscCode 06 |
Text |
Not currently used. |
| SERNAME.TC7 |
MiscCode 07 |
Text |
Not currently used. |
| SERNAME.TC8 |
MiscCode 08 |
Text |
Not currently used. |
| SERNAME.TC9 |
MiscCode 09 |
Text |
Not currently used. |
| SERNAME.TID |
Tax ID |
Text |
|
| SERNAME.TITLE |
c–Contact Name |
Text |
|
| SERNAME.TWN |
Township |
Text |
|
| SERNAME.WCITY |
Business City |
Text |
|
| SERNAME.WPHONE |
Work Phone |
Text |
|
| SERNAME.WRD |
Ward |
Text |
|
| SERNAME.WTDIR |
Business Street Direction |
Text |
|
| SERNAME.WTNAME |
Business Street Name |
Text |
|
| SERNAME.WTNUM |
Business Street Number |
Text |
|
| SERNAME.WTSUF |
Business Street Suffix |
Text |
|
| SERNAME.WZIP |
Business Zip Code |
Text |
|
| SERNAME.ZIP |
Zip Code |
Text |
|