Amount
| Fields | Description |
|---|---|
| Current Amount | Returns the current amount of the earning, deduction, or tax. |
| MTD Amount | Returns the month-to-date amount for the earning, deduction, or tax. |
| QTD Amount | Returns the quarter-to-date amount for the earning, deduction, or tax. |
| YTD Amount | Returns the current amount for the earning, deduction, or tax. |
Check Details
| Fields | Description |
|---|---|
| Check Template | Returns the name of the check template associated with the check from which the deduction was made. Access to this information is controlled by the Check Templates sub-feature of the Payroll Setup role feature. See Check Templates and Check Types. |
| Check Type of Last Payment | Returns the check type associated with the check from which the deduction was made. Access to this information is controlled by the Checks sub-features under the Payroll role feature. |
| Current Gross Wages | Returns the total employee wages before taxes and deductions in the current pay period. |
| Current Net Pay | Returns the employee’s current net pay from which the deductions were made. Net pay is calculated as total pay minus applicable taxes and deductions. |
| MTD Gross Wages | Returns the total employee wages before taxes and deductions for the month to date. |
| MTD Net Pay | Returns the employee’s month-to-date net pay from which the deductions were made. Net pay is calculated as total pay minus applicable taxes and deductions. |
| QTD Gross Wages | Returns the total employee wages before taxes and deductions for the quarter to date. |
| QTD Net Pay | Returns the employee’s quarter-to-date net pay from which the deductions were made. Net pay is calculated as total pay minus applicable taxes and deductions. |
| YTD Gross Wages | Returns the employee’s year-to-date net pay from which the deductions were made. Net pay is calculated as total pay minus applicable taxes and deductions. |
| YTD Net Pay | Returns the employee’s year-to-date net pay from which the deductions were made. Net pay is calculated as total pay minus applicable taxes and deductions. |
Client Information
| Fields | Description |
|---|---|
| Client Name | Returns the name of the employer organization, which is configured in Site Setup > Client. Access to this information is controlled by the Client sub-feature of the Site Setup role feature. |
| DTS Tax ID |
(US only) |
| FEIN/BN | Returns the legal entity’s business number, which is configured in Org Setup > Org Payroll Setup > Legal Entity. Access to this information is controlled by the Legal Entity sub-feature of the Org Setup > Org Payroll Setup role feature. See Configure Legal Entities in the Dayforce Implementation Guide. |
| Legal Entity Name | Returns the name of the legal entity to which the employee’s pay is associated, which is configured in Org Setup > Org Payroll Setup > Legal Entity. Access to this information is controlled by the Legal Entity sub-feature of the Org Setup > Org Payroll Setup role feature. See Configure Legal Entities in the Dayforce Implementation Guide. |
| Payroll Service Identifier | Returns the legal entity's payroll service identifier. For customers using HPL/ HPW or HPL Canada, this is recorded in the Payroll Properties tab of Pay Setup > Pay Group. See Configure Pay Group Payroll Properties in the Dayforce Implementation Guide. |
Deductions
| Fields | Description |
|---|---|
| Current Total Deductions |
Returns the current total employee deductions, which are defined in Payroll Setup > Earnings and Deductions. Access to this information is controlled by the Deductions sub-feature of the Payroll Setup > Earnings and Deductions role feature. |
| Deduction Name | Returns the name of the deduction, which is configured in Payroll Setup > Earnings and Deductions. Access to this information is controlled by the Deductions sub-feature of the Payroll Setup > Earnings and Deductions role feature. |
| Employer Deduction |
Returns a 'True' value if the deduction is an employer deduction. |
| MTD Total Deductions | Returns the total month-to-date employee deductions, which are defined in Payroll Setup > Earnings and Deductions. Access to this information is controlled by the Deductions sub-feature of the Payroll Setup > Earnings and Deductions role feature. |
| Pre Tax | Returns a 'True' value if the deduction is a pre-tax deduction. |
| QTD Total Deductions | Returns the total quarter-to-date employee deductions, which are defined in Payroll Setup > Earnings and Deductions. Access to this information is controlled by the Deductions sub-feature of the Payroll Setup > Earnings and Deductions role feature. |
| YTD Total Deductions | Returns the total year-to-date employee deductions, which are defined in Payroll Setup > Earnings and Deductions. Access to this information is controlled by the Deductions sub-feature of the Payroll Setup > Earnings and Deductions role feature. |
See Deductions and the Deductions Tab in the Dayforce Implementation Guide.
Earnings
| Fields | Description |
|---|---|
| Contribute To Net Pay | Returns either a 'True' or 'False' value, depending on whether the earning contributes to the employee's net pay. This information is determined by the earning type configured in the Earnings tab of Payroll Setup > Earnings and Deductions in the Details sub-tab for a specific earning, and the parameter is controlled by the Earnings sub-feature of the Payroll Setup > Earnings and Deductions role feature. |
| Current Total Earnings | Returns the current total employee earnings, as defined in Payroll Setup > Earnings and Deductions. Access to this information is controlled by the Earnings sub-feature of the Payroll Setup > Earnings and Deductions role feature. |
| Current Units | Returns the employee's current hours or units of work. |
| Earning Name | Returns the name of the earning, which is configured in Payroll Setup > Earnings and Deductions. Access to this information is controlled by the Earnings sub-feature of the Payroll Setup > Earnings and Deductions role feature. |
| Earning Type | Returns the type of the earning, which is configured in the Details tab in Payroll Setup > Earnings and Deductions. The parameter is controlled by the Earnings sub-feature of the Payroll Setup > Earnings and Deductions role feature. |
| MTD Total Earnings | Returns the month-to-date total employee earnings, which are defined in Payroll Setup > Earnings and Deductions. Access to this information is controlled by the Earnings sub-feature of the Payroll Setup > Earnings and Deductions role feature. |
| MTD Units | Returns the employee's month-to-date hours or units of work. |
| QTD Total Earnings | Returns the total quarter-to-date employee earnings, which are defined in Payroll Setup > Earnings and Deductions. Access to this information is controlled by the Earnings sub-feature of the Payroll Setup > Earnings and Deductions role feature. |
| QTD Units | Returns the employee's quarter-to-date hours or units of work. |
| YTD Total Earnings | Returns the total year-to-date employee earnings, which are defined in Payroll Setup > Earnings and Deductions. Access to this information is controlled by the Earnings sub-feature of the Payroll Setup > Earnings and Deductions role feature. |
| YTD Units | Returns the employee's current hours or units of work. |
See Earnings and the Earnings Tab in the Dayforce Implementation Guide.
Employee
| Fields | Description |
|---|---|
| Display Name |
Returns the employee's full name in the Personal > Contact Information screen of People. |
| Employee Culture |
Returns the employee’s preferred language culture in User Properties section of the Security Settings screen in People. |
| First Name |
Returns the employee's first name in the Personal > Contact Information screen of People. |
| Last Name |
Returns the employee's last name in the Personal > Contact Information screen of People. |
| Number | Returns the employee number in the Employment Status tab of the Employment > Employment Settings screen in People. |
| SIN Expiry Date |
Returns the expiry date of the employee’s Social Insurance Number in the Personal > Confidential Information screen of People. |
| SIN/SSN |
Returns the employee’s social security or Social Insurance Number in the Personal > Confidential Information screen of People. |
Employee Contact Information
| Fields | Description |
|---|---|
| Address |
Returns the employee's street address in the Personal > Contact Information screen of People. |
| Address 2 |
Returns the second line of the employee's street address in the Personal > Contact Information screen of People. |
| Country |
Returns the country listed in the employee's address in the Personal > Contact Information screen of People. |
| Employee City |
Returns the city listed in the employee's address in the Personal > Contact Information screen of People. |
| Postal / Zip Code |
Returns the postal or ZIP Code listed in the employee's address in the Personal > Contact Information screen of People. |
| Province / State |
Returns the province or state listed in the employee's address in the Personal > Contact Information screen of People. |
Employee Employment Status
| Fields | Description |
|---|---|
| Base Salary |
Returns the employee’s base salary amount in the Employment Status tab of the Employment > Employment Settings screen in People. |
| Hire Date |
Returns the date on which the employee was hired or onboarded. This is recorded in the Key Information tab of the Employment > Employment Settings screen in People. |
| Pay Group |
Returns the name of the pay group to which the deduction applies, which is configured in the Pay Groups tab in Payroll Setup > Earnings and Deductions. Access to this information is controlled by the Deductions sub-feature of the Payroll Setup > Earnings and Deductions role feature. See Deductions and The Deductions Tab in the Dayforce Implementation Guide. |
| Pay Rate |
Returns the employee’s pay rate in the Employment Status tab of the Employment > Employment Settings screen in People. |
| Status Group |
Returns the status group of the employee's status in the Employment Status tab of the Employment > Employment Settings screen in People. |
Employee Work Assignment
| Fields | Description |
|---|---|
| Department |
Returns the name of the department in which the employee works, which is recorded in the Work > Work Assignments screen of People. |
| Employee Work State Code |
Returns the employee’s work state or province code. This information is found in Org Setup > Organization by selecting a work location in the Organization tab and then expanding the slide-out panel and viewing the Address tab. Access to this information is controlled by the Organization subfeature of the Org Setup role feature. |
| Job |
Returns the employee’s job assignment title in the Work > Work Assignments screen of People. |
Pay Run Detail
| Fields | Description |
|---|---|
| Pay Frequency | Returns the frequency of the pay, which is configured in Pay Setup > Pay Group. Access to this information is controlled by the Pay Setup role feature. |
| Transaction Name | Returns the name of the earning, deduction, or tax. |
| Transaction Type | Returns the type of pay entry (Earning, Deduction, or Tax). |
Pay Type
| Fields | Description |
|---|---|
| Pay Type Group |
Returns the pay type group of the employee's pay type in the Employment Status tab of the Employment > Employment Settings screen in People. |
Taxes
| Fields | Description |
|---|---|
| Applied 2020 W4 Calc | Indicates if the 2020 version of the W4 form was submitted in the pay run for the employee. |
| Current Additional Amount |
Returns any current additional tax amounts that the employee has opted to have deducted toward their year end taxes, which is configured in the Payroll > Tax Definitions screen of People. See Employee Tax Information. |
| Current Reportable Wages | Returns the employee's reportable wages in the current pay period. |
| Current Subject Wages | Returns the current amount of employee wages that are assessed by the relevant tax authority as subject to taxation before any taxation limits are applied. |
| Current Taxable Wage to Limit | Returns the current amount of employee wages that are assessed by the relevant tax authority as subject to taxation, up to any taxation limits that are applied. |
| Current Total Employee Taxes |
Returns the current total employee taxes, which are defined in Payroll Setup > Payroll Taxes. Access to this information is controlled by the Payroll Taxes subfeature of the Payroll Setup role feature. See Employee Tax Information. |
| Current Total Employer Taxes |
Returns the current total employer taxes, which are system-configured and can be viewed in Payroll Setup > Payroll Taxes. Access to this information is controlled by the Payroll Taxes subfeature of the Payroll Setup role feature. See Employee Tax Information. |
| Current Total Insured Earnings |
Returns the employee’s current total insured earnings. Access to this information is controlled by the Payroll Policies subfeature of the Payroll Setup role feature. |
| Current Total Taxable Wages | Returns the current amount of employee wages that are assessed by the relevant tax authority as subject to taxation after taxation limits are applied. |
| Employer Tax | Returns a 'True' value if the tax is an employer tax. |
| Federal Additional Amount of Last Payment |
Returns any additional federal tax that the employee has opted to have deducted toward their year end taxes. This is configured in the Federal Tax Info section of the Payroll > Tax Definitions screen in People. See Employee Tax Information. |
| Federal Exemptions |
Returns the number of employee dependents that count toward federal exemption. Dependent records are configured in the Benefits > Dependents and Beneficiaries screen of People. If your organization doesn't use the Benefits module, this can be done in the Personal > Dependents and Beneficiaries screen of People instead. Access to this information is controlled by the People > Employee Profile > Benefits > Dependents and Beneficiaries sub-feature of the Application Container role feature. This sub-feature can also be found under Application Container > People > Employee Profile > Personal. See Employee Tax Information. |
| Local Exemptions |
Returns the number of employee dependents that count toward local exemption. Dependent records are configured in the Benefits > Dependents and Beneficiaries screen of People. If your organization doesn't use the Benefits module, this can be done in the Personal > Dependents and Beneficiaries screen of People instead. Access to this information is controlled by the People > Employee Profile > Benefits > Dependents and Beneficiaries sub-feature of the Application Container role feature. This sub-feature can also be found under Application Container > People > Employee Profile > Personal. See Employee Tax Information. |
| Marital Status (Federal) |
Returns the employee’s marital status for federal tax filing. This is recorded in the Personal > Confidential Information screen of People. See Employee Tax Information. |
| Marital Status (State) |
Returns the employee’s marital status for state tax filing. This is recorded the Personal > Confidential Information screen of People. See Employee Tax Information. |
| MTD Additional Amount | Returns any month-to-date additional tax amounts that the employee has opted to have deducted toward their year end taxes, which is configured in the Payroll > Tax Definitions screen of People. See Employee Tax Information. |
| MTD Reportable Wages | Returns the employee's month to date reportable wages. |
| MTD Subject Wages | Returns the month-to-date amount of employee wages that are assessed by the relevant tax authority as subject to taxation before any taxation limits are applied. |
| MTD Taxable Wage to Limit | Returns the month-to-date amount of employee wages that are assessed by the relevant tax authority as subject to taxation after taxation limits are applied. |
| MTD Total Employee Taxes |
Returns the total month-to-date employee taxes, which are defined in Payroll Setup > Payroll Taxes. Access to this information is controlled by the Payroll Taxes sub-feature of the Payroll Setup role feature. See Employee Tax Information. |
| MTD Total Employer Taxes |
Returns the total month-to-date employer taxes for the deduction, which are system-configured and can be viewed in Payroll Setup > Payroll Taxes. Access to this information is controlled by the Payroll Taxes sub-feature of the Payroll Setup role feature. See Employee Tax Information. |
| MTD Total Insured Earnings |
Returns the employee’s total month-to-date insured earnings from which deductions were made. Access to this information is controlled by the Payroll Policies sub-feature of the Payroll Setup role feature. |
| MTD Total Taxable Wages | Returns the month-to-date amount of employee wages that are assessed by the relevant tax authority as subject to taxation after taxation limits are applied. |
| QTD Additional Amount | Returns any quarter-to-date additional tax amounts that the employee has opted to have deducted toward their year end taxes, which is configured in the Payroll > Tax Definitions screen of People. See Employee Tax Information. |
| QTD Reportable Wages | Returns the employee's quarter to date reportable wages. |
| QTD Subject Wages | Returns the quarter-to-date amount of employee wages that are assessed by the relevant tax authority as subject to taxation before any taxation limits are applied. |
| QTD Taxable Wage to Limit | Returns the quarter-to-date amount of employee wages that are assessed by the relevant tax authority as subject to taxation, up to any taxation limits that are applied. |
| QTD Total Employee Taxes |
Returns the total quarter-to-date employee taxes, which are defined in Payroll Setup > Payroll Taxes. Access to this information is controlled by the Payroll Taxes sub-feature of the Payroll Setup role feature. See Employee Tax Information. |
| QTD Total Employer Taxes |
Returns the total quarter-to-date employer taxes for the deduction, which are system-configured and can be viewed in Payroll Setup > Payroll Taxes. Access to this information is controlled by the Payroll Taxes sub-feature of the Payroll Setup role feature. See Employee Tax Information. |
| QTD Total Insured Earnings |
Returns the employee’s total quarter-to-date insured earnings from which deductions were made. Access to this information is controlled by the Payroll Policies sub-feature of the Payroll Setup role feature. |
| QTD Total Taxable Wages | Returns the quarter-to-date amount of employee wages that are assessed by the relevant tax authority as subject to taxation after taxation limits are applied. |
| State Additional Amount |
Returns any additional state or provincial tax that the employee has opted to have deducted toward their year end taxes, which is configured in the State Tax Info or Provincial Tax Info section of the Payroll > Tax Definitions screen in People. See Employee Tax Information. |
| State Exemptions |
Returns the number of employee dependents that count toward state exemption. Dependent records are configured in the Benefits > Dependents and Beneficiaries screen of People. If your organization doesn't use the Benefits module, this can be done in the Personal > Dependents and Beneficiaries screen of People instead. Access to this information is controlled by the People > Employee Profile > Benefits > Dependents and Beneficiaries sub-feature of the Application Container role feature. This sub-feature can also be found under Application Container > People > Employee Profile > Personal. See Employee Tax Information. |
| Tax Exempt | Returns a 'True' value if the earning is tax exempt. |
| Tax Name | Returns the name of the applicable tax, which is system-configured. This information is found in Payroll Setup > Payroll Taxes. Access to this information is controlled by the Payroll Tax sub-feature of the Payroll Setup role feature. See Employee Tax Information. |
| W4 Deductions | Returns the amount in box 4(b) in the employee's W4 form. |
| W4 Dependent Tax Credit | Returns the amount in box 3 in the employee's W4 form. |
| W4 Other Income | Returns the amount in box 4(a) in the employee's W4 form. |
| W4 Two Jobs | Returns the employee's response to Step 2 in the W4 form. |
| YTD Additional Amount | Returns any year-to-date additional tax amounts that the employee has opted to have deducted toward their year end taxes, which is configured in the Payroll > Tax Definitions screen of People. See Employee Tax Information. |
| YTD Reportable Wages |
Returns the employee's year to date reportable wages. |
| YTD Subject Wages | Returns the year-to-date amount of employee wages that are assessed by the relevant tax authority as subject to taxation before any taxation limits are applied. Returns the quarter-to-date amount of employee wages that are assessed by the relevant tax authority as subject to taxation, up to any taxation limits that are applied. |
| YTD Taxable Wage to Limit | Returns the year-to-date amount of employee wages that are assessed by the relevant tax authority as subject to taxation, up to any taxation limits that are applied. Returns the quarter-to-date amount of employee wages that are assessed by the relevant tax authority as subject to taxation, up to any taxation limits that are applied. |
| YTD Total Employee Taxes |
Returns the total year-to-date employee taxes, which are defined in Payroll Setup > Payroll Taxes. Access to this information is controlled by the Payroll Taxes sub-feature of the Payroll Setup role feature. See Employee Tax Information. |
| YTD Total Employer Taxes |
Returns the total year-to-date employer taxes for the deduction, which are system-configured and can be viewed in Payroll Setup > Payroll Taxes. Access to this information is controlled by the Payroll Taxes sub-feature of the Payroll Setup role feature. See Employee Tax Information. |
| YTD Total Insured Earnings |
Returns the employee’s total year-to-date insured earnings from which deductions were made. Access to this information is controlled by the Payroll Policies sub-feature of the Payroll Setup role feature. |
| YTD Total Taxable Wages | Returns the year-to-date amount of employee wages that are assessed by the relevant tax authority as subject to taxation after taxation limits are applied. Returns the quarter-to-date amount of employee wages that are assessed by the relevant tax authority as subject to taxation, up to any taxation limits that are applied. |