EEEnroll
| EmpUID | Employee Unique ID | BigID | 12 | ||||||||||||
| PlanID | Plan Identifier | BigID | 12 | ||||||||||||
| CompanyID | Company Identifier | SmallID | 12 | ||||||||||||
| HistSeqNbr | History Sequence Number | Long | 12 | ||||||||||||
| EligStart | Eligibility Start Date | Date | 32 | ||||||||||||
| EligReason | Eligibility Reason Text | Text | 16000 | ||||||||||||
| EventDate | Event Date | Date | 32 | ||||||||||||
| GenCodeID | Generic Code Identifier | BigID | 12 | ||||||||||||
| EnrollStat | Enrollment Status | Enum | 1 |
|
|||||||||||
| StartDate | Starting Date | SmallDate | 32 | ||||||||||||
| StopDate | Ending Date | Date | 32 | ||||||||||||
| TermDate | Termination Date | Date | 32 | ||||||||||||
| WaiveDate | Waive Benefit Date | Date | 32 | ||||||||||||
| WaiveFlag | Waive Benefit Flag | Varchar | 1 | ||||||||||||
| EffectDate | Enrollment Effective Date | Date | 32 | ||||||||||||
| DependTags | Dependent Enrollment Tags | Varchar | 20 | ||||||||||||
| EnrlCounts | Enrollment Counts String | Varchar | 30 | ||||||||||||
| SmokerRate | Smoker Rate | Varchar | 1 | ||||||||||||
| BiCycleDt | Billing Cycle End Date | Date | 32 | ||||||||||||
| ContbCmpny | Company Contribution Amount | Number | 22 | ||||||||||||
| ContbEmply | Employee Contribution Amount | Number | 22 | ||||||||||||
| EEOnlyEEC | EE Only - Emply Contribution | Number | 22 | ||||||||||||
| EEOnlyERC | EE Only - Emplr Contribution | Number | 22 | ||||||||||||
| CostReason | Benefit Cost Reason Text | Text | 16000 | ||||||||||||
| EnrOverFlg | Enrolled as Over Age Child | Varchar | 1 | ||||||||||||
| RateCategy | Rate Category | Long | 12 | ||||||||||||
| RateSched | Rate Schedule | Varchar | 1 | ||||||||||||
| AmtPctFlg | Amount/Percentage Flag | Enum | 1 |
|
|||||||||||
| PayPeriod | Pay Period | Enum | 1 |
|
|||||||||||
| ContbPayck | Contribution Per Paycheck | Number | 22 | ||||||||||||
| Period | Period | Long | 12 | ||||||||||||
| VolumeAmt1 | Volume Amount | Number | 22 | ||||||||||||
| VolumeAmt2 | Volume Amount | Number | 22 | ||||||||||||
| PerAmt1 | Volume Per Amount | Number | 22 | ||||||||||||
| PerAmt2 | Volume Per Amount | Number | 22 | ||||||||||||
| PctOfPay1 | Percentage of Pay | Number | 22 | ||||||||||||
| PctOfPay2 | Percentage of Pay | Number | 22 | ||||||||||||
| VolMpy | Volume Muliplier | Number | 22 | ||||||||||||
| VolReason | Volume Amounts Reason Text | Text | 16000 | ||||||||||||
| Coverage | Coverage Literal | Varchar | 20 | ||||||||||||
| ProofOfGH | Proff of Good Health Flag | Date | 32 | ||||||||||||
| AmtApprovd | Amount Approved | Number | 22 | ||||||||||||
| PreTaxOptn | Pre Tax Option | Enum | 1 |
|
|||||||||||
| AdminFee | Admin Fee | Number | 22 | ||||||||||||
| PlanFeeFrq | Plan Wide Fee Frequency | Enum | 1 |
|
|||||||||||
| CobraCEAmt | Cobra Covered Employee Amt | Number | 22 | ||||||||||||
| CobraFreq | Cobra Fees Frequency | Enum | 1 |
|
|||||||||||
| CobraNote | Cobra Notice Types | Varchar | 8 | ||||||||||||
| HardshipAc | Hardship Withdrawl Active | Varchar | 1 | ||||||||||||
| LoanActive | Loan Active Flag | Varchar | 1 | ||||||||||||
| BuyUpSalAmt | Buy Up Salary Amount | Number | 22 | ||||||||||||
| CstF1 | Benefit Custom Fld 1 | Varchar | 40 | ||||||||||||
| CstF2 | Benefit Custom Fld 2 | Varchar | 40 | ||||||||||||
| CstF3 | Benefit Custom Fld 3 | Varchar | 40 | ||||||||||||
| CstF4 | Benefit Custom Fld 4 | Varchar | 40 | ||||||||||||
| CstF5 | Benefit Custom Fld 5 | Varchar | 40 | ||||||||||||
| CstF6 | Benefit Custom Fld 6 | Varchar | 40 | ||||||||||||
| VolOverride | Y/N | Varchar | 1 | ||||||||||||
| HpChgTS | Timestamp | 32 | |||||||||||||
| LstModBy | Last Modified By Name | Varchar | 40 | ||||||||||||
| LstModDate | Last Modified Date | Date | 32 | ||||||||||||
| LockSeqNbr | *SYSTEM* Row Sequence Nbr | Long | 12 |