XML Tag

Definition

comcorp

Five digit system number assigned to each corp.

house

6 digit house number

cust

2 digit customer number

titleid

5 character title id number; Valid values 1 - 99999

showid

5 character show id number; Valid values 1 - 99999 or "0" (zero) for Master Event search

XML Tag

Column Name

Data Type

Nullable

Definition

eord_corp

CORP

INT UNSIGNED

N

Five digit accounting corp number assigned to each corp

eord_house

HOUSE

CHAR(6)

N

Up to six digit house number

eord_cust

CUST

CHAR(2)

N

Two digit customer number

eordgroup

Beginning eordgroup delimiter

event

Beginning event delimiter

eord_titleid

TITLEID

INT UNSIGNED

N

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

eord_showid

SHOWID

INT UNSIGNED

N

Actual PPV identifier for the showing of a title.. Valid Values: 1-99999; will be "0" (zero) for Master Events

eord_ordate

ORDATE

DATETIME

N

Date this event was ordered by the customer. Valid Values:

eord_ortime

ORTIME

DATETIME

N

Time of order OR time event was ordered by customer if ANIPOLL. Valid Values:

eord_etype

ETYPE

CHAR(9)

N

Type of ppv event. Valid values: 1 = Single, 2 = Master, 3 = Component

eord_eventstat

EVENTSTAT

CHAR(8)

N

Status of this event. Valid Values; 1=autho clear, 2=autho set, 3=cancelled, 4=rescheduled

eord_who

WHO

CHAR(3)

N

Last person that updated the record (Operator Id)

eord_prog

PROG

CHAR(1)

N

Program that performed the last update to the record

eord_evtdes

EVTDES

CHAR(17)

N

Long description for the event. Valid Values:

eord_ledate

LEDATE

DATETIME

Y

Date of the last event in the customer package; master events only. Valid Values:

eord_cnrsn

CNRSN

CHAR(1)

N

Cancel reason code why the subscriber cancelled their PPV. Valid Values: ppvparams, cancel reasons

eord_cmpgn

CMPGN

CHAR(1)

N

PPV campaign used to sell this customer the ppv event. Valid Values:

eord_slsrsn

SLSRSN

CHAR(1)

N

PPV sales reason; Valid Values: 0-9, A-Z from 36 code table (136).

eord_chdate

CHDATE

DATETIME

Y

The last date this event was charged, viewed or cancelled. Valid Values:

eord_chglvl

CHGLVL

SMALLINT UNSIGNED

N

Charging level for this subscriber's event. Valid Values: 1-5

eord_price

PRICE

NUMERIC UNSIGNED

N

Unit price for this event. Valid Values:

eord_evdate

EVDATE

DATETIME

N

View date for this event Order date for Master events. Valid Values:

eord_evtime

EVTIME

DATETIME

N

Time the event is scheduled to start Order time for Master events. Valid Values:

eord_evwmin

EVWMIN

SMALLINT UNSIGNED

N

Number of viewing minutes for this event. Valid Values:

eord_pays

PAYS

SMALLINT UNSIGNED

N

Number of pay services for customer at time of this order. Valid Values:

eord_master

MASTER

INT UNSIGNED

N

For component records only, master event number to identify this package. Valid Values:

eord_mstrcp

MSTRCP

CHAR(1)

N

Flag indicating all components created. Valid Values: blank=all components not created yet 1=all components created

eord_caller

CALLER

CHAR(8)

N

Name of person calling. Valid Values:

eord_period

PERIOD

CHAR(1)

N

Code indicating the billing period this record wasprocessed OR for MSO data tape info. Valid Values: A thru X or if MSO data C=current M=month to da te Q=quarter to date

eord_cntrl

CNTRL

CHAR(5)

N

Controller event number used for authorization of this event on controller-event based systems. Valid Values:

eord_event_outlets

EVENT_OUTLETS

CHAR(250)

N

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

eord_mode

MODE

INT UNSIGNED

N

Frequency of statement sent to the customer. Valid Values: 0=none, 1=monthly, 2=bi-monthly, 3=quarterly, 6=semi-annually, A=annually

eord_viewtype

VIEWTYPE

SMALLINT UNSIGNED

N

View type of title. Valid Values: 0=standard, 1=NVOD, 2=game, 3=VOD

/event

Ending event delimiter

/eordgroup

Ending eordgroup delimiter

6/14/01

Modified tags to match OP Service/XML API Server output