COMP_RATECDPrompt Table: CRC_FA_JPN_VW
EFFDTDefault Value: %date
RATING_MODELPrompt Table: RVW_BAND_MDL_VW
REVIEW_RATINGPrompt Table: REVW_RATING_TBL
A=Active
I=Inactive
Default Value: A
SAL_AMT_TBL_JPN(SQL Table) |
Index Back |
|---|---|
Salary Increase Amount TableThis record holds Salary Increase Amounts according to CompRateCode and Review-Band. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COMP_RATECD |
Character(6) | VARCHAR2(6) NOT NULL |
Comp Rate Code
Prompt Table: CRC_FA_JPN_VW |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | RATING_MODEL |
Character(4) | VARCHAR2(4) NOT NULL |
Rating Model
Prompt Table: RVW_BAND_MDL_VW |
| 4 | REVIEW_RATING |
Character(1) | VARCHAR2(1) NOT NULL |
Review Rating
Prompt Table: REVW_RATING_TBL |
| 5 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 6 | SALINC_AMOUNT | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Amount of Salary Increase |