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.

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.