| Variable |
Name |
Type |
Description |
| SERNAME.APT |
Apartment |
Text |
|
| SERNAME.WCITY |
Business City |
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.BCADRSZ |
Business Suite |
Text |
|
| SERNAME.WZIP |
Business Zip Code |
Text |
|
| SERNAME.CPHONE |
Car/Mobile Phone |
Text |
Not currently used. |
| SERNAME.CITY |
City |
Text |
|
| SERNAME.CODE3 |
City |
Text |
|
| SERNAME.SID |
Constituent ID |
Text |
|
| SERNAME.CTY |
County |
Text |
|
| SERNAME.CODE2 |
District |
Text |
|
| SERNAME.FPHONE |
Fax |
Text |
|
| SERNAME.HPHONE |
Home Phone |
Text |
|
| SERNAME.LNAME |
Last Name |
Text |
|
| SERNAME.MAIL |
Mail to H or W or A |
Text |
|
| SERNAME.CUS |
Map Grid # |
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.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.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.CODE1 |
N/S |
Text |
|
| SERNAME.SCNT |
Number of Cases |
Text |
Number of requests associated with the constituent record. |
| 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.PPHONE |
Pager |
Text |
|
| SERNAME.PCT |
Precinct |
Text |
|
| SERNAME.SEX |
Sex |
Text |
Sex (M/F) of the primary contact for this constituent record. Not currently used. |
| SERNAME.STDIR |
Street Direction |
Text |
|
| SERNAME.STNAME |
Street Name |
Text |
|
| SERNAME.STNUM |
Street Number |
Text |
|
| SERNAME.STSUF |
Street Suffix (Ave) |
Text |
|
| SERNAME.TID |
Tax ID |
Text |
|
| SERNAME.TWN |
Township |
Text |
|
| SERNAME.IBCO |
Type I–B–O–G |
Text |
|
| SERNAME.WRD |
Ward |
Text |
|
| SERNAME.WPHONE |
Work Phone |
Text |
|
| SERNAME.ZIP |
Zip Code |
Text |
|
| SERNAME.BCNAME |
c–Business Name |
Text |
|
| SERNAME.TITLE |
c–Contact 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.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.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. |