SCH_ASG_HST_VW

(SQL View)
 Index Back

Schedule Calendar Assignments

This table handles schedule and alternate schedule assignments for the users of the scheduling feature, which include Global Payroll and Time & Labor.

SELECT A.EMPLID , A.EMPL_RCD , A.EFFDT , A.END_EFFDT , A.SCHEDULE_GRP , A.SETID , A.SCH_ADHOC_IND , A.SCHEDULE_ID , A.ROTATION_ID , A.USE_DFLT_WS , A.USE_DFLT_WS , A.ALT_SCHEDULE_GRP , A.SETID_SCHED , A.SCH_ADHOC_IND_ALT , A.ALT_WRK_SCHED_ID , A.ROTATION_ID_ALT , A.USE_ALT_DFLT_WS , A.USE_ALT_DFLT_WS FROM PS_SCH_ASSIGN A

# 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 Rcd Nbr
3 EFFDT Date(10) DATE NOT NULL Effective Date
4 END_EFFDT Date(10) DATE End Effdt
5 SCHEDULE_GRP Character(10) VARCHAR2(10) NOT NULL Scheduling Organizational Group Code

Prompt Table: SCH_GROUP_TBL

6 SETID Character(5) VARCHAR2(5) NOT NULL SetID
7 SCH_ADHOC_IND Character(1) VARCHAR2(1) NOT NULL This field is used on Schedule Definitions to indicate if a Schedule is Ad Hoc (i.e. belonging to a specific employee) or Common (used by many employees)
1=Common Schedule
2=Ad Hoc Primary Schedule
3=Ad Hoc Alternate Schedule

Default Value: 1

8 SCHEDULE_ID Character(16) VARCHAR2(16) NOT NULL The Schedule ID is a field used to uniquely identify a Schedule Definition or Schedule Calendar (built out Schedule Definition).

Prompt Table: SCH_DEFN_CMN_VW

9 ROTATION_ID Character(10) VARCHAR2(10) NOT NULL Rotation ID

Prompt Table: SCH_DEFN_ROT_VW

10 USE_DFLT_WS Character(1) VARCHAR2(1) NOT NULL Indicator for Primary Schedule
A=Create Personal Schedule
N=Select Predefined Schedule
Y=Use Default Schedule

Default Value: Y

11 USE_DFLT_TYPE Character(1) VARCHAR2(1) NOT NULL Shows whether the default Schedule is assigned to an employee, and if so, whether it comes from Workgroup from Paygroup
A=Personal Schedule
N=Predefined Schedule
T=Default from Workgroup
Y=Default from Paygroup
12 ALT_SCHEDULE_GRP Character(10) VARCHAR2(10) NOT NULL Alternate Schedule Group code

Prompt Table: SCH_GROUP_TBL

13 SETID_SCHED Character(5) VARCHAR2(5) NOT NULL SetID for Schedule ID
14 SCH_ADHOC_IND_ALT Character(1) VARCHAR2(1) NOT NULL This field is used on Schedule Definitions to indicate if the Alternate Schedule is Ad Hoc (i.e. belonging to a specific employee) or Common (used by many employees)
1=Common Schedule
2=Ad Hoc Primary Schedule
3=Ad Hoc Alternate Schedule

Default Value: 1

15 ALT_WRK_SCHED_ID Character(16) VARCHAR2(16) NOT NULL TR Alternate Schedule ID

Prompt Table: SCH_DEFN_CMN_VW
Set Control Field: ALT_SCHEDULE_GRP

16 ROTATION_ID_ALT Character(10) VARCHAR2(10) NOT NULL Rotation ID of relating to the Alternate Schedule

Prompt Table: SCH_DEFN_ROTAVW
Set Control Field: ALT_SCHEDULE_GRP

17 USE_ALT_DFLT_WS Character(1) VARCHAR2(1) NOT NULL Indicator for Alternate Schedule
A=Create Personal Schedule
N=Select Predefined Schedule
Y=Use Default Schedule

Default Value: Y

18 USE_ALT_DFLT_TYPE Character(1) VARCHAR2(1) NOT NULL Shows whether the default Schedule is assigned to an employee, and if so, whether it comes from Workgroup from Paygroup
A=Personal Schedule
N=Predefined Schedule
T=Default from Workgroup
Y=Default from Paygroup