Workerspassports

Columns


Name	Type	Description
WorkersPersonId [KEY]	Long	WorkersPersonId of Workerspassports
PassportId [KEY]	Long	PassportId of Workerspassports
IssuingCountry	String	Country in which the passport was issued. Valid values are defined in the hcmCountriesLov.
IssuingCountryName	String	IssuingCountryName of Workerspassports
PassportType	String	Type or category of the passport. Valid values are defined in the commonLookupsLOV.
PassportTypeMeaning	String	PassportTypeMeaning of Workerspassports
PassportNumber	String	Passport number of the person.
IssuingAuthority	String	Issuing authority for the passport.
IssueDate	Date	Issue date of the passport.
ExpirationDate	Date	Expiration date of the passport.
IssuingLocation	String	Location where the passport was issued.
Profession	String	Profession of the passport holder.
CreatedBy	String	CreatedBy of Workerspassports
CreationDate	Datetime	CreationDate of Workerspassports
LastUpdatedBy	String	LastUpdatedBy of Workerspassports
LastUpdateDate	Datetime	LastUpdateDate of Workerspassports

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.