RB_AMPOUTTYP_VW (SQL View)	Index Back
View to fetch Types View to fetch Types suggested by NLP

RB_AMPOUTTYP_VW

(SQL View)

View to fetch Types

View to fetch Types suggested by NLP

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

# 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