OT2 Query Reports Variables

Cross Connect Inspections

Field	Variable	Type	Description
Cross Connect Number	V_X_INSP.X_NUMBER	Text	The unique number identifying this cross connect.
Date Inspection Added	V_X_INSP.I_ADDED	Date	The date on which the inspection was scheduled.
Date Inspection Edited	V_X_INSP.I_EDITED	Date	The last time this inspection was saved.
Inspection Date	V_X_INSP.INSP_DATE	Date	The date on which the inspection is to take place or has taken place.
Inspection Result	V_X_INSP.PASSED	Text	This field contains three possible values – Passed, Failed, or nothing. A nothing value indicates that the inspection has not yet taken place.
Inspector	V_X_INSP.INSPECTOR	Text	The name of the person who will perform or who has performed this inspection.
Notes	V_X_INSP.NOTES	Text	A text field containing any notes associated with this inspection.
c–Apartment	SERNAME.APT	Text	The apartment number from the home address part of the constituent record to which this inspection record is related.
c–Area	SERNAME.CODE2	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.
c–Business City	SERNAME.WCITY	Text	The city from the work address part of the constituent record to which this inspection record is related.
c–Business Name	SERNAME.BCNAME	Text	The name from the work address part of the constituent record to which this inspection is related.
c–Business Street Directio	SERNAME.WTDIR	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.
c–Business Street Name	SERNAME.WTNAME	Text	The name of the street from the work address part of the constituent record to which this inspection record is related.
c–Business Street Number	SERNAME.WTNUM	Text	The street number from the work address part of the constituent record to which this inspection record is related.
c–Business Street Suffix	SERNAME.WTSUF	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.
c–Business Suite	SERNAME.BCADRSZ	Text	The Suite number from the work address part of the constituent record to which this inspection is related.
c–Business Zip Code	SERNAME.WZIP	Text	The Zip code from the work address part of the constituent record to which this inspection record is related.
c–Car/Mobile Phone	SERNAME.CPHONE	Text	The car/mobile phone number from the constituent record to which this inspection record is related.
c–City	SERNAME.CITY	Text	The city name from the home address section of the constituent record to which this inspection is related.
c–Constituent ID	SERNAME.SID	Text	The unique constituent ID of the constituent record to which this inspection record is related.
c–Contact Name	SERNAME.TITLE	Text	The formal name by which the constituent is to be addressed to which this inspection record is related.
c–County	SERNAME.CTY	Text	The county code associated with the constituent record to which this inspection record is related.
c–Fax	SERNAME.FPHONE	Text	The fax number from the constituent record to which this inspection record is related.
c–Garbage Zone	SERNAME.CODE3	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.
c–H2O Billing Number	SERNAME.TID	Text	TID (default is water billing number) from the constituent record to which this inspection record is related.
c–Home Phone	SERNAME.HPHONE	Text	The home phone number from the constituent record to which this inspection record is related.
c–Last Name	SERNAME.LNAME	Text	The last name of the individual from the constituent record to which this inspection record is related.
c–Mail to H or W or A	SERNAME.MAIL	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).
c–Marked by Query Select	SERNAME.MRK	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.
c–MiscCode 02	SERNAME.TC2	Text	Currently unused.
c–MiscCode 03	SERNAME.TC3	Text	Currently unused.
c–MiscCode 04	SERNAME.TC4	Text	Currently unused.
c–MiscCode 05	SERNAME.TC5	Text	Currently unused.
c–MiscCode 06	SERNAME.TC6	Text	Currently unused.
c–MiscCode 07	SERNAME.TC7	Text	Currently unused.
c–MiscCode 08	SERNAME.TC8	Text	Currently unused.
c–MiscCode 09	SERNAME.TC9	Text	Currently unused.
c–MiscCode 10	SERNAME.TC10	Text	Currently unused.
c–MiscCode 11	SERNAME.TC11	Text	Currently unused.
c–MiscCode 12	SERNAME.TC12	Text	Currently unused.
c–MiscCode 13	SERNAME.TC13	Text	Currently unused.
c–MiscCode 14	SERNAME.TC14	Text	Currently unused.
c–MiscCode 15	SERNAME.TC15	Text	Currently unused.
c–Number of Cases	SERNAME.SCNT	Text	The total number of issues associated with the constituent record to which this inspection record is related.
c–Odd/Even Address	SERNAME.TC1	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.
c–Pager	SERNAME.PPHONE	Text	The pager number from the constituent record to which this inspection record is related.
c–Pin Number	SERNAME.CUS	Text	This user defined field is located right above the ID field on the constituent record to which this inspection record is related.
c–Precinct	SERNAME.PCT	Text	The precinct code of the constituent record this inspection record is associated with.
c–Sex	SERNAME.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.
c–Street Direction	SERNAME.STDIR	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.
c–Street Name	SERNAME.STNAME	Text	The name of the street from the home address part of the constituent record to which this inspection record is related.
c–Street Number	SERNAME.STNUM	Text	The street number from the home address part of the constituent record to which this inspection record is related.
c–Street Suffix (Ave)	SERNAME.STSUF	Text	The street suffix (AVE, ST, DR, etc.) from the home address part of the constituent record to which this inspection record is related.
c–Township	SERNAME.TWN	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.
c–Type I–B–O–G	SERNAME.IBCO	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
c–Universal Direction	SERNAME.CDIR	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.
c–Universal House Number	SERNAME.CNUM	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".
c–Universal Name	SERNAME.CNAME	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.
c–Ward	SERNAME.WRD	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.
c–Work Phone	SERNAME.WPHONE	Text	The work phone number from the constituent record associated with this inspection record.
c–Zip Code	SERNAME.ZIP	Text	The zip code from the 'home' address from the constituent record associated with this inspection record.
c–Zone	SERNAME.CODE1	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.
n–Universal House Number	SERNAME.NNUM	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.
x–CC Currently Okay	V_X_DATA.X_OK	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.