Before You Connect

Before you can establish a connection, you must contact ADP to obtain a custom OAuth application and its associated credentials.

You must also create your own client certificate for use in authentication. For further information, see ADP Developer Resources.

Adding a Connection to ADP

To add a connection to ADP:

1. In the application console, navigate to the Connections page.
2. At the Add Connections panel, select the icon for the connection you want to add.
3. If the ADP icon is not available, click the Add More icon to download and install the ADP connector from the CData site.

For required properties, see the Settings tab.

For connection properties that are not typically required, see the Advanced tab.

Connecting to ADP

To connect to ADP, set the following properties:

• OAuthClientId: The client Id of the custom OAuth application you obtained from ADP.
• OAuthClientSecret: The custom OAuth application's client secret.
• SSLClientCert: The client certificate you created earlier (see Before You Connect).
• SSLClientCertPassword: The client certificate's password.
• UseUAT: The Sync App makes requests to the production environment by default. If using a developer account, set UseUAT = true.
• RowScanDepth: The maximum number of rows to scan for the custom fields columns available in the table (default=100). Setting a high value may decrease performance.

This section details a selection of advanced features of the ADP Sync App.

User Defined Views

The Sync App supports the use of user defined views, virtual tables whose contents are decided by a pre-configured user defined query. These views are useful when you cannot directly control queries being issued to the drivers. For an overview of creating and configuring custom views, see User Defined Views .

SSL Configuration

Use SSL Configuration to adjust how Sync App handles TLS/SSL certificate negotiations. You can choose from various certificate formats;. For further information, see the SSLServerCert property under "Connection String Options" .

Firewall and Proxy

Configure the Sync App for compliance with Firewall and Proxy, including Windows proxies and HTTP proxies. You can also set up tunnel connections.

Query Processing

The Sync App offloads as much of the SELECT statement processing as possible to ADP and then processes the rest of the query in memory (client-side).

For further information, see Query Processing.

Logging

For an overview of configuration settings that can be used to refine CData logging, see Logging. Only two connection properties are required for basic logging, but there are numerous features that support more refined logging, which enables you to use the LogModules connection property to specify subsets of information to be logged.

Customizing the SSL Configuration

By default, the Sync App attempts to negotiate TLS with the server. The server certificate is validated against the default system trusted certificate store. You can override how the certificate gets validated using the SSLServerCert connection property.

To specify another certificate, see the SSLServerCert connection property.

Connecting Through a Firewall or Proxy

HTTP Proxies

To authenticate to an HTTP proxy, set the following:

• ProxyServer: the hostname or IP address of the proxy server that you want to route HTTP traffic through.
• ProxyPort: the TCP port that the proxy server is running on.
• ProxyAuthScheme: the authentication method the Sync App uses when authenticating to the proxy server.
• ProxyUser: the username of a user account registered with the proxy server.
• ProxyPassword: the password associated with the ProxyUser.

Other Proxies

Set the following properties:

• To use a proxy-based firewall, set FirewallType, FirewallServer, and FirewallPort.
• To tunnel the connection, set FirewallType to TUNNEL.
• To authenticate, specify FirewallUser and FirewallPassword.
• To authenticate to a SOCKS proxy, additionally set FirewallType to SOCKS5.

The CData Sync App models ADP objects as relational tables and views. An ADP object has relationships to other objects; in the tables, these relationships are expressed through foreign keys. The following sections show the available API objects and provide more information on executing SQL to ADP APIs.

Schemas for most database objects are defined in simple, text-based configuration files.

Tables

The Sync App models the data exposed by the ADP APIs as relational Tables.

Views

Views describes the available read-only views.

The Sync App models the data in ADP as a list of tables in a relational database that can be queried using standard SQL statements.

ADP Connector for CData Sync Tables

Name	Description
Input_AdditionalRemunerations	To create aggregates for WorkersWorkAssignments.AdditionalRemunerations using this as a TEMP table. This table values only last as long as the connection remains open. When the connection to ADP is closed, all tables names started with Input are cleared.
Input_configurationTags	Add configurationTags aggregate for Input_DeductionInputs.DeductionConfigurationTags OR Input_EarningInputs.EarningConfigurationTags OR Input_ReimbursementInputs.ReimbursementConfigurationTags using this as TEMP table. This table values only last as long as the connection remains open. When the connection to ADP is closed, all tables names started with Input are cleared.
Input_DeductionInputs	Create aggregates for PayrollRuns.DeductionInputs using this as a TEMP table. This table values only last as long as the connection remains open. When the connection to ADP is closed, all tables names started with Input are cleared.
Input_EarningInputs	Create aggregates for PayrollRuns.EarningInputs using this as a TEMP table. This table values only last as long as the connection remains open. When the connection to ADP is closed, all tables names started with Input are cleared.
Input_ReimbursementInputs	Create aggregates for PayrollRuns.ReimbursementInputs using this as a TEMP table. This table values only last as long as the connection remains open. When the connection to ADP is closed, all tables names started with Input are cleared.
PayrollRuns	Add and view the payroll runs.
Workers	Returns workers details.
WorkersPersonCommunicationEmails	Returns workers person communication emails.
WorkersPersonCommunicationFaxes	Returns workers person communication faxes.
WorkersPersonCommunicationLandlines	Returns workers person communication landlines.
WorkersPersonCommunicationMobiles	Returns workers person communication mobiles.
WorkersPersonCommunicationPagers	Returns workers person communication pagers.
WorkersWorkAssignments	Returns workers details.

To create aggregates for WorkersWorkAssignments.AdditionalRemunerations using this as a TEMP table. This table values only last as long as the connection remains open. When the connection to ADP is closed, all tables names started with Input are cleared.

Columns

Name	Type	ReadOnly	References	Description
RemunerationTypeCode	String	True
RemunerationTypeCodeName	String	True
RemunerationRate	Decimal	True
RemunerationCurrencyCode	String	True
effectiveDate	Date	True
NameCode	String	True	AdditionalRemunerationNameCode.CodeValue
InactiveIndicator	Boolean	True

Add configurationTags aggregate for Input_DeductionInputs.DeductionConfigurationTags OR Input_EarningInputs.EarningConfigurationTags OR Input_ReimbursementInputs.ReimbursementConfigurationTags using this as TEMP table. This table values only last as long as the connection remains open. When the connection to ADP is closed, all tables names started with Input are cleared.

Columns

Name	Type	ReadOnly	References	Description
TagCode	String	True
TagDataType	String	True
TagValues	String	True		Add comma separeted values with double quote
ReferenceNumber	Integer	True		Configuration tag reference number

Create aggregates for PayrollRuns.DeductionInputs using this as a TEMP table. This table values only last as long as the connection remains open. When the connection to ADP is closed, all tables names started with Input are cleared.

Columns

Name	Type	ReadOnly	References	Description
AssociateOID	String	True
PayrollGroupCode	String	True
DeductionCodeValue	String	True	DeductionInputCode.CodeValue
DeductionRateValue	Decimal	True
DeductionAmountcurrencyCode	String	True
DeductionBaseUnitCodeValue	String	True
DeductionConfigurationTags	String	True
ReferenceNumber	Integer	True		Configuration tag reference number.

Create aggregates for PayrollRuns.EarningInputs using this as a TEMP table. This table values only last as long as the connection remains open. When the connection to ADP is closed, all tables names started with Input are cleared.

Columns

Name	Type	ReadOnly	References	Description
AssociateOID	String	True
PayrollGroupCode	String	True
EarningCodeValue	String	True	EarningInputCode.CodeValue
RateValue	Decimal	True
RatecurrencyCode	String	True
NumberOfHours	String	True
EarningsAmountValue	Decimal	True
EarningsCurrencyCode	String	True
EarningConfigurationTags	String	True
ReferenceNumber	Integer	True		Configuration tag reference number

Create aggregates for PayrollRuns.ReimbursementInputs using this as a TEMP table. This table values only last as long as the connection remains open. When the connection to ADP is closed, all tables names started with Input are cleared.

Columns

Name	Type	ReadOnly	References	Description
AssociateOID	String	True
PayrollGroupCode	String	True
ReimbursementCodeValue	String	True	ReimbursementInputCode.CodeValue
ReimbursementAmountValue	Decimal	True
ReimbursementAmountCurrencyCode	String	True
ReimbursementConfigurationTags	String	True
ReferenceNumber	Integer	True		Configuration tag reference number

Add and view the payroll runs.

Table Specific Information

Select

The Sync App 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 Sync App.

• ItemID supports the '=' comparison.
• PayrollRegionCodeValue supports the '=' comparison.
• PayrollGroupCodeValue supports the '=' comparison.
• PayrollScheduleReferenceScheduleEntryID supports the '=' comparison.
• PayrollScheduleReferencePayrollWeekNumber supports the '=' comparison.
• PayrollScheduleReferencePayrollYear supports the '=' comparison.
• PayrollScheduleReferencePayrollRunNumber supports the '=' comparison.
• Level supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM PayrollRuns WHERE ItemID = 'TXSMIb+yh9UbJ9-im9au7g=='

SELECT * FROM PayrollRuns WHERE PayrollRegionCodeValue = 'BOST'

SELECT * FROM PayrollRuns WHERE PayrollGroupCodeValue = '3TN'

SELECT * FROM PayrollRuns WHERE PayrollScheduleReferenceScheduleEntryID = '20201117141612-l6OF8VuGHJD1ydLFoe5+nGBEm7rZkaRSorra0woRs04='

