BASE_RATECD_VW(SQL View) |
Index Back |
|---|---|
Base Rate Code ViewA view of the Comp Rate Code Table that specifies the base rate codes |
| SELECT COMP_RATECD ,EFFDT ,EFF_STATUS ,DESCR ,DESCRSHORT ,COMP_BASE_PAY_SW ,COMP_RATE_TYPE ,COMPRATE ,COMP_PCT ,COMP_FREQUENCY ,CURRENCY_CD ,ERNCD ,USE_HIGHEST_RT_SW ,RATE_CODE_CLASS ,CMP_CALC_BY ,LOOKUP_ID FROM PS_COMP_RATECD_TBL WHERE COMP_BASE_PAY_SW = 'Y' AND RATE_CODE_CLASS <> 'SENPAY' |
| # | 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 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 6 | COMP_BASE_PAY_SW | Character(1) | VARCHAR2(1) NOT NULL | Comp Base Pay Switch |
| 7 | 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 |
| 8 | COMPRATE | Number(19,6) | DECIMAL(18,6) NOT NULL | Compensation Rate |
| 9 | COMP_PCT | Number(7,3) | DECIMAL(6,3) NOT NULL | Comp Percent |
| 10 | 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 |
| 11 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 12 | ERNCD | Character(3) | VARCHAR2(3) NOT NULL | Earnings Code |
| 13 | USE_HIGHEST_RT_SW | Character(1) | VARCHAR2(1) NOT NULL | Use Highest Rate |
| 14 | RATE_CODE_CLASS | Character(6) | VARCHAR2(6) NOT NULL |
Defines classes of rate codes. A rate code class can be used to bundle and group rate codes defined in the Comp Rate Code Table.
Prompt Table: RATECD_CLS_TBL |
| 15 | CMP_CALC_BY | Character(2) | VARCHAR2(2) NOT NULL |
Calculated By
EX=Extended RM=Rate Matrix ZZ=None |
| 16 | LOOKUP_ID | Character(15) | VARCHAR2(15) NOT NULL | Main unique identifier for Configurable Matrices. |