WorkAssignmentCustomHistoryCustomGroupTelephoneFields
The view that returns historical data for telephone fields that are defined within work-assignment custom groups. This view captures contact numbers or communication Ids that are linked to historical assignments.
Columns
| Name | Type | References | Description |
| Access | String | The access code or prefix that is used to initiate the telephone call. This field defines the dialing sequence that is required before the main number (for example, 9 for an outside line). | |
| AreaDialing | String | The area dialing code that identifies the regional telephone area. This field is used to route calls correctly within a country or region (for example, 212 for New York or 213 for Los Angeles). | |
| CategoryCodeCodeValue | String | The code value that identifies the category that is associated with this custom-group field. This field classifies the telephone record by business or payroll category (for example, Work Contact, Personal Contact, or Emergency Contact). | |
| CategoryCodeLongName | String | The full descriptive name of the category code value. This field provides the complete label that appears in Human Resources (HR) reports and employee contact records. | |
| CategoryCodeShortName | String | The abbreviated name that corresponds to the category code. This field provides a short label that is used in dashboards, exports, and summaries. | |
| CountryDialing | String | The international country dialing code that is used to identify the country of the telephone number (for example, 1 for the United States or 44 for the United Kingdom). | |
| DialNumber | String | The full telephone number that is dialed after the access, area, and country codes. This field represents the core contact number that is stored in the worker's record. | |
| Extension | String | The internal extension number that routes the call to a specific department or individual within an organization. This field is often used for corporate or departmental phone systems. | |
| FormattedNumber | String | The fully formatted version of the telephone number that includes access, area, country, and extension information. This field presents the number in a readable format for reports and user interfaces. | |
| ItemID | String | The unique identifier (Id) that represents the specific custom-group telephone entry. This Id allows systems to track and manage phone records across a worker's historical assignment data. | |
| NameCodeCodeValue | String | The code value that identifies the name of the custom field that is being tracked within this group. This field defines the purpose or usage context of the telephone number. | |
| NameCodeLongName | String | The full name of the code that describes the custom field name. This field provides a clear, descriptive label for reports, exports, and HR record reviews. | |
| NameCodeShortName | String | The abbreviated name that corresponds to the name code. This field provides a short, recognizable label for quick reference in dashboards and data tables. | |
| AssociateOID | String |
Workers.AssociateOID | The Id that represents the associate to whom this custom-group telephone record belongs. This field links the contact information to the correct worker profile within HR and payroll systems. |