SELECT * FROM PayrollRuns WHERE PayrollScheduleReferencePayrollWeekNumber = '40'

SELECT * FROM PayrollRuns WHERE PayrollScheduleReferencePayrollYear = '2020'

SELECT * FROM PayrollRuns WHERE PayrollScheduleReferencePayrollRunNumber = '1'

SELECT * FROM PayrollRuns WHERE Level = 'payroll'

Insert

Following is an example of how to inserting pay data inputs into PayrollRuns table. For example:

INSERT INTO PayrollRuns (PayrollGroupCodeValue, PayrollProcessingJobID, AssociateOID, PayNumber, PayrollFileNumber, EarningInputs, DeductionInputs, ReimbursementInputs) VALUES ('3U7', 'TestProcessing', 'G3BGDF8JG32ERTGK', '1', '020024', '[{"earningCode":{"codeValue":"R"},"modifierCode":{"codeValue":"1"},"rate":{"rateValue":"44.50"},"configurationTags":[{"tagCode":"ShiftCode","tagValues":["1"]}],"numberOfHours":40},{"earningCode":{"codeValue":"O"},"modifierCode":{"codeValue":"2"},"numberOfHours":4}]', '[{"deductionCode":{"codeValue":"A"},"deductionRate":{"rateValue":9.5,"currencyCode":"USD"}}]', '[{"reimbursementCode":{"codeValue":"B"},"reimbursementAmount":{"amountValue":25,"currencyCode":"USD"}}]')

Inserting pay data inputs using Temp Table.

INSERT INTO PayrollRunsEarningInputs#TEMP (EarningCodeValue, RateValue, NumberOfHours) VALUES ('R', '50.50', '40');
INSERT INTO PayrollRunsDeductionInputs#TEMP (DeductionCodeValue, DeductionRateValue, DeductionAmountcurrencyCode) VALUES ('A', '10', 'USD');
INSERT INTO PayrollRunsReimbursementInputs#TEMP (ReimbursementCodeValue, ReimbursementAmountValue, ReimbursementAmountCurrencyCode) VALUES ('B', '25.00', 'USD');

INSERT INTO PayrollRuns (PayrollGroupCodeValue, PayrollProcessingJobID, PayrollWeekNumber, AssociateOID, PayNumber, PayrollFileNumber, EarningInputs, DeductionInputs,  ReimbursementInputs) VALUES ('3U7', 'TestProcessing', '53', 'G3BGDF8JG32ERTGK', '1', '020024', 'PayrollRunsEarningInputs#TEMP', 'PayrollRunsDeductionInputs#TEMP', 'PayrollRunsReimbursementInputs#TEMP');

Columns

Name	Type	ReadOnly	References	Description
ItemID [KEY]	String	True		The unique identifier of a instance within the collection.
PayrollProcessingJobID	String	False		The unique identifier of the related payroll processing job. This is generated as the result of the payrollProcessingJob.initiate event.
AlternateJobIDs	String	True
PayrollRegionCodeValue	String	True		The region in which the payroll is processed.
PayrollGroupCodeValue	String	False	PayrollGroup.Code	The payroll group code relevant to payroll processing.
PayrollGroupCodeShortName	String	True		Short description of the related code.
PayrollGroupCodeLongName	String	True		Long description of the related code.
PayrollScheduleReferencePayrollScheduleID	String	True		The unique identifier of the payroll schedule associated with the payroll output.
PayrollScheduleReferenceScheduleEntryID	String	True		The unique identifier of payroll schedule entry associated to the payroll schedule associated with the payroll output.
PayrollScheduleReferencePayrollWeekNumber	String	True		The week number for a payroll in the payroll schedule. This does not necessarily align with the calendar week number.
PayrollScheduleReferencePayrollYear	String	True		The year associated to a payroll in the payroll schedule.
PayrollScheduleReferencePayrollRunNumber	String	True		For a given payroll week number, this is the numbered run for that week.
PayrollProcessingJobStatusCodeValue	String	True		The Job status code of the payroll processing.
PayrollProcessingJobStatusCodeShortName	String	True		Short description of the related Job status code.
PayrollProcessingJobStatusCodelongName	String	True		Long description of the related Job status code.
AssociatePayments	String	True		This column will return data. If level set to detail.

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.

Name	Type	Description
level	String	The allowed values are payroll, pay, details, payDetails, acc, acc-all, error, dropped pay, wage garnishements.
AssociateOID	String	Payroll Insert Only
PayrollWeekNumber	String	Payroll Insert Only
PayrollFileNumber	String	Payroll Insert Only
PayNumber	String	Payroll Insert Only
EarningInputs	String	Payroll Insert Only. Following Modifier codes are supported for pay data input 1 - 'Hours 1 (Regular)', 2 - 'Hours 3 Code & Quantity', 3 - 'Hours 3 Code & Quantity', 4 - 'Hours 4 Code & Quantity', 7 - 'Earnings 3 Code & Amount', 8 - 'Earnings 4 Code & Amount', 9 - 'Earnings 5 Code & Amount', 24 - 'Temporary Hourly Rate'.
DeductionInputs	String	Payroll Insert Only
ReimbursementInputs	String	Payroll Insert Only

Returns workers details.

Table Specific Information

Select

The Sync App 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 Sync App.

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

For example, the following queries are processed server side:

SELECT * FROM Workers WHERE AssociateOID = 'G3349PZGBADQY8H7'

SELECT * FROM Workers WHERE WorkerID = 'DRH9M9NPW'

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

Insert

Following is an example of how to inserting into Workers table. For example:

INSERT INTO Workers (PayrollGroupCode, OnboardingTemplateCode, OnboardingTemplateCodeName, OnboardingStatusCode, OnboardingStatusCodeName,  HireReasonCode, HireReasonCodeName, WorkerOriginalHireDate, PersonLegalNameGivenName, PersonLegalNameFamilyName1, PersonBirthDate, PersonHighestEducationLevelCode) VALUES ('3UD', '15336_7354', 'HR Only (System)', 'complete', 'complete', 'new', 'TESTHIRE 4', '2020-11-10', 'TestGivenName', 'TestFamilyName', '1990-06-01', 'DOC')

Following is an example of how to inserting into Workers table with WorkAssignements. For example:

INSERT INTO WorkersWorkAssignments#TEMP (StandardHoursQuantity, PayCycleCodeValue, BaseRemunerationHourlyRateAmountValue, WageLawCoverageCodeValue, BaseRemunerationDailyRateAmountValue) VALUES ('45', '4', 300, 'N',  100)

INSERT INTO Workers (PayrollGroupCode, OnboardingTemplateCode, OnboardingTemplateCodeName, OnboardingStatusCode, OnboardingStatusCodeName, HireReasonCode, HireReasonCodeName, WorkerOriginalHireDate, PersonBirthDate, PersonLegalNameFamilyName1, PersonLegalNameGivenName, PersonDisabledIndicator, PersonGenderCode, PersonHighestEducationLevelCode, PersonLegalAddressCityName, PersonLegalAddressCountryCode, PersonLegalAddressCountrySubdivisionLevel1Code, PersonLegalAddressCountrySubdivisionLevel1SubdivisionType, PersonLegalAddressLineOne, PersonLegalAddressLineTwo, PersonLegalAddressLineThree, PersonLegalAddressNameCodeShortName, PersonLegalAddressPostalCode, PersonLegalNameFamilyName1Prefix, PersonLegalNameGenerationAffixCode, PersonLegalNameInitials, PersonLegalNameMiddleName, PersonLegalNameNickName, PersonLegalNameQualificationAffixCode, PersonMaritalStatusCode, PersonMilitaryDischargeDate, PersonMilitaryStatusCode, WorkAssignments) VALUES ('3TQ', '15336_7354', 'HR Only (System)', 'complete', 'complete', 'new', 'TESTHIRE 16', '2020-12-30', '1990-06-02', 'TestGivenName', 'TestFamilyName', 'FALSE', 'M', 'GRD', 'Millburn', 'US', 'NJ', 'state', 'LineOne', 'LineTwo', 'LineThree', 'Legal Residence', '07041', 'Prefix1', '2nd', 'I', 'MiddleName', 'NickName', 'CFA', 'M', '2013-04-01', '12', 'WorkersWorkAssignments#TEMP')

Update

Following is an example of how to Update a Workers table:

UPDATE Workers SET PersonLegalNameGenerationAffixCode = '2nd', PersonLegalNameGivenName = 'GivenName', PersonLegalNameFamilyName1 = 'FamilyName1', PersonLegalNameFamilyName1Prefix = 'Prefix1', PersonLegalNameFamilyName2 = 'FamilyName2', PersonLegalNameFamilyName2Prefix = 'Prefix2', PersonLegalNameInitials = 'C', PersonLegalNameMiddleName = 'MiddleName', PersonLegalNameNickName = 'NickName', PersonLegalNamePreferredSalutations = '[{"salutationCode":{"codeValue":"Mr."},"typeCode":{"shortName":"Social"},"sequenceNumber":1}]', PersonLegalNameQualificationAffixCode = 'CFA' WHERE AssociateOID = 'G3DXX3CRDERXK3C9'

