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 /service

Generic Service Object. A service object creates an identity for the account object to which it belongs. This identity can perform actions and use resources. There can be multiple service objects associated with an account. The billing is tracked to the service level. The service object can be extended to add additional service-specific information.

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_AAC_ACCESS
string PIN_FLD_AAC_PACKAGE
string PIN_FLD_AAC_PROMO_CODE
string PIN_FLD_AAC_SERIAL_NUM
string PIN_FLD_AAC_SOURCE
string PIN_FLD_AAC_VENDOR
poid PIN_FLD_ACCOUNT_OBJ
poid PIN_FLD_BAL_GRP_OBJ
poid PIN_FLD_SUBSCRIPTION_OBJ
poid PIN_FLD_NAMEINFO_OBJ
timestamp PIN_FLD_CLOSE_WHEN_T
string PIN_FLD_ITEM_POID_LIST
string PIN_FLD_NEXT_ITEM_POID_LIST
string PIN_FLD_LASTSTAT_CMNT
timestamp PIN_FLD_LAST_STATUS_T
string PIN_FLD_LOGIN
string PIN_FLD_NAME
string PIN_FLD_PASSWD
enum PIN_FLD_PASSWD_STATUS
timestamp PIN_FLD_PASSWD_EXPIRATION_T
poid PIN_FLD_PROFILE_OBJ
string PIN_FLD_SERVICE_ID
enum PIN_FLD_TYPE
enum PIN_FLD_STATUS
int PIN_FLD_STATUS_FLAGS
timestamp PIN_FLD_EFFECTIVE_T
array PIN_FLD_ALIAS_LIST
string
array PIN_FLD_TRANSFER_LIST
poid
poid
poid
timestamp
string
string
enum PIN_FLD_OBJECT_CACHE_TYPE
int PIN_FLD_LIFECYCLE_STATE
timestamp PIN_FLD_SERVICE_STATE_EXPIRATION_T
timestamp PIN_FLD_SVC_EXP_LAST_NOTI_T
string PIN_FLD_SVC_EXP_LAST_NOTI_OFFSET


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_AAC_ACCESS

Automatic account creation field that indicates the access level specified when this service was created. This is a user-defined field to be used for marketing purposes.

Notes

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

Links

string PIN_FLD_AAC_PACKAGE

See PIN_FLD_AAC_PACKAGE in /account.

Notes

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

Links

string PIN_FLD_AAC_PROMO_CODE

See PIN_FLD_AAC_PROMO_CODE in /account.

Notes

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

Links

string PIN_FLD_AAC_SERIAL_NUM

See PIN_FLD_AAC_SERIAL_NUM in /account.

Notes

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

Links

string PIN_FLD_AAC_SOURCE

See PIN_FLD_AAC_SOURCE in /account.

Notes

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

Links

string PIN_FLD_AAC_VENDOR

See PIN_FLD_AAC_VENDOR in /account.

Notes

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

Links

poid PIN_FLD_ACCOUNT_OBJ

Link to the account object to which this service belongs.

Notes

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

Links

poid PIN_FLD_BAL_GRP_OBJ

Link to the balance_group for this service.

Notes

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

Links

poid PIN_FLD_SUBSCRIPTION_OBJ

Link to the subscription service object for this service.

Notes

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

Links

poid PIN_FLD_NAMEINFO_OBJ

Link to the nameinfo object for this service which contains the contact information.

Notes

  • Can be specified on object creation
  • Can be modified

Links

timestamp PIN_FLD_CLOSE_WHEN_T

Date this service should be automatically closed. This field is used to schedule service closure in advance. A value of 0 means that this service is not designated to be closed automatically.

Notes

  • Cannot specify on object creation
  • Can be modified

Links

string PIN_FLD_ITEM_POID_LIST

List of cumulative item poids - all currently active items for the account/service.

Notes

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

Links

string PIN_FLD_NEXT_ITEM_POID_LIST

If you have delayed batch events coming into Billing system and you have configured the system to have a delay for the billing run, so that all the events for the current billing cycle are received, before the billing is actually run, in that case, this field will store the list of item poids for next cycle (given that the billing for the current cycle is not yet run).

