allWorkers
Accesses the Worker as its primary object and returns one row per worker. Includes all workers even workers to be hired in the future. Does not contain any built-in prompts. This data source can be used to build reports on all workers. Helpful Tips - 1) If the worker is hired in the future, all fields will be returned based on the effective date. 2) If no effective date is specified, the system will use the current date as the effective date. 3) If the effective date is less than the worker's hire date, no effective dated information (such as position information, compensation information and so on) will be returned. 4) If effective dated behavior is desired, use the "All Active and Terminated workers" data source instead.
Columns
| Name | Type | References | Description |
| cf_ContractPayRateAnnualized_value | Decimal | Annualized pay rate for contract workers, expressed as a numerical value. | |
| cf_ContractPayRateAnnualized_currency | String | Currency in which the contract pay rate annualized value is measured. | |
| cf_NumberOfTerminations | Int | Total number of terminations recorded for the worker. | |
| cf_DisciplinaryActions_Completed | String | List of completed disciplinary actions for the worker. | |
| cf_RetirementEligibility_id | String | Unique identifier for the worker's retirement eligibility classification. | |
| cf_RetirementEligibility_descriptor | String | Descriptive label for the worker's retirement eligibility classification. | |
| cf_LocationSiteHierarchyLevel2_id | String | Unique identifier for the Level 2 location site hierarchy. | |
| cf_LocationSiteHierarchyLevel2_descriptor | String | Descriptive label for the Level 2 location site hierarchy. | |
| cf_TotalBasePayAnnualizedInCAD_Amount_value | Decimal | Total base pay annualized in CAD, expressed as a numerical value. | |
| cf_TotalBasePayAnnualizedInCAD_Amount_currency | String | Currency in which the total base pay annualized in CAD is measured. | |
| cf_TotalBasePayHourly_Amount_value | Decimal | Total base pay on an hourly basis, expressed as a numerical value. | |
| cf_TotalBasePayHourly_Amount_currency | String | Currency in which the total base pay hourly amount is measured. | |
| cf_PrimaryAddressHomeStateText | String | Text representation of the worker's primary home state address. | |
| cf_NumberOfHires | Int | Total number of hires associated with this worker record. | |
| cf_SpendAuthorizationsNotInUseByActiveExpenseReports | String | List of spend authorizations that are not in use by active expense reports. | |
| cf_FormatPercentOfExpenseReportsWithWarningValidations | String | Formatted percentage of expense reports that include warning validations. | |
| cf_LegalName_LastNameUppercase | String | Worker's legal last name formatted in uppercase. | |
| cf_Apparel | String | Apparel-related details associated with the worker. | |
| cf_TopLevelSupervisoryOrganizationGMS_id | String | Unique identifier for the worker's top-level supervisory organization in the GMS. | |
| cf_TopLevelSupervisoryOrganizationGMS_descriptor | String | Descriptive label for the worker's top-level supervisory organization in the GMS. | |
| cf_HireDate90Days | Date | Hire date plus 90 days. | |
| cf_TotalBasePayAnnualizedInEUR_Amount_value | Decimal | Total base pay annualized in EUR, expressed as a numerical value. | |
| cf_TotalBasePayAnnualizedInEUR_Amount_currency | String | Currency in which the total base pay annualized in EUR is measured. | |
| cf_TotalBasePayMonthly_Amount_value | Decimal | Total base pay on a monthly basis, expressed as a numerical value. | |
| cf_TotalBasePayMonthly_Amount_currency | String | Currency in which the total base pay monthly amount is measured. | |
| cf_PerformanceImprovementPlans_InProgressOrCompleted | String | List of performance improvement plans that are either in progress or completed. | |
| cf_ExternalPayrollActualHoursWorkedInLast12Months | Int | Total actual hours worked in external payroll during the last 12 months. | |
| cf_PreferredName_LastNameUppercase | String | Worker's preferred last name formatted in uppercase. | |
| effectiveAsOfDate | Date | A pseudo-column used to filter data based on the effective date of the worker record. | |
| effectiveAsOfMoment | Datetime | A pseudo-column used to filter data based on the exact timestamp of the worker record's effectiveness. | |
| entryDate | Date | A pseudo-column used to filter data based on the date the worker record entry was recorded. | |
| entryMoment | Datetime | A pseudo-column used to filter data based on the exact timestamp of when the worker record entry was recorded. |