UPDATE Workers SET PersonLegalAddressNameCodeShortName = 'Legal Residence', PersonLegalAddressLineOne = 'LineOne', PersonLegalAddressLineTwo = 'LineTwo', PersonLegalAddressCityName = 'Millburn',  PersonLegalAddressCountryCode = 'US', PersonLegalAddressCountrySubdivisionLevel1SubdivisionType = 'state', PersonLegalAddressPostalCode = '07041' WHERE AssociateOID = 'G3DXX3CRDERXK3C9'

UPDATE Workers SET PersonMaritalStatusCode = 'M', PersonMaritalStatusEffectiveDateTime = '2020-12-01T00:00:00Z' WHERE AssociateOID = 'G3DXX3CRDERXK3C9'

UPDATE Workers SET  PersonHighestEducationLevelCode = 'GRD' WHERE AssociateOID = 'G3DXX3CRDERXK3C9'

UPDATE Workers SET  PersonGenderCode = 'M' WHERE AssociateOID = 'G3DXX3CRDERXK3C9'

UPDATE Workers SET PersonBirthDate = '1990-06-01' WHERE AssociateOID = 'G3DXX3CRDERXK3C9'

UPDATE Workers SET PersonMilitaryClassificationCodes = '[{"codeValue":"R"}]' WHERE AssociateOID = 'G3DXX3CRDERXK3C9'

Columns

Name	Type	ReadOnly	References	Description
AssociateOID [KEY]	String	True
WorkerID	String	True
WorkAssignments	String	False
WorkerAcquisitionDate	Date	True
WorkerAdjustedServiceDate	Date	True
WorkerExpectedTerminationDate	Date	True
WorkerOriginalHireDate	Date	False
WorkerRehireDate	Date	True
WorkerRetirementDate	Date	True
WorkerTerminationDate	Date	True
WorkerStatusEffectiveDate	Date	True
WorkerStatusReasonCode	String	True
WorkerStatusReasonLongName	String	True
WorkerStatusReasonShortName	String	True
WorkerStatusStatusCode	String	True
WorkerStatusStatusLongName	String	True
WorkerStatusStatusShortName	String	True
Photos	String	True
BusinessCommunicationEmails	String	False
BusinessCommunicationFaxes	String	False
BusinessCommunicationLandlines	String	False
BusinessCommunicationMobiles	String	False
BusinessCommunicationPagers	String	False
PersonAlternatePreferredNames	String	True
PersonCommunicationEmails	String	False
PersonCommunicationFaxes	String	False
PersonCommunicationLandlines	String	False
PersonCommunicationMobiles	String	False
PersonCommunicationPagers	String	False
PersonDeathDate	Date	True
PersonDeceasedIndicator	Boolean	True
PersonDisabilityIdentificationDeclinedIndicator	Boolean	True
PersonDisabilityPercentage	Integer	True
PersonDisabilityTypeCodes	String	False
PersonDisabledIndicator	Boolean	False
PersonGenderCode	String	False		The allowed values are M, F, N.
PersonGenderLongName	String	True
PersonGenderShortName	String	True
PersonGovernmentIDs	String	False
PersonHighestEducationLevelCode	String	False	HighestEducationLevelCode.CodeValue
PersonHighestEducationLevelLongName	String	True
PersonHighestEducationLevelShortName	String	True
PersonIdentityDocuments	String	True
PersonImmigrationDocuments	String	True
PersonLegalAddressCityName	String	False
PersonLegalAddressCountryCode	String	False
PersonLegalAddressCountrySubdivisionLevel1Code	String	False
PersonLegalAddressCountrySubdivisionLevel1LongName	String	False
PersonLegalAddressCountrySubdivisionLevel1ShortName	String	False
PersonLegalAddressCountrySubdivisionLevel1SubdivisionType	String	False
PersonLegalAddressCountrySubdivisionLevel2Code	String	False
PersonLegalAddressCountrySubdivisionLevel2LongName	String	False
PersonLegalAddressCountrySubdivisionLevel2ShortName	String	False
PersonLegalAddressCountrySubdivisionLevel2SubdivisionType	String	False
PersonLegalAddressDeliveryPoint	String	False
PersonLegalAddressLineOne	String	False
PersonLegalAddressLineTwo	String	False
PersonLegalAddressLineThree	String	False
PersonLegalAddressNameCodeValue	String	False
PersonLegalAddressNameCodeLongName	String	True
PersonLegalAddressNameCodeShortName	String	False
PersonLegalAddressPostalCode	String	False
PersonLegalAddressSameAsAddressIndicator	Boolean	False
PersonLegalAddressSameAsAddressLinkCanonicalUri	String	False
PersonLegalAddressSameAsAddressLinkEncType	String	False
PersonLegalAddressSameAsAddressLinkHref	String	False
PersonLegalAddressSameAsAddressLinkMediaType	String	False
PersonLegalAddressSameAsAddressLinkMethod	String	False
PersonLegalAddressSameAsAddressLinkPayLoadArguments	String	False
PersonLegalAddressSameAsAddressLinkRel	String	False
PersonLegalAddressSameAsAddressLinkSchema	String	False
PersonLegalAddressSameAsAddressLinkTargetSchema	String	False
PersonLegalAddressSameAsAddressLinkTitle	String	False
PersonLegalNameFamilyName1	String	False
PersonLegalNameFamilyName1Prefix	String	False
PersonLegalNameFamilyName2	String	False
PersonLegalNameFamilyName2Prefix	String	False
PersonLegalNameFormattedName	String	False
PersonLegalNameGenerationAffixCode	String	False	GenerationAffixCode.CodeValue
PersonLegalNameGenerationAffixLongName	String	True
PersonLegalNameGenerationAffixShortName	String	True
PersonLegalNameGivenName	String	False
PersonLegalNameInitials	String	False
PersonLegalNameMiddleName	String	False
PersonLegalNameCode	String	False
PersonLegalNameLongName	String	True
PersonLegalNameShortName	String	False
PersonLegalNameNickName	String	False
PersonLegalNamePreferredSalutations	String	False
PersonLegalNameQualificationAffixCode	String	False	QualificationAffixCode.CodeValue
PersonLegalNameQualificationAffixLongName	String	False
PersonLegalNameQualificationAffixShortName	String	False
PersonLinks	String	True
PersonMaritalStatusCode	String	False	MaritalStatusCode.CodeValue
PersonMaritalStatusEffectiveDateTime	Datetime	False
PersonMaritalStatusLongName	String	True
PersonMaritalStatusShortName	String	False	MaritalStatusCode.ShortName
PersonMilitaryClassificationCodes	String	False		Supported values: Disabled Veteran, Active Duty Wartime or Campaign Badge Veteran, Armed Forces Service Medal Veteran, Recently Separated Veteran.
PersonMilitaryDischargeDate	Date	False
PersonMilitaryStatusCode	String	False
PersonMilitaryStatusEffectiveDate	Datetime	True
PersonMilitaryStatusLongName	String	True
PersonMilitaryStatusShortName	String	False
PersonOtherPersonalAddresses	String	False
PersonPassports	String	False
PersonPreferredNameFamilyName1	String	True
PersonPreferredNameFamilyName1Prefix	String	True
PersonPreferredNameFamilyName2	String	True
PersonPreferredNameFamilyName2Prefix	String	True
PersonPreferredNameFormattedName	String	True
PersonPreferredNameGenerationAffixCode	String	True
PersonPreferredNameGenerationAffixLongName	String	True
PersonPreferredNameGenerationAffixShortName	String	True
PersonPreferredNameGivenName	String	True
PersonPreferredNameInitials	String	True
PersonPreferredNameMiddleName	String	True
PersonPreferredNameCode	String	True
PersonPreferredNameLongName	String	True
PersonPreferredNameShortName	String	True
PersonPreferredNameNickName	String	True
PersonPreferredNamePreferredSalutations	String	True
PersonPreferredNameQualificationAffixCode	String	True
PersonPreferredNameQualificationAffixLongName	String	True
PersonPreferredNameQualificationAffixShortName	String	True
PersonPreferredNameScriptCode	String	True
PersonPreferredNameScriptLongName	String	True
PersonPreferredNameScriptShortName	String	True
PersonPreferredNameTitleAffixCodes	String	True
PersonPreferredNameTitlePrefixCodes	String	True
PersonReligionCode	String	True
PersonReligionLongName	String	True
PersonReligionShortName	String	True
PersonResidencyCountryCodes	String	True
PersonSexualOrientationCode	String	True
PersonSexualOrientationLongName	String	True
PersonSexualOrientationShortName	String	True
PersonSocialInsurancePrograms	String	True
PersonStudentIndicator	Boolean	True
PersonStudentStatusCode	String	True
PersonStudentStatusEffectiveDate	Date	True
PersonStudentStatusLongName	String	True
PersonStudentStatusShortName	String	True
PersonTobaccoUserIndicator	Boolean	True
PersonWorkAuthorizationDocuments	String	True
Links	String	True
AsOfDate	Date	True

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.

Name	Type	Description
PayrollGroupCode	String	Insert Only
OnboardingTemplateCode	String	Insert Only
OnboardingTemplateCodeName	String	Insert Only
OnboardingStatusCode	String	Insert Only
OnboardingStatusCodeName	String	Insert Only
HireReasonCode	String	Insert Only
HireReasonCodeName	String	Insert Only

Returns workers person communication emails.

Table Specific Information

Select

The Sync App 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 Sync App.

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

For example, the following queries are processed server side:

SELECT * FROM WorkersPersonCommunicationEmails WHERE AssociateOID = 'G3349PZGBADQY8H7'

