OT2 Query Reports Variables

Cross Connect Inspections

Variable Field Type Description
SERNAME.APT c–Apartment Text The apartment number from the home address part of the constituent record to which this inspection record is related.
SERNAME.BCADRSZ c–Business Suite Text The Suite number from the work address part of the constituent record to which this inspection is related.
SERNAME.BCNAME c–Business Name Text The name from the work address part of the constituent record to which this inspection is related.
SERNAME.CDIR c–Universal Direction Text Contains the street direction from the sername record to which this inspection is related, from the home address if the record is marked as an individual, business address otherwise.
SERNAME.CITY c–City Text The city name from the home address section of the constituent record to which this inspection is related.
SERNAME.CNAME c–Universal Name Text Contains the street name from the constituent record to which this inspection is related. Contains the street name from the home address if this record is labeled as an individual, business address otherwise.
SERNAME.CNUM c–Universal House Number Text The street number from the constituent record associated with this inspection. Contains the street number from the home address if the record is marked as an individual, from the work address otherwise. This field is in character format, so should not be used to sort addresses, as "12" will be sorted as less than "2".
SERNAME.CODE1 c–Zone Text The first of the four 'political' fields on the constituent screen. This field was designed to hold the zone code for the zone of the constituent record associated with this inspection record.
SERNAME.CODE2 c–Area Text The second of the four 'political' fields on the constituent screen. This field was designed to hold the political area code (not the telephone area code) of the constituent record associated with this inspection record.
SERNAME.CODE3 c–Garbage Zone Text The third of the four 'political' fields on the constituent screen. This field was designed to hold the garbage collection zone of the constituent record associated with this inspection record.
SERNAME.CPHONE c–Car/Mobile Phone Text The car/mobile phone number from the constituent record to which this inspection record is related.
SERNAME.CTY c–County Text The county code associated with the constituent record to which this inspection record is related.
SERNAME.CUS c–Pin Number Text This user defined field is located right above the ID field on the constituent record to which this inspection record is related.
SERNAME.FPHONE c–Fax Text The fax number from the constituent record to which this inspection record is related.
SERNAME.HPHONE c–Home Phone Text The home phone number from the constituent record to which this inspection record is related.
SERNAME.IBCO c–Type I–B–O–G Text Contains a single character determining the type of constituent record to which this inspection is related:
I–Individual
B–Business
G–Government
O–Organization
SERNAME.LNAME c–Last Name Text The last name of the individual from the constituent record to which this inspection record is related.
SERNAME.MAIL c–Mail to H or W or A Text Contains three possible values indicating to which address from the constituent record to which this inspection record is related correspondence should be mailed to, H–Home (Individual Address) W–Work (Business Address) A–Alternate (Alternate Address).
SERNAME.MRK c–Marked by Query Select Text If the constituent record to which this inspection record is related has been marked by a query through the Query menu, this field will not be blank. Usually a capitol "I" is used to mark records.
SERNAME.NNUM n–Universal House Number Numerical The street number from the constituent record associated with this inspection. Contains the street number from the home address if the record is marked as an individual, from the work address otherwise. This field is in numeric format as opposed to the c–Universal House Number which is in character format. This field should be used for sorting street addresses.
SERNAME.PCT c–Precinct Text The precinct code of the constituent record this inspection record is associated with.
SERNAME.PPHONE c–Pager Text The pager number from the constituent record to which this inspection record is related.
SERNAME.SCNT c–Number of Cases Text The total number of issues associated with the constituent record to which this inspection record is related.
SERNAME.SEX c–Sex Text Designed to hold the gender of the contact individual from the constituent record associated with this inspection record. However, I see nowhere to enter that information, and for the most part the field appears to be empty.
SERNAME.SID c–Constituent ID Text The unique constituent ID of the constituent record to which this inspection record is related.
SERNAME.STDIR c–Street Direction Text The street direction (ex: N, S, NW, etc.) from the home address part of the constituent record to which this inspection record is related.
SERNAME.STNAME c–Street Name Text The name of the street from the home address part of the constituent record to which this inspection record is related.
SERNAME.STNUM c–Street Number Text The street number from the home address part of the constituent record to which this inspection record is related.
SERNAME.STSUF c–Street Suffix (Ave) Text The street suffix (AVE, ST, DR, etc.) from the home address part of the constituent record to which this inspection record is related.
SERNAME.TC1 c–Odd/Even Address Text Contains three possible values: 'E' if the address ends in an even number, 'O' if the address ends in an odd number, and nothing if no address information has been entered. Keyed to the home street address if the constituent record to which this inspection is related is marked as 'Individual', the work street address otherwise. If the address ends in 1/2 then 1/2 is ignored, so 321 1/2 Baker ST will be odd but 320 1/2 Baker ST will be even.
SERNAME.TC10 c–MiscCode 10 Text Currently unused.
SERNAME.TC11 c–MiscCode 11 Text Currently unused.
SERNAME.TC12 c–MiscCode 12 Text Currently unused.
SERNAME.TC13 c–MiscCode 13 Text Currently unused.
SERNAME.TC14 c–MiscCode 14 Text Currently unused.
SERNAME.TC15 c–MiscCode 15 Text Currently unused.
SERNAME.TC2 c–MiscCode 02 Text Currently unused.
SERNAME.TC3 c–MiscCode 03 Text Currently unused.
SERNAME.TC4 c–MiscCode 04 Text Currently unused.
SERNAME.TC5 c–MiscCode 05 Text Currently unused.
SERNAME.TC6 c–MiscCode 06 Text Currently unused.
SERNAME.TC7 c–MiscCode 07 Text Currently unused.
SERNAME.TC8 c–MiscCode 08 Text Currently unused.
SERNAME.TC9 c–MiscCode 09 Text Currently unused.
SERNAME.TID c–H2O Billing Number Text TID (default is water billing number) from the constituent record to which this inspection record is related.
SERNAME.TITLE c–Contact Name Text The formal name by which the constituent is to be addressed to which this inspection record is related.
SERNAME.TWN c–Township Text The second in the list of user defined 'Political' fields, this was designed to hold the town code for the town in which this constituent to which this inspection is related is located.
SERNAME.WCITY c–Business City Text The city from the work address part of the constituent record to which this inspection record is related.
SERNAME.WPHONE c–Work Phone Text The work phone number from the constituent record associated with this inspection record.
SERNAME.WRD c–Ward Text The third of the four political information fields on the constituent screen, this field was designed to hold the ward code of the ward where the constituent associated with this inspection record is located.
SERNAME.WTDIR c–Business Street Directio Text The street direction (ex: N, S, NW, etc.) from the work address part of the constituent record to which this inspection record is related.
SERNAME.WTNAME c–Business Street Name Text The name of the street from the work address part of the constituent record to which this inspection record is related.
SERNAME.WTNUM c–Business Street Number Text The street number from the work address part of the constituent record to which this inspection record is related.
SERNAME.WTSUF c–Business Street Suffix Text The street suffix (ex: ST, WAY, DR, etc.) from the work address part of the constituent record to which this inspection record is related.
SERNAME.WZIP c–Business Zip Code Text The Zip code from the work address part of the constituent record to which this inspection record is related.
SERNAME.ZIP c–Zip Code Text The zip code from the 'home' address from the constituent record associated with this inspection record.
V_X_DATA.X_OK x–CC Currently Okay Logical The current status of the cross connect associated with this inspection. True means the last inspection found the cross connect in good working order, False means that the cross connect is currently awaiting repair or replacement.
V_X_INSP.INSPECTOR Inspector Text The name of the person who will perform or who has performed this inspection.
V_X_INSP.INSP_DATE Inspection Date Date The date on which the inspection is to take place or has taken place.
V_X_INSP.I_ADDED Date Inspection Added Date The date on which the inspection was scheduled.
V_X_INSP.I_EDITED Date Inspection Edited Date The last time this inspection was saved.
V_X_INSP.NOTES Notes Text A text field containing any notes associated with this inspection.
V_X_INSP.PASSED Inspection Result Text This field contains three possible values – Passed, Failed, or nothing. A nothing value indicates that the inspection has not yet taken place.
V_X_INSP.X_NUMBER Cross Connect Number Text The unique number identifying this cross connect.

© Copyright GOVT.com 2002