GetHouseInfo

XML Tag

Definition

comcorp

Five digit system number assigned to each corp.

house

Six digit house number

XML Tag

Column Name

Data Type

Nullable

Definition

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_outlt01

OUTLT01

CHAR(1)

N

House: Previous outlet #1 locationEvtorders: No longer used..

h_outlt02

OUTLT02

CHAR(1)

N

House: Previous outlet #2 locationEvtorders: No longer used..

h_outlt03

OUTLT03

CHAR(1)

N

House: Previous outlet #3 locationEvtorders: No longer used..

h_outlt04

OUTLT04

CHAR(1)

N

House: Previous outlet #4 locationEvtorders: No longer used..

h_outlt05

OUTLT05

CHAR(1)

N

House: Previous outlet #5 locationEvtorders: No longer used..

h_outlt06

OUTLT06

CHAR(1)

N

House: Previous outlet #6 locationEvtorders: No longer used..

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_newdrop

NEWDROP

CHAR(1)

N

Flag identifying address as a new drop. Valid Values: 1=NEW DROP

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_map

MAP

CHAR(4)

N

The map number for this house.

H_comment

COMMENT

CHAR(1)

N

Flag indicating that a house comment exists.

H_drop

Beginning h_drop delimiter

code

DROP

CHAR(1)

N

A code indicating where the drop located.

Shortdescription

CHAR(8)

Drop short description

longdescription

CHAR(30)

Drop long description

/h_drop

Ending h_drop delimiter

h_info

Beginning h_info delimiter

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 delimiter

h_mgt

MGT

SMALLINT UNSIGNED

N

Management area for this record.

H_slsroute

SLSROUTE

CHAR(5)

N

Sales route for this house.

H_c80

C80

CHAR(1)

N

Flag indicating this record has been sent to DDP Financials.

H_ftax

FTAX

SMALLINT UNSIGNED

N

Franchise area for this house. Valid Values: 1-99

h_ovug

OVUG

CHAR(1)

N

Indicates how the drop enters the house CHECK OUTSSEE IF NEWW PROGRAMS SQUEEZ LINE 1 AND 2 TOGETHERALSO BETTER CHECK THAT LINE 3 AND 4 ARE FIXED ENDSTART LINE 4. Valid Values: o =overhead,u=undergroun d ENDSTART LINE 2 END2START3 END3START4 END4

h_mkt

Beginning h_mkt delimiter

code

MKT

CHAR(1)

N

Code to indicate market type.

Shortdescription

CHAR(8)

Market type short description

longdescription

CHAR(30)

Market type long description

/h_mkt

Ending h_mkt delimiter

h_complex

COMPLEX

CHAR(5)

N

Number for the apartment complex this address is part of. Valid Values: Any number starting with an ‘A’ will link to the complex scheme…(XB rate code)

h_zipcode

ZIPCODE

CHAR(6)

N

ZIP code for this address. Valid Values: 6^th 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_wpcnt

WPCNT

CHAR(1)

N

Is a counter to link wip records.A wpcnt of ‘5’ would link all records with wpcnt 5 to one transactn. Valid Values: The next transaction would have wpcnt ‘6’ and so forth. Links the house, wip, wip com ment

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.

H_contlarea

CONTLAREA

CHAR(3)

N

Control area for this house.

H_dual

DUAL

CHAR(6)

N

In the master account, the account number of the dual created from the master.

H_clust

Beginning h_clust delimiter

code

CLUST

CHAR(2)

N

Code assigned by outside vendor to establish the socioeconomic group of the customer.

Shortdescription

CHAR(8)

Cluster short description

longdescription

CHAR(30)

Cluster long description

/h_clust

Ending h_clust delimiter

h_geocd

Beginning h_geocd delimiter

code

GEOCD

CHAR(1)

N

The geographic area used to get the cluster code. Valid Values: 1 = block, 2 = tract, 3 = zip

description

CHAR(20)

Geographic area description

/h_geocd

Ending h_geocd delimiter

h_enhdualtype

ENHDUALTYPE

CHAR(1)

N

Enhanced dual account type. Valid Values: blank=not a dual account, ‘P’=primary account, ‘S’=secondary account

h_altsvcadr

ALTSVCADR

SMALLINT SIGNED

N

Flag to determine whether the house has analternate service address.. Valid Values: 1 = alternate service address exists for house0 = no alternate service address for house

h_prevloc_outlets

PREVLOC_OUTLETS

VARCHAR(230)

N

Will contain a comma delimited string of outlet#’s and their corresponding location code(i.e. D2,B13). Valid Values: 1-60 for outlet #’s; 0-Z for location codes

h_fibernode

FIBERNODE

CHAR(20)

N

Used by HSDS to store the node information from the head end.. Valid Values: alpha/numeric

h_network_id

NETWORK_ID

CHAR(20)

N

Used by HSDS to store nodes information out in the plant.. Valid Values: alpha/numeric

zip_zipend

ZIPEND

CHAR(6)

N

Ending range of this group of zip codes.

Zip_zipbeg

ZIPBEG

CHAR(6)

N

Zip code beginning range.

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

zip_cycle

CYCLE

CHAR(1)

N

In custmaster = customer’s billing cycle, in cycletable = valid cycles for corp. Valid Values: A,B,C,D

asa_altsvcadr1

ALTSVCADR1

VARCHAR(30)

N

First line of alternate service address..

asa_altsvcadr2

ALTSVCADR2

VARCHAR(30)

N

Second line of alternate service address..