WorkersWorkAssignments

The table that stores comprehensive information about worker assignments. This table includes assignment Ids, job roles, departments, and reporting relationships. This table forms the foundation for payroll, scheduling, and Human Resources (HR) analytics.

Table Specific Information

Select

The cmdlet uses the ADP API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the cmdlet.

AssociateOID supports the '=' comparison.
WorkerIdValue supports the '=' comparison.
AsOfDate supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM WorkersWorkAssignments WHERE AssociateOID = 'G3349PZGBADQY8H7'

SELECT * FROM WorkersWorkAssignments WHERE WorkerIdValue = 'DRH9M9NPW'

SELECT * FROM WorkersWorkAssignments WHERE AsOfDate = '2020-01-01'

Update

Following is an example of how to Update BaseRemuneration:

UPDATE WorkersWorkAssignments SET StandardHoursQuantity = '45', BaseRemunerationEffectiveDate = '2020-12-21', PayCycleCodeValue = '4', BaseRemunerationHourlyRateAmountValue = 300, WageLawCoverageCodeValue = 'N', BaseRemunerationCode = 'ADJ', ItemId = '34321368N' WHERE AssociateOID = 'G3GMC21PJFZT7K4F'

Following is an example of how to Update AdditionalRemuneration using aggregates:

UPDATE WorkersWorkAssignments SET AdditionalRemunerations = '[{"remunerationTypeCode":{"code":"AE","name":"additional earnings"},"remunerationRate":{"rate":70,"currencyCode":"USD"},"effectiveDate":"2020-12-20","nameCode":{"code":"1FA"},"inactiveIndicator":false}]', itemid = '35777493N' WHERE AssociateOID = 'G3TGG0M57JZEXCP1'

Following is an example of how to Update AdditionalRemuneration using Temp Table:

INSERT INTO Input_AdditionalRemunerations#TEMP (RemunerationTypeCode, RemunerationRate, RemunerationCurrencyCode, effectiveDate, NameCode, InactiveIndicator) VALUES ('AE', '70', 'USD', '2021-01-04', 'R', false)

UPDATE WorkersWorkAssignments SET AdditionalRemunerations = 'Input_AdditionalRemunerations#TEMP', itemid = '35777493N' WHERE AssociateOID = 'G3TGG0M57JZEXCP1'

Following is an example of how to Update Worker Assignment Termination:

UPDATE WorkersWorkAssignments SET TerminationDate = '2020-01-31', LastWorkedDate = '2020-01-31', AssignmentStatusReasonCodeValue = 'A00', RehireEligibleIndicator = true, SeveranceEligibleIndicator = true, TerminationComments = 'Looking for better growth and oppurtunities', itemid = '00691088N' WHERE AssociateOID = 'G3TGG0M57JZECKRB'

Following is an example of how to Update Worker Type:

UPDATE WorkersWorkAssignments SET WorkerTypeCodeValue = 'F', ItemId = '31095304_1668', EventReasonCode = 'ADL', EffectiveDate = '2021-01-01' WHERE AssociateOID = 'G3Q8G47NKHBV1SMT'

Columns


