OT2 Query Reports Variables

Cross Connect

Variable Field Type Description
SERNAME.APT c–Apartment Text The apartment number from the home address part of the constituent record to which this cross connect record is related.
SERNAME.BCADRSZ c–Business Suite Text The Suite number from the work address part of the constituent record to which this cross connect record is related.
SERNAME.BCNAME c–Business Name Text The name from the work address part of the constituent record to which this cross connect record is related.
SERNAME.CDIR c–Universal Direction Text Contains the street direction from the sername record to which this cross connect record 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 cross connect record is related.
SERNAME.CNAME c–Universal Name Text Contains the street name from the constituent record to which this cross connect record 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 cross connect record. 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 cross connect 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 cross connect 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 cross connect record.
SERNAME.CPHONE c–Car/Mobile Phone Text The car/mobile phone number from the constituent record to which this cross connect record is related.
SERNAME.CTY c–County Text The county code associated with the constituent record to which this cross connect 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 cross connect record is related. Should be the same value as "CUS".
SERNAME.FPHONE c–Fax Text The fax number from the constituent record to which this cross connect record is related.
SERNAME.HPHONE c–Home Phone Text The home phone number from the constituent record to which this cross connect 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 cross connect record 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 cross connect 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 cross connect 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 cross connect 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 Numeric The street number from the constituent record associated with this cross connect record. 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 cross connect record is associated with.
SERNAME.PPHONE c–Pager Text The pager number from the constituent record to which this cross connect record is related.
SERNAME.SCNT c–Number of Cases Text The total number of issues associated with the constituent record to which this cross connect record is related.
SERNAME.SEX c–Sex Text Designed to hold the gender of the contact individual from the constituent record associated with this cross connect 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 cross connect 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 cross connect 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 cross connect record is related.
SERNAME.STNUM c–Street Number Text The street number from the home address part of the constituent record to which this cross connect 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 cross connect 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 cross connect record 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 cross connect record is related.
SERNAME.TITLE c–Contact Name Text The formal name by which the constituent is to be addressed to which this cross connect 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 cross connect record is related is located.
SERNAME.WCITY c–Business City Text The city from the work address part of the constituent record to which this cross connect record is related.
SERNAME.WPHONE c–Work Phone Text The work phone number from the constituent record associated with this cross connect 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 cross connect 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 cross connect 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 cross connect 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 cross connect 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 cross connect 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 cross connect record is related.
SERNAME.ZIP c–Zip Code Text The zip code from the 'home' address from the constituent record associated with this cross connect record.
V_X_DATA.CUS Cus Text 'Pin Number' from the cross connect detail screen. Should be the same as c–Pin Number.
V_X_DATA.HAZARD Hazard Text 'Hazard' field from the cross connect detail screen. A one character field. Contains values H, L, M, and T.
V_X_DATA.INSTALLED Date Installed Date 'Installed' field from the cross connect detail screen. The date on which this cross connect device was originally installed at this location.
V_X_DATA.LAST_INSP Date of Last inspection Date 'Inspection' field from the cross connect detail screen. The date of the most recently completed inspection on this cross connect.
V_X_DATA.LOCATION Location Text 'Location' field from the cross connect detail screen. A short description of the exact location of the cross connect device.
V_X_DATA.METER_DESC Meter desc Text 'Description' field from the cross connect details screen. Description of the cross connect device.
V_X_DATA.METER_SER Meter ser Text "Meter Service" field from the cross connect detail screen. Does not appear to be in use.
V_X_DATA.METER_SIZE Meter size Text "Meter Size" field from the cross connect detail screen. Meter size in inches.
V_X_DATA.METER_TYPE Meter type Text "Meter Type" field from cross connect detail screen. Code to identify the make/model of the cross connect device.
V_X_DATA.NEXT_INSP Date of Next inspection Date "Next Inspection" field from cross connect detail screen. The date of the next scheduled inspection for this cross connect device.
V_X_DATA.NOTICE_1 Date of Notice 1 Date "Notice 1" field from the cross connect detail screen. Date.
V_X_DATA.NOTICE_2 Date of Notice 2 Date "Notice 2" field from the cross connect detail screen. Date.
V_X_DATA.PERMIT_ISU Date Permit isued Date "Permit" field from the cross connect detail screen. Date on which the cross connect permit was issued.
V_X_DATA.PERMIT_NO Permit number Text "Permit Number" field from the cross connect detail screen. Cross connect permit number.
V_X_DATA.PRE_INSP Pre inspection Date "Pre Inspection" field from the cross connect detail screen. Date of pre inspection.
V_X_DATA.X_ADDED Date X connect added Date "Added" field from cross connect detail screen. Date this cross connect record was added to the system.
V_X_DATA.X_EDITED Date X connect edited Date "Edited" field from the cross connect detail screen. Date this cross connect record was last edited.
V_X_DATA.X_ERROR X connect error Text Not currently implemented.
V_X_DATA.X_NOTES X connect notes Text "Notes" field on the cross connect detail screen.
V_X_DATA.X_NUMBER X connect number Text "Number" field from the cross connect detail screen. Number uniquely identifying this cross connect device.
V_X_DATA.X_OK 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_DATA.X_SIZE X connect size Text "Size" field from the cross connect detail screen.
V_X_DATA.X_TYPE X connect type Text "Type" field from the cross connect detail screen.

© Copyright GOVT.com 2002