SELECT * FROM WorkersPersonCommunicationEmails WHERE WorkerID = 'DRH9M9NPW'

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

Update

Following is an example of how to Update a WorkersPersonCommunicationEmails table:

UPDATE WorkersPersonCommunicationEmails SET EmailUri = '[email protected]' WHERE AssociateOID = 'G3349PZGBADQY8H8'

Columns

Name	Type	ReadOnly	References	Description
AssociateOID [KEY]	String	True	Workers.AssociateOID
WorkerID	String	True	Workers.WorkerID
EmailUri	String	False
ItemID	String	True
NameCode	String	True
NameCodeLongName	String	True
NameCodeShortName	String	True
NotificationIndicator	Boolean	True
AsOfDate	Date	True

Returns workers person communication faxes.

Table Specific Information

Select

The Sync App 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 Sync App.

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

For example, the following queries are processed server side:

SELECT * FROM WorkersPersonCommunicationFaxes WHERE AssociateOID = 'G3349PZGBADQY8H7'

SELECT * FROM WorkersPersonCommunicationFaxes WHERE WorkerID = 'DRH9M9NPW'

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

Update

Following is an example of how to Update a WorkersPersonCommunicationFaxes table:

UPDATE WorkersPersonCommunicationFaxes SET AreaDialing = '232', DialNumber = '1234567' WHERE AssociateOID = 'G3349PZGBADQY8H8'

Columns

Name	Type	ReadOnly	References	Description
AssociateOID [KEY]	String	True	Workers.AssociateOID
WorkerID	String	True	Workers.WorkerID
Access	String	False
AreaDialing	String	False
CountryDialing	String	False
DialNumber	String	False
Extension	String	False
FormattedNumber	String	True
ItemID	String	True
NameCode	String	True
NameCodeLongName	String	True
NameCodeShortName	String	True
NotificationIndicator	Boolean	True
AsOfDate	Date	True

Returns workers person communication landlines.

Table Specific Information

Select

The Sync App 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 Sync App.

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

For example, the following queries are processed server side:

SELECT * FROM WorkersPersonCommunicationLandlines WHERE AssociateOID = 'G3349PZGBADQY8H7'

SELECT * FROM WorkersPersonCommunicationLandlines WHERE WorkerID = 'DRH9M9NPW'

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

Update

Following is an example of how to Update a WorkersPersonCommunicationLandlines table:

UPDATE WorkersPersonCommunicationLandlines SET AreaDialing = '232', DialNumber = '1234567' WHERE AssociateOID = 'G3349PZGBADQY8H8'

Columns

Name	Type	ReadOnly	References	Description
AssociateOID [KEY]	String	True	Workers.AssociateOID
WorkerID	String	True	Workers.WorkerID
Access	String	False
AreaDialing	String	False
CountryDialing	String	False
DialNumber	String	False
Extension	String	False
FormattedNumber	String	True
ItemID	String	True
NameCode	String	True
NameCodeLongName	String	True
NameCodeShortName	String	True
NotificationIndicator	Boolean	True
AsOfDate	Date	True

Returns workers person communication mobiles.

Table Specific Information

Select

The Sync App 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 Sync App.

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

For example, the following queries are processed server side:

SELECT * FROM WorkersPersonCommunicationMobiles WHERE AssociateOID = 'G3349PZGBADQY8H7'

SELECT * FROM WorkersPersonCommunicationMobiles WHERE WorkerID = 'DRH9M9NPW'

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

Update

Following is an example of how to Update a WorkersPersonCommunicationMobiles table:

UPDATE WorkersPersonCommunicationMobiles SET AreaDialing = '232', DialNumber = '1234567' WHERE AssociateOID = 'G3349PZGBADQY8H8'

Columns

Name	Type	ReadOnly	References	Description
AssociateOID [KEY]	String	True	Workers.AssociateOID
WorkerID	String	True	Workers.WorkerID
Access	String	False
AreaDialing	String	False
CountryDialing	String	False
DialNumber	String	False
Extension	String	False
FormattedNumber	String	True
ItemID	String	True
NameCode	String	True
NameCodeLongName	String	True
NameCodeShortName	String	True
NotificationIndicator	Boolean	True
AsOfDate	Date	True

Returns workers person communication pagers.

Table Specific Information

Select

The Sync App 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 Sync App.

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

For example, the following queries are processed server side:

SELECT * FROM WorkersPersonCommunicationPagers WHERE AssociateOID = 'G3349PZGBADQY8H7'

SELECT * FROM WorkersPersonCommunicationPagers WHERE WorkerID = 'DRH9M9NPW'

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

Update

Following is an example of how to Update a WorkersPersonCommunicationPagers table:

UPDATE WorkersPersonCommunicationPagers SET AreaDialing = '232', DialNumber = '1234567' WHERE AssociateOID = 'G3349PZGBADQY8H8'

Columns

Name	Type	ReadOnly	References	Description
AssociateOID [KEY]	String	True	Workers.AssociateOID
WorkerID	String	True	Workers.WorkerID
Access	String	False
AreaDialing	String	False
CountryDialing	String	False
DialNumber	String	False
Extension	String	False
FormattedNumber	String	True
ItemID	String	True
NameCode	String	True
NameCodeLongName	String	True
NameCodeShortName	String	True
NotificationIndicator	Boolean	True
AsOfDate	Date	True

Returns workers details.

Table Specific Information

Select

The Sync App 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 Sync App.

