TimeRecordGroupstimeRecords

Columns


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

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