The Billing - Employee PEPM Detail report template uses the Employee PEPM Detail Billing topic to display billing details related to per employee per month (PEPM) billing. The report includes details such as billing date, legal entity, funding identifiers, and billing category information. The report displays one record per employee per billing generation date.
Note: Although the PEPM billing report template is available to all customers in Reporting and Analytics > Reporting > Reports, the report returns only data for customers who are participating in the Dayforce Billing Pilot.
The template displays only information related to PEPM billing.
Fields
| Field Name | Group by | Sort Order | Totals |
|---|---|---|---|
| Billing Gen Date | Newest to Oldest | ||
| Employee | Ascending | ||
| Pay Group | |||
| Pay Group ID | |||
| PSID | |||
| Legal Entity | |||
| Funding ID | |||
| Status Group | |||
| Rule A - Paid | |||
| Rule B - Using WFM | |||
| Rule C - Connect Pay HR | |||
| Rule D - Pensioner | |||
| Category | |||
| Category Reference |
Custom Fields
Rule A - Paid
The Rule A - Paid custom field indicates whether the employee was paid in Dayforce in the previous 30 days. It uses the following expression:
Case WHEN (BillingPEPMDetail.RuleA = 'True') THEN 1 ELSE 0 END
Rule B - Using WFM
The Rule B - Using WFM custom field indicates whether the employee used Dayforce WFM features in the previous 30 days. It uses the following expression:
Case WHEN (BillingPEPMDetail.RuleB = 'True') THEN 1 ELSE 0 END
Rule C - Connect Pay HR
The Rule C - Connect Pay HR custom field indicates whether the employee was in a pay group that is configured for use with Connected Pay in the previous 30 days. It uses the following expression:
Case WHEN (BillingPEPMDetail.RuleC = 'True') THEN 1 ELSE 0 END
Rule D - Pensioner
The Rule D - Pensioner custom field indicates whether the employee had an employment type of pensioner in the previous 30 days. It uses the following expression:
Case WHEN (BillingPEPMDetail.RuleD = 'True') THEN 1 ELSE 0 END
Filters
This template includes the following filters:
