GradeLaddersstepRates
GradeLaddersstepRates
Columns
| Name | Type | Description |
| GradeLaddersEffectiveEndDate [KEY] | Date | GradeLaddersEffectiveEndDate of GradeLaddersstepRates |
| GradeLaddersEffectiveStartDate [KEY] | Date | GradeLaddersEffectiveStartDate of GradeLaddersstepRates |
| GradeLaddersGradeLadderId [KEY] | Long | GradeLaddersGradeLadderId of GradeLaddersstepRates |
| RateId [KEY] | Long | System generated primary key column. |
| EffectiveStartDate [KEY] | Date | Date Effective Entity: indicates the date at the beginning of the date range within which the row is effective. |
| EffectiveEndDate [KEY] | Date | Date Effective Entity: indicates the date at the end of the date range within which the row is effective. |
| LegislativeDataGroupId | Long | Foreign key to PER_LEGISLATIVE_DATA_GROUPS. |
| LegislationCode | String | Legislation code derived from Legal Entity. |
| RateName | String | Denoted the name for Rate. |
| RateType | String | Stores rate type, whether it's Salary/Bonus/Overtime. Gets values from look up : GRADE_PAY_RATE_TYPE |
| CurrencyCode | String | Currency Code for the rate values defined for the rate in per_rate_values_f table. |
| RateFrequency | String | Frequency of the rate : Annual/Monthly/Hourly/Payroll Period. Gets values from lookup : CMP_SALARY_BASIS? |
| AnnualizationFactor | Double | Annualization Factor value defaults based on the selected Frequency. Eg : 1 for Annual, 12 for monthly, 2080 for hourly, manually provided value in the UI for Payroll period |
| ActiveStatus | String | Status of the rate : Active/InActive |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| GradeLadderId | Long | GradeLadderId |
| SysEffectiveDate | Date | SysEffectiveDate |
| Finder | String | finder |