GetHistoryInfo

XML Tag

Definition

comcorp

Five digit system number assigned to each corp.

house

Six digit house number

cust

Two digit customer number

ascending

sort order

count

Determines how many rows are delivered.

type

Type of history record

timestamp

The service returns only the rows whose "timstmp" fields are more recent than the input TIMESTAMP

XML Tag

Column Name

Data Type

Nullable

Definition

hm_corp

CORP

INT UNSIGNED

N

Two digit system number assigned to each corp.Thecorp # is unique only within one Tandem system.

Hm_partition

PARTITION

CHAR(2)

N

Data hashing value for database management – equals the last 2 digits of the house #.

Hm_house

HOUSE

CHAR(6)

N

House number. Valid Values: Alpha/Numeric

hm_cust

CUST

CHAR(2)

N

Customer number.

Historygroup

Beginning historygroup delimiter

hm_timstmp

TIMSTMP

DATETIME

N

Time that a transaction was performed. Valid Values: Year to fraction

hm_type

Beginning hn_type delimiter

code

TYPE

CHAR(2)

N

Type of history record. Valid Values: 1=inst 2=restrt 3=chng svc 4=disc 5=dwo 7=tc 8=sro9=event a=box chg c=o/e opt 13 e=EFTs p=cust pinI=inbound contact J=outbound contact

description

CHAR(20)

Type description

/hn_type

Ending hm_type delimiter

hm_histdate

HISTDATE

DATETIME

N

Date associated with this transaction.

Hm_opr

OPR

CHAR(3)

N

ID of the operator responsible for latest transaction. Valid Values: "---" = ARU, "***" = Upload "###" = VOD API

hm_tech

TECH

SMALLINT UNSIGNED

N

Tech or installer number. Valid Values: 1 thru 999

hm_histstat

Beginning hm_histstat delimiter

code

HISTSTAT

CHAR(2)

N

History statusThis field is blank if HISTMASTER, TYPE=A, box chg. Valid Values: 1=complete,2=not done,3=notruck,4=new movein,5=reschedule,6=cancel,7=pending,8=box change,9=wip change

description

CHAR(20)

History status description

hn_histstat

Ending hm_histstat delimiter

hm_orgschdat

ORGSCHDAT

DATETIME

Y

The value of the schedule date before the reschedule.

Historygroup

Ending historygroup delimiter

XML Tag

Column Name

Data Type

Nullable

Definition

customerhistory

Beginning customerhistory delimiter

hc_slsrep

SLSREP

CHAR(3)

N

Sales rep who sold this account.

hc_lastnam

LASTNAM

CHAR(13)

N

Customer's last name.

hc_bildate

BILDATE

DATETIME

Y

Start/Stop billing date for this transaction. Valid Values: Year to Day only

hc_prorate

PRORATE

NUMERIC SIGNED

N

Prorated charges from start/stop bill date to the end of the cust's cycle/charge thru date.

hc_cmpgncd

Beginning hc_cmpgncd delimiter

code

CMPGNCD

CHAR(1)

N

Code describing the campaign used to acquire this customer's service or event ordering.

shortdescription

CHAR(8)

campaign code short description

longdescription

CHAR(30)

campaign code long description

hc_cmpgncd

Ending hc_cmpgncd delimiter

hc_chngrsn

Beginning hc_chngrsn delimiter

code

CHNGRSN

CHAR(1)

N

Change reason code.

shortdescription

CHAR(8)

change reason short description

longdescription

CHAR(30)

change reason long description

/hc_chngrsn

Ending hc_chngrsn delimiter

hc_slsrsn

Beginning hc_slsrsn delimiter

code

SLSRSN

CHAR(1)

N

Sales reason code OR PPV sales reason if inEVTORDERS or HISTEVENT tables.. Valid Values: 0-9, A-Z from 36 code table 113 (if NOT an event)or table #136 if event related.

shortdescription

CHAR(8)

sales reason short description

longdescription

CHAR(30)

sales reason long description

/hc_slsrsn

Ending hc_slsrsn delimiter

hc_resch

Beginning hc_resch delimiter

code

RESCH

CHAR(1)

N

Reschedule reason code.

shortdescription

CHAR(8)

reschedule reason short description

longdescription

CHAR(30)

reschedule reason long description

/hc_resch

Ending hc_resch delimiter

hc_cxlrsn

Beginning hc_cxlrsn delimiter

code

CXLRSN

CHAR(1)

N

Cancel reason code.

shortdescription

CHAR(8)

cancel reason short description

longdescription

CHAR(30)

cancel reason long description

/hc_cxlrsn

Ending hc_cxlrsn delimiter

hc_notdnrsn

Beginning hc_hotdnrsn delimiter

code

