EP_CMPWRTVW_LNG (SQL View)	Index Back
Sub-Competency Results Writer Sub-Competency Results Writer - Used as writing helper when updating the results in a performance review. Uses various character identifiers to pass gender specific pronouns to tailor the sentences to an individual.

EP_CMPWRTVW_LNG

(SQL View)

Sub-Competency Results Writer

Sub-Competency Results Writer - Used as writing helper when updating the results in a performance review. Uses various character identifiers to pass gender specific pronouns to tailor the sentences to an individual.

SELECT COMPETENCY , REVIEW_RATING ,LANGUAGE_CD , 'W' , EP_RESULTS_WRITER FROM PS_EP_COMPWRT_LANG

Related Language Record for EP_CMP_WRT_VW

Parent record: EP_SUB_PROF_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 COMPETENCY Character(8) VARCHAR2(8) NOT NULL Competency

2 REVIEW_RATING Character(1) VARCHAR2(1) NOT NULL Review Rating

3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

4 EP_WRT_SRC Character(1) VARCHAR2(1) NOT NULL Tip Source
C=Other Evaluators' Comments
D=Development Tips
P=Performance Notes
S=Suggested Results
W=Results Writer

5 EP_SUGGEST_RESULT Long Character CLOB Suggested Results Test

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMPETENCY	Character(8)	VARCHAR2(8) NOT NULL	Competency
2	REVIEW_RATING	Character(1)	VARCHAR2(1) NOT NULL	Review Rating
3	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	EP_WRT_SRC	Character(1)	VARCHAR2(1) NOT NULL	Tip Source C=Other Evaluators' Comments D=Development Tips P=Performance Notes S=Suggested Results W=Results Writer
5	EP_SUGGEST_RESULT	Long Character	CLOB	Suggested Results Test