RB_TGRP_ALL_VW

(SQL View)
 Index Back

Task Group Template.

View to display Task Group Template Information for usage ALL

SELECT TASK_GRP_TPL_ID , APPLICATION_USAGE , DESCR FROM PS_RB_TGRP_TPL_VW WHERE APPLICATION_USAGE = 'ALL'

  • Related Language Record: RB_TGRP_ALL_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RB_TSK_TPL_ID Character(15) VARCHAR2(15) NOT NULL Task Template ID. Used by Task Management.

    Prompt Table: RB_TGRP_ALL_VW

    2 APPLICATION_USAGE Character(4) VARCHAR2(4) NOT NULL Application Usage. Holds the info about the application.
    ALL=All Applications
    CHMG=Change Management
    EVNT=Marketing Events
    FLDS=Field Service
    HIED=Higher Education
    HLPD=HelpDesk
    HRHD=HR Helpdesk
    LEAD=Lead
    OPPY=Opportunity
    PIM=Personal Information Mgmt
    RSP=Strategic Planning
    SALS=Sales
    SUPP=Support
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description