Name	Type	ReadOnly	References	Description
AssociateOID [KEY]	String	True	Workers.AssociateOID	The unique identifier (Id) that represents the associate within the HR system. This field links the work assignment record to the associate's overall employment profile.
WorkerIdValue	String	True	Workers.WorkerID	The identifier value that represents the worker within HR and payroll systems. This field supports data synchronization and compliance tracking across systems.
ItemID [KEY]	String	False		The unique identifier (Id) that represents the specific work-assignment record. This field supports HR data auditing, history tracking, and reference linking to related tables.
ActualStartDate	Date	True		The date that defines when the worker actually began the assignment. This field supports HR onboarding validation, benefits eligibility, and payroll activation processes.
CompaRatio	Integer	True		The computed compensation ratio that compares the worker's pay to the midpoint of the assigned pay range. This field supports compensation analysis and equity reporting.
AdditionalRemunerations	String	False		The additional remuneration components associated with the worker's assignment (for example, bonuses, commissions, or allowances). This field supports detailed payroll and compensation reporting.
AnnualBenefitBaseRateAmountValue	Integer	True		The annual monetary value that defines the worker's base rate for benefit calculations. This field supports HR benefits administration and total rewards reporting.
AnnualBenefitBaseRateCurrencyCode	String	True		The currency code that defines the denomination of the annual benefit base rate (for example, USD, CAD, or EUR). This field ensures currency consistency across HR and payroll systems.
AnnualBenefitBaseRateNameCodeValue	String	True		The code that identifies the classification of the annual benefit base rate. This field supports HR and payroll benefit mapping and financial compliance.
AnnualBenefitBaseRateNameCodeLongName	String	True		The full descriptive name of the annual benefit base rate code. This field provides the complete label used in HR benefits and payroll documentation.
AnnualBenefitBaseRateNameCodeShortName	String	True		The abbreviated name that corresponds to the annual benefit base rate code. This field supports compact reporting and data display in HR dashboards.
AssignedOrganizationalUnits	String	False		The organizational units that are assigned to the worker's current position (for example, Department, Division, or Business Unit). This field supports HR structure management and cost center allocation.
AssignedWorkLocations	String	True		The locations that are assigned to the worker's current role (for example, Office, Plant, or Region). This field supports HR workforce planning and location-based compliance tracking.
AssignmentCostCenters	String	True		The cost centers that are linked to the worker's assignment. This field supports HR budgeting, payroll accounting, and financial reporting.
AssignmentStatusEffectiveDate	Date	True		The date that defines when the current assignment status became effective. This field supports HR history tracking and payroll processing accuracy.
AssignmentStatusReasonCodeValue	String	False		The code that identifies the reason for a change in assignment status (for example, Promotion, Transfer, or Termination). This field supports HR audit trail creation and compliance documentation.
AssignmentStatusReasonCodeLongName	String	True		The full descriptive name of the reason code for the assignment status. This field provides clarity in HR records and internal reporting.
AssignmentStatusReasonCodeShortName	String	True		The abbreviated name that corresponds to the reason code for the assignment status. This field supports compact display in HR reports and dashboards.
AssignmentStatusStatusCodeValue	String	True		The code that identifies the current status of the worker's assignment (for example, Active, On Leave, or Terminated). This field supports HR and payroll status validation.
AssignmentStatusStatusCodeLongName	String	True		The full descriptive name of the assignment status code. This field provides the detailed label used in HR documentation and status reports.
AssignmentStatusStatusCodeShortName	String	True		The abbreviated name that corresponds to the assignment status code. This field supports concise labeling in HR dashboards and compliance exports.
AssignmentTermCodeValue	String	True		The code that identifies the term or duration type of the worker's assignment (for example, Permanent, Temporary, or Seasonal). This field supports HR classification and contract tracking.
AssignmentTermCodeLongName	String	True		The full descriptive name of the assignment term code. This field provides the complete label used in HR reports and payroll documentation.
AssignmentTermCodeShortName	String	True		The abbreviated name that corresponds to the assignment term code. This field supports compact data presentation in HR dashboards and reports.
BargainingUnitBargainingUnitCodeValue	String	False		The code that identifies the bargaining unit to which the worker belongs. This field supports HR union management and collective bargaining compliance tracking.
BargainingUnitBargainingUnitCodeLongName	String	True		The full descriptive name of the bargaining unit code. This field provides context for HR labor relations and payroll reporting.
BargainingUnitBargainingUnitCodeShortName	String	False		The abbreviated name that corresponds to the bargaining unit code. This field supports compact reporting and streamlined HR data display.
BargainingUnitSeniorityDate	Date	False		The date that defines when the worker's seniority within the bargaining unit began. This field supports HR union reporting and benefit eligibility tracking.
BaseRemunerationAnnualRateAmountValue	Decimal	True		The monetary value of the worker's annual base remuneration. This field supports HR compensation planning, payroll calculation, and equity analysis.
BaseRemunerationAnnualRateAmountCurrencyCode	String	True		The currency code that defines the denomination of the annual base remuneration (for example, USD, GBP, or AUD). This field supports HR and payroll system integration.
BaseRemunerationAnnualRateAmountNameCodeValue	String	True		The code that identifies the classification of the annual remuneration type. This field supports structured pay configuration and HR compensation mapping.
BaseRemunerationAnnualRateAmountNameCodeLongName	String	True		The full descriptive name of the type code for the annual remuneration. This field provides the detailed label that appears in HR documentation and payroll reports.
BaseRemunerationAnnualRateAmountNameCodeShortName	String	True		The abbreviated name that corresponds to the type code for the annual remuneration. This field supports concise labeling in HR dashboards and compensation summaries.
BaseRemunerationAssociatedRateQualifiers	String	True		The rate qualifiers that are associated with the worker's base remuneration (for example, Hourly, Annualized, or Commission-based). This field supports payroll configuration and HR data mapping.
BaseRemunerationBiweeklyRateAmountValue	Decimal	True		The monetary value of the worker's biweekly base remuneration. This field supports payroll processing, labor cost tracking, and HR compensation analysis.
BaseRemunerationBiweeklyRateAmountCurrencyCode	String	True		The currency code that defines the denomination of the biweekly base remuneration (for example, USD, CAD, or EUR). This field supports currency consistency across HR and payroll systems.
BaseRemunerationBiweeklyRateAmountNameCodeLongName	String	True		The full descriptive name of the type code for the biweekly remuneration. This field provides the detailed label that appears in HR documentation and reports.
BaseRemunerationBiweeklyRateAmountNameCodeValue	String	True		The code that identifies the classification of the biweekly remuneration type. This field supports structured compensation tracking and HR data integration.
BaseRemunerationBiweeklyRateAmountNameCodeShortName	String	True		The abbreviated name that corresponds to the the type code for the biweekly remuneration. This field supports compact data display in HR dashboards and compensation exports.
BaseRemunerationCommissionRatePercentageBaseUnitCodeValue	String	True		The code that identifies the base unit that is used to calculate commission rate percentages (for example, Sales Amount, Units Sold, or Revenue). This field supports commission calculations and HR compensation reporting.
BaseRemunerationCommissionRatePercentageBaseUnitCodeLongName	String	True		The full descriptive name of the code for the commission-rate base unit. This field provides a human-readable label for HR compensation and commission reports.
BaseRemunerationCommissionRatePercentageBaseUnitCodeShortName	String	True		The abbreviated form of the code for the commission-rate base unit. This field supports compact display in HR dashboards and payroll exports.
BaseRemunerationCommissionRatePercentageNameCodeValue	String	True		The code that identifies the type of commission rate applied to the worker's compensation. This field supports structured HR and payroll data integration.
BaseRemunerationCommissionRatePercentageNameCodeLongName	String	True		The full descriptive name of the type code for the commission-rate percentage. This field provides the complete label that appears in HR documentation and payroll reports.
BaseRemunerationCommissionRatePercentageNameCodeShortName	String	True		The abbreviated name that corresponds to the the type code for the commission-rate percentage. This field supports compact display in HR dashboards and exports.
BaseRemunerationCommissionRatePercentagePercentageValue	Integer	True		The numeric percentage that represents the commission rate applied to the worker's earnings. This field supports payroll computation and HR compensation analysis.
BaseRemunerationDailyRateAmountValue	Decimal	False		The monetary value of the worker's daily base remuneration. This field supports payroll calculation, HR budgeting, and compensation planning.
BaseRemunerationDailyRateAmountCurrencyCode	String	True		The currency code that defines the denomination of the daily base remuneration (for example, USD, GBP, or CAD). This field supports payroll accuracy and cross-border HR reporting.
BaseRemunerationDailyRateAmountNameCodeValue	String	False		The code that identifies the classification of the daily remuneration type. This field supports structured compensation mapping and HR data standardization.
BaseRemunerationDailyRateAmountNameCodeLongName	String	True		The full descriptive name of the type code for the daily remuneration. This field provides context for HR compensation records and payroll documentation.
BaseRemunerationDailyRateAmountNameCodeShortName	String	True		The abbreviated name that corresponds to the type code for the daily remuneration. This field supports concise labeling in HR dashboards and data exports.
BaseRemunerationEffectiveDate	Date	False		The date that defines when the worker's base remuneration became effective. This field supports payroll accuracy, HR auditing, and historical tracking.
BaseRemunerationHourlyRateAmountValue	Decimal	False		The monetary value of the worker's hourly base remuneration. This field supports HR compensation management, payroll calculation, and compliance reporting.
BaseRemunerationHourlyRateAmountCurrencyCode	String	True		The currency code that defines the denomination of the hourly base remuneration (for example, USD, EUR, or GBP). This field ensures alignment between HR and payroll systems.
BaseRemunerationHourlyRateAmountNameCodeValue	String	True		The code that identifies the classification of the hourly remuneration type. This field supports structured data mapping and HR pay configuration.
BaseRemunerationHourlyRateAmountNameCodeLongName	String	True		The full descriptive name of the type code for th hourly remuneration. This field provides the detailed label used in HR compensation documentation and payroll reports.
BaseRemunerationHourlyRateAmountNameCodeShortName	String	True		The abbreviated name that corresponds to the type code for the hourly remuneration. This field supports compact display in HR dashboards and system exports.
BaseRemunerationMonthlyRateAmountValue	Decimal	True		The monetary value of the worker's monthly base remuneration. This field supports payroll cycle processing, HR compensation planning, and internal reporting.
BaseRemunerationMonthlyRateAmountCurrencyCode	String	True		The currency code that defines the denomination of the monthly base remuneration (for example, USD, CAD, or AUD). This field supports HR and payroll integration for accurate compensation management.
BaseRemunerationMonthlyRateAmountNameCodeValue	String	False		The code that identifies the classification of the monthly remuneration type. This field supports structured HR pay configuration and payroll reporting.
BaseRemunerationMonthlyRateAmountNameLongName	String	True		The full descriptive name of the type code for the monthly remuneration. This field provides the detailed label used in HR documentation and compensation reports.
BaseRemunerationMonthlyRateAmountNameShortName	String	False		The abbreviated name that corresponds to the type code for the monthly remuneration. This field supports compact data display in HR dashboards and exports.
BaseRemunerationPayPeriodRateAmountValue	Decimal	True		The monetary value of the worker's pay-period base remuneration. This field supports HR compensation planning, payroll calculation, and earnings reporting.
BaseRemunerationPayPeriodRateAmountCurrencyCode	String	True		The currency code that defines the denomination of the pay-period base remuneration (for example, USD, EUR, or CAD). This field ensures consistency between HR and payroll systems.
BaseRemunerationPayPeriodRateAmountNameCodeValue	String	True		The code that identifies the classification of the pay-period remuneration type. This field supports structured HR and payroll data mapping.
BaseRemunerationPayPeriodRateAmountNameCodeLongName	String	True		The full descriptive name of the code for the pay-period remuneration type. This field provides a human-readable label used in HR documentation and payroll reports.
BaseRemunerationPayPeriodRateAmountNameCodeShortName	String	True		The abbreviated name that corresponds to the code for the pay-period remuneration type. This field supports compact reporting in HR dashboards and compensation exports.
BaseRemunerationRecordingBasisCodeValue	String	True		The code that identifies the basis used for recording remuneration (for example, Cash, Accrual, or Commission-based). This field supports HR accounting compliance and payroll configuration.
BaseRemunerationRecordingBasisCodelongName	String	True		The full descriptive name of the code fro the remuneration recording basis. This field provides context for HR reporting, payroll auditing, and accounting integration.
BaseRemunerationRecordingBasisCodeShortName	String	True		The abbreviated name that corresponds to the code for the remuneration recording basis. This field supports concise labeling in HR dashboards and internal payroll reports.
BaseRemunerationSemiMonthlyRateAmountValue	Decimal	True		The monetary value of the worker's semi-monthly base remuneration. This field supports HR compensation analysis and payroll cycle management.
BaseRemunerationSemiMonthlyRateAmountCurrencyCode	String	True		The currency code that defines the denomination of the semi-monthly base remuneration (for example, USD, GBP, or AUD). This field supports cross-border HR and payroll consistency.
BaseRemunerationSemiMonthlyRateAmountNameCodeValue	String	True		The code that identifies the classification of the semi-monthly remuneration type. This field supports structured compensation management in HR systems.
BaseRemunerationSemiMonthlyRateAmountNameCodeLongName	String	True		The full descriptive name of the code for the semi-monthly remuneration type. This field provides the detailed label that appears in HR documentation and payroll reports.
BaseRemunerationSemiMonthlyRateAmountNameCodeShortName	String	True		The abbreviated name that corresponds to the code for the semi-monthly remuneration type. This field supports compact data representation in HR and payroll exports.
BaseRemunerationWeeklyRateAmountValue	Decimal	True		The monetary value of the worker's weekly base remuneration. This field supports payroll cycle processing, HR budgeting, and compensation analysis.
BaseRemunerationWeeklyRateAmountCurrencyCode	String	True		The currency code that defines the denomination of the weekly base remuneration (for example, USD, CAD, or EUR). This field ensures HR and payroll system alignment.
BaseRemunerationWeeklyRateAmountNameCodeValue	String	True		The code that identifies the classification of the weekly remuneration type. This field supports structured HR data mapping and compensation reporting.
BaseRemunerationWeeklyRateAmountNameCodeLongName	String	True		The full descriptive name of the code for the weekly remuneration type. This field provides context for HR documentation and payroll analysis.
BaseRemunerationWeeklyRateAmountNameCodeShortName	String	True		The abbreviated name that corresponds to the code for the weekly remuneration type. This field supports compact display in HR dashboards and internal payroll reports.
ExecutiveIndicator	Boolean	True		A Boolean value that indicates whether the worker is classified as an executive. This field supports HR workforce segmentation, compensation policy enforcement, and compliance tracking.
ExecutiveTypeCodeValue	String	True		The code that identifies the type of executive classification (for example, C-Level, Vice President, or Senior Director). This field supports HR categorization and compensation management.
ExecutiveTypeCodeLongName	String	True		The full descriptive name of the code for the executive type. This field provides the human-readable label used in HR and payroll documentation.
ExecutiveTypeCodeShortName	String	True		The abbreviated name that corresponds to the code for the executive type. This field supports compact HR and payroll data display.
ExpectedStartDate	Date	True		The date that defines when the worker's assignment is expected to begin. This field supports HR onboarding scheduling, payroll activation, and resource planning.
ExpectedTerminationDate	Date	True		The date that defines when the worker's assignment is expected to end. This field supports HR contract management, payroll forecasting, and offboarding coordination.
FullTimeEquivalenceRatio	Integer	True		The numeric ratio that represents the worker's full-time equivalence (FTE). This field supports HR analytics, payroll budgeting, and compliance reporting for part-time and full-time employees.
GeographicPayDifferentialCodeValue	String	True		The code that identifies the geographic pay differential category that is applied to the worker's pay. This field supports HR regional compensation management and pay equity analysis.
GeographicPayDifferentialCodeLongName	String	True		The full descriptive name of the geographic pay differential code. This field provides context in HR compensation documentation and payroll records.
GeographicPayDifferentialCodeShortName	String	True		The abbreviated name that corresponds to the geographic pay differential code. This field supports compact labeling in HR dashboards and compensation exports.
GeographicPayDifferentialPercentage	Integer	True		The numeric percentage that represents the pay differential applied to the worker based on geographic location. This field supports payroll accuracy and HR compensation analysis.
HighlyCompensatedIndicator	Boolean	True		A Boolean value that indicates whether the worker qualifies as a highly compensated employee. This field supports HR compliance reporting and compensation eligibility validation.
HighlyCompensatedTypeCodeValue	String	True		The code that identifies the type of highly compensated employee classification (for example, Exempt Executive, Exempt Professional, or Exempt Administrative). This field supports HR classification and compliance reporting.
HighlyCompensatedTypeCodeLongName	String	True		The full descriptive name of the highly compensated classification code. This field provides clarity in HR documentation and compensation analysis.
HighlyCompensatedTypeCodeShortName	String	True		The abbreviated name that corresponds to the highly compensated classification code. This field supports compact data presentation in HR dashboards and payroll reports.
HireDate	Date	True		The date that defines when the worker was originally hired for the assignment. This field supports HR tenure tracking, benefits eligibility, and payroll activation.
HomeOrganizationalUnits	String	False		The organizational units that are designated as the worker's home units (for example, Department, Division, or Cost Center). This field supports HR organizational mapping and payroll cost allocation.
HomeWorkLocationAddressAttentionOfName	String	True		The name of the person or department that correspondence to the worker's home work location should be addressed to. This field supports HR facility management and internal communication routing.
HomeWorkLocationAddressBlockName	String	True		The name or identifier of the block associated with the worker's home work-location address. This field supports HR address accuracy, facility mapping, and emergency contact documentation.
HomeWorkLocationAddressBuildingName	String	True		The name of the building where the worker's home work location is situated. This field supports HR facility identification, correspondence accuracy, and workplace safety planning.
HomeWorkLocationAddressBuildingNumber	String	True		The number that identifies the specific building associated with the worker's home work location. This field supports HR address standardization and postal delivery accuracy.
HomeWorkLocationAddressCareOfName	String	True		The name of the person or entity designated as 'care of' for the worker's home work-location address. This field supports HR record accuracy and ensures correspondence reaches the correct contact.
HomeWorkLocationAddressCityName	String	False		The name of the city where the worker's home work location is located. This field supports HR compliance, payroll tax jurisdiction assignment, and location-based reporting.
HomeWorkLocationAddressCountryCode	String	False		The code that identifies the country where the worker's home work location is situated (for example, US, CA, or MX). This field supports HR global data mapping and payroll localization.
HomeWorkLocationAddressCountrySubdivisionLevel1CodeValue	String	False		The code that identifies the first-level administrative subdivision (for example, State, Province, or Region). This field supports HR jurisdictional reporting and compliance management.
HomeWorkLocationAddressCountrySubdivisionLevel1LongName	String	True		The full descriptive name of the first-level administrative subdivision. This field provides the formal label used in HR and payroll documentation.
HomeWorkLocationAddressCountrySubdivisionLevel1ShortName	String	False		The abbreviated name that corresponds to the first-level administrative subdivision. This field supports compact display in HR reports and system dashboards.
HomeWorkLocationAddressCountrySubdivisionLevel1SubdivisionType	String	False		The classification that defines the type of first-level administrative subdivision (for example, State, Province, or Territory). This field supports HR standardization and jurisdiction mapping.
HomeWorkLocationAddressCountrySubdivisionLevel2CodeValue	String	False		The code that identifies the second-level administrative subdivision (for example, County, Municipality, or District). This field supports HR geographic hierarchy and payroll location mapping.
HomeWorkLocationAddressCountrySubdivisionLevel2LongName	String	True		The full descriptive name of the second-level administrative subdivision. This field provides the detailed label used in HR reports and address documentation.
HomeWorkLocationAddressCountrySubdivisionLevel2ShortName	String	False		The abbreviated name that corresponds to the second-level administrative subdivision. This field supports compact representation in HR dashboards and exported data.
HomeWorkLocationAddressCountrySubdivisionLevel2SubdivisionType	String	False		The classification that defines the type of second-level administrative subdivision (for example, County, District, or Municipality). This field supports HR and payroll location configuration.
HomeWorkLocationAddressDeliveryPoint	String	True		The specific delivery point that defines the precise postal destination for the worker's home work-location address (for example, Suite, Apartment, or Mailstop). This field supports HR correspondence and logistical accuracy.
HomeWorkLocationAddressDoor	String	True		The door or entryway identifier for the worker's home work location. This field supports HR facility access, emergency planning, and internal navigation.
HomeWorkLocationAddressFloor	String	True		The floor number or designation within the building at the worker's home work location. This field supports HR workplace mapping and safety coordination.
HomeWorkLocationAddressGeoCoordinateLatitude	Integer	True		The latitude coordinate that represents the worker's home work location. This field supports HR geolocation analysis, emergency planning, and workforce distribution tracking.
HomeWorkLocationAddressGeoCoordinateLongitude	Integer	True		The longitude coordinate that represents the worker's home work location. This field supports HR facility mapping, payroll region verification, and global compliance analytics.
HomeWorkLocationAddressLineFive	String	True		The fifth address line that provides additional details for the worker's home work-location address. This field supports full address documentation and HR correspondence completeness.
HomeWorkLocationAddressLineFour	String	True		The fourth address line used for secondary address components (for example, complex name or internal routing). This field supports detailed HR and facility address management.
HomeWorkLocationAddressLineOne	String	False		The first address line that identifies the main street address or premise information. This field supports HR legal documentation, payroll registration, and mailing accuracy.
HomeWorkLocationAddressLineTwo	String	False		The second address line that provides supplemental location information (for example, Apartment, Suite, or Unit). This field supports HR and payroll address validation.
HomeWorkLocationAddressLineThree	String	False		The third address line that provides further location details, such as complex or internal building identifiers. This field supports HR accuracy in employee and facility records.
HomeWorkLocationAddressNameCodeValue	String	True		The code that identifies the naming convention or category used for the home work-location address. This field supports HR address classification and system standardization.
HomeWorkLocationAddressNameCodeLongName	String	True		The full descriptive name of the home work-location address name code. This field provides the formal label used in HR reporting and payroll exports.
HomeWorkLocationAddressNameCodeShortName	String	True		The abbreviated name that corresponds to the home work-location address name code. This field supports compact data display in HR dashboards and export files.
HomeWorkLocationAddressPlotID	String	True		The plot identifier that represents the specific land parcel or property for the home work location. This field supports HR facility records, mapping, and legal compliance documentation.
HomeWorkLocationAddressPostalCode	String	False		The postal or ZIP code associated with the worker's home work location. This field supports HR and payroll jurisdictional reporting, taxation, and address validation.
HomeWorkLocationAddressPostOfficeBox	String	True		The post office box number linked to the worker's home work location, if applicable. This field supports HR correspondence management and postal recordkeeping.
HomeWorkLocationAddressScriptCodeValue	String	True		The code that identifies the character script used in the address (for example, Latin, Cyrillic, or Katakana). This field supports multilingual HR address formatting and system compatibility.
HomeWorkLocationAddressScriptCodeLongName	String	True		The full descriptive name of the address script code that defines the writing system used in the home work-location address (for example, Latin or Cyrillic). This field supports multilingual HR recordkeeping and system compatibility.
HomeWorkLocationAddressScriptCodeShortName	String	True		The abbreviated name that corresponds to the address script code. This field supports compact HR data display and international address formatting.
HomeWorkLocationAddressStairCase	String	True		The staircase identifier that defines a specific entry or section of the building associated with the worker's home work-location address. This field supports HR facility mapping, access management, and safety documentation.
HomeWorkLocationAddressStreetName	String	True		The name of the street where the worker's home work location is situated. This field supports HR address validation, payroll jurisdiction alignment, and mail accuracy.
HomeWorkLocationAddressStreetTypeCodeValue	String	True		The code that identifies the classification of the street type (for example, Avenue, Boulevard, or Road). This field supports HR address standardization and payroll region mapping.
HomeWorkLocationAddressStreetTypeCodeLongName	String	True		The full descriptive name of the type code for the street. This field provides clarity in HR and payroll address records for global consistency.
HomeWorkLocationAddressStreetTypeCodeShortName	String	True		The abbreviated name that corresponds to type code for the street. This field supports compact representation of address data in HR reports and exports.
HomeWorkLocationAddressUnit	String	True		The unit, apartment, or suite designation for the worker's home work location. This field supports HR address accuracy, facility contact tracking, and postal compliance.
HomeWorkLocationCommunicationEmails	String	True		The email contact details that are associated with the home work location (for example, site administrator, facilities desk, or local HR contact). This field supports communication management and HR coordination.
HomeWorkLocationCommunicationFaxes	String	True		The fax contact information for the worker's home work location. This field supports HR correspondence, document transmission, and site-level communication records.
HomeWorkLocationCommunicationLandlines	String	True		The landline telephone numbers that are associated with the home work location. This field supports HR contact directories, facility communication, and emergency planning.
HomeWorkLocationCommunicationMobiles	String	True		The mobile telephone numbers that are associated with the home work location. This field supports HR facility communication, on-call coordination, and safety contact requirements.
HomeWorkLocationCommunicationPagers	String	True		The pager contact numbers that are associated with the home work location. This field supports HR emergency notification systems and field response coordination.
HomeWorkLocationNameCodeValue	String	False		The code that identifies the name or label for the home work location (for example, Main Office, Regional Hub, or Distribution Center). This field supports HR location management and payroll cost allocation.
HomeWorkLocationNameCodeLongName	String	True		The full descriptive name of the home work location code. This field provides context for HR reporting, payroll records, and organizational mapping.
HomeWorkLocationNameCodeShortName	String	False		The abbreviated name that corresponds to the home work location code. This field supports compact reporting and HR data exports.
IndustryClassifications	String	False		The industry classification codes that are linked to the worker's assignment. This field supports HR reporting, compliance tracking, and regulatory classification (for example, NAICS or SIC).
JobCodeValue	String	False		The code that identifies the job classification assigned to the worker. This field supports HR job framework management and payroll configuration.
JobCodeEffectiveDate	Date	True		The date that defines when the current job code became effective. This field supports HR job history tracking and compensation alignment.
JobCodeLongName	String	True		The full descriptive name of the job code assigned to the worker. This field provides context for HR reports, job descriptions, and payroll documentation.
JobCodeShortName	String	False		The abbreviated name that corresponds to the job code. This field supports compact data presentation in HR dashboards and internal reports.
JobTitle	String	True		The title associated with the worker's current job. This field supports HR personnel records, payroll alignment, and organization chart display.
LaborUnionLaborUnionCodeValue	String	False		The code that identifies the labor union to which the worker belongs. This field supports HR compliance with collective bargaining agreements and labor law tracking.
LaborUnionLaborUnionCodeLongName	String	True		The full descriptive name of the labor union code. This field provides clarity in HR labor relations reporting and payroll processing.
LaborUnionLaborUnionCodeShortName	String	False		The abbreviated name that corresponds to the labor union code. This field supports concise labeling in HR dashboards and collective agreement summaries.
LaborUnionSeniorityDate	Date	True		The date that defines when the worker's labor union seniority began. This field supports HR union eligibility, benefits tracking, and seniority-based calculations.
LegalEntityID	String	True		The unique identifier (Id) that represents the legal entity associated with the worker's assignment. This field supports HR corporate structure management, payroll segregation, and compliance reporting.
Links	String	True		The links that connect this record to related resources, such as other HR records, payroll files, or assignment data. This field supports data navigation and API integration.
ManagementPositionIndicator	Boolean	False		A Boolean value that indicates whether the worker holds a management position. This field supports HR leadership classification, payroll approvals, and organizational reporting.
MinimumPayGradeStepDuration	String	True		The minimum duration that a worker must remain in the current pay grade step before becoming eligible for advancement. This field supports HR compensation policies and pay progression tracking.
NationalityContextCodeValue	String	True		The code that identifies the nationality or citizenship context associated with the worker's assignment. This field supports HR compliance and global workforce reporting.
NationalityContextCodeLongName	String	True		The full descriptive name of the nationality context code. This field provides clarity in HR documentation, especially for international assignment tracking.
NationalityContextCodeShortName	String	True		The abbreviated name that corresponds to the nationality context code. This field supports compact data display in HR dashboards and compliance exports.
NextPayGradeStepDate	Date	True		The date that defines when the worker is scheduled to move to the next pay grade step. This field supports HR compensation management and career progression planning.
OccupationalClassifications	String	False		The occupational classification codes that describe the worker's role or profession (for example, SOC or ISCO codes). This field supports HR job categorization, compliance, and government reporting.
OfferAcceptanceDate	Date	True		The date that defines when the worker accepted the employment offer. This field supports HR recruitment tracking, onboarding scheduling, and legal documentation.
OfferExtensionDate	Date	True		The date that defines when the employment offer was extended to the worker. This field supports HR recruitment timelines and compliance documentation.
OfficerIndicator	Boolean	True		A Boolean value that indicates whether the worker holds an officer designation within the organization. This field supports HR governance, executive classification, and payroll reporting.
OfficerTypeCodeValue	String	False		The code that identifies the officer classification type (for example, Corporate Officer, Financial Officer, or Legal Officer). This field supports HR hierarchy tracking and compliance reporting.
OfficerTypeCodeLongName	String	True		The full descriptive name of the type code for the officer. This field provides the detailed label used in HR documentation and payroll systems.
OfficerTypeCodeShortName	String	False		The abbreviated name that corresponds to the type code for the officer. This field supports compact labeling in HR dashboards and compliance exports.
PayCycleCodeValue	String	False		The code that identifies the pay cycle associated with the worker's assignment (for example, Weekly, Biweekly, or Monthly). This field supports HR payroll frequency configuration and wage calculation.
PayCycleCodeLongName	String	True		The full descriptive name of the pay cycle code. This field provides clarity in HR and payroll documentation.
PayCycleCodeShortName	String	False		The abbreviated name that corresponds to the pay cycle code. This field supports compact reporting and payroll system display.
PayGradeCodeValue	String	False		The code that identifies the pay grade assigned to the worker's job classification. This field supports HR compensation framework mapping and payroll validation.
PayGradeCodeLongName	String	True		The full descriptive name of the pay grade code. This field provides a complete label used in HR compensation reporting and documentation.
PayGradeCodeShortName	String	False		The abbreviated name that corresponds to the pay grade code. This field supports compact display in HR dashboards and exports.
PayGradePayRangeMaximumRateAmountValue	Decimal	True		The maximum pay rate amount defined for the worker's pay grade range. This field supports HR compensation modeling and payroll validation.
PayGradePayRangeMaximumRateBaseMultiplierValue	Integer	True		The numeric multiplier that represents the base unit factor applied to calculate the maximum pay rate. This field supports HR pay scale calculations and payroll computation.
PayGradePayRangeMaximumRateBaseUnitCodeValue	String	True		The code that identifies the base unit used for calculating the maximum pay rate (for example, Hour, Month, or Year). This field supports HR rate standardization and payroll consistency.
PayGradePayRangeMaximumRateBaseUnitCodeLongName	String	True		The full descriptive name of the base unit code used in the maximum pay rate calculation. This field provides clarity in HR documentation and compensation reports.
PayGradePayRangeMaximumRateBaseUnitCodeShortName	String	True		The abbreviated name that corresponds to the base unit code for the maximum pay rate. This field supports compact display in HR dashboards and payroll exports.
PayGradePayRangeMaximumRateCurrencyCode	String	True		The currency code that defines the denomination of the maximum pay rate (for example, USD, CAD, or GBP). This field supports HR international payroll reporting and consistency.
PayGradePayRangeMaximumRateUnitCodeValue	String	True		The code that identifies the pay unit used for expressing the maximum pay rate (for example, Hourly, Monthly, or Annual). This field supports HR compensation structure alignment.
PayGradePayRangeMaximumRateUnitCodeLongName	String	True		The full descriptive name of the pay unit code associated with the maximum pay rate. This field provides context for HR and payroll documentation.
PayGradePayRangeMaximumRateUnitCodeShortName	String	True		The abbreviated name that corresponds to the pay unit code for the maximum pay rate. This field supports compact HR data presentation and reporting.
PayGradePayRangeMedianRateAmountValue	Decimal	True		The monetary amount that represents the median rate within the worker's pay grade range. This field supports HR pay structure benchmarking and compensation analytics.
PayGradePayRangeMedianRateBaseMultiplierValue	Integer	True		The numeric multiplier that represents the base unit factor applied to calculate the median pay rate. This field supports HR and payroll pay grade consistency.
PayGradePayRangeMedianRateBaseUnitCodeValue	String	True		The code that identifies the base unit used for the median pay rate calculation (for example, Hour, Month, or Year). This field supports HR and payroll data standardization.
PayGradePayRangeMedianRateBaseUnitCodeLongName	String	True		The full descriptive name of the base unit used in the median pay rate calculation. This field provides detailed context for HR reporting and payroll computation.
PayGradePayRangeMedianRateBaseUnitCodeShortName	String	True		The abbreviated name that corresponds to the base unit code for the median pay rate calculation. This field supports compact HR data display and payroll system exports.
PayGradePayRangeMedianRateCcurrencyCode	String	True		The currency code that defines the denomination of the median pay rate (for example, USD, CAD, or GBP). This field supports HR compensation benchmarking and payroll consistency across regions.
PayGradePayRangeMedianRateUnitCodeValue	String	True		The code that identifies the pay unit used to express the median rate within the pay grade (for example, Hourly, Monthly, or Annual). This field supports HR pay structure reporting and payroll classification.
PayGradePayRangeMedianRateUnitCodeLongName	String	True		The full descriptive name of the pay unit code used for the median rate. This field provides clarity in HR documentation and pay structure configuration.
PayGradePayRangeMedianRateUnitCodeShortName	String	True		The abbreviated name that corresponds to the pay unit code for the median rate. This field supports compact HR display in dashboards and data exports.
PayGradePayRangeMinimumRateAmountValue	Decimal	True		The monetary amount that represents the minimum rate within the worker's pay grade range. This field supports HR pay scale management and payroll compliance.
PayGradePayRangeMinimumRateBaseMultiplierValue	Integer	True		The numeric multiplier that represents the base unit factor applied to calculate the minimum pay rate. This field supports HR pay grade alignment and compensation analytics.
PayGradePayRangeMinimumRateBaseUnitCodeValue	String	True		The code that identifies the base unit used for calculating the minimum pay rate (for example, Hour, Month, or Year). This field supports HR rate standardization and payroll consistency.
PayGradePayRangeMinimumRateBaseUnitCodeLongName	String	True		The full descriptive name of the base unit used to determine the minimum pay rate. This field provides detailed context for HR reporting and payroll computation.
PayGradePayRangeMinimumRateBaseUnitCodeShortName	String	True		The abbreviated name that corresponds to the base unit code for the minimum pay rate. This field supports compact display in HR dashboards and payroll reports.
PayGradePayRangeMinimumRateCurrencyCode	String	True		The currency code that defines the denomination of the minimum pay rate (for example, USD, GBP, or EUR). This field supports HR international payroll reporting and consistency.
PayGradePayRangeMinimumRateUnitCodeValue	String	True		The code that identifies the pay unit used to express the minimum rate within the pay grade (for example, Hourly, Weekly, or Annual). This field supports HR compensation management and payroll configuration.
PayGradePayRangeMinimumRateUnitCodeLongName	String	True		The full descriptive name of the pay unit code associated with the minimum pay rate. This field provides clarity for HR documentation and pay scale reporting.
PayGradePayRangeMinimumRateUnitCodeShortName	String	True		The abbreviated name that corresponds to the pay unit code for the minimum pay rate. This field supports concise HR display and payroll system integration.
PayGradeStepCodeValue	String	True		The code that identifies the pay grade step within the worker's assigned grade. This field supports HR compensation step progression and payroll calculation accuracy.
PayGradeStepCodeLongName	String	True		The full descriptive name of the pay grade step code. This field provides context for HR documentation, pay structure reports, and employee compensation history.
PayGradeStepCodeShortName	String	True		The abbreviated name that corresponds to the pay grade step code. This field supports compact HR data display in dashboards and compensation tables.
PayGradeStepPayRateAmountValue	Decimal	True		The monetary amount that represents the pay rate associated with the worker's current pay grade step. This field supports HR compensation calculations and payroll recordkeeping.
PayGradeStepPayRateBaseMultiplierValue	Integer	True		The numeric multiplier that represents the base unit factor applied to calculate the step pay rate. This field supports HR compensation modeling and payroll validation.
PayGradeStepPayRateBaseUnitCodeValue	String	True		The code that identifies the base unit used for calculating the pay grade step rate (for example, Hour, Month, or Year). This field supports HR rate standardization and payroll consistency.
PayGradeStepPayRateBaseUnitCodeLongName	String	True		The full descriptive name of the base unit code for the step pay rate. This field provides HR clarity in documentation and reporting.
PayGradeStepPayRateBaseUnitCodeShortName	String	True		The abbreviated name that corresponds to the base unit code for the step pay rate. This field supports compact HR dashboard display and payroll integration.
PayGradeStepPayRateCurrencyCode	String	True		The currency code that defines the denomination of the pay grade step rate (for example, USD, CAD, or GBP). This field supports HR international payroll consistency and wage accuracy.
PayGradeStepPayRateUnitCodeValue	String	True		The code that identifies the pay unit used to express the pay grade step rate (for example, Hourly, Weekly, or Annual). This field supports HR payroll configuration and compensation alignment.
PayGradeStepPayRateUnitCodeLongName	String	True		The full descriptive name of the pay unit code associated with the pay grade step rate. This field provides context for HR reporting and payroll documentation.
PayGradeStepPayRateUnitCodeShortName	String	True		The abbreviated name that corresponds to the pay unit code for the pay grade step rate. This field supports concise HR dashboard display and reporting consistency.
PayrollFileNumber	String	False		The number that identifies the worker's payroll file. This field supports HR payroll administration, employee record tracking, and compliance audits.
PayrollGroupCode	String	False		The code that identifies the payroll group to which the worker belongs. This field supports HR payroll configuration, batch processing, and reporting segmentation.
PayrollProcessingStatusCodeValue	String	True		The code that identifies the current payroll processing status (for example, Pending, Processed, or Approved). This field supports HR payroll workflow tracking and system integration.
PayrollProcessingStatusCodeEffectiveDate	Date	True		The date that defines when the current payroll processing status became effective. This field supports HR audit tracking and payroll cycle management.
PayrollProcessingStatusCodeLongName	String	True		The full descriptive name of the payroll processing status code. This field provides clarity in HR documentation and payroll system reports.
PayrollProcessingStatusCodeShortName	String	True		The abbreviated name that corresponds to the payroll processing status code. This field supports compact HR dashboard reporting.
PayrollRegionCode	String	True		The code that identifies the payroll region responsible for processing the worker's pay. This field supports HR jurisdiction management, tax configuration, and multi-region payroll alignment.
PayrollScheduleGroupID	String	True		The unique identifier (Id) that represents the payroll schedule group to which the worker's pay is assigned. This field supports HR pay cycle configuration and payroll scheduling.
PayScaleCodeValue	String	True		The code that identifies the pay scale or salary structure associated with the worker's assignment. This field supports HR compensation framework mapping and payroll alignment.
PayScaleCodeLongName	String	True		The full descriptive name of the pay scale code that defines the salary structure assigned to the worker. This field supports HR compensation planning, payroll configuration, and job structure alignment.
PayScaleCodeShortName	String	True		The abbreviated name that corresponds to the pay scale code. This field supports compact HR reporting and payroll dashboard display.
PositionID	String	False		The unique identifier (Id) that represents the position associated with the worker's assignment. This field supports HR job tracking, organizational hierarchy mapping, and payroll reporting.
PositionTitle	String	True		The title of the position associated with the worker's current assignment. This field supports HR organization chart display and job classification.
PrimaryIndicator	Boolean	True		A Boolean value that indicates whether this is the worker's primary work assignment. This field supports HR reporting, benefits eligibility, and payroll calculations.
RemunerationBasisCodeValue	String	True		The code that identifies the basis on which the worker's remuneration is calculated (for example, salary, hourly, or commission). This field supports HR compensation configuration and payroll alignment.
RemunerationBasisCodeLongName	String	True		The full descriptive name of the remuneration basis code. This field provides clarity for HR documentation and payroll setup.
RemunerationBasisCodeShortName	String	True		The abbreviated name that corresponds to the remuneration basis code. This field supports compact HR and payroll reporting.
ReportsTo	String	False		The unique identifier (Id) or reference that specifies the person or position to whom the worker reports. This field supports HR management hierarchy and performance reporting.
SeniorityDate	Date	True		The date that defines when the worker's continuous service began. This field supports HR tenure calculations, benefits eligibility, and labor law compliance.
StandardHoursQuantity	Integer	False		The number of standard work hours assigned to the worker per unit period. This field supports HR scheduling, payroll calculation, and time reporting.
StandardHoursUnitCodeValue	String	True		The code that identifies the time unit associated with the standard work hours (for example, hour, week, or month). This field supports HR time-tracking alignment and payroll configuration.
StandardHoursUnitCodeLongName	String	True		The full descriptive name of the time unit associated with the standard work hours. This field provides context in HR documentation and scheduling reports.
StandardHoursUnitCodeShortName	String	True		The abbreviated name that corresponds to the time unit for standard hours. This field supports compact HR and payroll data display.
StandardPayPeriodHoursHoursQuantity	Integer	True		The number of hours that defines the standard duration of a pay period for the worker. This field supports HR payroll planning and wage rate computation.
StandardPayPeriodHoursUnitCodeValue	String	True		The code that identifies the time unit used for defining the standard pay period hours (for example, hour, day, or week). This field supports HR payroll configuration.
StandardPayPeriodHoursUnitCodeLongName	String	True		The full descriptive name of the time unit associated with the standard pay period hours. This field provides clarity in HR documentation and payroll scheduling.
StandardPayPeriodHoursUnitCodeShortName	String	True		The abbreviated name that corresponds to the time unit for standard pay period hours. This field supports concise HR data presentation and payroll reporting.
StockOwnerIndicator	Boolean	True		A Boolean value that indicates whether the worker holds stock in the company. This field supports HR executive tracking, compensation disclosure, and compliance documentation.
StockOwnerPercentage	Integer	True		The percentage that represents the portion of company stock owned by the worker. This field supports HR compensation reporting, equity management, and compliance tracking.
TerminationDate	Date	False		The date that defines when the worker's employment or assignment ended. This field supports HR offboarding, payroll closure, and compliance reporting.
VipIndicator	Boolean	True		A Boolean value that indicates whether the worker holds VIP status within the organization. This field supports HR executive management, payroll exception handling, and system access control.
VipTypeCodeValue	String	True		The code that identifies the classification of the worker's VIP type (for example, executive, Partner, or Advisor). This field supports HR visibility configuration and payroll categorization.
VipTypeCodeLongName	String	True		The full descriptive name of the type code for the VIP. This field provides detailed context for HR executive tracking and payroll configuration.
VipTypeCodeShortName	String	True		The abbreviated name that corresponds to the type code for the VIP. This field supports compact HR and payroll reporting.
WageLawCoverageCodeValue	String	False	WageLawCoverageCode.CodeValue	The code that identifies the wage law coverage applicable to the worker (for example, FLSA Exempt, Non-Exempt, or Union). This field supports HR compliance and labor law reporting.
WageLawCoverageCodeLongName	String	True		The full descriptive name of the wage law coverage code. This field provides clarity in HR compliance documentation and payroll systems.
WageLawCoverageCodeShortName	String	False		The abbreviated name that corresponds to the wage law coverage code. This field supports concise HR compliance reporting.
WageLawCoverageWageLawNameCodeValue	String	True		The code that identifies the specific wage law that applies to the worker's assignment (for example, FLSA or State Overtime Law). This field supports HR regulatory alignment and payroll compliance.
WageLawCoverageWageLawNameCodeLongName	String	True		The full descriptive name of the wage law name code. This field provides clarity in HR and compliance documentation.
WageLawCoverageWageLawNameCodeShortName	String	True		The abbreviated name that corresponds to the wage law name code. This field supports compact HR compliance reporting and audit exports.
WorkArrangementCodeValue	String	True		The code that identifies the work arrangement type assigned to the worker (for example, On-site, Hybrid, or Remote). This field supports HR workforce management and payroll configuration.
WorkArrangementCodeLongName	String	True		The full descriptive name of the work arrangement code. This field provides detailed context for HR scheduling and location-based compliance.
WorkArrangementCodeShortName	String	True		The abbreviated name that corresponds to the work arrangement code. This field supports compact HR reporting and data exports.
WorkerGroups	String	True		The worker group codes that identify the collective or classification group to which the worker belongs. This field supports HR grouping, reporting, and payroll segmentation.
WorkerProbationIndicator	Boolean	True		A Boolean value that indicates whether the worker is currently in a probationary period. This field supports HR onboarding tracking and eligibility management.
WorkerProbationPeriodEndDate	Date	True		The date that defines when the worker's probationary period ends. This field supports HR monitoring of employee status changes and benefits eligibility.
WorkerProbationPeriodStartDate	Date	True		The date that defines when the worker's probationary period begins. This field supports HR onboarding and probation tracking.
WorkerTypeCodeValue	String	False	WorkerTypeCode.CodeValue	The code that identifies the type of worker (for example, Employee, Contractor, or Temporary). This field supports HR classification and payroll compliance.
WorkerTypeCodeLongName	String	True		The full descriptive name of the type code for the worker. This field provides context for HR documentation and employment classification reporting.
WorkerTypeCodeShortName	String	True		The abbreviated name that corresponds to the type code for the worker. This field supports compact HR data display and reporting.
WorkLevelCodeValue	String	True		The code that identifies the worker's job or responsibility level (for example, Entry, Mid, or Senior). This field supports HR job framework alignment and payroll scaling.
WorkLevelCodeLongName	String	True		The full descriptive name of the work-level code. This field provides clarity for HR reporting and job classification documentation.
WorkLevelCodeShortName	String	True		The abbreviated name that corresponds to the work-level code. This field supports compact HR reporting and analytics.
WorkShiftCodeValue	String	True		The code that identifies the worker's assigned work shift (for example, Day, Night, or Rotating). This field supports HR scheduling and payroll calculation.
WorkShiftCodeLongName	String	True		The full descriptive name of the work shift code. This field provides detailed context for HR shift planning and payroll alignment.
WorkShiftCodeShortName	String	True		The abbreviated name that corresponds to the work shift code. This field supports concise HR display and reporting.
JobFunctionCodeValue	String	True		The code that identifies the job function associated with the worker's position (for example, Finance, Engineering, or Operations). This field supports HR organizational mapping and payroll classification.
JobFunctionCodeShortName	String	True		The abbreviated name that corresponds to the job function code. This field supports compact HR data representation and reporting.
JobFunctionCodeLongName	String	True		The full descriptive name of the job function code. This field provides clarity for HR reporting and job classification documentation.
AsOfDate	Date	True		The date that defines when the data in this record is effective. This field supports HR reporting, payroll timing, and data version tracking.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.