TL_VAL_RLST_VW

(SQL View)
 Index Back

TL Value List


SELECT R.LIST_ID ,R.LIST_TYPE ,R.EFFDT ,R.DESCR ,R.DESCRSHORT FROM PS_TL_VAL_RLST_TBL R WHERE R.EFFDT = ( SELECT MAX(M.EFFDT) FROM PS_TL_VAL_RLST_TBL M WHERE M.LIST_ID = R.LIST_ID AND M.EFFDT <= %CurrentDateIn)

  • Related Language Record: TL_VAL_RLST_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LIST_ID Character(12) VARCHAR2(12) NOT NULL List ID
    2 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
    3 EFFDT Date(10) DATE 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_VAL_LIST_TBL.DESCR