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

Class /offer_profile

The offer profile will be used to describe the Policy Labels as wellas any static Policy Attributes that are required for that specificPolicy configuration.

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 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
string PIN_FLD_DESCR
string PIN_FLD_CODE
string PIN_FLD_NAME
poid PIN_FLD_ACCOUNT_OBJ
array PIN_FLD_POLICY_LABELS
string
string
int
enum
array
decimal
decimal
string


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

string PIN_FLD_DESCR

Description about the offer_profile object.

Notes

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

Links

string PIN_FLD_CODE

Code of the offer_profile. Assumed to be unique across all offer_profile

Notes

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

Links

string PIN_FLD_NAME

Name of the offer_profile object.

Notes

  • Required on object creation
  • Can be modified
  • 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

array PIN_FLD_POLICY_LABELS

Array to hold the policy labels information.

Notes

  • Can be specified on object creation
  • Can be modified

Links

string PIN_FLD_LABEL

The label of the policy.

Notes

Links

string PIN_FLD_RESOURCE_NAME

The resource name.

Notes

Links

int PIN_FLD_RESOURCE_ID

The resource id

Notes

Links

enum PIN_FLD_UNIT

Unit of the resource.

Notes

Links

array PIN_FLD_TIERS

Tier array

Notes

Links

decimal PIN_FLD_TIER_START_RANGE

Start tier range, start is assumed to beinclusive of value ( e.g. start <= x < end, 0 <= x < 2.5)

Notes

  • Can be specified on object creation
  • Can be modified

Links

decimal PIN_FLD_TIER_END_RANGE

End tier range, end is assumed to beexclusive of value ( e.g. start <= x < end, 0 <= x < 2.5)

Notes

  • Can be specified on object creation
  • Can be modified

Links

string PIN_FLD_STATUS_LABEL

Status Label Name

Notes

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

Links


SQL Mapping


Type Field Name Table Column Name
base-class /offer_profile offer_profile_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
string PIN_FLD_DESCR descr
string PIN_FLD_CODE code
string PIN_FLD_NAME name
poid PIN_FLD_ACCOUNT_OBJ account_obj*
array PIN_FLD_POLICY_LABELS offer_profile_policy_labels_t
string
PIN_FLD_LABEL
 		label
string
PIN_FLD_RESOURCE_NAME
 		resource_name
int
PIN_FLD_RESOURCE_ID
 		resource_id
enum
PIN_FLD_UNIT
 		unit
array
PIN_FLD_TIERS
 		offer_profile_tiers_t
decimal
PIN_FLD_TIER_START_RANGE
tier_start_range
decimal
PIN_FLD_TIER_END_RANGE
tier_end_range
string
PIN_FLD_STATUS_LABEL
status_label
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