TL_EXCEPT_DEFN

(SQL Table)
 Index Back

T&L Exception Definition

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: TL_EXCP_DFN_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EXCEPTION_ID Character(8) VARCHAR2(8) NOT NULL Exception ID
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: TL_EXCEPT_DEFN.DESCR

    5 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.

    Prompt Table: TL_MSG_SET_VW

    6 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.

    Prompt Table: TL_MSG_CATLG_VW

    7 SEVERITY Character(1) VARCHAR2(1) NOT NULL Severity of Exception
    H=High
    L=Low
    M=Medium
    8 ALLOWABLE_IND Character(1) VARCHAR2(1) NOT NULL Allowable
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    9 SAVE_IND Character(1) VARCHAR2(1) NOT NULL Archive Exception

    Y/N Table Edit

    Default Value: N

    10 PS_DELIVERED Character(1) VARCHAR2(1) NOT NULL PeopleSoft Delivered
    N=No
    Y=Yes