WorkersworkRelationships
WorkersworkRelationships
Columns
Name | Type | Description |
WorkersPersonId [KEY] | Long | WorkersPersonId of WorkersworkRelationships |
PeriodOfServiceId [KEY] | Long | PeriodOfServiceId of WorkersworkRelationships |
LegislationCode | String | LegislationCode of WorkersworkRelationships |
LegislationName | String | LegislationName of WorkersworkRelationships |
LegalEntityId | Long | LegalEntityId of WorkersworkRelationships |
LegalEmployerName | String | LegalEmployerName of WorkersworkRelationships |
WorkerType | String | WorkerType of WorkersworkRelationships |
WorkerTypeMeaning | String | WorkerTypeMeaning of WorkersworkRelationships |
PrimaryFlag | Bool | PrimaryFlag of WorkersworkRelationships |
StartDate | Date | StartDate of WorkersworkRelationships |
LegalEmployerSeniorityDate | Date | LegalEmployerSeniorityDate of WorkersworkRelationships |
EnterpriseSeniorityDate | Date | EnterpriseSeniorityDate of WorkersworkRelationships |
OnMilitaryServiceFlag | Bool | OnMilitaryServiceFlag of WorkersworkRelationships |
WorkerNumber | String | WorkerNumber of WorkersworkRelationships |
ReadyToConvertFlag | Bool | ReadyToConvertFlag of WorkersworkRelationships |
TerminationDate | Date | TerminationDate of WorkersworkRelationships |
NotificationDate | Date | NotificationDate of WorkersworkRelationships |
LastWorkingDate | Date | LastWorkingDate of WorkersworkRelationships |
RevokeUserAccess | String | RevokeUserAccess of WorkersworkRelationships |
RecommendedForRehire | String | RecommendedForRehire of WorkersworkRelationships |
RecommendedForRehireMeaning | String | RecommendedForRehireMeaning of WorkersworkRelationships |
RecommendationReason | String | RecommendationReason of WorkersworkRelationships |
RecommendationAuthorizedByPersonId | Long | RecommendationAuthorizedByPersonId of WorkersworkRelationships |
CreatedBy | String | CreatedBy of WorkersworkRelationships |
CreationDate | Datetime | CreationDate of WorkersworkRelationships |
LastUpdatedBy | String | LastUpdatedBy of WorkersworkRelationships |
LastUpdateDate | Datetime | LastUpdateDate of WorkersworkRelationships |
ProjectedTerminationDate | Date | ProjectedTerminationDate of WorkersworkRelationships |
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 |
AssignmentId | Long | AssignmentId |
AssignmentName | String | AssignmentName |
AssignmentNumber | String | AssignmentNumber |
DirectReportsFlag | String | DirectReportsFlag |
LineManagerFlag | String | LineManagerFlag |
PersonId | Long | PersonId |
PersonNumber | String | PersonNumber |
PrimaryAssignmentFlag | String | PrimaryAssignmentFlag |
RelationshipType | String | RelationshipType |
SysEffectiveDate | String | SysEffectiveDate |
Finder | String | finder |
EffectiveDate | Date | This query parameter is used to fetch resources which are effective dated as of the specified start date. The value of this query parameter is a string having a date in yyyy-MM-dd format. |