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

Class /cmt_reference

Used for storing references of data loaded by CMT

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 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
decimal PIN_FLD_BATCH_ID2
string PIN_FLD_BILLINFO_ID
string PIN_FLD_INPUT_ID
string PIN_FLD_OBJECT_TYPE
decimal PIN_FLD_POID_ID
int PIN_FLD_STAGE_ID
enum PIN_FLD_STATUS
int PIN_FLD_ACTG_CYCLE_DOM


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

decimal PIN_FLD_BATCH_ID2

The operating batch id of the related process.

Notes

  • Can be specified on object creation
  • Can be modified

Links

string PIN_FLD_BILLINFO_ID

The /billinfo or /balance_group poid id for /account or /service/* object type respectively.

Notes

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

Links

string PIN_FLD_INPUT_ID

The input id supplied in legacy data (XML) file.

Notes

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

Links

string PIN_FLD_OBJECT_TYPE

The type of object CMT assigns poid.

Notes

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

Links

decimal PIN_FLD_POID_ID

The poid id assigned by CMT.

Notes

  • Required on object creation
  • Can be modified

Links

int PIN_FLD_STAGE_ID

The stage to which migrated data belongs.

Notes

  • Required on object creation
  • Can be modified

Links

enum PIN_FLD_STATUS

Status for this account object. Status value 0 means account has not yet been completely deployed, a value 1 means account was succesfully deployed.

Notes

  • Can be specified on object creation
  • Can be modified

Links

int PIN_FLD_ACTG_CYCLE_DOM

The DOM in /billinfo for migrated account.

Notes

  • Can be specified on object creation
  • Can be modified

Links



SQL Mapping


Type Field Name Table Column Name
base-class /cmt_reference cmt_reference_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
decimal PIN_FLD_BATCH_ID2 batch_id
string PIN_FLD_BILLINFO_ID acct_billinfo_id
string PIN_FLD_INPUT_ID input_id
string PIN_FLD_OBJECT_TYPE obj_type
decimal PIN_FLD_POID_ID poid_id
int PIN_FLD_STAGE_ID stage_id
enum PIN_FLD_STATUS deploy_status
int PIN_FLD_ACTG_CYCLE_DOM cycle_dom
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