GetEventOrderFlip

XML Tag

Definition

comcorp

Five digit system number assigned to each corp.

house

6 digit house number

cust

2 digit customer number

XML Tag

Column Name

Data Type

Nullable

Definition

eord_corp

CORP

INT UNSIGNED

N

Five digit accounting corp number assigned to each corp

eord_partition

PARTITION

CHAR(2)

N

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

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

eordstatus

Beginning eordstatus delimiter

code

Code value for event show status. Valid Values; 1=autho clear, 2=autho set, 3=cancelled,4=rescheduled

eord_eventstat

EVENTSTAT

CHAR(8)

N

Status of this event. Valid Values: pending,charged,viewed, cancel

/eordstatus

Ending eordstatus delimiter

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:

eordeventtype

Beginning eordeventtype delimiter

code

Code for event type; Valid values: 1 = Single, 2 = Master, 3 = Component

eord_etype

ETYPE

CHAR(9)

N

Type of ppv event. Valid Values: single, master, component

/eordeventtype

Ending eordeventtype delimiter

eord_evtdes

EVTDES

CHAR(17)

N

Long description for the event. Valid Values:

eord_autho

AUTHO

CHAR(2)

N

Code for this event; identifies the bit in the PPVautho mask for this event. Valid Values:

eord_chnl

CHNL

CHAR(4)

N

Number of the channel that will receive the signalfor this event. Valid Values:

eord_rating

RATING

CHAR(7)

N

Events rating flag . Valid Values: ( ), (NR), (G), (PG),(PG13), ®,(NC17),(X).E42

eord_chdate

CHDATE

DATETIME

Y

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

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_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

eout_eodate

EODAT

DATETIME

Y

Date credit applied to account. Valid Values:

eout_eorsn

EORSN

CHAR(1)

N

Code from user defined table describing reason foroutage. Valid Values: 1-6

eout_eouamt

EOUAMT

NUMERIC SIGNED

N

The amount credited due to outage. Valid Values:

eout_eadjrsn

EADJRSN

CHAR(2)

N

Adjustment reason code used for this outage. Valid Values: "00"-"ZZ"

evt_digital

DIGITAL

CHAR(7)

N

Indicator value for digital rate code*or* Indicates whether or not equipment is digitalfor =SUPPORTED_EQUIPMENT.. Valid Values: analog ,digital

/event

Ending event delimiter

/eordgroup

Ending eordgroup delimiter

6/6/01

Added grouping tags and additional "code" tags for event status and event type fields.