You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Unable to find the table details for updating shift details,schedule event details to load .

in Workforce Management 1 comment

Summary:

Unable to find the table details for updating shift details,schedule event details to load .

We tried searching using below tables but we cannot get data.Also tried using zmm_ prefix tables but we could not get exact field. Kindly help

HTS_SCHED_REQUESTS

HTS_SCHED_EVENTS

HTS_SCHED_SHIFT_EVENTS

We wanted to know the exact tables from which the below fields can be retrieved.
METADATA|ScheduleRequest|ScheduleRequestNumber|RequestSource|RequestTime
MERGE|ScheduleRequest|SRN8020002667|ORA_HWM_PUB_SCHED|2025-05-29T10:30:20.010+01:00

METADATA|ScheduleEvent|ScheduleRequestNumber|ScheduleEventNumber|ImportMode|PersonNumber|PeriodStartDate|PeriodEndDate|AllowEdits|Publish|WorkerNotification
MERGE|ScheduleEvent|SRN8020002667|SRN8024704|FULL|1001191|2025/05/29|2025/05/29|Y|Y|N

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!