Excel Add-In for ADP

Build 24.0.9060

WorkersPersonLegalNameTitlePrefixCodes

Returns workers person legal name title prefix codes.

Table Specific Information

Select

The add-in 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 add-in.

  • AssociateOID supports the '=' comparison.
  • WorkerID supports the '=' comparison.
  • AsOfDate supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM WorkersPersonLegalNameTitlePrefixCodes WHERE AssociateOID = 'G3349PZGBADQY8H7'

SELECT * FROM WorkersPersonLegalNameTitlePrefixCodes WHERE WorkerID = 'DRH9M9NPW'

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

Columns

Name Type References Description
AssociateOID String

Workers.AssociateOID

WorkerID String

Workers.WorkerID

AffixCode String
AffixCodeLongName String
AffixCodeShortName String
SequenceNumber Integer
AsOfDate Date

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060