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