TL_TSKPRF_VW

(SQL View)
 Index Back

Task Profile & Template View

This view is used to control the Task Profiles displayed in the list box as the Task Profile Template ID for the Profile must equal that of the Task Profile Template ID selected for the Taskgroup.

SELECT A.TASK_PRFL_TMPLT_ID ,A.TASK_PROFILE_ID , A.EFFDT , A.DESCR FROM PS_TL_TSKPRF A WHERE A.EFF_STATUS = 'A'

  • Related Language Record: TL_TSKPRF_V_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TASK_PRFL_TMPLT_ID Character(10) VARCHAR2(10) NOT NULL Task Template ID
    2 TASK_PROFILE_ID Character(10) VARCHAR2(10) NOT NULL Task Profile ID
    3 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description