General informations
Fields (44)
Name | Label | Type | Description |
---|---|---|---|
Id | Plan Benefit ID | ID | |
OwnerId | Owner ID | LOOKUP | |
IsDeleted | Deleted | CHECKBOX | |
Name | Name | TEXT(255) | |
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 | |
PurchaserPlanId | Purchaser Plan ID | MASTER-DETAIL | |
EffectiveDate | Effective Date | DATE | |
Status | Status | PICKLIST | |
EffectiveFrom | Effective From | DATE | |
EffectiveTo | Effective To | DATE | |
PrimaryCareCopay | Primary Care Copay | CURRENCY(16,2) | |
SpecialistCopay | Specialist Copay | CURRENCY(16,2) | |
EmergencyDepartmentCopay | Emergency Department Copay | CURRENCY(16,2) | |
UrgentCareCopay | Urgent Care Copay | CURRENCY(16,2) | |
CopayNotes | Copay Notes | TEXT AREA (LONG)(32000) | |
IndividualInNetworkDeductible | Individual In-Network Deductible | CURRENCY(16,2) | |
IndividualOutofNetworkDeductible | Individual Out-of-Network Deductible | CURRENCY(16,2) | |
FamilyInNetworkDeductible | Family In-Network Deductible | CURRENCY(16,2) | |
FamilyOutofNetworkDeductible | Family Out-of-Network Deductible | CURRENCY(16,2) | |
DeductibleNotes | Deductible Notes | TEXT AREA (LONG)(32000) | |
InNetworkCoinsurancePercentage | In-Network Coinsurance (Percentage) | NUMBER(18,0) | |
OutofNetworkCoinsurancePercentage | Out-of-Network Coinsurance (Percentage) | NUMBER(18,0) | |
InNetworkCoinsuranceAmount | In-Network Coinsurance (Amount) | NUMBER(18,0) | |
OutofNetworkCoinsuranceAmount | Out-of-Network Coinsurance (Amount) | NUMBER(18,0) | |
CoinsuranceNotes | Coinsurance Notes | TEXT AREA (LONG)(32000) | |
IndividualInNetworkOutofPocket | Individual In-Network Out-of-Pocket | CURRENCY(16,2) | |
IndividualOutofNetworkOutofPocket | Individual Out-of-Network Out-of-Pocket | CURRENCY(16,2) | |
FamilyInNetworkOutofPocket | Family In-Network Out-of-Pocket | CURRENCY(16,2) | |
FamilyOutofNetworkOutofPocket | Family Out-of-Network Out-of-Pocket | CURRENCY(16,2) | |
OutofPocketNotes | Out-of-Pocket Notes | TEXT AREA (LONG)(32000) | |
InNetworkLifetimeMaximum | In-Network Lifetime Maximum | CURRENCY(16,2) | |
OutofNetworkLifetimeMaximum | Out-of-Network Lifetime Maximum | CURRENCY(16,2) | |
LifetimeMaximumNotes | Lifetime Maximum Notes | TEXT AREA (LONG)(32000) | |
BenefitNotes | Benefit Notes | TEXT AREA (LONG)(32000) | |
DocumentLocation | Document Location | TEXT(255) | |
SourceSystemIdentifier | Source System Identifier | TEXT(255) | |
SourceSystem | Source System | TEXT(64) | |
SourceSystemModified | Source System Modified | DATETIME |
Fields Details (44)
Name | Id |
Label | Plan Benefit ID |
Type | ID |
Required | Yes |
Name | OwnerId |
Label | Owner ID |
Type | LOOKUP |
Foreign key | Yes |
Required | Yes |
Name | IsDeleted |
Label | Deleted |
Type | CHECKBOX |
Required | Yes |
Default value | false |
Name | Name |
Label | Name |
Type | TEXT(255) |
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 | PurchaserPlanId |
Label | Purchaser Plan ID |
Type | MASTER-DETAIL |
Foreign key | Yes |
Required | Yes |
Name | EffectiveDate |
Label | Effective Date |
Type | DATE |
Name | Status |
Label | Status |
Type | PICKLIST |
Picklist values | Active Inactive |
Name | EffectiveFrom |
Label | Effective From |
Type | DATE |
Name | EffectiveTo |
Label | Effective To |
Type | DATE |
Name | PrimaryCareCopay |
Label | Primary Care Copay |
Type | CURRENCY(16,2) |
Name | SpecialistCopay |
Label | Specialist Copay |
Type | CURRENCY(16,2) |
Name | EmergencyDepartmentCopay |
Label | Emergency Department Copay |
Type | CURRENCY(16,2) |
Name | UrgentCareCopay |
Label | Urgent Care Copay |
Type | CURRENCY(16,2) |
Name | CopayNotes |
Label | Copay Notes |
Type | TEXT AREA (LONG)(32000) |
Name | IndividualInNetworkDeductible |
Label | Individual In-Network Deductible |
Type | CURRENCY(16,2) |
Name | IndividualOutofNetworkDeductible |
Label | Individual Out-of-Network Deductible |
Type | CURRENCY(16,2) |
Name | FamilyInNetworkDeductible |
Label | Family In-Network Deductible |
Type | CURRENCY(16,2) |
Name | FamilyOutofNetworkDeductible |
Label | Family Out-of-Network Deductible |
Type | CURRENCY(16,2) |
Name | DeductibleNotes |
Label | Deductible Notes |
Type | TEXT AREA (LONG)(32000) |
Name | InNetworkCoinsurancePercentage |
Label | In-Network Coinsurance (Percentage) |
Type | NUMBER(18,0) |
Name | OutofNetworkCoinsurancePercentage |
Label | Out-of-Network Coinsurance (Percentage) |
Type | NUMBER(18,0) |
Name | InNetworkCoinsuranceAmount |
Label | In-Network Coinsurance (Amount) |
Type | NUMBER(18,0) |
Name | OutofNetworkCoinsuranceAmount |
Label | Out-of-Network Coinsurance (Amount) |
Type | NUMBER(18,0) |
Name | CoinsuranceNotes |
Label | Coinsurance Notes |
Type | TEXT AREA (LONG)(32000) |
Name | IndividualInNetworkOutofPocket |
Label | Individual In-Network Out-of-Pocket |
Type | CURRENCY(16,2) |
Name | IndividualOutofNetworkOutofPocket |
Label | Individual Out-of-Network Out-of-Pocket |
Type | CURRENCY(16,2) |
Name | FamilyInNetworkOutofPocket |
Label | Family In-Network Out-of-Pocket |
Type | CURRENCY(16,2) |
Name | FamilyOutofNetworkOutofPocket |
Label | Family Out-of-Network Out-of-Pocket |
Type | CURRENCY(16,2) |
Name | OutofPocketNotes |
Label | Out-of-Pocket Notes |
Type | TEXT AREA (LONG)(32000) |
Name | InNetworkLifetimeMaximum |
Label | In-Network Lifetime Maximum |
Type | CURRENCY(16,2) |
Name | OutofNetworkLifetimeMaximum |
Label | Out-of-Network Lifetime Maximum |
Type | CURRENCY(16,2) |
Name | LifetimeMaximumNotes |
Label | Lifetime Maximum Notes |
Type | TEXT AREA (LONG)(32000) |
Name | BenefitNotes |
Label | Benefit Notes |
Type | TEXT AREA (LONG)(32000) |
Name | DocumentLocation |
Label | Document Location |
Type | TEXT(255) |
Name | SourceSystemIdentifier |
Label | Source System Identifier |
Type | TEXT(255) |
Name | SourceSystem |
Label | Source System |
Type | TEXT(64) |
Name | SourceSystemModified |
Label | Source System Modified |
Type | DATETIME |
Parents relationships(12)
Children relationships(4)
Name | Parent object | Child object | Parent object field | Child object field |
---|---|---|---|---|
Owner | User | PlanBenefit |
|
|
CreatedBy | User | PlanBenefit |
|
|
LastModifiedBy | User | PlanBenefit |
|
|
PurchaserPlan | PurchaserPlan | PlanBenefit |
|
|
Object User-defined metadata (0)
Label | Value |
---|