TL_EXCP_DFN_LNG (SQL Table)	Index Back
T&L Exception Defn Rel Lang Exception Definitions are used by the Time Validation and Time Administration processes during the generation and resolution of exceptions. Each exception definition is assigned a severity and an allowable indicator which are used in subsequent processing, as well as a message set and message number to manage message display in association with the exception. The allowable indicator assigned on the exception definition is used by Time Administration, in conjunction with the status of individual exceptions to determine whether or not the related Reported Time will be included for generation of Payable Time.

TL_EXCP_DFN_LNG

(SQL Table)

T&L Exception Defn Rel Lang

Exception Definitions are used by the Time Validation and Time Administration processes during the generation and resolution of exceptions. Each exception definition is assigned a severity and an allowable indicator which are used in subsequent processing, as well as a message set and message number to manage message display in association with the exception. The allowable indicator assigned on the exception definition is used by Time Administration, in conjunction with the status of individual exceptions to determine whether or not the related Reported Time will be included for generation of Payable Time.

Related Language Record for TL_EXCEPT_DEFN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

3 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %Date

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

5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
Default Value: TL_EXCP_DFN_LNG.DESCR

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EXCEPTION_ID	Character(8)	VARCHAR2(8) NOT NULL	Exception ID
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %Date
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
5	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description Default Value: TL_EXCP_DFN_LNG.DESCR