GetEventDescriptions

XML Tag

Definition

comcorp

Five digit system number assigned to each corp.

opr

Three character operator id

digital_flag

1=select digital events 0= do not select digital events

analog_flag

1=select analog events 0= do not select analog events

query_option

1 chacter field , 1=Query title by title name, 2=Query title by last show date/time , 3= Query showing by date and time

evt.title

41 character field, Entered only for query_option 1

beginning_date

DATE, 8 character field, Entered only for option 2 and 3 , YYYY-MM-DD eg. 2001-05-18

beginning_time

TIME, 8 character field, Entered only for option 2 and 3 , hh:mm:ss eg. 09:25:00

count

Number of records to return, max = 100 if left blank. If a value is entered it will return the amount in the database up to that number entered

XML Tag

Column Name

Data Type

Nullable

Definition

et_corp

CORP

INT UNSIGNED

N

Five digit accounting corp number assigned to each corp

titledescriptiongroup

Beginning titledescriptiongroup delimiter

titledescription

Beginning titledescription delimiter

et_titleid

TITLEID

INT UNSIGNED

N

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

et_stmtdesc

STMTDESC

VARCHAR(17)

N

Free form statement description. Valid Values:

et_digital

DIGITAL

CHAR(4)

N

Valid Values:"anlg" = analog event(0) or "dgtl" = digital event (1)

et_channel

CHANNEL

CHAR(5)

N

Channel Number. Valid Values: 1-9999 (A/B)

et_ratg

RATG

CHAR(6)

N

The event rating. Valid Values: ( ) = 1, (G) = 2, (PG) = 3, (PG13) =4, (NC17) = 5, (R) = 6, (X) = 7

ecl_chamt

CHAMT

NUMERIC SIGNED

N

The dollar amount to charge for this rate code, or if event info, for the charge level.. Valid Values:

et_lastshowtimechamt

CHAMT

NUMERIC SIGNED

N

The dollar amount to charge for this rate code, or if event info, for the charge level.. Valid Values:

et_firstshowdateweekday

FIRSTSHOWDATEWEEKDAY

CHAR(3)

N

Day of the week for et_firstshowdate field (MON, TUE, WED, THU, FRI, SAT, SUN)

et_firstshowdate

FIRSTSHOWDATE

DATETIME

N

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

et_firstshowtime

FIRSTSHOWTIME

DATETIME

N

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

et_lastshowdateweekday

LASTSHOWDATEWEEKDAY

CHAR(3)

N

Day of the week for et_lastshowdate field (MON, TUE, WED, THU, FRI, SAT, SUN)

et_lastshowdate

LASTSHOWDATE

DATETIME

N

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

et_lastshowtime

LASTSHOWTIME

DATETIME

N

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

/titledescription

Ending titledescription delimiter

/titledescriptiongroup

Ending titledescriptiongroup delimiter

showingdescriptiongroup

Beginning showingdescriptiongroup delimiter

showingdescription

Beginning showingdescription delimiter

et_titleid

TITLEID

INT UNSIGNED

N

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

es_showid

SHOWID

INT UNSIGNED

N

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

es_evstweekday

EVSWEEKDAY

CHAR(3)

N

Day of the week for es_evsdte field (MON, TUE, WED, THU, FRI, SAT, SUN)

es_evstdte

EVSTDTE

DATETIME

N

Start date for this event Stop order date for Master events OR date/time of record creation for VOD events. Valid Values:

es_evsttim

EVSTTIM

DATETIME

N

Start time for the event OR date/time of record creation for VOD events. Valid Values: Null for Master events

et_evtduration

EVTDURATION

SMALLINT UNSIGNED

N

Event Duration. Valid Values: 1-99999

et_stmtdesc

STMTDESC

VARCHAR(17)

N

Free form statement description. Valid Values:

et_digital

DIGITAL

CHAR(4)

N

Valid Values:"anlg" = analog event(0) or "dgtl" = digital event (1)

et_channel

CHANNEL

CHAR(5)

N

Channel Number. Valid Values: 1-9999 (A/B)

et_ratg

RATG

CHAR(6)

N

The event rating. Valid Values: ( ) = 1, (G) = 2, (PG) = 3, (PG13) =4, (NC17) = 5, (R) = 6, (X) = 7

ecl_chamt

CHAMT

NUMERIC SIGNED

N

The dollar amount to charge for this rate code, or if event info, for the charge level.. Valid Values:

/showingdescription

Ending showingdescription delimiter

/showingdescriptiongroup

Ending showingdescriptiongroup delimiter

5/31/01

Added clarification information to the definitions for Input tags: beginning_date, beginning_time, count

6/22/01

Changed order of et_ratg field to match server output in the titledescriptiongroup

7/16/01

Changed order of et_ratg field to match server output in the showingdescriptiongroup

7/25/01

Corrected spelling of es_evstweekday