EP_CMP_WRT_VW (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_CMP_WRT_VW

(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 , 'W' , EP_RESULTS_WRITER FROM PS_EP_COMP_WRT_TBL

Related Language Record: EP_CMPWRTVW_LNG

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 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

4 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	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
4	EP_SUGGEST_RESULT	Long Character	CLOB	Suggested Results Test