RSF_TSK_STYP_VW

(SQL View)
 Index Back

Task Type View.

View to get Active Task Types that are for generic usage. Used by Sales Task Management.

SELECT TASK_TYPE , DESCR , APPLICATION_USAGE FROM PS_RB_TSK_TYPE WHERE ACTIVE_FLG = 'Y' AND APPLICATION_USAGE IN ( 'ALL', 'SALS')

  • Related Language Record: RB_TSK_TYP_VW_L

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TASK_TYPE Character(18) VARCHAR2(18) NOT NULL Copied from Resouce Management (8.1). Added new label id for "Task Type"
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 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