TL_SRCH_EXCEPTS

(SQL View)
 Index Back

TL Exceptions for GS


SELECT A.EXCEPTION_ID , A.EMPLID , A.EMPL_RCD , A.DUR , A.SEQ_NBR , A.PROCESS_INSTANCE , A.RUN_CNTL_ID , A.EXCEPTION_SOURCE , A.EXCEPTION_STATUS , A.RESOLVED_BY , A.ACTION_DTTM , B.DESCR , B.DESCRSHORT , B.SEVERITY , B.ALLOWABLE_IND FROM PS_TL_EXCEPTION A , PS_TL_EXCEPT_DEFN B WHERE A.EXCEPTION_ID = B.EXCEPTION_ID AND B.EFFDT = ( SELECT MAX(B_ED.EFFDT) FROM PS_TL_EXCEPT_DEFN B_ED WHERE B.EXCEPTION_ID = B_ED.EXCEPTION_ID AND B_ED.EFFDT <= A.DUR)

  • Related Language Record: TL_SRCH_EX_LANG

    • # 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    13 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: TL_EXCEPT_DEFN.DESCR

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