SCH_DEFN_ROTATN (SQL Table)	Index Back
Schedule Definition Table Schedule Definition Rotations table maintains the Relative Start Day for each Rotation associated with a Schedule

SCH_DEFN_ROTATN

(SQL Table)

Schedule Definition Table

Schedule Definition Rotations table maintains the Relative Start Day for each Rotation associated with a Schedule

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Prompt Table: SET_VLD_TL_01

2 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

3 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).

4 EFFDT Date(10) DATE Effective Date
Default Value: %date

5 ROTATION_ID Character(10) VARCHAR2(10) NOT NULL Rotation ID
Default Value: 1

6 ROTATION_START_DAY Number(3,0) SMALLINT NOT NULL Relative Day Number of a Rotation. This represents the Day Number scheduled for the rotation on the Effective Date of the Schedule.
Default Value: 1

7 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
Default Value: A

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SET_VLD_TL_01
2	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
3	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).
4	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
5	ROTATION_ID	Character(10)	VARCHAR2(10) NOT NULL	Rotation ID Default Value: 1
6	ROTATION_START_DAY	Number(3,0)	SMALLINT NOT NULL	Relative Day Number of a Rotation. This represents the Day Number scheduled for the rotation on the Effective Date of the Schedule. Default Value: 1
7	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A