Copyright (c) 1996, 2015, Oracle and/or its affiliates. All rights reserved.
This material is the confidential property of Oracle Corporation or its licensors and may be used, reproduced, stored or transmitted only in accordance with a valid Oracle license or sublicense agreement.

Field Index SQL Mapping

Class /sponsorship

This object describes a sponsorship relationship. The new name for sponsorship is Charge Sharing, They are used here interchangably.

Notes

  • The system will assign poid ids above 1000 to objects of this class. The range below this is reserved for creating objects with well-known poid ids.
  • This object can be read by the owner or any billing group leader who is an ancestor of the owner.
  • This object can be modified only by 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_DESCR
timestamp PIN_FLD_END_T
string PIN_FLD_NAME
string PIN_FLD_CODE
timestamp PIN_FLD_START_T
array PIN_FLD_USAGE_MAP
string
string
int
poid PIN_FLD_ATTRIBUTE_OBJ


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

Account object for which this object was created.

Notes

  • Required on object creation
  • Cannot be modified
  • Audit trail is created automatically when this field is modified.

Links

string PIN_FLD_DESCR

Sponsorship description.

Notes

  • Can be specified on object creation
  • Can be modified
  • Audit trail is created automatically when this field is modified.
  • Maximum length is 255 bytes

Links

timestamp PIN_FLD_END_T

Non-inclusive end time of the validity period for the object. If the value is 0, means this is always valid.

Notes

  • Can be specified on object creation
  • Can be modified
  • Audit trail is created automatically when this field is modified.

Links

string PIN_FLD_NAME

Unique name of the sponsorship object.

Notes

  • Required on object creation
  • Can be modified
  • Audit trail is created automatically when this field is modified.
  • Maximum length is 255 bytes

Links

string PIN_FLD_CODE

Unique code of the sponsorship object.Relevant if PDC is enabled

Notes

  • Required on object creation
  • Cannot be modified
  • Audit trail is created automatically when this field is modified.
  • Maximum length is 255 bytes

Links

timestamp PIN_FLD_START_T

Inclusive absolute start time

Notes

  • Can be specified on object creation
  • Can be modified
  • Audit trail is created automatically when this field is modified.

Links

array PIN_FLD_USAGE_MAP

Array of entries defining how sponsorship should be performed for different events.

Notes

  • Can be specified on object creation
  • Can be modified

Links

string PIN_FLD_EVENT_TYPE

Type of event that this entry specifies sponsorship for. Unique within usage map. Subtypes are implicitly included.

Notes

Links

string PIN_FLD_DISCOUNT_MODEL

Name of Discount Model implementing the sponsorship.

Notes

Links

int PIN_FLD_FLAGS

Specify if this usage map is valid if the sponsorship instance is at certain status. Currently we have two flags: Inactivated flag PIN_PRICE_INACTIVATED(0x01); Cancelled flag PIN_PRICE_CANCELLED(0x02). By default, the two flags should not be set, which means that this usage map is not valid when the object status is inactivated or cancelled

Notes

Links

poid PIN_FLD_ATTRIBUTE_OBJ

POID of the offer attribute group object.

Notes

  • Can be specified on object creation
  • Can be modified

Links



SQL Mapping


Type Field Name Table Column Name
base-class /sponsorship sponsorship_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_DESCR descr
timestamp PIN_FLD_END_T end_t
string PIN_FLD_NAME name
string PIN_FLD_CODE code
timestamp PIN_FLD_START_T start_t
array PIN_FLD_USAGE_MAP sponsorship_usage_map_t
string
PIN_FLD_EVENT_TYPE
 		event_type
string
PIN_FLD_DISCOUNT_MODEL
 		discount_model
int
PIN_FLD_FLAGS
 		flags
poid PIN_FLD_ATTRIBUTE_OBJ attribute_obj*
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