Benefits Batch and Offered Benefits Plan Cloned Fields
This topic lists the fields that clone (i.e., copy) to the Renewal Pending Benefits Batch and associated Offered Benefits Plans when you renew a Benefits Batch.
Note: All fields may not be visible to all users. For example, ID, Date Created, Date Updated, Import ID, Created By and Updated By are administrative fields only visible to System Administrators.
Benefits Batch Fields Cloned Upon Renewal
|
Field Label |
Field Name |
|---|---|
|
ID |
fkProjectID |
|
Date Created |
DateCreated |
|
Created By |
CreatedByUserID |
|
Dated Updated |
DateUpdated |
|
Updated By |
UpdatedByUserID |
|
Active |
IsActive |
|
Status |
luStatus |
|
Type |
luType |
|
Effective Date |
EffectiveDate |
|
Expiration Date |
ExpirationDate |
|
Eligibility |
luEligibility |
|
ACA ALE |
luACAALE |
|
Safe Harbor Method |
LuSafeHarborMethod |
|
Notes |
Notes |
|
Source Benefits Batch |
fkSourceBenefitsBatchID |
| Assigned To | fkAssignedToUserID |
| Renewal Assigned | fkRenewalAssignedUserID |
| Renewal Client Contact | fkRenewalClientContactID |
| Commuter Plan Accepted | luCommuterPlanAccepted |
|
HSA Plan Offered |
luHSAPlanOffered |
|
FSA Plan Offered |
luFSAPlanOffered |
|
Eligibility Status |
mluEligibilityStatus |
|
Eligibility Type |
mluEligibilityType |
|
Default Rate Group |
DefaultRateGroup |
Offered Benefits Plan Fields Cloned Upon Renewal
|
Field Label |
Field Name |
|---|---|
|
Benefits Batch |
fkBenefitsBatchID |
|
Renewed From |
fkRenewedFromPlanID |
|
Benefit Plan |
fkBenefitPlanID |
|
Effective Date |
EffectiveDate |
|
Expiration Date |
ExpirationDate |
|
Client Plan Code |
ClientPlanCode |
|
Import ID |
ImportID |
|
Rate Group |
fkPlanTierID |
|
EE Premium |
EEPremium |
|
EC Premium |
ECPremium |
|
EF Premium |
EFPremium |
|
EK Premium |
EKPremium |
|
ES Premium |
ESPremium |
|
EC % |
EC |
|
EF % |
EF |
|
EK % |
EK |
|
EO % |
EO |
|
ES % |
ES |
|
Dollar Amount |
EOMaxDollarAmount |
|
Dollar Amount |
ESMaxDollarAmount |
|
Dollar Amount |
ECMaxDollarAmount |
|
Dollar Amount |
EKMaxDollarAmount |
|
Dollar Amount |
EFMaxDollarAmount |
|
HRA Offered? |
HRAOffered |
|
Details |
HRADetails |
|
ES |
HRAEE1 |
|
EC |
HRAEE2 |
|
EO |
HRAEO |
|
Contribution Method |
luContributionMethod |
|
Dependent Contrib % |
DependentContributionPct |
|
Category |
Category |
|
Benefit Group |
eeClassificatiosn |
| One Month Prepay | IsOneMonthPrepay |
| Add One Month for Prepay | IsAddOneMonthforPrepay |
| Annual Periods | luAnnualPeriods |
| Coverage Ends On | luCoverageEndsOn |
| Benefits Billing Frequency | luBenefitsBillingFrequency |
| Payroll Deduction Frequency | luPayrollDeductionFrequency |
| Cafe Eligible | IsCafeEligible |
| Rounding Method | luRoundingMethod |
| Wash Rule | HasWashRule |
| Wash Rule Day | luWashRuleDay |
|
Percent of Base |
PercentofBase |
|
Benefit Amount |
BenefitAmount |
|
LTD Max Coverage |
LTDMaxCoverage |
|
LTD Base Calc |
luLTDBaseCalc |
|
Eligibility Status |
mluEligibilityStatus |
|
Eligibility Type |
mluEligibilityType |
|
Minimum Age |
MinimumAge |
|
Days from Eligibility Status |
DaysfromEligibilityStatus |
|
Eligibility Days From |
luEligibilityDaysFrom |
|
Benefit Eligibility Date Used |
luBenefitEligibilityDateUsed |