COMP_RATECDEFFDTA=Active
I=Inactive
FA=Flat Amount
HF=Hourly Rate + Flat Amount
HR=Hourly Rate
PC=Percent
PT=Points
COMP_RT_REG_VW(SQL View) |
Index Back |
|---|---|
Comp Rate Codes Non Base PayThis is the view used by comp rate codes processing that selects from PS_COMP_RATECD_TBL rate codes for North American payroll where the base pay switch is set to 'N' and rate type is not points. It is designed to be used as prompt table in the pay earnings record for the regular rate code field and in pay other earnings for the rate code field. |
| SELECT A.COMP_RATECD , A.EFFDT , A.EFF_STATUS , A.DESCRSHORT , A.COMP_BASE_PAY_SW , A.COMP_RATE_TYPE FROM PS_COMP_RATECD_TBL A WHERE A.COMP_BASE_PAY_SW = 'N' AND A.COMP_RATE_TYPE <> 'PT' AND A.CMP_CALC_BY = 'ZZ' |
| # | 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 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 5 | COMP_BASE_PAY_SW | Character(1) | VARCHAR2(1) NOT NULL | Comp Base Pay Switch |
| 6 | 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 |