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
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
GradeLadderId | Long | GradeLadderId |
SysEffectiveDate | Date | SysEffectiveDate |
Finder | String | finder |