SAL_GRD_REV_JPN (SQL Table)	Index Back
Salary Grade Review Table This record is a child of SAL_GRADE_TBL. It holds the review weights for each review used in the Shokaku (Grade Advance) Eligibility processes of the Japanese specific features. /Japan HR 18-Aug-2000-0/ Newly created

SAL_GRD_REV_JPN

(SQL Table)

Salary Grade Review Table

This record is a child of SAL_GRADE_TBL. It holds the review weights for each review used in the Shokaku (Grade Advance) Eligibility processes of the Japanese specific features. /*Japan HR 18-Aug-2000-0*/ Newly created

Parent record: SAL_GRADE_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

2 SAL_ADMIN_PLAN Character(4) VARCHAR2(4) NOT NULL Salary Administration Plan

3 GRADE Character(3) VARCHAR2(3) NOT NULL Salary Grade

4 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

5 REVIEW_SEQUENCE Number(3,0) SMALLINT NOT NULL This field is used to identify the review to which a review weight will be assigned

6 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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	SAL_ADMIN_PLAN	Character(4)	VARCHAR2(4) NOT NULL	Salary Administration Plan
3	GRADE	Character(3)	VARCHAR2(3) NOT NULL	Salary Grade
4	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
5	REVIEW_SEQUENCE	Number(3,0)	SMALLINT NOT NULL	This field is used to identify the review to which a review weight will be assigned
6	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