TimeRecords

Columns


Name	Type	Description
TimeRecordId [KEY]	Double	TimeRecordId of TimeRecords
TimeRecordGroupId	Long	TimeRecordGroupId of TimeRecords
StartTime	Datetime	StartTime of TimeRecords
StopTime	Datetime	StopTime of TimeRecords
GroupType	String	GroupType of TimeRecords
RecordType	String	RecordType of TimeRecords
Measure	Double	Measure of TimeRecords
UnitOfMeasure	String	UnitOfMeasure of TimeRecords
PersonNumber	String	PersonNumber of TimeRecords
PersonId	Long	PersonId of TimeRecords
Comment	String	Comment of TimeRecords
AssignmentNumber	String	AssignmentNumber of TimeRecords
TimeRecordGroupVersion	Int	TimeRecordGroupVersion of TimeRecords
TimeRecordVersion	Int	TimeRecordVersion of TimeRecords
OvertimeDate	Date	OvertimeDate of TimeRecords
EarnedDate	Date	EarnedDate of TimeRecords

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