TL_RESPRF_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RESTRICTION_PRF_ID	Character(10)	VARCHAR2(10) NOT NULL	Restriction Profile ID
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_RESPRF_TBL.DESCR
6	RES_UNSCHED_MEAL	Character(1)	VARCHAR2(1) NOT NULL	Restrict Unsched Meal Punch Y/N Table Edit Default Value: N
7	RES_EARLY_IN	Character(1)	VARCHAR2(1) NOT NULL	Restrict Early In Y/N Table Edit Default Value: N
8	EARLY_IN_PUNCH	Number(3,0)	SMALLINT NOT NULL	Early In Margin
9	RES_LATE_IN	Character(1)	VARCHAR2(1) NOT NULL	Restrict Late In Y/N Table Edit Default Value: N
10	LATE_IN_PUNCH	Number(3,0)	SMALLINT NOT NULL	Late In Margin
11	RES_EARLY_OUT	Character(1)	VARCHAR2(1) NOT NULL	Restrict Early Out Y/N Table Edit Default Value: N
12	EARLY_OUT_PUNCH	Number(3,0)	SMALLINT NOT NULL	Early Out Margin
13	RES_LATE_OUT	Character(1)	VARCHAR2(1) NOT NULL	Restrict Late Out Y/N Table Edit Default Value: N
14	LATE_OUT_PUNCH	Number(3,0)	SMALLINT NOT NULL	Late Out Margin
15	RES_EARLY_MEAL	Character(1)	VARCHAR2(1) NOT NULL	Restrict Early Meal Y/N Table Edit Default Value: N
16	EARLY_MEAL	Number(3,0)	SMALLINT NOT NULL	Early Meal Margin
17	RES_LATE_MEAL	Character(1)	VARCHAR2(1) NOT NULL	Restrict Late Meal Y/N Table Edit Default Value: N
18	LATE_MEAL	Number(3,0)	SMALLINT NOT NULL	Late Meal Margin
19	RES_EARLY_BREAK	Character(1)	VARCHAR2(1) NOT NULL	Restrict Early Break Y/N Table Edit Default Value: N
20	EARLY_BREAK	Number(3,0)	SMALLINT NOT NULL	Early Break Margin
21	RES_LATE_BREAK	Character(1)	VARCHAR2(1) NOT NULL	Restrict Late Break Y/N Table Edit Default Value: N
22	LATE_BREAK	Number(3,0)	SMALLINT NOT NULL	Late Break Margin