WorkerslegislativeInfo

Columns


Name	Type	Description
WorkersPersonId [KEY]	Long	WorkersPersonId of WorkerslegislativeInfo
PersonLegislativeId [KEY]	Long	PersonLegislativeId of WorkerslegislativeInfo
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. Valid values are defined in the hcmCountriesLov.
LegislationName	String	LegislationName of WorkerslegislativeInfo
Gender	String	Gender of the person. Valid values are defined in the commonLookupsLOV.
GenderMeaning	String	GenderMeaning of WorkerslegislativeInfo
MaritalStatus	String	Marital status of the person. Valid values are defined in the commonLookupsLOV.
MaritalStatusMeaning	String	MaritalStatusMeaning of WorkerslegislativeInfo
MaritalStatusChangeDate	Date	Date from when the marital status came into effect.
HighestEducationLevel	String	Legislation-specific value that identifies the person's highest education level. Valid values are defined in the commonLookupsLOV.
HighestEducationLevelMeaning	String	HighestEducationLevelMeaning of WorkerslegislativeInfo
CreatedBy	String	CreatedBy of WorkerslegislativeInfo
CreationDate	Datetime	CreationDate of WorkerslegislativeInfo
LastUpdatedBy	String	LastUpdatedBy of WorkerslegislativeInfo
LastUpdateDate	Datetime	LastUpdateDate of WorkerslegislativeInfo

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.