SCH_ASSIGN (SQL Table)	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_ASSIGN

(SQL Table)

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.

# 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 ALT_SCHEDULE_GRP Character(10) VARCHAR2(10) NOT NULL Alternate Schedule Group code
Prompt Table: SCH_GROUP_TBL

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

13 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

14 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

15 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

16 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

#	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	ALT_SCHEDULE_GRP	Character(10)	VARCHAR2(10) NOT NULL	Alternate Schedule Group code Prompt Table: SCH_GROUP_TBL
12	SETID_SCHED	Character(5)	VARCHAR2(5) NOT NULL	SetID for Schedule ID
13	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
14	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
15	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
16	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