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 |