PER062_TMP2_JPN

(SQL Table)
Index Back

temporary table for per062jp

/* Japan HR 12-Sep-2000-0 */ This table is used in PER062JP.SQR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
4 SETID_SALARY Character(5) VARCHAR2(5) NOT NULL Salary SetID
5 EP_REVIEW_ID Character(8) VARCHAR2(8) NOT NULL Review ID
6 RATING_MODEL Character(4) VARCHAR2(4) NOT NULL Rating Model
7 REVIEW_RATING Character(1) VARCHAR2(1) NOT NULL Review Rating
8 ELIGIBILITY_POINTS Number(5,1) DECIMAL(4,1) NOT NULL This field represents the minimum number of review points that must be met for an employee to graduate out of the grade
9 REVIEW_WEIGHT Number(6,2) DECIMAL(5,2) NOT NULL The Review Weight is assigned to a review and used to calculate a weighted average review score