Database Table: ProductGroup
| Product Group:
Related set of products that can apply to a group of persons.
|
| Location in Model: | Logical View::MetaModel::Curam::Core::Reference Model::Products::Entity Objects::ProductGroup::ProductGroup |
| Controlling File: | core\model\Packages\Products\ProductGroup_cat.efx |
| ALLOW_OPTIMISTIC_LOCKING | yes |
| Attribute | Stereotype | Nullable | Description | Domain Definition | Codetable | DDL Type |
| productGroupID | key | no | Unique reference number assigned by the system to a Product Group record | PRODUCT_GROUP_ID | | SVR_INT64 |
| periodConAmount | details | | The amount deducted for coverage of a Product, Product Group or Policy for a given period. | CURAM_AMOUNT | | SVR_MONEY |
| periodConRate | details | | The percentage deducted for coverage of a Product, Product Group or Policy for a given period. | RATE | | SVR_DOUBLE |
| minPeriodConAmount | details | | The minimum contribution amount that may be deducted for a Product, Product Group or Policy for a given period. | CURAM_AMOUNT | | SVR_MONEY |
| maxPeriodConAmount | details | | The maximum contribution amount that may be deducted for a Product, Product Group or Policy for a given period. | CURAM_AMOUNT | | SVR_MONEY |
| creationDate | details | | Date record was created on the system. | CURAM_DATE | | SVR_DATE |
| details | | Free text registered by the User. | COMMENTS | | SVR_STRING<300> |
|
| Operation | Stereotype | Options | Description | SQL |
| insert | insert | | Standard Operation | |
| modify | modify | OPTIMISTIC_LOCKING: yes
| Standard Operation | |
| read | read | | Standard Operation | |
|
