Workersphones
Workersphones
Columns
Name | Type | Description |
WorkersPersonId [KEY] | Long | WorkersPersonId of Workersphones |
PhoneId [KEY] | Long | PhoneId of Workersphones |
PhoneType | String | Type of phone such as Work, Home, and so on. Valid values are defined in the commonLookupsLOV. |
PhoneTypeMeaning | String | PhoneTypeMeaning of Workersphones |
LegislationCode | String | Phone legislation code. |
LegislationName | String | LegislationName of Workersphones |
CountryCodeNumber | String | Country code of the phone number. Valid values are defined in the hcmCountriesLov. |
AreaCode | String | Area code of the phone number. |
PhoneNumber | String | Phone number of various phone types such as Work, Home, and so on. |
Extension | String | Extension number for the phone. |
FromDate | Date | Date from when the phone number is valid. |
ToDate | Date | Date until when the phone number is valid. |
CreatedBy | String | CreatedBy of Workersphones |
CreationDate | Datetime | CreationDate of Workersphones |
LastUpdatedBy | String | LastUpdatedBy of Workersphones |
LastUpdateDate | Datetime | LastUpdateDate of Workersphones |
PrimaryFlag | Bool | Indicates whether the phone number is the primary phone of the worker. |
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. |