EP_COMP_WRT_TBL (SQL Table)	Index Back
Competency Results Writer Record used to store the competency results writer text

EP_COMP_WRT_TBL

(SQL Table)

Competency Results Writer

Record used to store the competency results writer text

Related Language Record: EP_COMPWRT_LANG

Parent record: CM_RATING_DESCR

# 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
Prompt Table: REVW_RATING_TBL

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

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

5 LAST_UPDATE_DTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
Default Value: %DATETIME

#	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 Prompt Table: REVW_RATING_TBL
3	EP_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence number
4	EP_RESULTS_WRITER	Long Character	CLOB	Results writer statement, contains character identifers used to pass in gender specific pronouns
5	LAST_UPDATE_DTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. Default Value: %DATETIME