WorkersexternalIdentifiers
WorkersexternalIdentifiers
Columns
| Name | Type | Description |
| WorkersPersonId [KEY] | Long | WorkersPersonId of WorkersexternalIdentifiers |
| ExternalIdentifierId [KEY] | Long | ExternalIdentifierId of WorkersexternalIdentifiers |
| ExternalIdentifierSequence | Int | Sequence of the external identifier. |
| ExternalIdentifierNumber | String | External identifier number. |
| ExternalIdentifierType | String | Type of external identifier, such as Third-Party Payroll ID. Valid values are defined in the commonLookupsLOV. |
| ExternalIdentifierTypeMeaning | String | ExternalIdentifierTypeMeaning of WorkersexternalIdentifiers |
| AssignmentId | Long | Unique identifier of the assignment to which this external identifier relates. |
| FromDate | Datetime | Date and time from when the external identifier is valid. |
| ToDate | Datetime | Date and time until when the external identifier is valid. |
| Comments | String | Comments for the external identifier. |
| CreatedBy | String | CreatedBy of WorkersexternalIdentifiers |
| CreationDate | Datetime | CreationDate of WorkersexternalIdentifiers |
| LastUpdatedBy | String | LastUpdatedBy of WorkersexternalIdentifiers |
| LastUpdateDate | Datetime | LastUpdateDate of WorkersexternalIdentifiers |
| AssignmentNumber | String | Assignment number to which the external identifier belongs. |
| AssignmentName | String | AssignmentName of WorkersexternalIdentifiers |
| DirectReportsFlag | String | DirectReportsFlag of WorkersexternalIdentifiers |
| Finder | String | Finder of WorkersexternalIdentifiers |
| LineManagerFlag | String | LineManagerFlag of WorkersexternalIdentifiers |
| PersonId | Long | PersonId of WorkersexternalIdentifiers |
| PersonNumber | String | PersonNumber of WorkersexternalIdentifiers |
| PrimaryAssignmentFlag | String | PrimaryAssignmentFlag of WorkersexternalIdentifiers |
| RelationshipType | String | RelationshipType of WorkersexternalIdentifiers |
| SysEffectiveDate | String | SysEffectiveDate of WorkersexternalIdentifiers |
| WorkerType | String | WorkerType of WorkersexternalIdentifiers |
| EffectiveDate | Date | EffectiveDate of WorkersexternalIdentifiers |