COMP_RATECDEFFDTRATING_MODELREVIEW_RATINGA=Active
I=Inactive
UPG_EP_SAL_JPN(SQL Table) |
Index Back |
|---|---|
Upgrade: Japan Salary IncreaseThis table is a used as a temporary table during upgrade of the Japan Salary Increase tables. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COMP_RATECD |
Character(6) | VARCHAR2(6) NOT NULL | Comp Rate Code |
| 2 | EFFDT |
Date(10) | DATE | Effective Date |
| 3 | RATING_MODEL |
Character(4) | VARCHAR2(4) NOT NULL | Rating Model |
| 4 | REVIEW_RATING |
Character(1) | VARCHAR2(1) NOT NULL | Review Rating |
| 5 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 6 | SALINC_AMOUNT | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Amount of Salary Increase |
| 7 | SALSTEP_INC | Number(2,0) | SMALLINT NOT NULL | Number of Steps to Increase |