GradeRatesrateValues

Columns


Name	Type	Description
GradeRatesEffectiveEndDate [KEY]	Date	GradeRatesEffectiveEndDate of GradeRatesrateValues
GradeRatesEffectiveStartDate [KEY]	Date	GradeRatesEffectiveStartDate of GradeRatesrateValues
GradeRatesRateId [KEY]	Long	GradeRatesRateId of GradeRatesrateValues
RateValueId [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.
GradeId	Long	GradeId of GradeRatesrateValues
MinimumAmount	Double	Represents the minimum currency value of a grade in a grade rate.
MaximumAmount	Double	Represents the maximum currency value of a grade in a grade rate.
MidValueAmount	Double	Represents the average of minimum rate and maximum rate values of grade.
ValueAmount	Double	Numeric that represents value of grade in a grade rate

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