NOTDNRSN

CHAR(1)

N

Not done reason.

shortdescription

CHAR(8)

not done reason short description

longdescription

CHAR(30)

not done reason long description

hc_notdnrsn

Ending hc_notdnrsn delimiter

custratehistory

Beginning custratehistory delimiter

hcr_ratecd

Beginning hcr_ratecd delimiter

code

RATECD

CHAR(2)

N

Rate code associated with this charge level.

shortdescription

CHAR(8)

N

Rate code short description.

longdescription

CHAR(30)

N

Rate code long description.

/hcr_ratecd

Ending hcr_ratecd delimiter

hcr_ratesign

RATESIGN

CHAR(1)

N

Sign for rate code, adding or subtracting.

hcr_ratecnt

RATECNT

CHAR(2)

N

Rate code count.

custratehistory

Ending custratehistory delimiter

XML Tag

Column Name

Data Type

Nullable

Definition

fldsvchistory

Beginning fldsvchistory delimiter

hfs_fix01

Begiining hfs_fix01 delimiter

code

FIX01

CHAR(2)

N

Fix code

shortdescription

CHAR(8)

Fix code short description

longdescription

CHAR(30)

Fix code long description

/hfs_fix01

Ending hfs_fix01 delimiter

hfs_fix02

Beginning hfs_fix02 delimiter

code

FIX02

CHAR(2)

N

Fix code

shortdescription

CHAR(8)

Fix code short description

longdescription

CHAR(30)

Fix code long description

/hfs_fix02

Ending hfs_fix02 delimiter

hfs_fix03

Beginning hfs_fix03 delimiter

code

FIX03

CHAR(2)

N

Fix code

shortdescription

CHAR(8)

Fix code short description

longdescription

CHAR(30)

Fix code long description

/hfs_fix03

Ending hfs_fix03 delimiter

hfs_fix04

Beginning hfs_fix04 delimiter

code

FIX04

CHAR(2)

N

Fix code

shortdescription

CHAR(8)

Fix code short description

longdescription

CHAR(30)

Fix code long description

/hfs_fix04

Ending hfs_fix04 delimiter

hfs_fix05

Beginning hfs_fix05 delimiter

code

FIX05

CHAR(2)

N

Fix code

shortdescription

CHAR(8)

Fix code short description

longdescription

CHAR(30)

Fix code long description

/hfs_fix05

Ending hfs_fix05 delimiter

hfs_elaptim

ELAPTIM

INTERVAL

N

Elapsed time on t/c from receive to complete.

hfs_cxlrsn

Beginning hfs_cxlrsn delimiter

code

CXLRSN

CHAR(1)

N

Cancel reason code.

shortdescription

CHAR(8)

Cancel reason code short description.

longdescription

CHAR(30)

Cancel reason code long description.

/hfs_cxlrsn

Ending hfs_cxlrsn delimiter

hfs_resch

Beginning hfs_resch delimiter

code

RESCH

CHAR(1)

N

Reschedule reason code.

shortdescription

CHAR(8)

Reschedule reason code short description.

longdescription

CHAR(30)

Reschedule reason code long description.

/hfs_resch

Ending hfs_resch delimiter

hfs_notdnrsn

Beginning hfs_notdnrsn delimiter

code

NOTDNRSN

CHAR(1)

N

Not done reason.

shortdescription

CHAR(8)

Not done reason short description.

longdescription

CHAR(30)

Not done reason long description.

/hfs_notdnrsn

Ending hfs_notdnrsn delimiter

hfs_task01

Beginning hfs_task01 delimiter

code

TASK01

CHAR(1)

N

Task/problem code depending on job type.

shortdescription

CHAR(8)

Task/problem code short description.

longdescription

CHAR(30)

Task/problem code long description.

/hfs_task01

Ending hfs_task01 delimiter

hsf_taks02

Beginning hsf_taks02 delimiter

code

TASK02

CHAR(1)

N

Task/problem code depending on job type.

shortdescription

CHAR(8)

Task/problem code short description.

longdescription

CHAR(30)

Task/problem code long description.

/hsf_taks02

Ending hsf_taks02 delimiter

hfs_task03

Beginning hfs_task03 delimiter

code

TASK03

CHAR(1)

N

Task/problem code depending on job type.

shortdescription

CHAR(8)

Task/problem code short description.

longdescription

CHAR(30)

Task/problem code long description.

/hfs_task03

Ending hfs_task03 delimiter

/fldsvchistory

Ending fldsvchistory delimiter

XML Tag

Column Name

Data Type

Nullable

Definition

ppveventhistory

Beginning ppveventhistory delimiter

he_titleid

TITLEID

INT UNSIGNED

N

Actual PPV identifier for a title. Valid Values: 1-99999

