JDBC Driver for Oracle Fusion Cloud HCM

Build 24.0.9062

PublicWorkersassignments

PublicWorkersassignments

Columns

Name Type Description
PublicWorkersPersonId [KEY] Long PublicWorkersPersonId of PublicWorkersassignments
AssignmentId [KEY] Long AssignmentId of PublicWorkersassignments
AssignmentNumber String AssignmentNumber of PublicWorkersassignments
AssignmentName String AssignmentName of PublicWorkersassignments
LegalEmployerName String LegalEmployerName of PublicWorkersassignments
StartDate Date StartDate of PublicWorkersassignments
PrimaryFlag Bool PrimaryFlag of PublicWorkersassignments
PrimaryAssignmentFlag Bool PrimaryAssignmentFlag of PublicWorkersassignments
WorkerType String WorkerType of PublicWorkersassignments
WorkerNumber String WorkerNumber of PublicWorkersassignments
WorkAtHomeFlag Bool WorkAtHomeFlag of PublicWorkersassignments
FullPartTime String FullPartTime of PublicWorkersassignments
ManagerName String ManagerName of PublicWorkersassignments
BusinessUnitName String BusinessUnitName of PublicWorkersassignments
DepartmentName String DepartmentName of PublicWorkersassignments
JobCode String JobCode of PublicWorkersassignments
JobName String JobName of PublicWorkersassignments
PositionCode String PositionCode of PublicWorkersassignments
PositionName String PositionName of PublicWorkersassignments
LocationCode String LocationCode of PublicWorkersassignments
LocationName String LocationName of PublicWorkersassignments
GradeCode String GradeCode of PublicWorkersassignments
GradeName String GradeName of PublicWorkersassignments
InternalBuilding String InternalBuilding of PublicWorkersassignments
InternalFloor String InternalFloor of PublicWorkersassignments
InternalOfficeNumber String InternalOfficeNumber of PublicWorkersassignments
InternalMailstop String InternalMailstop of PublicWorkersassignments
LocationAddressLine1 String LocationAddressLine1 of PublicWorkersassignments
LocationAddressLine2 String LocationAddressLine2 of PublicWorkersassignments
LocationAddressLine3 String LocationAddressLine3 of PublicWorkersassignments
LocationAddressLine4 String LocationAddressLine4 of PublicWorkersassignments
LocationRegion1 String LocationRegion1 of PublicWorkersassignments
LocationRegion2 String LocationRegion2 of PublicWorkersassignments
LocationRegion3 String LocationRegion3 of PublicWorkersassignments
LocationTownOrCity String LocationTownOrCity of PublicWorkersassignments
LocationPostalCode String LocationPostalCode of PublicWorkersassignments
LocationCountry String LocationCountry of PublicWorkersassignments
LocationLongPostalCode String LocationLongPostalCode of PublicWorkersassignments
LocationTimezoneCode String LocationTimezoneCode of PublicWorkersassignments
LocationSingleLineAddress String LocationSingleLineAddress of PublicWorkersassignments
LocationMultiLineAddress String LocationMultiLineAddress of PublicWorkersassignments
LengthOfServiceYears Int LengthOfServiceYears of PublicWorkersassignments
LengthOfServiceMonths Int LengthOfServiceMonths of PublicWorkersassignments
LengthOfServiceDays Int LengthOfServiceDays of PublicWorkersassignments
MarkedAsFavoriteFlag Bool MarkedAsFavoriteFlag of PublicWorkersassignments
DirectReportsFlag Bool DirectReportsFlag of PublicWorkersassignments
DisplayName String DisplayName of PublicWorkersassignments
Finder String Finder of PublicWorkersassignments
LineManagerFlag Bool LineManagerFlag of PublicWorkersassignments
OnlyPrimaryAssignmentFlag Bool OnlyPrimaryAssignmentFlag of PublicWorkersassignments
PersonId Long PersonId of PublicWorkersassignments
PersonNumber String PersonNumber of PublicWorkersassignments
RelationshipType String RelationshipType of PublicWorkersassignments
WorkEmail String WorkEmail of PublicWorkersassignments

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