Table Description
CREOLE Product Sandbox: The CREOLE Product Sandbox entity allows a product to be configured before it is published.

The CREOLE Product Sandbox entity allows a product to be configured before it is published. It also allows updates to be made to an already live product before those changes are published.

Relationship Diagram
Click the diagram to manipulate and zoom. Traverse the diagram using Click-and-Drag motions.
Model Details
Location in Model: Logical View::MetaModel::Curam::Core::Reference Model::Products::Entity Objects::Infrastructure::Entities::CREOLEProductSandbox::CREOLEProductSandbox
Controlling File: core\model\Packages\Products\Infrastructure\Entities_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (7)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
sandboxIDkeynoUnique identifier of the sandbox record.INTERNAL_ID SVR_INT64
snapshotIDdetails Unique identifier of the snapshot record.INTERNAL_ID SVR_INT64
userNamedetailsnoThe name of the user who last updated the sandbox.USER_NAME SVR_STRING<64>
snapshotDatadetails Contains a snapshot of the product in XML format.CREOLE_PRODUCT_SNAPSHOT_DATA SVR_BLOB
actionTypedetailsnoDefines the type of action being performed on the sandbox, e.g. Created, Edited, Removed.CREOLE_PRODUCT_SANDBOX_ACTION_TYPEProductSandboxActionTypeSVR_STRING<10>
actionDateTimedetailsnoThe date/time on which the action was performed.CURAM_DATETIME SVR_DATETIME
pendingPublicationInddetails Whether this record is pending publication.CURAM_INDICATOR SVR_BOOLEAN
Foreign Keys (1)
ChildParent
CREOLEProductPublicationItem.sandboxIDCREOLEProductSandbox.sandboxID
Indices (1)
Index NameAttributes
ProductSandbox1IndexsnapshotID
Operations (6)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: sandboxID
Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
readread Standard Operation 
readAllnkreadmultiORDER_BY: actionDateTime
  
removeremove Standard Operation 
searchBySnapshotreadmulti   
Related Pages (38)
Remove Display Category (CREOLEProductAdmin_confirmRemoveDecisionDispCat)
Remove Product Period (CREOLEProductAdmin_confirmRemoveProductPeriod)
Remove Product Period Decision Details Rule (CREOLEProductAdmin_confirmRemoveProductPeriodDispCat)
Discard Changes (CREOLEProductAdmin_confirmRemoveSandbox)
Edit Name (CREOLEProductAdmin_confirmRenameDispCat)
Edit Name (CREOLEProductAdmin_confirmRenameProductPeriod)
New Display Category (CREOLEProductAdmin_createSandboxDecisionDisplayCategory)
Confirm Copy of Rules for Edit (CREOLEProductAdmin_createSandboxFromProduct)
Associate Decision Details Rule (CREOLEProductAdmin_createSandboxProdPeriodDispCat)
Associate Decision Details Rule (CREOLEProductAdmin_createSandboxProdPeriodDispCat1)
New Product Period (CREOLEProductAdmin_createSandboxProductPeriod)
CREOLEProductAdmin_listHistoryDecisionDispCat
CREOLEProductAdmin_listHistoryProductPeriod
Product Period Display Categories (CREOLEProductAdmin_listHistoryProductPeriodDispCat)
Product Period Display Categories (CREOLEProductAdmin_listHistoryProductPeriodDispCat1)
CREOLEProductAdmin_listInEditDecisionDispCat
CREOLEProductAdmin_listInEditProductPeriod
Product Period Display Categories (CREOLEProductAdmin_listInEditProductPeriodDispCat)
Product Period Display Categories (CREOLEProductAdmin_listInEditProductPeriodDispCat1)
CREOLEProductAdmin_listProductHistory
CREOLEProductAdmin_listPublishedDecisionDispCat
CREOLEProductAdmin_listPublishedProductPeriod
Product Period Display Categories (CREOLEProductAdmin_listPublishedProductPeriodDispCat)
Product Period Display Categories (CREOLEProductAdmin_listPublishedProductPeriodDispCat1)
Edit Display Category (CREOLEProductAdmin_modifyDecisionDispCat)
Edit Eligibility Determination Details (CREOLEProductAdmin_modifyInEditEligibilityDeterminationDetails)
Edit Product Period Decision Details Rule (CREOLEProductAdmin_modifyProdPeriodDispCat)
Edit Product Period (CREOLEProductAdmin_modifyProductPeriod)
CREOLEProductAdmin_readHistoryEligibilityDeterminationDetails
CREOLEProductAdmin_readInEditEligibilityDeterminationDetails
CREOLEProductAdmin_readPublishedEligibilityDeterminationDetails
Publish Changes (CREOLEProductAdmin_selectForPublish)
New Product (Product_benefitWizardSummary)
New Product (Product_benefitWizardSummary1)
New Product (Product_summaryForBenefitWizard)
New Product (Product_summaryForLiabilityWizard)
New Product (Wizard_benefitSummary)
New Product (Wizard_liabilitySummary)