StatusChangeRequestsstatusChanges
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. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
Finder | String | finder |
StatusRequestId | Long | statusRequestId |