SCH_ASG_AHST_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.

SCH_ASG_AHST_VW

(SQL View)

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.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 Record

3 EFFDT Date(10) DATE NOT NULL Effective Date

4 END_EFFDT Date(10) DATE End Effdt

5 ALT_SCHEDULE_GRP Character(10) VARCHAR2(10) NOT NULL Alternate Schedule Group code
Prompt Table: SCH_GROUP_TBL

6 SETID_SCHED Character(5) VARCHAR2(5) NOT NULL SetID for Schedule ID

7 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

8 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

9 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

10 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

11 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

#	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	EFFDT	Date(10)	DATE NOT NULL	Effective Date
4	END_EFFDT	Date(10)	DATE	End Effdt
5	ALT_SCHEDULE_GRP	Character(10)	VARCHAR2(10) NOT NULL	Alternate Schedule Group code Prompt Table: SCH_GROUP_TBL
6	SETID_SCHED	Character(5)	VARCHAR2(5) NOT NULL	SetID for Schedule ID
7	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
8	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
9	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
10	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
11	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