RA_PROFCNCY_VW (SQL View)	Index Back
Proficiency View Marketing View that fetches the Proficiency Details.

RA_PROFCNCY_VW

(SQL View)

Proficiency View

Marketing View that fetches the Proficiency Details.

SELECT DISTINCT review_rating , DESCR FROM PS_REVW_RATING_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROFICIENCY Character(1) VARCHAR2(1) NOT NULL Proficiency Field. This Field is imported into CRM DB from Human Resources Database.

2 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROFICIENCY	Character(1)	VARCHAR2(1) NOT NULL	Proficiency Field. This Field is imported into CRM DB from Human Resources Database.
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description