• 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
WorkerIdValue	String	True	Workers.WorkerID
ItemID [KEY]	String	False
ActualStartDate	Date	True
CompaRatio	Integer	True
AdditionalRemunerations	String	False
AnnualBenefitBaseRateAmountValue	Integer	True
AnnualBenefitBaseRateCurrencyCode	String	True
AnnualBenefitBaseRateNameCodeValue	String	True
AnnualBenefitBaseRateNameCodeLongName	String	True
AnnualBenefitBaseRateNameCodeShortName	String	True
AssignedOrganizationalUnits	String	False
AssignedWorkLocations	String	True
AssignmentCostCenters	String	True
AssignmentStatusEffectiveDate	Date	True
AssignmentStatusReasonCodeValue	String	False
AssignmentStatusReasonCodeLongName	String	True
AssignmentStatusReasonCodeShortName	String	True
AssignmentStatusStatusCodeValue	String	True
AssignmentStatusStatusCodeLongName	String	True
AssignmentStatusStatusCodeShortName	String	True
AssignmentTermCodeValue	String	True
AssignmentTermCodeLongName	String	True
AssignmentTermCodeShortName	String	True
BargainingUnitBargainingUnitCodeValue	String	False
BargainingUnitBargainingUnitCodeLongName	String	True
BargainingUnitBargainingUnitCodeShortName	String	False
BargainingUnitSeniorityDate	Date	False
BaseRemunerationAnnualRateAmountValue	Decimal	True
BaseRemunerationAnnualRateAmountCurrencyCode	String	True
BaseRemunerationAnnualRateAmountNameCodeValue	String	True
BaseRemunerationAnnualRateAmountNameCodeLongName	String	True
BaseRemunerationAnnualRateAmountNameCodeShortName	String	True
BaseRemunerationAssociatedRateQualifiers	String	True
BaseRemunerationBiweeklyRateAmountValue	Decimal	True
BaseRemunerationBiweeklyRateAmountCurrencyCode	String	True
BaseRemunerationBiweeklyRateAmountNameCodeLongName	String	True
BaseRemunerationBiweeklyRateAmountNameCodeValue	String	True
BaseRemunerationBiweeklyRateAmountNameCodeShortName	String	True
BaseRemunerationCommissionRatePercentageBaseUnitCodeValue	String	True
BaseRemunerationCommissionRatePercentageBaseUnitCodeLongName	String	True
BaseRemunerationCommissionRatePercentageBaseUnitCodeShortName	String	True
BaseRemunerationCommissionRatePercentageNameCodeValue	String	True
BaseRemunerationCommissionRatePercentageNameCodeLongName	String	True
BaseRemunerationCommissionRatePercentageNameCodeShortName	String	True
BaseRemunerationCommissionRatePercentagePercentageValue	Integer	True
BaseRemunerationDailyRateAmountValue	Decimal	False
BaseRemunerationDailyRateAmountCurrencyCode	String	True
BaseRemunerationDailyRateAmountNameCodeValue	String	False
BaseRemunerationDailyRateAmountNameCodeLongName	String	True
BaseRemunerationDailyRateAmountNameCodeShortName	String	True
BaseRemunerationEffectiveDate	Date	False
BaseRemunerationHourlyRateAmountValue	Decimal	False
BaseRemunerationHourlyRateAmountCurrencyCode	String	True
BaseRemunerationHourlyRateAmountNameCodeValue	String	True
BaseRemunerationHourlyRateAmountNameCodeLongName	String	True
BaseRemunerationHourlyRateAmountNameCodeShortName	String	True
BaseRemunerationMonthlyRateAmountValue	Decimal	True
BaseRemunerationMonthlyRateAmountCurrencyCode	String	True
BaseRemunerationMonthlyRateAmountNameCodeValue	String	False
BaseRemunerationMonthlyRateAmountNameLongName	String	True
BaseRemunerationMonthlyRateAmountNameShortName	String	False
BaseRemunerationPayPeriodRateAmountValue	Decimal	True
BaseRemunerationPayPeriodRateAmountCurrencyCode	String	True
BaseRemunerationPayPeriodRateAmountNameCodeValue	String	True
BaseRemunerationPayPeriodRateAmountNameCodeLongName	String	True
BaseRemunerationPayPeriodRateAmountNameCodeShortName	String	True
BaseRemunerationRecordingBasisCodeValue	String	True
BaseRemunerationRecordingBasisCodelongName	String	True
BaseRemunerationRecordingBasisCodeShortName	String	True
BaseRemunerationSemiMonthlyRateAmountValue	Decimal	True
BaseRemunerationSemiMonthlyRateAmountCurrencyCode	String	True
BaseRemunerationSemiMonthlyRateAmountNameCodeValue	String	True
BaseRemunerationSemiMonthlyRateAmountNameCodeLongName	String	True
BaseRemunerationSemiMonthlyRateAmountNameCodeShortName	String	True
BaseRemunerationWeeklyRateAmountValue	Decimal	True
BaseRemunerationWeeklyRateAmountCurrencyCode	String	True
BaseRemunerationWeeklyRateAmountNameCodeValue	String	True
BaseRemunerationWeeklyRateAmountNameCodeLongName	String	True
BaseRemunerationWeeklyRateAmountNameCodeShortName	String	True
ExecutiveIndicator	Boolean	True
ExecutiveTypeCodeValue	String	True
ExecutiveTypeCodeLongName	String	True
ExecutiveTypeCodeShortName	String	True
ExpectedStartDate	Date	True
ExpectedTerminationDate	Date	True
FullTimeEquivalenceRatio	Integer	True
GeographicPayDifferentialCodeValue	String	True
GeographicPayDifferentialCodeLongName	String	True
GeographicPayDifferentialCodeShortName	String	True
GeographicPayDifferentialPercentage	Integer	True
HighlyCompensatedIndicator	Boolean	True
HighlyCompensatedTypeCodeValue	String	True
HighlyCompensatedTypeCodeLongName	String	True
HighlyCompensatedTypeCodeShortName	String	True
HireDate	Date	True
HomeOrganizationalUnits	String	False
HomeWorkLocationAddressAttentionOfName	String	True
HomeWorkLocationAddressBlockName	String	True
HomeWorkLocationAddressBuildingName	String	True
HomeWorkLocationAddressBuildingNumber	String	True
HomeWorkLocationAddressCareOfName	String	True
HomeWorkLocationAddressCityName	String	False
HomeWorkLocationAddressCountryCode	String	False
HomeWorkLocationAddressCountrySubdivisionLevel1CodeValue	String	False
HomeWorkLocationAddressCountrySubdivisionLevel1LongName	String	True
HomeWorkLocationAddressCountrySubdivisionLevel1ShortName	String	False
HomeWorkLocationAddressCountrySubdivisionLevel1SubdivisionType	String	False
HomeWorkLocationAddressCountrySubdivisionLevel2CodeValue	String	False
HomeWorkLocationAddressCountrySubdivisionLevel2LongName	String	True
HomeWorkLocationAddressCountrySubdivisionLevel2ShortName	String	False
HomeWorkLocationAddressCountrySubdivisionLevel2SubdivisionType	String	False
HomeWorkLocationAddressDeliveryPoint	String	True
HomeWorkLocationAddressDoor	String	True
HomeWorkLocationAddressFloor	String	True
HomeWorkLocationAddressGeoCoordinateLatitude	Integer	True
HomeWorkLocationAddressGeoCoordinateLongitude	Integer	True
HomeWorkLocationAddressLineFive	String	True
HomeWorkLocationAddressLineFour	String	True
HomeWorkLocationAddressLineOne	String	False
HomeWorkLocationAddressLineTwo	String	False
HomeWorkLocationAddressLineThree	String	False
HomeWorkLocationAddressNameCodeValue	String	True
HomeWorkLocationAddressNameCodeLongName	String	True
HomeWorkLocationAddressNameCodeShortName	String	True
HomeWorkLocationAddressPlotID	String	True
HomeWorkLocationAddressPostalCode	String	False
HomeWorkLocationAddressPostOfficeBox	String	True
HomeWorkLocationAddressScriptCodeValue	String	True
HomeWorkLocationAddressScriptCodeLongName	String	True
HomeWorkLocationAddressScriptCodeShortName	String	True
HomeWorkLocationAddressStairCase	String	True
HomeWorkLocationAddressStreetName	String	True
HomeWorkLocationAddressStreetTypeCodeValue	String	True
HomeWorkLocationAddressStreetTypeCodeLongName	String	True
HomeWorkLocationAddressStreetTypeCodeShortName	String	True
HomeWorkLocationAddressUnit	String	True
HomeWorkLocationCommunicationEmails	String	True
HomeWorkLocationCommunicationFaxes	String	True
HomeWorkLocationCommunicationLandlines	String	True
HomeWorkLocationCommunicationMobiles	String	True
HomeWorkLocationCommunicationPagers	String	True
HomeWorkLocationNameCodeValue	String	False
HomeWorkLocationNameCodeLongName	String	True
HomeWorkLocationNameCodeShortName	String	False
IndustryClassifications	String	False
JobCodeValue	String	False
JobCodeEffectiveDate	Date	True
JobCodeLongName	String	True
JobCodeShortName	String	False
JobTitle	String	True
LaborUnionLaborUnionCodeValue	String	False
LaborUnionLaborUnionCodeLongName	String	True
LaborUnionLaborUnionCodeShortName	String	False
LaborUnionSeniorityDate	Date	True
LegalEntityID	String	True
Links	String	True
ManagementPositionIndicator	Boolean	False
MinimumPayGradeStepDuration	String	True
NationalityContextCodeValue	String	True
NationalityContextCodeLongName	String	True
NationalityContextCodeShortName	String	True
NextPayGradeStepDate	Date	True
OccupationalClassifications	String	False
OfferAcceptanceDate	Date	True
OfferExtensionDate	Date	True
OfficerIndicator	Boolean	True
OfficerTypeCodeValue	String	False
OfficerTypeCodeLongName	String	True
OfficerTypeCodeShortName	String	False
PayCycleCodeValue	String	False
PayCycleCodeLongName	String	True
PayCycleCodeShortName	String	False
PayGradeCodeValue	String	False
PayGradeCodeLongName	String	True
PayGradeCodeShortName	String	False
PayGradePayRangeMaximumRateAmountValue	Decimal	True
PayGradePayRangeMaximumRateBaseMultiplierValue	Integer	True
PayGradePayRangeMaximumRateBaseUnitCodeValue	String	True
PayGradePayRangeMaximumRateBaseUnitCodeLongName	String	True
PayGradePayRangeMaximumRateBaseUnitCodeShortName	String	True
PayGradePayRangeMaximumRateCurrencyCode	String	True
PayGradePayRangeMaximumRateUnitCodeValue	String	True
PayGradePayRangeMaximumRateUnitCodeLongName	String	True
PayGradePayRangeMaximumRateUnitCodeShortName	String	True
PayGradePayRangeMedianRateAmountValue	Decimal	True
PayGradePayRangeMedianRateBaseMultiplierValue	Integer	True
PayGradePayRangeMedianRateBaseUnitCodeValue	String	True
PayGradePayRangeMedianRateBaseUnitCodeLongName	String	True
PayGradePayRangeMedianRateBaseUnitCodeShortName	String	True
PayGradePayRangeMedianRateCcurrencyCode	String	True
PayGradePayRangeMedianRateUnitCodeValue	String	True
PayGradePayRangeMedianRateUnitCodeLongName	String	True
PayGradePayRangeMedianRateUnitCodeShortName	String	True
PayGradePayRangeMinimumRateAmountValue	Decimal	True
PayGradePayRangeMinimumRateBaseMultiplierValue	Integer	True
PayGradePayRangeMinimumRateBaseUnitCodeValue	String	True
PayGradePayRangeMinimumRateBaseUnitCodeLongName	String	True
PayGradePayRangeMinimumRateBaseUnitCodeShortName	String	True
PayGradePayRangeMinimumRateCurrencyCode	String	True
PayGradePayRangeMinimumRateUnitCodeValue	String	True
PayGradePayRangeMinimumRateUnitCodeLongName	String	True
PayGradePayRangeMinimumRateUnitCodeShortName	String	True
PayGradeStepCodeValue	String	True
PayGradeStepCodeLongName	String	True
PayGradeStepCodeShortName	String	True
PayGradeStepPayRateAmountValue	Decimal	True
PayGradeStepPayRateBaseMultiplierValue	Integer	True
PayGradeStepPayRateBaseUnitCodeValue	String	True
PayGradeStepPayRateBaseUnitCodeLongName	String	True
PayGradeStepPayRateBaseUnitCodeShortName	String	True
PayGradeStepPayRateCurrencyCode	String	True
PayGradeStepPayRateUnitCodeValue	String	True
PayGradeStepPayRateUnitCodeLongName	String	True
PayGradeStepPayRateUnitCodeShortName	String	True
PayrollFileNumber	String	False
PayrollGroupCode	String	False
PayrollProcessingStatusCodeValue	String	True
PayrollProcessingStatusCodeEffectiveDate	Date	True
PayrollProcessingStatusCodeLongName	String	True
PayrollProcessingStatusCodeShortName	String	True
PayrollRegionCode	String	True
PayrollScheduleGroupID	String	True
PayScaleCodeValue	String	True
PayScaleCodeLongName	String	True
PayScaleCodeShortName	String	True
PositionID	String	False
PositionTitle	String	True
PrimaryIndicator	Boolean	True
RemunerationBasisCodeValue	String	True
RemunerationBasisCodeLongName	String	True
RemunerationBasisCodeShortName	String	True
ReportsTo	String	False
SeniorityDate	Date	True
StandardHoursQuantity	Integer	False
StandardHoursUnitCodeValue	String	True
StandardHoursUnitCodeLongName	String	True
StandardHoursUnitCodeShortName	String	True
StandardPayPeriodHoursHoursQuantity	Integer	True
StandardPayPeriodHoursUnitCodeValue	String	True
StandardPayPeriodHoursUnitCodeLongName	String	True
StandardPayPeriodHoursUnitCodeShortName	String	True
StockOwnerIndicator	Boolean	True
StockOwnerPercentage	Integer	True
TerminationDate	Date	False
VipIndicator	Boolean	True
VipTypeCodeValue	String	True
VipTypeCodeLongName	String	True
VipTypeCodeShortName	String	True
WageLawCoverageCodeValue	String	False	WageLawCoverageCode.CodeValue
WageLawCoverageCodeLongName	String	True
WageLawCoverageCodeShortName	String	False
WageLawCoverageWageLawNameCodeValue	String	True
WageLawCoverageWageLawNameCodeLongName	String	True
WageLawCoverageWageLawNameCodeShortName	String	True
WorkArrangementCodeValue	String	True
WorkArrangementCodeLongName	String	True
WorkArrangementCodeShortName	String	True
WorkerGroups	String	True
WorkerProbationIndicator	Boolean	True
WorkerProbationPeriodEndDate	Date	True
WorkerProbationPeriodStartDate	Date	True
WorkerTypeCodeValue	String	False	WorkerTypeCode.CodeValue
WorkerTypeCodeLongName	String	True
WorkerTypeCodeShortName	String	True
WorkLevelCodeValue	String	True
WorkLevelCodeLongName	String	True
WorkLevelCodeShortName	String	True
WorkShiftCodeValue	String	True
WorkShiftCodeLongName	String	True
WorkShiftCodeShortName	String	True
JobFunctionCodeValue	String	True
JobFunctionCodeShortName	String	True
JobFunctionCodeLongName	String	True
AsOfDate	Date	True

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.

