Check Detail
| Fields | Description |
|---|---|
| Branch Address Name | Returns the name of the bank branch from which the check was issued, which is configured in the Branches tab of Payroll Setup > Bank Accounts. Access to this information is controlled by the Bank Accounts sub-feature of the Payroll Setup role feature. |
| Check Number | Returns the check number associated with the payment if it was an on site check. |
| Check Template | Returns the name of the check template associated with the check. See Check Templates and Check Types. |
| Check Type | Returns the check type associated with the check. |
| Gross Wages | Returns the total employee wages before taxes and deductions. |
| Net Pay | Returns the employee’s net pay from which the deduction was 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. |
| Legal Number | Returns the legal entity’s business ID 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. |
| 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 |
|---|---|
| Total Deductions | Returns the total employee deductions for the pay run, 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. |
Earnings
| Fields | Description |
|---|---|
| Total Earnings | Returns the total employee earnings for the pay run, 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. |
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 |
|---|---|
| Comments | Returns the number of employees processed if the pay run has been calculated, which can also be seen when loading pay runs in Payroll. |
| Commit Lock Phase | Returns the pay run’s current commit lock phase in Payroll. |
| Disbursement Commit Stage | Returns the state of the disbursements committal stage in Payroll. |
| Disbursement Commit State | Returns the state of the pay run’s committal stage in Payroll. |
| Off Cycle Pay Run Name | Returns the name of the off cycle pay run, which is configured in Payroll. |
| Pay Date | Returns the date on which the pay run is paid, which is determined in the Pay Calendars tab in Pay Setup > Pay Group. Access to this information is controlled by Pay Group sub-feature of the Pay Setup role feature. |
| 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. |
| Pay Period | Returns the pay period number, which is configured in the Pay Calendars tab in Pay Setup > Pay Group. Access to this information is controlled by the Pay Setup role feature. |
| Pay Run GUID | Returns the pay run's unique identifier code, which is configured by the application and used internally to identify various drafts of a pay run. |
| Payroll Committed | Returns either a ‘True’ or ‘False’ value, depending on whether the pay run has been committed by a payroll administrator in Payroll. |
| Payroll Committed Date | Returns the date on which the pay run was committed by a payroll administrator in Payroll. |
| Payroll Committed User | Returns the name of the payroll administrator who committed the pay run in Payroll. |
| Payroll Lock Last Action Date | Returns the date on which the last action was made on the pay run before being locked by a payroll administrator in Payroll. |
| Payroll Lock User | Returns the name of the user who locked the pay run in Payroll. |
| Payroll Locked | Returns either a ‘True’ or ‘False’ value, depending on whether the pay run has been locked by a payroll administrator in Payroll. |
| Period End | Returns the pay period’s effective end date, which is found in the Pay Calendars tab in Pay Setup > Pay Group. Access to this information is controlled by the Pay Setup role feature. |
| Period Start | Returns the pay period’s effective start date, which is found in the Pay Calendars tab in Pay Setup > Pay Group. Access to this information is controlled by the Pay Setup role feature. |
| Reports Commit State | Returns the state of the pay run’s reports in Payroll. |
| Sequence Number | Returns the sequence number associated with the tax and wage combination, which is assigned by the Canadian Trust Department. |
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 |
|---|---|
| Additional Amount |
Returns any additional tax amounts that the employee has opted to have deducted toward their year end taxes. |
| Amount | Returns the tax amount, which is system-configured. This information is found in Payroll Setup > Payroll Taxes. Access to this information is controlled by the Payroll Taxes sub-feature of the Payroll Setup role feature. |
| Applied 2020 W4 Calc | Indicates if the 2020 version of the W4 form was submitted in the pay run for the employee. |
| Client Responsible | Returns either a ‘True’ or ‘False’ value, depending on whether the tax is supported by Dayforce Tax Service, or if the client is responsible for remitting the balance. This information is system-configured; to review the taxes applied to a specific legal entity, see Columns in the Tax Authorities Tab by Country in the Dayforce Implementation Guide. |
| Current Taxable Wage to Limit | Returns the employees' wages for the loaded pay run that are available to be taxed, based on the associated tax authority’s assessment. Access to this information is controlled by the Payroll Taxes sub-feature of the Payroll Setup role feature. |
| EI Rate | (Canada only) |
| EI Reference Code | (Canada only) |
| Employer Tax | Returns either a ‘True’ or ‘False’ value, depending on whether the tax is an employer tax. This information is system-configured, and can be found in Payroll Setup > Payroll Taxes. Access to this information is controlled by the Payroll Taxes sub-feature of the Payroll Setup role feature. See Payroll Setup > Payroll Taxes in the Dayforce Implementation Guide. |
| Exemptions | Returns the number of exemptions applied to the tax. |
| Federal Additional Amount |
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. |
| Marital Status Filing Code |
Returns the employee’s marital status. This is recorded the Personal > Confidential Information screen of People. See Employee Tax Information. |
| MTD Taxable Wage to Limit | Returns the employee’s month to date wages for the loaded pay run that are available to be taxed, based on the associated tax authority’s assessment. Access to this information is controlled by the Payroll Taxes sub-feature of the Payroll Setup role feature. |
| Payment Type | Returns the payment type. |
| QTD Taxable Wage to Limit | Returns the employee’s quarter to date wages for the loaded pay run that are available to be taxed, based on the associated tax authority’s assessment. Access to this information is controlled by the Payroll Taxes sub-feature of the Payroll Setup role feature. |
| Quebec Health Contributions Exemption |
Returns the employee’s quarter to date wages for the loaded pay run that are available to be taxed, based on the assessment of the associated tax authority. Access to this information is controlled by the Payroll Taxes sub-feature of the Payroll Setup role feature. |
| Reportable Wages | Returns the employee's total reportable wages for the tax. |
| 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. |
| Subject Wages | Returns the amount of employee wages that are assessed by the relevant tax authority as subject to taxation before any taxation limits are applied. |
| 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 Taxes sub-feature of the Payroll Setup role feature. |
| Tax Rate Used | Returns the tax rate used. |
| Total Employee Taxes | Returns the total employee taxes for the check to which the taxes apply, 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. |
| Total Employer Taxes | Returns the total employer taxes for the pay run, which are configured in Payroll Setup > Payroll Taxes. Access to this information is controlled by the Payroll Taxes sub-feature of the Payroll Setup role feature. See Payroll Setup > Payroll Taxes in the Dayforce Implementation Guide. |
| Total Insured Earnings | Returns the employee’s total insured earnings for the pay run, which are configured in Payroll Setup > Payroll Policies. Access to this information is controlled by the Payroll Policies sub-feature of the Payroll Setup role feature. |
| Total Taxable Wages | Returns the amount of employee wages that are assessed by the relevant tax authority as subject to taxation after taxation limits are applied. |
| 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 Taxable Wage to Limit | Returns the employee’s year to date wages for the loaded pay run that are available to be taxed, based on the associated tax authority’s assessment. Access to this information is controlled by the Payroll Taxes sub-feature of the Payroll Setup role feature. |