he_outletlist

OUTLETLIST

CHAR(6)

N

Number of outlets currently active on this account.

he_cmpgncd

Beginning he_cmpgncd delimiter

code

CMPGNCD

CHAR(1)

N

Code describing the campaign used to acquire this customer's service or event ordering.

shortdescription

CHAR(8)

Campaign code short description

longdescription

CHAR(30)

Campaign code long description

/he_cmpgncd

Ending he_cmpgncd delimiter

he_slsrsn

Beginning he_slsrsn delimiter

code

SLSRSN

CHAR(1)

N

Sales reason code OR PPV sales reason if inEVTORDERS or HISTEVENT tables.. Valid Values: 0-9, A-Z from 36 code table 113 (if NOT an event)or table #136 if event related.

shortdescription

CHAR(8)

Sales reason short description

longdescription

CHAR(30)

Sales reason long description

/he_slsrsn

Ending he_slsrsn delimiter

he_slsrep

SLSREP

CHAR(3)

N

Sales rep who sold this account.

he_cxlrsn

Beginning he_cxlrsn delimiter

code

CXLRSN

CHAR(1)

N

Cancel reason code.

shortdescription

CHAR(8)

Cancel reason short description

longdescription

CHAR(30)

Cancel reason long description

/he_cxlrsn

Ending he_cxlrsn delimiter

he_ordrdate

ORDRDATE

DATETIME

Y

Date associated with the event order transaction.

he_ordrtime

ORDRTIME

DATETIME

Y

Time associated with the event order transaction.

he_event_outlets

EVENT_OUTLETS

VARCHAR(170)

N

Will contain a comma delimited list of outlet #'s(1,2,3,60) that represent which outlets are tiedto this event number.. Valid Values: 1-60 in a comma delimited list (i.e. 1,2,3)

he_showid

SHOWID

INT UNSIGNED

N

Actual PPV identifier for the showing of a title.. Valid Values: 1-99999

hec_creditrsn

Beginning hec_creditrsn delimiter

code

CREDITRSN

CHAR(1)

N

The adjustment reason for the credit given.

shortdescription

CHAR(8)

Credit reason short description.

longdescription

CHAR(30)

Credit reason long description.

/hec_creditrsn

Ending hec_creditrsn delimiter

hec_creditamt

CREDITAMT

NUMERIC SIGNED

N

Amount of credit given.

ppveventhistory

Ending ppveventhistory delimiter

XML Tag

Column Name

Data Type

Nullable

Definition

boxeshistory

Beginning boxeshistory delimiter

hb_retrnrsn

Beginning hb_retrnrsn delimiter

code

RETRNRSN

CHAR(1)

N

The reason converter was returned.

shortdescription

CHAR(8)

Return reason short description

longdescription

CHAR(30)

Return reason long description

/hb_retrnrsn

Ending hb_retrnrsn delimiter

hb_boxold

BOXOLD

CHAR(14)

N

Serial # of converter removed in this transaction

hb_boxnew

BOXNEW

CHAR(14)

N

Serial # of a new converter added in this trnasaction.

hb_locold

Beginning hb_locold delimiter

code

LOCOLD

CHAR(1)

N

Location code of converter being removed in this transaction.

shortdescription

CHAR(8)

Location code short description

longdescription

CHAR(30)

Location code long description

/hb_locold

Ending hb_locold delimiter

hb_locnew

Beginning hb_locnew delimiter

code

LOCNEW

CHAR(1)

N

Location code of the converter being added in thistransaction.

shortdescription

CHAR(8)

Location code short description

longdescription

CHAR(30)

Location code long description

/hb_locnew

Ending hb_locnew delimiter

hb_outlet

OUTLET

SMALLINT SIGNED

N

Outlet number. Valid Values: 1-60

/boxeshistory

Ending boxeshistory delimiter

XML Tag

Column Name

Data Type

Nullable

Definition

eftshistory

Beginning eftshistoyr delimiter

hefts_efttype

Beginning hefts_efttype delimiter

code

EFTTYPE

CHAR(1)

N

EFTS type. Valid Values: 1=pre-authorized checking, 2=bank card, 3=paymentcard

description

CHAR(20)

EFTS type description.

/hefts_efttype

Ending hefts_efttype delimiter

hefts_bank

BANK

CHAR(8)

N

Transit and ABA number of the bank for EFTS transactions.

hefts_bankacct

BANKACCT

CHAR(19)

N

Customer's bank account number at time of transaction.

/eftshistory

Ending eftshistoyr delimiter

XML Tag

Column Name

Data Type

Nullable

Definition

histcontactgroup

Beginning histcontactgroup delimiter

hcntct_timstmp

TIMSTMP

DATETIME

