WCS_EP_APPR (SQL Table)	Index Back
WCS Performance Rating Table This table is available to store performance rating information for Compensation Cycles processing if PeopleSoft ePerformance is not being used. If the Performance Integration Source on the Compensation Cycle Definition is set to 'Other', this table will be used to retrieve performance rating information.

WCS_EP_APPR

(SQL Table)

WCS Performance Rating Table

This table is available to store performance rating information for Compensation Cycles processing if PeopleSoft ePerformance is not being used. If the Performance Integration Source on the Compensation Cycle Definition is set to 'Other', this table will be used to retrieve performance rating information.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PERSON

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

3 PERIOD_BEGIN_DT Date(10) DATE NOT NULL Period Begin Date

4 PERIOD_END_DT Date(10) DATE NOT NULL Period End Date

5 EP_REVIEW_TYPE Character(8) VARCHAR2(8) NOT NULL Review type
Prompt Table: EP_REVW_TYP_VW

6 EP_RATING Number(6,2) DECIMAL(5,2) NOT NULL Rating

7 REVIEW_POINTS Number(3,0) SMALLINT NOT NULL Review Points

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
3	PERIOD_BEGIN_DT	Date(10)	DATE NOT NULL	Period Begin Date
4	PERIOD_END_DT	Date(10)	DATE NOT NULL	Period End Date
5	EP_REVIEW_TYPE	Character(8)	VARCHAR2(8) NOT NULL	Review type Prompt Table: EP_REVW_TYP_VW
6	EP_RATING	Number(6,2)	DECIMAL(5,2) NOT NULL	Rating
7	REVIEW_POINTS	Number(3,0)	SMALLINT NOT NULL	Review Points
8	REVIEW_RATING	Character(1)	VARCHAR2(1) NOT NULL	Review Rating