JOBCD_RATECD_VW(SQL View) |
Index Back |
|---|---|
Jobcode Rate Code ViewA view of the Jobcode Comp Rate Table that specifies the Base Comp Rates of the Jobcode. |
| SELECT A.COMP_RATECD ,A.SETID ,A.EFFDT ,A.JOBCODE ,B.EFF_STATUS ,B.DESCR ,B.DESCRSHORT ,B.COMP_BASE_PAY_SW ,B.COMP_RATE_TYPE ,A.COMPRATE ,A.COMP_PCT ,A.COMP_FREQUENCY ,A.CURRENCY_CD ,B.ERNCD ,B.USE_HIGHEST_RT_SW ,A.COMP_RATE_POINTS FROM PS_JOBCD_COMP_RATE A , PS_COMP_RATECD_TBL B WHERE A.COMP_RATECD = B.COMP_RATECD AND B.COMP_BASE_PAY_SW = 'Y' AND B.EFFDT = ( SELECT MAX(EFFDT) FROM PS_COMP_RATECD_TBL C WHERE B.COMP_RATECD = C.COMP_RATECD AND C.EFFDT <= A.EFFDT AND B.COMP_BASE_PAY_SW = 'Y' ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COMP_RATECD | Character(6) | VARCHAR2(6) NOT NULL | Comp Rate Code |
| 2 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 3 | EFFDT | Date(10) | DATE | Effective Date |
| 4 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL | Job Code |
| 5 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 8 | COMP_BASE_PAY_SW | Character(1) | VARCHAR2(1) NOT NULL | Comp Base Pay Switch |
| 9 | COMP_RATE_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Rate Code Type
FA=Flat Amount HF=Hourly Rate + Flat Amount HR=Hourly Rate PC=Percent PT=Points |
| 10 | COMPRATE | Number(19,6) | DECIMAL(18,6) NOT NULL | Compensation Rate |
| 11 | COMP_PCT | Number(7,3) | DECIMAL(6,3) NOT NULL | Comp Percent |
| 12 | 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 |
| 13 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 14 | ERNCD | Character(3) | VARCHAR2(3) NOT NULL | Earnings Code |
| 15 | USE_HIGHEST_RT_SW | Character(1) | VARCHAR2(1) NOT NULL | Use Highest Rate |
| 16 | COMP_RATE_POINTS | Number(5,0) | INTEGER NOT NULL | Comp Rate Points |