ElementEntries

Columns


Name	Type	Description
ElementEntryId [KEY]	Long	System-generated unique identifier for an element entry.
EffectiveStartDate [KEY]	Date	Date at the beginning of the period within which the entry is available for processing.
EffectiveEndDate [KEY]	Date	Date at the end of the period within which the entry is available for processing with element entry identifier.
CreatorType	String	Name of the user or the process that created the element entry record, such as batch element entry.
ElementTypeId	Long	Unique identifer of the element type.
EntryType	String	Type of the element entry, such as regular entry or override.
EntrySequence	Long	Unique number that identifies an element entry record when overlapping entries exists for the same element.
PersonId	Long	System-generated unique identifier for a person.
Reason	String	Reason for creating or updating an element entry.
Subpriority	Int	Number used to sequence the processing of element entries with the same priority.
PersonNumber	String	PersonNumber of ElementEntries
AssignmentId	Long	Surrogate identifer of the payroll assignment.
AssignmentNumber	String	AssignmentNumber of ElementEntries
PayrollRelationshipNumber	String	PayrollRelationshipNumber of ElementEntries
ElementName	String	Name of the element the entry is for, such as Performance Bonus.
UsageLevel	String	UsageLevel of ElementEntries
Intent	String	Intent of ElementEntries

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。