Notes

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

Links

string PIN_FLD_LASTSTAT_CMNT

Descriptive reason for the last status change to this service. This provides CSR a snapshot of why the status was changed.

Notes

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

Links

timestamp PIN_FLD_LAST_STATUS_T

Timestamp of when the status of this service was last changed.

Notes

  • Cannot specify on object creation
  • Can be modified

Links

string PIN_FLD_LOGIN

Login name associated with this service object.

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

string PIN_FLD_NAME

Name of this service object.

Notes

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

Links

string PIN_FLD_PASSWD

Password associated with this service object in encrypted or clear format. Typically, the encryption method is encoded as a prefix by the password encryption policies in the customer manager.

Notes

  • Can be specified on object creation
  • Can be modified
  • Encrypted value is stored in the database.
  • Maximum length is 1024 bytes

Links

enum PIN_FLD_PASSWD_STATUS

Used to specify password states. The possible states are NORMAL (0), TEMPORARY (1), EXPIRES (2) and INVALID(3).

Notes

  • Can be specified on object creation
  • Can be modified

Links

timestamp PIN_FLD_PASSWD_EXPIRATION_T

The expiration time of the service password.

Notes

  • Can be specified on object creation
  • Can be modified

Links

poid PIN_FLD_PROFILE_OBJ

Link to another service object of the same type which contains common attributes that one or more services may use.

Notes

  • Can be specified on object creation
  • Can be modified

Links

string PIN_FLD_SERVICE_ID

User defined name for the service. The Pricing Tool relies on this name being unique across all services defined in the plan.

Notes

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

Links

enum PIN_FLD_TYPE

This field specifies whether this service is an optional (0) service or required (1) basic service.

Notes

  • Can be specified on object creation
  • Can be modified

Links

enum PIN_FLD_STATUS

Status of the service. Values are active (10100), inactive (10102) and closed (10103). Typically user access to services is blocked unless active (policy controlled).

Notes

  • Cannot specify on object creation
  • Can be modified

Links

int PIN_FLD_STATUS_FLAGS

System and user-defined modifier flags to track the reasons for the service being inactive. See pin_cust.h for possible values.

Notes

  • Cannot specify on object creation
  • Can be modified

Links

timestamp PIN_FLD_EFFECTIVE_T

Effective time of modification of this service on an external system.

Notes

  • Can be specified on object creation
  • Can be modified

Links

array PIN_FLD_ALIAS_LIST

Alias List. List of aliases that also identify this user/service. The examples are Caller ID, or MAC address. The element-id is not significant. The name must be globally unique per service-type.

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

Associated alias name. This must be globally unique per service type.

Notes

Links

array PIN_FLD_TRANSFER_LIST

Optional Transfer list array. One array element is added every time a line/subscription is transferred from one account to a different account or when service is transferred from one bal_grpto another or when a balance_group is repointed fromone billinfo to another.

Notes

  • Can be specified on object creation
  • Can be modified

Links

poid PIN_FLD_ACCOUNT_OBJ

Account object from which the Line/ Subscription/service/balance_group is transferred.

Notes

Links

poid PIN_FLD_BAL_GRP_OBJ

Balance_group object from which the / Service/balance_group is transferred.

Notes

Links

poid PIN_FLD_BILLINFO_OBJ

Billinfo from which bal_grp or service/ balance_group is transferred.

Notes

Links

timestamp PIN_FLD_EFFECTIVE_T

Timestamp of when the line/subscription/service/bal_grp was transferred.

Notes

Links

string PIN_FLD_ITEM_POID_LIST

List of cumulative item poids for current cycle, moved from the transferred line/subscription. This is the Item Poid list moved from /service.ITEM_POID_LIST to Transfer List array each time a line/subscription/service/bal_grp is transferred.

Notes

Links

string PIN_FLD_NEXT_ITEM_POID_LIST