Name	Type	Description
EffectiveDate	Date	To update positionid and AssignedOrganizationalUnits
LastWorkedDate	Date	Worker Termination Update
RehireEligibleIndicator	Boolean	Worker Termination Update
SeveranceEligibleIndicator	Boolean	Worker Termination Update
TerminationComments	String	Worker Termination Update
BaseRemunerationCode	String
EventReasonCode	String

Views are similar to tables in the way that data is represented; however, views are read-only.

Queries can be executed against a view as if it were a normal table.

ADP Connector for CData Sync Views

Name	Description
AdditionalRemunerationNameCode	Additional remuneration name code.
AssociatePaymentsAllocationsEarningsAndBenefits	View the associate payment allocation earnings and benefits in the payroll outputs.
AssociatePaymentsAllocationsEarningSections	View the earning sections for the associate payments allocations in payroll outputs.
AssociatePaymentsAllocationsNonStatutoryDeductions	View the non-statutory deductions for the associate payments allocations in payroll outputs.
AssociatePaymentsAllocationsStatutoryDeductions	View the statutory deductions for the associate payments allocations in payroll outputs.
AssociatePaymentsSummaryEarningsAndBenefits	View the AssociatePayments Earnings and Benefits in the payroll outputs.
AssociatePaymentsSummaryEarningsSections	View the associate payments earnings sections items in the payroll outputs.
AssociatePaymentsSummaryNonStatutoryDeductions	To view the non statutory deduction for the associate in payroll outputs.
AssociatePaymentsSummaryPayrollAccumulations	To View the associate payments payroll accumulations in the payroll outputs.
AssociatePaymentsSummaryStatutoryDeductions	View the statutory deduction for the associate in payroll outputs.
CostCenters	Returns all Cost number codes setup for the client.
DeductionInputCode	Returns deduction input code.
EarningInputCode	Returns earning input code.
GenerationAffixCode	Returns legal name generation affix code.
HighestEducationLevelCode	Returns highest education level code value.
JobApplications	Returns a list of job applications.
JobApplicationsCommunicationLandlines	Returns a list of job applications communication landlines.
JobApplicationsCommunicationMobiles	Returns a list of job applications communication mobiles.
jobRequisitions	Returns a list of job requisitions.
JobRequisitionsOrganizationalUnits	View the organizational unit entries in Job Requisitions.
MaritalStatusCode	Returns marital status codes.
OnboardingTemplate	Returns onboarding template.
PaidTimeOffBalances	Returns Paid TimeOff Balances.
PaidTimeOffRequestEntries	Returns PaidTimeOff Requests.
PaidTimeOffRequests	Returns PaidTimeOff Requests.
PayrollGroup	Returns payroll group.
PayrollMemos	View the payroll memos.
PersonalContacts	Personal emergency contacts.
QualificationAffixCode	Returns work assignement worker type codes.
ReimbursementInputCode	Returns reimbursement input code.
TeamTimeCards	View the Team Time Cards.
TeamTimeCardsAllTeams	View the Team Time Cards of all teams.
TeamTimeCardsDailyTotals	View the Team Time Cards daily totals aggregate.
TeamTimeCardsDayEntries	View the Team Time Cards daily totals aggregate with day entries.
TeamTimeCardsHomeLaborAllocations	View the Team Time Cards period totals aggregate.
TeamTimeCardsPeriodTotals	View the Team Time Cards period totals aggregate.
TimeCards	View the worker Time Cards.
TimeCardsAllActiveWorkers	View the Time Cards of all active workers.
TimeCardsDailyTotals	View the worker Time Cards daily totals aggregate.
TimeCardsPeriodTotals	View the worker Time Cards period totals aggregate.
WageLawCoverageCode	Returns wage law coverage codes.
WorkAssignmentCustomHistoryCustomGroupAmountFields	Work assignment CustomGroup amount.
WorkAssignmentCustomHistoryCustomGroupCodeFields	Work assignment CustomGroup code.
WorkAssignmentCustomHistoryCustomGroupDateFields	Work assignment CustomGroup date.
WorkAssignmentCustomHistoryCustomGroupDateTimeFields	Work assignment CustomGroup date time.
WorkAssignmentCustomHistoryCustomGroupIndicatorFields	Work assignment CustomGroup indicator.
WorkAssignmentCustomHistoryCustomGroupLinks	Work assignment CustomGroup links.
WorkAssignmentCustomHistoryCustomGroupNumberFields	Work assignment CustomGroup number.
WorkAssignmentCustomHistoryCustomGroupPercentFields	Work assignment CustomGroup percent.
WorkAssignmentCustomHistoryCustomGroupStringFields	Work assignment CustomGroup string.
WorkAssignmentCustomHistoryCustomGroupTelephoneFields	Work assignment CustomGroup telephone.
WorkAssignmentHistory	Work assignment history.
WorkAssignmentHistoryAdditionalRemunerations	Work assignment additionsla remunerations history.
WorkAssignmentHistoryAssignedOrganizationalUnits	Work assignment organization units history.
WorkAssignmentHistoryAssignedWorkLocations	Work assignment Assigned locations history.
WorkAssignmentHistoryCommunicationsEmails	Work assignment communication history mail.
WorkAssignmentHistoryCommunicationsFaxes	Work assignment communication Fax History.
WorkAssignmentHistoryCommunicationsInstantMessages	Work assignment communication message History.
WorkAssignmentHistoryCommunicationsInternetAddresses	Work assignment communication Internet address History.
WorkAssignmentHistoryCommunicationsLandlines	Work assignment communication landline history.
WorkAssignmentHistoryCommunicationsMobiles	Work assignment communication mobile History.
WorkAssignmentHistoryCommunicationsPagers	Work assignment communication Pager History.
WorkAssignmentHistoryCommunicationsSocialNetworks	Work assignment communication social network history.
WorkAssignmentHistoryHomeOrganizationalUnits	Work assignment Home organization history.
WorkAssignmentHistoryIndustryClassifications	Work assignment industry classification history.
WorkAssignmentHistoryOccupationalClassifications	Work assignment occupational classification history.
WorkAssignmentHistoryReport	Work assignment Report.
WorkAssignmentHistoryWorkerGroups	Work assignment group history.
WorkerDemographics	Returns a list of demographics for each worker in the organization.
WorkersBusinessCommunicationEmails	Returns workers business communication emails.
WorkersBusinessCommunicationFaxes	Returns workers business communication faxes.
WorkersBusinessCommunicationLandlines	Returns workers business communication landlines.
WorkersBusinessCommunicationMobiles	Returns workers business communication mobiles.
WorkersBusinessCommunicationPagers	Returns workers business communication pagers.
WorkersPersonBirthNamePreferredSalutations	Returns workers person birth name preferred salutations.
WorkersPersonBirthNameTitleAffixCodes	Returns workers person birth name title affix codes.
WorkersPersonBirthNameTitlePrefixCodes	Returns workers person birth name title prefix codes.
WorkersPersonGovernmentIDs	Returns workers person government IDs.
WorkersPersonLegalNamePreferredSalutations	Returns workers person legal name preferred salutations.
WorkersPersonLegalNameTitleAffixCodes	Returns workers person legal name title affix codes.
WorkersPersonLegalNameTitlePrefixCodes	Returns workers person legal name title prefix codes.
WorkersPersonMilitaryClassificationCodes	Returns workers person military classification codes.
WorkersPhotoLinks	Returns workers photo links.
WorkersPhotos	Returns workers photos.
WorkersWorkAssignmentReportsTo	Returns workers work assignment ReportsTo.
WorkersWorkAssignmentsAssignedOrganizationalUnits	Returns workers work assignments assigned organizational units.
WorkersWorkAssignmentsAssignedWorkLocations	Returns workers work assignments assigned work locations.
WorkersWorkAssignmentsAssignedWorkLocationsCommunicationEmails	Returns workers work assignments assigned work locations communication emails.
WorkersWorkAssignmentsAssignedWorkLocationsCommunicationFaxes	Returns workers work assignments assigned work locations communication faxes.
WorkersWorkAssignmentsAssignedWorkLocationsCommunicationLandlines	Returns workers work assignments assigned work locations communication landlines.
WorkersWorkAssignmentsAssignedWorkLocationsCommunicationMobiles	Returns workers work assignments assigned work locations communication mobiles.
WorkersWorkAssignmentsAssignedWorkLocationsCommunicationPagers	Returns workers work assignments assigned work locations communication pagers.
WorkersWorkAssignmentsHomeOrganizationalUnits	Returns workers work assignments home organizational units.
WorkersWorkAssignmentsHomeWorkLocationCommunicationEmails	Returns workers work assignments home work location communication emails.
WorkersWorkAssignmentsHomeWorkLocationCommunicationFaxes	Returns workers work assignments home work location communication faxes.
WorkersWorkAssignmentsHomeWorkLocationCommunicationLandlines	Returns workers work assignments home work location communication landlines.
WorkersWorkAssignmentsHomeWorkLocationCommunicationMobiles	Returns workers work assignments home work location communication mobiles.
WorkersWorkAssignmentsHomeWorkLocationCommunicationPagers	Returns workers work assignments home work location communication pagers.
WorkersWorkAssignmentsIndustryClassifications	Returns workers work assignments industry classifications.
WorkersWorkAssignmentsLinks	Returns workers work assignments links.
WorkersWorkAssignmentsOccupationalClassifications	Returns workers work assignments occupational classifications.
WorkersWorkAssignmentsWorkerGroups	Work assignments worker groups.
WorkerTypeCode	Work assignment worker type codes.
WorkSchedules	View the Work Schedules.
WorkSchedulesEntries	View the schedule days entries in Work Schedules.

