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

RA_CM_TK_GRP_VW

(SQL View)

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

#	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