EP_SUB_WRT_TBL (SQL Table)	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_SUB_WRT_TBL

(SQL Table)

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.

Related Language Record: EP_SUBWRT_LANG

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 EP_SUB_ID Character(12) VARCHAR2(12) NOT NULL Sub-Item unique identifier

3 REVIEW_RATING Character(1) VARCHAR2(1) NOT NULL Review Rating
Prompt Table: REVW_RATING_TBL

4 EP_SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence number

5 EP_RESULTS_WRITER Long Character CLOB Results writer statement, contains character identifers used to pass in gender specific pronouns

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMPETENCY	Character(8)	VARCHAR2(8) NOT NULL	Competency
2	EP_SUB_ID	Character(12)	VARCHAR2(12) NOT NULL	Sub-Item unique identifier
3	REVIEW_RATING	Character(1)	VARCHAR2(1) NOT NULL	Review Rating Prompt Table: REVW_RATING_TBL
4	EP_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence number
5	EP_RESULTS_WRITER	Long Character	CLOB	Results writer statement, contains character identifers used to pass in gender specific pronouns