List of cumulative item poids for next cycle, moved from the transferred line/subscription/service/bal_grp. This is the Next Item Poid list moved from /service.NEXT_ITEM_POID_LIST to Transfer List array each time a line/subscription is transferred.

Notes

Links

enum PIN_FLD_OBJECT_CACHE_TYPE

Stores the cache residency distinction value for an object instance. Possible values are DEFAULT(0), REALTIME(1) and BATCH(2).

Notes

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

Links

int PIN_FLD_LIFECYCLE_STATE

Lifecycle state of a service See pin_cust.h for possible values.

Notes

  • Can be specified on object creation
  • Can be modified

Links

timestamp PIN_FLD_SERVICE_STATE_EXPIRATION_T

Expiration time of the service state.

Notes

  • Can be specified on object creation
  • Can be modified

Links

timestamp PIN_FLD_SVC_EXP_LAST_NOTI_T

The last time this object was processed/checked for SERVICE_STATE_EXPIRATION_T notification.

Notes

  • Can be specified on object creation
  • Can be modified

Links

string PIN_FLD_SVC_EXP_LAST_NOTI_OFFSET

The offset with which the last time this object was processed/checked for SERVICE_STATE_EXPIRATION_T notification.

Notes

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

Links



SQL Mapping


Type Field Name Table Column Name
base-class /service service_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_AAC_ACCESS aac_access
string PIN_FLD_AAC_PACKAGE aac_package
string PIN_FLD_AAC_PROMO_CODE aac_promo_code
string PIN_FLD_AAC_SERIAL_NUM aac_serial_num
string PIN_FLD_AAC_SOURCE aac_source
string PIN_FLD_AAC_VENDOR aac_vendor
poid PIN_FLD_ACCOUNT_OBJ account_obj*
poid PIN_FLD_BAL_GRP_OBJ bal_grp_obj*
poid PIN_FLD_SUBSCRIPTION_OBJ subscription_obj*
poid PIN_FLD_NAMEINFO_OBJ nameinfo_obj*
timestamp PIN_FLD_CLOSE_WHEN_T close_when_t
string PIN_FLD_ITEM_POID_LIST item_poid_list
string PIN_FLD_NEXT_ITEM_POID_LIST next_item_poid_list
string PIN_FLD_LASTSTAT_CMNT laststat_cmnt
timestamp PIN_FLD_LAST_STATUS_T last_status_t
string PIN_FLD_LOGIN login
string PIN_FLD_NAME name
string PIN_FLD_PASSWD passwd
enum PIN_FLD_PASSWD_STATUS passwd_status
timestamp PIN_FLD_PASSWD_EXPIRATION_T passwd_expiration_t
poid PIN_FLD_PROFILE_OBJ profile_obj*
string PIN_FLD_SERVICE_ID service_id
enum PIN_FLD_TYPE type
enum PIN_FLD_STATUS status
int PIN_FLD_STATUS_FLAGS status_flags
timestamp PIN_FLD_EFFECTIVE_T effective_t
array PIN_FLD_ALIAS_LIST service_alias_list_t
string
PIN_FLD_NAME
 		name
array PIN_FLD_TRANSFER_LIST service_transfer_list_t
poid
PIN_FLD_ACCOUNT_OBJ
 		account_obj*
poid
PIN_FLD_BAL_GRP_OBJ
 		bal_grp_obj*
poid
PIN_FLD_BILLINFO_OBJ
 		billinfo_obj*
timestamp
PIN_FLD_EFFECTIVE_T
 		effective_t
string
PIN_FLD_ITEM_POID_LIST
 		item_poid_list
string
PIN_FLD_NEXT_ITEM_POID_LIST
 		next_item_poid_list
enum PIN_FLD_OBJECT_CACHE_TYPE object_cache_type
int PIN_FLD_LIFECYCLE_STATE lifecycle_state
timestamp PIN_FLD_SERVICE_STATE_EXPIRATION_T state_expiration_t
timestamp PIN_FLD_SVC_EXP_LAST_NOTI_T svc_exp_last_noti_t
string PIN_FLD_SVC_EXP_LAST_NOTI_OFFSET svc_exp_last_noti_offset
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