SAL_RATECD_TBL(SQL Table) |
Index Back |
|---|---|
Salary Grade TableSAL_GRADE_TBL is the reference table for salary ranges. The mimimum, midpoint, and maximum salary are used to calculate compa ratio and percent of range. Several edits are done in the system to warn that an employee is over the maximum or under the mimimum for their salary grade. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_HR.SETID Prompt Table: SET_VLD_HR_05 |
| 2 | SAL_ADMIN_PLAN |
Character(4) | VARCHAR2(4) NOT NULL |
Salary Administration Plan
Prompt Table: SAL_PLAN_TBL |
| 3 | GRADE |
Character(3) | VARCHAR2(3) NOT NULL | Salary Grade |
| 4 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 5 | STEP |
Number(2,0) | SMALLINT NOT NULL | Step |
| 6 | COMP_EFFSEQ |
Number(3,0) | SMALLINT NOT NULL | Compensation Eff Sequence |
| 7 | COMP_RATECD |
Character(6) | VARCHAR2(6) NOT NULL |
Comp Rate Code
Prompt Table: BASE_RATECD_VW |
| 8 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Default Value: SAL_STEP_TBL.CURRENCY_CD Prompt Table: CURRENCY_CD_TBL |
| 9 | COMP_FREQUENCY | Character(5) | VARCHAR2(5) NOT NULL |
Compensation Frequency
A=Annual B=Biweekly C=Contract D=Daily H=Hourly M=Monthly S=Semimonthly W=Weekly Prompt Table: COMP_FREQ_VW |
| 10 | HOURLY_RT | Number(19,6) | DECIMAL(18,6) NOT NULL | Hourly Rate |
| 11 | MONTHLY_RT | Number(19,3) | DECIMAL(18,3) NOT NULL | Monthly Rate |
| 12 | ANNUAL_RT | Number(19,3) | DECIMAL(18,3) NOT NULL | Annual Rate |
| 13 | COMP_RATE_POINTS | Number(5,0) | INTEGER NOT NULL | Comp Rate Points |
| 14 | COMP_PCT | Number(7,3) | DECIMAL(6,3) NOT NULL | Comp Percent |
| 15 | RATE_CODE_GROUP | Character(6) | VARCHAR2(6) NOT NULL |
Rate Code Group Name
Prompt Table: COMPRT_GRP_TBL |
| 16 | COMPRATE | Number(19,6) | DECIMAL(18,6) NOT NULL | Compensation Rate |
| 17 | DAILY_RT | Number(19,3) | DECIMAL(18,3) NOT NULL | Daily Rate |