RA_CM_TK_GRP_VW

(SQL View)
Index Back

Campaign Task Group View

Marketing Task Group View - view of task groups for campaigns in active status

SELECT B.RA_TASK_GRP_ID , B.DESCR50 FROM PS_RA_TASK_GRP_DFN B WHERE B.RA_TASK_SHELL_TYPE = 'CAMP' AND B.STATUS = 'A'

  • Related Language Record: RA_CM_TGP_LN_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RA_TASK_GRP_ID Number(10,0) DECIMAL(10) NOT NULL Task Group ID Task Library (new definition)
    2 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50