ScheduleRequestsscheduleEvents
ScheduleRequestsscheduleEvents
Columns
Name | Type | Description |
ScheduleRequestsschedRequestId [KEY] | Long | ScheduleRequestsschedRequestId of ScheduleRequestsscheduleEvents |
ResourceReferenceType | String | Reference type of the resource such as, ASSIGNMENT_ID, ASSIGNMENT_NUMBER, and so on. Valid values are defined in the lookup HtsResourceRefType1. |
ResourceReference | String | Resource reference that matches the specified resource reference type. For example, if the resource reference type is Person ID, then the resource reference is the unique identifier for the person. |
ImportMode | String | Import modes for the schedule such as, FULL or UPDATE. Valid values are defined in the lookup HtsImportMode1. |
PeriodStartDate | Date | Start date for the period of imported schedule. For schedule imports for a single day, enter the value of peridEndDate. You enter the actual date in the periodEndDate field. |
PeriodEndDate | Date | Period end date of the imported schedule. |
Publish | String | Indicates whether to publish the imported schedules. Valid values are Y or N and are defined in the lookup HcmLookupYesNo. |
WorkerNotification | String | Indicates whether to notify workers after publishing their schedules. Valid values are Y or N and are defined in the lookup HcmLookupYesNo. |
AllowEdits | String | Indicates whether the scheduler can edit the imported schedule using the Manage Planned Schedule task. The attribute value in the Worker Time Setup profile provides the default value. Valid values are defined in the lookup HcmLookupYesNo. |
SchedEventId [KEY] | Long | Surrogate ID for the schedule request event, available only to reference existing records. |
SchedRequestId | Long | Surrogate ID for the schedule request for this schedule, available only to reference existing records. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
Finder | String | finder |