|
XML Tag |
Definition |
|
comcorp |
Five digit system number assigned to each corp. |
|
lastname |
Customer's Last Name - up to 13 characters |
|
firstname |
Customer's First Name - up to 8 characters. |
|
set |
Set determines which number of Count records will be returned. If there are a total of 30 records and Count is 10, then Set 1 will return the first 10 records, 2 the next 10, 3 the last 10. |
|
count |
Determines how many rows are delivered. |
|
XML Tag |
Column Name |
Data Type |
Nullable |
Definition |
|
browserow |
Beginning browserow delimiter |
|||
|
h_corp |
CORP |
INT UNSIGNED |
N |
Two digit system number assigned to each corp.Thecorp # is unique only within one Tandem system. |
|
h_partition |
PARTITION |
CHAR(2) |
N |
Data hashing value for database management - equals the last 2 digits of the house #. |
|
h_house |
HOUSE |
CHAR(6) |
N |
House number. Valid Values: Alpha/Numeric |
|
h_cust |
CUST |
CHAR(2) |
N |
Customer number. |
|
h_hfstatus |
Beginning h_hfstatus delimiter |
|||
|
code |
HFSTATUS |
CHAR(1) |
N |
Current status of this house. Valid Values: 1=never,2=active,3=disconnect |
|
shortdescription |
CHAR(8) |
House status short description |
||
|
longdescription |
CHAR(30) |
House status long description |
||
|
/h_hfstatus |
Ending h_hfstatus delimiter |
|||
|
h_carea |
Beginning h_carea delimiter |
|||
|
code |
CAREA |
CHAR(1) |
N |
Code to use for construction area. |
|
shortdescription |
CHAR(8) |
Construction area short description |
||
|
longdescription |
CHAR(30) |
Construction area long description |
||
|
/h_carea |
Ending h_carea delimiter |
|||
|
h_dwell |
Beginning h_dwell delimiter |
|||
|
code |
DWELL |
CHAR(1) |
N |
Code indicating type of dwelling for the house using 36 code table #106. Or 0=all 1=houses 2=apts. Valid Values: 0-9, A-Z |
|
shortdescription |
CHAR(8) |
Dwelling short description |
||
|
longdescription |
CHAR(30) |
Dwelling long description |
||
|
/h_dwell |
Ending h_dwell delimiter |
|||
|
h_name |
NAME |
CHAR(15) |
N |
Street name If =DELIVERYSYS, external delivery system name*** Removed from =DELIVERYSYS on 4.1. Valid Values: Alphanumeric character string |
|
h_dir |
DIR |
CHAR(2) |
N |
Indicates a direction associated with the street. |
|
h_stnum |
STNUM |
CHAR(5) |
N |
Number part of street address. |
|
h_fract |
FRACT |
CHAR(3) |
N |
Fraction number in street address. |
|
h_apt |
APT |
CHAR(3) |
N |
Apartment designator, used for "Apt", "Lot", "Spc". |
|
h_aptn |
APTN |
CHAR(4) |
N |
Actual apartment or space number. |
|
h_tag |
TAG |
CHAR(7) |
N |
Tag number for this drop. |
|
h_comment |
COMMENT |
CHAR(1) |
N |
Flag indicating that a house comment exists. |
|
h_info |
Beginning h_info delimter |
|||
|
code |
INFO |
CHAR(1) |
N |
Code for house information. |
|
shortdescription |
CHAR(8) |
House information short description |
||
|
longdescription |
CHAR(30) |
House information long description |
||
|
/h_info |
Ending h_info delimter |
|||
|
h_mgt |
MGT |
SMALLINT UNSIGNED |
N |
Management area for this record. |
|
h_ftax |
FTAX |
SMALLINT UNSIGNED |
N |
Franchise area for this house. Valid Values: 1-99 |
|
h_zipcode |
ZIPCODE |
CHAR(6) |
N |
ZIP code for this address. Valid Values: 6th character could be special city code linking to a city description..2 cities one zip..alpha cc |
|
h_zip4 |
ZIP4 |
CHAR(4) |
N |
Additional breakdown of zip code. |
|
h_hwstat |
Beginning h_hwstat delimiter |
|||
|
code |
HWSTAT |
CHAR(1) |
N |
WIP count for existing pending wip jobs(install,restart,chng,disc) Links directly to the wip job. Valid Values: 0-9,a-z |
|
shortdescription |
CHAR(8) |
WIP status short description |
||
|
longdescription |
CHAR(30) |
WIP status long description |
||
|
/h_hwstat |
Ending h_hwstat delimiter |
|||
|
h_tcstat |
Beginning h_tcstat delimiter |
|||
|
code |
TCSTAT |
CHAR(1) |
N |
WIP count for a pending trouble call. Valid Values: 0-9,a-z |
|
shortdescription |
CHAR(8) |
Trouble call status short description |
||
|
longdescription |
CHAR(30) |
Trouble call status long description |
||
|
/h_tcstat |
Ending h_tcstat delimiter |
|||
|
h_srostat |
Beginning h_srostat delimiter |
|||
|
code |
SROSTAT |
CHAR(1) |
N |
WIP count for a pending SRO. Valid Values: 0-9,a-z |
|
shortdescription |
CHAR(8) |
SRO status short description |
||
|
longdescription |
CHAR(30) |
SRO status long description |
||
|
/h_srostat |
Ending h_srostat delimiter |
|||
|
h_census |
CENSUS |
CHAR(6) |
N |
Government census area. |
|
zip_city |
CITY |
CHAR(18) |
N |
City Name tied to this zip. |
|
zip_state |
STATE |
CHAR(2) |
N |
Two character state abbreviation. Valid Values: Alphanumeric |
|
o_ampout |
AMPOUT |
SMALLINT UNSIGNED |
N |
Codes identifying outage status. Valid Values: blank=none, 1=stage 1, 2=stage 2 |
|
c_cust |
CUST |
CHAR(2) |
N |
Customer number. |
|
c_lname |
LNAME |
CHAR(13) |
N |
Customer's last name. |
|
c_fname |
FNAME |
CHAR(8) |
N |
Customer's first name. |
|
c_init |
INIT |
CHAR(2) |
N |
Initials. |
|
c_title |
TITLE |
CHAR(2) |
N |
Title associated with customer's name OR name given a map table OR group title for Rate Increase ORaward title. Valid Values: Alpha-numeric |
|
c_rphon |
RPHON |
CHAR(8) |
N |
Customer's residence phone number. |
|
c_bphone |
BPHONE |
CHAR(10) |
N |
Customer's business phone number. Valid Values: If CREDITCHKTRANS, AAAPPPSSSS where aaa=area codeppp=prefix, ssss=suffix. |
|
c_cvtr |
CVTR |
CHAR(1) |
N |
Converter flag. Valid Values: Blank=no boxes, 1=at least one addressable box 2=non-addressable box |
|
c_ssn |
SSN |
CHAR(9) |
N |
Customer's Social Security number. |
|
c_drsn |
Beginning c_drsn delimiter |
|||
|
code |
DRSN |
CHAR(1) |
N |
Disconnect reason. |
|
shortdescription |
CHAR(8) |
Disconnect reason short description |
||
|
longdescription |
CHAR(30) |
Disconnect reason long description |
||
|
/c_drsn |
Ending c_drsn delimiter |
|||
|
c_wrt |
WRT |
NUMERIC SIGNED |
N |
Amount of money that has been written-off for thisaccount and not recovered yet. Valid Values: Is the amt of the writeoff adj(debit balance amt will have credit amt in the field) OR 1=write to HS |
|
c_cur |
CUR |
NUMERIC SIGNED |
N |
Money in the current money bucket. |
|
c_c30 |
C30 |
NUMERIC SIGNED |
N |
Portion of the balance that is aged 30 days. |
|
c_c60 |
C60 |
NUMERIC SIGNED |
N |
Portion of the balance that is aged 60 days. |
|
c_c90 |
C90 |
NUMERIC SIGNED |
N |
Portion of the balance that is aged 90 days. |
|
c_c120 |
C120 |
NUMERIC SIGNED |
N |
Portion of the balance that is aged 120 days. |
|
c_colst |
Beginning c_colst delimiter |
|||
|
code |
COLST |
CHAR(1) |
N |
Collection status. Valid Values: Blank=not in collections. '1'=in collections "2"=pending npd/in collections "3"=not in collections but has a custcollect record for products |
|
description |
CHAR(40) |
Collections status description |
||
|
/c_colst |
Ending c_colst delimiter |
|||
|
c_stat |
Beginning c_stat delimiter |
|||
|
code |
STAT |
CHAR(1) |
N |
Status for cust - 1=P/IN 2=P/RS 3=P/CH 4=P/DS 5=ACTIVE 6=DISC 7=X/IN. Valid Values: REFUND STATUS 1,2,3,D,H,P,S,T,W EVENT DESCRIPTION TABLE 1-4 |
|
shortdescription |
CHAR(8) |
Status short description. |
||
|
longdescription |
CHAR(30) |
Status long description. |
||
|
/c_stat |
Ending c_colst delimiter |
|||
|
c_nbrpays |
NBRPAYS |
SMALLINT UNSIGNED |
N |
Number of pay services for this customer. Valid Values: 1-9 |
|
c_tallybucket |
TALLYBUCKET |
SMALLINT SIGNED |
N |
Tells which bucket in the Customer Tally table is current.. Valid Values: 0 - 24 |
|
c_rareacd |
RAREACD |
SMALLINT SIGNED |
N |
Residence/home phone area code. |
|
ct_house |
HOUSE |
CHAR(6) |
N |
House number. Valid Values: Alpha/Numeric |
|
ct_cust |
CUST |
CHAR(2) |
N |
Customer number. |
|
browserow |
Ending browserow delimiter |