TL_TMPLT_PAR_VW

(SQL View)
 Index Back

Required Parameter View

View of TL_TMPLT_PARMS that select distinct instances of required parameters. Used in validating the data entry during rule creation.

SELECT DISTINCT TEMPLATE_ID , RECNAME , FIELDNAME , LIST_TYPE FROM PS_TL_TMPLT_PARMS WHERE REQUIRED_FIELD = 'Y' AND RECNAME <> 'TL_TMPLT_RULE'

  • Parent record: TL_TMPLT_PARMS

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TEMPLATE_ID Character(15) VARCHAR2(15) NOT NULL Rule Template
    2 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
    3 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

    Prompt Table: PSRECFIELDALL

    4 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