RAE_TGRP_TPL_VW

(SQL View)
 Index Back

Task Group Template View.

Gives active Task Group Templates by Application Usage

SELECT APPLICATION_USAGE , TASK_GRP_TPL_ID , DESCR FROM PS_RB_TGRP_TPL WHERE ACTIVE_FLG = 'Y' AND APPLICATION_USAGE ='EVNT'

  • Related Language Record: RB_TGRP_TPL_LG2

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 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
    2 TASK_GRP_TPL_ID Character(10) VARCHAR2(10) NOT NULL Task Group Template ID primary key
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description