General informations
Fields (42)
| Name | Label | Type | Description |
|---|---|---|---|
| Id | Insurance Policy Coverage ID | ID | |
| IsDeleted | Deleted | CHECKBOX | |
| Name | Name | AUTO NUMBER | |
| CreatedDate | Created Date | DATETIME | |
| CreatedById | Created By ID | LOOKUP | |
| LastModifiedDate | Last Modified Date | DATETIME | |
| LastModifiedById | Last Modified By ID | LOOKUP | |
| SystemModstamp | System Modstamp | DATETIME | |
| LastViewedDate | Last Viewed Date | DATETIME | |
| LastReferencedDate | Last Referenced Date | DATETIME | |
| InsurancePolicyId | Insurance Policy ID | MASTER-DETAIL | |
| CategoryCode | Category Code | TEXT(255) | |
| LimitRange | Limit Range | PICKLIST | |
| LimitAmount | Limit Amount | CURRENCY(16,2) | |
| LimitDate | Limit Date | DATE | |
| LimitPercentage | Limit Percentage | PERCENT(3,0) | |
| PremiumAmount | Premium Amount | CURRENCY(16,2) | |
| DeductibleAmount | Deductible Amount | CURRENCY(16,2) | |
| Category | Category | PICKLIST | |
| CategoryGroup | Category Group | PICKLIST | |
| CategoryGroupType | Category Group Type | PICKLIST | |
| Discount | Discount | CURRENCY(16,2) | |
| BenefitPaymentFrequency | Benefit Payment Frequency | PICKLIST | |
| EffectiveDate | Effective Date | DATETIME | |
| ExpirationDate | Expiration Date | DATETIME | |
| IncomeOptionType | Income Option Type | PICKLIST | |
| DeathBenefitOptionType | Death Benefit Option Type | PICKLIST | |
| InsurancePolicyAssetId | Insurance Policy Asset ID | LOOKUP | |
| SourceSystemIdentifier | Source System Identifier | TEXT(255) | |
| SourceSystem | Source System | TEXT(255) | |
| CoverageName | Coverage Name | TEXT(255) | |
| Description | Description | TEXT AREA (LONG)(32000) | |
| InsurancePolicyParticipantId | Insurance Policy Participant ID | LOOKUP | |
| StandardPremiumAmount | Standard Premium | CURRENCY(16,2) | |
| StandardTaxAmount | Standard Tax | CURRENCY(16,2) | |
| StandardFeeAmount | Standard Fee | CURRENCY(16,2) | |
| TermFeeAmount | Term Fee | CURRENCY(16,2) | |
| TermPremiumAmount | Term Premium | CURRENCY(16,2) | |
| TermTaxAmount | Term Tax | CURRENCY(16,2) | |
| TotalStandardAmount | Total Standard Amount | ROLL-UP SUMMARY | |
| ContractGroupPlanId | Contract Group Plan ID | LOOKUP | |
| CoverageCode | Coverage Code | TEXT(255) |
Fields Details (42)
| Name | Id |
| Label | Insurance Policy Coverage ID |
| Type | ID |
| Required | Yes |
| Name | IsDeleted |
| Label | Deleted |
| Type | CHECKBOX |
| Required | Yes |
| Default value | false |
| Name | Name |
| Label | Name |
| Type | AUTO NUMBER |
| Required | Yes |
| Name | CreatedDate |
| Label | Created Date |
| Type | DATETIME |
| Required | Yes |
| Name | CreatedById |
| Label | Created By ID |
| Type | LOOKUP |
| Foreign key | Yes |
| Required | Yes |
| Name | LastModifiedDate |
| Label | Last Modified Date |
| Type | DATETIME |
| Required | Yes |
| Name | LastModifiedById |
| Label | Last Modified By ID |
| Type | LOOKUP |
| Foreign key | Yes |
| Required | Yes |
| Name | SystemModstamp |
| Label | System Modstamp |
| Type | DATETIME |
| Required | Yes |
| Name | LastViewedDate |
| Label | Last Viewed Date |
| Type | DATETIME |
| Name | LastReferencedDate |
| Label | Last Referenced Date |
| Type | DATETIME |
| Name | InsurancePolicyId |
| Label | Insurance Policy ID |
| Type | MASTER-DETAIL |
| Foreign key | Yes |
| Required | Yes |
| Name | CategoryCode |
| Label | Category Code |
| Type | TEXT(255) |
| Name | LimitRange |
| Label | Limit Range |
| Type | PICKLIST |
| Picklist values | 15/30/5 25/50/25 50/100/50 100/200/50 200/500/100 |
| Name | LimitAmount |
| Label | Limit Amount |
| Type | CURRENCY(16,2) |
| Name | LimitDate |
| Label | Limit Date |
| Type | DATE |
| Name | LimitPercentage |
| Label | Limit Percentage |
| Type | PERCENT(3,0) |
| Name | PremiumAmount |
| Label | Premium Amount |
| Type | CURRENCY(16,2) |
| Name | DeductibleAmount |
| Label | Deductible Amount |
| Type | CURRENCY(16,2) |
| Name | Category |
| Label | Category |
| Type | PICKLIST |
| Picklist values | Coverage Discount Rider Clause Deductible Limit Component |
| Name | CategoryGroup |
| Label | Category Group |
| Type | PICKLIST |
| Picklist values | Liability Uninsured Motorist Insurance Other Auto General Additional Coverage Section-1 Property Coverage Section 2/Liability Coverage Forms and Endorsements Home Bundled Coverage Workers' Compensation |
| Name | CategoryGroupType |
| Label | Category Group Type |
| Type | PICKLIST |
| Picklist values | Bodily Injury Property Damage Medical Payments Collision Comprehensive Disability Death Rehabilitation |
| Name | Discount |
| Label | Discount |
| Type | CURRENCY(16,2) |
| Name | BenefitPaymentFrequency |
| Label | Benefit Payment Frequency |
| Type | PICKLIST |
| Picklist values | Monthly Semi-Monthly(twice a month) Quarterly Semi-Annual(twice a year) Annually |
| Name | EffectiveDate |
| Label | Effective Date |
| Type | DATETIME |
| Name | ExpirationDate |
| Label | Expiration Date |
| Type | DATETIME |
| Name | IncomeOptionType |
| Label | Income Option Type |
| Type | PICKLIST |
| Picklist values | Carry Forward Customer Specified Deposit At interest Dividend Payment Indexed Interest Only |
| Name | DeathBenefitOptionType |
| Label | Death Benefit Option Type |
| Type | PICKLIST |
| Picklist values | Adjustable Decreasing based on a commuted value |
| Name | InsurancePolicyAssetId |
| Label | Insurance Policy Asset ID |
| Type | LOOKUP |
| Foreign key | Yes |
| Name | SourceSystemIdentifier |
| Label | Source System Identifier |
| Type | TEXT(255) |
| Unique | Yes |
| Name | SourceSystem |
| Label | Source System |
| Type | TEXT(255) |
| Name | CoverageName |
| Label | Coverage Name |
| Type | TEXT(255) |
| Name | Description |
| Label | Description |
| Type | TEXT AREA (LONG)(32000) |
| Name | InsurancePolicyParticipantId |
| Label | Insurance Policy Participant ID |
| Type | LOOKUP |
| Foreign key | Yes |
| Name | StandardPremiumAmount |
| Label | Standard Premium |
| Type | CURRENCY(16,2) |
| Name | StandardTaxAmount |
| Label | Standard Tax |
| Type | CURRENCY(16,2) |
| Name | StandardFeeAmount |
| Label | Standard Fee |
| Type | CURRENCY(16,2) |
| Name | TermFeeAmount |
| Label | Term Fee |
| Type | CURRENCY(16,2) |
| Name | TermPremiumAmount |
| Label | Term Premium |
| Type | CURRENCY(16,2) |
| Name | TermTaxAmount |
| Label | Term Tax |
| Type | CURRENCY(16,2) |
| Name | TotalStandardAmount |
| Label | Total Standard Amount |
| Type | ROLL-UP SUMMARY |
| Name | ContractGroupPlanId |
| Label | Contract Group Plan ID |
| Type | LOOKUP |
| Foreign key | Yes |
| Name | CoverageCode |
| Label | Coverage Code |
| Type | TEXT(255) |
Parents relationships(23)
Children relationships(6)
Object User-defined metadata (0)
| Label | Value |
|---|