RA_CM_TGP_LN_VW (SQL View)	Index Back
Campaign Task Group Marketing Campaign Task Group language View

RA_CM_TGP_LN_VW

(SQL View)

Campaign Task Group

Marketing Campaign Task Group language View

SELECT B.RA_TASK_GRP_ID ,B.LANGUAGE_CD , B.DESCR50 FROM PS_RA_TK_GP_DFN_LN B WHERE B.RA_TASK_SHELL_TYPE = 'CAMP'

Related Language Record for RA_CM_TK_GRP_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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

3 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	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50