Copyright © 2024, Oracle and/or its affiliates.
Field Index SQL Mapping

Class /ppv_schedule

Pay per view Schedule class.

Notes

  • This object can be read by the owner or any billing group leader within the brand who is an ancestor of the owner.
  • This object can be modified by the owner or any billing group leader within the brand who is an ancestor of the owner.
  • This object can be created by anyone.

Links



Field Index

Type Field Name
poid PIN_FLD_POID
timestamp PIN_FLD_CREATED_T
timestamp PIN_FLD_MOD_T
string PIN_FLD_READ_ACCESS
string PIN_FLD_WRITE_ACCESS
string PIN_FLD_CREATE_ACCESS
poid PIN_FLD_ACCOUNT_OBJ
string PIN_FLD_PERMITTED
string PIN_FLD_DESCR
string PIN_FLD_CONTENT_PROVIDER_NAME
string PIN_FLD_CONTENT_ITEM_ID
string PIN_FLD_REMIT_TYPE
string PIN_FLD_STUDIO
int PIN_FLD_SUBJECT_ID
string PIN_FLD_RATING
string PIN_FLD_DISTRIBUTOR
int PIN_FLD_COPY_VALUE_ID
enum PIN_FLD_STATUS
string PIN_FLD_CHANNEL
int PIN_FLD_FREE_MIN
timestamp PIN_FLD_START_T
timestamp PIN_FLD_END_T
enum PIN_FLD_DEFINE_STATUS
array PIN_FLD_ORDER_TIME_SLOTS
timestamp
timestamp
decimal
int PIN_FLD_CANCEL_REASON_ID
int PIN_FLD_ORDER_COUNT
int PIN_FLD_CANCEL_COUNT
array PIN_FLD_VENDOR_PROVISIONING
string
string
enum


Field Details

poid PIN_FLD_POID

Object Identifier for an instance of this class. Portal object ids have four pieces of information: database number, class type, sequence id, revision.

Notes

  • System defined on object creation
  • Can be modified only by System

Links

timestamp PIN_FLD_CREATED_T

Time the object was created.

Notes

  • System defined on object creation
  • Can be modified only by System

Links

timestamp PIN_FLD_MOD_T

Time the object was last modified.

Notes

  • System defined on object creation
  • Can be modified only by System

Links

string PIN_FLD_READ_ACCESS

Read Access level for object. Valid values are S(Self), G(Global), L(BrandLineage), B(BrandGroup), A(Ancestral).

Notes

  • System defined on object creation
  • Can be modified only by System
  • Maximum length is 255 bytes

Links

string PIN_FLD_WRITE_ACCESS

Write Access level for object. Valid values are S(Self), G(Global), L(BrandLineage), B(BrandGroup), A(Ancestral).

Notes

  • System defined on object creation
  • Can be modified only by System
  • Maximum length is 255 bytes

Links

string PIN_FLD_CREATE_ACCESS

Create Access level for object. Valid values are O(BrandOwner), R(Root), N(Any).

Notes

  • System defined on object creation
  • Can be modified only by System
  • Maximum length is 255 bytes

Links

poid PIN_FLD_ACCOUNT_OBJ

Link to account object for which this object was created.

Notes

  • Required on object creation
  • Can be modified

Links

string PIN_FLD_PERMITTED

Service type (should be /service/video or an extension of /service/video)

Notes

  • Can be specified on object creation
  • Can be modified
  • Maximum length is 255 bytes

Links

string PIN_FLD_DESCR

Title or description

Notes

  • Required on object creation
  • Can be modified
  • Maximum length is 255 bytes

Links

string PIN_FLD_CONTENT_PROVIDER_NAME

Creator of the file

Notes

  • Required on object creation
  • Can be modified
  • Maximum length is 255 bytes

Links

string PIN_FLD_CONTENT_ITEM_ID

Number that uniquely identifes a schedule

Notes

  • Required on object creation
  • Can be modified
  • Maximum length is 64 bytes

Links

string PIN_FLD_REMIT_TYPE

Number that can group schedules

Notes

  • Can be specified on object creation
  • Can be modified
  • Maximum length is 64 bytes

Links

string PIN_FLD_STUDIO

Content producer

Notes

  • Can be specified on object creation
  • Can be modified
  • Maximum length is 64 bytes

Links

int PIN_FLD_SUBJECT_ID

Number representing the string id of the localized string for the genre of the schedule

Notes

  • Can be specified on object creation
  • Can be modified

Links

string PIN_FLD_RATING

MPAA rating

Notes

  • Can be specified on object creation
  • Can be modified
  • Maximum length is 10 bytes

Links

string PIN_FLD_DISTRIBUTOR

Distributor of content

Notes

  • Can be specified on object creation
  • Can be modified
  • Maximum length is 64 bytes

Links

int PIN_FLD_COPY_VALUE_ID

Number representing the string id of the localized string for recording values - dictates whether a studio allows recording of a given schedule

Notes

  • Can be specified on object creation
  • Can be modified

Links

enum PIN_FLD_STATUS

Status of the schedule Legal values are ACTIVE(1) and CANCELED(2)

