TL_EXCEPTION (SQL Table)	Index Back
T&L Exception This table stores up to one occurence of a specific Exception per Employee & Record Number per day. Time Administration and Time Validation processes produce and resolve exceptions, based on system defined validations, as well as user defined rules or validations. Time Management events enable users to View Exceptions, Allow Exceptions and resolve the conditions which cause exceptions.

TL_EXCEPTION

(SQL Table)

T&L Exception

This table stores up to one occurence of a specific Exception per Employee & Record Number per day. Time Administration and Time Validation processes produce and resolve exceptions, based on system defined validations, as well as user defined rules or validations. Time Management events enable users to View Exceptions, Allow Exceptions and resolve the conditions which cause exceptions.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EXCEPTION_ID Character(8) VARCHAR2(8) NOT NULL Exception ID

2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

4 DUR Date(10) DATE NOT NULL Date Under Report associates time being reported, scheduled or paid, to a specific date.

5 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
Default Value: 1

6 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

7 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

8 EXCEPTION_SOURCE Character(3) VARCHAR2(3) NOT NULL Identifies the process which generated the Exception.
LD=Labor Distribution/Dilution
PI=Payroll Interface
TA=Time Administration
TVE=Time Validation Elapsed
TVP=Time Validation Punch

9 EXCEPTION_STATUS Character(1) VARCHAR2(1) NOT NULL Status of Exception
A=Allowed
R=Resolved
U=Unresolved

10 RESOLVED_BY Character(30) VARCHAR2(30) NOT NULL Resolved by whom?

11 ACTION_DTTM DateTime(26) TIMESTAMP Override Date Time

12 START_DT Date(10) DATE Start Date

13 END_DT Date(10) DATE end date

14 MSG_DATA1 Character(100) VARCHAR2(100) NOT NULL Message Data Text 1

15 MSG_DATA2 Character(100) VARCHAR2(100) NOT NULL Message Data Text 2

16 MSG_DATA3 Character(100) VARCHAR2(100) NOT NULL Message Data Text 3

17 MSG_DATA4 Character(100) VARCHAR2(100) NOT NULL Message Data Text 4

18 MSG_DATA5 Character(100) VARCHAR2(100) NOT NULL Message Data Text 5

19 COMMENTS Long Character CLOB Comment

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EXCEPTION_ID	Character(8)	VARCHAR2(8) NOT NULL	Exception ID
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
4	DUR	Date(10)	DATE NOT NULL	Date Under Report associates time being reported, scheduled or paid, to a specific date.
5	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number Default Value: 1
6	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
7	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
8	EXCEPTION_SOURCE	Character(3)	VARCHAR2(3) NOT NULL	Identifies the process which generated the Exception. LD=Labor Distribution/Dilution PI=Payroll Interface TA=Time Administration TVE=Time Validation Elapsed TVP=Time Validation Punch
9	EXCEPTION_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status of Exception A=Allowed R=Resolved U=Unresolved
10	RESOLVED_BY	Character(30)	VARCHAR2(30) NOT NULL	Resolved by whom?
11	ACTION_DTTM	DateTime(26)	TIMESTAMP	Override Date Time
12	START_DT	Date(10)	DATE	Start Date
13	END_DT	Date(10)	DATE	end date
14	MSG_DATA1	Character(100)	VARCHAR2(100) NOT NULL	Message Data Text 1
15	MSG_DATA2	Character(100)	VARCHAR2(100) NOT NULL	Message Data Text 2
16	MSG_DATA3	Character(100)	VARCHAR2(100) NOT NULL	Message Data Text 3
17	MSG_DATA4	Character(100)	VARCHAR2(100) NOT NULL	Message Data Text 4
18	MSG_DATA5	Character(100)	VARCHAR2(100) NOT NULL	Message Data Text 5
19	COMMENTS	Long Character	CLOB	Comment