TL_WRKGRP_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	WORKGROUP	Character(10)	VARCHAR2(10) NOT NULL	Workgroup
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %Date
3	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
5	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description Default Value: TL_WRKGRP_TBL.DESCR
6	TRC_PROGRAM	Character(5)	VARCHAR2(5) NOT NULL	TRC Program ID Prompt Table: TL_TRC_PGM_TBL
7	RULE_PGM_ID	Character(12)	VARCHAR2(12) NOT NULL	Rule Program ID Prompt Table: TL_RULE_PGM
8	TIME_RPTG_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Time Reporting Type E=Exception Time Reporting P=Positive Time Reporting Default Value: E
9	HOLIDAY_SCHEDULE	Character(6)	VARCHAR2(6) NOT NULL	Holiday Schedule Prompt Table: HOLIDAY_TBL
10	PERIOD_ID	Character(12)	VARCHAR2(12) NOT NULL	Time Period ID Prompt Table: TL_TR_PRDS_VW
11	SCHEDULE_GRP	Character(10)	VARCHAR2(10) NOT NULL	Scheduling Organizational Group Code Prompt Table: SCH_GROUP_TBL
12	SETID_SCHED	Character(5)	VARCHAR2(5) NOT NULL	SetID for Schedule ID
13	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 Set Control Field: SETID_SCHED
14	ROTATION_ID	Character(10)	VARCHAR2(10) NOT NULL	Rotation ID Prompt Table: SCH_DEFN_ROT_VW
15	COMP_TIME_PLAN	Character(10)	VARCHAR2(10) NOT NULL	Compensatory Time Off Plan Prompt Table: TL_COMP_TIME
16	NEEDS_APPR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Needs Approval Y/N Table Edit Default Value: N
17	DAYBREAKER	Time(15)	TIMESTAMP NOT NULL	Day Breaker Time
18	DAYBREAKER_OPTIONS	Character(1)	VARCHAR2(1) NOT NULL	Day Breaker Options B=Begin Time Of Shift E=End Time Of Shift M=Majority Of Shift S=Split By Day Breaker Default Value: B
19	ROUNDING_OPTIONS	Character(1)	VARCHAR2(1) NOT NULL	Rounding Options D=Day N=None S=Segment Default Value: N
20	ROUNDING_OPTS_RULE	Character(1)	VARCHAR2(1) NOT NULL	Round Duration After Rules Y/N Table Edit Default Value: N
21	ROUNDING_OPTS_PCH	Character(1)	VARCHAR2(1) NOT NULL	Round Punches Before Rules D=Day N=None P=Punch S=Segment Y/N Table Edit Default Value: N
22	ROUNDING_OPTS_DAY	Character(1)	VARCHAR2(1) NOT NULL	Used for Rounding by day in workgroup Y/N Table Edit Default Value: N
23	ROUNDING_INTERVALS	Number(6,2)	DECIMAL(5,2) NOT NULL	Rounding interval configuration used on Workgroup
24	ROUNDING_MARKER	Number(6,2)	DECIMAL(5,2) NOT NULL	Rounding Marker (Mins)
25	DAYBREAKER_RANGE	Character(1)	VARCHAR2(1) NOT NULL	The Day Breaker Range defines how to determine which date to allocate the day's hours to, in conjunction with the time of the Day Breaker. The options are to apply the hours to the date when the day begins or the date when the day ends. For example, if the Day Breaker is set to 2:00PM, should the hours prior to 2:00PM be considered part of this day (End option for Day Breaker range), or the previous day (Begin option for Day Breaker Range). B=Range Start Day E=Range End Day Default Value: B
26	TL_OT_ID	Character(8)	VARCHAR2(8) NOT NULL	Overtime Limit ID Prompt Table: TL_OT_SETUP_TBL
27	INCL_ML_BRK_FLG	Character(1)	VARCHAR2(1) NOT NULL	Include in Totals 1=Exclude Meals and Breaks 2=Include Meals 3=Include Breaks 4=Include Breaks and Meals Default Value: 1
28	TL_APRV_RPT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Approve Reported Time Y/N Table Edit Default Value: N
29	SCHED_DEV	Character(1)	VARCHAR2(1) NOT NULL	Display Schedule Deviation Y/N Table Edit Default Value: N
30	SCHED_TOLERANCE	Number(2,0)	SMALLINT NOT NULL	Tolerance from Schedule (min.)
31	TL_EXCLUDE_HOL	Character(1)	VARCHAR2(1) NOT NULL	Exclude Holiday Configuration at Workgroup level Y/N Table Edit Default Value: N
32	TL_CR_PARTIAL_HRS	Character(1)	VARCHAR2(1) NOT NULL	Create Parital Work hours configuration at Workgroup level Y/N Table Edit Default Value: N