Notes

  • Can be specified on object creation
  • Can be modified

Links

string PIN_FLD_CHANNEL

Channel on which the schedule is broadcast

Notes

  • Required on object creation
  • Can be modified
  • Maximum length is 64 bytes

Links

int PIN_FLD_FREE_MIN

Number of minutes a subscriber can view a schedule before ordering it

Notes

  • Can be specified on object creation
  • Can be modified

Links

timestamp PIN_FLD_START_T

Scheduled start time of the broadcast

Notes

  • Required on object creation
  • Can be modified

Links

timestamp PIN_FLD_END_T

Scheduled stop time of the broadcast

Notes

  • Required on object creation
  • Can be modified

Links

enum PIN_FLD_DEFINE_STATUS

Depicts whether schedule exists on any Conditional Access Systems. Legal values are NOT_DEFINED(0), DEFINED(1) and PARTIAL_DEFINED(2)

Notes

  • Can be specified on object creation
  • Can be modified

Links

array PIN_FLD_ORDER_TIME_SLOTS

Notes

  • Can be specified on object creation
  • Can be modified

Links

timestamp PIN_FLD_ORDER_START

Order window start date and time

Notes

Links

timestamp PIN_FLD_ORDER_STOP

Order window stop date and time

Notes

Links

decimal PIN_FLD_ORDER_PRICE

Price to be charged when subscriber orders during this time window

Notes

Links

int PIN_FLD_CANCEL_REASON_ID

Number representing the string id of the localized string for reason a schedule was cancelled

Notes

  • Can be specified on object creation
  • Can be modified

Links

int PIN_FLD_ORDER_COUNT

Number of orders received for a schedule

Notes

  • Can be specified on object creation
  • Can be modified

Links

int PIN_FLD_CANCEL_COUNT

Number of cancels received for a schedule

Notes

  • Can be specified on object creation
  • Can be modified

Links

array PIN_FLD_VENDOR_PROVISIONING

Notes

  • Can be specified on object creation
  • Can be modified

Links

string PIN_FLD_VENDOR

Conditional Access Vendor

Notes

Links

string PIN_FLD_PROVISIONING_TAG

Conditional Access Vendor ID for a schedule - uniquely identifies a schedule on specific CAS

Notes

Links

enum PIN_FLD_DELETE_STATUS

Depicts whether a delete transaction has been sent to the CASs once an event has expired. Legal values are NOT_SENT(0) and SENT(1)

Notes

Links



SQL Mapping


Type Field Name Table Column Name
base-class /ppv_schedule ppv_schedule_t
poid PIN_FLD_POID poid*
timestamp PIN_FLD_CREATED_T created_t
timestamp PIN_FLD_MOD_T mod_t
string PIN_FLD_READ_ACCESS read_access
string PIN_FLD_WRITE_ACCESS wrtie_access
string PIN_FLD_CREATE_ACCESS create_access
poid PIN_FLD_ACCOUNT_OBJ account_obj*
string PIN_FLD_PERMITTED permitted
string PIN_FLD_DESCR descr
string PIN_FLD_CONTENT_PROVIDER_NAME content_provider
string PIN_FLD_CONTENT_ITEM_ID content_item_id
string PIN_FLD_REMIT_TYPE remit_type
string PIN_FLD_STUDIO studio
int PIN_FLD_SUBJECT_ID subject_id
string PIN_FLD_RATING rating
string PIN_FLD_DISTRIBUTOR distributor
int PIN_FLD_COPY_VALUE_ID copy_value_id
enum PIN_FLD_STATUS status
string PIN_FLD_CHANNEL channel
int PIN_FLD_FREE_MIN free_min
timestamp PIN_FLD_START_T start_t
timestamp PIN_FLD_END_T end_t
enum PIN_FLD_DEFINE_STATUS define_status
array PIN_FLD_ORDER_TIME_SLOTS ppv_schd_order_time_slots_t
timestamp
PIN_FLD_ORDER_START
 		order_start
timestamp
PIN_FLD_ORDER_STOP
 		order_stop
decimal
PIN_FLD_ORDER_PRICE
 		order_price
int PIN_FLD_CANCEL_REASON_ID cancel_reason_id
int PIN_FLD_ORDER_COUNT order_count
int PIN_FLD_CANCEL_COUNT cancel_count
array PIN_FLD_VENDOR_PROVISIONING ppv_schd_vendor_provisioning_t
string
PIN_FLD_VENDOR
 		vendor
string
PIN_FLD_PROVISIONING_TAG
 		provisioning_tag
enum
PIN_FLD_DELETE_STATUS
 		delete_status
Column names marked with * are actually column prefixes. For poid type fields, the column prefix is used to create the columns poid_id0, poid_db and poid_type if the prefix is "poid". For PIN_FLD_POID in the base table, an additional column named poid_rev is created to hold the poid revision. For buffer fields, two columns are created - one in the containing table and one in the buffer table. For example if the prefix is "buf", then the column name in the buffer table is buffer_buf and the column name in the containing table is buffer_size.

Field Index This Class