SCH_DEFN_TBL (SQL Table)	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_TBL

(SQL Table)

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.

Related Language Record: SCH_DEFN_LANG

Parent Record Of SCH_DEFN_DTL SCH_DEFN_ROTATN SCH_DEFN_ROTAVW SCH_DEFN_ROT_VW SCH_DEFN_WRK

# 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 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
Default Value: A

6 END_EFFDT Date(10) DATE End Effdt

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

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

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

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

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

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

13 TIME_RPTG_TMPLT Character(10) VARCHAR2(10) NOT NULL Time Reporting Template ID
Prompt Table: SCH_TR_TMPT_VW

14 WORKGROUP Character(10) VARCHAR2(10) NOT NULL Workgroup
Prompt Table: TL_WRKGRP_TBL

15 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	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	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
6	END_EFFDT	Date(10)	DATE	End Effdt
7	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
8	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description Default Value: SCH_DEFN_TBL.DESCR
9	SCH_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Definition Type E=Elapsed F=Flex P=Punch Default Value: P
10	MULT_ROTATIONS	Character(1)	VARCHAR2(1) NOT NULL	Indicates if Schedule Definition will include multiple rotations Y/N Table Edit Default Value: N
11	SCHEDULE_DAYS	Number(3,0)	SMALLINT NOT NULL	Days in Schedule Default Value: 1
12	TASKGROUP	Character(10)	VARCHAR2(10) NOT NULL	Taskgroup Prompt Table: TL_TASKGRP_TBL
13	TIME_RPTG_TMPLT	Character(10)	VARCHAR2(10) NOT NULL	Time Reporting Template ID Prompt Table: SCH_TR_TMPT_VW
14	WORKGROUP	Character(10)	VARCHAR2(10) NOT NULL	Workgroup Prompt Table: TL_WRKGRP_TBL
15	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