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

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。