EmployeeEnrollment
Retrieves employee benefit plan enrollment records for the BenefitsAdministration schema.
View-Specific Information
The EmployeeEnrollment view provides read-only access to JD Edwards employee benefits enrollment records from the BenefitsAdministration schema. This view does not support insert, update, or delete operations.
Select
The connector uses the JD Edwards API to process WHERE clause conditions for all columns in this table. All columns support server-side filtering via the JD Edwards QBE (Query By Example) mechanism.
The supported operators depend on the column data type:
- Text columns (PlanID, EnrSts, EndSts, AddOpt, UserID, ProgramID, WorkStnID): support =, !=, LIKE, and IN.
- Numeric columns (AddressNumber, Factor, SequenceNumber): support =, !=, <, <=, >, >=, and IN.
- Date columns (EffectiveDate, EndingDate, DateEligible, ParticipationDate, ...): support =, !=, <, <=, >, >=, and IN. Two conditions on the same date column can be combined to express a range.
For example, the following query is processed server-side:
SELECT * FROM EmployeeEnrollment WHERE AddressNumber = 1001 AND EffectiveDate >= '2024-01-01' AND PlanID = 'MEDICAL'
Columns
| Name | Type | Description |
| AddressNumber | Decimal | Address Number |
| PlanID | String | Plan ID |
| EffectiveDate | Date | Effective Date |
| EndingDate | Date | Ending Date |
| EnrSts | String | Enr Sts |
| EndSts | String | End Sts |
| DateEligible | Date | Date Eligible |
| ParticipationDate | Date | Participation Date |
| UserDefDate | Date | User Def Date |
| AddOpt | String | Add Opt |
| Factor | Decimal | Factor |
| DBABegins | Date | DBA Begins |
| DBAEnds | Date | DBA Ends |
| SequenceNumber | Decimal | Sequence Number |
| UserID | String | User ID |
| ProgramID | String | Program ID |
| WorkStnID | String | Work Stn ID |
| DateUpdated | Date | Date Updated |