Tableau Connector for Oracle Fusion Cloud HCM

Build 24.0.9060

PayrollRelationshipspayrollAssignmentsassignedPayrolls

PayrollRelationshipspayrollAssignmentsassignedPayrolls

Columns

Name Type Description
PayrollRelationshipsEffectiveEndDate [KEY] Date PayrollRelationshipsEffectiveEndDate of PayrollRelationshipspayrollAssignmentsassignedPayrolls
PayrollRelationshipsEffectiveStartDate [KEY] Date PayrollRelationshipsEffectiveStartDate of PayrollRelationshipspayrollAssignmentsassignedPayrolls
PayrollRelationshipsPayrollRelationshipId [KEY] Long PayrollRelationshipsPayrollRelationshipId of PayrollRelationshipspayrollAssignmentsassignedPayrolls
PayrollassignmentsEffectiveEndDate [KEY] Date PayrollassignmentsEffectiveEndDate of PayrollRelationshipspayrollAssignmentsassignedPayrolls
PayrollassignmentsEffectiveStartDate [KEY] Date PayrollassignmentsEffectiveStartDate of PayrollRelationshipspayrollAssignmentsassignedPayrolls
PayrollassignmentsRelationshipGroupId [KEY] Long PayrollassignmentsRelationshipGroupId of PayrollRelationshipspayrollAssignmentsassignedPayrolls
AssignedPayrollId [KEY] Long Unique identifier used to retrieve the assigned payroll record for an assignment.
PayrollId Long Unique identifier for the payroll, such as the weekly payroll.
StartDate Date Start date of the payroll assigned to the assignment.
EndDate Date End date of the payroll assigned to the assignment.
TimeCardRequired String Associated with all assignments for a given payroll. Indicates whether the assignment must submit time cards for payroll purposes.
OverridingPeriodId Long Overtime period for all assignments associated to the payroll, such as the FLSA period for US employees.
EffectiveStartDate [KEY] Date Date at the beginning of the date range within which the payroll is effective.
EffectiveEndDate [KEY] Date Date at the end of the date range within which the payroll is effective.
Lsed Date Last standard earning date of the payroll assigned to the assignment.
AssignmentNumber String AssignmentNumber of PayrollRelationshipspayrollAssignmentsassignedPayrolls
Finder String Finder of PayrollRelationshipspayrollAssignmentsassignedPayrolls
PayrollRelationshipId Long PayrollRelationshipId of PayrollRelationshipspayrollAssignmentsassignedPayrolls
PersonNumber String PersonNumber of PayrollRelationshipspayrollAssignmentsassignedPayrolls
SysEffectiveDate String SysEffectiveDate of PayrollRelationshipspayrollAssignmentsassignedPayrolls

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