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.

# 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 Record
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
ST=Submit Time
TA=Time Administration
TS=Timesheet
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