TDV Adapter for Oracle Fusion Cloud HCM

Build 23.0.8839

PayrollRelationshipspayrollAssignmentsassignedPayrollsassignedPayrollDates

PayrollRelationshipspayrollAssignmentsassignedPayrollsassignedPayrollDates

Columns

Name Type Description
PayrollRelationshipsEffectiveEndDate [KEY] Date PayrollRelationshipsEffectiveEndDate of PayrollRelationshipspayrollAssignmentsassignedPayrollsassignedPayrollDates
PayrollRelationshipsEffectiveStartDate [KEY] Date PayrollRelationshipsEffectiveStartDate of PayrollRelationshipspayrollAssignmentsassignedPayrollsassignedPayrollDates
PayrollRelationshipsPayrollRelationshipId [KEY] Long PayrollRelationshipsPayrollRelationshipId of PayrollRelationshipspayrollAssignmentsassignedPayrollsassignedPayrollDates
PayrollassignmentsEffectiveEndDate [KEY] Date PayrollassignmentsEffectiveEndDate of PayrollRelationshipspayrollAssignmentsassignedPayrollsassignedPayrollDates
PayrollassignmentsEffectiveStartDate [KEY] Date PayrollassignmentsEffectiveStartDate of PayrollRelationshipspayrollAssignmentsassignedPayrollsassignedPayrollDates
PayrollassignmentsRelationshipGroupId [KEY] Long PayrollassignmentsRelationshipGroupId of PayrollRelationshipspayrollAssignmentsassignedPayrollsassignedPayrollDates
AssignedpayrollsAssignedPayrollId [KEY] Long AssignedpayrollsAssignedPayrollId of PayrollRelationshipspayrollAssignmentsassignedPayrollsassignedPayrollDates
AssignedpayrollsEffectiveEndDate [KEY] Date AssignedpayrollsEffectiveEndDate of PayrollRelationshipspayrollAssignmentsassignedPayrollsassignedPayrollDates
AssignedpayrollsEffectiveStartDate [KEY] Date AssignedpayrollsEffectiveStartDate of PayrollRelationshipspayrollAssignmentsassignedPayrollsassignedPayrollDates
DateValue Date DateValue of PayrollRelationshipspayrollAssignmentsassignedPayrollsassignedPayrollDates
PayDateId [KEY] Long PayDateId of PayrollRelationshipspayrollAssignmentsassignedPayrollsassignedPayrollDates
ShortName String ShortName of PayrollRelationshipspayrollAssignmentsassignedPayrollsassignedPayrollDates

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
AssignmentNumber String AssignmentNumber
EffectiveEndDate Date EffectiveEndDate
EffectiveStartDate Date EffectiveStartDate
PayrollRelationshipId Long PayrollRelationshipId
PersonNumber String PersonNumber
SysEffectiveDate String SysEffectiveDate
Finder String finder

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