WorkersnationalIdentifiers

Columns


Name	Type	Description
WorkersPersonId [KEY]	Long	WorkersPersonId of WorkersnationalIdentifiers
NationalIdentifierId [KEY]	Long	NationalIdentifierId of WorkersnationalIdentifiers
LegislationCode	String	Legislation code of the national identifier. Valid values are defined in the hcmCountriesLov.
LegislationName	String	LegislationName of WorkersnationalIdentifiers
NationalIdentifierType	String	Type of national identifier. Valid values are defined in the commonLookupsLOV.
NationalIdentifierTypeMeaning	String	NationalIdentifierTypeMeaning of WorkersnationalIdentifiers
NationalIdentifierNumber	String	National identification number.
IssueDate	Date	Issue date of the national identifier.
ExpirationDate	Date	Expiration date of the national identifier.
PlaceOfIssue	String	Place where the national identifier was issued.
CreatedBy	String	CreatedBy of WorkersnationalIdentifiers
CreationDate	Datetime	CreationDate of WorkersnationalIdentifiers
LastUpdatedBy	String	LastUpdatedBy of WorkersnationalIdentifiers
LastUpdateDate	Datetime	LastUpdateDate of WorkersnationalIdentifiers
PrimaryFlag	Bool	Indicates whether the national identifier is the person's primary national identifier.

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.