PositionsvalidGrades

Columns


Name	Type	Description
PositionsEffectiveEndDate [KEY]	Date	PositionsEffectiveEndDate of PositionsvalidGrades
PositionsEffectiveStartDate [KEY]	Date	PositionsEffectiveStartDate of PositionsvalidGrades
PositionsPositionId [KEY]	Long	PositionsPositionId of PositionsvalidGrades
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.

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