GetEventTitle

Input XML Tags

XML Tag

Definition

comcorp

Five digit system number assigned to each corp.

opr

Three character operator id

titleid

5 character title id number

option

Valid values; 1= Order PPV, 2 = Cancel PPV, 3 = Credit PPV

 

Output XML Tags

XML Tag

Column Name

Data Type

Nullable

Definition

evt_corp

CORP

INT UNSIGNED

N

Five digit accounting corp number assigned to each corp

titledescriptiongroup

     

Beginning titledescriptiongroup delimiter

titledescription

     

Beginning titledescription delimiter

evt_titleid

TITLEID

INT UNSIGNED

N

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

evt_title

TITLE

CHAR(40)

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

evt_basevt

BASEVT

INT UNSIGNED

N

Base event number associated with this event. Valid Values:

evt_etype

ETYPE

SMALLINT UNSIGNED

N

Type of ppv event. Valid Values: 1=single,2=master

evt_evtduration

EVTDURATION

SMALLINT UNSIGNED

N

Event Duration. Valid Values: 1-99999

evt_viewfreemin

VIEWFREEMIN

SMALLINT UNSIGNED

N

Number of minutes to view free. Valid Values: 0=Master; 1-99

evt_royrt

ROYRT

CHAR(6)

N

Royalty dollar amount or percentage. Valid Values: Either dollar amount (factor A) or percentage (factor P)

evt_royfc

ROYFC

CHAR(1)

N

Royalty factor. Valid Values: A = amount, P = percentage

evt_dist

DIST

SMALLINT UNSIGNED

N

Number for the distributor of this event. Valid Values:

evt_ratg

RATG

CHAR(1)

N

The event rating. Valid Values: 0=NR 1=G 2=PG 3=PG13 4=NC17 5=R 6=X

evt_subj

SUBJ

CHAR(1)

N

Code that describes type of event/or system subject code to replace PAL value. Valid Values: 0-9, A-Z

evt_studio

STUDIO

CHAR(1)

N

Default table value if not provided by vendor.. Valid Values: 0-9,A-Z

evt_blkbstr

BLKBSTR

CHAR(1)

N

Code to indicate this event is a block buster. Valid Values: Legal values are 1-9, A-U

evt_stmtdesc

STMTDESC

VARCHAR(17)

N

Free form statement description. Valid Values:

evt_shortdesc

SHORTDESC

CHAR(8)

N

Short description. Valid Values:

evt_viewtype

VIEWTYPE

SMALLINT UNSIGNED

N

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

evt_repeatcycle

REPEATCYCLE

SMALLINT UNSIGNED

N

Repeat Cycle. Valid Values: 0-999

evt_numberfreq

NUMBERFREQ

SMALLINT UNSIGNED

N

Number of Frequencies. Valid Values: 0-99

evt_channel

CHANNEL

CHAR(4)

N

Channel Number. Valid Values: 1-9999

evt_abcable

ABCABLE

CHAR(1)

N

Channel Designation. Valid Values: A/B

evt_ctrlevtasgnmnt

CTRLEVTASGNMNT

SMALLINT UNSIGNED

N

Controller Event Assignment Classification. Valid Values: 0=schedular, 1=title, 2=showing

evt_showings

SHOWINGS

SMALLINT UNSIGNED

N

Number of showings linked to a title. Valid Values: 0-65,535

evt_definecomplete

DEFINECOMPLETE

SMALLINT UNSIGNED

N

Define Complete. Valid Values: 1=defined on controller

evt_scheduletype

SCHEDULETYPE

SMALLINT UNSIGNED

N

Schedule Type. Valid Values: 0=by date, 1=by day of week

evt_firstshowdate

FIRSTSHOWDATE

DATETIME

N

Date of first showingOR date/time of record creation for VOD events. Valid Values: valid date

evt_firstshowtime

FIRSTSHOWTIME

DATETIME

N

Time of first showingOR date/time of record creation for VOD events. Valid Values: valid time

evt_lastshowdate

LASTSHOWDATE

DATETIME

N

Date of last showingOR date/time of record creation for VOD events. Valid Values: valid date

evt_lastshowtime

LASTSHOWTIME

DATETIME

N

Time of last showingOR date/time of record creation for VOD events. Valid Values: valid time

evt_mstostdate

MSTOSTDATE

DATETIME

Y

Master order start dateOR date/time of record creation for VOD events. Valid Values: valid date

evt_mstosttime

MSTOSTTIME

DATETIME

Y

Master Order Start TimeOR date/time of record creation for VOD events. Valid Values: valid time

evt_mstospdate

MSTOSPDATE

DATETIME

Y

Master order stop dateOR date/time of record creation for VOD events. Valid Values: valid date

evt_mstosptime

MSTOSPTIME

DATETIME

Y

Master Order Stop TimeOR date/time of record creation for VOD events. Valid Values: valid time

evt_titlestatus

TITLESTATUS

CHAR(1)

N

Master Order Stop TimeOR date/time of record creation for VOD events. Valid Values: valid time

evt_es_queue_num

ES_QUEUE_NUM

SMALLINT SIGNED

Y

The queue number assigned to an event when processed by the event scheduler program.. Valid Values:

evt_digital

DIGITAL

SMALLINT SIGNED

N

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

evt_ippv_purch

IPPV_PURCH

SMALLINT SIGNED

N

Indicator value for ippv purchasable. Valid Values: 0=not ippv purchasable, 1=ippv purchasable

evt_macrovision

MACROVISION

SMALLINT SIGNED

N

Indicator value for macrovision. Valid Values: 0=not macrovision, 1=macrovision

evt_con_ads

CON_ADS

SMALLINT SIGNED

N

Indicator value for content advisory. Valid Values: 0,1

evt_dig_info

DIG_INFO

CHAR(2)

Y

Digital information. Valid Values: bit 0 through 11

evt_sex_ads

SEX_ADS

INT UNSIGNED

Y

Sexual content advisory. Valid Values: 0-3

evt_lang_ads

LANG_ADS

INT UNSIGNED

Y

Language content advisory. Valid Values: 0-3

evt_vio_ads

VIO_ADS

INT UNSIGNED

Y

Violence content advisory. Valid Values: 0-3

evt_time_free

TIME_FREE

INT UNSIGNED

Y

Duration of anytime free preview for a program. Valid Values: 0-12 bits

/titledescription

     

Ending titledescription delimiter

/titledescriptiongroup

     

Ending titledescriptiongroup delimiter