RB_AMPOUTPGP_VW (SQL View)	Index Back
View to fetch Product Groups View to fetch Product Groups suggested by NLP

RB_AMPOUTPGP_VW

(SQL View)

View to fetch Product Groups

View to fetch Product Groups suggested by NLP

SELECT DISTINCT MCF_EMAIL_ID , KB_THRESHOLD , DESCR254 FROM PS_RB_AMP_NLPOUTPT WHERE EML_NLP_RET_CATG = '1'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 MCF_EMAIL_ID Number(16,0) DECIMAL(16) NOT NULL Email Id

2 KB_THRESHOLD Number(6,2) DECIMAL(5,2) NOT NULL Used to indicate the threshold

3 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	MCF_EMAIL_ID	Number(16,0)	DECIMAL(16) NOT NULL	Email Id
2	KB_THRESHOLD	Number(6,2)	DECIMAL(5,2) NOT NULL	Used to indicate the threshold
3	DESCR254	Character(254)	VARCHAR2(254) NOT NULL	Description of length 254