GradeLaddersgrades

Columns


Name	Type	Description
GradeLaddersEffectiveEndDate [KEY]	Date	GradeLaddersEffectiveEndDate of GradeLaddersgrades
GradeLaddersEffectiveStartDate [KEY]	Date	GradeLaddersEffectiveStartDate of GradeLaddersgrades
GradeLaddersGradeLadderId [KEY]	Long	GradeLaddersGradeLadderId of GradeLaddersgrades
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	Foreign Key to PER_GRADES_F table.
GradesInLadderSequence	Long	Indicates the sequence of the grades within the grade ladder.

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