RA_CM_TK_GP_VW1 (SQL View)	Index Back
Campaign Task Group View Marketing Task Group View

RA_CM_TK_GP_VW1

(SQL View)

Campaign Task Group View

Marketing Task Group View

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

# 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

3 RA_TASK_SHELL_ID Number(15,0) DECIMAL(15) NOT NULL Marketing - Task Shell ID
Prompt Table: %EDITTABLE

#	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
3	RA_TASK_SHELL_ID	Number(15,0)	DECIMAL(15) NOT NULL	Marketing - Task Shell ID Prompt Table: %EDITTABLE