Additional remuneration name code.

Columns

Name	Type	References	Description
CodeValue	String
ShortName	String

View the associate payment allocation earnings and benefits in the payroll outputs.

Table Specific Information

Select

The Sync App uses the ADP API to process WHERE clause conditions built with the following column and operator. The ItemId is required to make a request and the rest of the filter is executed client side within the Sync App.

• ItemId supports the '=' and IN comparisons.

SELECT * FROM AssociatePaymentsAllocationsEarningsAndBenefits WHERE ItemId = 'TXSMIb+yh9UbJ9-im9au7g=='
SELECT * FROM AssociatePaymentsAllocationsEarningsAndBenefits WHERE ItemId IN ('TXSMIb+yh9UbJ9-im9au7g==', 'XXSMIb+yh9UbJ9-im9au7g==')

Columns

Name	Type	References	Description
ItemID	String	PayrollRuns.ItemID	The unique identifier of a instance within the collection.
AssociateOID	String
payments	String

View the earning sections for the associate payments allocations in payroll outputs.

Table Specific Information

Select

The Sync App uses the ADP API to process WHERE clause conditions built with the following column and operator. The ItemId is required to make a request and the rest of the filter is executed client side within the Sync App.

• ItemId supports the '=' and IN comparisons.

SELECT * FROM AssociatePaymentsAllocationsEarningSections WHERE ItemId = 'TXSMIb+yh9UbJ9-im9au7g=='
SELECT * FROM AssociatePaymentsAllocationsEarningSections WHERE ItemId IN ('TXSMIb+yh9UbJ9-im9au7g==', 'XXSMIb+yh9UbJ9-im9au7g==')

Columns

Name	Type	References	Description
ItemID	String	PayrollRuns.ItemID	The unique identifier of a instance within the collection.
AssociateOID	String
ConfigurationTags	String
EarningAmountValue	Double
EarningClassificationCodeValue	String
EarningClassificationCodeShortName	String
EarningIDDescription	String
EarningIDValue	String
PayRateBaseUnitCodeValue	String
PayRateBaseUnitCodeShortName	String
PayRateValue	Double
TimeWorkedQuantityValue	Double
TimeWorkedQuantityunitTimeCodeValue	String
TimeWorkedQuantityUnitTimeCodeShortName	String
DepartmentId	String

View the non-statutory deductions for the associate payments allocations in payroll outputs.

Table Specific Information

Select

The Sync App uses the ADP API to process WHERE clause conditions built with the following column and operator. The ItemId is required to make a request and the rest of the filter is executed client side within the Sync App.

• ItemId supports the '=' and IN comparisons.

SELECT * FROM AssociatePaymentsAllocationsNonStatutoryDeductions WHERE ItemId = 'TXSMIb+yh9UbJ9-im9au7g=='
SELECT * FROM AssociatePaymentsAllocationsNonStatutoryDeductions WHERE ItemId IN ('TXSMIb+yh9UbJ9-im9au7g==', 'XXSMIb+yh9UbJ9-im9au7g==')

Columns

Name	Type	References	Description
ItemID	String	PayrollRuns.ItemID	The unique identifier of a instance within the collection.
AssociateOID	String		.
SectionName	String
SectionCategory	String
AssociateDeductionTakenAmountValue	Double
DeductionIDDescription	String
DeductionIDValue	String
DepartmentId	String

View the statutory deductions for the associate payments allocations in payroll outputs.

Table Specific Information

Select

The Sync App uses the ADP API to process WHERE clause conditions built with the following column and operator. The ItemId is required to make a request and the rest of the filter is executed client side within the Sync App.

• ItemId supports the '=' and IN comparisons.

SELECT * FROM AssociatePaymentsSummaryEarningsSections WHERE ItemId = 'TXSMIb+yh9UbJ9-im9au7g=='
SELECT * FROM AssociatePaymentsSummaryEarningsSections WHERE ItemId IN ('TXSMIb+yh9UbJ9-im9au7g==', 'XXSMIb+yh9UbJ9-im9au7g==')

Columns

Name	Type	References	Description
ItemID	String	PayrollRuns.ItemID	The unique identifier of a instance within the collection.
AssociateOID	String
SectionName	String
SectionCategory	String
AssociateDeductionTakenAmountValue	Double
AssociateTaxableAmountValue	Double
ConfigurationTags	String
EmployerPaidAmountValue	Double
EmployerTaxableAmountValue	Double
StatutoryDeductionTypeCodeValue	String
StatutoryDeductionTypeCodeShortName	String
StatutoryJurisdictionAdministrativeLevel1.codeValue	String
StatutoryJurisdictionWorkedInIndicator	Boolean
DepartmentId	String

View the AssociatePayments Earnings and Benefits in the payroll outputs.

Table Specific Information

Select

The Sync App uses the ADP API to process WHERE clause conditions built with the following column and operator. The ItemId is required to make a request and the rest of the filter is executed client side within the Sync App.

• ItemId supports the '=' and IN comparisons.

SELECT * FROM AssociatePaymentsSummaryEarningsAndBenefits WHERE ItemId = 'TXSMIb+yh9UbJ9-im9au7g=='
SELECT * FROM AssociatePaymentsSummaryEarningsAndBenefits WHERE ItemId IN ('TXSMIb+yh9UbJ9-im9au7g==', 'XXSMIb+yh9UbJ9-im9au7g==')

Columns

Name	Type	References	Description
ItemID	String	PayrollRuns.ItemID	The unique identifier of a instance within the collection.
AssociateOID	String
Payments	String

View the associate payments earnings sections items in the payroll outputs.

Table Specific Information

Select

The Sync App uses the ADP API to process WHERE clause conditions built with the following column and operator. The ItemId is required to make a request and the rest of the filter is executed client side within the Sync App.

• ItemId supports the '=' and IN comparisons.

SELECT * FROM AssociatePaymentsSummaryEarningsSections WHERE ItemId = 'TXSMIb+yh9UbJ9-im9au7g=='
SELECT * FROM AssociatePaymentsSummaryEarningsSections WHERE ItemId IN ('TXSMIb+yh9UbJ9-im9au7g==', 'XXSMIb+yh9UbJ9-im9au7g==')

Columns

Name	Type	References	Description
ItemID	String	PayrollRuns.ItemID	The unique identifier of a instance within the collection.
AssociateOID	String
ConfigurationTags	String
EarningAmountValue	Double
EarningClassificationCodeValue	String
EarningClassificationCodeShortName	String
EarningIDDescription	String
EarningIDValue	String
PayRateBaseUnitCodeValue	String
PayRateBaseUnitCodeShortName	String
PayRateRateValue	Double
PayrollAccumulations	String
TimeWorkedQuantityValue	Double
TimeWorkedQuantityUnitTimeCodeValue	String
TimeWorkedQuantityUnitTimeCodeName	String
DepartmentId	String

To view the non statutory deduction for the associate in payroll outputs.

Table Specific Information

Select

