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