GradeRates
GradeRates
Columns
| Name | Type | Description |
| 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. |
| RateType | String | Stores rate type, whether it's Salary/Bonus/Overtime. Gets values from look up : GRADE_PAY_RATE_TYPE |
| GradeRateName | String | Denoted the name for Rate. |
| 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 |
| ActionReasonCode | String | The user defined Code for the Action Reason |
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 |
| SysEffectiveDate | Date | SysEffectiveDate |
| Finder | String | finder |
| PGradeCode | String | pGradeCode |
| PGradeId | Long | pGradeId |
| PGradeSetCode | String | pGradeSetCode |
| PLegislativeDataGroup | String | pLegislativeDataGroup |
| PLegislativeDataGroupId | Long | pLegislativeDataGroupId |