The Sync App uses the ADP API to process WHERE clause conditions built with the following column and operator. The ItemId is required to make a request and the rest of the filter is executed client side within the Sync App.

• ItemId supports the '=' and IN comparisons.

SELECT * FROM AssociatePaymentsSummaryNonStatutoryDeductions WHERE ItemId = 'TXSMIb+yh9UbJ9-im9au7g=='
SELECT * FROM AssociatePaymentsSummaryNonStatutoryDeductions WHERE ItemId IN ('TXSMIb+yh9UbJ9-im9au7g==', 'XXSMIb+yh9UbJ9-im9au7g==')

Columns

Name	Type	References	Description
ItemID	String	PayrollRuns.ItemID	The unique identifier of a instance within the collection
AssociateOID	String
SectionName	String
SectionCategory	String
AssociateDeductionAmountValue	Double
AssociateDeductionTakenAmountValue	Double
DeductionIDDescription	String
DeductionIDValue	String
PayrollAccumulations	String
DepartmentId	String

To View the associate payments payroll accumulations in the payroll outputs.

Table Specific Information

Select

The Sync App uses the ADP API to process WHERE clause conditions built with the following column and operator. The ItemId is required to make a request and the rest of the filter is executed client side within the Sync App.

• ItemId supports the '=' and IN comparisons.

SELECT * FROM AssociatePaymentsSummaryPayrollAccumulations WHERE ItemId = 'TXSMIb+yh9UbJ9-im9au7g=='
SELECT * FROM AssociatePaymentsSummaryPayrollAccumulations WHERE ItemId IN ('TXSMIb+yh9UbJ9-im9au7g==', 'XXSMIb+yh9UbJ9-im9au7g==')

Columns

Name	Type	References	Description
ItemID	String	PayrollRuns.ItemID	The unique identifier of a instance within the collection.
AssociateOID	String
AccumulatedAmountValue	Double
AccumulatedTimeWorkedQuantityValue	Double
AccumulatedTimeWorkedQuantityUnitTimeCodeValue	String
AccumulatedTimeWorkedQuantityUnitTimeCodeShortName	String
AccumulatorCodeValue	String
AccumulatorCodeLongName	String
AccumulatorCodeShortName	String
AccumulatorDescription	String
AccumulatorTimeUnitCodeValue	String
AccumulatorTimeUnitCodeShortName	String
DepartmentId	String

View the statutory deduction for the associate in payroll outputs.

Table Specific Information

Select

The Sync App uses the ADP API to process WHERE clause conditions built with the following column and operator. The ItemId is required to make a request and the rest of the filter is executed client side within the Sync App.

• ItemId supports the '=' and IN comparisons.

SELECT * FROM AssociatePaymentsSummaryStatutoryDeductions WHERE ItemId = 'TXSMIb+yh9UbJ9-im9au7g=='
SELECT * FROM AssociatePaymentsSummaryStatutoryDeductions WHERE ItemId IN ('TXSMIb+yh9UbJ9-im9au7g==', 'XXSMIb+yh9UbJ9-im9au7g==')

Columns

Name	Type	References	Description
ItemID	String	PayrollRuns.ItemID	The unique identifier of a instance within the collection.
AssociateOID	String
SectionCategory	String
SectionName	String
AssociateDeductionAmountValue	Double
AssociateDeductionTakenAmountValue	Double
AssociateTaxableAmountValue	Double
ConfigurationTags	String
EmployerPaidAmountValue	Double
EmployerTaxableAmountValue	Double
PayrollAccumulations	String
StatutoryDeductionTypeCodeValue	String
StatutoryDeductionTypeCodeASortName	String
StatutoryJurisdictionAdministrativeLevel1CodeValue	String
StatutoryJurisdictionWorkedInIndicator	Boolean
DepartmentId	String

Returns all Cost number codes setup for the client.

Table Specific Information

Select

No filters are supported server side for this table. All criteria will be handled client side within the Sync App.

For example, the following query is processed server side:

	SELECT * FROM CostCenters

Columns

Name	Type	References	Description
Code	String		Code for the Cost Center.
Description	String		Description for the Cost Center.
CompanyCode	String		Payroll Group Code.
Active	Boolean		It indicate if the department is still in use.

Returns deduction input code.

Columns

Name	Type	References	Description
CodeValue	String
ShortName	String
Description	String

Returns earning input code.

Columns

Name	Type	References	Description
CodeValue	String
ShortName	String
LongName	String
Description	String

Returns legal name generation affix code.

Columns

Name	Type	References	Description
CodeValue	String
ShortName	String

Returns highest education level code value.

Columns

Name	Type	References	Description
CodeValue	String
ShortName	String

Returns a list of job applications.

Table Specific Information

Select

No filters are supported server side for this table. All criteria will be handled client side within the Sync App.

For example, the following query is processed server side:

	SELECT * FROM JobApplications

Columns

Name	Type	References	Description
ItemID	String
RequisitionID	String
RequisitionTitle	String
ClientRequisitionID	String
InternalIndicator	Boolean
ExternalIndicator	Boolean
HiringManagerID	String
HiringManagerWorkerID	String
HiringManagerGivenName	String
HiringManagerFamilyName	String
HiringManagerFormattedName	String
ApplicationEffectiveDate	Date
ApplicationShortName	String
ApplicationCode	String
ApplicationPostingChannelID	String
ApplicationPostingChannelCode	String
ApplicationPostingChannelShortName	String
ApplicationSubmittedByAssociateOID	String
ApplicationSubmittedByGivenName	String
ApplicationSubmittedByFamilyName	String
ApplicationSubmittedDate	Date
ApplicantID	String
ApplicantInternalIndicator	Boolean
ApplicantWotcScreeningShortName	String
ApplicantWotcScreeningLongName	String
ApplicantWotcScreeningCode	String
ApplicantBackgroundScreeningLongName	String
ApplicantBackgroundScreeningCode	String
ApplicantCountryCode	String
ApplicantCityName	String
ApplicantCountrySubdivisionType	String
ApplicantCountrySubdivisionShortName	String
ApplicantCountrySubdivisionCode	String
ApplicantAddressLine1	String
ApplicantPostalCode	String
CommunicationLandlines	String
CommunicationMobiles	String
ApplicantGivenName	String
ApplicantFamilyName	String
ApplicantFormattedName	String
AppliedLocationItemID	String
AppliedLocationCode	String
AppliedLocationShortName	String

Returns a list of job applications communication landlines.

Table Specific Information

Select

No filters are supported server side for this table. All criteria will be handled client side within the Sync App.

For example, the following query is processed server side:

	SELECT * FROM JobApplicationsCommunicationLandlines

Columns

Name	Type	References	Description
ApplicantID	String
ItemID	String
AreaDialing	String
CountryDialing	String
DialNumber	String
FormattedNumber	String
NameCodeValue	String

Returns a list of job applications communication mobiles.

Table Specific Information

Select

No filters are supported server side for this table. All criteria will be handled client side within the Sync App.

For example, the following query is processed server side:

	SELECT * FROM JobApplicationsCommunicationMobiles

Columns

Name	Type	References	Description
ApplicantID	String
ItemID	String
AreaDialing	String
CountryDialing	String
DialNumber	String
FormattedNumber	String
NameCodeValue	String

Returns a list of job requisitions.

Table Specific Information

Select

No filters are supported server side for this table. All criteria will be handled client side within the Sync App.

For example, the following query is processed server side:

	SELECT * FROM JobRequisitions

Columns

Name	Type	References	Description
ItemID	String
PostingInstructionsCode	String
PostingInstructionsLongName	String
PostingInstructionsInternalIndicator	Boolean
PostingChannelID	String
PostingChannelCode	String
PostingChannelShortName	String
PostingChannelLongName	String
PostingChannelInternetAddress	String
PostingChannelExternalIndicator	Boolean
PostingChannelDefaultIndicator	Boolean
PostingInstructionsExpireDate	Date
PostingInstructionsResumeRequiredIndicator	Boolean
PostingInstructionsValidityAttestationIndicator	Boolean
PostingInstructionsPostDate	Date
LinksHref	String
LinksRel	String
LinksTitle	String
SupportedLocaleCodes	String
OpeningsNewPositionQuantity	Integer
WorkedInCountry	String
WorkerTypeCode	String
WorkerTypeShortName	String
CompanyName	String
LocationVisibleIndicator	Boolean
CompensationVisibleIndicator	Boolean
OpeningsFilledQuantity	Integer
OrganizationalUnits	String
OpeningsQuantity	Integer
EvergreenIndicator	Boolean
ProjectedStartDate	Date
ExternalIndicator	Boolean
VisibleToJobSeekerIndicator	Boolean
LieDetectorAcknowledgementIndicator	Boolean
HiringManagerID	String
HiringManagerWorkerID	String
HiringManagerGivenName	String
HiringManagerFamilyName	String
HiringManagerFormattedName	String
ClientRequisitionID	String
RequisitionEffectiveDate	Date
RequisitionShortName	String
RequisitionCode	String
JobCode	String
JobShortName	String
JobTitle	String
OccupationalClassificationsCode	String
OccupationalClassificationsShortName	String
RequisitionLocationsID	String
RequisitionLocationsPostalCode	String
RequisitionLocationsCityName	String
RequisitionLocationsCountrySubdivisionLevel1Code	String
RequisitionLocationsAddressLine1	String
RequisitionLocationsCountryCode	String
RequisitionLocationsCode	String
RequisitionLocationsShortName	String