N

Time that a transaction was performed. Valid Values: Year to fraction

hcntct_opr

OPR

CHAR(3)

N

ID of the operator responsible for latest transaction. Valid Values: "---" = ARU, "***" = Upload "###" = VOD API

hcntct_contacttype

Beginning hcntct_contacttype delimiter

code

CONTACTTYPE

CHAR(4)

N

CUSTOMER CONTACT TYPE. Valid Values: "IBND", "OBND"

description

CHAR(8)

Customer contact type description.

/hcntct_contacttype

Ending hcntct_contacttype delimiter

hcntct_incntcttype1

Beginning hcntct_incntcttype1 delimiter

code

INCNTCTTYPE1

CHAR(2)

N

INBOUND CUSTOMER CONTACT CODE #1. Valid Values: " 1" - "95", " "

shortdescription

CHAR(8)

longdescription

CHAR(20)

/hcntct_incntcttype1

Ending hcntct_incntcttype1 delimiter

hcntct_incntcttype2

Beginning hcntct_incntcttype2 delimiter

code

INCNTCTTYPE2

CHAR(2)

N

INBOUND CUSTOMER CONTACT CODE #2. Valid Values: " 1" - "95", " "

shortdescription

CHAR(8)

longdescription

CHAR(20)

/hcntct_incntcttype2

Ending hcntct_incntcttype2 delimiter

hcntct_incntcttype3

Beginning hcntct_incntcttype3 delimiter

code

INCNTCTTYPE3

CHAR(2)

N

INBOUND CUSTOMER CONTACT CODE #3. Valid Values: " 1" - "95", " "

shortdescription

CHAR(8)

longdescription

CHAR(20)

/hcntct_incntcttype3

Ending hcntct_incntcttype3 delimiter

hcntct_incntctnote

INCNTCTNOTE

VARCHAR(350)

N

INBOUND CUSTOMER CONTACT NOTE - UP TO 10 LINES, 35CHARS EACH. Valid Values: 1 - 10 LINES, 35 CHARACTERS EACH

hcntct_outcntcttype1

Beginning hcntct_outcntcttype1 delimiter

code

OUTCNTCTTYPE1

CHAR(2)

N

OUTBOUND CUSTOMER CONTACT CODE #1. Valid Values: " 1" - "95", " "

shortdescription

CHAR(8)

longdescription

CHAR(20)

/hcntct_outcntcttype1

Ending hcntct_outcntcttype1 delimiter

hcntct_outcntcttype2

Beginning hcntct_outcntcttype2 delimiter

code

OUTCNTCTTYPE2

CHAR(2)

N

OUTBOUND CUSTOMER CONTACT CODE #2. Valid Values: " 1" - "95", " "

shortdescription

CHAR(8)

longdescription

CHAR(20)

/hcntct_outcntcttype2

Ending hcntct_outcntcttype2 delimiter

hcntct_outcntcttype3

Beginning hcntct_outcntcttype3 delimiter

code

OUTCNTCTTYPE3

CHAR(2)

N

OUTBOUND CUSTOMER CONTACT CODE #3. Valid Values: " 1" - "95", " "

shortdescription

CHAR(8)

longdescription

CHAR(20)

/hcntct_outcntcttype3

Ending hcntct_outcntcttype3 delimiter

hcntct_outcntctnote

OUTCNTCTNOTE

VARCHAR(350)

N

OUTBOUND CUSTOMER CONTACT NOTE - UP TO 10 LINES,35 CHARS EACH. Valid Values: 1- 10 LINES, 35 CHARACTERS EACH

/histcontactgroup

Ending histcontactgroup delimiter

XML Tag

Column Name

Data Type

Nullable

Definition

custpinhistory

Beginning custpinhistory delimiter

hcp_opr

OPR

CHAR(3)

N

ID of the operator responsible for latest transaction. Valid Values: "---" = ARU, "***" = Upload "###" = VOD API

hcp_custpin

CUSTPIN

CHAR(4)

N

Customer level personal identification number. Valid Values: numeric

hcp_prevcustpin

PREVCUSTPIN

CHAR(4)

N

Previous customer PIN.

hcp_caller

CALLER

CHAR(8)

N

Name of person calling.

hcp_lastpinchgdte

LASTPINCHGDTE

DATETIME

N

Last PIN change date.

custpinhistory

Ending custpinhistory delimiter

XML Tag

Column Name

Data Type

Nullable

Definition

hte_flagchgs

FLAGCHGS

CHAR(72)

N

A string denoting tax flag changes. Size is derived from 36 taxes * 2 characters. Valid values are a string of code36 codes (from table #165 taxes) preceeded by a + when a flag is turned on and by a - when a flag is turned off, or -ALL, + All.