TL_ALRT_CRT

(SQL Table)
 Index Back

Alert Criteria

  • Related Language Record: TL_ALRT_CRT_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ALERT_ID Character(10) VARCHAR2(10) NOT NULL Alert Criterion ID
    2 ALERT_TYPE Character(2) VARCHAR2(2) NOT NULL Alert Type
    B=Balances
    E=Exception
    L=Limit
    P=Pattern
    S=Status
    U=Unprocessed Data
    V=Data Verification

    Default Value: L

    3 ALERT_SOURCE Character(2) VARCHAR2(2) NOT NULL Alert Source
    A=Absence Event
    B=Benefit Plan
    C=Comp or Leave Time
    E=Exceptions
    P=Payable Time
    R=Reported Time

    Default Value: R

    4 PERIOD_ID Character(12) VARCHAR2(12) NOT NULL Calendar

    Prompt Table: TL_TR_PRDS_VW

    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 ALERT_SUB_TYPE Character(2) VARCHAR2(2) NOT NULL Alert Sub Type. Further classifies the type / nature of the Alert Criterion. Serves to control some of the parameter entry for the criterion.
    BB=Benefits Plan
    BC=Comp Time Plan
    EA=Attendance-related Exception
    EE=Exceptions by ID
    ES=Exceptions by Severity
    NA=Not Applicable
    PA=Reports Leave
    PE=Works Excessive Hours
    PW=Works without Meals or Breaks
    VE=Not Available
    VP=Quantity is Not Positive
    VT=Check TRC
    VZ=Quantity is Zero

    Default Value: NA

    7 LIST_TYPE Character(4) VARCHAR2(4) NOT NULL List type for Values
    0=TCD Group
    1=TaskGroup
    10=Company
    11=Paygroup
    12=Grade
    13=Step
    14=Punch Type
    15=Employee Status
    16=Employee Type
    17=Attendance Violations
    18=Absence Take
    19=Compensatory Time Off Plan
    2=Time Reporting Codes
    20=Plan Type
    21=Payable Status
    22=Reported Status
    23=Absence Status
    24=Exception
    25=Severity
    26=Benefit Plan
    27=Absence Entitlement
    3=WorkGroup
    4=Union Code
    5=Jobcode
    6=Department
    7=Position number
    8=Location
    9=Shift
    8 VALUELIST Character(30) VARCHAR2(30) NOT NULL Group of Values for "Value List'

    Prompt Table: %EDITTABLE

    9 LIST_TYPE2 Character(4) VARCHAR2(4) NOT NULL List type for Values. Copy of LIST_TYPE for storing multiples on same definition.
    0=TCD Group
    1=TaskGroup
    10=Company
    11=Paygroup
    12=Grade
    13=Step
    14=Punch Type
    15=Employee Status
    16=Employee Type
    17=Attendance Violations
    18=Absence Take
    19=Compensatory Time Off Plan
    2=Time Reporting Codes
    20=Benefit Plan
    21=Payable Status
    22=Reported Status
    23=Absence Status
    24=Exception
    25=Severity
    3=Work Group
    4=Union Code
    5=Jobcode
    6=Departments
    7=Position number
    8=Location
    9=Shift
    10 VALUELIST2 Character(30) VARCHAR2(30) NOT NULL Value List ID. Clone of field VALUELIST.

    Prompt Table: %EDITTABLE2

    11 ALERT_SUB_TYPE2 Character(2) VARCHAR2(2) NOT NULL Alert Sub Type2. Further classifies the type / nature of the Alert Criterion. Serves to control some of the parameter entry for the criterion.
    NA=Not Applicable
    PD=Occurs on back-to-back days
    PH=Occurs next to a Holiday
    PO=Occurs

    Default Value: NA

    12 TL_ALERTS_OPER1 Character(2) VARCHAR2(2) NOT NULL Criterion Type
    <=is less than
    <==is less than or equal to
    <>=is not equal to
    ==is equal to
    >=is greater than
    >==is greater than or equal to
    13 ALERT_LIMIT1 Signed Number(16,2) DECIMAL(14,2) NOT NULL Numeric (lower) boundary to specify condition when an alert should be triggered.
    14 TL_ALERTS_OPER2 Character(2) VARCHAR2(2) NOT NULL Additional Criterion (Or)
    <=is less than
    <==is less than or equal to
    <>=is not equal to
    ==is equal to
    >=is greater than
    >==is greater than or equal to
    15 ALERT_LIMIT2 Signed Number(16,2) DECIMAL(14,2) NOT NULL Numeric boundary to specify condition when an alert should be triggered.
    16 ALERT_UOM Character(2) VARCHAR2(2) NOT NULL Identifies what is being measured with a given alert criteria, e.g. the total quantity, the hours, the estimated gross amount.
    DA=Distributed Amount
    EG=Estimated Gross
    HR=Hours
    NA=Not Applicable
    OC=Count (Occurrences)
    QT=Quantity

    Default Value: NA

    17 ITEMNAME Character(30) VARCHAR2(30) NOT NULL Item Name
    18 PANELNAME Character(18) VARCHAR2(18) NOT NULL Panelname
    19 PORTAL_NAME Character(30) VARCHAR2(30) NOT NULL Portal Name (see PSPRDMDEFN).
    20 PORTAL_OBJNAME Character(30) VARCHAR2(30) NOT NULL Portal Object Name
    21 DESCRLONG Long Character CLOB Long Description
    22 NOTIFY_EMPLOYEE Character(1) VARCHAR2(1) NOT NULL Field introduced to control whether manager's modifications to the employees time should require a notification to be sent.

    Y/N Table Edit

    Default Value: N

    23 TRC_TYPE Character(1) VARCHAR2(1) NOT NULL This defines TRC Type of Hours,Amounts ,Units
    A=Amount
    H=Hours
    U=Units