Workersdisabilities
Workersdisabilities
Columns
Name | Type | Description |
WorkersPersonId [KEY] | Long | WorkersPersonId of Workersdisabilities |
DisabilityId [KEY] | Long | Surrogate identifier for the disability of a worker. |
DisabilityCode | String | Code for the disability. |
EffectiveStartDate [KEY] | Date | Start date of the date-effective changes to the record. |
EffectiveEndDate [KEY] | Date | End date of the date-effective changes to the record. |
LegislationCode | String | Legislation code for the disability. Valid values are defined in the hcmCountriesLov. |
Category | String | Category of the disability such as Physical or Intellectual. |
QuotaFTE | Double | Person's full time equivalency. |
Status | String | Status of the person's disability. |
Reason | String | Reason for the person's disability. |
Degree | Double | Extent to which the disability impacts the person's abilities. |
SelfDisclosedType | String | Type of disability disclosed by the worker. Used explicitly for the Japanese, United Kingdom, and United States legislation. |
DisclosureDate | Date | Date on which the disability has been disclosed by the worker. Used explicitly for the Japanese, United Kingdom, and United States legislation. |
AccommodationRequest | String | Request for accomodation. |
RegistrationDate | Date | Date on which the disability was registered with the disability organization. |
RegistrationExpDate | Date | Expiration date of the disability registration. |
RegistrationId | String | Identification detail given to the person by the disability organization. |
OrganizationId | Long | Unique identifier of the organization. |
OrganizationName | String | Organization name to which the disability is registered. |
Description | String | Description of the person's disability. |
WorkRestriction | String | Details of any work restrictions due to the disability. |
CreatedBy | String | CreatedBy of Workersdisabilities |
CreationDate | Datetime | CreationDate of Workersdisabilities |
LastUpdatedBy | String | LastUpdatedBy of Workersdisabilities |
LastUpdateDate | Datetime | LastUpdateDate of Workersdisabilities |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
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 |
WorkerType | String | WorkerType |
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. |