SCH_ADHOC_VW

(SQL View)
Index Back

Schedule Ad Hoc Detail

The Schedule Ad Hoc Detail table stores time reporter specific detail schedule information. This information may vary from a Time Reporter's long term schedule in terms of when a Time Reporter is schedule to work, and what a Time Reporter is scheduled to work on. This second aspect differentiates this schedule from the Time Reporter's long term schedule which only communicates when a Time Reporter is scheduled to work. The detail schedule may be populated by the Ad Hoc Schedule or Manage Schedule online processes as well as through the Work Force Scheduling interface which accepts schedules from other scheduling applications. For Release 8.0 and beyond, the Scheduling feature is a shared feature, utilized by applications including Time & Labor and Global Payroll.

SELECT DISTINCT EMPLID , EMPL_RCD , SHIFT_ID FROM PS_SCH_ADHOC_DTL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
3 SHIFT_ID Character(10) VARCHAR2(10) NOT NULL Shift ID