StatusChangeRequestsstatusChanges

Columns


Name	Type	Description
StatusChangeRequestsstatusRequestId [KEY]	Long	StatusChangeRequestsstatusRequestId of StatusChangeRequestsstatusChanges
StatusChangeId [KEY]	Long	Unique identifier for the status change record.
BuildingBlockId	Long	Unique identifier for the time record associated with the status change record.
BuildingBlockVersion	Int	Version number of the time record stored in the WFM time repository.
ConsumerCode	String	Consumer code associated with the status change record, such as PJC or PYR.
StatusCode	String	Status definition ID of the status change record. The default value is A_XFR_STATUS.
StatusValue	String	Transfer status of the time entry, such as SUCCESS or UNPROCESSED.
RequestStatus	String	Processing status of the status change record, such as NEW, IN PROCESS, or COMPLETE.

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