SCH_DEFN_VW (SQL View)	Index Back
Schedule Definition Table Schedule Definition table maintains the Schedule Name (DESCR) as well as the date and time of the last scheduled out punch, which is for use by subsequent schedule creation runs.

SCH_DEFN_VW

(SQL View)

Schedule Definition Table

Schedule Definition table maintains the Schedule Name (DESCR) as well as the date and time of the last scheduled out punch, which is for use by subsequent schedule creation runs.

SELECT SETID , SCH_ADHOC_IND , SCHEDULE_ID , EFFDT , EFF_STATUS , DESCR , DESCRSHORT , SCH_TYPE , MULT_ROTATIONS , SCHEDULE_DAYS , TASKGROUP , SCH_DLS_OPT FROM PS_SCH_DEFN_TBL

Related Language Record: SCH_DEFN_VW_LNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 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

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

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

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

6 DESCR Character(30) VARCHAR2(30) NOT NULL Description

7 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
Default Value: SCH_DEFN_TBL.DESCR

8 SCH_TYPE Character(2) VARCHAR2(2) NOT NULL Shift Type
E=Elapsed
F=Flex
P=Punch
Default Value: P

9 MULT_ROTATIONS Character(1) VARCHAR2(1) NOT NULL Indicates if Schedule Definition will include multiple rotations
Y/N Table Edit
Default Value: N

10 SCHEDULE_DAYS Number(3,0) SMALLINT NOT NULL Days in Schedule
Default Value: 1

11 TASKGROUP Character(10) VARCHAR2(10) NOT NULL Taskgroup
Prompt Table: TL_TASKGRP_TBL

12 SCH_DLS_OPT Character(1) VARCHAR2(1) NOT NULL Daylight Savings Option. Used on Schedules to indicate the action to take when a Schedule may be affected by Daylight Savings - i.e. either starts and ends in different TimeZones, or on days when Daylight Savings starts or ends.
1=Fixed Duration
2=Fixed Time
Default Value: 2

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID_SCHED	Character(5)	VARCHAR2(5) NOT NULL	SetID for Schedule ID
2	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
3	ALT_WRK_SCHED_ID	Character(16)	VARCHAR2(16) NOT NULL	TR Alternate Schedule ID
4	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
5	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
6	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
7	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description Default Value: SCH_DEFN_TBL.DESCR
8	SCH_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Shift Type E=Elapsed F=Flex P=Punch Default Value: P
9	MULT_ROTATIONS	Character(1)	VARCHAR2(1) NOT NULL	Indicates if Schedule Definition will include multiple rotations Y/N Table Edit Default Value: N
10	SCHEDULE_DAYS	Number(3,0)	SMALLINT NOT NULL	Days in Schedule Default Value: 1
11	TASKGROUP	Character(10)	VARCHAR2(10) NOT NULL	Taskgroup Prompt Table: TL_TASKGRP_TBL
12	SCH_DLS_OPT	Character(1)	VARCHAR2(1) NOT NULL	Daylight Savings Option. Used on Schedules to indicate the action to take when a Schedule may be affected by Daylight Savings - i.e. either starts and ends in different TimeZones, or on days when Daylight Savings starts or ends. 1=Fixed Duration 2=Fixed Time Default Value: 2