COMP_RATECDEFFDTDefault Value: %date
FA=Flat Amount
HF=Hourly Rate + Flat Amount
HR=Hourly Rate
PC=Percent
PT=Points
SEN_RATECD_VW(SQL View) |
Index Back |
|---|---|
Seniority Pay Rate Code ViewThis view is used as a prompt table for the COMP_RATECD field in Seniority Pay run control panels. |
| SELECT COMP_RATECD , EFFDT , DESCR , COMP_RATE_TYPE FROM PS_COMP_RATECD_TBL WHERE 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
Default Value: %date |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | 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 |